Re: inherited table and rules

From: Scott Frankel <leknarf(at)pacbell(dot)net>
To: Klint Gore <kg(at)kgb(dot)une(dot)edu(dot)au>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: inherited table and rules
Date: 2005-03-23 23:09:45
Message-ID: 6cb4d972d8821aab5272e4e2c52bdc3f@pacbell.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Mar 23, 2005, at 2:42 PM, Klint Gore wrote:
>
> Rows inserted into inherited tables are visible to the parent. It's
> effectively the same as having a union all on the 2 tables. Using the
> only qualifier is how you stop the "union" happening.

This explains it.

Thanks!
Scott

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-03-23 23:25:28 Re: plperl doesn't release memory
Previous Message Sven Willenberger 2005-03-23 22:45:22 plperl doesn't release memory