Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group