Re: [HACKERS] [BUGS] DateStyle (fwd) - Mailing list pgsql-hackers

From Gerhard Reithofer
Subject Re: [HACKERS] [BUGS] DateStyle (fwd)
Date
Msg-id 609fa7fe90c5dc744904815a80f664a4
Whole thread Raw
In response to [HACKERS] [BUGS] DateStyle (fwd)  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-hackers
On Wed, 25 Jun 1997, Bruce Momjian wrote:

> >
> > > > set DateStyle to 'European' does not have any effect.
> > > > It used to work well with the -e option to postmaster in version 6.0
> > > Has this been fixed yet.  Probably should.
> >
> > Fixed in the source tree a couple of days ago. Had apparently broken
> > with some changes for the geqo options. I will commit some tests for
> > these commands in the regression suite in the next few days.
> >
> > Workaround is to type
> >
> >   SET DateStyle TO 'European,';
> >
> > (note extra comma).
> >
> > > Do we remove -e flag, or make it work?
> >
> > Don't know if the "-e" flag is still present.
>
> It is still there.  Someone reported that it works, but I have not
> tested it myself.
>
> Would you check it out?
>
> --
> Bruce Momjian
> maillist@candle.pha.pa.us

Hi to all hackers,
the "-e" option is definitely present in V6.1.

============= Part of my start up script ============
PG_BINDIR=/usr/local/pgsql/bin
STARTUP_OPTIONS="-b $PG_BINDIR/postgres -o -e"
cd $PG_BINDIR
nohup postmaster $STARTUP_OPTIONS 2>>$ERRORLOG &
====================================================

gerhardr@aix_530:/home/postgres/bin > psql -d template1
Welcome to the POSTGRESQL interactive sql monitor:
  Please read the file COPYRIGHT for copyright terms of POSTGRESQL

   type \? for help on slash commands
   type \q to quit
   type \g or terminate with semicolon to execute query
 You are currently connected to the database: template1

template1=> show datestyle ;
NOTICE:DateStyle is Postgres with European conventions
SHOW VARIABLE
template1=>

............................................................
Cheers
    Gerhard

+------------------+             +--- gerhardr@tech-edv.co.at ----+
| T.B.Reithofer     \ Gerhard    | Technical Sofware Developement |
| Staatsbahnstr. 100 \ Reithofer | CAD/CAM/CAE/CAQ/CAP +----------+
| A-2136 Laa/Thaya    +----------+ Mechanical CAD +----+
| Tel +43-2522/8726, Fax +43-2522/87268 +---------+
+---------------------------------------+

------------------------------

pgsql-hackers by date:

Previous
From: Frank Dana
Date:
Subject: Re: [HACKERS] Problem with copying abstimes
Next
From: "Gabriele, Mitarbeiterin EDV/IT"
Date:
Subject: [none]