Re: [GENERAL] Annoying Reply-To

2008-10-23 Thread Collin Kidder
Angel Alvarez wrote: Well but the RFC's were in fact prior to thunderbird So for he most of its life, when few people was using it, Thiunderbird was a sad example of your botched attempt of creating a standar of NOT FOLLOWING THE RFC's... But, as I mentioned, nobody cares about this particu

Re: [GENERAL] Annoying Reply-To

2008-10-23 Thread Collin Kidder
Angel Alvarez wrote: What's such most advanced mail reader?? No one, ive seen, seems to be perfect nor thunderbird. By the way kmail has 4 options (reply, reply to all, reply to author, reply to list) in addition to be able to use list headers included in the message. in fact many other mail-

Re: [GENERAL] Annoying Reply-To

2008-10-23 Thread Collin Kidder
Bruce Momjian wrote: Mikkel is right, every other well-organized mailing list I've ever been on handles things the sensible way he suggests, but everybody on his side who's been on lists here for a while already knows this issue is a dead horse. Since I use the most advanced e-mail client on

Re: [GENERAL] Annoying Reply-To

2008-10-17 Thread Collin Kidder
I resent that you're trying to make this a personal thing. I was going to answer the rest of this email, then I realized that the real problem was right here, and discussing anything else was dancing around the issue and wasting time. You can resent it or not, but this _is_ a personal th

Re: [GENERAL] Timezone issue - Is it me or is this a massive bug?

2008-06-23 Thread Collin Peters
TED]> wrote: > On Friday 20 June 2008 1:19 pm, Collin Peters wrote: >> I have a server of which the OS timezone is set to Pacific time >> (currently -7). I run the following query on it >> >> SELECTnow(), now() AT TIME ZONE 'GMT+10:00', now() AT T

[GENERAL] Timezone issue - Is it me or is this a massive bug?

2008-06-20 Thread Collin Peters
09:39.245641" - WRONG) * column 4 - the current time in Melbourne Australia ("2008-06-21 06:09:39.245641" - CORRECT) Am I missing something obvious? Seems when I specify GMT+10:00 it returns GMT-10:00 and vice versa. Note that column 2 & 3 are timestamp withOUT timezone whi

Re: [GENERAL] pgAdmin complains about vacuuming required after fresh 8.1 install

2008-06-11 Thread Collin Peters
this table yet? On Thu, Jun 5, 2008 at 5:47 PM, Collin Peters <[EMAIL PROTECTED]> wrote: > Hi all - I am wondering if I can get a consensus on what to do about > this minor issue. I have looked through the archives and can't find a > definitive answer. > > So I have a new

[GENERAL] pgAdmin complains about vacuuming required after fresh 8.1 install

2008-06-05 Thread Collin Peters
hat autovacuum also does analyze so we don't need to recommend nightly analyzes anymore unless autovacuum is off." So I am looking for the definitive answer on this. Is pgAdmin wrong and I should ignore the messages? Is autovacuum not fully running? Do they just have different threshold v

Re: [GENERAL] Connect to postgres from a dynamic IP

2008-03-03 Thread Collin
But make it "hostssl" instead of "host", to require some cryptography in the channel used, specially to authenticate the connection. Opening your access to everyone without crypto sounds like something you don't want to do. Specially if users can change their own passwords... My underst

Re: [GENERAL] [pgsql-advocacy] PostgreSQL Certification

2008-02-04 Thread Collin Kidder
Lewis Cunningham wrote: --- Gregory Stark <[EMAIL PROTECTED]> wrote: pgsql-hackers pgsql-users There really aren't any other groups of people. "people who want to talk about There are hackers (contribute to PostgreSQL), DBAs (administer the database), Developers (write application to

Re: [GENERAL] Would it be OK if I put db file on a ext2 filesystem?

2007-12-12 Thread Collin Kidder
Magicloud Wang wrote: Dear, I think database has its own operation journal, and different journal filesystem does give different performance. So if I put database file on a non-journal filesystem, would it be safe? Does this like using a raw device? You lose a little bit of data integrit

Re: [GENERAL] top posting

2007-12-11 Thread Collin Kidder
I agree with Joshua on this point. It's entirely possible to discuss this without resorting to immaturity. If you make a decent point, then diminish it by cursing or insulting everybody here, you've lost the point and it's effectiveness entirely. Yes, once again, I apologize. At times I se

Re: [GENERAL] top posting

2007-12-11 Thread Collin Kidder
I felt I was 'responding in kind' wrt 'it really irritates me when people cry like 4 year olds about top posting. It's not that bad, get over it.' posting. My apologies if I've taken it to a level of rude that it had not already reached. I suppose that the post was probably directed at

Re: [GENERAL] top posting

2007-12-11 Thread Collin Kidder
Geoffrey wrote: Collin Kidder wrote: I have to suffer through dealing with people like the two of you quoted above. You can deal with people who'd like to top post. Anything else is just being a spoiled baby who can't deal with minor issues. If all the energy spent crying about t

Re: [GENERAL] top posting

2007-12-11 Thread Collin Kidder
Scott Marlowe wrote: On Dec 11, 2007 11:41 AM, Leif B. Kristensen <[EMAIL PROTECTED]> wrote: It certainly isn't a crime. But it's a bit like thread hijacking in the sense that a well-formed inline posting is more likely to attract intelligent replies. I don't think that I'm the only one who t

Re: [GENERAL] Syntax error in a large COPY

2007-11-07 Thread Collin Kidder
My point is: with top-posting I don't care how many lines were repeated because I don't have to scroll. Considering there is an RFC that recommends inline posting over top-posting (http://tools.ietf.org/html/rfc1855), and considering the fact that this topic has been beat to death on do

Re: [GENERAL] Syntax error in a large COPY

2007-11-06 Thread Collin Kidder
This is offtopic but there is nothing wrong with top posting. Is there a mail list policy on it or are you just picky about it? Scott Marlowe wrote: On 11/6/07, Reg Me Please <[EMAIL PROTECTED]> wrote: That seems not to be the case. The last line has a \. by its own and the last but one is

Re: [GENERAL] Migration from PervasiveSQL

2007-09-24 Thread Collin
What about Perl? DBI? Not sure if it supports PervasiveSQL The OP stated he already had ODBC connectors setup. Yes, I already have ODBC setup. I'm basically just writing a little something myself that uses the existing Pervasive and Postgres tools as much as possible. On a s

[GENERAL] Migration from PervasiveSQL

2007-09-20 Thread Collin
Well, the subject says it pretty well but to elaborate: I have a database from our ERP package that uses btrieve (PervasiveSQL) for it's database engine. I'd like to transition all of the data to PostgreSQL. I've been having trouble finding a suitable program to automatically get all of the da

[GENERAL] Auto vacuum documentation

2007-09-07 Thread Collin Peters
en I click around in pgAdmin it still prompts me to vacuum for many of the tables. I am wondering if there are any sites that tell me the ins-n-outs of autovacuuming. Regards, Collin ---(end of broadcast)--- TIP 5: don't forget to increase your

[GENERAL] Extremely slow performance with 'select *' after insert of 37,000 records

2005-06-16 Thread Collin Peters
Let me know if any more information would help. This is postgresql 7.4.7 (also a unicode database). Regards, Collin - -- Table: pp_users -- DROP TABLE pp_users; CREATE TABLE pp_users ( user_id serial NOT NULL, title varchar(10), firstname varchar(40) NOT NULL, lastname

[GENERAL] Best practices for migrating a development database to a release database

2004-09-10 Thread Collin Peters
lease database... overwrite it with the development database... then copy all your real data back into the release database (this last step is probably quite difficult) -Perhaps some combination of the two Does anybody have any recommendations? Regards, Collin Peters ---(e

Re: SV: [GENERAL] Postmaster startup problems

2000-10-08 Thread Collin Peters
I am just trying to connect locally. Only one machine involved. Is there a way to tell what port the postmaster is running on if it is running at all. Collin On Sun, 8 Oct 2000 10:55:32 +0200, Jarmo Paavilainen said: > > > > I'm having problems starting postgres.

[GENERAL] Postmaster startup problems

2000-10-07 Thread Collin Peters
nnect!! Is it maybe running on a different port or something? Another strange thing is that TOP reports the running process to be /usr/local/pgsql/bin instead of /usr/local/pgsql/bin/postmaster which is the way I remember it running before. Collin Peters