Lost plpgsql function - Mailing list pgsql-general

From
Subject Lost plpgsql function
Date
Msg-id 0A5B2E3C3A64CA4AB14F76DBCA76DDA44E2CD5@seifur.hnit.is
Whole thread Raw
Responses Re: Lost plpgsql function  ("Uwe C. Schroeder" <uwe@oss4u.com>)
Re: Lost plpgsql function  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Lost plpgsql function  (Richard Huxton <dev@archonet.com>)
List 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

pgsql-general by date:

Previous
From: Alex Madon
Date:
Subject: Re: postgresql + apache under heavy load
Next
From: Andrew Sullivan
Date:
Subject: Re: embedded/"serverless" (Re: serverless postgresql)