which index? could you help me again?
Eric Anderson Martins Miranda
Net Admin @ Via Net SAO
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Eric Anderson Vianet SAO" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, June 1
"Eric Anderson Vianet SAO" <[EMAIL PROTECTED]> writes:
> Sorry about this sucks thread but now i´v got following error
> ERROR: relation "pg_toast_26474986" is of type "t"
You may have to use REINDEX INDEX (on the index not the toast table of
course) to get it to work in older versions. REINDEX d
Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Eric Anderson Vianet SAO" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, June 17, 2003 11:55 AM
Subject: Re: [SQL] yet pg_toast reindex
> "Eric Anderson Vianet SAO" <[EMAIL PRO
"Eric Anderson Vianet SAO" <[EMAIL PROTECTED]> writes:
> When I try to reindex a toast table with command ´REINDEX TABLE
> pg_toast_16557' I receive following error message:
> ERROR: "pg_toast_16557" is a system table. call REINDEX under standalone
> postgres with -O -P options
> So I restart postm
When I try to reindex a toast table with command ´REINDEX TABLE
pg_toast_16557' I receive following error message:
ERROR: "pg_toast_16557" is a system table. call REINDEX under standalone
postgres with -O -P options
So I restart postmaster standalone (no -i option) and I receive same error.
how
