From: | David Johnston <polobo(at)yahoo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: PG 9.3 complains about specified more than once ??? Those views worked in PG 9.1 + 9.2 |
Date: | 2013-09-11 19:02:25 |
Message-ID: | 1378926145889-5770510.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Andreas-3-2 wrote
> Hi,
>
> *I ran into a major problem when I tried to import a backup from 9.1.
> into a 9.3 PG.*
>
> I just installed PG 9.3 on a new linux box.
> Then I wanted to import a plaintext dump of a DB that was created by
> pg_dump of PG 9.1
>
> There are a lot of views that have joins to a subquery in the from-clause.
>
> something like
>
> SELECT ... some columns ...
> FROM
> maintable AS m
> JOIN someflag AS f ON m.flag_1_id = f.id
> LEFT JOIN
> (
> child_table AS c
> JOIN someotherflag AS f ON c.flag_2_id = f.id
> ) AS x ON m.id = x.main_id
>
> This works with PG 9.1 and PG 9.2 but PG 9.3 complains:
>
> ERROR: table name "f" specified more than once
>
> *Are there no separate namespaces for subqueries anymore in PG 9.3 ?*
>
> Do I have to change ALL those views in the old PG 9.1 server before I
> can import the backup into 9.3 or is there another way to work around
> this issue ?
Not running 9.3 yet so cannot test this myself. Ignore the pg_dump and
view. Does (should) the above query work if executed in psql?
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/PG-9-3-complains-about-specified-more-than-once-Those-views-worked-in-PG-9-1-9-2-tp5770489p5770510.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | David Johnston | 2013-09-11 19:09:13 | Re: PG 9.3 complains about specified more than once ??? Those views worked in PG 9.1 + 9.2 |
Previous Message | Adrian Klaver | 2013-09-11 18:17:09 | Re: PG 9.3 complains about specified more than once ??? Those views worked in PG 9.1 + 9.2 |