X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 78AD95643C for ; Tue, 15 Mar 2005 15:40:37 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 79642-02 for ; Tue, 15 Mar 2005 15:40:34 +0000 (GMT) Received: from mail2.tandbergtv.com (mail2.tandbergtv.com [66.0.13.30]) by svr1.postgresql.org (Postfix) with ESMTP id C7079561ED for ; Tue, 15 Mar 2005 15:40:32 +0000 (GMT) Received: from mail2.tandbergtv.com ([10.250.0.85]) by mail2.tandbergtv.com with Microsoft SMTPSVC(6.0.3790.211); Tue, 15 Mar 2005 10:40:30 -0500 Received: from [192.168.0.74] ([192.168.0.74]) by mail2.tandbergtv.com with Microsoft SMTPSVC(6.0.3790.211); Tue, 15 Mar 2005 10:40:28 -0500 Message-ID: <423701EF.7060702@tandbergtv.com> Date: Tue, 15 Mar 2005 10:40:31 -0500 From: Christopher Smiga Organization: TANDBERG Television User-Agent: Debian Thunderbird 1.0 (X11/20050116) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: psql: FATAL: invalid value for parameter "datestyle": "SQL US" X-Enigmail-Version: 0.90.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 15 Mar 2005 15:40:28.0220 (UTC) FILETIME=[50214FC0:01C52975] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200503/313 X-Sequence-Number: 16811 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