Обсуждение: [HACKERS] [BUGS] DateStyle (fwd)
Has this been fixed yet. Probably should. Do we remove -e flag, or make it work? Forwarded message: > From owner-pgsql-bugs@hub.org Fri Jun 13 12:01:01 1997 > Message-Id: <199706131545.RAA03568@mailsvr.pt.lu> > From: "Dorte Munk-Jakobsen" <munk@pt.lu> > To: <pgsql-bugs@postgreSQL.org> > Subject: [BUGS] DateStyle > Date: Fri, 13 Jun 1997 17:48:08 +0200 > X-MSMail-Priority: Normal > X-Priority: 3 > X-Mailer: Microsoft Internet Mail 4.70.1161 > MIME-Version: 1.0 > Content-Type: text/plain; charset=ISO-8859-1 > Content-Transfer-Encoding: 7bit > Sender: owner-bugs@hub.org > Precedence: bulk > > Your name : Dorte Munk-Jakobsen > Your email address : munk@pt.lu > > > System Configuration > --------------------- > Architecture (example: Intel Pentium) : Intel 486 > > Operating System (example: Linux 2.0.26 ELF) : Linux 2.0.27 (REDHAT 4.1) > > PostgreSQL version (example: PostgreSQL-6.1) : PostgreSQL-6.1 970611 > > Compiler used (example: gcc 2.7.2) : gcc 2.7.2.1 > > > Please enter a FULL description of your problem: > ------------------------------------------------ > set DateStyle to 'European' does not have any effect. > It used to work well with the -e option to postmaster in version 6.0 > > Please describe a way to repeat the problem. Please try to provide a > concise reproducible example, if at all possible: > ---------------------------------------------------------------------- > > > If you know how this problem might be fixed, list the solution below: > --------------------------------------------------------------------- > > > -------- > Tommy & Dorte Munk-Jakobsen | > munk@pt.lu | Mainly Dorte > tommy.munk@metrix.lu | Only Tommy > Voice: +352 81 15 66 +352 816 506 | > Fax +352 816 821 > > - -- Bruce Momjian maillist@candle.pha.pa.us ------------------------------ End of hackers-digest V1 #397 *****************************
Bruce Momjian wrote: > > Has this been fixed yet. Probably should. > > Do we remove -e flag, or make it work? > it works for me. Edmund - -- +-------------------+---------------------+ | Edmund Mergl | E.Mergl@bawue.de | | Im Haldenhau 9 | fon: +49=711-747503 | | D 70565 Stuttgart | | |-------------------+---------------------| | http://www.bawue.de/~mergl/ | +-----------------------------------------+ ------------------------------
> > 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.
- Tom
------------------------------
> > > > 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 ------------------------------
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 +---------+
+---------------------------------------+
------------------------------