Re: BUG #7842: pg_dump scripts view to table

why?

because 1 on views didnt recreate after restoring from backup, we had a table instead of view. that means incomplete backup without even our knowledge (no warn,error), if its not a bug what other word would be better to describe this?

and now the funny part:

I deleted and created this view(and dependant views) from the same definition it was stored in pg, and the problem just vanished....

this view now is properly stored by pg_dump, and properly restored by psql.

W dniu 01.02.2013 16:06, Tom Lane pisze:

=?UTF-8?B?TWFjaWVqIMWBb3B1c3phxYRza2k=?= lopuszanski(at)oleofarm(dot)com writes:

is there a way to find exactly what object/table/column creates this
circular dependency?

Look into pg_depend for entries referencing the view or the view's
rowtype. (Offhand I'd bet it's the latter.) So the refobjid would
be 'viewname'::regclass or 'viewname'::regtype.

pg_dumb even in verbose mode does not warn/error of this situation.

Why should it? This isn't a bug, this is merely an implementation
detail.

regards, tom lane

--

Maciej Łopuszański

Programista

mobile: +48 797 119 384

e-mail: lopuszanski(at)oleofarm(dot)com

Oleofarm Sp. z o.o., ul. Fabryczna 16, 55-080 Pietrzykowice

tel. +48 71 316 94 55, fax. +48 71 316 94 57, www.oleofarm.com.pl

NIP: 896-13-78-324, REGON: 933023467

Sąd Rejonowy dla Wrocławia Fabrycznej we Wrocławiu , VI Wydział Gospodarczy

Krajowego Rejestru Sądowego pod numerem KRS 218272, kapitał zakładowy: 50 000 zł

Zawarte w niniejszej wiadomości lub załączonym dokumencie informacje są POUFNE

i przeznaczone tylko dla oznaczonego adresata. Rozpowszechnianie, ujawnianie

i kopiowanie tych informacji jest zabronione. Jeżeli niniejsza wiadomość trafiła

do Państwa przez pomyłkę, bardzo prosimy o powiadomienie nas o tym fakcie

i odesłanie dokumentu lub natychmiastowe jego zniszczenie.

The information contained in the e-mail or attached document is CONFIDENTIAL

and is intended only for the use of the individual to whom it is addressed.

If you are not the intended recipient or employee responsible to deliver to the

intended recipient, you are hereby notified that any dissemination, distribution

or copying of the communication is strictly prohibited. If you have received

the e-mail in error, please immediately notify us and return the original message

to us at the address above or destroy it.