pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (8+ messages)  latest in thread

Message-ID: <20000420181228.10173.qmail@web120.yahoomail.com>
Permalink:  ../20000420181228.10173.qmail@web120.yahoomail.com/
Also on:    postgresql.org/message-id/20000420181228.10173.qmail@web120.yahoomail.com

 · 

reply

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