pg_dump -t broken for mixed case table names in beta3?
| От | Kevin Grittner |
|---|---|
| Тема | pg_dump -t broken for mixed case table names in beta3? |
| Дата | |
| Msg-id | 456C395A.EE98.0025.0@wicourts.gov обсуждение исходный текст |
| Ответы |
Re: pg_dump -t broken for mixed case table names in beta3?
|
| Список | pgsql-hackers |
Unless I'm missing something, pg_dump is not allowing selective dump of
a table where the table name is mixed case. The -t switch still works
for lower case. Even though quotes weren't previously needed on the
pg_dump command line, I tried that with no better luck.
postgres@DTR3:~> psql dtr
Welcome to psql 8.2beta3, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms \h for help with SQL commands \? for help with psql commands \g
orterminate with semicolon to execute query \q to quit
dtr=# \d "DbTranLogRecord" Table "public.DbTranLogRecord" Column | Type | Modifiers
----------------+-------------------+-----------countyNo | "CountyNoT" | not nulltranImageSeqNo |
"TranImageSeqNoT"| not nulllogRecordSeqNo | "LogRecordSeqNoT" | not nulloperation | "OperationT" | not
nulltableName | "TableNameT" | not null
Indexes: "DbTranLogRecordPK" PRIMARY KEY, btree ("countyNo",
"tranImageSeqNo", "logRecordSeqNo") "DbTranLogRecord_tableName" btree ("countyNo", "tableName",
operation)
dtr=# \q
postgres@DTR3:~> pg_dump -s -t DbTranLogRecord dtr
pg_dump: No matching tables were found
postgres@DTR3:~>
В списке pgsql-hackers по дате отправления: