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.
