Re: [GENERAL] pg_dump ignoring without oids

2008-04-03 Thread Tom Lane
"Chris Velevitch" <[EMAIL PROTECTED]> writes: > On Fri, Apr 4, 2008 at 4:33 PM, Tom Lane <[EMAIL PROTECTED]> wrote: >> "Chris Velevitch" <[EMAIL PROTECTED]> writes: >>> I'm using Centos 5. >> >> Um ... Red Hat, who are about as conservative as they come on this type >> of issue, shipped PG 8.1.x i

Re: [GENERAL] pg_dump ignoring without oids

2008-04-03 Thread Chris Velevitch
On Fri, Apr 4, 2008 at 4:33 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > "Chris Velevitch" <[EMAIL PROTECTED]> writes: > > On Fri, Apr 4, 2008 at 2:50 PM, Chris Velevitch > > <[EMAIL PROTECTED]> wrote: > >> In the mean time, which download has only the 7.4 utils and can that > >> be installed with

Re: [GENERAL] pg_dump ignoring without oids

2008-04-03 Thread Tom Lane
"Chris Velevitch" <[EMAIL PROTECTED]> writes: > On Fri, Apr 4, 2008 at 2:50 PM, Chris Velevitch > <[EMAIL PROTECTED]> wrote: >> In the mean time, which download has only the 7.4 utils and can that >> be installed without removing my 8.1 utils. > I'm using Centos 5. Um ... Red Hat, who are about a

Re: [GENERAL] pg_dump ignoring without oids

2008-04-03 Thread Chris Velevitch
On Fri, Apr 4, 2008 at 2:50 PM, Chris Velevitch <[EMAIL PROTECTED]> wrote: > In the mean time, which download has only the 7.4 utils and can that > be installed without removing my 8.1 utils. I'm using Centos 5. Chris -- Chris Velevitch Manager - Sydney Flash Platform Developers Group m: 0415

Re: [GENERAL] pg_dump ignoring without oids

2008-04-03 Thread Chris Velevitch
On Fri, Apr 4, 2008 at 1:45 PM, Colin Wetherbee <[EMAIL PROTECTED]> wrote: > If you're moving from 7.4.7 to 7.4.13, why don't you use the 7.4 utilities? > The 8.1 utilities assume 8.1 defaults, which can be quite different from 7.4 > defaults and, IIRC, are responsible for your OID issue. I've be

Re: [GENERAL] pg_dump ignoring without oids

2008-04-03 Thread Colin Wetherbee
Chris Velevitch wrote: I'm transferring a database from 7.4.7 to 7.4.13 using 8.1.11 utilities and pg_dump leaves out the "without oids" clause in the create table commands. I've confirmed the original tables are created without oids by using pgadmin3 v1.8.2. How do I get the table created wi

Re: [GENERAL] pg_dump ignoring without oids

2008-04-03 Thread Tom Lane
"Chris Velevitch" <[EMAIL PROTECTED]> writes: > I'm transferring a database from 7.4.7 to 7.4.13 using 8.1.11 > utilities Why in the world would you try that, rather than using 7.4's pg_dump? At no time has pg_dump version N claimed to produce output that was loadable into server versions < N. >