Re: [HACKERS] VIP: new format for psql - shell - simple using psql in shell

2012-05-26 Thread Abel Abraham Camarillo Ojeda
On Sat, May 26, 2012 at 11:50 AM, Pavel Stehule wrote: > 2012/5/26 Tom Lane : >> Bruce Momjian writes: >>> On Sat, May 26, 2012 at 05:39:23PM +0200, Pavel Stehule wrote: I proposed new psql's format "shell". This format is optimized for processing returned result in shell: >> >>> I am u

Re: [HACKERS] CREATE DOMAIN json vs built-in json

2012-03-20 Thread Abel Abraham Camarillo Ojeda
On Tue, Mar 20, 2012 at 2:47 AM, Abel Abraham Camarillo Ojeda wrote: > On Tue, Mar 20, 2012 at 2:44 AM, Hitoshi Harada wrote: >> I've noticed our plv8 regression test now fails.  It has CREATE DOMAIN >> json AS text ... and validates text via v8's JSON.parse(), wh

Re: [HACKERS] CREATE DOMAIN json vs built-in json

2012-03-20 Thread Abel Abraham Camarillo Ojeda
On Tue, Mar 20, 2012 at 2:44 AM, Hitoshi Harada wrote: > I've noticed our plv8 regression test now fails.  It has CREATE DOMAIN > json AS text ... and validates text via v8's JSON.parse(), which was > working before introducing built-in json type.  The test itself can be > solved simply by creatin

Re: [HACKERS] Enhanced psql in core?

2011-07-09 Thread Abel Abraham Camarillo Ojeda
On Sat, Jul 9, 2011 at 8:14 PM, Jaime Casanova wrote: > On Sat, Jul 9, 2011 at 5:29 AM, hubert depesz lubaczewski > wrote: >> hi, >> would it be possible to incorporate >> http://www.postgres.cz/index.php/Enhanced-psql in core PostgreSQL/psql? >> >> This patch adds lots of nice functionalities, w

Re: [HACKERS] Extra check in 9.0 exclusion constraint unintended consequences

2011-07-05 Thread Abel Abraham Camarillo Ojeda
9.1 because there are other operators for which that might not > be true, like <>, but the use case is a little more obscure. > > However, values don't always overlap with themselves -- for instance the > empty period (which was an oversight by me). So, Abel Abraham Camaril

Re: [HACKERS] Difference in postgres9.0.4 and postgres9.1beta1 when displaying error lines in functions with comments

2011-06-09 Thread Abel Abraham Camarillo Ojeda
Thanks... and sorry for sending it to hackers list... I had not read the bug reporting guides... nor the release notes... it seems. Again, thanks. On Thu, Jun 9, 2011 at 9:22 PM, Tom Lane wrote: > Abel Abraham Camarillo Ojeda writes: >> Postgres 9.0.4 and postgres9.1beta1 give diffe

[HACKERS] Difference in postgres9.0.4 and postgres9.1beta1 when displaying error lines in functions with comments

2011-06-09 Thread Abel Abraham Camarillo Ojeda
Postgres 9.0.4 and postgres9.1beta1 give different line of error numbers on functions that raise runtime errors (it seems). How to reproduce, given the next SQL file: $ cat /tmp/sql begin; CREATE FUNCTION pg_temp.commchecksql() returns boolean strict language plpgsql as $$ begin -- SQL comment p