From: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Postgres Triggers issue |
Date: | 2010-02-11 07:06:55 |
Message-ID: | 20100211070655.GB10411@a-kretschmer.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
In response to u235sentinel :
> I have a strange problem we noticed the other day with triggers. We're
> running 8.3.3 on Solaris 10 (intel) and have a feed that comes in
> regularly to populate a table we're working on. The feed works just
> fine inserting rows however the following trigger stops the feed until
> we remove the trigger. Any thoughts on what I'm doing wrong here?
>
> Thanks!
>
> ---
>
> CREATE OR REPLACE FUNCTION r.m_t()
> RETURNS trigger AS
> $BODY$
> BEGIN
> INSERT INTO temp_m_t VALUES (NEW.*,1+1);
> RETURN NULL;
> END;
> $BODY$
> LANGUAGE 'plpgsql';
>
>
> CREATE TRIGGER tafter
> AFTER INSERT OR UPDATE
> ON r.m_a
> FOR EACH ROW
> EXECUTE PROCEDURE r.m_t();
What exactly happens?
Something similar works for me:
test=# create table a(i int);
CREATE TABLE
test=*# create table b(i int, other_column int);
CREATE TABLE
test=*# create or replace function f() returns trigger as $$begin insert into b values (new.*, 5); return null; end;$$ language plpgsql;
CREATE FUNCTION
test=*# create trigger trg1 after insert or update on a for each row execute procedure f();
CREATE TRIGGER
test=*# insert into a values (1);
INSERT 0 1
test=*# select * from b;
i | other_column
---+--------------
1 | 5
(1 row)
Regards, Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431 2EB0 389D 1DC2 3172 0C99
From | Date | Subject | |
---|---|---|---|
Next Message | Balma Robin Gordon | 2010-02-11 09:43:26 | Using xpath queries against XML Datatype |
Previous Message | u235sentinel | 2010-02-11 04:15:51 | Postgres Triggers issue |