[HACKERS] Re: [GENERAL] child table doesn't inherit PRIMARY KEY?

2001-01-24 Thread Bruce Momjian
OK, what do people want to do with this item? Add to TODO list? Seems making a separat unique constraint would be easy to do and be of value to most users. Probably, since I see it in near recent sources (and it affects UNIQUE as well. As I remember it, the last discussion on this

[HACKERS] Re: [GENERAL] child table doesn't inherit PRIMARY KEY?

2001-01-24 Thread Bruce Momjian
On Wed, 24 Jan 2001, Bruce Momjian wrote: OK, what do people want to do with this item? Add to TODO list? Seems making a separat unique constraint would be easy to do and be of value to most users. The problem is that doing that will pretty much guarantee that we won't be

[HACKERS] Re: [GENERAL] child table doesn't inherit PRIMARY KEY?

2001-01-24 Thread Stephan Szabo
On Wed, 24 Jan 2001, Bruce Momjian wrote: OK, what do people want to do with this item? Add to TODO list? Seems making a separat unique constraint would be easy to do and be of value to most users. The problem is that doing that will pretty much guarantee that we won't be doing foreign

Re: [HACKERS] Re: [GENERAL] child table doesn't inherit PRIMARY KEY?

2001-01-24 Thread Oliver Elphick
Bruce Momjian wrote: On Wed, 24 Jan 2001, Bruce Momjian wrote: I smell TODO item. In fact, I now see a TODO item: * Unique index on base column not honored on inserts from inherited table INSERT INTO inherit_table (unique_index_col) VALUES (dup) should fail [inherit] So

Re: [HACKERS] Re: [GENERAL] child table doesn't inherit PRIMARY KEY?

2001-01-24 Thread Bruce Momjian
Thanks. Done. Bruce Momjian wrote: On Wed, 24 Jan 2001, Bruce Momjian wrote: I smell TODO item. In fact, I now see a TODO item: * Unique index on base column not honored on inserts from inherited table INSERT INTO inherit_table (unique_index_col) VALUES (dup) should fail