Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Admin > pg_dump with "-...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 1 Topic 4952 of 5156
Post > Topic >>

pg_dump with "-t" option not dumping OID data?

by afrederico@[EMAIL PROTECTED] ("Andrew Frederico") Apr 29, 2008 at 04:39 PM

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 ex****t:

         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

-- 
Sent via pgsql-admin mailing list (pgsql-admin@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
 




 1 Posts in Topic:
pg_dump with "-t" option not dumping OID data?
afrederico@[EMAIL PROTECT  2008-04-29 16:39:26 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Thu Jul 24 1:25:16 CDT 2008.