8.0.0beta2 and plpgsql

[Stefano Bonnin]

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 EACHROW EXECUTE PROCEDURE sns_action();

The table is:

Table "public.SNS_DAT A"
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_Cam pione | 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_datacodluo go2" btree ("Cod_Luogo" )
"sns_datatimefi eld2" btree ("Data_Arrivo_C ampione")
"sns_siteid 2" 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_M is","Cod_Luogo" ,"Data_Arrivo_C ampione",site_i d,hash) VALUES ('24359','2004-09-11 03:00:0057',19. 8,'Temperatura media []','°C','57',tim estamp '2004-09-11 03:00:00',1,-574156802);

Thanks in advance for the help.
RedS

[Alvaro Herrera]

On Thu, Sep 16, 2004 at 05:43:55PM +0200, Stefano Bonnin wrote:

CORRECTION,

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

And this is causing a segfault? Most likely your installation is
broken. Try a make distclean and a full rebuild. And make sure it's
not referencing libraries of some other installation.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
Essentially, you're proposing Kevlar shoes as a solution for the problem
that you want to walk around carrying a loaded gun aimed at your foot.
(Tom Lane)
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)