Re: [HACKERS] [PATCH] Docs: Make notes on sequences and rollback more obvious
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
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
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
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
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
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?
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?
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
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
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?
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 ...
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 )
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 )
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
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
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
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