Re: [GENERAL] [PERFORM] [ADMIN] Postgres VS Oracle

2007-06-19 Thread Andrew Kelly
On Mon, 2007-06-18 at 13:02 -0400, Jonah H. Harris wrote: > On 6/18/07, Andreas Kostyrka <[EMAIL PROTECTED]> wrote: > > As a cynic, I might ask, what Oracle is fearing? > > As a realist, I might ask, how many times do we have to answer this > type of anti-commercial-database flamewar-starting ques

Re: [GENERAL] reporting tools

2007-08-23 Thread Andrew Kelly
On Thu, 2007-08-23 at 06:20 -0400, Geoffrey wrote: > Joshua D. Drake wrote: > > -BEGIN PGP SIGNED MESSAGE- > > Hash: SHA1 > > > > John DeSoi wrote: > >> On Aug 22, 2007, at 7:21 PM, Geoffrey wrote: > >> > >>> We are looking for an open source reporting tool that will enable > >>> users to

[GENERAL] DB upgrade

2007-10-09 Thread Andrew Kelly
Hi folks, please forgive what feels like a no-brainer even as I ask it, but... I've read dozens of times in these lists that when one is upgrading from an older to newer version of PG, the DB being dumped (older version) should be done so using pg_dump from the newer version. I think I've probabl

Re: [GENERAL] DB upgrade

2007-10-09 Thread Andrew Kelly
On Tue, 2007-10-09 at 13:58 +0200, Peter Eisentraut wrote: > Am Dienstag, 9. Oktober 2007 schrieb Andrew Kelly: > > Unless my installation is unique in some way of which I'm yet unaware, > > Yes, it's a Debian package. Indeed, yes. Where can I read what that means in t

Re: [GENERAL] DB upgrade

2007-10-10 Thread Andrew Kelly
On Tue, 2007-10-09 at 11:46 +0200, Andrew Kelly wrote: > Hi folks, > > please forgive what feels like a no-brainer even as I ask it, but... Just wanted to thank everybody who's provided feedback. I'm squared away now, and very appreciative of

Re: [GENERAL] Announcing PostgreSQL RPM Buildfarm

2008-01-08 Thread Andrew Kelly
On Mon, 2008-01-07 at 12:32 -0800, Joshua D. Drake wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On Mon, 07 Jan 2008 20:25:45 + > Richard Huxton <[EMAIL PROTECTED]> wrote: > > > Scott Marlowe wrote: > > > On Jan 7, 2008 12:57 PM, Devrim GÜNDÜZ <[EMAIL PROTECTED]> > > > wrote: >

Re: [GENERAL] Limitations of PostgreSQL

2005-10-13 Thread Andrew Kelly
On Wed, 2005-10-12 at 16:49 -0500, Scott Marlowe wrote: > On Wed, 2005-10-12 at 16:16, Chris Travers wrote: > > Denis G Dudhia wrote: > > > > > Hello There... > > > > > > I am new to PostgreSQL. > > > > > > I usually check out negative sides of any software or system, before > > > implementing it

Re: [GENERAL] [HACKERS] 'a' == 'a '

2005-10-20 Thread Andrew Kelly
On Thu, 2005-10-20 at 08:14 -0400, Jan Wieck wrote: > On 10/20/2005 2:17 AM, Greg Stark wrote: > > > (I can't believe anyone really wants varchar to be space padded. Space > > padding > > always seemed like a legacy feature for databases with fixed record length > > data types. Why would anyone w

Re: [GENERAL] vista

2006-09-20 Thread Andrew Kelly
On Tue, 2006-09-19 at 10:26 -0400, Tom Lane wrote: > Naz Gassiep <[EMAIL PROTECTED]> writes: > > For something like Vista > > compatibility, if you want to be taken seriously by anyone who uses > > Windows (hands up anyone who knows a Windows user), "scratch your own > > itch" is not really goin

Re: [GENERAL] postgresql rising

2006-09-22 Thread Andrew Kelly
On Wed, 2006-09-20 at 10:10 -0500, Tony Caduto wrote: > Merlin Moncure wrote: > > I have seen a steady progressive rise in the number of postgresql > > related jobs and the quality of those jobs. Major companies are > > apparently rolling out critical infrastructure on postgresql...Vonage > > is

Re: [GENERAL] more anti-postgresql FUD

2006-10-11 Thread Andrew Kelly
On Tue, 2006-10-10 at 14:50 -0400, Tom Lane wrote: > Peter Eisentraut <[EMAIL PROTECTED]> writes: > >> * MySQL is used as a primary development platform. > > > Another good reason. > > Actually that's *the* reason --- it's always going to be hard for > Postgres to look good for an application th

[GENERAL] access and security

2006-10-30 Thread Andrew Kelly
Hi all, please forgive a (likely) less than clever question. Are the barriers provided by pg_hba.conf enough from a security standpoint, or is it best to put up some iptable rules duplicating the restrictions? Andy ---(end of broadcast)--- TIP 2:

Re: [GENERAL] access and security

2006-10-30 Thread Andrew Kelly
On Mon, 2006-10-30 at 15:36 +0100, Martijn van Oosterhout wrote: > On Mon, Oct 30, 2006 at 01:34:34PM +0100, Andrew Kelly wrote: > > Hi all, > > > > please forgive a (likely) less than clever question. > > > > Are the barriers provided by pg_hba.conf enough from

Re: [GENERAL] open source - content management system - that uses PostGreSQL

2007-02-19 Thread Andrew Kelly
On Sun, 2007-02-18 at 09:59 -0500, John DeSoi wrote: > On Feb 16, 2007, at 4:13 PM, Andrew Kirkness wrote: > > > I am currently setting up a website and have PostGreSQL database > > I'm using for the backend. I'm researching an open source Content > > Management System that uses PostGreSQL. Do

Re: [GENERAL] I have had enough

2004-11-10 Thread Andrew Kelly
On Wed, 2004-11-10 at 14:56, Mike Cox wrote (or didn't write): I guess that pretty much firmly identifies this list as an unmoderated list, non? ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] CMS - portal server Question

2006-08-25 Thread Andrew Kelly
On Fri, 2006-08-25 at 12:07 +0300, Achilleas Mantzios wrote: > In the same sense java is prefered over PHP, since we dont intent to interfere > with CMS code, but if some killer PHP app does the job, then it will be the > one selected. Take a look at eZpublish (http://ez.no). Killer PHP app, s

Re: [GENERAL] PostgreSQL on system with root as only user

2006-08-30 Thread Andrew Kelly
On Wed, 2006-08-30 at 09:17 -0400, Tom Lane wrote: > "Fredrik Israelsson" <[EMAIL PROTECTED]> writes: > > I am about to install PostgreSQL on a minimal Linux system, where root > > is the only user that is allowed to exist. > > You've *got* to be kidding. That's possibly the stupidest system desi

Re: [GENERAL] PostgreSQL slammed by PHP creator

2006-09-15 Thread Andrew Kelly
On Fri, 2006-09-15 at 00:21 -0500, Ron Johnson wrote: > On 09/14/06 21:32, AgentM wrote: > > > > On Sep 14, 2006, at 21:25 , Bruce Momjian wrote: > > > >> > >> I am not going to ask how you got to 135MPH. > > > > Obviously he was running MySQL under the hood. > > No wonder he spun out and crash

Re: [GENERAL] convert result to uppercase

2004-04-21 Thread Andrew Kelly
On Tue, 2004-04-20 at 23:39, Janning Vygen wrote: > Am Dienstag, 13. April 2004 14:17 schrieb Victor Spång Arthursson: > > Hi! > > > > How do i convert a result to upper/lowercase? > > This is a question > > > SELECT UPPER(lang) from languages; > > and this is the answer. It works exactly like t

[GENERAL] OT: Dup mails

2004-05-12 Thread Andrew Kelly
Sorry if this has already been covered... Suddenly I'm receiving every post to the pgsql-general list twice; been happening for a couple days now. I even unsubscribed for a bit and then resubscribed, but it continues. Is this just me, or is this a global thing? FWIW, I'm only getting single post

Re: [GENERAL] OT: Dup mails

2004-05-12 Thread Andrew Kelly
Whoops, disregard please. I shoulda noticed that the headers were identical before I went whining to the list. Sorry everybody. Turns out to have been a hammered chain of filters. Thanks for the nudge, Tom. Andy On Wed, 2004-05-12 at 13:03, Andrew Kelly wrote: > Sorry if this has already b