| From: | Alessio Bragadini <alessio(at)albourne(dot)com> | 
|---|---|
| To: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> | 
| Cc: | Adriaan Joubert <a(dot)joubert(at)albourne(dot)com> | 
| Subject: | Foreign Keys referencing a View | 
| Date: | 2000-04-06 12:20:54 | 
| Message-ID: | 38EC8126.B465B89E@albourne.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-hackers | 
Hi,
I noticed a behaviour in PostgreSql 7 (beta 3, Alpha, Digital Unix 4.0f,
cc) that probably needs to be addressed.
If I create a table referencing a view
create table mytable (id serial, name text);
create view myview as select * from mytable where name like 'A%';
create table othertable (id serial, refer integer references myview
(id));
the engine doesn't complain, but
insert into mytable (name) values ('Alpha');
insert into othertable (refer) values (1);
ERROR:  system column oid not available - myview is a view
which looks sensible. But probably the errors should have been raised at 
'create table othertable'.
What do you think?
-- 
Alessio F. Bragadini		alessio(at)albourne(dot)com
APL Financial Services		http://www.sevenseas.org/~alessio
Nicosia, Cyprus		 	phone: +357-2-750652
"It is more complicated than you think"
		-- The Eighth Networking Truth from RFC 1925
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Lockhart | 2000-04-06 13:33:55 | Re: 7.1 items | 
| Previous Message | Karel Zak | 2000-04-06 11:02:45 | pg_dumplo, thanks :) (fwd) |