[BUGS] BUG #8243: Order by with column ordinal and collate - fails to parse
The following bug has been logged on the website: Bug reference: 8243 Logged by: Tim Kane Email address: tim.k...@gmail.com PostgreSQL version: 9.1.9 Operating system: Debian Description: As per psql general mailing list thread: http://www.postgresql.org/message-id/CADVWZZJd5veDpEi_kgzBJ3uRNuE23Zs=x=az_pewssbfma7...@mail.gmail.com The following query refuses to parse: # select distinct(value) from properties order by 1 collate C; ERROR: collations are not supported by type integer LINE 1: ... distinct(value) from properties order by 1 collate C... ^ # select distinct(value) from properties order by distinct(value) collate C; ERROR: syntax error at or near distinct LINE 1: ...ct distinct(value) from properties order by distinct(v... ^ # select distinct(value) as foo from properties order by foo collate C; ERROR: column foo does not exist LINE 1: ...tinct(value) as foo from properties order by foo collat... The solution was as follows: # select distinct(value) collate C from properties order by 1; It's arguable if this is a bug or not, though I would have expected the first attempt at least to be valid. Cheers, Tim -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] BUG #8241: submisson
The following bug has been logged on the website: Bug reference: 8241 Logged by: Oksana Email address: luk...@novosoft.net PostgreSQL version: 9.2.4 Operating system: windows Description: Hi! Could you please help me with submission, I can`t add an organization and a product. because of «Server Error An internal server error occurred». My data: Novosoft h4ndYb4ckuP This is the info: About Novosoft LLC Novosoft has accumulated an extensive experience in IT-consulting and custom software development over the last 20 years. Nowadays Novosoft delivers its own IT-solutions for home and corporate users. The expertise of the company’s specialists allows Novosoft to create software products of high demand and to stay ahead of the competitors. http://www.novosoft-us.com/ About Handy Backup Handy Backup is a powerful backup tool for Windows 8/7/Vista/XP and Windows Server 2012/2008/2003. The program allows protecting local and remote files, HDD images, MySQL, MS SQL, PostgreSQL, MS Exchange, Oracle, DB2 and other data. Handy Backup is available in several editions suitable for different needs of home and corporate users. http://www.handybackup.net Thank you in advance! Best regards, Oksana http://www.novosoft-us.com Handy Backup http://handybackup.net/ http://handybackup.net/ Email: luk...@novosoft.net Blog: Handy Backup Blog http://blog.handybackup.net/ http://blog.handybackup.net/ Twitter: @Handy_Backup http://twitter.com/Handy_Backup http://twitter.com/Handy_Backup http://www.handybackup.net/templates/handy/images/logo_4.png -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] BUG #8242: No way to debug subquery must return only one column error
The following bug has been logged on the website: Bug reference: 8242 Logged by: boraldomaster Email address: boraldomas...@gmail.com PostgreSQL version: 9.1.2 Operating system: any Description: When I get this message I cannot guess from it's description what really causes this error. I would like to see exactly the subquery that returned more than one column and the row where this happened. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] BUG #8244: Stack Builder 3.1.0 fails with an http proxy because of an incorrect HTTP Host header value
The following bug has been logged on the website: Bug reference: 8244 Logged by: Jos Annevelink Email address: jannevel...@anwb.nl PostgreSQL version: 9.2.4 Operating system: Windows 7 Description: Stack Builder fails to retrieve http://www.postgresql.org/applications-v2.xml. This used to work in the old days when we had direct access to the internet. Now we sitting behind proxies. My conclusion now is that this error is due to an incorrect HTTP Host header value. I experimented a little and changed the proxy to localhost . I also started a local nc -l (nc, i.e netcat inside X-Windows on top of Cygwin). Here is what Stack Builder send and nc received: GET http://www.postgresql.org/applications-v2.xml HTTP/1.0 Host: localhost User-Agent: wxWidgets 2.x The error seems to be the Host header value. It mentions the proxy host (localhost), but should mention the targeted HTTP server (www.postgresql.org). If all this still works for others, then my situation may be compounded by all kinds of traffic auditing and filtering services in our company proxy server stopping the (invalid) request from ever getting to www.postgresql.org. When I use telnet targeting our proxy server and use GET ... HTTP/1.1 in combination with Host: www.postgresql.org, then the request gets thru and the requested xml file is returned. I've installed postgresql-9.2.4-1-windows-x64.exe and I'm running its Stack Builder 3.1.0. All on top the latest Windows 7 Enterprise (64 bit version). -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #8242: No way to debug subquery must return only one column error
boraldomas...@gmail.com writes: When I get this message I cannot guess from it's description what really causes this error. I would like to see exactly the subquery that returned more than one column and the row where this happened. That's a parse-time error, so it's nonsensical to ask for the row where it happened. AFAICS, the parser should give back a syntax-error pointer for this error; for example, when I try to provoke the error in psql, I get =# select * from table1 where id = any(array(select c1,c2 from table2)); ERROR: subquery must return only one column LINE 1: select * from table1 where id = any(array(select c1,c2 ... ^ which shows me that the problem is associated with the ARRAY() construct not accepting multiple input columns. If you're not seeing such an error pointer, it's the fault of whatever client-side software you're working in. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs