Foreign Keys and OIDs
| От | Toshio Kuratomi |
|---|---|
| Тема | Foreign Keys and OIDs |
| Дата | |
| Msg-id | 20001216145027.D9113@prtr-13.ucsc.edu обсуждение |
| Ответы |
Re: Foreign Keys and OIDs
|
| Список | pgsql-general |
Is the foreign key mechanism supposed to work with OIDs?
Is it known to be broken in 7.0.3?
I declare two tables:
CREATE TABLE address (
street text,
city text,
state char(2) check ( state ~'[A-Z]{2}')
);
CREATE TABLE personaddress (
person_id integer,
address_id oid references address(oid),
notes text,
primary key (person_id, address_id)
);
Then I insert data into both address and person.
When I try to insert into personaddress I get the following reply:
=>INSERT INTO personaddress VALUES ('1', '29321', 'My home');
ERROR: constraint <unnamed>: table address does not have an attribute oid
Should I create a new primary key column or is there some workaround or a
fix in the upcoming release or am I just plain doing something wrong?
Thanks,
Toshio Kuratomi
--
______S______U______B______L______I______M______I______N______A______L______
b a d g e r @ p r t r - 1 3 . u c s c . e d u
GA->ME 1999
В списке pgsql-general по дате отправления: