pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
psql: FATAL:  invalid value for parameter "datestyle": "SQL US"
2+ messages / 2 participants
[nested] [flat]

* psql: FATAL:  invalid value for parameter "datestyle": "SQL US"
@ 2005-03-15 15:40 Christopher Smiga <csmiga@tandbergtv.com>
  2005-03-21 03:00 ` Re: psql: FATAL: invalid value for parameter "datestyle": "SQL US" Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 2+ messages in thread

From: Christopher Smiga @ 2005-03-15 15:40 UTC (permalink / raw)
  To: pgsql-admin

I'm working through the Oreilly "Practical PostgreSQL" book and I 
implemented "booktown.sql" to work examples in the book. Anyway, in 
chapter 3, I performed something that causes the following FATAL ERROR 
when trying to get back into "psql"

postgres@n2-atl-csmiga:~$ psql booktown
psql: FATAL:  invalid value for parameter "datestyle": "SQL US"

Does anyone have an idea to how I can correct this problem? I'm running 
PostgreSQL 7.4

Thank you.


-- 
Christopher Smiga
QA Software Test Engineer

TANDBERG Television
e-Mail: csmiga@tandbergtv.com
-----
TANDBERG Television (www.tandbergtv.com)
4500 River Green Parkway, Suite 110
Duluth, GA. 30096-2564




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: psql: FATAL: invalid value for parameter "datestyle": "SQL US"
  2005-03-15 15:40 psql: FATAL:  invalid value for parameter "datestyle": "SQL US" Christopher Smiga <csmiga@tandbergtv.com>
@ 2005-03-21 03:00 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2005-03-21 03:00 UTC (permalink / raw)
  To: Christopher Smiga <csmiga@tandbergtv.com>; +Cc: pgsql-admin

Christopher Smiga <csmiga@tandbergtv.com> writes:
> ... I performed something that causes the following FATAL ERROR 
> when trying to get back into "psql"

> postgres@n2-atl-csmiga:~$ psql booktown
> psql: FATAL:  invalid value for parameter "datestyle": "SQL US"

> Does anyone have an idea to how I can correct this problem?

"unset PGDATESTYLE", likely ...

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-03-21 03:00 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-03-15 15:40 psql: FATAL:  invalid value for parameter "datestyle": "SQL US" Christopher Smiga <csmiga@tandbergtv.com>
2005-03-21 03:00 ` Re: psql: FATAL: invalid value for parameter "datestyle": "SQL US" Tom Lane <tgl@sss.pgh.pa.us>

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