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