On Sat, Apr 25, 2009 at 04:21:06PM -0400, Kenneth Tilton wrote:
> But I am "inheriting" from the parent, so everything about the parent
> should be true for me unless overridden. I mean in the usual sense of
> inherit I know from OO.
This is from the current docs
(http://www.postgresql.org/doc
Joshua Tolley wrote:
On Sat, Apr 25, 2009 at 04:01:20PM -0400, Kenneth Tilton wrote:
Given constraint:
ALTER TABLE provider_input.common
ADD CONSTRAINT common_pin_file_load_sid_fkey FOREIGN KEY
(pin_file_load_sid)
REFERENCES provider_input.file_load (sid) MATCH FULL
ON UPDATE
On Sat, Apr 25, 2009 at 04:01:20PM -0400, Kenneth Tilton wrote:
> Given constraint:
>
> ALTER TABLE provider_input.common
> ADD CONSTRAINT common_pin_file_load_sid_fkey FOREIGN KEY
> (pin_file_load_sid)
> REFERENCES provider_input.file_load (sid) MATCH FULL
> ON UPDATE NO ACTION ON
My noob understanding is that deleteing one of these:
CREATE TABLE provider_input.file_load
(
sid serial NOT NULL,
file_name_full text,
file_name text,
file_creation_date text,
load_universal_time numeric,
headers text,
date timestamp without time zone DEFAULT now(),
CONSTRAINT fi
