| From: | joepie Platteau <joepie(dot)Platteau(at)kulak(dot)ac(dot)be> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
| Subject: | copy old row trigger |
| Date: | 2002-12-14 13:28:15 |
| Message-ID: | 3DFB31EF.5040004@kulak.ac.be |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-novice |
Hi,
I have the following problem :
I have 2 tables : T-Alumni and T-AlumniB (exact copy of Alumni, except
3 extra columns : user, date, time)
On events 'update' and 'delete' in table Alumni, I want to copy the old
row to AlumniB and add the username, date and time.
So I created a function :
CREATE FUNCTION trigfunc_add_alumni() RETURNS opaque AS '
begin
insert into T-Alumni-B values (old.Id_Person, old.Member,
old.Payed, old.Nr, old.Alumninr, old.Acyear, old.Styear);
return NULL;
end;
' LANGUAGE 'plpgsql';
Then I wanted to create a trigger using this function with the properties :
Table T-Alumni
Executes AFTER
Event UPDATE, DELETE
For each ROW
Function trigfunc_add_alumni()
Then I get the error :
An error has occurred in pgAfdmin II:frmTrigger.cmdOK_Click : Number 5
Description : Invalid procedure call or argument
Can someone tell me what i'm doing wrong? Or is there another better
solution for this problem?!
Thanks!!
Joepie Platteau.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Igor Georgiev | 2002-12-14 15:31:58 | Re: [GENERAL] PostgreSQL Global Development Group |
| Previous Message | mlw | 2002-12-14 13:26:51 | Re: [GENERAL] PostgreSQL Global Development Group Announces |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mat Rice | 2002-12-15 15:19:47 | Anyone using postgreSQL on Mac OS X installed by Fink? |
| Previous Message | paul butler | 2002-12-14 10:13:59 | Re: recommended reading |