"nicola75ss" writes:
> Good morning. I'm totally newbie with postgresql. I was studying
> pg_size_pretty() and I've discovered that if I pass it a great value it
> returns negative value.
> This is an example
> select pg_size_pretty(9223372); -- "-8388607 TB"
Yeah, that's a bug. Fi
On Wed, Apr 13, 2011 at 6:52 AM, Donald Fraser wrote:
>> If the server is shut down mid-query, doesn't the backend complete the
>> current query cycle before closing the connection?
>> i.e. we'd see ErrorResponse, ReadyForQuery, and return control to the
>> app before seeing EOF anyway?
>> The pro
On Mon, Apr 25, 2011 at 11:06 AM, Tom Lane wrote:
> Robert Haas writes:
>> On Wed, Apr 20, 2011 at 7:13 PM, Tom Lane wrote:
>>> I have stated previously my opinion that this is a misconceived feature,
>>> and it's now apparent that the implementation is as poorly thought
>>> through as the defin
The following bug has been logged online:
Bug reference: 5993
Logged by: nicola75ss
Email address: nicola7...@gmail.com
PostgreSQL version: 8.4
Operating system: windows 7
Description:pg_size_pretty overflow
Details:
Good morning. I'm totally newbie with postgresql.
Robert Haas writes:
> On Wed, Apr 20, 2011 at 7:13 PM, Tom Lane wrote:
>> I have stated previously my opinion that this is a misconceived feature,
>> and it's now apparent that the implementation is as poorly thought
>> through as the definition. My recommendation is to revert that patch
>> alto
On Wed, Apr 6, 2011 at 12:14 PM, Alvaro Herrera wrote:
> Excerpts from Daniel Migowski's message of mié abr 06 06:45:25 -0300 2011:
>> PostgreSQL version: 8.3.9
>> Operating system: Windows 7
>
>> My PostgreSQL server just crashed during an attempt to connect to it
>> (multiple times at once, a
On Tue, Apr 5, 2011 at 4:31 PM, Joseph Adams wrote:
>> The following bug has been logged online:
>>
>> Bug reference: 5963
>> Logged by: Gavin Flower
>> Email address: gavin(dot)flower(at)archidevsys(dot)co(dot)nz
>> PostgreSQL version: 9.1alpha5
>> Operating system: x86_64 Li
On Wed, Apr 20, 2011 at 7:13 PM, Tom Lane wrote:
> "Marko Tiikkaja" writes:
>> CREATE TABLE IF NOT EXISTS duplicates some constraints if the new table
>> isn't created:
>
> What this means is that the feature was implemented in the wrong place,
> ie the short-circuit is after rather than before p
On Wed, Apr 20, 2011 at 5:16 PM, Kevin Grittner
wrote:
> Heikki Linnakangas wrote:
>
>> The immediate fix is trivial:
>>
>> [patch changing one line of code]
>
> I have confirmed that without this patch the new regression tests I
> have proposed will fail, and with the patch they succeed. I have
