Re: [BUGS] BUG #7842: pg_dump scripts view to table

[Maciej Łopuszański]

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=?= <lopuszan...@oleofarm.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: lopuszan...@oleofarm.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.