Skip to content

Instantly share code, notes, and snippets.

@CEZERT
Last active May 12, 2022 06:55
Show Gist options
  • Save CEZERT/38f8da029af73c3edd4e29ab40d49b6a to your computer and use it in GitHub Desktop.
Save CEZERT/38f8da029af73c3edd4e29ab40d49b6a to your computer and use it in GitHub Desktop.

Notes

-- Table Rules

-- DROP RULE qualification_trace_insert_ignore ON traitement."Qualification_trace";

CREATE RULE qualification_trace_insert_ignore AS ON INSERT TO "Acapulco"."Qualification_trace" WHERE (EXISTS ( SELECT 1 FROM "Acapulco"."Qualification_trace" WHERE ((("Qualification_trace".lot_liv)::text = (new.lot_liv)::text) AND (("Qualification_trace".id_liv)::text = (new.id_liv)::text) AND ("Qualification_trace".geom = new.geom)))) DO INSTEAD NOTHING;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment