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