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 from

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. integrity. Only

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 parent

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-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, example,

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 seems *just*

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 fields

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 without

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

2006-10-06 Thread Ivan Sergio Borgonovo
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? -- Ivan Sergio Borgonovo

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 know if