PGAdmin III - string literal parse error entering functions - Mailing list pgadmin-support

From Michael Foy
Subject PGAdmin III - string literal parse error entering functions
Date
Msg-id DFCF49747CB1DD48A2119FBD9BACB8B9138E70@moon.fsl.noaa.gov
Whole thread Raw
List pgadmin-support
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">All,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">  Thanks for the great product.</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">  When entering functions to create a trigger using the create trigger dialog like the one below. 
Youhave to use three single quotes instead of two to enclose string literals.  Either this should be documented if it
isthe correct way to do this, or it should work with two like the pg docs denote.  Hope this helps.</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Courier New" size="2"><span style="font-size:10.0pt;
font-family:"Courier New""> BEGIN</span></font><p class="MsoNormal"><font face="Courier New" size="2"><span
style="font-size:10.0pt;
font-family:"Courier New"">   PERFORM lo_unlink(OLD.class);</span></font><p class="MsoNormal"><font face="Courier New"
size="2"><spanstyle="font-size:10.0pt; 
font-family:"Courier New"">   IF NOT FOUND THEN </span></font><p class="MsoNormal"><font face="Courier New"
size="2"><spanstyle="font-size:10.0pt; 
font-family:"Courier New"">     RAISE EXCEPTION '''Large Object Cannot Be Removed''';</span></font><p
class="MsoNormal"><fontface="Courier New" size="2"><span style="font-size:10.0pt; 
font-family:"Courier New"">   END IF;</span></font><p class="MsoNormal"><font face="Courier New" size="2"><span
style="font-size:10.0pt;
font-family:"Courier New"">   RETURN NULL;</span></font><p class="MsoNormal"><font face="Courier New" size="2"><span
style="font-size:10.0pt;
font-family:"Courier New""> END;</span></font><p class="MsoNormal"><font face="Courier New" size="2"><span
style="font-size:10.0pt;
font-family:"Courier New""> </span></font><p class="MsoNormal"><font face="Courier New" size="2"><span
style="font-size:10.0pt;
font-family:"Courier New"">Platform information:</span></font><p class="MsoNormal"><font face="Courier New"
size="2"><spanstyle="font-size:10.0pt; 
font-family:"Courier New"">Pagadmin III version 1.0.1 running on Windows XP service pack 1</span></font><p
class="MsoNormal"><fontface="Courier New" size="2"><span style="font-size:10.0pt; 
font-family:"Courier New"">Postgresql 7.3 running on redhat linux 7.3</span></font><p class="MsoNormal"><font
face="CourierNew" size="2"><span style="font-size:10.0pt; 
font-family:"Courier New""> </span></font><p class="MsoNormal"><font face="Courier New" size="2"><span
style="font-size:10.0pt;
font-family:"Courier New""> </span></font><p class="MsoNormal"><font face="Courier New" size="2"><span
style="font-size:10.0pt;
font-family:"Courier New"">  Mike Foy</span></font></div>

pgadmin-support by date:

Previous
From: timothy.r.morley@kc.frb.org
Date:
Subject: Re: Connnection to SSL enabled server
Next
From: "Sachintana"
Date:
Subject: Error Message: ERROR: DROP DATABASE: database is marked as a template