FAQ

PostgreSQL > pgsql-hackers > March 2003

Search Discussions

180 discussions - 1,242 posts

  • 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 LaneTom 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 ConwayJoe 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 ...
    TaralTaral
    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 ConwayNeil 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 KoizarManfred 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 LaneTom 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 EisentrautPeter 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. WoodwardMark 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 IshiiTatsuo 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 ConwayNeil 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 EisentrautPeter 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 SFKey88 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 LaneTom 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 LaneTom 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 NielsenEric 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 BerkusJosh 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 LaneTom 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 CliftJustin 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 PflugAndreas Pflug
    Mar 24, 2003 at 6:14 pm
    Apr 2, 2003 at 11:20 pm
  • 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 HerreraAlvaro 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 SzaboStephan 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 KindnessLee 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 ConwayNeil 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 ConwayNeil 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. WoodwardMark 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 BartunovOleg 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 PageDave 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-LynneChristopher 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. ThaiThomas 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 SuttonChris 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 TaylorRod 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 IshiiTatsuo 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 LaneTom 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 ZukermanItai 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 LiuJohn 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 EisentrautPeter 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-LynneChristopher 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 PageDave 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örklundDennis 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-LynneChristopher 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 LaneTom Lane
    Mar 3, 2003 at 5:16 am
    Mar 3, 2003 at 9:46 pm
  • 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 ConwayJoe 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 BrownKevin 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 LaneTom 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.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 LaneTom 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. WoodwardMark 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-LynneChristopher 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 MullaneGreg 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 LaneTom Lane
    Mar 1, 2003 at 12:16 am
    Mar 3, 2003 at 3:45 am
Mar 2003
1234
Group Navigation
period‹ prev | Mar 2003 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions180
posts1,242
users145
websitepostgresql.org...
irc#postgresql

145 users for March 2003

Tom Lane: 226 posts Bruce Momjian: 177 posts Peter Eisentraut: 50 posts Christopher Kings-Lynne: 49 posts Dave Page: 38 posts Hiroshi Inoue: 38 posts Rod Taylor: 35 posts Justin Clift: 33 posts Joe Conway: 31 posts Neil Conway: 30 posts Alvaro Herrera: 27 posts Merlin Moncure: 26 posts Hannu Krosing: 21 posts Kevin Brown: 19 posts Marc G. Fournier: 19 posts Larry Rosenman: 17 posts Scott.marlowe: 14 posts Greg Stark: 13 posts Mark L. Woodward: 13 posts Tatsuo Ishii: 12 posts
show more
Archives