Re: [GENERAL] datestyle in postgresql.conf, version 7.4

2003-12-11 Thread Jean-Max Reymond
Oliver Elphick wrote: On Wed, 2003-12-10 at 23:01, Jean-Max Reymond wrote: I stop the postmaster (/usr/local/pgsql/bin/pg_ctl stop) and restart the postmaster (/usr/local/pgsql/bin/pg_ctl -D /home/local/BasePostgres/ -l logfile -o -i start). I have tried with and without blanks near = ( da

Re: [GENERAL] datestyle in postgresql.conf, version 7.4

2003-12-10 Thread Jean-Max Reymond
Tom Lane wrote: Jean-Max Reymond <[EMAIL PROTECTED]> writes: Tom Lane wrote: I think you need single quotes in that file. Try datestyle='Postgres, European' sorry, but it does not work with simple or double quotes :-( Works for me (with single quotes). Did you remember to SIG

Re: [GENERAL] datestyle in postgresql.conf, version 7.4

2003-12-10 Thread Tom Lane
Jean-Max Reymond <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> I think you need single quotes in that file. Try >> datestyle='Postgres, European' >> > sorry, but it does not work with simple or double quotes :-( Works for me (with single quotes). Did you remember to SIGHUP the postmaster (eg

Re: [GENERAL] datestyle in postgresql.conf, version 7.4

2003-12-10 Thread Jean-Max Reymond
Tom Lane wrote: Jean-Max Reymond <[EMAIL PROTECTED]> writes: 3. datestyle="Postgres, European" in the postgresql.conf file, but unfortunately it does nor work I think you need single quotes in that file. Try datestyle='Postgres, European' sorry, but it does not work with simple or d

Re: [GENERAL] datestyle in postgresql.conf, version 7.4

2003-12-10 Thread Tom Lane
Jean-Max Reymond <[EMAIL PROTECTED]> writes: > 3. datestyle="Postgres, European" in the postgresql.conf file, but > unfortunately it does nor work I think you need single quotes in that file. Try datestyle='Postgres, European' regards, tom lane