Re: [HACKERS] proper way to fix information_schema.key_column_usage view

2007-08-12 Thread Peter Eisentraut
April Lorenzen wrote: > I had to feel my way carrying out this fix, and I don't know if I did > it right - I only know that it appears I no longer have the error. > Please confirm whether I was supposed to execute all of > share/information_schema.sql --- or just the portion that CREATEs or > REPLA

Re: [HACKERS] proper way to fix information_schema.key_column_usage view

2007-08-11 Thread Tom Lane
"April Lorenzen" <[EMAIL PROTECTED]> writes: > I had to feel my way carrying out this fix, and I don't know if I did > it right - I only know that it appears I no longer have the error. > Please confirm whether I was supposed to execute all of > share/information_schema.sql --- or just the portion

[HACKERS] proper way to fix information_schema.key_column_usage view

2007-08-11 Thread April Lorenzen
Tom Lane commits (http://www.postgresql.org/community/weeklynews/pwn20070121.html) - Fix incorrect permissions check in information_schema.key_column_usage view: it was checking a pg_constraint OID instead of pg_class OID, resulting in "relation with OID n does not exist" failures for anyone w