Re: [SQL] Database with "override" tables

2005-12-07 Thread Michael Burke
Lane Van Ingen wrote: Not quite sure how to answer this, but one thought does occur to me: I was perhaps assuming that an override table would override an entire record in the 'original' table(that is what we are doing), and we require that critical fields in the override field be NOT NULL (and

Re: [SQL] Database with "override" tables

2005-12-06 Thread Lane Van Ingen
s, provide DEFAULT values). Will that help? -Original Message- From: Michael Burke [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 06, 2005 9:55 AM To: Lane Van Ingen Cc: PGSQL-SQL Subject: Re: [SQL] Database with "override" tables Lane Van Ingen wrote: >I think I h

Re: [SQL] Database with "override" tables

2005-12-06 Thread Michael Burke
Lane Van Ingen wrote: I think I have a similar situation involving the naming of assets, where the usual asset description is used, but users can enter a description in a separate table which 'overrides' the original name with a name that is more familiar to the individual. IF THIS IS WHAT YO

Re: [SQL] Database with "override" tables

2005-12-05 Thread Lane Van Ingen
PGSQL-SQL Subject: [SQL] Database with "override" tables Hello, I am in a situation where I have various tables (including data such as a product list) that are read-only to me. I wish to provide the functionality of changing this table: Removing items, modifying items, creating new one

[SQL] Database with "override" tables

2005-12-05 Thread Michael Burke
Hello, I am in a situation where I have various tables (including data such as a product list) that are read-only to me. I wish to provide the functionality of changing this table: Removing items, modifying items, creating new ones. My original idea is to use a second table that is formatte