Thread: ViewData Updates with validations
Hello,
We would like to use pgAdmin interface to do updates on the database records.
The problem right now is that the Constraints do not seem to be applied when doing an update from ViewData.
Is there a way this can be enabled?
Hope to hear from you soon.
Best regards,
On Wed, Jun 20, 2018 at 3:09 PM, Andreea Gavrilovici <andreea@lionstep.com> wrote:
Hello,We would like to use pgAdmin interface to do updates on the database records.The problem right now is that the Constraints do not seem to be applied when doing an update from ViewData.Is there a way this can be enabled?
Constraints are enforced by the backend database. It is not possible for pgAdmin to bypass them unless it were to explicitly disable them (which it makes no attempt to do).
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company