[gnome-db] Triggers support

[Jean-Michel POURE <jm poure freesurf fr>]

Le Vendredi 13 Décembre 2002 14:08, Rodrigo Moya a écrit :
> yes. Could you please come to a list of fields that should be returned
> for the triggers schema? (that is, as with the other schemas
> (http://www.gnome-db.org/docs/libgda/libgda-provider-class.html#LIBGDA-PROV
>IDER-GET-SCHEMA)

http://www.postgresql.org/idocs/ is a good place to query PostgreSQL 
documentation.

1) Create trigger
http://www.postgresql.org/idocs/index.php?sql-createtrigger.html

CREATE TRIGGER trigger [ BEFORE | AFTER ] [ INSERT | DELETE | UPDATE [ OR ... 
] ] ON relation FOR EACH [ ROW | STATEMENT ] EXECUTE PROCEDURE procedure 
(args);

2) Drop trigger
http://www.postgresql.org/idocs/index.php?sql-droptrigger.html
DROP TRIGGER name ON table

3) Alter trigger
Not supported. Per discussion on hackers, clients should handle DROP/CREATE as 
there is no need to preserve object ID.

4) Additionnaly, PostgreSQL 7.3 allows to enable / disable triggers.

5) More general request : additional information in libgda (additional field 
carrying serialized data).

Would it be possible for libgda to return an "additional" field for each 
object ? This field would carry special information serialized one way or 
another (XML?). This would provide more consistency for extending data 
providers.

Example : PLpgSQL is installed by default in PostgreSQL. Additional languages 
need to be installed manually. The database provider for PostgreSQL could 
return the list of installed languages in an "additional" field. There are 
many other examples where an addition field carrying serialized data would be 
useful.

Cheers to you all,
Jean-Michel POURE