SOS POSTGRES

• Schalk van der Merwe

  SSC Veteran

  Points: 254

  More actions

  June 27, 2005 at 7:03 am

  #164990

  In Postgres when I try to create a trigger this way

  CREATE          TRIGGER ins_all_environment_master AFTER INSERT OR UPDATE

  on alpha.all_environment_master

     DECLARE

     v_ls_so  VARCHAR(10);

  Why do I get the following error

  ERROR:  syntax error at or near "DECLARE" at character 115.

  Can anyone help?

  Thanks

  Schalk

   

   

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  June 27, 2005 at 7:08 am

  #568560

  I never used POSTGRES, but in sql server you must have the "as" keyword in there :

  FOR INSERT, UPDATE, DELETE

  AS

  Declare....

• Schalk van der Merwe

  SSC Veteran

  Points: 254

  More actions

  June 27, 2005 at 7:10 am

  #568561

  Thanks, but that doesn't work.

  SOS

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  June 27, 2005 at 7:25 am

  #568566

  Can't find anything... but then again I don't know where to look.

• sql92

  SSC Enthusiast

  Points: 114

  More actions

  June 27, 2005 at 7:37 am

  #568570

  http://www.dbforums.com/f81

• Schalk van der Merwe

  SSC Veteran

  Points: 254

  More actions

  June 27, 2005 at 8:20 am

  #568615

  Thanks, will have a look

  If you have any information before I subscribe I would appreciate!