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 View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3914554#3914554 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3914554 ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click _______________________________________________ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
