Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL Developer Best Practices - Mailing list pgsql-general

From David G. Johnston
Subject Re: PostgreSQL Developer Best Practices
Date
Msg-id CAKFQuwa=8g9NpAXfr=c4OmzHO=Gsf9c3nmcMV5mnXU4YE7CtLQ@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL Developer Best Practices  (Melvin Davidson <melvin6925@gmail.com>)
List pgsql-general
Tree view
On Mon, Aug 24, 2015 at 10:32 AM, Melvin Davidson <melvin6925@gmail.com> wrote:
>What then if it is discovered that the keyed in value was mis-typed?

That is why SQL has UPDATE and DELETE statements. If a primary key is incorrect,
it can be fixed, be it one method of another. 

​Yes, a DBA can use ON DELETE CASCADE and ON UPDATE CASCADE​
 
​to manually resolve the issue of a typo.    At scale it is not a clear-cut solution, however.

David J.

pgsql-general by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: PostgreSQL Developer Best Practices
Next
From: John Turner
Date:
Subject: Re: PostgreSQL Developer Best Practices