FAQ

Search Discussions

143 discussions - 1,165 posts

  • Yes, it was vague. The question is now that we are a month away, do we want to target June 1, mid-June, or July 1. Some are saying that once Win32 is ready, it will justify a release even if the ...
    Bruce MomjianBruce Momjian
    Apr 29, 2004 at 5:26 pm
    Sep 6, 2005 at 6:54 pm
  • Here is a blog about a recent MySQL conference with title, "Why MySQL Grew So Fast": http://www.oreillynet.com/pub/wlg/4715 and a a Slashdot discussion about it: ...
    Bruce MomjianBruce Momjian
    Apr 23, 2004 at 4:09 am
    Apr 30, 2004 at 6:20 pm
  • Taking into account that quite a few people have repeatedly stated that the components in contrib are considered more supported/recommended than similar solutions found on gborg or any other external ...
    Jan WieckJan Wieck
    Apr 21, 2004 at 5:48 pm
    Apr 26, 2004 at 6:01 pm
  • About a year or two ago I submitted a configuration patch that allowed PostgreSQL to be fully configured by postgresql.conf -- enabling data and configuration to be in separate locations. The idea ...
    Mark L. WoodwardMark L. Woodward
    Apr 8, 2004 at 11:57 am
    Apr 17, 2004 at 5:13 am
  • Hi, I know the issue of pre-fork PostgreSQL has been discussed previously. Someone mentionned pre-fork can be implemented when schemas become available in PostgreSQL because there will be less of the ...
    PrivatePrivate
    Apr 29, 2004 at 6:45 pm
    May 13, 2004 at 1:00 pm
  • Hi! When debugging on win32, I've created myself a little function that I feel should be added to the "backend proper". While it adds a lot of vlaue on win32, I think it adds quite a bit of value on ...
    Magnus HaganderMagnus Hagander
    Apr 2, 2004 at 9:52 pm
    Apr 9, 2004 at 1:53 am
  • A sort of debate started by Bruce about what MySQL does better vs what PostgreSQL could do, then there was a thread about removing "/contrib" from the main download, and a few other posts. I don't ...
    Mark L. WoodwardMark L. Woodward
    Apr 25, 2004 at 9:06 pm
    May 7, 2004 at 6:07 pm
  • Dear hackers, Would it hurt anybody if operator == is made a synonym for operator =? as != is a synonum for < , it would make sense. If it does not hurt, should it be implemented by replicating ...
    Fabien COELHOFabien COELHO
    Apr 7, 2004 at 7:36 am
    Apr 13, 2004 at 8:37 pm
  • Is anyone working to make the locale support in pg better? Running initdb to set the locale is a bit heavy. It would be nice to at least be able to set it per database. -- /Dennis Björklund
    Dennis BjorklundDennis Bjorklund
    Apr 7, 2004 at 11:04 am
    Apr 12, 2004 at 6:08 pm
  • Since Phase1 is functioning and should hopefully soon complete, we can now start thinking about Phase 2: full recovery to a point-in-time. Previous thinking was that a command line switch would be ...
    Simon RiggsSimon Riggs
    Apr 26, 2004 at 4:52 pm
    May 5, 2004 at 7:46 am
  • I've now completed the coding of Phase 1 of PITR. This allows a backup to be recovered and then rolled forward (all the way) on transaction logs. This proves the code and the design works, but also ...
    Simon RiggsSimon Riggs
    Apr 26, 2004 at 3:38 pm
    May 11, 2004 at 9:59 pm
  • OK, but I am worried about giving Win32 special treatment, and having the date float like that until Win32 is done. This is what we did with the SMP fixed in 7.3 and the date slipped week by week. We ...
    Bruce MomjianBruce Momjian
    Apr 30, 2004 at 7:15 pm
    May 2, 2004 at 5:11 am
  • We've had a backend crash with sig 11 during connection. My guess is there's something up with (maybe) the IPv6 support on AIX. I seem to recall something similar recently, but I can't find the post ...
    Andrew SullivanAndrew Sullivan
    Apr 15, 2004 at 5:08 pm
    Oct 7, 2004 at 5:20 pm
  • Here are features that are being worked on, hopefully for 7.5: o tablespaces (Gavin) o nested transactions (Alvaro) o two-phase commit (Heikki Linnakangas) o integrated pg_autovacuum (O'Connor) o ...
    Bruce MomjianBruce Momjian
    Apr 27, 2004 at 1:27 pm
    May 12, 2004 at 11:55 pm
  • Folks, I'm thinking it's time to remove the "MySQL" conversion tools from the PostgreSQL source tree and put them somewhere they might be maintained. I've just done some testing, and neither one ...
    Josh BerkusJosh Berkus
    Apr 13, 2004 at 10:20 pm
    Apr 19, 2004 at 6:05 pm
  • Community, People asked me to put a simple extension for PostgreSQL Open Source. The attached package contains a simple functions whichs tells a remote TCP socket that somebody is about to modify a ...
    Hans-Jürgen SchönigHans-Jürgen Schönig
    Apr 5, 2004 at 11:04 am
    Apr 16, 2004 at 5:36 pm
  • Hi Haim, Is the PostgreSQL license (http://www.postgresql.org/licence.html) LGPL compatible? I have adapted some code (for jdate manipulation) into the OLE DB project (LGPL). I have copied over the ...
    Shachar ShemeshShachar Shemesh
    Apr 22, 2004 at 9:12 am
    Apr 23, 2004 at 9:31 pm
  • Hackers, In current (as of a couple hours ago) clean CVS tip sources, without any of my local changes, I'm getting a postmaster segfault when trying to connect to a non existant database. The ...
    Alvaro HerreraAlvaro Herrera
    Apr 23, 2004 at 10:03 pm
    May 25, 2004 at 10:20 pm
  • Hackers, Is this expected? If so, why? I'd expect the prepared stmt to be deallocated. alvherre=# begin; BEGIN alvherre=# prepare tres as select 3; PREPARE alvherre=# rollback; ROLLBACK alvherre=# ...
    Alvaro HerreraAlvaro Herrera
    Apr 30, 2004 at 7:35 pm
    May 7, 2004 at 6:53 pm
  • Hi I am working on a project in postgres..in which i designed customized data type and operations on it.it requires a look up table.. I have three options regarding this table... 1. Every time a ...
    VinayjVinayj
    Apr 21, 2004 at 4:16 am
    May 7, 2004 at 12:48 pm
  • I looked into this and I see a number of cases where pg_autovacuum calls send_query(), but doesn't test for a NULL return from the function. Matthew, would you look into this and submit a patch? ...
    Bruce MomjianBruce Momjian
    Apr 20, 2004 at 3:25 pm
    Apr 22, 2004 at 6:02 am
  • Dear hackers, It seems to me that the current default setup for a new database which is given to some user is not consistent (createdb -O calvin foo or CREATE DATABASE foo WITH OWNER calvin). Indeed, ...
    Fabien COELHOFabien COELHO
    Apr 30, 2004 at 3:57 pm
    May 6, 2004 at 12:06 pm
  • I am having some trouble interfacing the 7.5 server built with MINGW with tools generated using other compilers. I suspect that the issue is one of default structure packing. In the old version we ...
    Dann CorbitDann Corbit
    Apr 6, 2004 at 12:42 am
    Apr 16, 2004 at 7:42 pm
  • I work at Coverity where we use static analysis to find bugs in software. I ran a security checker over postgresql-7.4.1 and I think I found a security hole. I'm not familiar with the postgres ...
    Ken AshcraftKen Ashcraft
    Apr 20, 2004 at 2:27 am
    May 13, 2004 at 1:15 pm
  • Hi, [Just so y'all know: This has been discussed extensively in #PostgreSQL and I tried asking the question in both -admin and -general, first. Also did some web searching.] Environment: PostgreSQL ...
    Jim SeymourJim Seymour
    Apr 1, 2004 at 9:51 pm
    Apr 3, 2004 at 3:20 pm
  • I would like to suggest changing the symlinks to copy commands: cp ./src/backend/port/tas/dummy.s ./src/backend/port/tas.s cp ./src/backend/port/dynloader/win32.c ./src/backend/port/dynloader.c cp ...
    Dann CorbitDann Corbit
    Apr 6, 2004 at 9:17 pm
    Apr 12, 2004 at 5:38 pm
  • I'm opening a new thread, as the previous one was too nested, and contained too much emotions. I'll start by my understanding of a summary of the thread so far. The solution we are seeking would have ...
    Shachar ShemeshShachar Shemesh
    Apr 25, 2004 at 2:44 pm
    May 13, 2004 at 10:58 pm
  • Dear hackers, still in the spirit of "it may be useful to others, as it was to me, and it does cost very little", and before submitting a small patch and being exploded because it is obviously very ...
    Fabien COELHOFabien COELHO
    Apr 27, 2004 at 4:25 pm
    May 19, 2004 at 1:16 am
  • [sorry for the repost...lists down? Problem may or may not be on win32 version only] The catalog number was updated, so it was time to run initdb. Sometime over the weekend (or since the last initdb ...
    Merlin MoncureMerlin Moncure
    Apr 26, 2004 at 1:46 pm
    Apr 26, 2004 at 8:40 pm
  • I've spent some more time reading specs today. Together with Peter E's explanataion (Thanks!) I think I've got a farily good understanding of the parts talking about locales now. My next question is ...
    Dennis BjorklundDennis Bjorklund
    Apr 13, 2004 at 4:57 pm
    Apr 14, 2004 at 8:36 am
  • I am trying to get version 7.4.2 installed on a Solaris box, but initdb fails because of shmmax being set too low. It does this even though initdb drops shared buffers as low as it can go (50). Is ...
    Greg Sabino MullaneGreg Sabino Mullane
    Apr 4, 2004 at 7:41 pm
    Apr 12, 2004 at 5:15 pm
  • With initdb written now in C, we don't need a pg_encoding binary anymore. I have removed it from CVS. There were no mentions of it in the docs. -- Bruce Momjian | http://candle.pha.pa.us ...
    Bruce MomjianBruce Momjian
    Apr 20, 2004 at 12:41 am
    Apr 23, 2004 at 3:41 am
  • Why is libpgtcl still in /src/interfaces? Isn't it now on gborg? Are there two of them there now? -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is ...
    Bruce MomjianBruce Momjian
    Apr 9, 2004 at 5:39 pm
    Apr 20, 2004 at 2:02 am
  • I'm looking into adding sql standard aggregates EVERY/ANY/SOME. It seems to me that there is a syntax ambiguity with ANY and SOME: CREATE TABLE bla(b BOOL); SELECT TRUE = ANY(b) FROM bla; Is parsed ...
    Fabien COELHOFabien COELHO
    Apr 28, 2004 at 1:21 pm
    May 2, 2004 at 9:13 am
  • Seemingly completely opposite to my usual focus on large scale enterprise issues and requirements, I'm looking into PostgreSQL on small handheld devices. Clearly these have limited memory and little ...
    Simon RiggsSimon Riggs
    Apr 29, 2004 at 10:14 pm
    Apr 30, 2004 at 12:22 pm
  • Valgrind'ing the postmaster yields a fair number of errors. A lot of them are similar, such as the following: ==29929== Use of uninitialised value of size 4 ==29929== at 0x80AFB80: XLogInsert ...
    Neil ConwayNeil Conway
    Apr 21, 2004 at 6:50 pm
    Apr 22, 2004 at 9:33 pm
  • I just tried an experiment that I thought would improve the performance of the PostGIS spatial index. The old way used a BOX (bounding box of 4 doubles) as the key in the index. The new way uses a ...
    David BlasbyDavid Blasby
    Apr 16, 2004 at 6:57 pm
    Apr 19, 2004 at 8:41 pm
  • Does ecpg need to use the same timezone database as the backend? I just committed code so it will not, but I am not sure. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) ...
    Bruce MomjianBruce Momjian
    Apr 30, 2004 at 8:48 pm
    May 2, 2004 at 6:21 pm
  • On -performance we have been discussing a configuration where a bulk delete run takes almost a day (and this is not due to crappy hardware or apparent misconfiguration). Unless I misinterpreted the ...
    Manfred KoizarManfred Koizar
    Apr 25, 2004 at 9:31 pm
    Apr 28, 2004 at 9:14 am
  • Hi, I might have some time left to spend on the item "Allow external interfaces to extend the GUC variable set" filed under "Administration" on the TODO list. I'm thinking of an approach with the ...
    Thomas HallgrenThomas Hallgren
    Apr 19, 2004 at 12:12 pm
    Apr 22, 2004 at 9:43 am
  • [ Discussion moved from patches@ to hackers@ ] The gist of the discussion being: what are the ramifications of having PostgreSQL and psql(1) hide information/schema bits that a user doesn't have ...
    Sean ChittendenSean Chittenden
    Apr 11, 2004 at 9:10 pm
    Apr 12, 2004 at 8:06 pm
  • [time to move this to -hackers] Well, for what I tried to find out my wild guess seems to be wrong. I don't doubt that Vitter's formula is correct, but it assumes that access to any tuple has the ...
    Manfred KoizarManfred Koizar
    Apr 2, 2004 at 6:03 pm
    Apr 3, 2004 at 1:07 am
  • Is it worth us marking any system catalog indexes as clusterable by default for performance? Chris
    Christopher Kings-LynneChristopher Kings-Lynne
    Apr 28, 2004 at 5:58 am
    May 20, 2004 at 2:59 am
  • I read in the manual that the libpq functions PQputline(conn, cmd) and PQendcopy(conn) have been deprecated and that PQputCopyData(conn, cmd, sizeof(cmd)) and PQputCopyEnd(conn, msg) are the ...
    Tony ReinaTony Reina
    Apr 30, 2004 at 1:15 pm
    May 1, 2004 at 12:35 pm
  • I've got a problem with these variables in freelist.c: static int strategy_cdb_found; static int strategy_cdb_replace; static int strategy_get_from; Why are these per-backend? Shouldn't they be in ...
    Tom LaneTom Lane
    Apr 19, 2004 at 4:46 pm
    Apr 19, 2004 at 7:47 pm
  • We run a multithreaded application that uses postgres 7.4 on Linux 2.4.18, dual cpu Xeon processor machine. We have occassional weird crashes and have tried a lot of things to reproduce them in ...
    Prem GopalanPrem Gopalan
    Apr 30, 2004 at 7:45 pm
    Jul 2, 2004 at 11:43 am
  • No check is performed for being a superuser, the table owner or that it is a system table when marking an index for clustering: usa= alter table pg_class cluster on "pg_class_oid_index"; ALTER TABLE ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Apr 28, 2004 at 5:45 am
    Apr 29, 2004 at 7:26 am
  • The thread testing program is not nice to a vpath build. I see this error: checking for gmake... gmake checking thread safety of required library functions... Makefile:13: ...
    Alvaro HerreraAlvaro Herrera
    Apr 26, 2004 at 3:27 pm
    Apr 27, 2004 at 1:46 am
  • This implies that the standard functions are created with explicit quoting to make the lower case named? Shouldn't all functions be created without any quoting so they fold to whichever way the ...
    Robert TreatRobert Treat
    Apr 23, 2004 at 6:13 pm
    Apr 26, 2004 at 5:20 pm
  • [ discussion moved to hackers.] Peter Eisentraut wrote: I considered going this direction, but it broke the WITH clause style of COPY. Previously it was "WITH keyword value". Now it is also "WITH ...
    Bruce MomjianBruce Momjian
    Apr 20, 2004 at 1:22 pm
    Apr 20, 2004 at 3:03 pm
Group Navigation
period‹ prev | Apr 2004 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions143
posts1,165
users144
websitepostgresql.org...
irc#postgresql

144 users for April 2004

Bruce Momjian: 160 posts Tom Lane: 150 posts Andrew Dunstan: 44 posts Fabien COELHO: 40 posts Marc G. Fournier: 40 posts Simon Riggs: 34 posts Alvaro Herrera Munoz: 31 posts Joe Conway: 29 posts Mark L. Woodward: 29 posts Dennis Bjorklund: 28 posts Josh Berkus: 28 posts Peter Eisentraut: 25 posts Shachar Shemesh: 24 posts Christopher Kings-Lynne: 22 posts Magnus Hagander: 21 posts Rod Taylor: 21 posts Jan Wieck: 16 posts Matthew T. O'Connor: 16 posts Robert Treat: 16 posts Scott.marlowe: 16 posts
show more
Archives