Marcin Gil <marcin(dot)gil(at)audax(dot)com(dot)pl> writes:
> I see. That's my first time with inheriting tables. I though that it
> would be something as C++, ie. structure inherit only.
As of 7.4 there is a way to do structural inheritance, but it's not this
syntax.
>> You could do "SELECT docid FROM ONLY documents" if you don't want the
>> scan to include child tables. But it's probably a bad idea to use
>> inheritance for the archives table at all.
>>
> Why it's a bad idea?
Just because it's error prone. I can't see that you'd ever want to
include the archives table in searches or updates of the documents table
--- but the default behavior will be to do so.
regards, tom lane