Re: [GENERAL] Community account

2009-04-19 Thread Magnus Hagander
Rainer Bauer wrote: > Hello, > > I signed up a couple of months ago but never received the confirmation email. > > If I try to create a new account with the same email address, but a different > handle it is denied with this error message: "A user with that email already > exists". > > When I cl

Re: [GENERAL] Community account

2009-04-19 Thread Rainer Bauer
Hello Magnus, Sunday, April 19, 2009, 11:05:49 AM, you wrote: MH> I assume you are trying to register as inqu...@munnin.com? Yep. MH> So we are trying to deliver this to your domain, but appear to be MH> repeatedly graylisted by the different MX machines. And when we try MH> again, we're put ba

Re: [GENERAL] Community account

2009-04-19 Thread Rainer Bauer
Hello Magnus, Sunday, April 19, 2009, 11:05:49 AM, you wrote: MH> You need to have the email system give us at least a chance to get off MH> the graylist :-) Or you need to whitelist the wwwmaster.postgresql.org MH> domain. It was whitelisted and works now like a charm. Thanks, Magnus! I suppos

Re: [GENERAL] Community account

2009-04-19 Thread Roderick A. Anderson
Scott Marlowe wrote: On Sat, Apr 18, 2009 at 8:27 AM, Rainer Bauer wrote: Hello Scott, Saturday, April 18, 2009, 4:21:29 PM, you wrote: SM> On Sat, Apr 18, 2009 at 3:49 AM, Rainer Bauer wrote: Hello, I signed up a couple of months ago but never received the confirmation email. If I try to

Re: [GENERAL] number of relations reported by vacuumdb -av

2009-04-19 Thread Irene Barg
System: MacOS XServer, 4GB RAM PostgreSQL-8.1.9: the MCAT database 7.6GB big has 525 relations Hi Martin The current setting is: max_fsm_pages = 20 # min max_fsm_relations*16, 6 bytes each max_fsm_relations = 2000# min 100, ~70 bytes each I reset it yester

Re: [GENERAL] Community account

2009-04-19 Thread Magnus Hagander
Rainer Bauer wrote: > Hello Magnus, > > Sunday, April 19, 2009, 11:05:49 AM, you wrote: > > MH> You need to have the email system give us at least a chance to get off > MH> the graylist :-) Or you need to whitelist the wwwmaster.postgresql.org > MH> domain. > > It was whitelisted and works now l

[GENERAL] One command to rule them all?

2009-04-19 Thread Raymond O'Donnell
Hi all, just wondering... I remember some time back there was a discussion about implementing a single catch-all command for PostgreSQL, to replace (or perhaps rather encompass) the various other utilities we currently use (psql, pg_dump, createdb, etc etc). Did that idea die a death, or is it st

Re: [GENERAL] Partitioned table and trigger/insert result horribleness

2009-04-19 Thread Henry
Quoting "Simon Riggs" : Use Rules is the current answer, though that has other issues also. Hi Simon - as you say, Rules have issues. From my understanding, partitioning with rules is impractical. Anyway, thanks for clarifying. Cheers Henry -- Sent via pgsql-general mailing list (pgsql-

Re: [GENERAL] Full text search strategy for names

2009-04-19 Thread Tom Lane
Rick Schumeyer writes: > I also noticed that the directions for indexing multiple columns don't seem > to be quite right. > In section 12.2.2: > UPDATE pgweb SET textsearchable_index_col = > to_tsvector('english', coalesce(title,'') || coalesce(body,'')); Yeah, this would be better done wi

[GENERAL] DISTINCT ON without ORDER BY

2009-04-19 Thread Martijn van Oosterhout
Hi, I was going through the queries of an SQL application and came across queries like: SELECT * FROM foo WHERE id in (SELECT max(id) FROM foo GROUP BY bar); I thought, here's a case where this could be better written using DISTINCT ON, since then you avoid the self-join: SELECT DISTINCT ON (ba

Re: [GENERAL] Postgresql 8.3X supports Arrays of Composite Types?

2009-04-19 Thread Robson Fidalgo
> > Hello, > I am using postgresql 8.3X and I created a table (see example below) that > has an attribute that is an Array of a Composite Type (ROW). However, I do > not know how can I insert a record in this table. > > Well, I've searched the mailing lists and have found little said about the > OR

[GENERAL] Problem with pgpool-II tool

2009-04-19 Thread aravind chandu
Hello, I have encountered a problem while configuring pgpool-II,I encountered a problem while executing the following command. pgpool -n & [1] 2796 [achand...@localhost ~]$ pool_config: could not open configuration file (pgpool.conf) pool_config: using default values... pid file

[GENERAL] Postgresql 8.3X supports Arrays of Composite Types?

2009-04-19 Thread Robson Fidalgo
Hello, I am using postgresql 8.3X and I created a table (see example below) that has an attribute that is an Array of a Composite Type (ROW). However, I do not know how can I insert a record in this table. Well, I've searched the mailing lists and have found little said about the OR features. In p

Re: [GENERAL] Postgresql 8.3X supports Arrays of Composite Types?

2009-04-19 Thread Tom Lane
Robson Fidalgo writes: > I am using postgresql 8.3X and I created a table (see example below) that > has an attribute that is an Array of a Composite Type (ROW). However, I do > not know how can I insert a record in this table. You need some explicit casts so that the array[] construct is seen to

Re: [GENERAL] Postgresql 8.3X supports Arrays of Composite Types?

2009-04-19 Thread David Fetter
On Sun, Apr 19, 2009 at 06:03:26PM -0300, Robson Fidalgo wrote: > Hello, > I am using postgresql 8.3X and I created a table (see example below) > that has an attribute that is an Array of a Composite Type (ROW). > However, I do not know how can I insert a record in this table. You want a normalize

[GENERAL] Frequently unable connecting to db "server doesn't listen"

2009-04-19 Thread Net Tree Inc.
If this e-mail address is not intend use for asking questions using e-mail suscription, please ignore it. I could not find any official PostgreSQL support forum for me to post ask questions. Appreciated if you could you refer me a few good PostgreSQL support forum for me to ask questions. Problem

Re: [GENERAL] Frequently unable connecting to db "server doesn't listen"

2009-04-19 Thread Scott Marlowe
On Sun, Apr 19, 2009 at 8:10 PM, Net Tree Inc. wrote: > > If this e-mail address is not intend use for asking questions using e-mail > suscription, please ignore it.  I could not find any official PostgreSQL > support forum for me to post ask questions. Appreciated if you could you > refer me a fe