Re: new MB patch and pg_type oid problem - Mailing list pgsql-hackers

>> o these patches are made against the latest source tree (after Bruce's
>> massive patch, I think) BTW, I noticed that after running regression,
>> the oid field of pg_type seems disappeared.
>>
>>     regression=> select oid from pg_type;
>>     ERROR:  attribute 'oid' not found
>
>I just tried:
>
>    select oid from pg_type;
>
>and it worked.
>
>>
>> this happens after the constraints test. This occures with/without my
>> patches. strange...
>
>What contraints test?

The constraints test in the regression test suite.  Following step
should reproduce the problem.

------------------------------------------------
% cd src/test/regress
% gmake all
% createdb test
% psql -c "select count(oid) from pg_type" test
count
-----
  106
(1 row)
% psql test < sql/constraints.sql
% psql -c "select count(oid) from pg_type" test
ERROR:  attribute 'oid' not found
------------------------------------------------

I found the problem while debugging pg_dump command. I ran the
regression test, then tried to dump the regression database using
pg_dump that failed with an error message:

    getTypes(): SELECT failed

Inspecting the regression test step by step, I found the "no oid
attribute problem" had occured right after the constraints test.
--
Tatsuo Ishii
t-ishii@sra.co.jp