8.0.0beta2 and plpgsql

From: "Stefano Bonnin" <stefano(dot)bonnin(at)comai(dot)to>
To: "Postgres General" <pgsql-general(at)postgresql(dot)org>
Subject: 8.0.0beta2 and plpgsql
Date: 2004-09-16 15:43:55
Message-ID: 037201c49c03$f994ccd0$0501a8c0@comai04
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

CORRECTION,

even if I define a stupid "hello world" trigger function the problem is present:

for example

CREATE FUNCTION sns_action () RETURNS TRIGGER AS '
BEGIN
RAISE NOTICE ''hello world!'';
RETURN NEW;
END;
' LANGUAGE 'plpgsql';

CREATE TRIGGER sns_action_tr BEFORE UPDATE OR INSERT ON "SNS_DATA" FOR EACH ROW EXECUTE PROCEDURE sns_action();

The table is:

Table "public.SNS_DATA"
Column | Type | Modifiers
----------------------+-----------------------------+--------------------
Ordine | integer | not null default 0
Cod_Par | character varying(100) | not null
Cod_Ana | character varying(100) | not null
Valore | character varying(255) |
Descriz | character varying(512) |
Un_Mis | character varying(70) |
hash | integer |
valid | boolean | default true
alarm | boolean | default false
Cod_Luogo | character varying(30) |
Data_Arrivo_Campione | timestamp without time zone |
site_id | integer |
Cod_Luogo_v | character varying(30) |
repeated_val | boolean | default false
Indexes:
"sns_data2_pkey" PRIMARY KEY, btree ("Ordine", "Cod_Ana", "Cod_Par")
"sns_datacodluogo2" btree ("Cod_Luogo")
"sns_datatimefield2" btree ("Data_Arrivo_Campione")
"sns_siteid2" btree (site_id)
"sns_valid2" btree ("valid")
"snsdata_codana" btree ("Cod_Ana")
"snsdata_codpar" btree ("Cod_Par")
Foreign-key constraints:
"$2" FOREIGN KEY ("Cod_Ana") REFERENCES "SNS_ANA"("Cod_Ana") ON DELETE CASCADE
Triggers:
sns_action_tr BEFORE INSERT OR UPDATE ON "SNS_DATA" FOR EACH ROW EXECUTE PROCEDURE sns_action()

and the insert operation is:

INSERT INTO "SNS_DATA" ("Cod_Par","Cod_Ana","Valore","Descriz","Un_Mis","Cod_Luogo","Data_Arrivo_Campione",site_id,hash) VALUES ('24359','2004-09-11 03:00:0057',19.8,'Temperatura media []','°C','57',timestamp '2004-09-11 03:00:00',1,-574156802);

Thanks in advance for the help.
RedS

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2004-09-16 15:59:04 Re: 8.0.0beta2 and plpgsql
Previous Message Shelby Cain 2004-09-16 15:27:34 Re: Not even JPEGs are safe?