reindexdb -t schema.table name

From: dx k9 <bitsandbytes88(at)hotmail(dot)com>
To: posgres support <pgsql-admin(at)postgresql(dot)org>
Subject: reindexdb -t schema.table name
Date: 2009-06-09 18:50:25
Message-ID: COL120-W47692710D810C5ADEF08C8D1440@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


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.
http://windowslive.com/online/skydrive?ocid=TXT_TAGLM_WL_SD_25GB_062009

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andy Shellam 2009-06-09 19:17:54 Re: reindexdb -t schema.table name
Previous Message Alvaro Herrera 2009-06-09 15:35:25 Re: Add pre-existing tablespace to new installation