Re: partitioning using dblink - Mailing list pgsql-general

From Tom Lane
Subject Re: partitioning using dblink
Date
Msg-id 9593.1204308750@sss.pgh.pa.us
Whole thread Raw
In response to Re: partitioning using dblink  (Scara Maccai <m_lists@yahoo.it>)
Responses Re: partitioning using dblink
Re: partitioning using dblink
List pgsql-general
Scara Maccai <m_lists@yahoo.it> writes:
> I got that there should be no difference... plus, I don't get any
> errors,

You should have.  The system enforces (or tries to) that a view can't be
part of an inheritance hierarchy, but you seem to have managed to find a
sequence of operations that avoids those checks.  Turning a table into a
view with a manual CREATE RULE operation has always been a kluge, and
it's missing a check that the table isn't part of an inheritance tree.

            regards, tom lane

pgsql-general by date:

Previous
From: Chris Bowlby
Date:
Subject: issue with an assembled date field
Next
From: Colin Wetherbee
Date:
Subject: Re: issue with an assembled date field