Re: new MB patch and pg_type oid problem

> >> 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.

I see the following change to pg_attribute. I am researching why.

They are exactly the rows you say are missing.

---------------------------------------------------------------------------

*** /tmp/c Thu Aug 20 11:43:41 1998
--- /tmp/d Thu Aug 20 11:44:10 1998
***************
*** 12,21 ****
1247 typoutput 24 0 4 12 0 -1 -1 t f i f f
1247 typreceive 24 0 4 13 0 -1 -1 t f i f f
1247 typsend 24 0 4 14 0 -1 -1 t f i f f
- 1247 typalign 18 0 1 15 0 -1 -1 t f c f f
- 1247 typdefault 25 0 -1 16 0 -1 -1 f f i f f
- 1247 ctid 27 0 6 -1 0 -1 -1 f f i f f
- 1247 oid 26 0 4 -2 0 -1 -1 t f i f f
1247 xmin 28 0 4 -3 0 -1 -1 f f i f f
1247 cmin 29 0 4 -4 0 -1 -1 t f i f f
1247 xmax 28 0 4 -5 0 -1 -1 f f i f f
--- 12,17 ----
***************
*** 393,395 ****
--- 389,503 ----
17184 cmin 29 0 4 -4 0 -1 -1 t f i f f
17184 xmax 28 0 4 -5 0 -1 -1 f f i f f
17184 cmax 29 0 4 -6 0 -1 -1 t f i f f
+ 143776 i 23 0 4 1 0 -1 -1 t f i f t
+ 143776 x 25 0 -1 2 0 -1 -1 f f i f t
+ 143776 f 701 0 8 3 0 -1 -1 f f d f t
+ 143776 ctid 27 0 6 -1 0 -1 -1 f f i f f
+ 143776 oid 26 0 4 -2 0 -1 -1 t f i f f
+ 143776 xmin 28 0 4 -3 0 -1 -1 f f i f f
+ 143776 cmin 29 0 4 -4 0 -1 -1 t f i f f
+ 143776 xmax 28 0 4 -5 0 -1 -1 f f i f f
+ 143776 cmax 29 0 4 -6 0 -1 -1 t f i f f
+ 143795 sequence_name 19 0 32 1 0 -1 -1 f f d f f
+ 143795 last_value 23 0 4 2 0 -1 -1 t f i f f
+ 143795 increment_by 23 0 4 3 0 -1 -1 t f i f f
+ 143795 max_value 23 0 4 4 0 -1 -1 t f i f f
+ 143795 min_value 23 0 4 5 0 -1 -1 t f i f f
+ 143795 cache_value 23 0 4 6 0 -1 -1 t f i f f
+ 143795 is_cycled 18 0 1 7 0 -1 -1 t f c f f
+ 143795 is_called 18 0 1 8 0 -1 -1 t f c f f
+ 143795 ctid 27 0 6 -1 0 -1 -1 f f i f f
+ 143795 oid 26 0 4 -2 0 -1 -1 t f i f f
+ 143795 xmin 28 0 4 -3 0 -1 -1 f f i f f
+ 143795 cmin 29 0 4 -4 0 -1 -1 t f i f f
+ 143795 xmax 28 0 4 -5 0 -1 -1 f f i f f
+ 143795 cmax 29 0 4 -6 0 -1 -1 t f i f f
+ 143812 i1 23 0 4 1 0 -1 -1 t f i f t
+ 143812 i2 23 0 4 2 0 -1 -1 t f i f t
+ 143812 ctid 27 0 6 -1 0 -1 -1 f f i f f
+ 143812 oid 26 0 4 -2 0 -1 -1 t f i f f
+ 143812 xmin 28 0 4 -3 0 -1 -1 f f i f f
+ 143812 cmin 29 0 4 -4 0 -1 -1 t f i f f
+ 143812 xmax 28 0 4 -5 0 -1 -1 f f i f f
+ 143812 cmax 29 0 4 -6 0 -1 -1 t f i f f
+ 143828 x 23 0 4 1 0 -1 -1 t f i f f
+ 143828 ctid 27 0 6 -1 0 -1 -1 f f i f f
+ 143828 oid 26 0 4 -2 0 -1 -1 t f i f f
+ 143828 xmin 28 0 4 -3 0 -1 -1 f f i f f
+ 143828 cmin 29 0 4 -4 0 -1 -1 t f i f f
+ 143828 xmax 28 0 4 -5 0 -1 -1 f f i f f
+ 143828 cmax 29 0 4 -6 0 -1 -1 t f i f f
+ 143841 sequence_name 19 0 32 1 0 -1 -1 f f d f f
+ 143841 last_value 23 0 4 2 0 -1 -1 t f i f f
+ 143841 increment_by 23 0 4 3 0 -1 -1 t f i f f
+ 143841 max_value 23 0 4 4 0 -1 -1 t f i f f
+ 143841 min_value 23 0 4 5 0 -1 -1 t f i f f
+ 143841 cache_value 23 0 4 6 0 -1 -1 t f i f f
+ 143841 is_cycled 18 0 1 7 0 -1 -1 t f c f f
+ 143841 is_called 18 0 1 8 0 -1 -1 t f c f f
+ 143841 ctid 27 0 6 -1 0 -1 -1 f f i f f
+ 143841 oid 26 0 4 -2 0 -1 -1 t f i f f
+ 143841 xmin 28 0 4 -3 0 -1 -1 f f i f f
+ 143841 cmin 29 0 4 -4 0 -1 -1 t f i f f
+ 143841 xmax 28 0 4 -5 0 -1 -1 f f i f f
+ 143841 cmax 29 0 4 -6 0 -1 -1 t f i f f
+ 143858 x 23 0 4 1 0 -1 -1 t f i f f
+ 143858 y 25 0 -1 2 0 -1 -1 f f i f f
+ 143858 z 23 0 4 3 0 -1 -1 t f i f f
+ 143858 ctid 27 0 6 -1 0 -1 -1 f f i f f
+ 143858 oid 26 0 4 -2 0 -1 -1 t f i f f
+ 143858 xmin 28 0 4 -3 0 -1 -1 f f i f f
+ 143858 cmin 29 0 4 -4 0 -1 -1 t f i f f
+ 143858 xmax 28 0 4 -5 0 -1 -1 f f i f f
+ 143858 cmax 29 0 4 -6 0 -1 -1 t f i f f
+ 143872 sequence_name 19 0 32 1 0 -1 -1 f f d f f
+ 143872 last_value 23 0 4 2 0 -1 -1 t f i f f
+ 143872 increment_by 23 0 4 3 0 -1 -1 t f i f f
+ 143872 max_value 23 0 4 4 0 -1 -1 t f i f f
+ 143872 min_value 23 0 4 5 0 -1 -1 t f i f f
+ 143872 cache_value 23 0 4 6 0 -1 -1 t f i f f
+ 143872 is_cycled 18 0 1 7 0 -1 -1 t f c f f
+ 143872 is_called 18 0 1 8 0 -1 -1 t f c f f
+ 143889 x 23 0 4 1 0 -1 -1 t f i f t
+ 143889 y 25 0 -1 2 0 -1 -1 f f i f t
+ 143889 z 23 0 4 3 0 -1 -1 t f i f t
+ 143889 ctid 27 0 6 -1 0 -1 -1 f f i f f
+ 143889 oid 26 0 4 -2 0 -1 -1 t f i f f
+ 143889 xmin 28 0 4 -3 0 -1 -1 f f i f f
+ 143889 cmin 29 0 4 -4 0 -1 -1 t f i f f
+ 143889 xmax 28 0 4 -5 0 -1 -1 f f i f f
+ 143889 cmax 29 0 4 -6 0 -1 -1 t f i f f
+ 143911 sequence_name 19 0 32 1 0 -1 -1 f f d f f
+ 143911 last_value 23 0 4 2 0 -1 -1 t f i f f
+ 143911 increment_by 23 0 4 3 0 -1 -1 t f i f f
+ 143911 max_value 23 0 4 4 0 -1 -1 t f i f f
+ 143911 min_value 23 0 4 5 0 -1 -1 t f i f f
+ 143911 cache_value 23 0 4 6 0 -1 -1 t f i f f
+ 143911 is_cycled 18 0 1 7 0 -1 -1 t f c f f
+ 143911 is_called 18 0 1 8 0 -1 -1 t f c f f
+ 143911 ctid 27 0 6 -1 0 -1 -1 f f i f f
+ 143911 oid 26 0 4 -2 0 -1 -1 t f i f f
+ 143911 xmin 28 0 4 -3 0 -1 -1 f f i f f
+ 143911 cmin 29 0 4 -4 0 -1 -1 t f i f f
+ 143911 xmax 28 0 4 -5 0 -1 -1 f f i f f
+ 143911 cmax 29 0 4 -6 0 -1 -1 t f i f f
+ 143928 xd 23 0 4 1 0 -1 -1 t f i f f
+ 143928 yd 25 0 -1 2 0 -1 -1 f f i f f
+ 143928 zd 23 0 4 3 0 -1 -1 t f i f f
+ 143946 x 23 0 4 1 0 -1 -1 t f i f f
+ 143946 y 25 0 -1 2 0 -1 -1 f f i f f
+ 143946 z 23 0 4 3 0 -1 -1 t f i f f
+ 143946 ctid 27 0 6 -1 0 -1 -1 f f i f f
+ 143946 oid 26 0 4 -2 0 -1 -1 t f i f f
+ 143946 xmin 28 0 4 -3 0 -1 -1 f f i f f
+ 143946 cmin 29 0 4 -4 0 -1 -1 t f i f f
+ 143946 xmax 28 0 4 -5 0 -1 -1 f f i f f
+ 143946 cmax 29 0 4 -6 0 -1 -1 t f i f f
+ 143961 i 23 0 4 1 0 -1 -1 t f i t f
+ 143961 t 25 0 -1 2 0 -1 -1 f f i f f
+ 143979 i 23 0 4 1 0 -1 -1 t f i t f
+ 143979 t 25 0 -1 2 0 -1 -1 f f i t f
+ 143997 i 23 0 4 1 0 -1 -1 t f i f f
+ 143997 t 25 0 -1 2 0 -1 -1 f f i f f
+ 144017 i 23 0 4 1 0 -1 -1 t f i f f
+ 144017 t 25 0 -1 2 0 -1 -1 f f i f f

--
Bruce Momjian | 830 Blythe Avenue
maillist(at)candle(dot)pha(dot)pa(dot)us | Drexel Hill, Pennsylvania 19026
+ If your life is a hard drive, | (610) 353-9879(w)
+ Christ can be your backup. | (610) 853-3000(h)