Re: [GENERAL] Inheritance and shared sequence

2007-06-07 Thread Oliver Elphick
On Thu, 2007-06-07 at 09:44 +0100, Richard Huxton wrote: > Sebastjan Trepca wrote: > > Hi, > > > > as I understood, when you create a table which inherits some other > > table, the constraints and indexes do not go to the child table hence > > you have to create a separate ones in there. That mean

Re: [GENERAL] Inheritance and shared sequence

2007-06-07 Thread Richard Huxton
Sebastjan Trepca wrote: Hi, as I understood, when you create a table which inherits some other table, the constraints and indexes do not go to the child table hence you have to create a separate ones in there. That means you cannot depend that you won't have duplicate IDs in both tables. Right?

[GENERAL] Inheritance and shared sequence

2007-06-07 Thread Sebastjan Trepca
Hi, as I understood, when you create a table which inherits some other table, the constraints and indexes do not go to the child table hence you have to create a separate ones in there. That means you cannot depend that you won't have duplicate IDs in both tables. Right? BUT...what if child tabl