Re: [GENERAL] inheritance and partial index: how to override constraints or default_values

2001-02-27 Thread Oliver Elphick
Nico wrote: >I want to partial index every table in a inherited tree. >Please let me know how to override the fields along inheritance? There is currently no facility that I know of for doing this. It would be nice to be able to attach a column to an existing index. -- Oliver Elphick

[GENERAL] inheritance and partial index: how to override constraints or default_values

2001-02-27 Thread Nico
I want to partial index every table in a inherited tree. Please let me know how to override the fields along inheritance? ===8<= CREATE SEQUENCE "a_id_seq" increment 1 minvalue 01 maxvalue 01 start 010001 cache 1; CREATE TABLE "a" ( "id" int4 DEFAULT