Hi,
Ketema Harris wrote:
as expected I can do select * from states and get everything out of the
child table as well. What I can't do is create a FK to the states table
and have it look in the child table as well. Is this on purpose? Is it
possible to have FK that spans into child tables?
On Sep 14, 2007, at 10:35 AM, Ketema Harris wrote:
I have the following table set up:
CREATE TABLE states
(
state_id integer NOT NULL DEFAULT nextval
('state_province_id_seq'::regclass),
state character(2),
full_name character varying,
timezone character varying,
CONSTRAINT "PK_stat
On Friday 14 September 2007, Ketema Harris <[EMAIL PROTECTED]> wrote:
> as expected I can do select * from states and get everything out of
> the child table as well. What I can't do is create a FK to the
> states table and have it look in the child table as well. Is this on
> purpose? Is it pos
On 9/14/07, Ketema Harris <[EMAIL PROTECTED]> wrote:
> I have the following table set up:
>
> CREATE TABLE states
> (
>state_id integer NOT NULL DEFAULT nextval
> ('state_province_id_seq'::regclass),
>state character(2),
>full_name character varying,
>timezone character varying,
>
