RE: 7.1 pg_dump fails for user-defined types (release stopper?)

Поиск
Список
Период
Сортировка
От Darren King
Тема RE: 7.1 pg_dump fails for user-defined types (release stopper?)
Дата
Msg-id NDBBJNEIGLIPLCHCMANLKELFCLAA.darrenk@insightdist.com
обсуждение исходный текст
Ответ на 7.1 pg_dump fails for user-defined types (release stopper?)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Mikheev, Vadim"
Дата:
Сообщение: RE: 7.1 pg_dump fails for user-defined types (release s topper?)
Следующее
От: Mike Mascari
Дата:
Сообщение: RE: 7.1 pg_dump fails for user-defined types (release stopper?)