pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
changed SQL in 6.4?
2+ messages / 2 participants
[nested] [flat]

* changed SQL in 6.4?
@ 1998-11-30 23:00  Sascha Schumann <sas@schell.de>
  0 siblings, 1 reply; 2+ messages in thread

From: Sascha Schumann @ 1998-11-30 23:00 UTC (permalink / raw)
  To: pgsql-sql@hub.org

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"

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




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

* Re: [SQL] changed SQL in 6.4?
@ 1998-12-01 01:22  pierre@desertmoon.com
  parent: Sascha Schumann <sas@schell.de>
  0 siblings, 0 replies; 2+ messages in thread

From: pierre@desertmoon.com @ 1998-12-01 01:22 UTC (permalink / raw)
  To: sas@schell.de; +Cc: pgsql-sql@hub.org

> 
> 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
> 
> 
> 




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


end of thread, other threads:[~1998-12-01 01:22 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-11-30 23:00 changed SQL in 6.4? Sascha Schumann <sas@schell.de>
1998-12-01 01:22 ` pierre@desertmoon.com

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