On Mon, 11 Aug 2003, [ISO-8859-1] Benoît Bournon wrote:
> No trigger
>
> Just triggers for foreign key in spectacle and none in spectacle_v
>
> How is it possible to verify triggers for foreign keys ?
Generally a select on pg_trigger. Each foreign key should have 3
triggers, 1 on the referencin
On Mon, 11 Aug 2003, BenLaKnet wrote:
> we make a dump before ... and with a product pgmanager (ems tech) we do
> not show any foreign keys.
That's possible, I'd have guessed that it should be dumping the triggers
as CREATE CONSTRAINT TRIGGER commands in the dump.
> But I think all of triggers
we make a dump before ... and with a product pgmanager (ems tech) we do
not show any foreign keys.
But I think all of triggers of referenced table are not deleted.
We recreate the schemas ... and now it's running.
How is it possible to identify Triggers with no referenced tables ?
Stepha
No trigger
Just triggers for foreign key in spectacle and none in spectacle_v
How is it possible to verify triggers for foreign keys ?
Stephan Szabo a écrit:
On Fri, 8 Aug 2003, BenLaKnet wrote:
When I duplicate this code in an other table named spectacle_v without
Foreygn
we make a dump before ... and with a product pgmanager (ems tech) we do
not show any foreign keys.
But I think all of triggers of referenced table are not deleted.
We recreate the schemas ... and now is running.
How is it possible to identify Triggers with no referenced tables ?
Stephan Sz
No trigger
Just triggers for foreign key in spectacle and none in spectacle_v
How is it possible to verify triggers for foreign keys ?
Stephan Szabo a écrit:
On Fri, 8 Aug 2003, BenLaKnet wrote:
When I duplicate this code in an other table named spectacle_v without
Foreygn
On Fri, 8 Aug 2003, BenLaKnet wrote:
> When I duplicate this code in an other table named spectacle_v without
> Foreygn key ... all is running.
>
> But when I try to delete a spectacle_membre, linked value in spectacle
> are correctly deleted, but I have an error for spectacle_v which is not
> lin
I have to duplicate a table to save different instances of datas.
Structure de la table "spectacle"
*/
CREATE TABLE "spectacle" (
id_spectacle SERIAL,
"id_membre_adherent" INTEGER NOT NULL,
"id_genre_festival" INTEGER,
"id_fes
