Re: segv's on CREATE INDEX with recent HEAD...

> Sean Chittenden <sean(at)chittenden(dot)org> writes:
> > PS What's the dilly with the server(s)? I haven't gotten a commit
> > message all day, but CVSup and anoncvs picked up the change.
>
> Well, the CVS master server has been pretty much 100% through this
> whole rigmarole (kudos to Marc for keeping up what *had* to be up ;-))
> The anoncvs mirror was busted for a couple days but has been okay since
> then, AFAIK. The pgsql-committers list is still, uh, AWOL. I get the
> impression that the listserv doesn't think the CVS server is authorized
> to send mail to the list, and that Marc has been manually approving
> batches of mail every couple days but hasn't got round to locating the
> real problem yet. I trust he'll get it fixed before much longer though
> ...

Hardware problems are the worst. Best of Marc. Well, normally you're
good about committing things in batches, but I'm not sure if I'm
building against a complete/up to date version, but here is some
regression.diff fun to digest. Looks like expected/misc.out and
./expected/sanity_check.out need to be updated and there's something
wrong with triggers/constraints:

*** ./expected/constraints.out Wed May 28 23:26:42 2003
--- ./results/constraints.out Wed May 28 23:28:15 2003
***************
*** 191,210 ****
CREATE TABLE INSERT_CHILD (cx INT default 42,
cy INT CHECK (cy > x))
INHERITS (INSERT_TBL);
INSERT INTO INSERT_CHILD(x,z,cy) VALUES (7,-7,11);
INSERT INTO INSERT_CHILD(x,z,cy) VALUES (7,-7,6);
! ERROR: ExecInsert: rejected due to CHECK constraint "insert_child_cy" on "insert_child"
INSERT INTO INSERT_CHILD(x,z,cy) VALUES (6,-7,7);
! ERROR: ExecInsert: rejected due to CHECK constraint "$1" on "insert_child"
INSERT INTO INSERT_CHILD(x,y,z,cy) VALUES (6,'check failed',-6,7);
! ERROR: ExecInsert: rejected due to CHECK constraint "insert_con" on "insert_child"
SELECT * FROM INSERT_CHILD;
! x | y | z | cx | cy
! ---+--------+----+----+----
! 7 | -NULL- | -7 | 42 | 11
! (1 row)
!
DROP TABLE INSERT_CHILD;
--
-- Check constraints on INSERT INTO
--
--- 191,209 ----
CREATE TABLE INSERT_CHILD (cx INT default 42,
cy INT CHECK (cy > x))
INHERITS (INSERT_TBL);
+ ERROR: RelationClearRelation: relation 135137 deleted while still in use
INSERT INTO INSERT_CHILD(x,z,cy) VALUES (7,-7,11);
+ ERROR: Relation "insert_child" does not exist
INSERT INTO INSERT_CHILD(x,z,cy) VALUES (7,-7,6);
! ERROR: Relation "insert_child" does not exist
INSERT INTO INSERT_CHILD(x,z,cy) VALUES (6,-7,7);
! ERROR: Relation "insert_child" does not exist
INSERT INTO INSERT_CHILD(x,y,z,cy) VALUES (6,'check failed',-6,7);
! ERROR: Relation "insert_child" does not exist
SELECT * FROM INSERT_CHILD;
! ERROR: Relation "insert_child" does not exist
DROP TABLE INSERT_CHILD;
+ ERROR: table "insert_child" does not exist
--
-- Check constraints on INSERT INTO
--

======================================================================

*** ./expected/triggers.out Sat Nov 23 10:13:22 2002
--- ./results/triggers.out Wed May 28 23:28:15 2003
***************
*** 87,92 ****
--- 87,93 ----
NOTICE: check_pkeys_fkey_cascade: 1 tuple(s) of fkeys are deleted
NOTICE: check_pkeys_fkey_cascade: 1 tuple(s) of fkeys2 are deleted
DROP TABLE pkeys;
+ ERROR: Relation 120339 does not exist
DROP TABLE fkeys;
DROP TABLE fkeys2;
-- -- I've disabled the funny_dup17 test because the new semantics

======================================================================

*** ./expected/sanity_check.out Wed May 28 09:04:02 2003
--- ./results/sanity_check.out Wed May 28 23:28:29 2003
***************
*** 58,68 ****
pg_statistic | t
pg_trigger | t
pg_type | t
road | t
shighway | t
tenk1 | t
tenk2 | t
! (52 rows)

--
-- another sanity check: every system catalog that has OIDs should have
--- 58,69 ----
pg_statistic | t
pg_trigger | t
pg_type | t
+ pkeys | t
road | t
shighway | t
tenk1 | t
tenk2 | t
! (53 rows)

--
-- another sanity check: every system catalog that has OIDs should have

======================================================================

*** ./expected/misc.out Wed May 28 23:26:42 2003
--- ./results/misc.out Wed May 28 23:28:39 2003
***************
*** 633,638 ****
--- 633,639 ----
onek2
path_tbl
person
+ pkeys
point_tbl
polygon_tbl
ramp
***************
*** 657,663 ****
toyemp
varchar_tbl
xacttest
! (93 rows)

--SELECT name(equipment(hobby_construct(text 'skywalking', text 'mer'))) AS equip_name;
SELECT hobbies_by_name('basketball');
--- 658,664 ----
toyemp
varchar_tbl
xacttest
! (94 rows)

--SELECT name(equipment(hobby_construct(text 'skywalking', text 'mer'))) AS equip_name;
SELECT hobbies_by_name('basketball');

======================================================================

Sorry for the bad news... or incomplete Sup. This a local problem
(incomplete checkout?) or is there something else going on? -sc

--
Sean Chittenden