| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Alex Pilosov <alex(at)pilosoft(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: inheritance question 2/ref integrity |
| Date: | 2000-10-08 00:43:20 |
| Message-ID: | Pine.BSF.4.10.10010071739090.13099-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Sat, 7 Oct 2000, Alex Pilosov wrote:
> Can I do following?
>
> create table foo (
> x int4 references bar*
> )
>
> Or, since 7.1 will have bar* as default for bar, will using 'references
> bar' do what I want?
No, and not really. Parts of it may sort of work, but referential
actions will definately fail (this includes the default no action)
because I don't believe triggers inherit in an automatic fashion.
Also, at least under 7.0 and earlier, constraints don't inherit and
they would have to for the above to be meaningful (the values in bar*'s
primary key have to be unique through all of the inheritance tree or
most of the references stuff simply doesn't work right).
| From | Date | Subject | |
|---|---|---|---|
| Next Message | The Hermit Hacker | 2000-10-08 01:13:02 | Re: What's happening with pgsql-committers? |
| Previous Message | The Hermit Hacker | 2000-10-08 00:13:47 | Re: Re: [ANNOUNCE] Announce: Release of PyGreSQL version 3.0 |