Re: [HACKERS] row_to_json bug with index only scans: empty keys!

2014-11-10 Thread Ross Reedstrom
t json/jsonb usage to really > take off with 9.4, it might be better if we get row_to_json behaving > unsurprisingly now. But I'm not dead set on it. > > regards, tom lane > -- Ross Reedstrom, Ph.D. reeds...@ric

Re: [HACKERS] row_to_json bug with index only scans: empty keys!

2014-11-08 Thread Ross Reedstrom
regression=# select row_to_json(q) from vv q(a,b); >row_to_json > - > {"f1":1,"f2":2} > (1 row) > > So that's another case we probably want to change in HEAD but not the back > branches. > > regards,

[HACKERS] row_to_json bug with index only scans: empty keys!

2014-11-07 Thread Ross Reedstrom
rmission"), FOREIGN KEY ("uuid") REFERENCES document_controls ("uuid") ); The uuid and enums make no difference - I've made an all text version as well, same problem. testjson=# select version(); version --

Re: [HACKERS] Documentation epub format

2013-05-01 Thread Ross Reedstrom
nce, and have less burden to carry for searchability and findability than if they are presented as the primary format for using the material. If the split version is not primary, automated, less-than-perfect means of splitting (page count?) can be considered. Ross -- Ross Reedstrom, Ph.D.

Re: [HACKERS] feature request: auto savepoint for interactive psql when in transaction.

2012-08-17 Thread Ross Reedstrom
On Wed, Aug 15, 2012 at 10:26:55PM -0400, Bruce Momjian wrote: > On Mon, Nov 14, 2011 at 04:19:30PM -0600, Ross Reedstrom wrote: > > On Wed, Sep 28, 2011 at 11:47:51AM -0700, David Fetter wrote: > > > On Wed, Sep 28, 2011 at 02:25:44PM -0400, Gurjeet Singh wrote: > > >

Re: [HACKERS] Escaping ":" in .pgpass - code or docs bug?

2011-12-17 Thread Ross Reedstrom
escaped colons */ + t = ret; + while (t[0]) { + if (t[0] == '\\' && (t[1] == ':' || t[1] == '\\')) + strcpy(t,t+1); + t++; + return ret; } This would be backward compatible, in that

Re: [HACKERS] includeifexists in configuration file

2011-12-12 Thread Ross Reedstrom
ng it together as one word. > > What's going on, it's like this bikeshed just disappeared. I should > figure out how that happened so I can replicate it. Must be that special "camo" paint. Ross Woohoo! Caught up from my beginning of Oct. trip backlog

Re: [HACKERS] Command Triggers

2011-12-05 Thread Ross Reedstrom
en > confirm the existance of the table. > didn't I see a discussion in passing about the possibility of using these command triggers to implement some aspects of se-pgsql? In that case, you'd need the above behavior. Ross -- Ross Reedstrom, Ph.D.

Re: [HACKERS] feature request: auto savepoint for interactive psql when in transaction.

2011-11-14 Thread Ross Reedstrom
n, I've included this as a PSA at the start of any postgres talks > I've given, because it's simply not widely known. Good man. (That's a Postgres Service Announcement, then?) Ross -- Ross Reedstrom, Ph.D. reeds...@rice.edu Systems E

Re: [HACKERS] feature request: auto savepoint for interactive psql when in transaction.

2011-11-14 Thread Ross Reedstrom
different tool for running scripts. That would argue the defaults for psql proper should favor safe interactive use (autocommit off, anyone?) Peter mentioned the traditional method unix shells use to handle this: different config files are read for interactive vs. non-interactive startup. Seems we

Re: [HACKERS] proposal: psql concise mode

2011-11-14 Thread Ross Reedstrom
| integer # plain # Has OIDs: no or: Column | Type || Storage | +-++-+ a | integer || plain | b | integer || plain | or even: Column | Type || Storage || +-++-++ a | integer || plain || b | integer || plain || Ross