Thread: psql: FATAL: invalid value for parameter "datestyle": "SQL US"

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

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