Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 48DCC2E0033 for ; Tue, 29 Apr 2008 19:46:39 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 52455-03 for ; Tue, 29 Apr 2008 19:46:30 -0300 (ADT) X-Greylist: delayed 00:07:07.247877 by SQLgrey-1.7.5 Received: from fk-out-0910.google.com (fk-out-0910.google.com [209.85.128.187]) by developer.postgresql.org (Postfix) with ESMTP id B4CAF2E0032 for ; Tue, 29 Apr 2008 19:46:35 -0300 (ADT) Received: by fk-out-0910.google.com with SMTP id 19so8837fkr.12 for ; Tue, 29 Apr 2008 15:46:34 -0700 (PDT) Received: by 10.82.174.20 with SMTP id w20mr4287553bue.58.1209508766308; Tue, 29 Apr 2008 15:39:26 -0700 (PDT) Received: by 10.82.166.19 with HTTP; Tue, 29 Apr 2008 15:39:26 -0700 (PDT) Message-ID: <1be1170e0804291539p1b439950k78ed86888928dd9f@mail.gmail.com> Date: Tue, 29 Apr 2008 16:39:26 -0600 From: "Andrew Frederico" To: pgsql-admin@postgresql.org. Subject: pg_dump with "-t" option not dumping OID data? Cc: "Matthew Excell" MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200804/298 X-Sequence-Number: 29062 All, I'm using the "-t" option with "pg_dump" to select only a few tables from a database. Those tables just happen to have OID fields in them. If I dump the -entire- database the OID data comes along with it. If I dump specific -tables,- since it doesn't cascade to dependencies, the OID data is -not- dumped. I have also tried dumping those tables with the "-o" option but with the same result. Here's the actual console command I use: pg_dump -o -v -f 29-april.jasper.ns2.tar -F tar -t '*.j*' -t '*.qrtz*' -T '*.*static' -t '*.rv_*' -t '*.*view' -t '*.wgisbn' -t '*.hibernate_sequence' ucentive Here is the "\d" of the table whose OID data doesn't export: Table "public.jifileresource" Column | Type | Modifiers -----------+-----------------------+----------- id | bigint | not null data | oid | file_type | character varying(20) | reference | bigint | Indexes: "jifileresource_pkey" PRIMARY KEY, btree (id) Foreign-key constraints: "fkf75b58895a0c539" FOREIGN KEY (reference) REFERENCES jifileresource(id) "fkf75b5889a8bf376d" FOREIGN KEY (id) REFERENCES jiresource(id) If anyone has any suggestions where to find this data to specifically dump it or any other suggestions would be appreciated! -- Andrew