Hacker News
new
|
past
|
comments
|
ask
|
show
|
jobs
|
submit
login
sgarland
on Oct 21, 2024
|
parent
|
context
|
favorite
| on:
MVCC – the part of PostgreSQL we hate the most (20...
You’re not technically wrong, but even Postgres’ docs [0] use the term Primary Key.
[0]:
https://www.postgresql.org/docs/current/ddl-constraints.html
srcreigh
on Oct 21, 2024
[–]
Postgres primary key indexes are not primary indexes.
sgarland
on Oct 21, 2024
|
parent
[–]
I know that, I’m saying that it’s a fairly pedantic argument when even their own docs use the term loosely.
jeltz
on Oct 21, 2024
|
root
|
parent
|
next
[–]
Primary keys are primary indexes are two mostly unrelated terms.
j16sdiz
on Oct 21, 2024
|
root
|
parent
|
prev
[–]
"Primary Key" is the term in SQL standard. The url you linked is in "Part II: The SQL Language"
Guidelines
|
FAQ
|
Lists
|
API
|
Security
|
Legal
|
Apply to YC
|
Contact
Search:
[0]: https://www.postgresql.org/docs/current/ddl-constraints.html