Re: set datestyle to European PROBLEM

Alessandro Rossi wrote:

> I have the defaul installation of postgres 7.0.3 and on another machine
> 7.1.2 on redhat 7.1
>
> I cannont get the date in correct form:

.....

> Is this a bug ?
>
> I think i should get dd-mm-yyy date format and not yyyy-mm-dd
>
> Is postgres using ISO date format as default ?

I had the same problem ... but I solved ...
(I use PostgreSQL 7.1 on RH 7.1 installed from rpm):

In "/etc/rc.d/init.d/postgresql" I modify in "start" arm ... from:
su -l postgres -c "LC_ALL=C /usr/bin/pg_ctl -D $PGDATA -p
/usr/bin/postmaster start >/dev/null 2>&1" < /dev/null

to

su -l postgres -c "LC_ALL=C /usr/bin/pg_ctl -D $PGDATA -o '-i -o -e' -p
/usr/bin/postmaster start >/dev/null 2>&1" < /dev/null

and, after I connect my application to the database, the first command is:

SET DATESTYLE TO 'Postgres';

and work fine ...

> Thanks

> Alex

George Moga,
Data Systems Srl,
Slobozia, ROMANIA