RE: 7.1 pg_dump fails for user-defined types (release stopper?) - Mailing list pgsql-hackers

From Darren King
Subject RE: 7.1 pg_dump fails for user-defined types (release stopper?)
Date
Msg-id NDBBJNEIGLIPLCHCMANLKELFCLAA.darrenk@insightdist.com
Whole thread Raw
In response to 7.1 pg_dump fails for user-defined types (release stopper?)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> A more promising idea is to hack function creation
> so that the OID assigned to the function is lower
> than the OIDs assigned to any shell types created
> when the function is defined.  Or we could try to
> hack pg_dump to fix this, but that doesn't seem
> appetizing.

Requiring OID ordering would open up a new can of worms.

What happens if the user does a drop/create on the function after
creating it?

The function could potentially be recreated with a higher OID and then
the user would be in the same situation.

If the system requires (or works around) creation ordering when creating
functions and types, ISTM that pg_dump should have to do the same.

darrenk



pgsql-hackers by date:

Previous
From: "Mikheev, Vadim"
Date:
Subject: RE: 7.1 pg_dump fails for user-defined types (release s topper?)
Next
From: Mike Mascari
Date:
Subject: RE: 7.1 pg_dump fails for user-defined types (release stopper?)