BUG #13789: pg_admin produces table definitiona instead of a view

Поиск
Список
Период
Сортировка
От amsl.sm@gmail.com
Тема BUG #13789: pg_admin produces table definitiona instead of a view
Дата
Msg-id 20151201213353.2771.86443@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #13789: pg_admin produces table definitiona instead of a view  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      13789
Logged by:          Alex Maslennikov
Email address:      amsl.sm@gmail.com
PostgreSQL version: 9.4.5
Operating system:   Windows 7
Description:

I have a view defined with the following sql statement:

CREATE OR REPLACE VIEW my_view AS
(
    select     s.id as start_id
    from start s
    group by s.id
    order by start_date desc
);

When pg_admin exports this view it outputs it as as table not view:

CREATE TABLE my_view (
    start_id integer
);

Removing "order by" from view fixes the problem, but "order by" is a valid
syntax for a view.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: PQexec() hangs on OOM
Следующее
От: Dave Page
Дата:
Сообщение: Re: BUG #12447: pgAdmin 1.20.0 missing MSVC redistributables?