Thank you very much to everyone, it worked
-Original Message-
From: Khangelani Gama [mailto:kg...@argility.com]
Sent: Thursday, May 22, 2014 3:01 PM
To: 'Igor Neyman'; 'Andrew Sullivan'; 'pgsql-general@postgresql.org'
Subject: RE: [GENERAL] Need help on t
On 05/22/2014 06:01 AM, Khangelani Gama wrote:
Many Thanks, I will try it now
In the link I sent previously:
http://www.postgresql.org/docs/9.3/interactive/plpgsql-trigger.html
there is a handy section (40.9.1. Triggers on data changes) that
explains what information is available to a plpgs
Many Thanks, I will try it now
-Original Message-
From: Igor Neyman [mailto:iney...@perceptron.com]
Sent: Thursday, May 22, 2014 2:55 PM
To: Khangelani Gama; Andrew Sullivan; pgsql-general@postgresql.org
Subject: RE: [GENERAL] Need help on triggers - postgres 9.1.2
> > -Or
On Thu, May 22, 2014 at 02:48:48PM +0200, Khangelani Gama wrote:
> > CREATE OR REPLACE FUNCTION check_center_changes() RETURNS TRIGGER AS
> > $center_changed$
> >
> > BEGIN
> >
> > IF (TG_OP = 'UPDATE') THEN
> > INSERT INTO center_changed SELECT c_cde, now();
PostgreSQL probab
> > -Original Message-
> > From: Khangelani Gama [mailto:kg...@argility.com]
> > Sent: Thursday, May 22, 2014 9:38 AM
> > To: 'Adrian Klaver'; 'pgsql-general@postgresql.org'
> > Subject: RE: [GENERAL] Need help on triggers - postgres 9.1.
Thanks , I will try that
-Original Message-
From: Raymond O'Donnell [mailto:r...@iol.ie]
Sent: Thursday, May 22, 2014 2:54 PM
To: Khangelani Gama; Andrew Sullivan; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Need help on triggers - postgres 9.1.2
On 22/05/2014 13:48, Khang
On 22/05/2014 13:48, Khangelani Gama wrote:
> Hi
>
> My problem is on two lines, INSERT statements, I get an error saying c_cde
> does not exist
>
> INSERT INTO center_changed SELECT c_cde, now(); - My problem is here: I
> get an error saying c_cde does not exist, I cant how I can give
You nee
ts. Center table has got many rows so I need
to only get c_cde for only the row that was inserted.
-Original Message-
From: Andrew Sullivan [mailto:a...@crankycanuck.ca]
Sent: Thursday, May 22, 2014 2:39 PM
To: Khangelani Gama
Subject: Re: [GENERAL] Need help on triggers - postgres 9.1.2
Please help
-Original Message-
From: Khangelani Gama [mailto:kg...@argility.com]
Sent: Thursday, May 22, 2014 9:38 AM
To: 'Adrian Klaver'; 'pgsql-general@postgresql.org'
Subject: RE: [GENERAL] Need help on triggers - postgres 9.1.2
Hi all
Something it's t
check_center_changes();
-Original Message-
From: Khangelani Gama [mailto:kg...@argility.com]
Sent: Wednesday, May 21, 2014 9:34 PM
To: 'Adrian Klaver'; 'pgsql-general@postgresql.org'
Subject: RE: [GENERAL] Need help on triggers - postgres 9.1.2
Thank you very m
Thank you very much, I will have a look.
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Wednesday, May 21, 2014 3:20 PM
To: Khangelani Gama; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Need help on triggers - postgres 9.1.2
On 05/21/2014 02:54 AM
On 05/21/2014 02:54 AM, Khangelani Gama wrote:
Hi
I have a postgres 9 database, inside this database I need to create a
new table called *center_changed* that gets inserted by any change that
take place in a table called *center*. So I need to create trigger to do
this.
*Example: *
Table name*
Hi
I have a postgres 9 database, inside this database I need to create a new
table called *center_changed* that gets inserted by any change that take
place in a table called *center*. So I need to create trigger to do this.
*Example: *
Table name*: center*(c_cde, c_dsc, ops_cde, grp_cde);
13 matches
Mail list logo