Re: lo function changed in PostgreSQL 8.1.1

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Premsun Choltanwanich" <Premsun(at)nsasia(dot)co(dot)th>
Cc: "Richard Huxton" <dev(at)archonet(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: lo function changed in PostgreSQL 8.1.1
Date: 2005-12-14 15:06:33
Message-ID: 19290.1134572793@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Premsun Choltanwanich" <Premsun(at)nsasia(dot)co(dot)th> writes:
> I think I use contrib/lo type for manage lo. What is wrong?

You need to use the 8.1 version of contrib/lo, not any previous version.

You might find that the easiest way to manage this is to create an empty
database, load the 8.1 contrib/lo definitions by running lo.sql, then
restoring from your pg_dump backup. You'll see some complaints about
duplicate function definitions but these can be ignored.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-12-14 15:15:42 Re: ANSI SQL, CASE expression Conformance F262, F263 any info
Previous Message Tom Lane 2005-12-14 15:01:47 Re: Immodest Proposal: pg_catalog.pg_ddl