On Sun, Jul 17, 2005 at 10:33:58PM +0200, Sander Steffann wrote:
> I wish I knew enough about the internals of PostgreSQL to write one :-)
> Sander
Well, there are other TODO items that are much simpler, which would be a
great way to learn more about the internals. :) There's been talk of
creating
Hi,
>"A serious limitation of the inheritance feature is that indexes
>(including unique constraints) and foreign key constraints only
>apply to single tables, not to their inheritance children. This
>is true on both the referencing and referenced sides of a foreign
>key constraint."
I would r
On Sun, Jul 17, 2005 at 12:38:48PM +0200, Sander Steffann wrote:
> >
> >"A serious limitation of the inheritance feature is that indexes
> >(including unique constraints) and foreign key constraints only
> >apply to single tables, not to their inheritance children. This
> >is true on both the refe
On Jul 17, 2005, at 5:35 AM, Michael Fuhr wrote:
See the inheritance documentation:
http://www.postgresql.org/docs/8.0/static/ddl-inherit.html
"A serious limitation of the inheritance feature is that indexes
(including unique constraints) and foreign key constraints only
apply to single tables
Hi,
http://www.postgresql.org/docs/8.0/static/ddl-inherit.html
"A serious limitation of the inheritance feature is that indexes
(including unique constraints) and foreign key constraints only
apply to single tables, not to their inheritance children. This
is true on both the referencing and re
On Sat, Jul 16, 2005 at 05:39:59PM -0400, Garrett Kalleberg wrote:
>
> Now, the rec with id '1234' is in the table
> invoicelineiteminventorytypes, but I can't wrap my head around the
> fact that
>
> SELECT invoicelineitemtypeid FROM invoicelineitemtypes
>
> yields the rec with invoicelineit
I have this structure:
CREATE TABLE invoicelineitemtypes (
invoicelineitemtypeid varchar(36) PRIMARY KEY,
otherstuff varchar(36)
);
CREATE TABLE invoicelineiteminventorytypes (
moresetuff varchar(36)
)
INHERITS (invoicelineitemtypes);
CREATE TABLE invoicelines (
invoicelineitemt
