Re: new MB patch and pg_type oid problem - Mailing list pgsql-hackers
| From | Bruce Momjian |
|---|---|
| Subject | Re: new MB patch and pg_type oid problem |
| Date | |
| Msg-id | 199808201547.LAA27134@candle.pha.pa.us Whole thread Raw |
| In response to | Re: new MB patch and pg_type oid problem (t-ishii@sra.co.jp) |
| 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. 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@candle.pha.pa.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)
pgsql-hackers by date: