>Subject: [pgadmin-support] 'order by' clause lost when
>Date: 28 August 2001 13:19
>When I created a view in pgAdmin II using a SELECT statement that
>includes an ORDER BY clause, pgAdmin seemed to ignore that clause.
>The generated SQL shown with the view properties clearly does not
>that clause, even though the original SQL as shown in the
>area does have that clause. The same view definition works fine
>I create it directly in psql.
>Why does pgAdmin translate the view definition SELECT statement
>different form, rather than using it verbatim?
It shouldn't. I don't have the code near me until tomorrow, but as far
as I can recall nothing is done with the view definition at all -
there is no reason for pgAdmin to parse the SQL so it doesn't.
I'll take a look tomorrow and see if anything else might be causing
the symptoms you're seeing.
pgadmin-support by date
|Next:||From: Marc G. Fournier||Date: 2001-08-29 03:44:16|
|Subject: List archives moved and cleaned up ...|
|Previous:||From: fred||Date: 2001-08-28 12:16:37|
|Subject: 'order by' clause lost when creating view|