| From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> | 
|---|---|
| To: | "Hackers" <pgsql-hackers(at)postgresql(dot)org> | 
| Subject: | Bright ideas required for drop column... | 
| Date: | 2002-07-18 05:48:51 | 
| Message-ID: | GNELIHDDFBOCMGBFGEFOKEDGCDAA.chriskl@familyhealth.com.au | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-hackers | 
Does anyone know how I should modify MergeAttributes to support dropped
columns?
If the parent column is dropped, should I perhaps just instead of going:
def = makeNode(ColumnDef);
I could go something like:
def = makeNullNode(); (or whatever the correct function is)
Or should I modify or remove this sort of thing?:
inhSchema = lappend(inhSchema, def);
This is to stop a new child table from inheriting dropped columns by
default...
Also, the last thing after that on my checklist is fixing these two:
CREATE CONSTRAINT TRIGGER
ALTER TABLE / ADD FOREIGN KEY
Where should I do the check for these?  For the alter table case, I can
check that the foreign keys and primary keys actually exist in
createForeignKeyConstraint, but that means that it's already done the table
scan to validate the foreign key.
And I can't for the life of me actually find where a CREATE CONSTRAINT
TRIGGER statement is processed...
Chris
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Zeugswetter Andreas SB SD | 2002-07-18 08:01:20 | Re: error codes | 
| Previous Message | Bruce Momjian | 2002-07-18 05:00:17 | Re: utils C files |