db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrew McIntyre" <mcintyr...@gmail.com>
Subject Re: Re: Rename table error
Date Fri, 21 Jul 2006 18:40:07 GMT
On 7/21/06, Edson Carlos Ericksson Richter
<edson.richter@mgrinformatica.com.br> wrote:
> I'm doing something wrong?
> Or it's known behavior? If yes, it's fixed in early releases?

>From the doc for RENAME TABLE:

"If there is a view or foreign key that references the table, attempts
to rename it will generate an error. In addition, if there are any
check constraints or triggers on the table, attempts to rename it will
also generate an error."

http://db.apache.org/derby/docs/dev/ref/rrefsqljrenametablestatement.html

This is the behavior in the current release and in the trunk.

andrew

Mime
View raw message