db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alexander Fedorenko" <afedo...@informex.net>
Subject RE: [SOURCE] Issue #TRQS121 modified
Date Fri, 20 Jun 2003 10:32:11 GMT
Hello.

Very good.

And just another small thing 

2.  DROP TABLE command

    ... from PostgreSQL documentation

    DROP TABLE always removes any indexes, rules, triggers, and
constraints that exist for the target table. However, to drop a table
that is referenced by a foreign-key constraint of another table, CASCADE
must be specified. (CASCADE will remove the foreign-key constraint, not
the other table itself.)  


Code in file src\templates\sql\base\postgresql\drop.vm

DROP TABLE $table.Name;

Should be replaced with

DROP TABLE $table.Name CASCADE ;


-----Original Message-----
From: Martin Poeschl [mailto:mpoeschl@marmot.at] 
Sent: Friday, June 20, 2003 11:59 AM
To: Bill Schneider
Cc: torque-dev@db.apache.org
Subject: [SOURCE] Issue #TRQS121 modified

You can view the issue detail at the following URL:

    http://scarab.werken.com/issues/id/TRQS121

Type
 Defect

Issue ID
 TRQS121 (native limit and offset breaks on postgresql 7.3)

Modified by
 Martin Poeschl
 mpoeschl (mpoeschl@marmot.at)

The following modifications were made to this issue:
---------------------------------------------------------------------

Status changed from 'New' to 'Closed'
Resolution set to 'Fixed'

Reason:
fixed in HEAD and 3_0_BRANCH

---------------------------------------------------------------------
This message is automatically generated by the Scarab
issue tracking system.  For more information:
http://scarab.tigris.org/



---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org


Mime
View raw message