Re: [GENERAL] Windows default editor for psql \e

2007-02-03 Thread Bruce Momjian
Joshua D. Drake wrote: > On Tue, 2006-11-28 at 22:59 -0500, Bruce Momjian wrote: > > Richard Broersma Jr wrote: > > > > Sure, see the psql manual page, but setting EDITOR is the easiest way. > > > > This works on Win32 too. > > > > > > c:\set EDITOR="c:\Program Files\Vim\vim70\gvim.exe" > > > >

Re: [GENERAL] date comparisons

2007-02-03 Thread Bruce Momjian
OK, so we have a bug. Thanks. --- Chad Wagner wrote: > On 2/3/07, Bruce Momjian <[EMAIL PROTECTED]> wrote: > > > > > > Would someone please confirm that our behavior in the three queries > > below matches Oracle's behavior?

Re: [GENERAL] date comparisons

2007-02-03 Thread Chad Wagner
On 2/3/07, Bruce Momjian <[EMAIL PROTECTED]> wrote: Would someone please confirm that our behavior in the three queries below matches Oracle's behavior? Here is output from Oracle: Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production With the Partitioning, OL

Re: [GENERAL] date comparisons

2007-02-03 Thread Bruce Momjian
Would someone please confirm that our behavior in the three queries below matches Oracle's behavior? --- Tom Lane wrote: > "Belinda M. Giardine" <[EMAIL PROTECTED]> writes: > > Should it be this way? > > Well, to_timestamp(

Re: [GENERAL] Can a function be parameter in PL/PGSQL function?

2007-02-03 Thread elein
On Tue, Jan 30, 2007 at 12:32:04PM -0800, Karen Hill wrote: > Is it possible to have a pl/pgsql function take another pl/pgsql > function as one of the parameters? > > regards, > karen > > > ---(end of broadcast)--- > TIP 9: In versions below 8.0,

Re: [GENERAL] [EMAIL PROTECTED]: Re: port fault on pg_ctl's

2007-02-03 Thread Bruce Momjian
Documentation patch attached and applied to HEAD and 8.2.X. --- Palle Girgensohn wrote: > > > --On onsdag, december 13, 2006 11.04.54 -0500 Tom Lane <[EMAIL PROTECTED]> > wrote: > > > Gergely CZUCZY <[EMAIL PROTECTED]> w

Re: [GENERAL] some ports closed in Fedora

2007-02-03 Thread brian
Harpreet Dhaliwal wrote: Is there any fedora mailinglist? Never knew if there was one try here: https://www.redhat.com/mailman/listinfo/fedora-list ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Query optimization problem

2007-02-03 Thread Dave Page
> --- Original Message --- > From: Peter <[EMAIL PROTECTED]> > To: pgsql-general@postgresql.org > Sent: 03/02/07, 10:58:08 > Subject: Re: [GENERAL] Query optimization problem > > >>> Try SELECT count(*) FROM ... instead and see if the times are closer. > > > >> Correct. That executes in

Re: [GENERAL] PG Email Client

2007-02-03 Thread Joshua D. Drake
> I would be careful about using dspam. > > I have documented cases where it lost email and even with posting all > the debug and other logs on the mailing lists I've never received any > indication that they recognize this as a dspam problem. > > dspam will lose your mail. *ahem* I have severa

[GENERAL] [1/2 OFF] Update on Varlena.com Access problem

2007-02-03 Thread Jorge Godoy
Hi! Just to let you know that I've just tried to access Varlena.com again and it worked. I'm just reporting it here because of the "noise" I caused when I asked if there was any blocking. :-) Thanks for whoever solved that! Be seeing you, -- Jorge Godoy <[EMAIL PROTECTED]> --

Re: [GENERAL] some ports closed in Fedora

2007-02-03 Thread Harpreet Dhaliwal
lol On 2/3/07, Andreas Kretschmer <[EMAIL PROTECTED]> wrote: Harpreet Dhaliwal <[EMAIL PROTECTED]> schrieb: > Is there any fedora mailinglist? Never knew if there was one Yes, more then one, ask google. Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely uni

Re: [GENERAL] some ports closed in Fedora

2007-02-03 Thread Andreas Kretschmer
Harpreet Dhaliwal <[EMAIL PROTECTED]> schrieb: > Is there any fedora mailinglist? Never knew if there was one Yes, more then one, ask google. Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torv

Re: [GENERAL] some ports closed in Fedora

2007-02-03 Thread Harpreet Dhaliwal
Is there any fedora mailinglist? Never knew if there was one On 2/3/07, A. Kretschmer <[EMAIL PROTECTED]> wrote: am Sat, dem 03.02.2007, um 9:49:46 -0500 mailte Harpreet Dhaliwal folgendes: > Also, wanted to know how to prevent remote root ftp login in fedora. 1. configure your ftp-server a

Re: [GENERAL] some ports closed in Fedora

2007-02-03 Thread A. Kretschmer
am Sat, dem 03.02.2007, um 9:49:46 -0500 mailte Harpreet Dhaliwal folgendes: > Also, wanted to know how to prevent remote root ftp login in fedora. 1. configure your ftp-server appropriate 2. this is a postgresql-mailinglist, not fedore or such 3. i don't like silly fullquote below the answer

Re: [GENERAL] PG Email Client

2007-02-03 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/03/07 07:17, Tom Allison wrote: > Alban Hertroys wrote: >> Jean-Gérard Pailloncy wrote: [snip] > The *one* feature I did like about dspam is they quarantine spam and you > can sort it out later. That can be done easily enough and won't > interfe

Re: [GENERAL] some ports closed in Fedora

2007-02-03 Thread Harpreet Dhaliwal
Also, wanted to know how to prevent remote root ftp login in fedora. On 2/3/07, Andreas Kretschmer <[EMAIL PROTECTED]> wrote: Harpreet Dhaliwal <[EMAIL PROTECTED]> schrieb: > Hi, > though this is not directly related to postgres, but i was wondering why are > most of the ports seen closed > wh

Re: [GENERAL] database backup trouble

2007-02-03 Thread George Weaver
From: "Tomi N/A" And the .bat file script? The .bat script is of no importance: So be it... it's a windows-related problem Is the Task Scheduler service running? (Start > Settings > Control Panel > Administrative Tools > Services - Task Scheduler?). If the Task Scheduler service is r

Re: [GENERAL] PG Email Client

2007-02-03 Thread Tom Allison
Alban Hertroys wrote: Jean-Gérard Pailloncy wrote: I do not have test numbers rigth now, because I need first to configure the box for virtual hosting, then dspam. It would be really wonderful if someone managed to combine this with dspams own database. Maybe it'd be possible to pull dspam's a

Re: [GENERAL] sql formatter/beautifier

2007-02-03 Thread Joris Dobbelsteen
PostGreSQL (7.4 and onward) has such a thing build-in, but its not particulary good (simple case works, but once it gets complex it makes a mess out of it). For example the postgresql formatted version $CREATE OR REPLACE VIEW "Subquery" AS $ SELECT t1.a, t2.b $ FROM ( SELECT 1 AS a, 2 AS x) t1

Re: [GENERAL] Rule, update and aggregate functions

2007-02-03 Thread Peter
Hi, I got stuck with the following problem and strangely couldn't find anything similar in the list: Assume two tables: table: warehouse, columns: id, incoming, outgoing table: articles, columns: id, articles_in_stock All I want is to create a rule, that everytime when articles leave or get in

Re: [GENERAL] Query optimization problem

2007-02-03 Thread Peter
Try SELECT count(*) FROM ... instead and see if the times are closer. Correct. That executes in 300ms flat: So your problem is data transfer, not the query per se. Well, based on PgAdmin times I suspected some sort of heavy 'data preparation before it's sent out' overhead How old a pgAdm

Re: [GENERAL] some ports closed in Fedora

2007-02-03 Thread Andreas Kretschmer
Harpreet Dhaliwal <[EMAIL PROTECTED]> schrieb: > Hi, > though this is not directly related to postgres, but i was wondering why are > most of the ports seen closed > when one does nmap scan of these ports. Whats reason can we attribute to the > fact that most of the ports in an OS are > in closed

[GENERAL] some ports closed in Fedora

2007-02-03 Thread Harpreet Dhaliwal
Hi, though this is not directly related to postgres, but i was wondering why are most of the ports seen closed when one does nmap scan of these ports. Whats reason can we attribute to the fact that most of the ports in an OS are in closed state. Thanks, Harpreet