On 3/11/25 12:55, mark bradley wrote:
It happened again. Now there are no sequences (although there once was).
Read my previous post and provide the information requested.
Also:
1) Postgres version.
2) Where did you get Postgres from?
Sequence of data reentry:
1.
I reentered the /node_id/s in table node as a primary key.
2.
I reentered the datasets, in table /dataset/.
3.
/Node_id/ was already a PK in dataset.
4.
_I set _/_node_id_/_ to also be a foreign key in _/_dataset_/_._
5.
I went back to look at /node/ and see that duplicate key values
appeared.
Processing nodes are unaffected because I didn't add any data to the
/processing_node/ table.
Next, I'm going to create a simple database from scratch and see if I
can duplicate this behavior.
Best regards,
Mark Brady
_amazon.com/author/markjbrady <https://amazon.com/author/markjbrady>_
------------------------------------------------------------------------
*From:* Adrian Klaver <adrian.klaver@xxxxxxxxxxx>
*Sent:* Tuesday, March 11, 2025 3:37 PM
*To:* mark bradley <markbradyju@xxxxxxxxxxx>
*Cc:* pgsql-general <pgsql-general@xxxxxxxxxxxxxx>
*Subject:* Re: Duplicate Key Values
On 3/11/25 11:52, mark bradley wrote:
there is an index on node_id as it is the Primary Key.
Why do you think there is not?
My mistake, I misread the output from \d dataset
Can you elaborate more on point 3.
Are you calling the Foreign Key relationships subclassing?
Although I did not explicitly use Postgres to declare inheritance,
logically speaking table /dataset/ and /processing _node/ inherit or are
subclasses of /node/ because they are subclasses of /node/ in a dataflow
diagram.
In terms of keys, this is accomplished by having the /node_id/ key in
the /node/ table appear as a foreign key and as a primary key in both
the /dataset/ and /processing_node/ tables.
You will need to show the schema definitions for:
node
dataset
processing_node
Best to do using psql \d <table_name>
Also in from previous \d dataset there where NOT VALID FK definitions.
Did you ever run VALIDATE CONSTRAINT against them?
Is there anything in Postgres log at the time you did the above that
showed it did more then a REINDEX?
Not that I can tell.
Best regards,
Mark Brady
_amazon.com/author/markjbrady <https://amazon.com/author/markjbrady
<https://amazon.com/author/markjbrady>>_
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
