Would a backup/restore change the physical layout to match the logical?

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Ann Harrison
Sent: Wednesday, April 03, 2013 4:54 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] FireBird 2.5 How can i create 1 byte
(0-255) column?

On Wed, Apr 3, 2013 at 12:25 PM, Markus Ostenried <macnoz@...>
wrote:

>
> >
> > ... be
> > careful of the layout of your records. For example, if you sandwich
> > your CHAR[1] between two integer columns, you'll get three bytes of
> > padding so the integers align on natural boundaries.
> >
>
> Out of curiosity:
> Can the "sandwich problem" be controlled via "alter position"? IOW
> does column position affect the record layout on disk?

No, "alter position" just changes the logical position of the columns -
what
you see from a SELECT *. The physical layout is determined when the
table
is defined, and added fields always come last.

Good luck,

Ann

>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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
>
>
>
>

[Non-text portions of this message have been removed]



------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

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