PG 9.3 complains about specified more than once ??? Those views worked in PG 9.1 + 9.2
| От | Andreas |
|---|---|
| Тема | PG 9.3 complains about specified more than once ??? Those views worked in PG 9.1 + 9.2 |
| Дата | |
| Msg-id | 5230A017.7040105@gmx.net обсуждение исходный текст |
| Ответы |
Re: PG 9.3 complains about specified more than once ???
Those views worked in PG 9.1 + 9.2
Re: PG 9.3 complains about specified more than once ??? Those views worked in PG 9.1 + 9.2 |
| Список | pgsql-general |
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 ?
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 ?
В списке pgsql-general по дате отправления: