| 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: | Whole Thread | Raw Message | 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
| 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 |