Re: partitioning using dblink

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Scara Maccai <m_lists(at)yahoo(dot)it>
Cc: Marko Kreen <markokr(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: partitioning using dblink
Date: 2008-02-29 18:12:30
Message-ID: 9593.1204308750@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Scara Maccai <m_lists(at)yahoo(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Carl McCalla 2008-02-29 18:12:50 Removing Users and Revoking Privileges
Previous Message Colin Wetherbee 2008-02-29 18:12:25 Re: issue with an assembled date field