[Devel] postgres tables example

[Daniel-Constantin Mierla]

Hello,

On 06/30/05 15:59, Cesc wrote:

>Hi,
>
>Now that you mention updating serctl to support postgres ... i added,
>quite some time ago, support for dbtext to serctl. I know ... dbtext
>is not so used, but the few of us who use, find it very comfortable ;)
>
>In ser it did not seem to be welcome ... maybe openser is more interested ... 
>  
>
is it a separate file? Could you send the file or patch again? It will 
be added in a way or other.

Cheers,
Daniel

>Regards,
>
>Cesc
>
>On 6/30/05, Klaus Darilion <klaus.mailinglists at pernau.at> wrote:
>  
>
>>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
>>>
>>>
>>>      
>>>
>>_______________________________________________
>>Devel mailing list
>>Devel at openser.org
>>http://openser.org/cgi-bin/mailman/listinfo/devel
>>
>>    
>>
>
>  
>