Well at the same time you can end up with left over "permits" in iipermits if having a view on the table,
That ends up being "dropped" because of dropping a column. (Bugfix out today for my found bug 124523 on 9.2.1 - happy new year).

By the way internal reproduced at Ingres on
III 9.2.1 (axp.osf/103) + p13832, II 2.6/0803 (axp.osf/00) + p13228 and II 10.0.0 (int.w32/125)

If later trying to drop the permit according to iipermits select gives an error and regranting as well gives an error.

So always "drop" any dependencies before dropping a column and preferably only for wrong named new columns.

Kind regards
Henrik Georg Sørensen, Ingres DBA
Organisator - En del af KMD
Denmark
Fra: info-ingres-bounces (AT) kettleriver...ting (DOT) com [mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] På vegne af Martin Bowes
Sendt: 30. november 2010 12:52
Til: Ingres and related product discussion forum
Cc: Allan Biggs
Emne: Re: [Info-Ingres] Error in dropping column

Perhaps a nice procedure which would list all the dependencies ... no particular order.

Marty

From: Allan Biggs [mailto:Allan.Biggs (AT) gbr (DOT) dupont.com]
Sent: 30 November 2010 11:25
To: Ingres and related product discussion forum
Subject: Re: [Info-Ingres] Error in dropping column


Similar topic.

I wish there was a warning that a table is part of a view when you drop a table. Maybe later releases do this.

Allan


Martin Bowes <martin.bowes (AT) ctsu (DOT) ox.ac.uk>
Sent by: info-ingres-bounces (AT) kettleriver...ting (DOT) com

30/11/2010 10:49
Please respond to
Ingres and related product discussion forum <info-ingres (AT) kettleriverconsulting (DOT) com>


To

Ingres and related product discussion forum <info-ingres (AT) kettleriverconsulting (DOT) com>

cc

Subject

Re: [Info-Ingres] Error in dropping column







Hi Leandro,

Yes it was a database rule. It had an update(action) clause.

Marty

From: Leandro Pinto Fava [mailto:leandro (AT) unisc (DOT) br]
Sent: 29 November 2010 16:10
To: Ingres and related product discussion forum
Subject: Re: [Info-Ingres] Error in dropping column

Hi Martin,

May be you can take a look at rules and/or procedures.
What I do in these cases is make a unloaddb ou copydb and search by the column name (or any text to match) in the copy.in file.

Leandro Fava
Setor de Informática - UNISC
+55 51 3717 7636

From: info-ingres-bounces (AT) kettleriver...ting (DOT) com [mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of Martin Bowes
Sent: segunda-feira, 29 de novembro de 2010 11:55
To: Ingres and related product discussion forum
Subject: [Info-Ingres] Error in dropping column

Hi All,

When I try to drop a column from a table with: alter table tag_def drop column action restrict\g

I get: E_QE016B ALTER TABLE DROP COLUMN RESTRICT: restricted destruction of base
table column cannot proceed as it has one or more dependent objects
which would become abandoned.

The column action is not part of a key nor is it the subject of a constraint.

What catalogs do I need to examine to try and find out what its bitching about?

Martin Bowes
_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://ext-cando.kettleriverconsulti...fo/info-ingres



This communication is for use by the intended recipient and contains

information that may be Privileged, confidential or copyrighted under

applicable law. If you are not the intended recipient, you are hereby

formally notified that any use, copying or distribution of this e-mail,

in whole or in part, is strictly prohibited. Please notify the sender by

return e-mail and delete this e-mail from your system. Unless explicitly

and conspicuously designated as "E-Contract Intended", this e-mail does

not constitute a contract offer, a contract amendment, or an acceptance

of a contract offer. This e-mail does not constitute a consent to the

use of sender's contact information for direct marketing purposes or for

transfers of data to third parties.



Francais Deutsch Italiano Espanol Portugues Japanese Chinese Korean



http://www.DuPont.com/corp/email_disclaimer.html