subject:"\[SQL\] My Trigger is not working \:\("

Re: [SQL] My Trigger is not working :(

2011-09-09 Thread Waqar Azeem

Thanks... After putting some code here ... starts getting this error ... SQL statement "INSERT INTO ad_changelog( ad_changelog_id, ad_session_id, ad_table_id, ad_column_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, record_id, oldvalue, newvalue, undo, redo, iscusto

Re: [SQL] My Trigger is not working :(

2011-09-09 Thread pasman pasmański

DECLARE section not contain variable AD_TABLE_ID 2011/9/9, Waqar Azeem : > I think i missed some basics ... > > > ERROR: column "ad_table_id" does not exist > Where: PL/pgSQL function "oms_changelog" line 21 at assignment > > -- > trigger definition >

[SQL] My Trigger is not working :(

2011-09-09 Thread Waqar Azeem

I think i missed some basics ... ERROR: column "ad_table_id" does not exist Where: PL/pgSQL function "oms_changelog" line 21 at assignment -- trigger definition -- CREATE OR REPLACE FUNCTION oms_changelog() RETURNS trigger AS $BODY$ DECLAR