[Info-ingres] Table specified no longer exists

[Adrian Williamson]

Hi Marty,

 

We spotted something about this in 2020 - Karl thinks he knows - it is a
view thing.

 

See attached.

 

Cheers

 

Adrian

 

From: info-ingres-bounces at lists.planetingres.org
<info-ingres-bounces at lists.planetingres.org> On Behalf Of Martin Bowes
Sent: 15 February 2022 09:17
To: Martin Bowes <martin.bowes at ndph.ox.ac.uk>;
info-ingres at lists.planetingres.org
Subject: Re: [Info-ingres] Table specified no longer exists

 

And an addendum.

 

I can glean nothing else from server tracing, II_EMBED_SET=printqry,
verifydb.

 

Nothing is being written into the errlog.

 

Marty

 

From: Martin Bowes <martin.bowes at ndph.ox.ac.uk
<mailto:martin.bowes at ndph.ox.ac.uk> > 
Sent: 15 February 2022 08:52
To: info-ingres at lists.planetingres.org
<mailto:info-ingres at lists.planetingres.org> 
Subject: [Info-ingres] Table specified no longer exists

 

Hi All,

 

Ingres 11.1.0 +p15692

 

I have a table with an integer1 column I wish to drop. The column is not
part of the table key, not any index on the table, it has no comments, it is
not involved in any constraints, rules, procedures, views etc. The table
does have a long object, but this column isn't it.

 

alter table field drop column cost_ba cascade; 

Executing . . .

 

E_US16D5 Table specified no longer exists.

 

That was surprising.

 

I've copied this table to a dummy database and repeated the drop command
there but this time with success, so I'm ruling out the possibility of
interference from the long object at this point.

 

As this is a production database I don't want to monkey with it much more so
I'm currently recovering it to a backup host so I can play with it in
isolation. That will take some time. In the mean time does anyone have a
suggestion about what may be causing the problem? 

 

Martin Bowes

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20220215/3224bd9f/attachment-0001.html>
-------------- next part --------------
An embedded message was scrubbed...
From: "Karl Schendel" <schendel at kbcomputer.com>
Subject: Re: [Info-ingres] E_US16D5 Table specified no longer exists
Date: Tue, 15 Dec 2020 22:26:16 -0000
Size: 6193
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20220215/3224bd9f/attachment-0001.mht>