Dumps/Reloads

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.
emayo@pozicom.net