Not sure how to classify this... Here is the scenario:
create database pozicom; create table employees(....); create table emppayrate(....); create function getemprate(...); If I pg_dump pozicom > /tmp/pozicom.dump then log in and \i /tmp/pozicom.dump everything works fine until. Now I need to make a change to the emppayrate table so I: drop table emppayrate; create table emppayrate(... new field or whatever).... Now if I pg_dump the database and try to import it, the function, getemprate, complains that the emppayrate table is not there! Viewing the .dump file I can see it is simply a placement issue. Moving the "create function" statement to the end and before the data corrects the problem. So, I am not sure if this is a bug or if I am over looking something. Is there a way to do the dump such that the functions are always last? Hope this helps! Sorry if this is not a bug and I am not getting something but I couldn't find any other advise. Eric Pozicom Tech. [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
