Subject Re: [ib-support] external tables & backup/restore
Author Nick Upson
I'v attached the entire output in a file to avoid work-wraps

>select * from rdb$relations where rdb$relation_name = 'TBL';

nothing obvious to my untrained eye

>select * from rdb$relation_fields rf join rdb$fields f
>on rf.rdb$field_source = f.rdb$field_name
>where rf.rdb$relation_name = 'TBL'
>order by rf.rdb$field_name;

the field RDB$FIELD_SUB_TYPE is blank in the pre-backup query
it contains 0 following the restore

>
> > >Maybe it's a bug in v4's gbak?
> >
> > but has it been fixed in a later version?
>
>I don't know. I never saw it documented or acknowledged, sorry.

maybe it still needs to be fixed

_________________________________________________________________
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx

----------


select * from rdb$relations where rdb$relation_name = 'BX_BOARD';

RDB$VIEW_BLR RDB$VIEW_SOURCE RDB$DESCRIPTION RDB$RELATION_ID RDB$SYSTEM_FLAG
RDB$DBKEY_LENGTH RDB$FORMAT RDB$FIELD_ID RDB$RELATION_NAME
RDB$SECURITY_CLASS RDB$EXTERNAL_FILE all
field -> are blank
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
33 0
8 5 29 BX_BOARD
SQL$BX_BOARD /usr/jam7/data/external/zboard.dat

RDB$VIEW_BLR RDB$VIEW_SOURCE RDB$DESCRIPTION RDB$RELATION_ID RDB$SYSTEM_FLAG
RDB$DBKEY_LENGTH RDB$FORMAT RDB$FIELD_ID RDB$RELATION_NAME
RDB$SECURITY_CLASS RDB$EXTERNAL_FILE
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
33 0
8 2 27 BX_BOARD
SQL$BX_BOARD /usr/jam7/data/external/zboard.dat

select * from rdb$relation_fields rf join rdb$fields f
on rf.rdb$field_source = f.rdb$field_name
where rf.rdb$relation_name = 'BX_BOARD'
order by rf.rdb$field_name;

RDB$FIELD_NAME RDB$RELATION_NAME
RDB$FIELD_SOURCE RDB$QUERY_NAME
RDB$BASE_FIELD RDB$EDIT_STRING

RDB$FIELD_POSITION RDB$QUERY_HEADER RDB$UPDATE_FLAG RDB$FIELD_ID
RDB$VIEW_CONTEXT RDB$DESCRIPTION RDB$DEFAULT_VALUE RDB$SYSTEM_FLAG
RDB$SECURITY_CLASS RDB$COMPLEX_NAME
RDB$NULL_FLAG RDB$DEFAULT_SOURCE RDB$COLLATION_ID RDB$FIELD_NAME1
RDB$QUERY_NAME1 RDB$VALIDATION_BLR
RDB$VALIDATION_SOURCE RDB$COMPUTED_BLR RDB$COMPUTED_SOURCE
RDB$DEFAULT_VALUE1 RDB$DEFAULT_SOURCE1 RDB$FIELD_LENGTH RDB$FIELD_SCALE
RDB$FIELD_TYPE RDB$FIELD_SUB_TYPE RDB$MISSING_VALUE RDB$MISSING_SOURCE
RDB$DESCRIPTION1 RDB$SYSTEM_FLAG1 RDB$QUERY_HEADER1 RDB$SEGMENT_LENGTH
RDB$EDIT_STRING1
RDB$EXTERNAL_LENGTH
RDB$EXTERNAL_SCALE RDB$EXTERNAL_TYPE RDB$DIMENSIONS RDB$NULL_FLAG1
RDB$CHARACTER_LENGTH RDB$COLLATION_ID1 RDB$CHARACTER_SET_ID
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
BX_BD_CALIPER BX_BOARD RDB$11


2
1 2
0
0
RDB$11

4 0 14
0



4
0
BX_BD_DATE_UPDATED BX_BOARD RDB$13


4
1 4
0
0
RDB$13

10 0 14
0



10
0
BX_BD_GSM BX_BOARD RDB$14


5
1 5
0
0
RDB$14

4 0 14
0



4
0
BX_BD_MILL BX_BOARD RDB$12


3
1 3
0
0
RDB$12

20 0 14
0



20
0
BX_BD_NAME BX_BOARD RDB$10


1
1 1
0
0
RDB$10

25 0 14
0



25
0
BX_BD_PRICE_1 BX_BOARD RDB$15


6
1 6
0
0
RDB$15

7 0 14
0



7
0
BX_BD_PRICE_10 BX_BOARD RDB$24


15
1 15
0
0
RDB$24

7 0 14
0



7
0
BX_BD_PRICE_2 BX_BOARD RDB$16


7
1 7
0
0
RDB$16

7 0 14
0



7
0
BX_BD_PRICE_3 BX_BOARD RDB$17


8
1 8
0
0
RDB$17

7 0 14
0



7
0
BX_BD_PRICE_4 BX_BOARD RDB$18


9
1 9
0
0
RDB$18

7 0 14
0



7
0
BX_BD_PRICE_5 BX_BOARD RDB$19


10
1 10
0
0
RDB$19

7 0 14
0



7
0
BX_BD_PRICE_6 BX_BOARD RDB$20


11
1 11
0
0
RDB$20

7 0 14
0



7
0
BX_BD_PRICE_7 BX_BOARD RDB$21


12
1 12
0
0
RDB$21

7 0 14
0



7
0
BX_BD_PRICE_8 BX_BOARD RDB$22


13
1 13
0
0
RDB$22

7 0 14
0



7
0
BX_BD_PRICE_9 BX_BOARD RDB$23


14
1 14
0
0
RDB$23

7 0 14
0



7
0
BX_BD_REF BX_BOARD RDB$9


0
1 0
0
0
RDB$9

6 0 14
0



6
0
BX_BD_TONNAGE_1 BX_BOARD RDB$25


16
1 16
0
0
RDB$25

6 0 14
0



6
0
BX_BD_TONNAGE_10 BX_BOARD RDB$34


25
1 25
0
0
RDB$34

6 0 14
0



6
0
BX_BD_TONNAGE_2 BX_BOARD RDB$26


17
1 17
0
0
RDB$26

6 0 14
0



6
0
BX_BD_TONNAGE_3 BX_BOARD RDB$27


18
1 18
0
0
RDB$27

6 0 14
0



6
0
BX_BD_TONNAGE_4 BX_BOARD RDB$28


19
1 19
0
0
RDB$28

6 0 14
0



6
0
BX_BD_TONNAGE_5 BX_BOARD RDB$29


20
1 20
0
0
RDB$29

6 0 14
0



6
0
BX_BD_TONNAGE_6 BX_BOARD RDB$30


21
1 21
0
0
RDB$30

6 0 14
0



6
0
BX_BD_TONNAGE_7 BX_BOARD RDB$31


22
1 22
0
0
RDB$31

6 0 14
0



6
0
BX_BD_TONNAGE_8 BX_BOARD RDB$32


23
1 23
0
0
RDB$32

6 0 14
0



6
0
BX_BD_TONNAGE_9 BX_BOARD RDB$33


24
1 24
0
0
RDB$33

6 0 14
0



6
0
FILLER1 BX_BOARD RDB$1006


26
1 28
0
0
RDB$1006

57 0 14
0

RDB$FIELD_NAME RDB$RELATION_NAME
RDB$FIELD_SOURCE RDB$QUERY_NAME
RDB$BASE_FIELD RDB$EDIT_STRING

RDB$FIELD_POSITION RDB$QUERY_HEADER RDB$UPDATE_FLAG RDB$FIELD_ID
RDB$VIEW_CONTEXT RDB$DESCRIPTION RDB$DEFAULT_VALUE RDB$SYSTEM_FLAG
RDB$SECURITY_CLASS RDB$COMPLEX_NAME
RDB$NULL_FLAG RDB$DEFAULT_SOURCE RDB$COLLATION_ID RDB$FIELD_NAME1
RDB$QUERY_NAME1 RDB$VALIDATION_BLR
RDB$VALIDATION_SOURCE RDB$COMPUTED_BLR RDB$COMPUTED_SOURCE
RDB$DEFAULT_VALUE1 RDB$DEFAULT_SOURCE1 RDB$FIELD_LENGTH RDB$FIELD_SCALE
RDB$FIELD_TYPE RDB$FIELD_SUB_TYPE RDB$MISSING_VALUE RDB$MISSING_SOURCE
RDB$DESCRIPTION1 RDB$SYSTEM_FLAG1 RDB$QUERY_HEADER1 RDB$SEGMENT_LENGTH
RDB$EDIT_STRING1
RDB$EXTERNAL_LENGTH
RDB$EXTERNAL_SCALE RDB$EXTERNAL_TYPE RDB$DIMENSIONS RDB$NULL_FLAG1
RDB$CHARACTER_LENGTH RDB$COLLATION_ID1 RDB$CHARACTER_SET_ID
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
BX_BD_CALIPER BX_BOARD RDB$11


2
1 2
0
0
RDB$11

4 0 14
0 0



4 0
BX_BD_DATE_UPDATED BX_BOARD RDB$13


4
1 13
0
0
RDB$13

10 0 14
0 0



10 0
BX_BD_GSM BX_BOARD RDB$14


5
1 0
0
0
RDB$14

4 0 14
0 0



4 0
BX_BD_MILL BX_BOARD RDB$12


3
1 1
0
0
RDB$12

20 0 14
0 0



20 0
BX_BD_NAME BX_BOARD RDB$10


1
1 26
0
0
RDB$10

25 0 14
0 0



25 0
BX_BD_PRICE_1 BX_BOARD RDB$15


6
1 25
0
0
RDB$15

7 0 14
0 0



7 0
BX_BD_PRICE_10 BX_BOARD RDB$24


15
1 16
0
0
RDB$24

7 0 14
0 0



7 0
BX_BD_PRICE_2 BX_BOARD RDB$16


7
1 24
0
0
RDB$16

7 0 14
0 0



7 0
BX_BD_PRICE_3 BX_BOARD RDB$17


8
1 23
0
0
RDB$17

7 0 14
0 0



7 0
BX_BD_PRICE_4 BX_BOARD RDB$18


9
1 22
0
0
RDB$18

7 0 14
0 0



7 0
BX_BD_PRICE_5 BX_BOARD RDB$19


10
1 21
0
0
RDB$19

7 0 14
0 0



7 0
BX_BD_PRICE_6 BX_BOARD RDB$20


11
1 20
0
0
RDB$20

7 0 14
0 0



7 0
BX_BD_PRICE_7 BX_BOARD RDB$21


12
1 19
0
0
RDB$21

7 0 14
0 0



7 0
BX_BD_PRICE_8 BX_BOARD RDB$22


13
1 18
0
0
RDB$22

7 0 14
0 0



7 0
BX_BD_PRICE_9 BX_BOARD RDB$23


14
1 17
0
0
RDB$23

7 0 14
0 0



7 0
BX_BD_REF BX_BOARD RDB$9


0
1 14
0
0
RDB$9

6 0 14
0 0



6 0
BX_BD_TONNAGE_1 BX_BOARD RDB$25


16
1 12
0
0
RDB$25

6 0 14
0 0



6 0
BX_BD_TONNAGE_10 BX_BOARD RDB$34


25
1 3
0
0
RDB$34

6 0 14
0 0



6 0
BX_BD_TONNAGE_2 BX_BOARD RDB$26


17
1 11
0
0
RDB$26

6 0 14
0 0



6 0
BX_BD_TONNAGE_3 BX_BOARD RDB$27


18
1 10
0
0
RDB$27

6 0 14
0 0



6 0
BX_BD_TONNAGE_4 BX_BOARD RDB$28


19
1 9
0
0
RDB$28

6 0 14
0 0



6 0
BX_BD_TONNAGE_5 BX_BOARD RDB$29


20
1 8
0
0
RDB$29

6 0 14
0 0



6 0
BX_BD_TONNAGE_6 BX_BOARD RDB$30


21
1 7
0
0
RDB$30

6 0 14
0 0



6 0
BX_BD_TONNAGE_7 BX_BOARD RDB$31


22 <br/><br/>(Message over 64 KB, truncated)