Den 2013-06-03 19:45 skrev Hannes Streicher såhär:
>
> Guten Tag Kjell Rilbe,
>
> what happens if you commit after alter table ?
>
Then it works, but I shouldn't be required to commit there, should I?
And if so, shouldn't the error occur on drop index rather than on commit?
> > Hi,
>
> > This seems buggy to me (Firebird WI-V2.5.2.26540 64 bit):
>
> > create table "Test" ("MyCol" int);
> > create index "IxTest" on "Test" ("MyCol");
> > [commit]
>
> > alter table "Test" alter "MyCol" to "NewName";
> > drop index "IxTest";
> > [commit]
>
> > In FlameRobin, this results in error message:
> > ======================================
> > *** IBPP::SQLException ***
> > Context: Transaction::Commit
>
> > SQL Message : -607
> > This operation is not defined for system tables.
>
> > Engine Code : 335544351
> > Engine Message :
> > unsuccessful metadata update
> > cannot create index IxTest
> > ======================================
>
> > After that, the index seems to be in use preventing me from doing
> > "anything", until I disconnect and reconnect.
>
> > If I drop the index before renaming the column, it works as expected.
>
> --
> Mit freundlichen Grüssen
> Hannes Streicher mailto:hstreic...@gmx.de <mailto:HStreicher%40gmx.de>
>
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kj...@datadia.se
Telefon: 08-761 06 55
Mobil: 0733-44 24 64
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)
<*> To change settings via email:
firebird-support-dig...@yahoogroups.com
firebird-support-fullfeatu...@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
