[Devel] postgres tables example

[Klaus Darilion]

What about changing the existing mysqldb.sh to also support postgres?

I've already started, but having some problems with different syntax 
between mysql and postgres, e.g.

datetime      --?-->  TIMESTAMP WITHOUT TIME ZONE
timestamp(14) --?-->  TIMESTAMP

also the default value must be changed as postgresql accepts only 
correct formats:

time datetime NOT NULL default '0000-00-00 00:00:00'
--?--> '2000-01-01 00:00:01'

indexes should be no problem when defined after creating the table - 
this works also with mysql

Thus, we only need a new name for the file :-)

I think updating serctl to support also postgres should be easy. The 
only problem is that psql does not support the password as a command 
line parameter. But >=7.3 supports storing the password in a ~/.pgpass 
file. In think we can require having this file for postgres users.

Comments?

regards,
klaus


Daniel-Constantin Mierla wrote:
> Hello,
> 
> could you write a pgsqldb.sh similar to mysqldb.sh? You can eventually 
> extract the common parts in another file and have only the differences 
> in separate files. We can grant you cvs write access if you want to do 
> it and maintain the scripts -- just make an account on sourceforge.net 
> and let us know your id.
> 
> cheers,
> Daniel
> 
> On 06/28/05 01:29, Ingo Wolfsberger wrote:
> 
>> Hi
>>
>> I have attached "sample" tables for the postgres module.
>> The most important tables are in it.
>>
>> bye,
>>   Ingo
>>
>>  
>>
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> Devel mailing list
>> Devel at openser.org
>> http://openser.org/cgi-bin/mailman/listinfo/devel
>>  
>>
> 
> _______________________________________________
> Devel mailing list
> Devel at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/devel
> 
>