| Subject | RE: [ib-support] Too many versions error |
|---|---|
| Author | Leyne, Sean |
| Post date | 2001-02-21T18:52:53Z |
Daniel,
Yes, Firebird has the same limitation. By the way, the limit is 255
metadata changes to any single table - that's a lot of changes to a
table.
Historically, it has not been considered a priority to extend this
limit. It is perhaps something which can be considered as part of a
major ODS revision (which would not be backward compatible).
You can incorporate a backup and restore within your application - just
don't ever overwrite the existing database, restore to a temp file,
rename the original file, change temp file to original filename.
Sean
-----Original Message-----
From: Daniel Rail [mailto:drail@...]
Sent: Wednesday, February 21, 2001 1:44 PM
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] Too many versions error
Does anybody know if Firebird has this limit of 255 metadata changes?
I'm
creating a program that would make the necessary modifications on my
clients servers. But if there's a limit on the changes, this could be
dangerous for me, since most of my clients had guidance on installing
the
software and don't want to take the time for maintenance. I have one
question, if I incorporate in the software the backup and restore(with
replace), would this work?
Thank you in advance.
Daniel Rail
At 21/02/2001 14:26, you wrote:
075.htm?mid=yahoo_cga158_cs>
ib-support-unsubscribe@egroups.com
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
Yes, Firebird has the same limitation. By the way, the limit is 255
metadata changes to any single table - that's a lot of changes to a
table.
Historically, it has not been considered a priority to extend this
limit. It is perhaps something which can be considered as part of a
major ODS revision (which would not be backward compatible).
You can incorporate a backup and restore within your application - just
don't ever overwrite the existing database, restore to a temp file,
rename the original file, change temp file to original filename.
Sean
-----Original Message-----
From: Daniel Rail [mailto:drail@...]
Sent: Wednesday, February 21, 2001 1:44 PM
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] Too many versions error
Does anybody know if Firebird has this limit of 255 metadata changes?
I'm
creating a program that would make the necessary modifications on my
clients servers. But if there's a limit on the changes, this could be
dangerous for me, since most of my clients had guidance on installing
the
software and don't want to take the time for maintenance. I have one
question, if I incorporate in the software the backup and restore(with
replace), would this work?
Thank you in advance.
Daniel Rail
At 21/02/2001 14:26, you wrote:
> >I have the following error when trying to ALTER a DOMAIN:700007709:N/A=585623/*http://www.egghead.com/category/inv/00000272/03715
> >
> >Project raised exception class EIB_ISCError with message
> >'ISC ERROR CODE:335544351
> >ISC ERROR MESSAGE:
> >unsuccessful metadata update
> >TABLE CLIENTS
> >too many versions'
>
>You may have exceeded the "limit" on metadata changes, I believe it is
>255. If so, a gbak, then restore will reset the for you.
>
>
>Yahoo! Groups
>Sponsor<http://rd.yahoo.com/M=179201.1337717.2926275.2/D=egroupmail/S=1
075.htm?mid=yahoo_cga158_cs>
>To unsubscribe from this group, send an email to:
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to the
><http://docs.yahoo.com/info/terms/>Yahoo! Terms of Service.
ib-support-unsubscribe@egroups.com
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/