pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Postgres Triggers issue
2+ messages / 2 participants
[nested] [flat]

* Postgres Triggers issue
@ 2010-02-11 04:13  u235sentinel <u235sentinel@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: u235sentinel @ 2010-02-11 04:13 UTC (permalink / raw)
  To: pgsql-admin

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();




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Postgres Triggers issue
@ 2010-02-11 05:51  Tom Lane <tgl@sss.pgh.pa.us>
  parent: u235sentinel <u235sentinel@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2010-02-11 05:51 UTC (permalink / raw)
  To: u235sentinel@gmail.com; +Cc: pgsql-admin

u235sentinel <u235sentinel@gmail.com> writes:
> 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?

This really isn't enough information for anybody to help you.  The
rest of us don't know what you mean by a "feed", let alone how a trigger
might stop it.  Tell us what's happening at the level of SQL commands.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2010-02-11 05:51 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-02-11 04:13 Postgres Triggers issue u235sentinel <u235sentinel@gmail.com>
2010-02-11 05:51 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox