postgresqlentity-relationshipreferential-integrity
Referential cycle: ON DELETE CASCADE?
If "predmet" is a FK to "predmeti", and "nositelj" is a FK to "nastavnici",
what will happen if I specify ON DELETE CASCADE to both foreign keys and delete one of the entities? Would it produce an error?
Edit: I'm using the latest version of PostgreSQL.
Solution
Read manual for your RDBMS (you have not specified it). Typically circular cascade forbidden - you will get an error on create.
UPDATED: try http://sqlfiddle.com/#!1/24df4/2/0 It seems it is not forbidden - remove recursively.
Someone very kind minused me, because i have fixed the tags and it makes my post incorrect)
- Filter out rows in 1:N LEFT JOIN where any row in child table fails condition
- SQL Formatting a string (name)
- Postgres Query using concat and LIKE
- Autoincrement separately for each foreign key
- error connecting external database with rails
- Forward fill NULL values in multiple columns
- PostgreSQL EXISTS in user-defined function always returning true
- Problem with creating server in pgadmin 4, unable to connect to server
- Oracle JSON_TABLE to PostgreSQL - how to search from the second hierarchical key in a JSON column
- pg_upgrade on Windows cannot write to log file pg_upgrade_internal.log
- Why is my postgres constraint name suffix different from the standard?
- I want to restore the database with a different schema
- Postgres settings to maximize compute resources for a single local connection
- Why does an operation on real and a numeric inputs result in a double precision?
- Typeorm queryBuilder select only a specific key value of a JSONB type column
- How to write this SQL query to find each account balance?
- How to set `lock_timeout` on a PostgreSQL connection with SQLAlchemy and psycopg2?
- How to calculate DATE Difference in PostgreSQL?
- Missing FROM-clause entry for a table
- PostgreSQL 17: pg_upgrade on Windows Server 2019: could not load library "$libdir/adminpack": No such file or directory
- Displaying binary images on JSP page
- Recursive CTE in Postgresql
- Add missing dates in a table
- Cast value to type (TEXT) using string representation of type ("TEXT")
- Slow join query on large table using Postgres
- Equivalent of FOUND_ROWS() function in Postgresql
- django.db.utils.ProgrammingError: column "role" of relation "APP_profile" does not exist
- How to convert SQLite SQL dump file to PostgreSQL?
- How do I change the timezone to UTC in postgres permanently?
- Export .csv file (with headers) from PostgreSQL table using PHP PDO, first data row missing