Re: 7.3b2 strangeness

On 24 Oct 2002, Brian Hirt wrote:

> Hi, i recently installed 7.3b2 on my machine to start looking at the
> changes and to make sure my code works with the new system in
> anticipation of 7.3. I dumped my 7.2 database and reloaded in into
> 7.3. The dump and resore went fine, and most everything seems to work
> great. I did run into a strange thing, where I cannot update one of my
> tables. I get "Relation 0 does not exist" Does anyone have any ideas
> why this would be happing?

Has this dataset been dumped and restored in the past? This looks like
the symptom from having had an older pg_dump drop a piece of the foreign
key information. Current sources should actually work for this case,
but if you want you can set tgconstrrelid manually for the affected
pg_trigger rows or drop the triggers and re-add the foreign key
constraints. The information was somewhat optional in the past but
became used in 7.3