Re: BUG #4121: ERROR: could not open relation 1663/16403/469917: Invalid argument

Try to look into base/16403/ directory and check if file 469917 exists. And run


select relname from pg_class where relfilenode=469917


to determine which relation (table) is affected.

        Zdenek

PS: 8.1 version of PostgreSQL is not supported on win. Use 8.3


Boldinov napsal(a):
> The following bug has been logged online:
>
> Bug reference:      4121
> Logged by:          Boldinov
> Email address:      bldnv@mail.ru
> PostgreSQL version: 8.1.5
> Operating system:   Windows Server 2003 Standart
> Description:        ERROR:  could not open relation 1663/16403/469917:
> Invalid argument
> Details:
>
> 2008-04-21 14:35:41 ERROR:  could not open relation 1663/16403/469917:
> Invalid argument
> 2008-04-21 14:35:41 STATEMENT:  SELECT
>     _Reference130._IDRRef AS f_3,
>     _Reference130._Description AS f_4
>     FROM
>     _Reference130
>     WHERE
>     _Reference130._IDRRef =
> '\\200"\\000\\033x0\\004\\032\\021\\334\\250\\246\\360\\024\\017_'::bytea
> AND (FALSE = TRUE OR
>     EXISTS(
>     SELECT
>     0 AS f_2
>     FROM
>     (
>     SELECT
>     TRUE AS _f_1
>     ) _V8TblAli1
>     INNER JOIN _InfoReg16060 _InfoReg16060_Q_000_T_002
>     ON _InfoReg16060_Q_000_T_002._Fld16061_TYPE = '\\010'::bytea AND
> _InfoReg16060_Q_000_T_002._Fld16061_RTRef = '\\000\\000\\000\\236'::bytea
> AND _InfoReg16060_Q_000_T_002._Fld16061_RRRef = _Reference130._OwnerIDRRef
> AND _InfoReg16060_Q_000_T_002._Fld16062RRef =
> '\\205Y\\011U\\377\\362\\015\\220D''_3\\367\\352\\200\\247'::bytea AND
> _InfoReg16060_Q_000_T_002._Fld16063_TYPE = '\\010'::bytea AND
> (_InfoReg16060_Q_000_T_002._Fld16063_RTRef ||
> _InfoReg16060_Q_000_T_002._Fld16063_RRRef) IN ('\\000\\000\\0002'::bytea ||
> '\\200"\\000\\033x0\\004\\032\\021\\334\\262\\273<\\265)4'::bytea,'\\000\\00
> 0\\0002'::bytea ||
> '\\245\\230\\272~\\361\\313\\223fG\\034\\011\\207X\\325q\\016'::bytea,'\\000
> \\000\\000\\324'::bytea ||
> '\\257\\332\\000\\004#R\\244\\374\\021\\334\\206\\326\\355\\252j\\360'::byte
> a) AND _InfoReg16060_Q_000_T_002._Fld16065 = TRUE))
>