Re: RI triggers and schemas
От | Tom Lane |
---|---|
Тема | Re: RI triggers and schemas |
Дата | |
Msg-id | 5310.1017681554@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | Re: RI triggers and schemas (Stephan Szabo <sszabo@megazone23.bigpanda.com>) |
Ответы |
Re: RI triggers and schemas
|
Список | pgsql-hackers |
Stephan Szabo <sszabo@megazone23.bigpanda.com> writes: > Well, there is another place where the current name behavior > causes problems so we'd need to be sticking in the fully qualified > name, otherwise creating a table in your search path earlier than > the intended table would break the constraint. This currently already > happens with temp tables. But the point is that the table name would be resolved to OID once at CREATE TRIGGER time (or when the original FK constraint is created). After that, it's up to the trigger to construct queries using the fully-qualified table name. This should eliminate the temp table gotcha as well as change-of-search-path issues. regards, tom lane
В списке pgsql-hackers по дате отправления: