Adrian Klaver wrote:
On Thursday 11 February 2010 1:57:39 am Albe Laurenz wrote:
u235sentinel wrote:
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.
Adrian Klaver wrote:
Well that would depend on any number of factors. Without information
on how the feed is being done or more detailed logs it is hard to say
for sure. At a guess though, I would say it is because the 'feed' is
being done wrapped in a transaction and when the trigger errors
On 02/11/2010 11:08 AM, u235sentinel wrote:
Trigger function for an insert/update trigger should return "NEW", not
NULL (OLD - for "on delete" trigger):
It's an AFTER TRIGGER, so the RETURN-Value ignored.
According the doc:
The return value of a BEFORE or AFTER statement-level trigger or an
Trigger function for an insert/update trigger should return "NEW", not
NULL (OLD - for "on delete" trigger):
It's an AFTER TRIGGER, so the RETURN-Value ignored.
According the doc:
The return value of a BEFORE or AFTER statement-level trigger or an
AFTER row-level trigger is always
A. Kretschmer wrote:
> In response to Igor Neyman :
> > >
> > > CREATE TRIGGER tafter
> > > AFTER INSERT OR UPDATE
> > > ON r.m_a
> > > FOR EACH ROW
> > > EXECUTE PROCEDURE r.m_t();
> > >
> > >
> >
> > Trigger function for an insert/update trigger should return "NEW", not
> > NULL (OLD - for
In response to Igor Neyman :
> >
> > CREATE TRIGGER tafter
> > AFTER INSERT OR UPDATE
> > ON r.m_a
> > FOR EACH ROW
> > EXECUTE PROCEDURE r.m_t();
> >
> >
>
> Trigger function for an insert/update trigger should return "NEW", not
> NULL (OLD - for "on delete" trigger):
It's an AFTER TRIGGER, s
> -Original Message-
> From: u235sentinel [mailto:u235senti...@gmail.com]
> Sent: Wednesday, February 10, 2010 11:15 PM
> To: pgsql-general@postgresql.org
> Subject: Postgres Triggers issue
>
> I have a strange problem we noticed the other day with
> triggers. We're running 8.3.3 on So
On Thursday 11 February 2010 1:57:39 am Albe Laurenz wrote:
> u235sentinel wrote:
> > 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
u235sentinel wrote:
> 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 th
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 tri
10 matches
Mail list logo
