Search Discussions
-
This is an attempt to lay out a road map for updating the frontend/backend protocol in 7.4. I don't at this point want to get into details on any one of the TODO items, just get consensus that this ...
Tom Lane
Mar 10, 2003 at 6:51 pm
May 25, 2003 at 3:59 am -
I'd like to implement SQL99/200x ARRAY support (well, at least the basics). Does anyone have objections to the following grammar/semantics? =========================================================== ...
Joe Conway
Mar 9, 2003 at 3:57 am
Mar 24, 2003 at 7:00 pm -
I tried general, but no response. Anyone here can shed some light on the issue? Do I need to code merge sort into postgresql? ----- Forwarded message from Taral <taral@taral.net ----- From: Taral ...
Taral
Mar 13, 2003 at 9:10 pm
Apr 15, 2003 at 2:47 am -
Folks, I'd like to implement updateable cursors. I'll be working on just getting updateable cursors working for relatively simple SELECT queries (e.g. no joins, aggregates, grouping, user-defined ...
Neil Conway
Mar 24, 2003 at 9:49 pm
Apr 2, 2003 at 2:59 pm -
Here is, what I've put together from various messages posted November/December last year. . Subtrans trees . Transaction states . Tuple visibility . HeapTupleSatifiesUpdate . Shortcuts . Still ...
Manfred Koizar
Mar 19, 2003 at 7:29 am
Mar 21, 2003 at 3:53 pm -
(Or, protocol upgrade phase 1...) After digging through our many past discussions of what to do with error messages, I have put together the following first-cut proposal. Fire at will... Objective ...
Tom Lane
Mar 13, 2003 at 8:51 pm
Mar 18, 2003 at 2:49 pm -
There are Windows binaries on the PostgreSQL FTP server mirrors, for example, http://ftp.de.postgresql.org/mirror/postgresql/binary/v7.3.1/Windows/ that users are having problems with. Apparently ...
Peter Eisentraut
Mar 5, 2003 at 10:48 pm
Mar 10, 2003 at 6:33 pm -
I have been working on moving some of my software to a more SOAP compatible interface. As I was doing it, it occured to me that a generic function could be written, in PostgreSQL's new function ...
Mark L. Woodward
Mar 28, 2003 at 1:50 pm
Apr 3, 2003 at 3:32 pm -
We are developing a Win32 port of PostgreSQL 7.3(different from Jan's implementaion, in that we are using a thread model. In the future I hope we could contribute the source code). We have done a ...
Tatsuo Ishii
Mar 5, 2003 at 12:20 pm
Mar 8, 2003 at 2:32 am -
Folks, I'm currently working on an implementation of cursors that can function outside the transaction that created them (the SQL spec calls them "holdable cursors"). I can see 2 main ways to ...
Neil Conway
Mar 18, 2003 at 2:48 am
Mar 20, 2003 at 3:38 am -
The XML standard does not call for any table format. But a number of table formats have been established within the XML framework. Some of them are formatting-oriented (e.g., the HTML model, or CALS ...
Peter Eisentraut
Mar 3, 2003 at 5:55 pm
Mar 7, 2003 at 1:33 pm -
Hi - there is a problem with PQescapeBytea for Win32. Since libpq is a DLL, all memory allocated from within the DLL needs to be freed from within the dll. PQescapeBytea allocates memory, but there ...
Key88 SF
Mar 18, 2003 at 4:49 am
Mar 25, 2003 at 2:46 am -
I checked into this, and indeed OS X 10.2 is behaving funny: integer divide by zero doesn't raise any signal, it just returns a bogus answer. They're within their rights to do so according to the ...
Tom Lane
Mar 8, 2003 at 6:19 pm
Mar 10, 2003 at 10:35 pm -
A conversation with Andrew Sullivan led me to the following idea: We have a number of frontends that like to issue BEGIN immediately after COMMIT; so that if the client does nothing for awhile after ...
Tom Lane
Mar 29, 2003 at 4:13 am
May 26, 2003 at 6:36 pm -
Let me preface this by expressing my appreciation for all the hard work for the people who develop, maintain, and support PostGreSQL. I've been using it for a little over two years for a variety of ...
Eric D Nielsen
Mar 4, 2003 at 10:11 pm
Mar 8, 2003 at 2:24 am -
Folks, Some months ago we agreed on this list that the functioning of to_char(interval) was not particularly useful the way it works in current stable versions. I don't see a to_char fix on the TODO ...
Josh Berkus
Mar 21, 2003 at 11:32 pm
Mar 26, 2003 at 6:01 pm -
Postgres' implementation of cursors has always had a problem with doing MOVE or FETCH backwards on complex queries. It works okay for simple seqscans and indexscans, but fails for plans involving ...
Tom Lane
Mar 9, 2003 at 8:35 pm
Mar 10, 2003 at 4:26 pm -
Hi everyone, Thinking about the numbering further. Would it be cool to decide on the version numbering of our next release like this: + If it looks like we'll have Win32 and/or PITR recovery in time ...
Justin Clift
Mar 12, 2003 at 5:29 am
Mar 12, 2003 at 4:24 pm -
Trying to connect from pgadmin2, I get the message "no pg_hba.conf entry for ..." I found that the ip address matching with rangeSockAdr in line 651 in hba.c fails. I get access if I set ipaddr/mask ...
Andreas Pflug
Mar 24, 2003 at 6:14 pm
Apr 2, 2003 at 11:20 pm -
11
ALTER USER
Hackers, One can alter a user to set a validity timestamp. However, unless one uses the ugly kludge of setting a date very far into the future, there's no way to set this validity forever. Should I ...Alvaro Herrera
Mar 16, 2003 at 2:38 am
Mar 20, 2003 at 8:05 pm -
Going through the issues in doing dirty reads in foreign keys I've come up with a few cases that I'm fairly uncertain about how to handle with regards to deadlocks and figured I should ask for advice ...
Stephan Szabo
Mar 1, 2003 at 12:17 am
Mar 1, 2003 at 7:27 pm -
Philip, You can find the "patch so far" at: http://services.csl.co.uk/postgresql/ along with a libpq thread-safe patch. The thread referenced by Bruce's email details some of the issues still to be ...
Lee Kindness
Mar 28, 2003 at 9:37 am
Jun 2, 2003 at 6:56 am -
About 1 in every 5 runs of the (parallel) regression tests are failing for me with CVS HEAD: the triggers, inherit, vacuum, sanity_check, and misc tests fail. I can make the failures occur fairly ...
Neil Conway
Mar 7, 2003 at 8:53 pm
Mar 9, 2003 at 6:25 pm -
Folks, While doing some other cursor-related work, I noticed the following two issues: (1) Lack of NO SCROLL The SQL spec specifies that you should be able to specify NO SCROLL to DECLARE CURSOR to ...
Neil Conway
Mar 21, 2003 at 4:35 pm
Mar 24, 2003 at 5:28 pm -
I was at a client office reviewing some code. They use MSSQL and I noticed that: select * from table where field = 'blah'; gave the same results as: select * from table where field = 'BLah'; I was ...
Mark L. Woodward
Mar 12, 2003 at 1:54 pm
Mar 23, 2003 at 1:21 pm -
Hi there, we have a little problem in new version of tsearch we're currently working. We've implemented concatenation operation for txtidx type and treat concatenation with NULL as NULL (as it should ...
Oleg Bartunov
Mar 19, 2003 at 7:26 pm
Mar 20, 2003 at 2:55 pm -
I have a table that is likely to grow over the next few years at a rate of 1K-2K rows/day. As the vast majority of the activity on the table (other than the inserts) will be selects of data for the ...
Dave Page
Mar 6, 2003 at 4:52 pm
Mar 7, 2003 at 10:30 am -
Hi Guys, I just thought I'd share with you guys a very clever solution to the old 'update row. if no rows affected, then insert the row' race condition problem. A guy at my work came up with it. We ...
Christopher Kings-Lynne
Mar 27, 2003 at 1:55 am
Mar 28, 2003 at 5:34 am -
System: NetBSD / Alpha 1.6 (64 bit) Postgresql 7.3.2 Bug: after vacuum analyze, I'm unable to do a simple select. Instead I'm getting this error: ERROR: datumGetSize: Invalid typLen 0 Many thanks to ...
Thomas T. Thai
Mar 27, 2003 at 1:42 am
Mar 27, 2003 at 5:38 pm -
Hello, I need some insight on the best way to use a RAM drive in a Postgresql installation. Here is our situation and current setup: Postgresql 7.2.1 Dual PIII 800 RAID 5 SCSI disks Platypus 8GB PCI ...
Chris Sutton
Mar 4, 2003 at 3:03 pm
Mar 6, 2003 at 9:50 pm -
It would be nice if PGAvd could receive row level stats without a large hit to simple queries. Ran a simple test. Calling pgstat_report_tabstat() at a frequency of once per second reduces the time ...
Rod Taylor
Mar 6, 2003 at 5:28 am
Mar 6, 2003 at 5:05 pm -
Kenji Sugita has identified a problem with cost_sort() in costsize.c. In the following code fragment, sortmembytes is defined as long. So double nruns = nbytes / (sortmembytes * 2); may cause an ...
Tatsuo Ishii
Mar 31, 2003 at 10:36 pm
Apr 2, 2003 at 7:02 pm -
I've been amusing myself the last several evenings by working on a reimplementation of the NUMERIC datatype, along the lines of previous discussion (use base-10000 digits instead of base-10 so that ...
Tom Lane
Mar 20, 2003 at 3:51 am
Mar 20, 2003 at 6:33 pm -
Just before the return from gistSplit() I see this: (gdb) p (*newtup)[0] $147 = {t_tid = {ip_blkid = {bi_hi = 0, bi_lo = 34}, ip_posid = 1}, t_info = 136} (gdb) p (*newtup)[1] $148 = {t_tid = ...
Itai Zukerman
Mar 2, 2003 at 1:13 pm
Mar 3, 2003 at 9:58 am -
make[4]: Leaving directory `/emrxdbs/postgresql-7.3.2/src/backend/parser' cc -O2 -qmaxmem=16384 -qsrcmsg -qlonglong -I../../../src/interfaces/libpq -I ../../../src/include -I/usr/local/include ...
John Liu
Mar 31, 2003 at 4:14 pm
Apr 2, 2003 at 3:15 pm -
Some people were mentioning an error message style guide. Here's a start of one that I put together a while ago. Feel free to consider it. Size of message --------------- The main part of a message ...
Peter Eisentraut
Mar 15, 2003 at 12:42 am
Mar 24, 2003 at 12:46 am -
Does the new ALTER TABLE / CLUSTER ON syntax support the ONLY modifier - it isn't documented if it is?? I guess it's not really relevant is it? Chris
Christopher Kings-Lynne
Mar 21, 2003 at 3:20 am
Mar 22, 2003 at 4:48 am -
Hi all, The following script is currently used to build our main website. Static HTML versions of each of the pages are generated from php scripts on an hourly basis by this script, but the other day ...
Dave Page
Mar 11, 2003 at 8:35 pm
Mar 13, 2003 at 3:41 pm -
There is no declaration of charset in the main webpage. Something like <meta content="text/html; charset=iso-8859-1" http-equiv="Content-Type" would be nice. What is worse is that there are several ...
Dennis Björklund
Mar 8, 2003 at 6:12 am
Mar 9, 2003 at 9:18 am -
I want to fix this bug, however I can't see how the example below is failing... (Obeys dropped columns) I'm not up with my SRFs, so would someone be able to post a concise SQL script that ...
Christopher Kings-Lynne
Mar 6, 2003 at 2:21 am
Mar 8, 2003 at 4:09 am -
OSDL has just come out with a set of open-source database benchmarks: http://www.osdl.org/projects/performance/ The bad news: "This tool kit works with SAP DB open source database versions 7.3.0.23 ...
Tom Lane
Mar 3, 2003 at 5:16 am
Mar 3, 2003 at 9:46 pm -
5
IS OF
While messing around in gram.y I came across a production like this: { $$ = (Node *) makeSimpleA_Expr(AEXPR_OF, "=", $1, (Node *) $5); } { $$ = (Node *) makeSimpleA_Expr(AEXPR_OF, "!=", $1, (Node *) ...Joe Conway
Mar 22, 2003 at 11:58 pm
May 26, 2003 at 3:59 pm -
I've been experimenting with Matthew T. O'Connor's pg_avd (auto vacuum daemon), which is actually quite an interesting piece of software that so far seems to function pretty well. I've ported it to ...
Kevin Brown
Mar 27, 2003 at 11:32 am
Apr 4, 2003 at 11:27 pm -
I have just noticed that 7.3 and CVS tip reject a query that was accepted in earlier releases: regression=# create table t1(f1 int, f2 int); CREATE TABLE regression=# create table t2(f2 int, f3 int); ...
Tom Lane
Mar 31, 2003 at 7:44 pm
Apr 1, 2003 at 3:00 pm -
I am seeing this same problem on two separate machines, one brand new, one older. Not sure yet what is causing it, but seems pretty unlikely that it is hardware-related. Ed
Ed L.
Mar 31, 2003 at 10:38 pm
Apr 1, 2003 at 1:06 am -
Deepak Bhole of Red Hat just pointed out to me a failure that he got after some 7.3 stress testing: This error comes out of regprocin() when it finds multiple candidate functions with the same name ...
Tom Lane
Mar 12, 2003 at 8:16 pm
Mar 23, 2003 at 5:24 am -
I haven't been able to get to it all morning.
Mark L. Woodward
Mar 7, 2003 at 4:56 pm
Mar 8, 2003 at 3:01 am -
Hey, with this new ALTER SEQUENCE patch, how about this for an idea: I submitted a patch to always generate non-colliding index and sequence names. Seemed like an excellent idea. However, 7.3 dumps ...
Christopher Kings-Lynne
Mar 4, 2003 at 1:47 am
Mar 7, 2003 at 4:35 pm -
As promised, I've been looking over the error handling (especially the archived discussions) and it's a real rat's nest. :) I'm not sure where we should start, but just getting some error codes ...
Greg Sabino Mullane
Mar 4, 2003 at 10:09 pm
Mar 6, 2003 at 8:41 am -
Ahh ... it took me way too long to realize what was happening. The problem is simply that GiST indexes do not index nulls (at least not in the first column of an index). So if you CLUSTER, you lose ...
Tom Lane
Mar 1, 2003 at 12:16 am
Mar 3, 2003 at 3:45 am
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 180 |
posts | 1,242 |
users | 145 |
website | postgresql.org... |
irc | #postgresql |
145 users for March 2003
Archives
- August 2013 (1,430)
- July 2013 (1,772)
- June 2013 (2,428)
- May 2013 (1,555)
- April 2013 (1,283)
- March 2013 (1,441)
- February 2013 (1,366)
- January 2013 (2,520)
- December 2012 (1,701)
- November 2012 (1,618)
- October 2012 (1,580)
- September 2012 (1,195)
- August 2012 (1,180)
- July 2012 (1,125)
- June 2012 (1,850)
- May 2012 (1,584)
- April 2012 (1,459)
- March 2012 (1,921)
- February 2012 (1,517)
- January 2012 (1,777)
- December 2011 (1,347)
- November 2011 (1,764)
- October 2011 (1,687)
- September 2011 (1,623)
- August 2011 (1,433)
- July 2011 (1,658)
- June 2011 (2,404)
- May 2011 (1,664)
- April 2011 (1,834)
- March 2011 (1,956)
- February 2011 (2,476)
- January 2011 (2,965)
- December 2010 (2,587)
- November 2010 (2,109)
- October 2010 (2,113)
- September 2010 (2,173)
- August 2010 (2,061)
- July 2010 (1,612)
- June 2010 (1,560)
- May 2010 (1,961)
- April 2010 (1,575)
- March 2010 (1,314)
- February 2010 (2,439)
- January 2010 (3,118)
- December 2009 (2,514)
- November 2009 (493)
- October 2009 (1,903)
- September 2009 (1,990)
- August 2009 (2,170)
- July 2009 (2,025)
- June 2009 (1,565)
- May 2009 (1,518)
- April 2009 (1,431)
- March 2009 (1,424)
- February 2009 (1,399)
- January 2009 (2,641)
- December 2008 (2,011)
- November 2008 (1,918)
- October 2008 (1,695)
- September 2008 (1,887)
- August 2008 (1,374)
- July 2008 (1,495)
- June 2008 (1,149)
- May 2008 (1,112)
- April 2008 (1,908)
- March 2008 (1,288)
- February 2008 (1,309)
- January 2008 (1,220)
- December 2007 (989)
- November 2007 (1,369)
- October 2007 (1,553)
- September 2007 (1,225)
- August 2007 (1,221)
- July 2007 (1,007)
- June 2007 (1,127)
- May 2007 (1,189)
- April 2007 (1,266)
- March 2007 (1,866)
- February 2007 (1,916)
- January 2007 (1,645)
- December 2006 (1,423)
- November 2006 (1,021)
- October 2006 (1,565)
- September 2006 (2,375)
- August 2006 (2,039)
- July 2006 (1,626)
- June 2006 (1,624)
- May 2006 (1,366)
- April 2006 (1,150)
- March 2006 (1,327)
- February 2006 (1,259)
- January 2006 (1,030)
- December 2005 (1,252)
- November 2005 (1,568)
- October 2005 (1,417)
- September 2005 (1,464)
- August 2005 (1,191)
- July 2005 (1,150)
- June 2005 (1,576)
- May 2005 (1,592)
- April 2005 (1,004)
- March 2005 (1,069)
- February 2005 (969)
- January 2005 (1,100)
- December 2004 (949)
- November 2004 (1,210)
- October 2004 (1,059)
- September 2004 (951)
- August 2004 (1,601)
- July 2004 (1,397)
- June 2004 (1,037)
- May 2004 (1,446)
- April 2004 (1,167)
- March 2004 (1,330)
- February 2004 (1,003)
- January 2004 (861)
- December 2003 (827)
- November 2003 (1,618)
- October 2003 (1,602)
- September 2003 (1,683)
- August 2003 (1,343)
- July 2003 (1,045)
- June 2003 (1,302)
- May 2003 (802)
- April 2003 (1,012)
- March 2003 (1,242)
- February 2003 (1,323)
- January 2003 (1,315)
- December 2002 (1,176)
- November 2002 (1,220)
- October 2002 (1,449)
- September 2002 (1,816)
- August 2002 (2,295)
- July 2002 (1,290)
- June 2002 (1,024)
- May 2002 (1,157)
- April 2002 (1,532)
- March 2002 (1,207)
- February 2002 (1,225)
- January 2002 (1,397)
- December 2001 (963)
- November 2001 (1,301)
- October 2001 (1,155)
- September 2001 (895)
- August 2001 (1,204)
- July 2001 (938)
- June 2001 (1,131)
- May 2001 (1,458)
- April 2001 (1,168)
- March 2001 (1,672)
- February 2001 (1,154)
- January 2001 (1,450)
- December 2000 (1,222)
- November 2000 (1,390)
- October 2000 (1,296)
- September 2000 (633)
- August 2000 (888)
- July 2000 (1,428)
- June 2000 (1,283)
- May 2000 (1,648)
- April 2000 (184)
- March 2000 (291)
- February 2000 (1,464)
- January 2000 (1,639)
- December 1999 (1,056)
- November 1999 (916)
- October 1999 (949)
- September 1999 (946)
- August 1999 (695)
- July 1999 (1,070)
- June 1999 (1,242)
- May 1999 (1,136)
- April 1999 (218)
- March 1999 (1,002)
- February 1999 (692)
- January 1999 (758)
- December 1998 (591)
- November 1998 (600)
- October 1998 (1,208)
- September 1998 (678)
- August 1998 (856)
- July 1998 (482)
- June 1998 (496)
- May 1998 (618)
- April 1998 (702)
- March 1998 (1,118)
- February 1998 (1,307)
- January 1998 (855)
- December 1997 (346)
- November 1997 (374)
- October 1997 (575)
- September 1997 (549)
- August 1997 (404)
- July 1997 (391)
- June 1997 (595)
- May 1997 (478)
- April 1997 (854)
- March 1997 (526)
- February 1997 (297)
- January 1997 (927)
- December 1996 (2)
- November 1996 (1)
- October 1996 (1)
- October 1995 (2)
- July 1995 (1)