Re: Enforce primary key on every table during dev?
Ron Johnson <ron.l.johnson@cox.net>
From: Ron Johnson <ron.l.johnson@cox.net>
To: pgsql-general@lists.postgresql.org
Date: 2018-03-01T19:42:18Z
Lists: pgsql-general
On 03/01/2018 01:11 PM, marcelo wrote: > > On 01/03/2018 16:00 , Ron Johnson wrote: [snip] >> If your only unique index is a synthetic key, then you can insert the >> same "business data" multiple times with different synthetic keys. >> >> >> -- >> Angular momentum makes the world go 'round. > IMHO, business logic can and must preclude "garbage insertion". Except you > are inserting data directly to database using SQL, any n-tier architecture > will be checking data validity. Any n-tier architecture that's bug-free. -- Angular momentum makes the world go 'round.