1 Reply Latest reply on Dec 28, 2005 9:45 AM by gavin.king

    PostgreSQL and schema update error

    armita

      Trying to run SEAM example on the PostgreSQL 8.0 I got this error messages

      15:44:49,371 ERROR [SchemaUpdate] Unsuccessful: create table User (username varchar(255) not null, name varchar(100) not null, password varchar(15) not null, primary key (username))
      15:44:49,372 ERROR [SchemaUpdate] ERROR: syntax error at or near "User"
      15:44:49,522 ERROR [SchemaUpdate] Unsuccessful: alter table Booking add constraint FK6713A0396E4A3BD foreign key (user_username) references User
      15:44:49,522 ERROR [SchemaUpdate] ERROR: syntax error at or near "User"

      I think the problem is that User is a reserved word in postgresql.
      How could it be solved?

      Thanks