BUG #13777: FKs began to no longer treat referential integrity, ie, it was as if the FKs did not exist.

From: alvaro(dot)pereira(dot)neto(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #13777: FKs began to no longer treat referential integrity, ie, it was as if the FKs did not exist.
Date: 2015-11-17 19:14:26
Message-ID: 20151117191426.12380.835@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 13777
Logged by: Alvaro Neto
Email address: alvaro(dot)pereira(dot)neto(at)gmail(dot)com
PostgreSQL version: 9.3.6
Operating system: RedHat 6.5 x86
Description:

We are experiencing a "bug" that we had not noticed, the releases 9.3.3 and
9.3.6.
1) a migration via dump / restore, version 9.0.7 to version 9.3.6 was
carried out, and after seven months in one of the tables, which had 8 FKs,
these FKs began to no longer treat referential integrity, ie, it was as if
the FKs did not exist;
2) the development platform, release 9.3.3, a database was created
(dbadmin-new) using, as a template, another existing database (dbadmin). And
then charges through inserts have not been validated by FKs. It was found
that all FKs exist. However, FKs not restricted any inclusion of information
without integrity. Instructions for creating the database was:
CREATE DATABASE 'dbadmin-new' WITH TEMPLATE 'dbadmin' OWNER 'postgres'
TABLESPACE = 'homolog';

Our PostgreSQL been compiled in accordance with the parameter set of the
following:
* For 9.3.6 - production platform ==> CONFIGURE = '--prefix = / usr /
local / pgsql-9.3.6' --with-perl '' --with-python '' --with- tcl ''
--with-tclconfig = / usr / lib64 '' --with-krb5 '' --with-openssl ''
--with-pam '' --with-ldap '' --with-libxml '' --with-libxslt '
* For 9.3.3 - plataform development ==> CONFIGURE = '--prefix'
'/usr/local/pgsql-9.3.3' '--with-perl' '--with-python' '--with -tcl ''
--with-tclconfig = / usr / lib64 '' --with-krb5 '' --with-openssl ''
--with-pam '' --with-ldap '' --with-libxml '--with-libxslt'

Our production platform is grounded in PostgreSQL cluster with a total of
5 nodes, with streaming replication, and I am the one who created and
manages all of these platforms.

You could refer, please, this e-mail to the development team to see if
anyone else has experienced this situation? Sought I and an architect,
references in this 'bug' but did not find anything or the forums, and even
the Internet in general.

Thanks.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message John R Pierce 2015-11-17 20:04:29 Re: BUG #13777: FKs began to no longer treat referential integrity, ie, it was as if the FKs did not exist.
Previous Message Sandeep Thakkar 2015-11-17 07:34:32 Re: BUG #13692: Error when run silent installation whith alredy installed PG9.4