Re: What causes a table's oid to change?

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: What causes a table's oid to change?
Дата
Msg-id web-1776617@davinci.ethosmedia.com
обсуждение исходный текст
Ответ на Re: What causes a table's oid to change?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Sudheesh Krishnankutty
Дата:
Сообщение: How to store encrypted data into database
Следующее
От: Thad Humphries
Дата:
Сообщение: date conversions