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

From: amsl(dot)sm(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #13789: pg_admin produces table definitiona instead of a view
Date: 2015-12-01 21:33:53
Message-ID: 20151201213353.2771.86443@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: 13789
Logged by: Alex Maslennikov
Email address: amsl(dot)sm(at)gmail(dot)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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2015-12-01 21:35:01 Re: BUG #13788: compile error in generic_msvc.h
Previous Message otheus uibk 2015-12-01 19:04:17 Re: BUG #12447: pgAdmin 1.20.0 missing MSVC redistributables?