datestyle in postgresql.conf, version 7.4

I want to have the date in french format for my postgres 7.4 database.
reading the documentation, three ways to get it.
1. set datestyle to 'postgres,european'; for each session, it works OK
2. old style export
PGDATESTYLE='Postgres,European';/usr/local/pgsql/bin/pg_ctl -D
/home/local/BasePostgres/ -l logfile -o -i start it works OK
3. datestyle="Postgres, European" in the postgresql.conf file, but
unfortunately it does nor work

what's wrong?

--
Jean-Max Reymond email: jmreymond@free.fr tel: 33 (0)6 16 94 25 11
http://jmreymond.free.fr/Etna2002


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

re: datestyle in postgresql.conf, version 7.4

Jean-Max Reymond <jmreymond@free.fr> writes:[color=blue]
> 3. datestyle="Postgres, European" in the postgresql.conf file, but
> unfortunately it does nor work[/color]

I think you need single quotes in that file. Try

datestyle='Postgres, European'

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

re: datestyle in postgresql.conf, version 7.4

Tom Lane wrote:
[color=blue]
>Jean-Max Reymond <jmreymond@free.fr> writes:
>
>[color=green]
>>3. datestyle="Postgres, European" in the postgresql.conf file, but
>>unfortunately it does nor work
>>
>>[/color]
>
>I think you need single quotes in that file. Try
>
>datestyle='Postgres, European'
>
>
>[/color]
sorry, but it does not work with simple or double quotes :-(


--
Jean-Max Reymond email: jmreymond@free.fr tel: 33 (0)6 16 94 25 11
http://jmreymond.free.fr/Etna2002


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

re: datestyle in postgresql.conf, version 7.4

Jean-Max Reymond <jmreymond@free.fr> writes:[color=blue]
> Tom Lane wrote:[color=green]
>> I think you need single quotes in that file. Try
>> datestyle='Postgres, European'
>>[/color]
> sorry, but it does not work with simple or double quotes :-([/color]

Works for me (with single quotes). Did you remember to SIGHUP the
postmaster (eg with "pg_ctl reload") after editing the config file?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

re: datestyle in postgresql.conf, version 7.4

Tom Lane wrote:
[color=blue]
>Jean-Max Reymond <jmreymond@free.fr> writes:
>
>[color=green]
>>Tom Lane wrote:
>>
>>[color=darkred]
>>>I think you need single quotes in that file. Try
>>>datestyle='Postgres, European'
>>>
>>>
>>>[/color]
>>sorry, but it does not work with simple or double quotes :-(
>>
>>[/color]
>
>Works for me (with single quotes). Did you remember to SIGHUP the
>postmaster (eg with "pg_ctl reload") after editing the config file?
>
> regards, tom lane
>
>
>
>[/color]
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 = (

datestyle='Postgres, European'
and
datestyle = 'Postgres, European'

but not successfull

--
Jean-Max Reymond email: jmreymond@free.fr tel: 33 (0)6 16 94 25 11
http://jmreymond.free.fr/Etna2002


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

re: datestyle in postgresql.conf, version 7.4

Oliver Elphick wrote:
[color=blue]
>On Wed, 2003-12-10 at 23:01, Jean-Max Reymond wrote:
>
>[color=green]
>>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 = (
>>
>>datestyle='Postgres, European'
>>and
>>datestyle = 'Postgres, European'
>>
>>but not successfull
>>
>>[/color]
>
>Are you editing the right postgresql.conf file? It should be in
>$PGDATA.
>
>
>[/color]
Oups, you're right. I'am very confused. I have two repositories (one for
7.3 and one for 7.4) and it was not the good one!!!
thanks a lot. NOw, it works like a charm


--
Jean-Max Reymond email: jmreymond@free.fr tel: 33 (0)6 16 94 25 11
http://jmreymond.free.fr/Etna2002


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org