Re: Intentando hacer un insert con un trigger.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Solucionado.

Era un error en la declaración de campos en el insert.

create or replace function permisosrecursos() returns trigger as $$
begin
insert into permisosrecursos(recurso,grupo) values((select id from
recursos),new.id);
return new;
end;

$$ language plpgsql;

create trigger permisosrecursos after insert on gruposusuarios for each
row execute procedure permisosrecursos();

Así funciona perfectamente.

- --

< ¡¡Nos vemos!! >
----------------------------
\
\
.::!!!!!!!:.
.!!!!!:. .:!!!!!!!!!!!!
~~~~!!!!!!. .:!!!!!!!!!UWWW$$$
:$$NWX!!: .:!!!!!!XUWW$$$$$$$$$P
$$$$$##WX!: .<!!!!UW$$$$" $$$$$$$$#
$$$$$ $$$UX :!!UW$$$$$$$$$ 4$$$$$*
^$$$B $$$$\ $$$$$$$$$$$$ d$$R"
"*$bd$$$$ '*$$$$$$$$$$$o+#"
"""" """""""
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFHjzEYK7lGsMchFswRAuy8AJ469uQofezJTEJn3ps/fWU5L0/ffQCeLM5j
D5hvlK0EdyhanXAB5DxsLuE=
=aqic
-----END PGP SIGNATURE-----