FAQ

PostgreSQL > pgsql-hackers > September 2002

Search Discussions

251 discussions - 1,816 posts

  • Hi everyone, Am just wondering if we've ever considered adding a PGXLOG environment variable that would point to the pg_xlog directory? In a Unix environment it's not real necessary as filesystem ...
    Justin CliftJustin Clift
    Sep 12, 2002 at 4:29 am
    Oct 15, 2002 at 9:06 am
  • Hello Barry, JDBC driver must find autocommit (off or on) and set autoCommit field when open connection. regards
    SnpeSnpe
    Sep 6, 2002 at 6:10 pm
    Sep 11, 2002 at 10:03 pm
  • I've come upon a misbehaviour of drop column, where drop column unconditionally drops inherited column from child tables. What it should do is to check if the same column is not inherited from other ...
    Hannu KrosingHannu Krosing
    Sep 12, 2002 at 7:21 am
    Oct 3, 2002 at 9:29 pm
  • We've been discussing this stuff in fits and starts for months now, but nothing satisfactory has been arrived at. I've concluded that part of the problem is that we are trying to force the system's ...
    Tom LaneTom Lane
    Sep 15, 2002 at 5:09 pm
    Oct 9, 2002 at 4:22 pm
  • Hello all, Some time back I posted a query to build a site with 150GB of database. In last couple of weeks, lots of things were tested at my place and there are some results and again some concerns. ...
    Shridhar DaithankarShridhar Daithankar
    Sep 26, 2002 at 8:35 am
    Sep 27, 2002 at 7:01 pm
  • There has been a lot of activity on open items in the past week. Here is the updated list. Basically, upgrading and casting have blown up into a variety of items. ...
    Bruce MomjianBruce Momjian
    Sep 18, 2002 at 5:10 am
    Sep 24, 2002 at 5:26 pm
  • Hello all, PostgreSQL *still* has a bug where PQcmdStatus() won't return the number of rows updated. But that is essential for applications, since without it of course we don't know if the ...
    Steve HoweSteve Howe
    Sep 6, 2002 at 6:10 pm
    Sep 11, 2002 at 7:54 pm
  • I have finished going through my email box and applying patches from the patches queue. There is one patch left in the queue related to tcl notification of connection failure. Tom wants to look at ...
    Bruce MomjianBruce Momjian
    Sep 2, 2002 at 6:30 am
    Sep 6, 2002 at 12:48 am
  • Because we have seen many complains about sequential vs index scans, I wrote a script which computes the value for your OS/hardware combination. Under BSD/OS on one SCSI disk, I get a ...
    Bruce MomjianBruce Momjian
    Sep 9, 2002 at 5:05 am
    Oct 12, 2002 at 2:45 pm
  • will announce it on -announce tomorrow, if ppl want to take a quick look at it ... man pages weren't included, but I did regenerate the docs per Peter's suggested commands ... Scary, even with ...
    Marc G. FournierMarc G. Fournier
    Sep 5, 2002 at 2:39 am
    Sep 12, 2002 at 9:19 pm
  • Having not seen anyone asking about the progress on the 7.3beta RPMset, I thought I would give a statement as to where things stand. I am waiting the result of the pg_dump from 7.2.x to 7.3 restore ...
    Lamar OwenLamar Owen
    Sep 17, 2002 at 3:51 pm
    Sep 19, 2002 at 1:21 am
  • I am working with several groups getting the Win32 port ready for 7.4 and I have a few questions: What is the standard workaround for the fact that rename() isn't atomic on Win32? Do we need to ...
    Bruce MomjianBruce Momjian
    Sep 19, 2002 at 12:01 am
    Sep 20, 2002 at 5:54 pm
  • Hello all, Here are the proposals for solutioning the "Return proper effected tuple count from complex commands [return]" issue as seen on TODO. Any comments ?... This is obviously open to voting and ...
    Steve HoweSteve Howe
    Sep 8, 2002 at 10:50 pm
    Sep 11, 2002 at 10:11 am
  • Hi all, While testing for large databases, I am trying to load 12.5M rows of data from a text file and it takes lot longer than mysql even with copy. Mysql takes 221 sec. v/s 1121 sec. for postgres. ...
    Shridhar DaithankarShridhar Daithankar
    Sep 20, 2002 at 3:59 pm
    Oct 6, 2002 at 3:06 pm
  • OK, I just received this answer from an Oracle 9 tester. It shows CURRENT_TIMESTAMP changing during the transaction. Thanks, Dan. Dan, it wasn't clear if this was in a transaction or not. Does Oracle ...
    Bruce MomjianBruce Momjian
    Sep 30, 2002 at 5:17 pm
    Oct 3, 2002 at 8:56 am
  • 25

    Re:

    Ok, I made the changes in the compressed pg_dump file. Now pg_restore crashes: pg_restore: [archiver] out of memory *sigh* L. -- Laurette Cisneros The Database Group (510) 420-3137 NextBus ...
    Laurette CisnerosLaurette Cisneros
    Sep 9, 2002 at 10:54 pm
    Sep 12, 2002 at 2:11 am
  • In an attempt to beef up the PostgreSQL port for FreeBSD, I've added an option for adding additional optimization, similar to what MySQL does by compiling the server with -O6. I'm only compiling at ...
    Sean ChittendenSean Chittenden
    Sep 9, 2002 at 9:27 pm
    Sep 23, 2002 at 5:44 am
  • As was previously discussed (and now that I'm mostly back from the dead ... damn colds) I've just branched off REL7_3_STABLE ... all future beta's will be made based off of that branch, so that ...
    Marc G. FournierMarc G. Fournier
    Sep 28, 2002 at 4:47 pm
    Oct 22, 2002 at 6:56 am
  • I have seen no discussion on whether to go ahead with a 7.2.3 to add several serious fixes Tom has made to the code in the past few days. Are we too close to 7.3 for this to be worthwhile? Certainly ...
    Bruce MomjianBruce Momjian
    Sep 28, 2002 at 6:36 pm
    Sep 30, 2002 at 6:12 pm
  • Hi, I didn't download the beta but compared the CVS checkouts and it appears the ecpg directory is still the one from 7.2 not the one tagged big_bison. Will this one be moved into the mainstream ...
    Michael MeskesMichael Meskes
    Sep 8, 2002 at 8:20 am
    Sep 13, 2002 at 6:43 am
  • I know everyone is busy with the 7.3beta, but maybe this is something to think of before releasing the beta. Currently VACUUM will vacuum every table, but sometimes it's desireable to leave tables ...
    Mario WeilguniMario Weilguni
    Sep 3, 2002 at 6:53 am
    Sep 4, 2002 at 3:04 pm
  • OK, the HISTORY file is updated, and 7.3 is branded and ready for beta1. I used the same HISTORY categories Peter made in 7.2. I liked them. Please review the HISTORY file. I am sure there are ...
    Bruce MomjianBruce Momjian
    Sep 4, 2002 at 7:25 am
    Sep 4, 2002 at 8:06 pm
  • 19

    Re:

    I guess so. It seems to me that upgrading to 7.3 is going to be the stuff of nightmares, so my first thought is to try to avoid getting people to run a 7.3 utility on their 7.x database. It would be ...
    Dave PageDave Page
    Sep 11, 2002 at 9:20 pm
    Sep 14, 2002 at 4:04 am
  • Hi, any idea what we do with ecpg for the upcoming freeze? Do we use the beta version of bison? If so, do we merge the branch back into main? I just synced the parsers and found one more problem. The ...
    Michael MeskesMichael Meskes
    Sep 1, 2002 at 9:30 am
    Sep 2, 2002 at 9:55 pm
  • Ah. I don't think we've done much of any work on plugging leaks in pltcl :-(. Yeah, I see very quick memory exhaustion also :-(. Looks like the spi_exec call is the culprit, but I'm not sure exactly ...
    Tom LaneTom Lane
    Sep 19, 2002 at 4:18 pm
    Sep 26, 2002 at 5:23 am
  • Rohit Seth recently added support for the use of large TLB pages on Linux if the processor architecture supports them (I believe the SPARC, IA32, and IA64 have hugetlb support, more archs will ...
    Neil ConwayNeil Conway
    Sep 24, 2002 at 2:16 pm
    Sep 30, 2002 at 3:04 am
  • Hi all, It occurs to me that opening web page on www.postgresql.org, asking the user to select the mirror, is rather unprofessional. I am sure this has been discussed before but I thought I would ...
    Gavin SherryGavin Sherry
    Sep 24, 2002 at 3:43 am
    Sep 29, 2002 at 6:51 pm
  • Hi all, Am experimenting to find out what kind of performance gain are achieved from moving indexes to a different scsi drives than the WAL files, than the data itself, etc. Have come across an ...
    Justin CliftJustin Clift
    Sep 28, 2002 at 7:08 am
    Oct 4, 2002 at 2:24 am
  • as best i can understand, there is no way to get apach/php/pgsql configured (using "PostgreSQL's native access mappings") that would disallow php code in one virtual host from connecting to any ...
    Jim MercerJim Mercer
    Sep 27, 2002 at 12:26 am
    Sep 29, 2002 at 12:21 pm
  • Patrick Welche's recent problems (see pgsql-general) point out that the old CREATE CONSTRAINT TRIGGER syntax that optionally omits a "FROM table" clause doesn't work anymore --- the system *needs* ...
    Tom LaneTom Lane
    Sep 26, 2002 at 8:57 pm
    Sep 28, 2002 at 5:04 am
  • The Makefile for contrib/earthdistance indicates that there should be a regression test, but the files seem to be missing from CVS. The change to the Makefile was made here: ...
    Joe ConwayJoe Conway
    Sep 24, 2002 at 5:45 pm
    Sep 25, 2002 at 4:24 pm
  • There is a misfeature in 7.2.2 that appears when I have a foreign key that references two columns of a table. Consider following simplified example: CREATE TABLE a ( a int PRIMARY KEY, b int ); ...
    Antti HaapalaAntti Haapala
    Sep 13, 2002 at 8:18 am
    Sep 14, 2002 at 8:45 pm
  • I am getting errors when doing a checkout, related to Marc's splitting up the CVS tree into modules: C pgsql/contrib/earthdistance/Makefile cvs checkout: move away ...
    Bruce MomjianBruce Momjian
    Sep 25, 2002 at 6:34 pm
    Oct 22, 2002 at 8:04 pm
  • Yesterday I reported a WAL problem that could lead to tuples not being marked as committed-good or committed-dead after we'd already removed the pg_clog segment that had their transaction's commit ...
    Tom LaneTom Lane
    Sep 27, 2002 at 10:40 pm
    Sep 30, 2002 at 9:07 pm
  • 11

    Re:

    Oliver reported: 2. The dump produced: CREATE TABLE cust_alloc_history ( ... "year" integer DEFAULT date_part('year'::text, ('now'::text)::timestamp(6) with time zone) NOT NULL, ... ERROR: Column ...
    Dave PageDave Page
    Sep 12, 2002 at 7:23 am
    Sep 16, 2002 at 1:23 am
  • Hi Oleg/Teodor, I'm sorry to keep posting bugs without patches, but I'm just hoping you guys know the answer faster than I...I know you're busy. What does tsearch have against the word 'herring' (as ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Sep 5, 2002 at 6:35 am
    Sep 9, 2002 at 2:26 pm
  • I'm done making back-patches for 7.2.3. Over to you, Bruce ... attached is the REL7_2_STABLE branch history since 7.2.2. regards, tom lane 2002-09-30 16:57 tgl * src/backend/utils/adt/: date.c, ...
    Tom LaneTom Lane
    Sep 30, 2002 at 9:03 pm
    Oct 7, 2002 at 9:46 pm
  • While adding schema support to the JDBC Driver, I came across a query which occasionally generates some spectacularly bad plans. I have attached the query and explain analyze outputs against today's ...
    Kris JurkaKris Jurka
    Sep 19, 2002 at 10:06 pm
    Oct 3, 2002 at 7:20 pm
  • Anyone else think we should add some more pins to the developer map? At the moment, it looks like we have very few developers! Chris
    Christopher Kings-LynneChristopher Kings-Lynne
    Sep 5, 2002 at 5:10 am
    Sep 9, 2002 at 5:33 pm
  • I have the beginnings of an idea about improving our interlock logic for postmaster startup. The existing method is pretty good, but we have had multiple reports that it can fail during system boot ...
    Tom LaneTom Lane
    Sep 28, 2002 at 4:01 pm
    Oct 5, 2002 at 1:16 am
  • select to_char( to_date( CAST(extract(week from CURRENT_TIMESTAMP) as text) , 'WWYYYY') , 'FMDay, D'); to_char ------------ Tuesday, 3 (1 row) Not that it matters for me at the moment (I care that ...
    Rod TaylorRod Taylor
    Sep 30, 2002 at 9:37 pm
    Oct 1, 2002 at 3:33 pm
  • Hi, I just removed the prepare/execute/deallocate function from ecpg's parser so there are no conflicts anymore. But for the future (that is after 7.3 is released) I'd like to work something out. The ...
    Michael MeskesMichael Meskes
    Sep 20, 2002 at 6:30 am
    Sep 25, 2002 at 8:43 am
  • Hello. I'm just curious as to the 7.3 status of a couple of things: 1. Back in Feb. I wrote (in regards to Oracle behavior): "Unlike normal queries where blocks are added to the MRU end of an LRU ...
    Mike MascariMike Mascari
    Sep 23, 2002 at 3:57 pm
    Sep 23, 2002 at 11:11 pm
  • It seems that my last mail on this did not get through to the list ;( Please consider renaming the new builtin function split(text,text,int) to something else, perhaps split_part(text,text,int) (like ...
    Hannu KrosingHannu Krosing
    Sep 5, 2002 at 6:29 am
    Sep 11, 2002 at 5:07 am
  • Olivier PRENANTOlivier PRENANT
    Sep 4, 2002 at 4:18 pm
    Sep 4, 2002 at 10:17 pm
  • findoidjoins doens't seem to compile: gmake[1]: Entering directory `/home/chriskl/pgsql-head/contrib/findoidjoins' gcc -pipe -O -g -Wall -Wmissing-prototypes -Wmissing-declarations -I../../sr ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Sep 3, 2002 at 6:41 am
    Sep 4, 2002 at 5:17 pm
  • Looks like we got an honourable mention *sigh*: Server Appliance: SnapGear for Lite/Lite+ SOHO Firewall/VPN Client Honorable Mention: Sun Microsystems for Cobalt Qube Security Tool: GPG Web Server: ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Sep 3, 2002 at 1:49 am
    Sep 3, 2002 at 6:18 am
  • I'm trying to get the client utilities to compile under win32/VS.net per http://developer.postgresql.org/docs/postgres/install-win32.html. I was able to do this successfully using the 7.2.2 tarball, ...
    Joe ConwayJoe Conway
    Sep 25, 2002 at 10:06 pm
    Oct 3, 2002 at 5:15 pm
  • Hello All, I have written a small daemon that can automatically vacuum PostgreSQL database, depending upon activity per table. It sits on top of postgres statistics collector. The postgres ...
    Shridhar DaithankarShridhar Daithankar
    Sep 23, 2002 at 1:43 pm
    Sep 25, 2002 at 6:24 am
  • Greetings, As far as I use the txtidx data structure in conjunction with gist indexing to make a word indexing of a very large UNICODE db, I've implemented a PostgreSQL function that uses libunac to ...
    NngodinhNngodinh
    Sep 18, 2002 at 10:14 am
    Sep 19, 2002 at 5:48 pm
Sep 2002
123456
Group Navigation
period‹ prev | Sep 2002 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions251
posts1,816
users149
websitepostgresql.org...
irc#postgresql

149 users for September 2002

Bruce Momjian: 335 posts Tom Lane: 296 posts Christopher Kings-Lynne: 82 posts Peter Eisentraut: 72 posts Marc G. Fournier: 54 posts Hannu Krosing: 46 posts Joe Conway: 43 posts Alvaro Herrera: 40 posts Shridhar Daithankar: 40 posts Justin Clift: 38 posts Curt Sampson: 34 posts Stephan Szabo: 31 posts Rod Taylor: 26 posts Andreas Zeugswetter: 24 posts Jan Wieck: 24 posts Michael Meskes: 23 posts Oliver Elphick: 22 posts Dave Page: 21 posts Neil Conway: 21 posts Steve Howe: 20 posts
show more
Archives