Odd error with FK referencing another FK column? (was Re: [GENERAL] java.sql.SQLException: ERROR: Relation 38868974 does not exist)

2004-12-16 Thread Richard Huxton
Alain M. Gaudrault wrote: We had a foreign key which was referencing a column in table which itself was a foreign key (something that was new to our system). We've made mods to prevent the two levels of foreign keys, and so far, so good. Not sure how this would explain the behaviour we were se

[GENERAL] java.sql.SQLException: ERROR: Relation 38868974 does not exist

2004-12-14 Thread Alain M. Gaudrault
I've come across a problem which is only happening intermittently, and having a difficult time finding information to help me determine what is the source of my frustration. The symptom is the error reported in the subject. We invoke SQL statements from a Java servlet via pg74jdbc3.jar. The r