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 click on the

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 back

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 suppose

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 use...@munnin.com 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 use...@munnin.com wrote: Hello, I signed up a couple of months ago but never received

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

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 like a

[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

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

2009-04-19 Thread Henry
Quoting Simon Riggs si...@2ndquadrant.com: 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

Re: [GENERAL] Full text search strategy for names

2009-04-19 Thread Tom Lane
Rick Schumeyer rschume...@gmail.com 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

[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

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

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

2009-04-19 Thread Tom Lane
Robson Fidalgo r...@cin.ufpe.br 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[]

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 normalized

[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.

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. nettree...@gmail.com 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