Search Discussions

260 discussions - 1,450 posts

  • I have about 20 open 7.1 items that I need to get resolved before I can start getting the doc TODO list started. The issues relate to JDBC, ODBC, and lots of other stuff that need to be settled ...
    Bruce MomjianBruce Momjian
    Jan 24, 2001 at 5:28 am
    Feb 23, 2001 at 1:53 am
  • The 'tmpwatch' program on Red Hat will remove the /tmp/.s.PGSQL.5432.lock file after the server has run 6 days. This will be a problem. We could touch (open) the file once every time the ServerLoop() ...
    Peter EisentrautPeter Eisentraut
    Jan 26, 2001 at 8:09 pm
    Jan 29, 2001 at 4:44 pm
  • I think featureism is the the most prominent argument for PostgreSQL. Thus standing before a decision to eighter fix GiST bugs and risc a new bug (limited to GiST) because of an added feature or ...
    Andreas ZeugswetterAndreas Zeugswetter
    Jan 11, 2001 at 10:25 am
    Jan 24, 2001 at 3:41 am
  • Just because you're paranoid doesn't mean someone isn't out to get you! But like Tom says - a beta in the name - should do it (and will for me). Lamar, Is it possible to put some variables in the ...
    Roderick A. AndersonRoderick A. Anderson
    Jan 6, 2001 at 4:06 pm
    Jan 14, 2001 at 2:37 am
  • Hi, Does anyone seen this on PostgreSQL 7.0.3????? FATAL: s_lock(401f7435) at bufmgr.c:2350, stuck spinlock. Aborting. FATAL: s_lock(401f7435) at bufmgr.c:2350, stuck spinlock. Aborting. Server ...
    Denis PerchineDenis Perchine
    Jan 7, 2001 at 9:36 am
    Jan 9, 2001 at 9:40 pm
  • 24


    This seems to protect against some partial writes, but see below. External agents include RAM bit drops and noise on cables when blocks are (read and re-) written. Every time data is moved, there is ...
    Nathan MyersNathan Myers
    Jan 12, 2001 at 8:35 pm
    Jan 16, 2001 at 7:36 pm
  • Ok, I have a first set of 7.1beta3 RPMs uploading now. These RPMs pass regression on my home RedHat 6.2 machine, which has all locale environment variables disabled (/etc/sysconfig/i18n deleted and a ...
    Lamar OwenLamar Owen
    Jan 15, 2001 at 7:16 am
    Jan 16, 2001 at 4:37 pm
  • Mark, we prepared new version of contrib-intarray - index support for 1-D integer arrays using GiST. Changes: - Improved regression test - Current implementation provides index support for ...
    Oleg BartunovOleg Bartunov
    Jan 25, 2001 at 4:32 pm
    Mar 20, 2001 at 4:16 am
  • [ . . . ] The installation by simply running configure, make, make install went completely smoothly, no hassle whatsoever (except for the flex-is-not-present warning which I think you can ignore)! ...
    Frank JoerdensFrank Joerdens
    Jan 24, 2001 at 8:54 pm
    Jan 29, 2001 at 8:41 am
  • I have just finished trudging through a bunch of code and trying to make it secure against being interrupted by die() at arbitrary instants. However, I am under no illusion that I have succeeded in ...
    Tom LaneTom Lane
    Jan 12, 2001 at 10:01 pm
    Jan 17, 2001 at 11:55 pm
  • The tz db is neighter damaged nor missing anything (see below). Only mktime does not work for some (maybe even avoidable) reason for dates before 1970. As I see it, the Linux results are also not 100 ...
    Andreas ZeugswetterAndreas Zeugswetter
    Jan 11, 2001 at 9:05 am
    Jan 22, 2001 at 11:17 am
  • Seems this one got lost along the way somewhere. At least, I didn't get it back... Trying a resend. //Magnus
    Magnus HaganderMagnus Hagander
    Jan 22, 2001 at 8:45 am
    Jan 25, 2001 at 12:01 am
  • We should not only support access to all db's under one postmaster, but also remote access to other postmaster's databases. All biggie db's allow this in one way or another (synonyms, qualified ...
    Andreas ZeugswetterAndreas Zeugswetter
    Jan 22, 2001 at 4:01 pm
    Jan 25, 2001 at 3:37 am
  • Hello, I've selected postgresql 7.0.3 for our (critical) application and while doing my first experiments I've found a bug which makes me worry very much. The problem is that a SELECT with a certain ...
    Rob van NieuwkerkRob van Nieuwkerk
    Jan 18, 2001 at 7:51 pm
    Jan 20, 2001 at 1:13 am
  • In looking at the VAX ASM problem, I realized that the ASM in s_lock.h is all formatted differently, making it even more confusing. I have applied the following patch to s_lock.h to try and clean it ...
    Bruce MomjianBruce Momjian
    Jan 19, 2001 at 2:58 am
    Jan 19, 2001 at 8:44 pm
  • Contrary to what the submitted documentation claims, there is no permission checking done on the CHECKPOINT command. Should there be? Btw., is there any normal usage application of this command? This ...
    Peter EisentrautPeter Eisentraut
    Jan 24, 2001 at 9:55 pm
    Jan 27, 2001 at 4:28 am
  • What I do not understand is, that I thought a time in december cannot be affected by such math because it is clearly not in the daylight savings months of the year ? Also I thought that you recognize ...
    Andreas ZeugswetterAndreas Zeugswetter
    Jan 9, 2001 at 4:44 pm
    Jan 12, 2001 at 5:35 pm
  • I am a Comp. Sci. student at Ryerson Polytechnic University in toronto. I am in the midst of a software engineering project that involves the development of a (possibly) relational database on a ...
    Cameron LairdCameron Laird
    Jan 23, 2001 at 6:58 am
    Jan 24, 2001 at 4:26 pm
  • Hello i don't know, whether it is a real bug or what, has been fixed or not, but i can't find any info about it: i try to fill my table from a file using copy from stdin and postgresql corrupt the ...
    Rehak TamasRehak Tamas
    Jan 15, 2001 at 12:34 am
    Jan 18, 2001 at 10:27 pm
  • Has anyone ever thought of asking the FreeBSD folks for their CVS COmmit message generator? They generate ONE message with more info in it for multi-directory commits than we do with ours. Thanks... ...
    Larry RosenmanLarry Rosenman
    Jan 12, 2001 at 9:58 pm
    Jan 13, 2001 at 3:23 am
  • I posted a note to the hackers list about this very issue last week. It was never responded to. I am prepared to do the work and submit a patch, but I wanted some input on how best to do it. We had a ...
    Jan 5, 2001 at 1:19 am
    Jan 9, 2001 at 2:26 pm
  • I am reposting this because I'm not sure it actually made it to the list. I have a function to transform text into a pseudo-metaphone variable, take this example: cddbsql=# select song, ...
    M wM w
    Jan 30, 2001 at 6:48 pm
    Feb 5, 2001 at 7:42 am
  • Helo all, Please try this script, it will crash the current connection. I'm using the 01/18/2001 PostgreSQL v7.1 beta3 snapshot. -- Script begin ------------------------------------- create table ...
    Steve HoweSteve Howe
    Jan 24, 2001 at 4:08 am
    Jan 27, 2001 at 5:40 am
  • In Linux Weekly News, an Interview with Bruce (from Nov 30): http://lwn.net/2001/features/Momjian/ :-) Go get'em, Bruce.... -- Lamar Owen WGCR Internet Radio 1 Peter 4:11
    Lamar OwenLamar Owen
    Jan 12, 2001 at 4:10 am
    Jan 13, 2001 at 3:59 pm
  • Hi, Beeing very impressed by TOAST, I wonder how I can insert BLOB from a flat file. It seems quite easy with php; But how can I do it from psql?? TIA -- Olivier PRENANT Tel: +33-5-61-50-97-00 (Work) ...
    Olivier PRENANTOlivier PRENANT
    Jan 28, 2001 at 7:59 pm
    Jan 30, 2001 at 10:49 am
  • It is reported that building C++ interface on FreeBSD 4.2 fails. Can someone comment on this? c++ -pipe -O3 -mpentiumpro -Wall -fpic -DPIC -I/usr/local/ssl/include -I../../../src/include ...
    Tatsuo IshiiTatsuo Ishii
    Jan 20, 2001 at 4:12 am
    Jan 24, 2001 at 4:08 am
  • When I run 'make check' on the CVS version (today and for the last serveral days), I have been getting interesting failures. Some of the tests fail, but the interesting part is that not the same ...
    Jan 6, 2001 at 9:46 pm
    Jan 7, 2001 at 10:33 pm
  • I've just been looking through the options which can and cannot be set in postgresql.conf and have a few points to raise. 1. There are some undocumented options which appear to relate to WAL: Name ...
    Oliver ElphickOliver Elphick
    Jan 11, 2001 at 8:38 pm
    Jan 25, 2001 at 6:15 pm
  • Does the SPI interface support recursion? That is, can a function use SPI to make a query which involves calling another function which uses SPI? The documentation suggests not, saying that if a ...
    Ian Lance TaylorIan Lance Taylor
    Jan 5, 2001 at 7:39 pm
    Jan 12, 2001 at 3:08 am
  • I just finished running the parallel regress tests with inval.c rigged to flush the relcache and syscache at every available opportunity, that is anytime we could recognize a shared-cache-inval ...
    Tom LaneTom Lane
    Jan 5, 2001 at 6:18 am
    Jan 10, 2001 at 2:32 am
  • Bruce, On Tue, 23 Jan 2001 09:35:49 -0500 (EST) Bruce Momjian wrote: Sucks found: - doesn't handle mediumint, converts it to mediuminteger. The same for bigint, and probably shorting & tinyint as ...
    Max RudenskyMax Rudensky
    Jan 23, 2001 at 6:49 pm
    Feb 10, 2001 at 12:03 pm
  • It has been requested that I ship prebuilt contrib items in the 7.1 RPMset. Currently, the source code of the whole contrib tree is being shipped in the main RPM as documentation, but only autoinc ...
    Lamar OwenLamar Owen
    Jan 25, 2001 at 6:25 pm
    Jan 27, 2001 at 1:10 pm
  • Just to understand things correctly. Is the Like optimization disabled for all non-ASCII char sets, or (imho correctly) for non charset ordered collations (LC_COLLATE) ? Thus can you enable index ...
    Andreas ZeugswetterAndreas Zeugswetter
    Jan 22, 2001 at 11:17 am
    Jan 24, 2001 at 1:29 pm
  • Yes, I am hoping to write this utility before 7.1 final. Maybe it will have to be in /contrib. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a ...
    Bruce MomjianBruce Momjian
    Jan 15, 2001 at 9:56 pm
    Jan 24, 2001 at 5:06 am
  • Hello, just small question. I just realized that it seems that Oracle stores indexed values in the index itself. This mean that it is not necessary to access table when you need to get only indexed ...
    Denis PerchineDenis Perchine
    Jan 23, 2001 at 4:22 pm
    Jan 23, 2001 at 11:01 pm
  • Dear Tom, I am writing to you because you are the maintainer of the query optimizer and planner. I have found a very significant performance degradation between PostgreSQL 6.5.3 and 7.1beta3, which ...
    Robert E. BruccoleriRobert E. Bruccoleri
    Jan 16, 2001 at 6:26 pm
    Jan 17, 2001 at 8:13 pm
  • First I tried to dump out a database like: frank@limedes:~ pg_dump mpi dump.mpi getTables(): relation 'institute': 6 Triggers were expected, but got 0 The database mpi does contain a table ...
    Frank JoerdensFrank Joerdens
    Jan 12, 2001 at 5:04 pm
    Jan 12, 2001 at 8:19 pm
  • After almost a month since Beta1 was released, and skipping Beta2, the PostgreSQL Developers are pleased to announced Beta3 of v7.1. Due to the large number of changes made since Beta1 was released, ...
    The Hermit HackerThe Hermit Hacker
    Jan 11, 2001 at 4:19 am
    Jan 12, 2001 at 4:24 pm
  • The problem with pg_dump and renamed primary key attrs can be fixed by using the indkey attribute of pg_index to lookup attrs in pg_class - this is what pg_dump does when it dumps indexes. If I am ...
    Philip WarnerPhilip Warner
    Jan 7, 2001 at 8:35 am
    Jan 12, 2001 at 1:14 pm
  • Dear list, According to this list's content, the upcoming 7.1 release appears to be in good progress. This version will bring a *lot* on necessary features for some database work : unions and ...
    Emmanuel CharpentierEmmanuel Charpentier
    Jan 7, 2001 at 11:42 am
    Jan 12, 2001 at 1:31 am
  • I have noticed that AND and TRAILING could be made ColLabel's without further changes. Currently they are completely reserved. (This is especially odd given that OR is a ColLabel.) Would that be okay ...
    Peter EisentrautPeter Eisentraut
    Jan 4, 2001 at 8:23 pm
    Jan 6, 2001 at 12:47 am
  • Would people please check the TODO list in pgsql/doc/TODO or on our web site, and let me know if there are any items that need a dash because they are completed in 7.1? I think I may have missed a ...
    Bruce MomjianBruce Momjian
    Jan 3, 2001 at 7:13 am
    Jan 5, 2001 at 11:04 am
  • my English is more poor :-) You are right, it is (was?) in TODO and it will implemented - I hope - in some next release (may be in 7.2 during ACL overhaul, Peter?). Before some time I wrote patch ...
    Karel ZakKarel Zak
    Jan 29, 2001 at 10:37 pm
    May 9, 2001 at 1:33 pm
  • Damn, the new EXECUTE command in PL/pgSQL is a security hole. PL/pgSQL is a trusted procedural language, meaning that regular users can write code in it. With the new EXECUTE command, someone could ...
    Jan WieckJan Wieck
    Jan 29, 2001 at 2:57 pm
    Jan 29, 2001 at 8:01 pm
  • Here is documentation for WAL, as text for immediate review and as SGML source, generated from Vadim's original text with my editing. Please review for correctness. =========================== WAL ...
    Oliver ElphickOliver Elphick
    Jan 23, 2001 at 4:44 pm
    Jan 24, 2001 at 11:19 pm
  • Could anyone please tell me what changed in some of the include files. I just noticed that ecpg won't compile anymore. Also I think we have yet to agree on the libpq/ecpg problem, or did I miss a ...
    Michael MeskesMichael Meskes
    Jan 18, 2001 at 2:22 pm
    Jan 19, 2001 at 3:59 pm
  • I'm working with PHP and Postgres, and if I try to do an EXPLAIN query, with PHP, to the postgres backend the output goes to the error_log file of apache and I don't know how to redirect that output ...
    Martin A. MarquesMartin A. Marques
    Jan 9, 2001 at 7:07 pm
    Jan 10, 2001 at 1:59 am
  • The planregress.sh tests generate errors. Attached is a tar of the planregress directory... -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: ler@lerctr.org US Mail: 1905 ...
    Larry RosenmanLarry Rosenman
    Jan 1, 2001 at 4:49 am
    Jan 2, 2001 at 12:37 pm
  • It would require only very minor changes in the main backend code to eliminate entirely the hard-wired upper bound MAXBACKENDS. This would be nice since there'd never be any need to recompile in ...
    Tom LaneTom Lane
    Jan 26, 2001 at 4:28 pm
    Jan 27, 2001 at 4:43 am
  • If you don't know what is all about read the bottom (I'll requote my posting) Bruce Momjian wrote: The thing which comes most close to a rejection was the 'I can't decide' mail by you (answered by ...
    Christof PetigChristof Petig
    Jan 24, 2001 at 4:10 am
    Jan 24, 2001 at 3:54 pm
Group Navigation
period‹ prev | Jan 2001 | next ›
Group Overview
grouppgsql-hackers @

159 users for January 2001

Tom Lane: 276 posts Bruce Momjian: 203 posts Peter Eisentraut: 90 posts Lamar Owen: 58 posts The Hermit Hacker: 56 posts Vadim Mikheev: 55 posts Thomas Lockhart: 39 posts Andreas Zeugswetter: 38 posts Hannu Krosing: 28 posts Tatsuo Ishii: 28 posts Oliver Elphick: 25 posts Martin A. Marques: 22 posts Nathan Myers: 21 posts Oleg Bartunov: 20 posts Jan Wieck: 18 posts Patrick Welche: 17 posts Hiroshi Inoue: 16 posts Lawrence E. Rosenman: 16 posts Philip Warner: 16 posts Pete Forman: 15 posts
show more