From: | t-ishii(at)sra(dot)co(dot)jp |
---|---|
To: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | t-ishii(at)sra(dot)co(dot)jp, lockhart(at)alumni(dot)caltech(dot)edu, hackers(at)postgreSQL(dot)org |
Subject: | Re: new MB patch and pg_type oid problem |
Date: | 1998-08-20 01:15:52 |
Message-ID: | 199808200115.KAA02092@srapc451.sra.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)sra(dot)co(dot)jp
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1998-08-20 04:04:08 | Re: [HACKERS] weird problem with latest cvs |
Previous Message | Keith Parks | 1998-08-19 23:06:49 | Re: Rules and views (was Re: [HACKERS] Rules: 2nd patch) |