[SQL-CVS] [ sqlobject-Bugs-1369871 ] v0.6: dropTable can not drop CASCADEing

[SourceForge.net <no...@so...>]

Bugs item #1369871, was opened at 2005-11-30 01:20
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=540672&aid=1369871&group_id=74338

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: General
Group: SQLObject release (specify)
Status: Open
Resolution: None
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: v0.6: dropTable can not drop CASCADEing

Initial Comment:
Traceback (most recent call last):
  File "./cdb.py", line 1403, in ?
    main()
  File "./cdb.py", line 1399, in main
    m = mutateDb()
  File "./cdb.py", line 523, in __init__
    self.cdb    = clusterDb()
  File
"/home/ramon/src/lisa/rc_db_utils/so_redesign/cluster_database.py",
line 93, in __init__
    table.dropTable( ifExists = True, dropJoinTables =
True )
  File
"/usr/lib/python2.3/site-packages/sqlobject/main.py",
line 967, in dropTable
    cls._connection.dropTable(cls._table, cascade)
  File
"/usr/lib/python2.3/site-packages/sqlobject/postgres/pgconnection.py",
line 93, in dropTable
    self.query("DROP TABLE %s %s" % (tableName,
  File
"/usr/lib/python2.3/site-packages/sqlobject/dbconnection.py",
line 196, in query
    return self._runWithConnection(self._query, s)
  File
"/usr/lib/python2.3/site-packages/sqlobject/dbconnection.py",
line 117, in _runWithConnection
    val = meth(conn, *args)
  File
"/usr/lib/python2.3/site-packages/sqlobject/dbconnection.py",
line 193, in _query
    self._executeRetry(conn, conn.cursor(), s)
  File
"/usr/lib/python2.3/site-packages/sqlobject/dbconnection.py",
line 188, in _executeRetry
    return cursor.execute(query)
psycopg.ProgrammingError: ERROR:  cannot drop table
network because other objects depend on it
HINT:  Use DROP ... CASCADE to drop the dependent
objects too.


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=540672&aid=1369871&group_id=74338