On Fri, 2006-11-10 at 11:23 -0500, Tom Lane wrote: > "Alex Turner" <armtuk@xxxxxxxxx> writes: > > Well yes - thats what I mean, the definition for the index. It's not > > dumping the index defs. It also looks like it's not dumping roles fully > > either. I was missing grants from the dump too. > > [ raised eyebrow... ] Let's see a test case. Alex, what Tom is saying here is... this is likely user error :). Can you provide the exact pg_dump command you are using? Sincerely, Joshua D. Drake > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate