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 chapter with a ref would be
 appropriate.
 

+1

 -Kevin

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


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 admonitions that
  it was only intended to ease conversion and that users were
  encouraged to migrate to standard syntax as soon as possible.
 

IMHO if you give someone syntax surgar like this and tell them to fix it ASAP 
it will never get fixed properly. I'm all for getting new users to pgsql, but 
this is not the way to do it.

Regards,
J

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


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 pretty much anything the users throw at it.
 
 It is also handy that it recognizes special case values like now,
 today, tomorrow and yesterday. However, I can't see any way of
 entering more general relative timestamps like 5 days ago or 2
 hours from now.
 

Years ago I wrapped 'getdate.y' from the CVS source code and made it into a 
python extension. It handles +2 hours or next week, etc. I don't know much 
of anything about making pg contrib modules, but it should not be hard to do. 
The way it works is you pass in a string and it returns the unix timestamp.

[...snipped...]
 
 Thoughts?
 Better ideas?
 
 Regards,
 Dean

Regards,
J

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


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 result that crosses the DST date. Does 
Postgres have a library that could be used by the parser?

 Regards,
 Dean

Regards,
Jeff

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


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 training easier for the teacher.

Regards,
J

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


[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 tell me what the actual problem is :)

eros=# select * from sig where path @ 'top.';
ERROR:  syntax error
DETAIL:  Unexpected end of line.

posting the issue here was suggested by someone in #postgresql earlier today. 

if I can be of assistance with more details please let me know.

regards,
jeff
-- 
http://zoidtechnologies.com/
websites that suck less

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers



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 XHTML 
  1.0 as the standard?
 
 I ran accross an article a few weeks ago that suggested that this wasn't
 all that great of an idea. Using HTML 4.01 should be just as useful.
 

I don't really have a concern if the standard chosen is XHTML or not..
what I am concerned about is that all the pages *validate*.

just my opinion of course :)

regards,
J


---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly


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 have one flag called, say, --build-env which has 
  all the interesting settings from the build environment in one hit.
 
 I thought about that too, but the advantage of separate options is that
 it'd be relatively easy for programs to pull out and use the values.
 For instance, this could be handy for configuring an external addon.
 I believe the --configure option is specifically designed to allow
   configure `pg_config --configure`
 to work sanely.
 
 The one-flag way would be human readable but not program friendly.
 
   regards, tom lane
 

how about both? have the various single-variable options, and another (like
'--build-env') that presents a human readable list for posting in bug
reports or web pages showing build environments and such..

regards,
J

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org


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 what the Win32 API calls are to get what you
  are looking for. Most concepts found in one system are also found in
  the other. I would assume yes before no.
 
 Yes - Win32 has Performance Counters which are an extensible set of
 monitored objects, and a rich API to access them - see
 http://msdn.microsoft.com/library/default.asp?url=/library/en-us/perfmon
 /base/performance_monitoring.asp for details. The perfmon program (Start
 - Run - perfmon - OK) gives a GUI interface to play with in which you
 can monitor any installed counter.
 
 Regards, Dave.

ok, ok.. you can tell I haven't seriously used win32 since the win 98 days
(heck, haven't written any kind of windows application since around thetime
of win 3.11 or so).. I told you I was ignorant of these things! :) I don't
have a win32 machine to try either of the above with, so I'll take the words
of the more experienced as fact :)

regards,
J

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings


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
determine load average on win32?

regards,
J

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster


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 plugging in amavis ...



 ---(end of broadcast)---
 TIP 4: Don't 'kill -9' the postmaster



---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster



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.

Jeff.

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html



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 wanting to do something moderately complicated
 would have a yet higher hurdle.  Isn't that a problem?

When you install freebsd or linux, is it a problem that all the perl modules
you need have to fetched from cpan ? why can't they call just be part of the
OS ?'
likewise with dns servers, samba, apache etc.. this is a bit of a stretched
example
but the point is the same.

Personall, I'd live to just be able to download the server with pg_dump psql
etc..

But that's just me for what it's worth.

jeff.


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster



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 just installed FreeBSD 4.6 on a machine, i chose to install
mod_php from /stand/sysinstall.

It ofcourse installed php, with mysql as a dependency, i was annoyed, but
when
i looked at what was actually installed, it was just mysql client.

The actually server did not get installed at all.

Jeff.


---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html



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 interviewed by OReilly


On Wed, 10 Jul 2002, Christopher Browne wrote:

 And if there are 20 places that say It's officially spelled
 PostgreSQL, but you can _pronounce_ that 'p\O\st-gres', and here's
 the MP3 of Bruce saying it, that can cope with the situation nicely.

For the record, the voice on the MP3 isn't Bruce.  It's the voice of a
professional broadcaster.

Vince.
-- 
==
Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net
 56K Nationwide Dialup from $16.00/mo at Pop4 Networking
Online Campground Directoryhttp://www.camping-usa.com
   Online Giftshop Superstorehttp://www.cloudninegifts.com
==




---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]



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

2002-06-26 Thread Jeff MacDonald

what is gborg ? :)

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]]On Behalf Of Marc G. Fournier
 Sent: Wednesday, June 26, 2002 11:21 AM
 To: Dave Cramer
 Cc: [EMAIL PROTECTED]
 Subject: Re: [HACKERS] Democracy and organisation : let's make a
 revolution



 could we get this added to gborg and a link created to it?  we're working
 on marketing Gborg, and the software that is listed there, and Chris added
 (at my request)  in code to the 'news' section so that whenever there are
 changes, it automatically gets sent to the -announce list so that ppl are
 aware of changes/enhancements/news ...

 On 26 Jun 2002, Dave Cramer wrote:

  I have started a java admin tool on sourceforge just 2 weeks ago
  actually, www.sf.net/jpgadmin
 
  Dave
 
  On Wed, 2002-06-26 at 02:51, Christopher Kings-Lynne wrote:
What other development options do we have for soemthing
 that is GUI and
portable to all platforms that postgresql runs on?  Java?
 wxWindows?  Qt?
Gtk?  I would think that Gtk is probably the most portable,
 and it has
bindings to many languages, but we would probalby want to use C.
  
   TOra uses QT and is cool.  Unfortunately Windows version
 costs money.  It is
   utterly, totally awesome though.  Don't know how good its
 Postgres support
   is working at the moment, tho.




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

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

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] 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,
Dave Cramer

 












 
--  
Chronological
--
  

 
  

 
  --  
  Thread 
  --  
  





  
  
  
  
  [EMAIL PROTECTED]">
  Reply via email to
  
  













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

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

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] 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,
Dave Cramer

 












 
--  
Chronological
--
  

 
  

 
  --  
  Thread 
  --  
  





  
  
  
  
  [EMAIL PROTECTED]">
  Reply via email to
  
  













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

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

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] 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,
Dave Cramer

 












 
--  
Chronological
--
  

 
  

 
  --  
  Thread 
  --  
  





  
  
  
  
  [EMAIL PROTECTED]">
  Reply via email to
  
  













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

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

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] 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,
Dave Cramer

 












 
--  
Chronological
--
  

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

2000-10-10 Thread Jeff MacDonald

Nope, neigher PyGreSQL nor ""PGSQL"" are products of
Pgsql.com (aka PostgreSQL Inc)On Mon, 9 Oct 2000, Vince Vielhaber wrote:

 On Mon, 9 Oct 2000, Bruce Momjian wrote:
 
  I need to know how this is different than our current python interface,
  PyGreSQL.
 
 Is this a 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  | 1-902-542-3657
-
Facsimile : 1 902 542 5386
IRC Nick  : bignose