Re: [GENERAL] exploiting features of pg to obtain polymorphism

2006-10-17 Thread Karsten Hilbert
On Mon, Oct 16, 2006 at 11:41:25AM +0200, Ivan Sergio Borgonovo wrote: > > You can put a unique constraint and a serial default on the > > parent table (such as a primary key). Insertion on a child > > table will fail if the key in question already exists in the > > base table. It may have come fr

Re: [GENERAL] exploiting features of pg to obtain polymorphism

2006-10-16 Thread Ivan Sergio Borgonovo
On Fri, 13 Oct 2006 16:37:42 +0200 Karsten Hilbert <[EMAIL PROTECTED]> wrote: > On Thu, Oct 12, 2006 at 04:40:32PM +0200, Ivan Sergio Borgonovo > wrote: > > > Anyway it doesn't solve the problem of having lists that > > can contain different elements with same parent and maintain > > ref. integri

Re: [GENERAL] exploiting features of pg to obtain polymorphism

2006-10-13 Thread Jeff Davis
On Fri, 2006-10-06 at 23:09 +0200, Ivan Sergio Borgonovo wrote: > Is there any good documentation, example, tutorial, pamphlet, discussion... > to exploit pg features to obtain "polymorphic" behavior without renouncing to > referential integrity? > > Inheritance seems *just* promising. > > Any

Re: [GENERAL] exploiting features of pg to obtain polymorphism

2006-10-13 Thread Karsten Hilbert
On Thu, Oct 12, 2006 at 04:40:32PM +0200, Ivan Sergio Borgonovo wrote: > Anyway it doesn't solve the problem of having lists that > can contain different elements with same parent and maintain > ref. integrity. Only to some degree. You can put a unique constraint and a serial default on the paren

Re: [GENERAL] exploiting features of pg to obtain polymorphism

2006-10-12 Thread Ivan Sergio Borgonovo
Resending since it definitively seems it has been lost in outer spaces. Sorry for duplicates if any. On Sun, 8 Oct 2006 14:09:53 +0200 Karsten Hilbert <[EMAIL PROTECTED]> wrote: > On Fri, Oct 06, 2006 at 11:09:29PM +0200, Ivan Sergio Borgonovo > wrote: > > > Is there any good documentation, exam

Re: [GENERAL] exploiting features of pg to obtain polymorphism

2006-10-08 Thread Ivan Sergio Borgonovo
On Sun, 8 Oct 2006 14:09:53 +0200 Karsten Hilbert <[EMAIL PROTECTED]> wrote: > On Fri, Oct 06, 2006 at 11:09:29PM +0200, Ivan Sergio Borgonovo > wrote: > > > Is there any good documentation, example, tutorial, pamphlet, > > discussion... to exploit pg features to obtain "polymorphic" > > behavior

Re: [GENERAL] exploiting features of pg to obtain polymorphism maintaining ref. integrity

2006-10-08 Thread Karsten Hilbert
On Fri, Oct 06, 2006 at 11:09:29PM +0200, Ivan Sergio Borgonovo wrote: > Is there any good documentation, example, tutorial, pamphlet, discussion... > to exploit pg features to obtain "polymorphic" behavior without renouncing to > referential integrity? In GNUmed we use it to aggregate text fie

Re: [GENERAL] exploiting features of pg to obtain polymorphism

2006-10-08 Thread Ivan Sergio Borgonovo
On Fri, 6 Oct 2006 18:12:22 -0700 (PDT) Richard Broersma Jr <[EMAIL PROTECTED]> wrote: > > Is there any good documentation, example, tutorial, pamphlet, > > discussion... to exploit pg features to obtain "polymorphic" > > behavior without renouncing to referential integrity? > > > > Inheritance s

Re: [GENERAL] exploiting features of pg to obtain polymorphism maintaining ref. integrity

2006-10-06 Thread Richard Broersma Jr
> Is there any good documentation, example, tutorial, pamphlet, discussion... > to exploit pg > features to obtain "polymorphic" behavior without renouncing to referential > integrity? > > Inheritance seems *just* promising. > > Any methodical a approach to the problem in pg context? I don't k