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:[EMAIL PROTECTED] 
Sent: Friday, June 20, 2003 11:59 AM
To: Bill Schneider
Cc: [EMAIL PROTECTED]
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 ([EMAIL PROTECTED])

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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to