From: | Adam Haberlach <adam(at)newsnipple(dot)com> |
---|---|
To: | bugs(at)postgresql(dot)org |
Subject: | pg_dump crashes trying to dump database containing index on oid |
Date: | 2000-05-23 05:29:57 |
Message-ID: | 20000522222957.A24174@ricochet.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Reply-To:
==========================================================================
POSTGRESQL BUG REPORT TEMPLATE
==========================================================================
Your name : Adam Haberlach
Your email address : adam(at)be(dot)com
System Configuration
---------------------
Architecture (example: Intel Pentium) : Intel Pentium II
Operating System (example: Linux 2.0.26 ELF) : Linux version 2.2.2
(adam(at)bugnow) (gcc version 2.7.2.3) #1 Sat Mar 6 02:31:09 PST 1999
PostgreSQL version (example: PostgreSQL-6.5.1): PostgreSQL 7.0.0 on
i686-pc-linux-gnu, compiled by gcc 2.7.2.3
Compiler used (example: gcc 2.8.0) :
Please enter a FULL description of your problem:
------------------------------------------------
pg_dump crashes trying to dump database containing index on oid
Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
createdb snafu
psql -d snafu
CREATE TABLE test (test text);
CREATE INDEX idx_test_oid ON test (oid);
\q
pg_dump snafu
This sequence crashes while gathering index information with:
parseNumericArray: bogus number
This occurs because the 'indkey' field in the query used by pg_dump
contains a '-2', which crashes its Numeric Array parser.
If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------
I believed the simplest fix would be to update the parser to handle the
negative numbers--cursory examination shows that it shouldn't be too
hard. On the other hand, there may be problems with creating indexes
on oids. This database worked just fine with Postgres 6.4.3
--
Adam Haberlach |"You have to understand that the
adam(at)newsnipple(dot)com | entire 'Net is based on people with
http://www.newsnipple.com/ | too much free time on their hands."
From | Date | Subject | |
---|---|---|---|
Next Message | Adam Haberlach | 2000-05-23 05:31:49 | ODBC SELECT WHERE a IN ('frob') returns where a = '' too |
Previous Message | Tom Lane | 2000-05-23 05:27:28 | Re: pg_dump crashes trying to dump database containing index on oid |