On 28 Aug 2009, at 21:13, Steven Lembark wrote:
If I query on foo_id % 8, explain shows the optimizer
using the constraint (1).
If I just query on foo_id = 100, the exclusion is
not used (2).
What would be the best way to feed the optimizer
enough data to use the partitioning with equality
quer
Hi,
I installed PostgreSQL 8.4 over a PostgreSQL 8.3 installation (using msi) on
a Windows machine.
My pgAdmin3 program correctly displays only PostgreSQL 8.4 on localhost.
I went to my harddrive and noticed that I have PostgreSQL 8.3 "DATA" files
installed in: C:\Program Files\PostgreSQL\8.3
Gh,
Last week postgresql was working fine, yesterday I upgraded to
Snow Leopard...
Everything seemed to be working and then I tried to move some
rows to another machine via dblink.
I am getting a variety of failures on dblink_connect..
mbp is my main machine let me connect to my home serve
for superusers only
dblink-connect takes a libpq style connection string with hostaddr as first
attribute
dblink("hostaddr=127.0.0.1 port=5432 dbname=mydb user=postgres
password=mypasswd");
http://www.postgresql.org/docs/current/static/contrib-dblink-connect.html
Martin Gainty
On Aug 29, 2009, at 2:40 PM, Martin Gainty wrote:
for superusers only
dblink-connect takes a libpq style connection string with hostaddr
as first attribute
dblink("hostaddr=127.0.0.1 port=5432 dbname=mydb user=postgres
password=mypasswd");
http://www.postgresql.org/docs/current/static/c
Added to TODO:
Allow compilation using MSVC 2008
---
Magnus Hagander wrote:
> On Fri, Aug 28, 2009 at 18:19, Tom Lane wrote:
> > Dave Huber writes:
> >> I have recently installed MS VC++ 2008 Express Edition for a
Hello,
I am not experienced PostgreSQL user but have following problem:
I am unable to use plpythonu on linux (ubuntu 9.04). After I execute
command:
psql# CREATE LANGUAGE plpythonu;
I got following error message:
ERROR: could not load library
"/opt/PostgreSQL/8.4/lib/postgresql/plpython.so":
I am charged with migrating a Lotus Approach db + forms.
Approach (97 I think :) has this function where, when viewing a record
or within a form (or in the spreadsheet view for that matter) one can
press CTRL-F, for "find records".
The form I am on becomes a blank form (all fields cleared, but al
