On Friday, November 30, 2012 at 02:30, czisg0sgmt@sneakemail.com
(Chris Angelico rosuav-at-gmail.com |pg-gts/Basic|) wrote:
>I like his quoting of the error messages. MySQL: now()/0 -> NULL;
>PostgreSQL: now()/0 -> "dude, what are you doing".
>
Hmmmm... that looked amusing in a perverse way, and a diversion
from test cases, so I gave it a try mid psql session, as follows:
pendari=> select '2149Q1'::text similar to '((19)|(20))[0-9]{2}Q[1-4]'::text;
?column?
----------
f
(1 row)
pendari=> select now()/0;
Bus error: 10
pendari:~ gavan$ psql --user=book_keeper --host=localhost pendari
psql: could not connect to server: Connection refused
Is the server running on host "localhost" (127.0.0.1)
and accepting
TCP/IP connections on port 5434?
could not connect to server: Connection refused
Is the server running on host "localhost" (::1) and accepting
TCP/IP connections on port 5434?
could not connect to server: Connection refused
Is the server running on host "localhost" (fe80::1) and accepting
TCP/IP connections on port 5434?
pendari:~ gavan$
Ouch! That is a strange way to say "dude, what are you doing",
even if it is totally accurate.
PostreSQL: 9.2.1
System: Mac OS X Server Lion 10.7.5 (11G63)
Processor: 2.66 GHz Intel Core 2 Duo
RAM: 8 GB 1067 MHz DDR3
Nothing got to the log files
On the assumption that stupid user input should not crash the
server I consider this to be a bug, but also assume there must
be some details in my configuration that have brought this to
light. So what extra information is needed to complete the picture?
Since I did the build myself I have the ./configure output
files, and will see if a core dump has turned up somewhere.
Anything else to add? and, what is the next step?
Regards
Gavan Schneider
PS. Of course I will smile bravely if this is the postgresql
equivalent of being Rick rolled :)
