Hi 2 all,
in an existing database, we wanted to replace a not sufficiently defined
table by just dropping and recreating it.
It has a FK to just one other table.
Hence, sth like
drop table usersession
//
create table usersession (
....
....
)
//
alter table usersession(
add constraint
...
)
, all executed with SQL Studio, should normally do the job.
However, SQL Studio reports 2 different things, dependent on the DB
server I am working on:
DB server is a Windows XP laptop: (MaxDB 7.5.00.38)
------------------------------------
General Error,-7073 POS(1) Internal Recreate failed with -9206:
USERVIEW_TODOLIST
drop table USERSESSION
------------------------------------
DB server is
a Linux test machine (MaxDB 7.6.00.34)
or an IBM AIX test machine (MaxDB 7.5.00.30)
------------------------------------
Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
General error;-9206 POS(1) System error: AK Duplicate catalog
information:00000000000004EC000A00
drop table USERSESSION
------------------------------------
Noteworthy side information:
In SQL Studio catalog manager, the table to be dropped occurs as the
last one in front of a set of VIEWS I have defined with names like
userview_SelectThis
userview_SelectThat
...
Any comments or hints appreciated, especially helpful ones.
Regards
Michael Neuber
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
