Displaying 1 result from an estimated 1 matches for "hotels_pkey".
2005 Jun 16
3
PostgreSQL Scaffold Doesn't Insert PK?
...am porting an
existing Web app.
I am running the latest release on Tiger and PG8.
Right now my single table has three attributes:
id | integer | not null
hotel_name | character varying(255) | not null
hotel_location | character varying(255) | not null
"hotels_pkey" PRIMARY KEY, btree (id)
When I use the generated insert form, it sends this SQL:
INSERT INTO hotels ("hotel_location", "hotel_name") VALUES(''Strip'',
''Bellagio'')
Of course there is no PK there so the query fails and an exception is
rai...