[BUGS] BUG #7625: corrupted pid file prevents postgreSQL from normal starting

The following bug has been logged on the website: Bug reference: 7625 Logged by: Tianyin Xu Email address: t...@cs.ucsd.edu PostgreSQL version: 9.2.1 Operating system: Linux (actually doesn't matter) Description: Hi, Postgresql, Maybe this problem is well studied, bu

[BUGS] BUG #7624: Misleading Log Message & Inconsistent Configuration Design

The following bug has been logged on the website: Bug reference: 7624 Logged by: Tianyin Xu Email address: t...@cs.ucsd.edu PostgreSQL version: 9.2.1 Operating system: Linux (actually doesn't matter) Description: Hi, Postgresql, I'm here to report a very misleading l

Re: [BUGS] BUG #7620: array_to_json doesn't support heterogeneous arrays

On 10/24/2012 11:46 PM, Greg Hazel wrote: > Another option that just occurred to me is a new function (say, to_json) that > converts the parameter to its json representation, with type json. > > Then this would be possible: > > select array_to_json(ARRAY[to_json('foo'), to_json(100), to_json(true)