On 2017-11-16 12:01, antoedinchar...@gmail.com [firebird-support] wrote:
> have you tried altering rdb$indices ?
That is something that will no longer work with Firebird 3.
Mark
> I never do a database structure change when users are connected and do not
> allow them to use the system at this time. So in my case, it is to slow
It's almost always like that, when you altering DB structure - you must
disconnect all users to avoid problems.
16.11.2017 12:20, michael.vilhelm...@microcom.dk [firebird-support] wrote:
> I do know, that its a onetime thing, but if Ihave to wait for it to finish
> all I want to
> change, I will not do it.
Run script in evening, get results in morning.
--
WBR, SD.
have you tried altering rdb$indices ?
No - but I can try.
I think, "slow" here is not a problem - you do it only one time, and not on
regular basis.
I do know, that its a onetime thing, but if Ihave to wait for it to finish all
I want to change, I will not do it.
I never do a database structure change when users are connected and do not
allow
Thank you Dimitry Sibiryakov for the suggession. I tried a trial with local
dummy db of size just 1.5GB in which i tried inserting 10Cr records to one
table with only 1 field currenttimestamp and executed. At this same time i
started nbackup for this db it also take approximately 20-30 minutes
> have you tried altering rdb$indices ?
No, I don't have such necessity.
have you tried altering rdb$indices ?
> Use "ALTER TABLE ... DROP CONSTRAINT ..." and then "ALTER TABLE ... ADD
> CONSTRAINT ... FOREIGN KEY ..."
>
> Thats no fast if the table is huge. This method I know.
I think, "slow" here is not a problem - you do it only one time, and not on
regular basis.
If you mean that this is slow
Use "ALTER TABLE ... DROP CONSTRAINT ..." and then "ALTER TABLE ... ADD
CONSTRAINT ... FOREIGN KEY ..."
Thats no fast if the table is huge. This method I know.
Where you see such FK name as "RDB$FOREIGN60"? It created by you or some DB
management tool? As I know, there is no
<>
Please read
Upgrading from Firebird 1.5 to 2.5 and beyond (.pdf) (161.31K)
by Pavel Cisar
http://www.ibphoenix.com/files/conf2016/upgrading-Cisar-2016.pdf
It will help...
Regards
Paul
Use "ALTER TABLE ... DROP CONSTRAINT ..." and then "ALTER TABLE ... ADD
CONSTRAINT ... FOREIGN KEY ..."
Where you see such FK name as "RDB$FOREIGN60"? It created by you or some DB
management tool? As I know, there is no automatically generated ("system")
FK's. So, you must create them manually
Hi
Is there any easy and fast way to rename a foreign key constraint?
We have a lot like:
RDB$FOREIGN60
Which I would like to rename to something more saying.
As of now its in Firebird 2.5.7.
Regards
Michael
13 matches
Mail list logo