From: | Greg Youngblood <YoungblG(at)houstoncellular(dot)com> |
---|---|
To: | "'PostgreSQL General List'" <pgsql-general(at)postgresql(dot)org>, "'PostgreSQL SQL List'" <pgsql-sql(at)postgresql(dot)org>, "'PostgreSQL Novice List'" <pgsql-novice(at)postgresql(dot)org> |
Subject: | HELP: Problems with triggers and sql functions |
Date: | 1998-12-31 19:33:54 |
Message-ID: | 2B9713A99045D211BB4E0008C75668692EA792@SCORPEXC1.houstoncell.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
I am having a problem getting a trigger created and I'm sure it is a
simple/stupid mistake, yet nothing I read, nor nothing I try, seems to let
me create this trigger.
Postgres 6.4 (from the 6.4.1 OOPS distribution) on Linux 2.0.35 SMP.
Sample table tab1:
a b c
xyz stuff here Y
abc more stuff N
Sample table tab2:
l a g
name xyz Y
aname xyz Y
where a is char(16); b is varchar(250); c is char(1); l is char(8); and, g
is char(1).
create function update_tab2 () returns int4 as 'insert into tab2 (l,a,g)
select distinct a.l,b.a,b.c from tab2 a,tab1 b where b.a not in (select
distinct a from tab2); select 1 as exitvalue;' language 'sql';
The function creates properly.
Here's the goal. If and when tab1 has a new value inserted into it, tab2
should be updated according to function update_tab2.
Using the above samples, if I run:
select update_tab2();
I get:
exitvalue
------------
1
and then: select * from tab2;
yields:
l a g
name xyz Y
aname xyz Y
name abc N
aname abc N
which is correct.
So, I try this:
create trigger new_tab1_a after insert on tab1 for each row execute
procedure update_tab2 ();
generates:
ERROR: CreateTrigger: function update_tab2 () does not exist.
I have also tried changing the function and trigger to pass an int4 value.
If I run the function manually, it all works, but I can't get the trigger to
create.
Does anyone have any ideas or advice? This is really frustrating.
Thanks
Greg
Gregory S. Youngblood
ext 2164
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Chalmers | 1999-01-01 23:13:05 | There's now two!! opps. Re: mysql: ANNOUNCEMENT: sql-general mailing list |
Previous Message | Simon Drabble | 1998-12-31 18:39:24 | libpq wrapper |
From | Date | Subject | |
---|---|---|---|
Next Message | Tim Perdue, The Des Moines City.net | 1999-01-02 01:34:00 | SELECT DISTINCT |
Previous Message | Bruce Momjian | 1998-12-31 17:22:31 | Re: [SQL] html table output of table space |