[Devel] postgres tables example

[Cesc]

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 ... 

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
>