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

Re: Error restoring

From: John DeSoi <desoi(at)pgedit(dot)com>
To: Partners - Majolee InfoTech <info(at)majolee(dot)info>
Cc: <pgsql-php(at)postgresql(dot)org>
Subject: Re: Error restoring
Date: 2005-09-28 17:15:51
Message-ID: E89CF710-1318-4388-B494-3884224CDC53@pgedit.com (view raw or flat)
Thread:
Lists: pgsql-php
On Sep 28, 2005, at 3:36 AM, Partners - Majolee InfoTech wrote:

> now at a different machine we are trying to restore but the plpgsql  
> functions are having $_$ after "as" and after "end;". This is  
> causing errors while restoring. Do anyone know how to get rid of  
> this easily.

Dollar quoting was not implemented until PostgreSQL 8.0. Are you  
trying to restore to an earlier version? If so you have to change the  
$_$ to single quotes and then appropriately escape any quotes in the  
function body.



John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL


In response to

pgsql-php by date

Next:From: enzo venegas palaciosDate: 2005-09-28 22:00:20
Subject: exec format
Previous:From: Toon van DoornDate: 2005-09-28 14:33:40
Subject: Re: postmaster does not start

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