[SQL] Foreign key pg_dump issue and serial column type

2005-06-29 Thread Vsevolod (Simon) Ilyushchenko
Hi, As a relative newbie to postgres, I've run into to weirdisms that I don't quite know how to handle: 1. I have a many-to-many table 'people_roles' containing fields 'person_code' and 'role_code'. It links tables 'people' and 'roles'. There are foreign key constraints: ALTER TABLE PEOPLE

[SQL] cursor "" does not exist

2005-06-15 Thread Vsevolod (Simon) Ilyushchenko
Hi, I'm querying a Postgres 8.0.3 database from Java via the 8.0-311 JDBC driver. It mostly works. I ran into the "cursor does not exist" problem, but was able to fix it with connection.setAutoCommit(false); Or so I thought. There are several JSP pages which still throw the 'cursor "portal 1