Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id D59A89FA274 for ; Tue, 28 Nov 2006 15:28:24 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 18466-03 for ; Tue, 28 Nov 2006 15:28:06 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from gwmta.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by postgresql.org (Postfix) with ESMTP id 17D2D9FA231 for ; Tue, 28 Nov 2006 15:28:07 -0400 (AST) Received: from Courts-MTA by gwmta.wicourts.gov with Novell_GroupWise; Tue, 28 Nov 2006 13:28:07 -0600 Message-Id: <456C395A.EE98.0025.0@wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 7.0.1 Date: Tue, 28 Nov 2006 13:27:55 -0600 From: "Kevin Grittner" To: Subject: pg_dump -t broken for mixed case table names in beta3? Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/918 X-Sequence-Number: 94380 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 or terminate with semicolon to execute query \q to quit dtr=# \d "DbTranLogRecord" Table "public.DbTranLogRecord" Column | Type | Modifiers ----------------+-------------------+----------- countyNo | "CountyNoT" | not null tranImageSeqNo | "TranImageSeqNoT" | not null logRecordSeqNo | "LogRecordSeqNoT" | not null operation | "OperationT" | not null tableName | "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:~>