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

All,

  Thanks for the great product.

 

  When entering functions to create a trigger using the create trigger dialog like the one below.  You have to use three single quotes instead of two to enclose string literals.  Either this should be documented if it is the correct way to do this, or it should work with two like the pg docs denote.  Hope this helps.

 

 BEGIN

   PERFORM lo_unlink(OLD.class);

   IF NOT FOUND THEN

     RAISE EXCEPTION '''Large Object Cannot Be Removed''';

   END IF;

   RETURN NULL;

 END;

 

Platform information:

Pagadmin III version 1.0.1 running on Windows XP service pack 1

Postgresql 7.3 running on redhat linux 7.3

 

 

  Mike Foy

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