Re: [HACKERS] [PATCH] Docs: Make notes on sequences and rollback more obvious

2012-08-07 Thread Jeff MacDonald
On Tuesday, August 07, 2012 09:45:35 AM Kevin Grittner wrote: [...snipped...] I also think it's a problem that one can get through the entire Concurrency Control chapter (mvcc.sgml) without a clue that sequences aren't transactional. I think maybe a mention in the Introduction section of that

Re: [HACKERS] MySQL search query is not executing in Postgres DB

2012-02-17 Thread Jeff MacDonald
Greetings, My biggest concern is whether we might paint ourselves into a corner by including such an extension. It might shut off avenues for other cool features because anyone using the extension would have conflicts. Perhaps such a thing would be more appropriate on PGXN with

Re: [HACKERS] Inputting relative datetimes

2011-08-27 Thread Jeff MacDonald
Greetings, On Thursday, August 25, 2011 05:39:09 AM Dean Rasheed wrote: As background, I have an app that accepts user text input and casts it to a timestamp in order to produce reports. I use PostgreSQL's timestamp input conversion for this, since it gives a lot of flexibility, and can parse

Re: [HACKERS] Inputting relative datetimes

2011-08-27 Thread Jeff MacDonald
Greetings, On Saturday, August 27, 2011 11:36:13 AM Dean Rasheed wrote: I'm not sure how best to handle timezones though, since it's hard-coded list probably won't match the timezones PostgreSQL knows about. Maybe that doesn't matter, I'm not sure. It'll matter when the expression has a

Re: [HACKERS] Indication of db-shared tables

2011-06-22 Thread Jeff MacDonald
Greetings, On Wednesday, June 22, 2011 09:10:02 AM Bruce Momjian wrote: I assumed it was important to indicate if someone was looking at per-database or per-cluster data, like pg_tablespace. The issue comes up when I do admin training about the system tables. +1 I favor features that make

[HACKERS] quirk using 'ltree' module: paths ending with a dot result in cryptic error message

2008-04-27 Thread Jeff MacDonald
greetings, I am using opensuse 10.3, and postgresql-contrib-8.2.6-0.1 which has the ltree contrib bundled with it. I have found that if I do a search with a path that ends in a . (dot), the error message I get in my logs is something like unexpected end of line or some such, which imo doesn't

Re: [HACKERS] FAQ/HTML standard?

2005-09-10 Thread Jeff MacDonald
On Sat, 2005-09-10 at 12:59 -0500, Bruno Wolff III wrote: On Sat, Sep 10, 2005 at 12:10:19 -0400, Andrew Dunstan [EMAIL PROTECTED] wrote: Is there an HTML standard that we try to follow in our HTML docs such as FAQs? If there isn't an explicit standard, may I suggest that we adopt

Re: [HACKERS] small proposal: pg_config record flag variables?

2005-08-09 Thread Jeff MacDonald
On Tue, Aug 09, 2005 at 03:25:16PM -0400, Tom Lane wrote: Andrew Dunstan [EMAIL PROTECTED] writes: Tom Lane wrote: pg_config --cc pg_config --cppflags pg_config --cflags pg_config --cflags_sl pg_config --ldflags pg_config --ldflags_sl pg_config --libs I would be tempted to

Re: [HACKERS] Autovacuum to-do list

2005-08-02 Thread Jeff MacDonald
On Tue, Aug 02, 2005 at 08:25:00AM +0100, Dave Page wrote: [..snipped..] Oooo... That's a lot of win32 ignorance to ignore... :-) Push control-alt-delete and look under Performance. I believe Windows may even keep *more* information that Linux. It's all a question of figuring out

Re: [HACKERS] Autovacuum to-do list

2005-08-01 Thread Jeff MacDonald
On Mon, Aug 01, 2005 at 10:22:14PM -0400, Matthew T. O'Connor wrote: [..snipped..] Right which is why we would need to enforce some max value so that vacuuming will never be totally squeezed out. greetings, I'm a linux guy, so please forgive my ignorance, but is it even possible to

Re: [HACKERS] Does this go out?

2002-08-02 Thread Jeff MacDonald
got it... what's amivis ? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Marc G. Fournier Sent: Friday, August 02, 2002 10:17 AM To: [EMAIL PROTECTED] Subject: [HACKERS] Does this go out? Just making sure that I haven't screwed up anything

Re: [HACKERS] Trimming the Fat, Part Deux ...

2002-08-01 Thread Jeff MacDonald
And the sooner our very old perl client goes away, the better I like it. It is a good client, don't get me wrong: but DBD:Pg is the standard now. This may sound like a dumb question, but DBD::Pg == DBI right ? not pg.pm I code perl about 25 hours a week, and DBI has never failed me yet.

Re: Trim the Fat (Was: Re: [HACKERS] Open 7.3 items )

2002-07-31 Thread Jeff MacDonald
Besides, more generally, Postgres already has a reputation as being difficult to install. The proposal to separate out all the non-basics (I'm not even sure how one would draw that line: maybe a server-only package and a client-library package run through GBorg?) would mean that anyone

Re: Trim the Fat (Was: Re: [HACKERS] Open 7.3 items )

2002-07-31 Thread Jeff MacDonald
How many thousands of web sites out there don't offer PgSQL due to teh hassle? Everyone is arguing 'why mysql vs pgsql?' ... if we had a simple 'libpq.tar.gz' that could be downloaded, nice and small, then we've just made enabling PgSQL by default in mod_php4 brain dead ... Case in point, I

Re: [HACKERS] I am being interviewed by OReilly

2002-07-11 Thread Jeff MacDonald
How long did it take you to teach him to say PostgreSQL ? :) Jeff. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Vince Vielhaber Sent: Thursday, July 11, 2002 6:31 AM To: Christopher Browne Cc: [EMAIL PROTECTED] Subject: Re: [HACKERS] I am being

Re: [HACKERS] Democracy and organisation : let's make a revolution

2002-06-26 Thread Jeff MacDonald
] Democracy and organisation : let's make a revolution, Kaare Rasmussen Re: [HACKERS] Democracy and organisation : let's make a revolution, Dave Cramer Re: [HACKERS] Democracy and organisation : let's make a revolution, Jeff MacDonald Re: [HACKERS] Democracy and organisation : let's make a revolution

Re: [HACKERS] Announcing PgSQL - a Python DB-API 2.0 compliantinterface to PostgreSQL

2000-10-10 Thread Jeff MacDonald
product of pgsql.com? Vince. Jeff MacDonald, - PostgreSQL Inc | Hub.Org Networking Services [EMAIL PROTECTED] | [EMAIL PROTECTED] www.pgsql.com | www.hub.org 1-902-542-0713