PGAdmin III - string literal parse error entering functions

From: "Michael Foy" <Michael(dot)C(dot)Foy(at)noaa(dot)gov>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: PGAdmin III - string literal parse error entering functions
Date: 2003-10-29 21:12:23
Message-ID: DFCF49747CB1DD48A2119FBD9BACB8B9138E70@moon.fsl.noaa.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2003-10-30 08:30:31 Re: [GENERAL] pgAdmin vs SQL Server Enterprise Manager
Previous Message timothy.r.morley 2003-10-29 18:51:09 Re: Connnection to SSL enabled server