Re: youtube video on pgsql integrity

On Friday, November 30, 2012 at 02:30, czisg0sgmt(at)sneakemail(dot)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 :)