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

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

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

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

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

2008-06-23 Thread Collin Peters
] 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 TIME ZONE 'GMT-10:00', now() AT TIME ZONE 'Australia

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

2008-06-20 Thread Collin Peters
- 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 while 1 4 are timestamp WITH timezone. But I still see this as totally wrong. Regards, Collin Peters -- Sent via pgsql-general mailing

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

2008-06-12 Thread Collin Peters
with 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 8.1 install on Linux (have not yet been

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

2008-06-05 Thread Collin Peters
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 values and pgadmin is a bit pickier? Regards, Collin -- Sent via pgsql-general

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

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

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

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 top posting

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

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

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

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

[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

[GENERAL] Auto vacuum documentation

2007-09-07 Thread Collin Peters
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 free space map

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

2005-06-16 Thread Collin Peters
). 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 varchar(40) NOT NULL, shortname varchar(20) NOT NULL, username varchar(20), password varchar(40

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

2004-09-10 Thread Collin Peters
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 ---(end

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. What happens

[GENERAL] Postmaster startup problems

2000-10-07 Thread Collin Peters
? 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