Re: [GENERAL] youtube video on pgsql integrity

2012-11-29 Thread Gavan Schneider
Tom, thanks for the reply On Thursday, November 29, 2012 at 12:58, Tom Lane wrote: Gavan Schneider writes: pendari=> select now()/0; Bus error: 10 [ scratches head... ] I get the expected error report on my own OS X 10.7.5 machine (though it's just plain Lion not Server). As of Lion the Se

Re: [GENERAL] youtube video on pgsql integrity

2012-11-29 Thread Tom Lane
Gavan Schneider writes: > pendari=> select now()/0; > Bus error: 10 [ scratches head... ] I get the expected error report on my own OS X 10.7.5 machine (though it's just plain Lion not Server). This looks like it's a psql-side problem, not a server-side problem, particularly since you

Re: [GENERAL] youtube video on pgsql integrity

2012-11-29 Thread Gavan Schneider
On Friday, November 30, 2012 at 02:30, czisg0s...@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". H... that looked amusing in a perverse way, and a

Re: [GENERAL] youtube video on pgsql integrity

2012-11-29 Thread Mike Christensen
On Thu, Nov 29, 2012 at 9:41 AM, Shaun Thomas wrote: > On 11/29/2012 07:48 AM, Ray Stell wrote: > > > http://www.youtube.com/watch?**v=1PoFIohBSM4 >> > > To be fair to MySQL, you can turn all that "helpfulness" off if you set > the SQL mode: > > https:

Re: [GENERAL] youtube video on pgsql integrity

2012-11-29 Thread Gavin Flower
On 30/11/12 04:30, Chris Angelico wrote: On Fri, Nov 30, 2012 at 2:00 AM, Ray Stell wrote: On Nov 29, 2012, at 9:27 AM, Kevin Grittner wrote: is everything shown there really the behavior of the MySQL database itself? Good question. I intend to install mysql one day to explore, but just can'

Re: [GENERAL] youtube video on pgsql integrity

2012-11-29 Thread Shaun Thomas
On 11/29/2012 07:48 AM, Ray Stell wrote: http://www.youtube.com/watch?v=1PoFIohBSM4 To be fair to MySQL, you can turn all that "helpfulness" off if you set the SQL mode: https://dev.mysql.com/doc/refman/5.5/en/server-sql-mode.html Amusingly enough, they actually have a POSTGRESQL mode. ;)

Re: [GENERAL] youtube video on pgsql integrity

2012-11-29 Thread Zdeněk Bělehrádek
Dne Thu, 29 Nov 2012 16:00:55 +0100 Ray Stell napsal(a): On Nov 29, 2012, at 9:27 AM, Kevin Grittner wrote: is everything shown there really the behavior of the MySQL database itself? Good question. I intend to install mysql one day to explore, but just can't find the time. The particul

Re: [GENERAL] youtube video on pgsql integrity

2012-11-29 Thread Chris Angelico
On Fri, Nov 30, 2012 at 2:00 AM, Ray Stell wrote: > > On Nov 29, 2012, at 9:27 AM, Kevin Grittner wrote: >> is everything shown there really >> the behavior of the MySQL database itself? > > Good question. I intend to install mysql one day to explore, but just can't > find the time. The particu

Re: [GENERAL] youtube video on pgsql integrity

2012-11-29 Thread Ray Stell
On Nov 29, 2012, at 9:27 AM, Kevin Grittner wrote: > is everything shown there really > the behavior of the MySQL database itself? Good question. I intend to install mysql one day to explore, but just can't find the time. The particular engine is not disclosed and I've read some are better th

Re: [GENERAL] youtube video on pgsql integrity

2012-11-29 Thread Thomas Kellerer
Kevin Grittner, 29.11.2012 15:27: Ray Stell wrote: http://www.youtube.com/watch?v=1PoFIohBSM4 I really don't want to get into bashing another product or starting a flame war, but I'm curious -- is everything shown there really the behavior of the MySQL database itself? Yes, it is. It *is*

Re: [GENERAL] youtube video on pgsql integrity

2012-11-29 Thread Kevin Grittner
Ray Stell wrote: > http://www.youtube.com/watch?v=1PoFIohBSM4 I really don't want to get into bashing another product or starting a flame war, but I'm curious -- is everything shown there really the behavior of the MySQL database itself? It's not the front-end tool or something? It's hard to beli