| From: | alfranio correia junior <alfranio(at)lsd(dot)di(dot)uminho(dot)pt> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | PLPG |
| Date: | 2006-11-28 14:04:32 |
| Message-ID: | 456C41F0.8000909@lsd.di.uminho.pt |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
How do I create a PLPG procedure by means of a statement ?
For instance:
private static String createFunction = "CREATE OR REPLACE FUNCTION
process_audit_customer() RETURNS TRIGGER AS \n"
+ "$process_audit$ \n"
+ "BEGIN \n"
+ "IF (TG_OP = 'DELETE') THEN \n"
+ "INSERT INTO tmp_customer SELECT OLD.*, 'D', now(), user\\; \n"
+ "RETURN OLD\\; \n"
+ "ELSIF (TG_OP = 'UPDATE') THEN \n"
+ "INSERT INTO tmp_customer SELECT OLD.*, 'U', now(), user\\; \n"
+ "RETURN NEW\\; \n"
+ "ELSIF (TG_OP = 'INSERT') THEN \n"
+ "INSERT INTO tmp_customer SELECT NEW.*, 'I', now(), user\\; \n"
+ "RETURN NEW\\; \n"
+ "END IF\\; \n"
+ "RETURN NULL\\; \n"
+ "END\\; \n"
+ "$process_audit$ \n" + "LANGUAGE plpgsql SECURITY DEFINER;";
When I try to execute such statement an exception is raised:
ERROR: unterminated dollar-quoted string at or near "$process_audit$
BEGIN
IF (TG_OP = 'DELETE') THEN
INSERT INTO tmp_customer SELECT OLD.*, 'D', now(), user
Does anybody have a suggestion ?
Regards,
Alfranio.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Cramer | 2006-11-28 14:17:24 | Re: PLPG |
| Previous Message | Ingmar Lötzsch | 2006-11-28 09:46:31 | Re: PreparedStatement and TYPE bit |