Re: [GENERAL] partitioned lookup table?

2010-04-17 Thread David Fetter
On Fri, Apr 16, 2010 at 04:48:18PM +0200, Andreas Kretschmer wrote: > Hi @all, > > A question, found in the german PG-Forum: > > is it possible to partitionate a lookup-table? What i mean is: > > test=# create table foo(i int primary key); > NOTICE: CREATE TABLE / PRIMARY KEY will create implic

[GENERAL] Postgis Availability on Website or Cloud?

2010-04-17 Thread Bob Pawley
Hi I am developing a PostgreSQL/PostGIS application (Geometric not Geographic). I want to have the database on the web with a desktop user interface and viewer. The usual method is to install a PostgreSQL server on a website and go from there. However, seeking a more flexible approach, I woul

Re: [GENERAL] Cannot access various Postgres sites

2010-04-17 Thread Eric Ridge
On Sat, Apr 17, 2010 at 1:42 PM, Adrian Klaver wrote: I can get to both sites and telnet also. Must be something on your end :( > Yup, it was. :( I appreciate the confirmation that it was me, thanks! eric

Re: [GENERAL] Cannot access various Postgres sites

2010-04-17 Thread Adrian Klaver
On Saturday 17 April 2010 10:20:01 am Eric Ridge wrote: > It's not DNS. I can resolve the hostnames just fine. In fact, those two > both resolve to the same IP: 200.46.204.71 > > They just don't respond. > > $ telnet 200.46.204.71 80 > Trying 200.46.204.71... > > just hangs indefinitely. :( > >

Re: [GENERAL] Cannot access various Postgres sites

2010-04-17 Thread Eric Ridge
It's not DNS. I can resolve the hostnames just fine. In fact, those two both resolve to the same IP: 200.46.204.71 They just don't respond. $ telnet 200.46.204.71 80 Trying 200.46.204.71... just hangs indefinitely. :( eric I could read the release notes for 9.0 by then and st

Re: [GENERAL] Cannot access various Postgres sites

2010-04-17 Thread Jorge Godoy
I could read the release notes for 9.0 by then and still can now. This is from two different countries (Brazil first and now US), so this should be an indicative that you might be having network issues. Can you please try canging your DNS servers from whatever you have now to Google's? Make 8.8.

[GENERAL] Cannot access various Postgres sites

2010-04-17 Thread Eric Ridge
I'm only subscribed to -general and -hackers, so if this message should go to a different list, please feel free to forward it along, but I've been unable to get to a couple of the Postgres websites for quite awhile. Back on March 20 Bruce Momjian posted a link in -hackers to the 9.0 release notes

Re: [GENERAL] partitioned lookup table?

2010-04-17 Thread Martin Gainty
Andreas- I have marched to the Oracle drumbeat of partitioning table instead of using FK constraint for years Are there timings which show FK constraint a better alternative than partitioning? Martin Gainty __ Jogi és Bizalmassági kinyilatkoztatá

Re: [GENERAL] partitioned lookup table?

2010-04-17 Thread Andreas Kretschmer
Vick Khera wrote: > On Fri, Apr 16, 2010 at 10:48 AM, Andreas Kretschmer > wrote: > > is it possible to partitionate a lookup-table? What i mean is: > > > > test=# create table foo(i int primary key); > > NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "foo_pkey" > > for table "f

Re: [GENERAL] Int64GetDatum

2010-04-17 Thread John R Pierce
Tom Lane wrote: No, but trying to build against a non-self-consistent set of files is bad. You really need a pg_config.h that matches the original build of the server, and you haven't got that. I think Greg's point is that trying to reverse-engineer that file is considerably more risky than bui