On 25.3.2012 01:39, Jonathan Hoser wrote:

and again encountered the issue I suggested a patch for.
This time, I applied the suggested variant
"Select label from [...]" and it is working all the same.

It is triggered on a rhn_register call from a client.
Please find the corresponding patch attached.

Sorry for joining this thread so late, but you said;


> Added 'as' to the SQL command, since PostgreSQL 9.x
> (possibly also 8.x) stumbles over it

What do you mean "stumbles"? Can you point me to some error message?
I installed pg 9.1 to test it and I did:

psql (9.1.3)
Type "help" for help.

postgres=# create table test (id int);
CREATE TABLE
postgres=# select id from test;
 id
----
(0 rows)

postgres=# select id from test t;
 id
----
(0 rows)

postgres=# select t.id from test t;
 id
----
(0 rows)

postgres=# select t.id id from test t;
 id
----
(0 rows)

postgres=# select t.id as id from test t;
 id
----
(0 rows)

And I see no errors from PostgreSQL server in all cases.

Mirek

_______________________________________________
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel

Reply via email to