Re: from "opaque" to "trigger" WARNING

[Joseph <..hidden..>]

Yes, I transferred databases from Postgresql-8.0.15 to 8.1.11
However, I'm getting the same error when saving to a backup file and restoring it on the save version 8.1.11.
I think it has something to do with postgresql.

--
Joseph


On 09/26/09 01:45, Luke wrote:
> Are you restoring between different versions of Postgresql?
>
> Luke
>
>
> On Fri, 25 Sep 2009, Joseph wrote:
>
> > Does anybody get these warnings when restoring database?
> >
> > WARNING:  changing return type of function del_yearend from "opaque" to "trigger"
> > CREATE TRIGGER
> > WARNING:  changing return type of function del_department from "opaque" to "trigger"
> > CREATE TRIGGER
> > CREATE TRIGGER
> > CREATE TRIGGER
> > CREATE TRIGGER
> > WARNING:  changing return type of function del_customer from "opaque" to "trigger"
> > CREATE TRIGGER
> > WARNING:  changing return type of function del_vendor from "opaque" to "trigger"
> > CREATE TRIGGER
> > WARNING:  changing return type of function del_exchangerate from "opaque" to "trigger"
> > CREATE TRIGGER
> > CREATE TRIGGER
> > CREATE TRIGGER
> > WARNING:  changing return type of function check_inventory from "opaque" to "trigger"
> > CREATE TRIGGER
> > WARNING:  changing return type of function check_department from "opaque" to "trigger"
> > CREATE TRIGGER
> > CREATE TRIGGER
> > CREATE TRIGGER
> > CREATE TRIGGER
> > WARNING:  changing return type of function del_recurring from "opaque" to "trigger"