Get constrrelid for fk constraints that lost it
От
Stephan Szabo
Тема
Get constrrelid for fk constraints that lost it
Дата
Msg-id
20020929213738.N75495-200000@megazone23.bigpanda.com
Список
Дерево обсуждения
Get constrrelid for fk constraints that lost it Stephan Szabo <sszabo@megazone23.bigpanda.com>
Re: Get constrrelid for fk constraints that lost it Tom Lane <tgl@sss.pgh.pa.us>
Re: Get constrrelid for fk constraints that lost it Stephan Szabo <sszabo@megazone23.bigpanda.com>
Re: Get constrrelid for fk constraints that lost it Tom Lane <tgl@sss.pgh.pa.us>
Re: Get constrrelid for fk constraints that lost it Tom Lane <tgl@sss.pgh.pa.us>
Re: Get constrrelid for fk constraints that lost it Stephan Szabo <sszabo@megazone23.bigpanda.com>
I believe this should allow create constraint trigger to look up the constrrelid out of the fk constraint arguments for those cases where the FROM clause was lost if we want to go that route. It determines if it should look up args and which argument to use based on the function name and won't probably handle delimited names nicely. I figured that since the point of it is to read old dumps, this is okay. If the table doesn't exist or there aren't enough args to intuit a table name, it currently elog errors. Is that reasonable behavior, or should it be taking the constraint and letting it fail at runtime?
В списке pgsql-patches по дате отправления
От: Zeugswetter Andreas SB SD
Дата: