FAQ

PostgreSQL > pgsql-hackers > August 2003

Search Discussions

227 discussions - 1,343 posts

  • What is the state of things regarding having to use massive strings of quotes like this (taken from the 7.3 docs)?: a_output := a_output || '' if v_'' || referrer_keys.kind || '' like '''''''''' then ...
    Andrew DunstanAndrew Dunstan
    Aug 28, 2003 at 6:17 pm
    Sep 16, 2003 at 7:50 pm
  • Hi, As the 7.4 beta rolls on, I thought now would be a good time to start talking about the future. I have a potential need in the future for distributed transactions (XA). To get that from Postgres, ...
    Andrew SullivanAndrew Sullivan
    Aug 26, 2003 at 9:56 pm
    Oct 25, 2003 at 1:25 pm
  • Everything looks like it built clean ... will do a quick, more general announce tomorrow, but if someone can confirm that things are good, that would be great ...
    Marc G. FournierMarc G. Fournier
    Aug 27, 2003 at 3:21 am
    Sep 13, 2003 at 2:49 pm
  • Yes, in practice, you'd have to put IS NOT NULL checks in the subselect, which is fine for the two match types we support since a referenced row with a NULL isn't a choice for a referenced row for ...
    Stephan SzaboStephan Szabo
    Aug 15, 2003 at 2:59 pm
    Oct 9, 2003 at 2:44 am
  • Here are the changes for 7.4. I am looking for any improvements. This will be adjusted as we move through beta. I need to work on the other sections of a major release, like a compatibility section. ...
    Bruce MomjianBruce Momjian
    Aug 3, 2003 at 11:30 pm
    Aug 7, 2003 at 2:13 pm
  • Hi every one, I've tried to reindex one of my customer's table to gain some disk space. I had to stop after 90 m cpu... I've then pg_dump'ed the database and recreate an other both on 7.3.4 and 7.4b ...
    OhpOhp
    Aug 28, 2003 at 12:42 pm
    Mar 17, 2004 at 5:02 pm
  • I did some basic profiling of CVS HEAD after having read Bruce's post the other day: When did we get so fast. It seemed to me that the number of inserts per second wasn't actually all that high so I ...
    Gavin SherryGavin Sherry
    Aug 12, 2003 at 1:05 am
    Aug 25, 2003 at 4:12 am
  • I received this from a friend: Lance Rushing wrote: This is a 7.3.3 installation on Red Hat (9 I think). I don't have any more detail yet on exactly what he was doing at this point, but I grabbed a ...
    Joe ConwayJoe Conway
    Aug 30, 2003 at 5:32 pm
    Sep 5, 2003 at 4:58 pm
  • [ Beta discussion moved to hackers.] Peter Childs wrote: There will be a lost of config name and other changes in a special section soon. Rolling backups should be in 7.5, I hope. -- Bruce Momjian | ...
    Bruce MomjianBruce Momjian
    Aug 14, 2003 at 10:13 pm
    Aug 16, 2003 at 4:29 am
  • Just wondering, what other databases has transactable DDLs? oracle seems to have autonomous transactions which is arthogonal. If we are going to compare it, we are going to need it against other ...
    Shridhar DaithankarShridhar Daithankar
    Aug 21, 2003 at 10:10 am
    Aug 24, 2003 at 11:22 pm
  • This is a spill over from some discussions on some of the FreeBSD mailing lists about FS performance. After FreeBSD 4.5-RELEASE, the file system block size was bumped from 8K to 16K. Right now, ...
    Sean ChittendenSean Chittenden
    Aug 28, 2003 at 7:21 pm
    Aug 30, 2003 at 3:55 pm
  • (Responding to the deafening silence regarding my posts a couple of days ago about logging dbnames and disconnections) ;-) The dbname patch is now done. If nobody objects to the format ...
    Andrew DunstanAndrew Dunstan
    Aug 5, 2003 at 4:19 pm
    Aug 6, 2003 at 1:30 am
  • Hi! Would it be possible to implement a "truncate all" that purges all tuples from *all* tables, without taking account any rules or triggers, but leaving all table structures and rules, triggers, ...
    AndreasAndreas
    Aug 4, 2003 at 9:25 am
    Aug 24, 2003 at 10:59 pm
  • I am marking the completed TODO items. Are these done? * Have standalone backend read postgresql.conf * Prevent whole-row references from leaking memory, e.g. SELECT COUNT(tab.*) * Use index to ...
    Bruce MomjianBruce Momjian
    Aug 8, 2003 at 2:01 am
    Aug 13, 2003 at 12:53 am
  • Seems we have a problem with pooled connections and WITH HOLD cursors. We have code to reset transaction state and variables via RESET ALL, but how do we remove WITH HOLD cursors when we pass a ...
    Bruce MomjianBruce Momjian
    Aug 8, 2003 at 5:36 pm
    Aug 17, 2003 at 4:44 am
  • Hi, I dropped the owner of a table (with no complaints), and now I get this: psql: asdf=# \dt List of relations Schema | Name | Type | Owner --------+------+-------+------------ public | a1 | table | ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Aug 11, 2003 at 2:07 am
    Aug 12, 2003 at 6:57 pm
  • I definitely don't want pg_dump using the pretty-print stuff ;-). I'm neutral on whether to use it in psql's \d commands. regards, tom lane
    Tom LaneTom Lane
    Aug 7, 2003 at 3:18 pm
    Aug 12, 2003 at 3:22 pm
  • Hi Tom, Hi Larry After updating from cvs I'm going a little further. But still have problems: UX:acomp: ERROR: "fe-protocol3.c", line 1402: internal compiler error: can't deal with op BMOVE gmake[3]: ...
    OhpOhp
    Aug 7, 2003 at 5:10 pm
    Aug 8, 2003 at 8:07 pm
  • Well, let's see what additional functionality we need. I am not feeling too friendly on SCO/Unixware right now to jump through hoops. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us ...
    Bruce MomjianBruce Momjian
    Aug 4, 2003 at 5:20 pm
    Aug 7, 2003 at 12:13 am
  • I have done some beta testing with PostgreSQL 7.4beta2. I have run a simple set of SQL statements 1 million times: -- START TRANSACTION ISOLATION LEVEL READ COMMITTED; INSERT INTO t_data (data) ...
    Hans-Jürgen SchönigHans-Jürgen Schönig
    Aug 30, 2003 at 12:09 pm
    Sep 10, 2003 at 3:53 pm
  • Hi, I've just tried the cvs on uw 7.13. It fails on compiling hba.c: UX:acomp: ERROR: "hba.c", line 651: undefined symbol: AI_NUMERICHOST UX:acomp: ERROR: "hba.c", line 1237: undefined symbol: ...
    OhpOhp
    Aug 7, 2003 at 12:43 pm
    Aug 14, 2003 at 7:15 pm
  • FarewellIt's time for formal acknowledgement that I'm not in The Project any more. I'm not interested in small features/fixes and have no time for big ones. It was this way for very long time and I ...
    Vadim MikheevVadim Mikheev
    Aug 11, 2003 at 4:35 am
    Aug 12, 2003 at 5:35 pm
  • Will it be possible to tell a PostgreSQL back end to use *only* the new version of the FE/BE protocol? That is, will it be possible to set up a database that will reject connection attempts that do ...
    Bruce BadgerBruce Badger
    Aug 29, 2003 at 12:32 am
    Sep 4, 2003 at 4:11 pm
  • Umm.. What does FSM does then? I was under impression that FSM stores page pointers and vacuum work on FSM information only. In that case, it wouldn't have to waste time to find out which pages to ...
    Shridhar DaithankarShridhar Daithankar
    Aug 22, 2003 at 10:56 am
    Aug 22, 2003 at 5:20 pm
  • Hackers, I've been searching the archives, but I can't find the thread from last month where we discussed the problem with Linux memory overcommits in kernel 2.4.x. Can someone point me to the right ...
    Josh BerkusJosh Berkus
    Aug 20, 2003 at 6:04 pm
    Aug 21, 2003 at 7:24 pm
  • (Not sure if hackers is the right place for this, but I'm not subscribed to all the lists!) The distributed 7.3.4 RPMs for RH 7.3 require libcrypto.so.3 and libssl.so.3, but there does not appear to ...
    Andrew DunstanAndrew Dunstan
    Aug 4, 2003 at 3:40 pm
    Aug 5, 2003 at 2:48 pm
  • Hi, I notice on the SET CONSTRAINTS doc page, it says SET CONSTRAINTS <constraint ... But it doesn't at all make it clear what <constraint is, since cosntraint names are per-relation I thought? Chris
    Christopher Kings-LynneChristopher Kings-Lynne
    Aug 13, 2003 at 5:40 am
    Sep 5, 2003 at 1:10 am
  • Can someone explain in succinct and general terms what the difference between a NOTICE and a WARNING is? I'm currently examining the validity of notice and warning messages throughout the backend, ...
    Peter EisentrautPeter Eisentraut
    Aug 25, 2003 at 6:37 pm
    Sep 3, 2003 at 10:45 pm
  • Greg StarkGreg Stark
    Aug 22, 2003 at 10:16 pm
    Aug 24, 2003 at 8:32 pm
  • I notice you can use the 'DROP TYPE' syntax to drop a domain. Should that be allowed? Chris
    Christopher Kings-LynneChristopher Kings-Lynne
    Aug 4, 2003 at 5:18 am
    Aug 17, 2003 at 4:28 am
  • This is the situation, I create a user called " test=# create user """"; CREATE USER test=# drop user """"; DROP USER test=# create user """"; CREATE USER test=# create table temp(a int4); CREATE ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Aug 8, 2003 at 8:27 am
    Aug 14, 2003 at 9:56 pm
  • Hi all, I found this code on the file variables.c and in the function SetVariable I read: if (strcmp(current- name, name) == 0) { free(current- value); current- value = strdup(value); return current- ...
    Mendola GaetanoMendola Gaetano
    Aug 27, 2003 at 2:59 pm
    Sep 1, 2003 at 10:37 pm
  • Hi all, I noticed that some date are not anymore accepted: Postgres 7.3.3: test=# select '18/03/71'::date; date ------------ 1971-03-18 (1 row) Postgres 7.4beta1: test=# select '18/03/71'::date; ...
    Mendola GaetanoMendola Gaetano
    Aug 26, 2003 at 3:39 pm
    Aug 30, 2003 at 9:35 pm
  • Hi all, the following code was working properly under Postgres 7.3.X I'm now running my regression test with Postgres 7.4beta1 and I'm having the error in subj. CREATE TABLE test ( a integer, b ...
    Gaetano MendolaGaetano Mendola
    Aug 8, 2003 at 1:36 am
    Aug 8, 2003 at 7:22 pm
  • Hi all, Following is from Documentation/vm/overcommit-accounting ------------- 2 - (NEW) strict overcommit. The total address space commit for the system is not permitted to exceed swap + a ...
    Shridhar DaithankarShridhar Daithankar
    Aug 28, 2003 at 10:42 am
    Sep 1, 2003 at 2:40 am
  • I did some profiling and soon realized that the main problem is the executor's trick for not returning the same row multiple times in a multiple-indexscan plan node. The point is that given WHERE a = ...
    Tom LaneTom Lane
    Aug 21, 2003 at 8:42 pm
    Aug 24, 2003 at 9:37 pm
  • following is taken from postgresql-7.3.2/src/backend/storage/lmgr/readme: "If we are setting a table level lock both the blockId and tupleId (in an item pointer this is called the position) are set ...
    Jenny -Jenny -
    Aug 5, 2003 at 6:47 pm
    Oct 6, 2003 at 2:44 am
  • I've always wanted to be a PoatgreSQL hacker, and I am going to try this change out first. Bruce said that it's kind of low on the priority list, so hopefully I won't be holding anyone up if I take a ...
    Jonathan GardnerJonathan Gardner
    Aug 30, 2003 at 3:33 pm
    Aug 30, 2003 at 11:12 pm
  • So where are the new array functions and syntaces documented? Specifically I want to know how to replace my int_array_aggregate(int) and int_array_enum(_int) calls. And how to replace my "arr *= n" ...
    Greg StarkGreg Stark
    Aug 28, 2003 at 5:13 pm
    Aug 28, 2003 at 11:04 pm
  • Thanks to Tom and Bruce, we can now compile CVS 7.4 on UnixWare with OUT any tweaks, including the --enable-thread-safety switch. Here is what I used, and is now running on lerami: CC=cc CXX=CC ...
    Larry RosenmanLarry Rosenman
    Aug 15, 2003 at 3:23 am
    Aug 25, 2003 at 4:04 am
  • Hey, Just wondering if there is currently any mechanism in the contrib makefile hierarchy for installing header files into an appropriate directory. I didn't find anything. I'm using PGSphere ...
    Robert CreagerRobert Creager
    Aug 23, 2003 at 4:18 am
    Aug 24, 2003 at 9:27 pm
  • (Thought triggered by something Tom said the other day) Is this a security hole? Looks like one to me. Would it be better to use a sequence generator for sysids instead of using max+1 on the user ...
    Andrew DunstanAndrew Dunstan
    Aug 12, 2003 at 2:37 pm
    Aug 13, 2003 at 4:52 pm
  • SuSE 7.3, PostgreSQL cvshead (7.4) This is as far as I've gotten with 7.4. It is built and configured like my 7.3 installation on the same machine. I have built from CVS previously. And the ...
    EleinElein
    Aug 11, 2003 at 3:11 am
    Aug 11, 2003 at 9:46 pm
  • I've been thinking about Ludwig Lim's recent report of a "stuck spinlock" failure on a heavily loaded machine. Although I originally found this hard to believe, there is a scenario which makes it ...
    Tom LaneTom Lane
    Aug 5, 2003 at 8:11 pm
    Aug 6, 2003 at 4:56 pm
  • Is it intended that libpq is always compiled with the so-called "thread-safe" compiler option, regardless of whether I used --enable-thread-thing? -- Peter Eisentraut peter_e@gmx.net
    Peter EisentrautPeter Eisentraut
    Aug 4, 2003 at 1:29 pm
    Aug 4, 2003 at 5:13 pm
  • Hi, My name is Markus Kräutner, I am using PostgreSQL to build a distributed biological database as part of my diploma thesis. I hope this is the right forum for my question. At the end of several ...
    Markus KräutnerMarkus Kräutner
    Aug 27, 2003 at 7:20 pm
    Aug 28, 2003 at 1:58 pm
  • Can we modify pg_dumpall (or pg_dump?) to include a \pset pager off to prevent the setval() calls from halting an interactive \i of the dump file? Thanks, LER -- Larry Rosenman ...
    Larry RosenmanLarry Rosenman
    Aug 11, 2003 at 5:39 pm
    Aug 14, 2003 at 7:13 pm
  • I've noticed that when the stats are wrong (like in cases where you've loaded data but reltuples hasn't been updated yet) that a hashed NOT IN seems to take a significant time penalty. Is this to be ...
    Stephan SzaboStephan Szabo
    Aug 17, 2003 at 3:39 am
    Aug 19, 2003 at 1:44 am
  • I appear to have a hang on my system (40 minutes so far, it's now 17:40). The code is from CVS updated 8/6 if I remember correctly. The machine is idle, with a vacuum waiting and an INSERT doing ...
    Robert CreagerRobert Creager
    Aug 9, 2003 at 11:49 pm
    Aug 10, 2003 at 7:51 pm
  • Guys, I've been testing 7.4 against an application today. Recompiled everything against the new libraries. However the application includes code which builds up a bulkload file in the documented 7.1 ...
    Lee KindnessLee Kindness
    Aug 1, 2003 at 3:12 pm
    Aug 5, 2003 at 1:29 pm
Aug 2003
12345
Group Navigation
period‹ prev | Aug 2003 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions227
posts1,343
users129
websitepostgresql.org...
irc#postgresql

129 users for August 2003

Tom Lane: 277 posts Bruce Momjian: 164 posts Larry Rosenman: 75 posts Christopher Kings-Lynne: 67 posts Andrew Dunstan: 65 posts Peter Eisentraut: 42 posts Stephan Szabo: 39 posts Joe Conway: 37 posts Rod Taylor: 36 posts Andreas Pflug: 34 posts Josh Berkus: 22 posts Marc G. Fournier: 21 posts Mendola Gaetano: 21 posts Ohp: 19 posts Shridhar Daithankar: 19 posts Manfred Koizar: 16 posts Jenny -: 15 posts Neil Conway: 15 posts Robert Treat: 15 posts Lee Kindness: 14 posts
show more
Archives