Re: 8.1 and syntax checking at create time

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com>
Cc: Michael Fuhr <mike(at)fuhr(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: 8.1 and syntax checking at create time
Date: 2005-08-31 19:37:21
Message-ID: 431606F1.9020308@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tony Caduto wrote:

> Hi,
>
> I did restore from a 8.0 dump.
>
[snip]

> I am trying my tests on a new database with fresh language install now.
>
> How can I get my restored databases to behave the same as a fresh one?
>
>

Run "createlang plpgsql mydb" before running your restore, and possibly
remove the bits that create them from the dump script, or they might
just fail benignly.

cheers

andrew

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim C. Nasby 2005-08-31 19:38:16 Re: 8.1 and syntax checking at create time
Previous Message Tony Caduto 2005-08-31 19:35:21 Re: 8.1 and syntax checking at create time