Re: [GENERAL] Trigger problems/questions

2017-06-15 Thread Jim Fulton
On Thu, Jun 15, 2017 at 1:56 PM, Tom Lane wrote: > Jim Fulton writes: > > I have an object database that's mirrored to a table with data in a JSONB > > column. Data are organized into "communities". Community ids aren't > > stored directly in content but can be found by recursively following >

Re: [GENERAL] Trigger problems/questions

2017-06-15 Thread Tom Lane
Jim Fulton writes: > I have an object database that's mirrored to a table with data in a JSONB > column. Data are organized into "communities". Community ids aren't > stored directly in content but can be found by recursively following > __parent__ properties. I want to be able to index content

Re: [GENERAL] Trigger problems/questions

2017-06-15 Thread Jim Fulton
On Thu, Jun 15, 2017 at 1:44 PM, Adrian Klaver wrote: > On 06/15/2017 10:23 AM, Jim Fulton wrote: > ... > I do not pretend to fully understand what the the triggers/functions are > really doing, but I did notice this: > > create or replace function populate_community_zoid_triggerf() > > ... >

Re: [GENERAL] Trigger problems/questions

2017-06-15 Thread Adrian Klaver
On 06/15/2017 10:23 AM, Jim Fulton wrote: I have an object database that's mirrored to a table with data in a JSONB column. Data are organized into "communities". Community ids aren't stored directly in content but can be found by recursively following __parent__ properties. I want to be able

[GENERAL] Trigger problems/questions

2017-06-15 Thread Jim Fulton
I have an object database that's mirrored to a table with data in a JSONB column. Data are organized into "communities". Community ids aren't stored directly in content but can be found by recursively following __parent__ properties. I want to be able to index content records on their community i

Re: [GENERAL] Trigger Problems

2004-11-30 Thread gnari
From: "Jamie Deppeler" <[EMAIL PROTECTED]> > Hi , i have designed a trigger function called test2(Integer) the trigger function must be declared without arguments http://scripts.postgresql.org/docs/7.4/static/triggers.html#TRIGGER-DEFINITI ON gnari ---(end of broad

Re: [GENERAL] Trigger Problems

2004-11-30 Thread Jim C. Nasby
That is probably because you created test2(INTEGER) and you're trying to call test2(TEXT). On Wed, Dec 01, 2004 at 11:22:41AM +1100, Jamie Deppeler wrote: > Hi , i have designed a trigger function called test2(Integer) > > im trying to use it with a trigger but get errors that function cannot >

[GENERAL] Trigger Problems

2004-11-30 Thread Jamie Deppeler
Hi , i have designed a trigger function called test2(Integer) im trying to use it with a trigger but get errors that function cannot be found Trigger statement is CREATE TRIGGER "new_trigger566" BEFORE INSERT ON "customer" FOR EACH ROW EXECUTE PROCEDURE test2("primary"); get the error test2() can

Re: [GENERAL] Trigger Problems?

2000-12-07 Thread GH
> -Original Message- > From: Darrin Ladd <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> > Date: Wednesday, December 06, 2000 12:03 PM > Subject: [GENERAL] Trigger Problems? > > > Hello, > >

Re: [GENERAL] Trigger Problems?

2000-12-07 Thread Darrin Ladd
ete these triggers or if this is a bug.  Either way, I learned something new.   Thanks, Darrin -Original Message-From: Darrin Ladd <[EMAIL PROTECTED]>To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>Date: Wednesday, December 06, 2000 12:03 PMSubject: [GENERAL]