From: | Sandeep Joshi <sjoshi(at)Zambeel(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | what is wrong? |
Date: | 2000-12-14 21:10:40 |
Message-ID: | 3A393750.2886C5D4@zambeel.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I am trying to use "triggers". I get following error:
create function insert_into_db2 RETURNS int AS
'/work/posgresql/lib/libpq.so' language 'C';
create trigger trial before insert or update on db1user for each row
execute procedure insert_into_db2();
ERROR: CreateTrigger: function insert_into_db2() must return OPAQUE
Does anybody know why?
Also, if a function is enforced to return OPAQUE then what is the
"RETURNS" clause?
One more question,
If a trigger does not succeed then I want to ABORT transaction, is
it possible? how?
- Sandeep
From | Date | Subject | |
---|---|---|---|
Next Message | Diego A. Puertas F. | 2000-12-14 21:22:42 | Re: Accessing PSQL database with MS Access via ODBC |
Previous Message | John Burski | 2000-12-14 21:06:15 | Re: |