Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group