[GENERAL] Setting up spatial index

lement efficiently if the geometries use ellipsoidal coordinates), although queries like (2), above, are easy to do quickly when you have an R-tree index of points in cartesian coordinates. Nathaniel -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

[GENERAL] Mixing use of ECPG and libpq

that allow databases to be moved around between machines, while keeping backups etc ticking away seemlessly. But, as I say, it creates connections with ECPG. Many thanks, Nathaniel -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to you

[GENERAL] Bulk read

s know to stay well clear. Can anyone comment on either approach, or offer an alternative strategy? Thanks, Nathaniel -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] COPY binary

le_name FROM/TO 'file_name'"? Nathaniel -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] (Relatively) Oversized Checkpoint

y - we write more than we read What can trigger this kind of out of character checkpoint? What should I be looking at to understand this? Thanks! -- Nathaniel

Re: [GENERAL] (Relatively) Oversized Checkpoint

4B0Q Serial Number: X Model: ATA Samsung SSD 840 SATA NCQ Capable: True SATA NCQ Enabled: True Current Temperature (C): 21 Maximum Temperature (C): 70 PHY Count: 1 PHY Transfer Rate: 1.5Gbps -- Nathaniel

[GENERAL] Data audit trail techniques in postgresql

ers use to accomplish this? Do most pg users just write triggers by hand? Or is there some nice auditing module that Google just isn't revealing to me? Thanks. Nathaniel Smith Web Application Developer Summersault, LLC. 710 E. Main St., Suite 200 Richmond, IN 47374 www.summersault.com --

Re: [GENERAL] Data audit trail techniques in postgresql

Alvaro Herrera wrote: > Perhaps, but I have heard of people using it successfully recently, > whereas Nathaniel reported that audittrail2 seems to have obvious > bugs. Thanks for the tip. Do to poor searching on my part tablelog fell under my radar. I'll try and out and s

[GENERAL] installation on vista

I have downloaded the one click installer on Vista. I right click on the executable and select run as administrator, and an empty dialog box appears. This is as far as I can go. Any suggestions?

Re: [GENERAL] installation on vista

-Original Message- From: Dave Page [mailto:dp...@pgadmin.org] Sent: Thu 4/22/2010 3:35 AM To: Craig Ringer Cc: Watson, Nathaniel; pgsql-general@postgresql.org Subject: Re: [GENERAL] installation on vista On Thu, Apr 22, 2010 at 1:47 AM, Craig Ringer wrote: > On 22/04/2010 1:05

[GENERAL] libpq: do I need PQendcopy after PQgetCopyData?

's a pain to do--it requires a whole bunch of other infrastructure to be switched over to later versions too). Nathaniel -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] libpq: do I need PQendcopy after PQgetCopyData?

Tom Lane wrote: No, but did you do a PQgetResult? See the description of PQgetCopyData. Oops! Thanks Tom. Even after many re-reads, I missed that final paragraph in the manual, and have wasted ages on this. Nathaniel -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] Reordering results for a report (follow-up)

On 12/13/2003 3:47 PM, Bruno Wolff III wrote : On Fri, Dec 12, 2003 at 14:40:34 -0800, Nathaniel Price <[EMAIL PROTECTED]> wrote: Sorry, that's not really what I'm looking for. When I said that the sort order could be arbitrary, I meant /arbitrary/. As in "no amount of