SEO

#1 (**permalink**) 04-09-2008, 11:22 PM

if a function includes this SQL:

Update Table1 Set field_1 = 'ab';
Insert Table2(field_2) VALUES('cd');

and I create an update trigger on Table1:

Create Trigger Table1_Update AFTER Update
On Table1 FOR EACH ROW:

Select * From Table2

will the Select statement in the trigger see the row that I inserted
in the main function?
if not, is there another way to write these statements to that it does?

thanks

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#2 (**permalink**) 04-09-2008, 11:22 PM

Question answered- needed to move Insert statement before Update in
main function.

On Fri, Mar 21, 2008 at 6:42 PM, Postgres User
<postgres.developer@gmail.com> wrote:
> if a function includes this SQL:
>
> Update Table1 Set field_1 = 'ab';
> Insert Table2(field_2) VALUES('cd');
>
>
> and I create an update trigger on Table1:
>
> Create Trigger Table1_Update AFTER Update
> On Table1 FOR EACH ROW:
>
> Select * From Table2
>
>
> will the Select statement in the trigger see the row that I inserted
> in the main function?
> if not, is there another way to write these statements to that it does?
>
> thanks
>

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Trigger transactions