3 ms·

It’s really annoying to see people write that Postgres has a “primary index” and “secondary indexes”. No. That’s not what those words mean. Every index in Postg

It’s really annoying to see people write that Postgres has a “primary index” and “secondary indexes”. No. That’s not what those words mean. Every index in Postgres is a secondary index.

sgarland 2y ago
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 https://www.postgresql.org/docs/current/ddl-constraints.html
- srcreigh 2y ago
  Postgres primary key indexes are not primary indexes.
  - sgarland 2y ago
    I know that, I’m saying that it’s a fairly pedantic argument when even their own docs use the term loosely.
    - j16sdiz 2y ago
      "Primary Key" is the term in SQL standard. The url you linked is in "Part II: The SQL Language"
    - jeltz 2y ago
      Primary keys are primary indexes are two mostly unrelated terms.
    - deleted 2y ago
      [deleted]