Re: DEFERRABLE NOT NULL constraint - Mailing list pgsql-general

From Bèrto ëd Sèra
Subject Re: DEFERRABLE NOT NULL constraint
Date
Msg-id CAKwGa_-RyRP6ekGB+0aOAYYtE0YQYNRp6iiJZx99eB9v-8uH_A@mail.gmail.com
Whole thread Raw
In response to Re: DEFERRABLE NOT NULL constraint  (Chris Angelico <rosuav@gmail.com>)
Responses Re: DEFERRABLE NOT NULL constraint  (Chris Angelico <rosuav@gmail.com>)
List pgsql-general
Hi

> I still don't see how that's any better than a stored procedure that
> directly does the INSERT. You can conceal the code every bit as
> easily.

Guys I DO NOT write the customers' security guidelines. I get asked to
produce a design in which "party X will make plain INSERTs and ignore
the very existence of business rules". Can I do it in PG, No. Can I
rewrite the guidelines? No. Hence, PG is not used. Full stop.

Whether these customers are clever or stupid is not an issue. They are
paying customers, so they are right by design. And yes, sometimes I
manage to sell them something else, as I said earlier. Some other
times I end up having to use a db that is not PG. Easy as that.

Cheers
Bèrto

--
==============================
If Pac-Man had affected us as kids, we'd all be running around in a
darkened room munching pills and listening to repetitive music.



pgsql-general by date:

Previous
From: drew_hunt1976@yahoo.co.jp
Date:
Subject: Need help understanding WAL and checkpoints
Next
From: Chris Angelico
Date:
Subject: Re: DEFERRABLE NOT NULL constraint