Menu
▾
▴
[Bacula-bugs] [bacula 0000096]: Bad SQL style causes errors.
|
From: <bac...@li...> - 2004-08-26 21:45:27
|
The following bug has been CLOSED ====================================================================== http://bugs.bacula.org/bug_view_advanced_page.php?bug_id=0000096 ====================================================================== Reported By: Jari Fredriksson Assigned To: ====================================================================== Project: bacula Bug ID: 96 Category: sql Reproducibility: always Severity: minor Priority: normal Status: closed ====================================================================== Date Submitted: 08-26-2004 11:06 PDT Last Modified: 08-26-2004 14:47 PDT ====================================================================== Summary: Bad SQL style causes errors. Description: dird/sqlcmds.c makes queries to table DelCandicates after the table is DROPped from the table space. Error messages are shown, but I'm not sure if any more harm will happen. Solution: do not DROP/CREATE it, but TRUNCATE instead at beginning AND end of session. (Btw, you are now prepared to an error, if the app has crashed, and the table was never DROPped rigth? CREATE will error.. ====================================================================== ---------------------------------------------------------------------- Jari Fredriksson - 08-26-2004 11:20 PDT ---------------------------------------------------------------------- The correct version number is 1.35.2 ---------------------------------------------------------------------- Dan Langille - 08-26-2004 11:32 PDT ---------------------------------------------------------------------- PostgreSQL has the ability to create temporary tables which are available only during the current session. They are automagically deleted afterwards. PostgreSQL supports truncate: http://www.postgresql.org/docs/current/static/sql-truncate.html ---------------------------------------------------------------------- kern - 08-26-2004 14:47 PDT ---------------------------------------------------------------------- I'm sorry, but if you cannot point out exactly where the problem is occurring, I cannot fix it. I have no plans to change the current code to use TEMPORARY tables or to use TRUNCATE because those features are not portable. Bug History Date Modified Username Field Change ====================================================================== 08-26-04 11:06 Jari FredrikssonNew Bug 08-26-04 11:20 Jari FredrikssonBugnote Added: 0000188 08-26-04 11:31 TheBossAccount Bugnote Added: 0000189 08-26-04 11:32 Dan Langille Bugnote View State: private: 189 08-26-04 11:32 Dan Langille Bugnote Added: 0000190 08-26-04 11:32 Dan Langille Bugnote Deleted: 0000189 08-26-04 14:47 kern Bugnote Added: 0000192 08-26-04 14:47 kern Resolution open => unable to duplicate 08-26-04 14:47 kern Status new => closed ====================================================================== |