Re: [HACKERS] Inheritance, Primary Keys and Foreign Keys

2006-05-14 Thread Hannu Krosing
Ühel kenal päeval, N, 2006-05-11 kell 23:28, kirjutas Albert Cervera Areny: > Of course, that's an option for my case. Just wanted to know if this solution > could be useful for PostgreSQL in general. Mainly because I'll add some > triggers to check what maybe PostgreSQL should do itself but it's

Re: [HACKERS] Inheritance, Primary Keys and Foreign Keys

2006-05-14 Thread Thomas Hallgren
Albert Cervera Areny wrote: > ...What do you mean with triggers that maintain cascade behavior? It ties on to how references are handled. Since they currently ignore the inheritance aspect, you need triggers that enforce 'on cascade delete/update'. They will become obsolete if that changes (i.

Re: [HACKERS] Inheritance, Primary Keys and Foreign Keys

2006-05-14 Thread Albert Cervera Areny
A Saturday 13 May 2006 08:33, Thomas Hallgren va escriure: > Albert Cervera Areny wrote: > > Of course, that's an option for my case. Just wanted to know if this > > solution could be useful for PostgreSQL in general. Mainly because I'll > > add some triggers to check what maybe PostgreSQL should d

Re: [HACKERS] Inheritance, Primary Keys and Foreign Keys

2006-05-13 Thread Albert Cervera Areny
Of course, that's an option for my case. Just wanted to know if this solution could be useful for PostgreSQL in general. Mainly because I'll add some triggers to check what maybe PostgreSQL should do itself but it's unimplemented. If that's not interesting or a proper solution for PostgreSQL I

Re: [HACKERS] Inheritance, Primary Keys and Foreign Keys

2006-05-12 Thread Thomas Hallgren
Albert Cervera Areny wrote: Of course, that's an option for my case. Just wanted to know if this solution could be useful for PostgreSQL in general. Mainly because I'll add some triggers to check what maybe PostgreSQL should do itself but it's unimplemented. If that's not interesting or a proper

Re: [HACKERS] Inheritance, Primary Keys and Foreign Keys

2006-05-12 Thread Albert Cervera Areny
Of course, that's an option for my case. Just wanted to know if this solution could be useful for PostgreSQL in general. Mainly because I'll add some triggers to check what maybe PostgreSQL should do itself but it's unimplemented. If that's not interesting or a proper solution for PostgreSQL I'll

Re: [HACKERS] Inheritance, Primary Keys and Foreign Keys

2006-05-09 Thread Simon Riggs
On Tue, 2006-05-09 at 01:20 +0200, Albert Cervera Areny wrote: > In my particular case (don't know about the SQL standard or other > cases), > it'd be enough if when an inherited table is created: > - A primary key in the inherited table is created with the same columns > as > the su

[HACKERS] Inheritance, Primary Keys and Foreign Keys

2006-05-08 Thread Albert Cervera Areny
Hi, I'm developing an object persistency framework for which I'd love to have better support for inheritance in PostgreSQL. I could already map subclasses with the current inheritance facilities, but the problem is with Primary and Foreign Keys. There's a TODO for implementing Ind