I need to restore two records from a lost transaction and I am having only the WAL file, managed by Postgresql 7.4.17. The structure of records is:
* Record 1: varchar(400)[] with exact 191 elements, where al least 185 elements are just “*” and at most 6 are string with length>1. Like this {first string,*,*,*,*,*,second string,…}
* Record 2: smallint[] with exact 191 elements, where every element is between [-1 and 8]. Like this {-1,0,7,3,-1,-1,3,4,5,…}
Can anybody give me more information about the implementation of SQL arrays like:
1) hex markers for the beginning, length, or ending of the array
2) way of encoding strings inside the array
3) some idea in which interval should be the size of the encoded array. Should be correct if I say that my first record is more than 191 bytes or not?
4) particular documentation for sql array encoding in the 7.4.17 implementation
10x in advance for any answer!
---
Andrew