Hi everybody this has happened to me for first time, i did a ./pg_dump uescc > uescc.sql and then enter in ./psql uescc2 and run \i uescc.sql.
and when the script was running occur an error telling me that the relation bec_t_saldofavor does not exist. so i look for it in the script and it already exist in the script but the the create table was after a create view that uses that table. so pg_dump wasn't able to determine that dependency. regards, Jaime Casanova _________________________________________________________ Do You Yahoo!? Información de Estados Unidos y América Latina, en Yahoo! Noticias. Visítanos en http://noticias.espanol.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
