Re: Lost plpgsql function

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: lnd(at)hnit(dot)is
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Lost plpgsql function
Date: 2004-01-22 00:04:56
Message-ID: 2115.1074729896@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<lnd(at)hnit(dot)is> writes:
> After copied pg database from one PC to another
> -I could not find plpgsql function(s) in the copied database.
> -had to instal plpgsql language handler again

Please define "could not find plpgsql function(s)". What *exactly*
did you do, and what exact error messages did you get?

The theory in the back of my mind is that you had the plpgsql handler
function defined using the old method of specifying an absolute path
to plpgsql.so, and that the correct path on the new machine was
something different.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2004-01-22 00:12:56 Re: postgresql + apache under heavy load
Previous Message scott.marlowe 2004-01-21 23:54:26 Re: varchar_pattern_ops in 7.3.4?