Subject Re: [ib-support] gbak error
Author Martijn Tonies
> I originally changed the length of a varchar field.
> But in another db with the same metadata (i thought) and a tool.
> I copied the command that this tool exceuted.
> But in this db it was another field.
> BTW is there a command for firebird to change the length of a varchar
field without hacking system tables ?

Sure, ALTER TABLE ... Check the docs at the IBPhoenix CD or the beta
docs for IB6 (PDF files)...

Or, use InterBase Workbench to do it for you and record a change-script.

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

> >
> > > I' ve found the error.
> > > In addition to the add column i did a change on a system table which
was
> > in=
> > > correct.
> > > After correcting it works again.
> >
> > You did a change on the system tables by hand, what, if I may ask?
> >
> > Martijn Tonies
> > InterBase Workbench - the developer tool for InterBase and Firebird
> > http://www.interbaseworkbench.com
> >
> > Upscene Productions
> > http://www.upscene.com
> >
> > "This is an object-oriented system.
> > If we change anything, the users object."
> >
> > > gru=DF
> > > Carsten
> > > ----- Original Message -----=20
> > > From: "Carsten Sch=E4fer" <ca_schaefer@...>
> > > To: <ib-support@yahoogroups.com>
> > > Sent: Monday, August 19, 2002 4:21 PM
> > > Subject: [ib-support] gbak error
> > >
> > >
> > > I'm using Firebird 1.o on Win2000.
> > > Now I have seen that after an update of a table (add column) backup is
not
> > =
> > > working any longer.
> > > I get the followowing error:
> > > gbak: writing data for table T_ANGEBOT
> > > gbak: ERROR: message length error (encountered 1548, expected 1302)
> > > gbak: ERROR: gds_$receive failed
> > > gbak: Exiting before completion due to errors
> > >
> > > t_angebot is the table where the add column took place.
> > > I've seen a similar error posted on februar this year.
> > > Is my databse corrupted now ?
> > >
> > > How to get a working backup for this db ?
> > > Yes, it's in production.
> > >
> > > gru=DF
> > > Carsten Sch=E4fer
> > > =20
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> > > To unsubscribe from this group, send an email to:
> > > ib-support-unsubscribe@egroups.com
> > >
> > > =20
> > >
> > > Your use of Yahoo! Groups is subject to
> > http://docs.yahoo.com/info/terms/=20
> > >
> > >
> > >
> > >
> > >
> > > To unsubscribe from this group, send an email to:
> > > ib-support-unsubscribe@egroups.com
> > >
> > > =20
> > >
> > > Your use of Yahoo! Groups is subject to
> > http://docs.yahoo.com/info/terms/=20
> > >
> > >
> > >
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > ib-support-unsubscribe@egroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>