pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedyet pg_toast reindex
5+ messages / 2 participants
[nested] [flat]
* yet pg_toast reindex
@ 2003-06-17 12:23 Eric Anderson Vianet SAO <eric@vianet-express.com.br>
0 siblings, 1 reply; 5+ messages in thread
From: Eric Anderson Vianet SAO @ 2003-06-17 12:23 UTC (permalink / raw)
To: pgsql-sql
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 could I reindex it?
tnx
Eric Anderson Martins Miranda
Net Admin @ Via Net SAO
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: yet pg_toast reindex
@ 2003-06-17 14:55 Tom Lane <tgl@sss.pgh.pa.us>
parent: Eric Anderson Vianet SAO <eric@vianet-express.com.br>
0 siblings, 1 reply; 5+ messages in thread
From: Tom Lane @ 2003-06-17 14:55 UTC (permalink / raw)
To: Eric Anderson Vianet SAO <eric@vianet-express.com.br>; +Cc: pgsql-sql
"Eric Anderson Vianet SAO" <eric@vianet-express.com.br> 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 postmaster standalone (no -i option) and I receive same error.
Removing the -i option does not constitute a standalone backend. See
http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=sql-reindex.html
for a detailed description of the procedure you need to follow here.
(7.3 doesn't require this pushup anymore for toast tables, btw.)
regards, tom lane
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: yet pg_toast reindex
@ 2003-06-17 19:31 Eric Anderson Vianet SAO <eric@vianet-express.com.br>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 5+ messages in thread
From: Eric Anderson Vianet SAO @ 2003-06-17 19:31 UTC (permalink / raw)
To: pgsql-sql
Sorry about this sucks thread but now i´v got following error
ERROR: relation "pg_toast_26474986" is of type "t"
I looked for "type t" around documentation and don´t find something usefull.
tnx
Eric Anderson Martins Miranda
Net Admin @ Via Net SAO
----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Eric Anderson Vianet SAO" <eric@vianet-express.com.br>
Cc: <pgsql-sql@postgresql.org>
Sent: Tuesday, June 17, 2003 11:55 AM
Subject: Re: [SQL] yet pg_toast reindex
> "Eric Anderson Vianet SAO" <eric@vianet-express.com.br> 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 postmaster standalone (no -i option) and I receive same
error.
>
> Removing the -i option does not constitute a standalone backend. See
>
http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=sql-reindex.
html
> for a detailed description of the procedure you need to follow here.
>
> (7.3 doesn't require this pushup anymore for toast tables, btw.)
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: yet pg_toast reindex
@ 2003-06-17 23:50 Tom Lane <tgl@sss.pgh.pa.us>
parent: Eric Anderson Vianet SAO <eric@vianet-express.com.br>
0 siblings, 1 reply; 5+ messages in thread
From: Tom Lane @ 2003-06-17 23:50 UTC (permalink / raw)
To: Eric Anderson Vianet SAO <eric@vianet-express.com.br>; +Cc: pgsql-sql
"Eric Anderson Vianet SAO" <eric@vianet-express.com.br> 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 didn't use to
think it could work on toast tables.
regards, tom lane
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: yet pg_toast reindex
@ 2003-06-18 12:39 Eric Anderson Vianet SAO <eric@vianet-express.com.br>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 5+ messages in thread
From: Eric Anderson Vianet SAO @ 2003-06-18 12:39 UTC (permalink / raw)
To: pgsql-sql
which index? could you help me again?
Eric Anderson Martins Miranda
Net Admin @ Via Net SAO
----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Eric Anderson Vianet SAO" <eric@vianet-express.com.br>
Cc: <pgsql-sql@postgresql.org>
Sent: Tuesday, June 17, 2003 8:50 PM
Subject: Re: [SQL] yet pg_toast reindex
> "Eric Anderson Vianet SAO" <eric@vianet-express.com.br> 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 didn't use to
> think it could work on toast tables.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2003-06-18 12:39 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-06-17 12:23 yet pg_toast reindex Eric Anderson Vianet SAO <eric@vianet-express.com.br>
2003-06-17 14:55 ` Tom Lane <tgl@sss.pgh.pa.us>
2003-06-17 19:31 ` Eric Anderson Vianet SAO <eric@vianet-express.com.br>
2003-06-17 23:50 ` Tom Lane <tgl@sss.pgh.pa.us>
2003-06-18 12:39 ` Eric Anderson Vianet SAO <eric@vianet-express.com.br>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox