PostgreSQL array of elements that each are a foreign key

by

It may soon be possible to do this: https://commitfest.postgresql.org/17/1252/ – Mark Rofail has been doing some excellent work on this patch!

The patch will (once complete) allow

CREATE TABLE PKTABLEFORARRAY (
    ptest1 float8 PRIMARY KEY,
    ptest2 text
);
CREATE TABLE FKTABLEFORARRAY (
    ftest1 int[],
    FOREIGN KEY (EACH ELEMENT OF ftest1) REFERENCES PKTABLEFORARRAY,
    ftest2 int
);

However, author currently needs help to rebase the patch (beyond my own ability) so anyone reading this who knows Postgres internals please help if you can.

More Related Contents:

  1. CONSTRAINT to check values from a remotely related table (via join etc.)
  2. Why the “Group BY” by month didn’t work? [closed]
  3. What to do with null values when modeling and normalizing?
  4. Postgres: INSERT if does not exist already
  5. Truncating all tables in a Postgres database
  6. How can I drop all the tables in a PostgreSQL database?
  7. postgres default timezone
  8. quick random row selection in Postgres
  9. Running PostgreSQL in memory only
  10. How to close idle connections in PostgreSQL automatically?
  11. postgresql – replace all instances of a string within text field
  12. Is it possible to have autoincrement number without it being an ID?
  13. How do I login and authenticate to Postgresql after a fresh install?
  14. pgadmin4 : postgresql application server could not be contacted.
  15. PostgreSQL error ‘Could not connect to server: No such file or directory’
  16. function returns multiple columns as a single column instead of multiple columns
  17. Postgres FOR LOOP
  18. Storing Images in PostgreSQL
  19. Strange behaviour in Postgresql
  20. Postgres: Distinct but only for one column
  21. In PostgreSQL, how to insert data with COPY command?
  22. Cursor based records in PostgreSQL
  23. How to add column if not exists on PostgreSQL?
  24. Configuration parameter work_mem in PostgreSQL on Linux
  25. How to work with PGpoint for Geolocation using PostgreSQL?
  26. Heroku database restore issue
  27. user postgres launches process that takes all CPUs 100% usage
  28. How do I get min, median and max from my query in postgresql?
  29. PostgreSQL jsonb, `?` and JDBC
  30. Error when pushing data to Heroku: time zone displacement out of range

Leave a Comment