The mailing list for listmasters using Sympa

[Olivier Salaun - CRU <address@concealed>]

> > C. Clasohm : 
> > > I am currently installing Sympa 2.2.7 on one of our Linux servers and
> > > noticed a conflict with PostgreSQL. Beginning with version 6.5, "user" 
> > > is a reserved keyword and may not be used for table names. Renaming the
> > > table to "users" will fix this problem.

> O. Salaun :
> > USER now seems to be a synonym for CURRENT_USER. In which way could Pg
> > mistake this variable with a table name ? 

C. Clasohm : 
> When one tries to create a table named "user" with Pg 6.5, this happens:
> 
> => create table user (x int);
> ERROR:  parser: parse error at or near "user"

Table name "user" will be changed to "users" in next release.
This will involve :

        1/ changing a bit of perl code
        2/ Renaming tables in your existing databases

Olivier Salaun