Lost plpgsql function

From: <lnd(at)hnit(dot)is>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Lost plpgsql function
Date: 2004-01-21 22:29:19
Message-ID: 0A5B2E3C3A64CA4AB14F76DBCA76DDA44E2CD5@seifur.hnit.is
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

-whilst tables and data moved fine

The copy included all under /cygwin/usr/local/pgsql/data and database was
down while making a copy.

What could I forget to copy as far plpgsql is concerned ?
Are pgsql stored objects stored in the database itself (a table pg_proc,
column prosrc)?
Catalog tables like pg_proc are just a part of database cluster data files,
aren't they?

Thank you in advance, Laimis

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2004-01-21 22:31:12 Re: embedded/"serverless" (Re: serverless postgresql)
Previous Message Alex Madon 2004-01-21 22:20:24 Re: postgresql + apache under heavy load