Postgres Pro
Downloads
Home   >   mailing lists

reindexdb -t schema.table name - Mailing list pgsql-admin

From dx k9
Subject reindexdb -t schema.table name
Date
Msg-id COL120-W47692710D810C5ADEF08C8D1440@phx.gbl
Whole thread Raw
Responses Re: reindexdb -t schema.table name  (Andy Shellam <andy-lists@networkmail.eu>)
List pgsql-admin
Tree view
Hi all,

I'm having trouble reindexing a table in a schema other than public, called history.

This syntax isn't working.

reindexdb -h fido -p 5432 -d abc -t history._name_history

reindexdb: reindexing of table "history._name_history" in database "abc" failed: ERROR:  relation"h                                                                                                                            istory._name_history" does not exist

I also tried it with double quotes.  -t "history._name_history.  The table is actually _name_history.

Thanks in advance,
~DjK                                                                                      


Windows Live™ SkyDrive™: Get 25 GB of free online storage. Get it on your BlackBerry or iPhone.

pgsql-admin by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Add pre-existing tablespace to new installation
Next
From: Andy Shellam
Date:
Subject: Re: reindexdb -t schema.table name