I wonder if it has something to do with your Linux server install, classic
or superserver ?
I believe the Win installs are all of the superserver type, releasing all
resources when all users are logged off. Or do I have this backwards ?

----------------------------------------------------------------------------
-----------------------------------------------

----- Original Message -----
From: "skotaylor" <scott@...>
To: <firebird-support@yahoogroups.com>
Sent: Thursday, July 17, 2003 2:55 PM
Subject: [firebird-support] Re: Modify Primary key


| --- In firebird-support@yahoogroups.com, Hans Hoogstraat <hans@h...>
| wrote:
| > You don't happen to use something like IB_WISQL with the cursor
| sitting on
| > the name of the table you are trying to modify, when you use the same
| > program to drop the primary key from that table ? Happened to me a
| few times
| > :)
|
| Hi Hans,
|
| I tried with IB_WISQL with the browser closed, and the native isql.
|
| SQL> alter table fuellog drop constraint INTEG_68;
| Statement failed, SQLCODE = -607
|
| unsuccessful metadata update
| -object INDEX is in use
|
| Same thing. :(
|
| I just tried on a copy of the database, with only my connection as the
| only user and it worked fine.
|
|
|
| Cheers,
|
| :)
|
|
|
|
| To unsubscribe from this group, send an email to:
| firebird-support-unsubscribe@yahoogroups.com
|
|
|
| Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
|
|
|