From: Jason Earl <jdearl@yahoo.com>
To: pgsql-sql@postgresql.org, Web Manager <web@inter-resa.com>
Subject: Re: US Date Style
Date: Thu, 20 Apr 2000 11:12:28 -0700 (PDT)
Message-ID: <20000420181228.10173.qmail@web120.yahoomail.com> (raw)
Thanks to <web Manager> and the PostgreSQL docs I have
found out what I was doing wrong. Actually the fix
was so dead simple that I am more than a little
embarrased to share.
But here goes...
The Debian package of PostgreSQL has a nifty
configuration file /etc/postgresql/postmaster.init .
Basically this file let's you customize just about any
PostgreSQL parameter that is configurable at run time
and worth fiddling with. I read the config file and
decided that setting:
PGDATESTYLE=US
Should do what I needed. Unfortunately what I
actually wanted was:
PGDATESTYLE=POSTGRES
Thanks to web@inter-resa.com, and special thanks to
the PostgreSQL team for their continued efforts.
7.0 Rocks,
Jason Earl
--- Jason Earl <jdearl@yahoo.com> wrote:
> With a little bit of grepping through the docs I
> have
> found something that will mostly work for me. I
> simply need to have each client issue a:
>
> SET DATESTYLE TO 'Postgres';
>
> This works just fine, but (of course) I would rather
> have this set up as the 'default.' Does anyone know
> how to do this?
>
> Thanks again,
> Jason
>
> --- Jason Earl <jdearl@yahoo.com> wrote:
> > Note: I sent this to the pgsql-general list from
> > another account
> > yesterday, but it hasn't been answered. My
> > apologies
> > if you see it
> > twice. On the other hand, I have taken some time
> to
> > proofread a bit,
> > so perhaps the punctuation won't be quite as bad.
> >
> > I recently upgraded the PostgreSQL database on one
> > of
> > my Debian Linux
> > boxes to postgresql-7.0-0.beta3-1 in preparation
> for
> > the grand
> > switchover to version 7.0. So far I am quite
> > impressed, but I have
> > had a little bit of a problem setting the
> > PGDATESTYLE
> > correctly. For
> > historical reasons I would like to continue using
> > the
> > US datestyle
> > (eg. Sat Jan 01 07:09:19 2000 MDT).
> >
> > I have tried setting the variable in
> > /etc/postgresql/postmaster.init
> > and no joy. I have also tried to set the value of
> > PGDATESTYLE
> > manually in psql using:
> >
> > processdata=>\set PGDATESTYLE US
> >
> > When I do this I am able to then check the
> variables
> > that are set and
> > I get:
> >
> > processdata=> \set
> > VERSION = 'PostgreSQL 7.0.0 on i686-pc-linux-gnu,
> > compiled by gcc 2.95.2'
> > DBNAME = 'processdata'
> > USER = 'earlj'
> > HOST = 'nampadata'
> > PORT = '5432'
> > ENCODING = 'SQL_ASCII'
> > PROMPT1 = '%/%R%# '
> > PROMPT2 = '%/%R%# '
> > PROMPT3 = '>> '
> > HISTSIZE = '500'
> > PGDATESTYLE = 'US'
> >
> > Unfortunately, when I test it out:
> >
> > processdata=> select 'now'::datetime;
> > ?column?
> > ------------------------
> > 2000-04-19 14:09:06-06
> > (1 row)
> >
> > I still get the ISO format. So what do I need to
> do
> > to get my US
> > datestyle back?
> >
> > Sorry to bother,
> > Jason Earl
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Send online invitations with Yahoo! Invites.
> > http://invites.yahoo.com
> >
>
> __________________________________________________
> Do You Yahoo!?
> Send online invitations with Yahoo! Invites.
> http://invites.yahoo.com
>
__________________________________________________
Do You Yahoo!?
Send online invitations with Yahoo! Invites.
http://invites.yahoo.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: jdearl@yahoo.com, web@inter-resa.com
Subject: Re: US Date Style
In-Reply-To: <20000420181228.10173.qmail@web120.yahoomail.com>
References: <20000420181228.10173.qmail@web120.yahoomail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox