From: | jan(dot)mate(at)inf-it(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #7838: pg_dump major bug |
Date: | 2013-01-29 23:50:14 |
Message-ID: | E1U0KwQ-0005ME-MQ@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 7838
Logged by: Jan Mate
Email address: jan(dot)mate(at)inf-it(dot)com
PostgreSQL version: 9.2.2
Operating system: Debian GNU/Linux
Description:
Today I tried to upgrade from 9.1.7 to 9.2.2 by using:
pg_upgradecluster 9.1 main
The upgrade process failed on one of my VIEWS with syntax error (after I
removed that VIEW, the upgrade process worked well - also there was no
problem with re-creation of the VIEW after the upgrade).
I created a very simple example to reproduce the problem (looks like it is a
pg_dump problem). Here are the links to files used in my example:
- my original SQL queries
http://www.inf-it.com/fixes/postgres-bugreport/test.sql
- result from the pg_dump
http://www.inf-it.com/fixes/postgres-bugreport/test_dump.sql
Steps to reproduce the problem:
$ createdb test
$ psql test < test.sql
$ psql test -c 'SELECT * FROM export_data;'
number | org |
name
------------+----------------------------------------------+----------------------------------
5555551212 | Starfleet or Springfield Nuclear Power Plant | Simpson
Homer or Picard Jean-Luc
(1 row)
$ pg_dump test > test_dump.sql
$ dropdb test
$ createdb test
$ psql test < test_dump.sql
SET
SET
SET
SET
SET
CREATE EXTENSION
COMMENT
SET
SET
SET
CREATE TABLE
ALTER TABLE
ERROR: syntax error at or near "["
LINE 2: ...i'::text) regexp_matches(regexp_matches) LIMIT 1))[1],
'[\\]...
^
ERROR: relation "public.export_data" does not exist
REVOKE
REVOKE
GRANT
GRANT
From | Date | Subject | |
---|---|---|---|
Next Message | Noah Misch | 2013-01-30 01:51:55 | Re: BUG #7493: Postmaster messages unreadable in a Windows console |
Previous Message | Tom Lane | 2013-01-29 22:52:16 | Re: BUG #7836: COPY command does not honor 'FORMAT' option |