On Thu, Jul 26, 2012 at 2:17 PM, Bruce Momjian wrote:
> On Thu, Jul 26, 2012 at 01:24:19PM -0400, Robert Haas wrote:
>> On Thu, Jul 26, 2012 at 12:06 PM, Bruce Momjian wrote:
>> > I don't see the "don't modify the user files" behavior changing anytime
>> > soon, and it is documented, so I feel pr
On Thu, Jul 26, 2012 at 7:24 PM, Bruce Momjian wrote:
> On Thu, Jul 26, 2012 at 02:17:22PM -0400, Bruce Momjian wrote:
>> > > Is that sufficient?
>> >
>> > Well, at the very least, you need to guarantee that the standby is
>> > caught up - i.e. that it replayed all the WAL records that were
>> > g
On Wed, Jul 25, 2012 at 2:51 PM, Peter Geoghegan wrote:
> On 3 March 2012 20:22, Jeff Janes wrote:
>> Add it all up, and instead of pre-reading 32 consecutive 8K blocks, it
>> pre-reads only about 1 or 2 consecutive ones on the final merge. Now
>> some of those could be salvaged by the kernel ke
Hi!
I am developing a work that will need to make some changes in the PostgreSQL
source code. More precisely, I'll also make changes in the PostGIS extension.
So I work with geographic data.
I wonder if someone can show me a better way for me to make such changes in
PostgreSQL:
-> I need to set
On Thu, 2012-07-26 at 12:13 -0400, Bruce Momjian wrote:
> So, do we want a TODO item about adding columns to a unique index that
> will not be used for uniqueness checks?
-1 from me, at least in its current form.
At it's heart, this is about separating the constraint from the index
that enforces
"Stephan, Richard" writes:
> More information (9.0.8):
> $ pg_ctl start
> Killed
> fgets failure: Error 0
> The program "postgres" is needed by pg_ctl but was not found in the
> same directory as "/opt/postgres/9.0/bin/pg_ctl".
> Check your installation.
> $ postgres -V
> ld.so.1: postgres: fata
On Fri, Jul 27, 2012 at 12:24 PM, Jeff Davis wrote:
> On Thu, 2012-07-26 at 12:13 -0400, Bruce Momjian wrote:
>> So, do we want a TODO item about adding columns to a unique index that
>> will not be used for uniqueness checks?
>
> -1 from me, at least in its current form.
>
> At it's heart, this i
Robert Creager writes:
> Working on bringing online a new build farm machine running Mountain Lion.
> Warnings are being generated in the contrib installcheck phase, causing the
> failure of the build transaction.
> [5012f1c9.4014:27] LOG: statement: select pgp_key_id(dearmor(seckey)) from
>
On Thu, Jul 26, 2012 at 2:56 PM, Anderson C. Carniel
wrote:
>
> -> I need to set a new data type specific, as the PostGIS. I saw that in
> PostgreSQL's Documentation there is a User-Defined Types. This is the best
> way to define a new data type? Using this approach, can I define the way
> queries