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

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

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

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 pa

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 mak

[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 do

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

Re: [HACKERS] problems installing pgsql on rh9 box

2005-08-30 Thread Jeff MacDonald
On Tue, 2005-08-30 at 12:06 -0600, Ricardo Gamero wrote: > Hello everybody! > > I'm so sorry to post this simple question but I don't know what to do, > the thing is I need to install postgresql 8.0.3 in red hat 9 but when > I try to do it this errors appear: > > [EMAIL PROTECTED] root]# rpm -i

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

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 fig

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 det

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 an

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 y

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

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 anyon

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 interv

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

2002-06-26 Thread Jeff MacDonald
ard Re: [HACKERS] Democracy and organisation : let's make a revolution, Scott Marlowe Re: [HACKERS] Democracy and organisation : let's make a revolution, Andrew Sullivan Re: [HACKERS] Democracy and organisation : let's make a revolution, Christopher Kings-Lynne Re: [HACKERS

[HACKERS] test .. ignore

2000-11-08 Thread Jeff MacDonald
Jeff MacDonald, - PostgreSQL Inc | Hub.Org Networking Services [EMAIL PROTECTED] | [EMAIL PROTECTED] www.pgsql.com | www.hub.org 1-902-542-0713 | 1-902-542-3657

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

2000-10-10 Thread Jeff MacDonald
t; PyGreSQL. > > Is this a product of pgsql.com? > > Vince. > Jeff MacDonald, - PostgreSQL Inc | Hub.Org Networking Services [EMAIL PROTECTED] | [EMAIL PROTECTED] www.pgsql.com |

[HACKERS] ordbms - postgresql errata

2000-09-26 Thread Jeff MacDonald
greetings, i planning on making heavy use of the postgresql inheritance features for a large scale application and i was wondering if anyone has run into any interesting errata regarding this that i should be aware of. bugs, features, caveats, side notes etc.. Jeff MacDonald

Re: [HACKERS] ordbms - postgresql errata

2000-09-18 Thread Jeff MacDonald
it would appear my first mail didn't go thru the basic gist was, can anyone point out any caveats/pitfalls to the postgresql inheritance functions.. On Tue, 19 Sep 2000, Jeff MacDonald wrote: > i just found a (few) caveat already.. > > 1: > > bignose=# create tab

[HACKERS] ordbms - postgresql errata

2000-09-18 Thread Jeff MacDonald
ender, but it put in a "randomish" value.. shouldn't it have just left this untouched ? Jeff MacDonald, - PostgreSQL Inc | Hub.Org Networking Services [EMAIL PROTECTED] | [EMAIL PROTECTED] www.pgsql.com