Re: What causes a table's oid to change? - Mailing list pgsql-novice

From Josh Berkus
Subject Re: What causes a table's oid to change?
Date
Msg-id web-1776617@davinci.ethosmedia.com
Whole thread Raw
In response to Re: What causes a table's oid to change?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Tom,

> 7.3 fixes it, if you consider a fix to be disallowing drop of a table
> that has dependent views...
>
> regression=# create table t1 (f1 int);
> CREATE TABLE
> regression=# create view v1 as select * from t1;
> CREATE VIEW
> regression=# drop table t1;
> NOTICE:  rule _RETURN on view v1 depends on table t1
> NOTICE:  view v1 depends on rule _RETURN on view v1

Cool!  This wouldn't be much of a fix if you hadn't implemented DROP
COLUMN as well, but with that, it helps a lot.

One of the most gratifying things about being part of the Postgresql
commmunity is being able to see the (rapid) progress happen.

-Josh


pgsql-novice by date:

Previous
From: Sudheesh Krishnankutty
Date:
Subject: How to store encrypted data into database
Next
From: Thad Humphries
Date:
Subject: date conversions