On Sun, 6 Feb 2005, Larry Rosenman wrote:

I get the following:

$ TRAP: FailedAssertion("!(!(tup->t_data->t_infomask & 0x0010))", File: "heapam.c", Line: 1133)


when I try to cluster this table:

CREATE TABLE virtusers (
   lhs text,
   rhs text,
   insert_date timestamp(0) with time zone DEFAULT now(),
   insert_who text DEFAULT "current_user"(),
   "comment" text
);
ALTER TABLE ONLY virtusers ALTER COLUMN lhs SET STATISTICS 100;

--
-- Name: vu_lhs_index; Type: INDEX; Schema: public; Owner: ler; Tablespace: --


CREATE UNIQUE INDEX vu_lhs_index ON virtusers USING btree (lhs);


ALTER INDEX public.vu_lhs_index OWNER TO ler;


When I issue the cluster vu_lhs_index on virtusers, I get the above assertion.


8.0.1 on UnixWare 7.1.4



I had done the following, which I think is what's doing it:

1) alter table virtusers (and all the others in that db) set without oids;
2) changed postgresql.conf's default_with_oids to false.

Based on my read, this case is what's causing the grief.


-- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: ler@lerctr.org US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
     subscribe-nomail command to [EMAIL PROTECTED] so that your
     message can get through to the mailing list cleanly

Reply via email to