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
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
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
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
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
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
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
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-
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
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
>
> 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
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
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
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
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
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
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
17 matches
Mail list logo