|
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 |
