Robert Haas <robertmh...@gmail.com> writes: > 2010/1/3 KaiGai Kohei <kai...@ak.jp.nec.com>: >> if (number_of_attribute_origin(myrelid, oldattname) > 1) >> ereport(ERROR, ...); >> >> Am I missing something?
> That sounds about right to me, It looks remarkably inefficient to me. Do you propose to search the entire database's inheritance tree to derive that number? And do it over again at each child table? The method I suggested would allow the necessary information to be extracted during the initial search for child tables, which we have to do anyway. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers