From: Mantis B. T. <no...@bu...> - 2010-11-17 08:45:01
|
The following issue has been CLOSED ====================================================================== http://bugs.bacula.org/view.php?id=1665 ====================================================================== Reported By: baculator Assigned To: ====================================================================== Project: bacula Issue ID: 1665 Category: PostgreSQL Reproducibility: N/A Severity: tweak Priority: normal Status: closed Resolution: open Fixed in Version: ====================================================================== Date Submitted: 2010-11-16 20:31 UTC Last Modified: 2010-11-17 08:44 UTC ====================================================================== Summary: PostgreSQL deferrable foreign key Description: Hello, I have read that foreign keys are not used on PostgreSQL because of performance. I'd like to have referential integrity and found that there is a way. Constraints that are deferrable may be postponed until the end of the transaction. >From manual at http://www.postgresql.org/docs/8.1/static/sql-createtable.html DEFERRABLE NOT DEFERRABLE This controls whether the constraint can be deferred. A constraint that is not deferrable will be checked immediately after every command. Checking of constraints that are deferrable may be postponed until the end of the transaction (using the SET CONSTRAINTS command). NOT DEFERRABLE is the default. Only foreign key constraints currently accept this clause. All other constraint types are not deferrable ====================================================================== ---------------------------------------------------------------------- (0005657) ebollengier (administrator) - 2010-11-17 08:44 http://bugs.bacula.org/view.php?id=1665#c5657 ---------------------------------------------------------------------- Sorry, we are dealing only with bugs on this tracker, if you want to discuss new features, improvements, etc.. use bacula-devel list. Don't forget to include more details on your proposal like, which kind of foreign keys, what problems it will solve, some performance tests with big catalog (You are claiming that it won't slow down operations, I'm ok to trust you, but I need to see it first)... Issue History Date Modified Username Field Change ====================================================================== 2010-11-16 20:31 baculator New Issue 2010-11-17 08:44 ebollengier Note Added: 0005657 2010-11-17 08:44 ebollengier Status new => closed ====================================================================== |