Thanks Fidel, but the error message is normally attributed to exactly what
it says, i.e. a record size exceeding 64K
But the fields in this view (and underlying tables) are nowhere near that
limit. The entire table of fields here is 700 bytes, and the entire table of
fields of the other table is about 3000 bytes.
In my experience, the presence of blobs in this respect don't automatically
make the limit be exceeded.

Alan

> -----Original Message-----
> From: firebird-support@yahoogroups.com [mailto:firebird-
> support@yahoogroups.com] On Behalf Of Fidel Viegas
> Sent: Monday, 8 September 2008 5:27 PM
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] unsuccessful metadata update
>
> On Mon, Sep 8, 2008 at 12:07 AM, Alan McDonald <alan@...>
> wrote:
> > Does anyone know what this means?
> > I have an FB1.5 DB backed up and restored into 2.1 server.
> > I am trying to create a view (see below) and the error messages is:
> >
> > 335544351
> > unsuccessful metadata update
> > INTERPRET BUFFER = new record size of 65552 bytes is too big
> >
> > All objects in the view exist. And if I do the eact same thing in a
> newly
> > created 2.1 database, there is no error. Suggests that something
> exists in a
> > new 2.1 which is not created when restored from 1.5.
> > I've tried different page sizes to no avail. My client libaries
> match.
>
> Hi Alan,
>
> Have a look at the FB docs. I don't remember if it is the Release
> Notes or if it is another document that talks about this. But, I know
> there is a document that explains how to resolve this issue.
> Another way is to do a search in the list. This has been discussed
> several times before.
>
> Fidel.
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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
>
>
>