Re: Moving a database between servers

Unfortunately I do not have the ability to update to
7.4, although I did try the quick "hack." It worked
for a few functions but later on in the import it
begins to say that current_transaction does not exist
again. Could you think of any reasonf or this? I
don't see any sort of DROP/DELETE for this table.
(The one I added as a hack to get everytihng to import
correctly, that is...)

Appreciate the help,
Mike
--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Michael ." <phifli(at)yahoo(dot)com> writes:
> > [ SQL function that references a TEMP table ]
>
> > How do I get these functions to import correctly
> if it
> > fails due to this "current_transaction" table not
> > being found?
>
> I don't think there is any good solution in 7.3,
> because it will insist
> on trying to validate the function body. A hack
> workaround is to create
> the "current_transaction" table (as a plain, not
> TEMP, table), then
> import your dump, then drop the table.
>
> 7.4 has a better solution (you can turn off function
> body checking in
> CREATE FUNCTION), and 7.4's pg_dump will use it.
>
> regards, tom lane
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

__________________________________
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/