Re: [GENERAL] partitioned lookup table?
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 implicit index "foo_pkey" for > table "foo" > CREATE TABLE > test=*# create table bla ( i int references foo); > CREATE TABLE > test=*# insert into foo values (1); > INSERT 0 1 > test=*# insert into bla values (1); > INSERT 0 1 > test=*# create table foo_2 () inherits (foo); > CREATE TABLE > test=*# alter table foo_2 add primary key (i); > NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index > "foo_2_pkey" for table "foo_2" > ALTER TABLE Kinda. http://people.planetpostgresql.org/dfetter/index.php?/archives/51-Partitioning-Is-Such-Sweet-Sorrow.html Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Postgis Availability on Website or Cloud?
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 would like to explore other possibilities. Is anyone aware of a PostgreSQL/PostGIS installation, either as a website or cloud based system, that allows users to access, install and run single or multiple databases, and be charged accordingly? It would be something like having an "on demand" database capability. Is this a service that would be useful to others? Bob
Re: [GENERAL] Cannot access various Postgres sites
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
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. :( > > eric > I can get to both sites and telnet also. Must be something on your end :( -- Adrian Klaver adrian.kla...@gmail.com -- 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] Cannot access various Postgres sites
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 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.4.4 primary and 8.8.8.8 secondary and try again. You can also try using OpenDNS servers. -- Jorge Godoy On Sat, Apr 17, 2010 at 11:57, Eric Ridge wrote: > 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 (http://developer.postgresql.org/pgdocs/postgres/release-9-0.html). > It blew my mind that so many were able to discuss that page because > developer.postgresql.org didn't respond then, and it doesn't respond now. > :( I'd still like to read that page. > > Today I wanted to peek inside the JDBC driver sources before I join their > mailing list and ask a bunch of dumb questions, butjdbc.postgresql.org isn't > responding either. > > I've also seen intermittent connectivity issues with planet.postgresql.org, > but it seems to be working today. > > Is it just my network or is something up with these hosts? > > eric > >
Re: [GENERAL] Cannot access various Postgres sites
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.4.4 primary and 8.8.8.8 secondary and try again. You can also try using OpenDNS servers. -- Jorge Godoy On Sat, Apr 17, 2010 at 11:57, Eric Ridge wrote: > 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 (http://developer.postgresql.org/pgdocs/postgres/release-9-0.html). > It blew my mind that so many were able to discuss that page because > developer.postgresql.org didn't respond then, and it doesn't respond now. > :( I'd still like to read that page. > > Today I wanted to peek inside the JDBC driver sources before I join their > mailing list and ask a bunch of dumb questions, but jdbc.postgresql.orgisn't > responding either. > > I've also seen intermittent connectivity issues with planet.postgresql.org, > but it seems to be working today. > > Is it just my network or is something up with these hosts? > > eric >
[GENERAL] Cannot access various Postgres sites
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 (http://developer.postgresql.org/pgdocs/postgres/release-9-0.html). It blew my mind that so many were able to discuss that page because developer.postgresql.org didn't respond then, and it doesn't respond now. :( I'd still like to read that page. Today I wanted to peek inside the JDBC driver sources before I join their mailing list and ask a bunch of dumb questions, but jdbc.postgresql.orgisn't responding either. I've also seen intermittent connectivity issues with planet.postgresql.org, but it seems to be working today. Is it just my network or is something up with these hosts? eric
Re: [GENERAL] partitioned lookup table?
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ás/Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Ez az üzenet bizalmas. Ha nem ön az akinek szánva volt, akkor kérjük, hogy jelentse azt nekünk vissza. Semmiféle továbbítása vagy másolatának készítése nem megengedett. Ez az üzenet csak ismeret cserét szolgál és semmiféle jogi alkalmazhatósága sincs. Mivel az electronikus üzenetek könnyen megváltoztathatóak, ezért minket semmi felelöség nem terhelhet ezen üzenet tartalma miatt. Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > Date: Sat, 17 Apr 2010 11:39:28 +0200 > From: akretsch...@spamfence.net > To: pgsql-general@postgresql.org > Subject: Re: [GENERAL] partitioned lookup table? > > 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 "foo" > > > CREATE TABLE > > > test=*# create table bla ( i int references foo); > > > > You can have FK references from a partitioned table, but not to the > > table. That is, you cannot have this FK reference since you are > > partitioning foo. You can mimic the FK tests by writing your own > > triggers that have knowledge of how you split the table, but they will > > not be as efficient as a built-in FK test. > > Thx for the answer, and yes, this is what i had in mind. > > > Andreas > -- > Really, I'm not out to destroy Microsoft. That will just be a completely > unintentional side effect. (Linus Torvalds) > "If I was god, I would recompile penguin with --enable-fly." (unknown) > Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889° > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general _ The New Busy is not the too busy. Combine all your e-mail accounts with Hotmail. http://www.windowslive.com/campaign/thenewbusy?tile=multiaccount&ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_4
Re: [GENERAL] partitioned lookup table?
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 "foo" > > CREATE TABLE > > test=*# create table bla ( i int references foo); > > You can have FK references from a partitioned table, but not to the > table. That is, you cannot have this FK reference since you are > partitioning foo. You can mimic the FK tests by writing your own > triggers that have knowledge of how you split the table, but they will > not be as efficient as a built-in FK test. Thx for the answer, and yes, this is what i had in mind. Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknown) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889° -- 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] Int64GetDatum
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 building your own packages from scratch. and once again totally concurring with what you are saying... for laughs, I went ahead and tweaked the fields in a copy of the 32bit pg_config.h that I suspected were obviously wrong, and rebuilt my module against that, and it got through most of the pl/java test suite. so I know I'm on the right track, I just need the right pg_config.h from Bjorn and all will be well with my world. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general