Stephan, Thanks for the info. This dataset started life off with 6.4
and has been dumped and restored many times over the last 4 years.
One of the things i'm looking forward to is more managable foreign keys
in 7.3 and I am currently writing a conversion script to drop the old
keys and recreate them using the 7.3 syntax.
On Thu, 2002-10-24 at 09:36, Stephan Szabo wrote:
> 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
--
Brian Hirt <bhirt@mobygames.com>