Received: from desertmoon.com (qmailr@desertmoon.com [198.182.124.2]) by hub.org (8.9.1/8.9.1) with SMTP id UAA26204 for ; Mon, 30 Nov 1998 20:18:40 -0500 (EST) (envelope-from pierre@desertmoon.com) From: pierre@desertmoon.com Received: (qmail 17489 invoked by uid 100); 1 Dec 1998 01:22:47 -0000 Message-ID: <19981201012247.17488.qmail@desertmoon.com> Date: 30 Nov 1998 18:22:47 -0700 Subject: Re: [SQL] changed SQL in 6.4? To: sas@schell.de (Sascha Schumann) Date: Mon, 30 Nov 1998 18:22:47 -3100 (MST) Cc: pgsql-sql@hub.org In-Reply-To: from "Sascha Schumann" at Dec 1, 98 00:00:44 am X-Mailer: ELM [version 2.4 PL25] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit > > Hi list, > > I've dumped my databases, but 6.4 doesn't like the code produced by > 6.3.2's pg_dump. > > CREATE TABLE user (username varchar(128), realname varchar(128), password > varchar(128), allow int4, id int4); > ERROR: parser: parse error at or near "user" > I found the same thing in my conversion process. The keyword user is reserved....change your table name to users and it will work, however you'll need to change all references to the table user to users as well. -=pierre > Exact the same statement works perfectly with 6.3.2. It also doesn't like > INSERTing in tables named user. Is user a reserved name? > > Regards, > > Sascha Schumann | > Consultant | finger sas@schell.de > | for PGP public key > > >