[GENERAL] Re: [GENERAL] Love Your Database project — Thoughts on effectively handling constraints? - Mailing list pgsql-general

From Guyren Howe
Subject [GENERAL] Re: [GENERAL] Love Your Database project — Thoughts on effectively handling constraints?
Date
Msg-id 338985BB-5472-430B-9E06-3FF0E27AB047@gmail.com
Whole thread Raw
In response to Re: [GENERAL] Love Your Database project — Thoughts on effectively handling constraints?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Dec 16, 2016, at 16:52 , Tom Lane <tgl@sss.pgh.pa.us> wrote:

The server already does deliver more-structured error data, although I confess
that I have no idea how to get at it in Ruby on Rails.  In psql the case
looks about like this:

Thanks for the advice. I’ve worked out how to get at the same information you showed (it’s available as PG::Result#error_field()). At this point, I just want to show that it is in principle possible to handle PG validations elegantly, so I can write this up and move on to the next thing.

The obvious thing to cover next I think is stored procedures. I think I will cover writing them in PgSQL and ECMAScript. Is there anything I should cover that your average web developer might not know about this that they should? Debugging stored procedures is one thing that comes to mind; I’ll take advice on that or anything else anyone thinks I should share.

pgsql-general by date:

Previous
From: David Steele
Date:
Subject: Re: [GENERAL] Checking data checksums...
Next
From: Torsten Förtsch
Date:
Subject: Re: [GENERAL] Checking data checksums...