Problem with pg_dump / pg_restore

Поиск
Список
Период
Сортировка
От Armel HERVE
Тема Problem with pg_dump / pg_restore
Дата
Msg-id CGEBLCNHICNOBNMINIICIEADCDAA.ah.pgsql@laposte.net
обсуждение исходный текст
Список pgsql-interfaces
Hi everybody,
I have a problem with dump / restore commands on PostgreSQL:
pg_dump doesn't care about objects dependencies:- I create a view V1 on a table and then another view V2 on the 
same table- I modify V1 to use V2

pg_dump doesn't detect that V1 is using V2. So the command batch 
generated contains in first the creation of the view V1 which uses V2 
and then the creation on the view V2 and it's impossible to restore a 
database with this generated file.

My question is : how can I use pg_dump / pg_restore to generate a good 
backup file ?

Thanks for your answers (and sorry for my poor english!!!)

Armel


В списке pgsql-interfaces по дате отправления:

Предыдущее
От: Martin_Hurst@dom.com
Дата:
Сообщение: Where is Postgesql ? - MYSQL SURPRISES WITH MAXDB / MySQL appliance for Linux arrives
Следующее
От: siddiqui@mail.utexas.edu
Дата:
Сообщение: how to execute stored procedures from the console in pgAdmin???