Jonathan Guthrie wrote: > When I create a project, entries in the project table and the resource > table are created in a single function. Then, separate functions are > called to set the owner's access to the new project. These other > functions are failing because of the resourceid foreign key constraint.
Have you turned statement logging on? Your message suggests that's the case, but didn't say so explicitly. Are the two steps: 1. Create project, resource 2. Set access-rights done in separate connections by any chance? If so it's possible (due to MVCC) that #2 is still seeing the database as it was before #1 committed. > Anyway, I need for these operations to succeed because the lack of > permissions causes odd problems in other parts of the system. If you want both steps to succeed or fail together though, they need to be in the same transaction. -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
