Re: [GENERAL] pg_dump and languages

2004-11-26 Thread Adrian Klaver
On Friday 26 November 2004 03:11 pm, Tom Lane wrote: > Adrian Klaver <[EMAIL PROTECTED]> writes: > > Sorry should have been more explicit. The dump loaded functions depending > > on plsh before the function that created the language. In fact it did not > > instalI the language at all. > > Ah. Look

Re: [GENERAL] pg_dump and languages

2004-11-26 Thread Tom Lane
Adrian Klaver <[EMAIL PROTECTED]> writes: > Sorry should have been more explicit. The dump loaded functions depending on > plsh before the function that created the language. In fact it did not > instalI the language at all. Ah. Looking back at your first message, I see you'd installed plsh int

Re: [GENERAL] pg_dump and languages

2004-11-26 Thread Adrian Klaver
On Friday 26 November 2004 10:26 am, Tom Lane wrote: > Adrian Klaver <[EMAIL PROTECTED]> writes: > > I used the pg_dump from Postgres 8.0beta5 to dump the data from a version > > 7.4.0 database. Both databases are located on SuSE Linux machines. The > > pg_restore to the 8.0 version went very well

Re: [GENERAL] pg_dump and languages

2004-11-26 Thread Tom Lane
Adrian Klaver <[EMAIL PROTECTED]> writes: > I used the pg_dump from Postgres 8.0beta5 to dump the data from a version > 7.4.0 database. Both databases are located on SuSE Linux machines. The > pg_restore to the 8.0 version went very well with the exception of the > languages. I have plpgsql and

[GENERAL] pg_dump and languages

2004-11-25 Thread Adrian Klaver
I used the pg_dump from Postgres 8.0beta5 to dump the data from a version 7.4.0 database. Both databases are located on SuSE Linux machines. The pg_restore to the 8.0 version went very well with the exception of the languages. I have plpgsql and plsh installed in the 7.4.0 database. pg_dump han