Disable PostgreSQL foreign key checks for migrations

by

For migration, it is easier to disable all triggers with:

SET session_replication_role="replica";

And after migration reenable all with

SET session_replication_role="origin";

More Related Contents:

  1. What is PostgreSQL equivalent to autoincrement?
  2. How do I specify a password to ‘psql’ non-interactively?
  3. INSERT with dynamic table name in trigger function
  4. psql: FATAL: Ident authentication failed for user “postgres”
  5. Use multiple conflict_target in ON CONFLICT clause
  6. PostgreSQL -must appear in the GROUP BY clause or be used in an aggregate function
  7. What is the format for the PostgreSQL connection string / URL?
  8. Go and IN clause in Postgres
  9. Where does PostgreSQL store the database?
  10. How to add “on delete cascade” constraints?
  11. Is there a way to disable function overloading in Postgres
  12. Grant all on a specific schema in the db to a group role in PostgreSQL
  13. Can I make a plpgsql function return an integer without using a variable?
  14. Migrate database from Postgres to MySQL [closed]
  15. How to add a new Column in a table after the 2nd or 3rd column in the Table using postgres?
  16. Can’t connect the postgreSQL with psycopg2
  17. Test for null in function with varying parameters
  18. PostgreSQL: Why psql can’t connect to server?
  19. Postgres error on insert – ERROR: invalid byte sequence for encoding “UTF8”: 0x00
  20. Can I use return value of INSERT…RETURNING in another INSERT?
  21. Changing a postgres containers server port in Docker Compose
  22. How do you find the disk size of a Postgres / PostgreSQL table and its indexes
  23. no pg_hba.conf entry for host
  24. PostgreSQL – disabling constraints
  25. PostgreSQL authentication method 10 not supported
  26. How to delete an enum type value in postgres?
  27. Why unsigned integer is not available in PostgreSQL?
  28. now() default values are all showing same timestamp
  29. What’s the difference between pg_table_size, pg_relation_size & pg_total_relation_size? (PostgreSQL)
  30. JPA and PostgreSQL with GenerationType.IDENTITY

Leave a Comment