| From: | Kristis Makris <kristis(dot)makris(at)datasoft(dot)com> |
|---|---|
| To: | Phuong Ma <pma(at)commandprompt(dot)com> |
| Cc: | pgsql sql <pgsql-sql(at)postgresql(dot)org>, Postgres-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: trigger on DELETE |
| Date: | 2001-07-11 23:23:48 |
| Message-ID: | 200107112323.f6BNNra16872@postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
> Ok, the function works only with a trigger that is defined as ON INSERT
> OR UPDATE. If I try to define a trigger for ON DELETE and then delete a
> row from the table, there is nothing in the 'NEW' variable to return. I
> get an error message. If I define the function to return NULL, 0, or
> nothing, then it comes up with a type mis-match error. Is there anyone
> who can help? Thanks.
Try using the OLD variable instead.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2001-07-11 23:49:06 | Re: vacuum and 24/7 uptime |
| Previous Message | Stephan Szabo | 2001-07-11 23:20:11 | Re: trigger on DELETE |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mars G Miro | 2001-07-12 00:39:30 | epoch to show millseconds |
| Previous Message | Stephan Szabo | 2001-07-11 23:20:11 | Re: trigger on DELETE |