FAQ

PostgreSQL > pgsql-hackers > March 2002

Search Discussions

194 discussions - 1,207 posts

  • I have been talking with Bruce Momjian about implementing query timeouts in the JDBC driver. As things stand, you can call setQueryTimeout() or getQueryTimeout(), but a slow query will never actually ...
    Jessica Perry HekmanJessica Perry Hekman
    Mar 29, 2002 at 8:50 pm
    Apr 24, 2002 at 5:04 am
  • I traded a couple emails with a guy using one of my open source projects. To make a long story short, he is going to the new version of MySQL for his website because of the new caching feature. He is ...
    Mark L. WoodwardMark L. Woodward
    Mar 16, 2002 at 2:01 pm
    Apr 14, 2002 at 5:20 pm
  • Now that Bruce has done some work on rationalizing elog() output, seems like we ought to take another look at EXPLAIN VERBOSE. Currently, that command does this: 1. A non-pretty-printed plan dump ...
    Tom LaneTom Lane
    Mar 9, 2002 at 7:09 pm
    Mar 12, 2002 at 4:42 pm
  • In datatype.sgml: The type numeric can store numbers of practically unlimited size and precision,... I think this is simply wrong since the current implementation of numeric and decimal data types ...
    Tatsuo IshiiTatsuo Ishii
    Mar 2, 2002 at 2:15 pm
    Apr 13, 2002 at 4:51 pm
  • From what I read in the recent exchanges in the PostgreSQL vs ORACLE thread it would seem a good idea for the backend to keep track of the number of update performed on a database and after a certain ...
    Nicolas BazinNicolas Bazin
    Mar 5, 2002 at 1:13 am
    Mar 7, 2002 at 3:02 pm
  • As of CVS tip, referential integrity triggers are kinda broken: they will only work for tablenames that are in the current search path. I think that instead of storing just table names in the trigger ...
    Tom LaneTom Lane
    Mar 26, 2002 at 8:32 pm
    Apr 1, 2002 at 6:38 pm
  • Manuel SugawaraManuel Sugawara
    Mar 17, 2002 at 11:14 pm
    Apr 18, 2002 at 4:12 pm
  • Seems like it's about time to release 7.2.1. We have enough post-release patches in there that a dot-release is clearly needed (particularly for the pg_dump-related issues). And it seems like not too ...
    Tom LaneTom Lane
    Mar 8, 2002 at 1:28 am
    Mar 19, 2002 at 2:18 pm
  • I'm trying to use latest version of PostNuke which uses adodb for the database layer. The problem is in the insert and update statements. For example: insert into foo(foo.a) values(1); fails because ...
    Vince VielhaberVince Vielhaber
    Mar 14, 2002 at 12:32 am
    Mar 18, 2002 at 6:49 pm
  • Jeff Davis asked on -general why NOTIFY doesn't take an optional argument, specifying a message that is passed to the listening backend. This feature is supported by Oracle and other databases and I ...
    Neil ConwayNeil Conway
    Mar 22, 2002 at 2:12 am
    Apr 10, 2002 at 1:15 am
  • Just before anyone asks where it is ... I'm just rolling v7.2.1 up right now and will let everyone know once its ready for a download ... I'll do up an announce in the morning unless anyone finds a ...
    Marc G. FournierMarc G. Fournier
    Mar 26, 2002 at 3:38 am
    Apr 4, 2002 at 10:32 am
  • Just curious, and honestly I haven't looked, but is there any form of compression between clients and servers? Has this been looked at? Greg
    Greg CopelandGreg Copeland
    Mar 14, 2002 at 2:43 pm
    Mar 17, 2002 at 5:47 pm
  • But sequences can force WAL record if sequence page LSN is <= than system RedoRecPtr (XLogCtlInsert.RedoRecPtr), ie previously made sequence WAL record is "too old" and would not be played during ...
    Mikheev, VadimMikheev, Vadim
    Mar 13, 2002 at 9:03 pm
    Mar 16, 2002 at 6:03 am
  • I am adding users and groups to pg_hba.conf. The coding is done but I am stuck on a reload issue. As you may know, 7.2 tokenizes pg_hba.conf once, and reads those tokens to test every connection ...
    Bruce MomjianBruce Momjian
    Mar 21, 2002 at 8:36 am
    Mar 27, 2002 at 4:16 pm
  • I just sent in this email and it will appear immediately in the list. Somewhat earlier, I have submitted a 25kb patch and then a 5kb gzipped version of that patch to -hackers and -patches - it has ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Mar 27, 2002 at 7:17 am
    Mar 29, 2002 at 2:29 pm
  • As PostgreSQL uses the zlib library (for TOAST?), this is a headsup that a bug has been found in the zlib library that could cause data corruption or a security breach. See ...
    Lamar OwenLamar Owen
    Mar 12, 2002 at 4:05 pm
    Mar 13, 2002 at 8:02 pm
  • Current CVS of postgres is completely broken. initdb fails with SIG11 during the 'creation of template1' --debug doesn't show anything being written. Several regression tests have postmaster ...
    Rod TaylorRod Taylor
    Mar 6, 2002 at 4:40 pm
    Mar 8, 2002 at 12:51 am
  • Hi Bruce, Now that I look at this patch again I don't think I like the syntax. COPY [BINARY] <relation [WITH OIDS] TO | FROM <file [[USING DELIMITERS | WITH DELIMITER] <delimiter [WITH NULL AS <char ...
    Gavin SherryGavin Sherry
    Mar 5, 2002 at 10:18 am
    Apr 16, 2002 at 11:55 pm
  • Autoconf 2.53 was just released, and I'd like us to upgrade to this release in the next few weeks. Compared to 2.13, there are tons of new features in this release that will make our lives easier. ...
    Peter EisentrautPeter Eisentraut
    Mar 11, 2002 at 4:20 am
    Mar 27, 2002 at 1:40 am
  • Dear Tom, The evidence is from the Process Activity Recorder, an Irix utility similar to strace the reports syscall usage. A number of semop's are performed in the operation of backend. Luis can send ...
    Robert E. BruccoleriRobert E. Bruccoleri
    Mar 18, 2002 at 8:59 pm
    Mar 22, 2002 at 6:32 pm
  • I truely don't know what I did to create the nasty patch (source file certainly didn't look like what it resulted in) -- then again there have been alot of changes since the domain patch was created. ...
    Rod TaylorRod Taylor
    Mar 19, 2002 at 12:35 pm
    Mar 20, 2002 at 8:25 pm
  • We have the following TODO item: * Allow usernames to be specified directly in pg_hba.conf (Bruce) My idea is to allow comma-separated usernames in the AUTH_ARGUMENT column. Right now we use it for ...
    Bruce MomjianBruce Momjian
    Mar 10, 2002 at 6:20 am
    Mar 14, 2002 at 9:33 pm
  • Currently we have a rather confusing mismash of behaviors for the names of rules, constraints, and triggers. I'd like to unify the rules so that these objects all have the same naming behavior; and ...
    Tom LaneTom Lane
    Mar 4, 2002 at 7:24 pm
    Mar 11, 2002 at 1:37 am
  • The archives search is not working on postgresql.org so I need to ask this question... We are using postgresql 7.2 and when dumping one of our larger databases, we get the following error: File size ...
    Laurette CisnerosLaurette Cisneros
    Mar 29, 2002 at 12:29 am
    Mar 29, 2002 at 7:05 pm
  • hi all i'm working with pg7.2 on irix6.5 platform and i've realized that postgres is using semop instead of tas, pg_config_os.h has define HAVE_TEST_AND_SET, and i don't kwow where could be the ...
    Luis Alberto Amigo NavarroLuis Alberto Amigo Navarro
    Mar 18, 2002 at 10:48 am
    Mar 20, 2002 at 9:15 am
  • Okay folks, time to put on your language-lawyer hats ... I have been trying to puzzle out the SQL rules concerning whether two FROM items conflict in the presence of schemas. It is entirely clear ...
    Tom LaneTom Lane
    Mar 8, 2002 at 10:00 pm
    Mar 11, 2002 at 9:17 pm
  • we're running on sgi powerchallenge, 8 r10000 4-way smp, and we're getting bad performance from postgres, throughput increases from 1 to 5 streams, but from 5 and above there is no further increase, ...
    Luis Alberto Amigo NavarroLuis Alberto Amigo Navarro
    Mar 12, 2002 at 5:42 pm
    Mar 25, 2002 at 3:28 pm
  • Understood. It's the best that I had on me. I've not found a cheap resource for the real one. Ie. priced suitably to fit a hobby project :)
    Rod TaylorRod Taylor
    Mar 21, 2002 at 3:42 pm
    Apr 17, 2002 at 5:16 am
  • Hi all, Here are the results of our survey on a migration from Oracle 8.0 / W$ NT4 SP5 to PostgreSQL 7.2 / Red Hat 7.2. You'll probably remember of a thread I initiated in this list a couple of weeks ...
    Jean-Paul ARGUDOJean-Paul ARGUDO
    Mar 13, 2002 at 4:19 pm
    Mar 15, 2002 at 10:33 am
  • I don't think this is me... gcc -pipe -O -Wall -Wmissing-prototypes -Wmissing-declarations -Wno-error -I ./../include -I. -I../../../../src/include -DMAJOR_VERSION=2 -DMINOR_VERSIO N=10 ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Mar 27, 2002 at 5:24 am
    Apr 18, 2002 at 1:41 am
  • The DOMAIN patch is completely broken when it comes to type coercion behavior. For one thing, it doesn't know that any operators or functions on a domain's base type can be used with a domain: ...
    Tom LaneTom Lane
    Mar 19, 2002 at 9:14 pm
    Mar 21, 2002 at 10:46 pm
  • Is there an easy way to test the lock on a user level lock without actually issuing the lock? I would like to use them, but there is only a LockAcquire() and LockRelease().. There is no LockTest().. ...
    Lance EllinghausLance Ellinghaus
    Mar 15, 2002 at 6:40 am
    Mar 17, 2002 at 11:34 pm
  • Hi, It seems that the Linux kernel will very shortly acquire a lightweight userlevel locking primitive (called futexes), thanks primarily to Rusty and Hubertus. It looks to be very useful for the ...
    Matthew KirkwoodMatthew Kirkwood
    Mar 12, 2002 at 9:25 pm
    Mar 13, 2002 at 4:40 am
  • Hi all, Is there a reason why the reltuples column of pg_class is stored as a "real", rather than one of the integer data types? Are there any situations in which there will be a non-integer value ...
    Neil ConwayNeil Conway
    Mar 7, 2002 at 10:02 pm
    Mar 8, 2002 at 4:02 am
  • Sorry for the package, but the following patch need to be applied to get the new verion compiled on SCO Openserver 5.0.5 and Unixware 7.1.1
    Nicolas BazinNicolas Bazin
    Mar 26, 2002 at 6:22 am
    Apr 24, 2002 at 1:58 am
  • If I do this as any user: SELECT update_pg_pwd(); it crashes all backends and causes a server-wide restart. Is this acceptable behavior? I am sure there are other cases too. Isn't it a problem that ...
    Bruce MomjianBruce Momjian
    Mar 21, 2002 at 2:46 am
    Mar 21, 2002 at 4:19 pm
  • I'm looking through the index code and just happened to notice that INDEX_MAX_KEYS is currently set to 16. It there a reason for this value to be at 16 or was it arbitrarily specified? Curious, Greg
    Greg CopelandGreg Copeland
    Mar 10, 2002 at 5:13 pm
    Mar 11, 2002 at 11:00 pm
  • The following patch supresses "USING btree" for btree indexes in pg_dump: CREATE INDEX ii ON test (x); CREATE INDEX kkas ON test USING hash (x); This is possible because btree is the default. TODO ...
    Bruce MomjianBruce Momjian
    Mar 8, 2002 at 4:51 am
    Mar 10, 2002 at 6:01 am
  • If we're going to change the structure anyway, let's fix it to be independent of NAMEDATALEN. Instead of char relname[NAMEDATALEN]; int be_pid; let's do char *relname; int be_pid; This should require ...
    Tom LaneTom Lane
    Mar 20, 2002 at 9:10 pm
    Apr 15, 2002 at 11:36 pm
  • I've a severe problem with deadlocks in postgres, when using referential integrity it's quite easy to trigger deadlocks. I think the may be a bug in ri_trigger.c (discussed later). Here's some short ...
    Mario WeilguniMario Weilguni
    Mar 28, 2002 at 2:44 pm
    Mar 28, 2002 at 9:58 pm
  • (posted last week to pgsql-general; no responses there, so I'm seeing if anyone here can contribute. Thanks!) I'm working on a site hosted in a BSD Jail; they have MySQL installed but, of course, I'd ...
    Joel BurtonJoel Burton
    Mar 25, 2002 at 3:51 pm
    Mar 27, 2002 at 10:56 am
  • 6

    XML

    Do U know if pgSQL supports XML ? 4 example : BROWSER- APACHE JSERV- SERVLET- DB- xsl+xml- HTML Do U know any open source DB doing that? Thanks a lot
    LongjohnLongjohn
    Mar 15, 2002 at 2:06 pm
    Mar 20, 2002 at 7:18 pm
  • Hello Group, I need your help, in putting together a list of comparisons, and good solid technical reasons, to why to use PostgreSQL over using Microsoft SQL Server. Right now, we are using ...
    Dale AndersonDale Anderson
    Mar 18, 2002 at 9:54 pm
    Mar 19, 2002 at 3:40 pm
  • I have been unable to successfully search the mailing list archives off of archives.postgresql.org for a few days now. Just me, or does anyone else experience this behaviour as well? Gavin
    Gavin SherryGavin Sherry
    Mar 13, 2002 at 2:28 pm
    Mar 14, 2002 at 1:51 am
  • I think you all should really buy the book 'Database Development for Dummies'. Postgresql is for sure the only database on this planet that cannot optimize a select(max) using an index. Not even ...
    Thomas ZehetbauerThomas Zehetbauer
    Mar 7, 2002 at 4:04 pm
    Mar 13, 2002 at 9:39 pm
  • OK, I've committed a patch to the stable and development trees which adds a guard check in three places in gram.y, matching the guards already in place for other cass in the same area. Fernando, can ...
    Thomas LockhartThomas Lockhart
    Mar 9, 2002 at 5:47 pm
    Mar 10, 2002 at 12:28 am
  • I am building/testing the current cvs sources on a Red Hat Linux 7.2 machine and today I am seeing several failures (it was OK yesterday). The test that actually crashes the backend is ...
    Fernando NasserFernando Nasser
    Mar 7, 2002 at 3:26 pm
    Mar 7, 2002 at 8:20 pm
  • We're using a function to insert some information into the database. This information is later (within seconds) retrieved from a program, that does the actual processing of the information. It is ...
    Turbo FredrikssonTurbo Fredriksson
    Mar 6, 2002 at 8:19 am
    Mar 7, 2002 at 8:41 am
  • I've got patches to enable storage of date/time values as integers rather than as floating point numbers, as discussed earlier. 64-bit integers are (afaik) not available on every platform we want to ...
    Thomas LockhartThomas Lockhart
    Mar 24, 2002 at 5:58 pm
    Mar 26, 2002 at 5:54 pm
  • At Tom Lane's suggestion, I am adding a field to pg_control to hold the compile-time configuration of timestamp and time storage. I notice that the compile-time locale settings are registered in that ...
    Thomas LockhartThomas Lockhart
    Mar 22, 2002 at 3:24 pm
    Mar 25, 2002 at 6:35 pm
Mar 2002
1234
Group Navigation
period‹ prev | Mar 2002 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions194
posts1,207
users149
websitepostgresql.org...
irc#postgresql

149 users for March 2002

Bruce Momjian: 202 posts Tom Lane: 184 posts Peter Eisentraut: 56 posts Christopher Kings-Lynne: 46 posts Greg Copeland: 39 posts Rod Taylor: 39 posts Neil Conway: 35 posts Mark L. Woodward: 32 posts Thomas Lockhart: 32 posts Luis Amigo: 30 posts Jan Wieck: 21 posts Andreas Zeugswetter: 20 posts Fernando Nasser: 20 posts Thomas Lockhart: 18 posts Nicolas Bazin: 16 posts Vince Vielhaber: 16 posts Tatsuo Ishii: 15 posts Oleg Bartunov: 13 posts Stephan Szabo: 13 posts Doug McNaught: 12 posts
show more
Archives