Hi Mark,
in fact, the problem is in the structure backup: this command doesn't care
about views dependencies. It take views in creation order to put its in
the .sql. So I have to reorder manually this view creations.
I made a view (another...) to look for dependencies. Maybe it's the good
way.
This view give, for each view oid, the dependencies:
SELECT dep.objid,
(SELECT pg_rewrite.ev_class
FROM pg_rewrite
WHERE (pg_rewrite.oid = dep.objid )) AS trueoid,
dep.refobjid
FROM pg_depend dep, pg_rewrite rew, pg_class "class"
WHERE dep.objid >= 30000
AND rew.oid = dep.objid
AND dep.refobjid = "class".oid
AND "class".relkind = 'v'
AND rew.ev_class <> dep.refobjid;
Armel
-----Message d'origine-----
De : [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] la part de Mark Carew
Envoy� : lundi 1 d�cembre 2003 10:00
� : [EMAIL PROTECTED]
Objet : Re: [ADMIN] Problem with pg_dump / pg_restore
Hi Armel,
Why not do a structure only dump to plain text and see if you can use
that as your start .sql ext file for 'psql -e .. etc'. Eliminates the
necessity to have an active client side data dictionary. BTW, your english
is fine.
Regards
markcarew@
magicwanddept.com.au
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
