Search Discussions

180 discussions - 938 posts

  • I have found that many TODO items would benefit from a pg_depend table that tracks object dependencies. TODO updated. --------------------------------------------------------------------------- ...
    Bruce MomjianBruce Momjian
    Jul 16, 2001 at 5:00 am
    Jul 24, 2001 at 7:50 am
  • Hi, I'd like to add another column to pg_rewrite, holding the string representation of the rewrite rule. A new utility command will then allow to recreate the rules (internally DROP/CREATE, but that ...
    Jan WieckJan Wieck
    Jul 12, 2001 at 5:22 pm
    Jul 13, 2001 at 2:15 am
  • [ redirected to pgsql-hackers for comment ] Helge Bahmann <bahmann@math.tu-freiberg.de writes: Well, we need to talk about that. I like your idea of making ident auth "just work" on local connections ...
    Tom LaneTom Lane
    Jul 31, 2001 at 3:47 pm
    Aug 7, 2001 at 3:39 pm
  • I have purchased the Solaris source code from Sun for $80. (I could have downloaded it for free after faxing them an 11 page contract, but I decided I wanted the CD's.) See the slashdot story at: ...
    Bruce MomjianBruce Momjian
    Jul 5, 2001 at 8:30 pm
    Jul 11, 2001 at 10:28 pm
  • Upon review, I don't think these patches are very good at all. #defining errno as WSAGetLastError() is a fairly blunt instrument, and it breaks all the places that do actually need to use errno, such ...
    Tom LaneTom Lane
    Jul 21, 2001 at 8:46 pm
    Aug 15, 2001 at 5:02 pm
  • I have noticed that a large fraction of the I/O done by 7.1 is associated with initializing new segments of the WAL log for use. (We have to physically fill each segment with zeroes to ensure that ...
    Tom LaneTom Lane
    Jul 17, 2001 at 2:56 pm
    Jul 23, 2001 at 1:03 pm
  • I was looking over the todo list and saw that someone wanted to support XML. I have some quick and dirty stuff that could be used. OK, what should the feature look like? Should it be grafted onto ...
    Mark L. WoodwardMark L. Woodward
    Jul 27, 2001 at 11:37 am
    Jul 30, 2001 at 2:31 pm
  • Hello all, I've tried again sending large queries using libpq on Windows environment, without success. I downloaded the PostgreSQL v7.12 sources, compiled libpq.dll using Microsoft's Visual C++ 6.0, ...
    Steve HoweSteve Howe
    Jul 20, 2001 at 7:01 am
    Jul 23, 2001 at 5:25 pm
  • Idea for a new SQL Data Type: RECURRINGCHAR The idea with RECURRINGCHAR is treated exactly like a VARCHAR in it's usage. However, it's designed for table columns that store a small set of repeated ...
    Jul 3, 2001 at 7:29 pm
    Jul 11, 2001 at 12:13 pm
  • Running: ALTER TABLE table ADD COLUMN column SERIAL; Defines a column as int4 but does not create the sequence or attempt to set the default value. Not a big deal, but I was surprised when the column ...
    Rod TaylorRod Taylor
    Jul 16, 2001 at 4:48 pm
    Nov 28, 2001 at 8:56 pm
  • I have thought of a few new TODO performance items: 1) Someone at O'Reilly suggested that we order our duplicate index entries by tid so if we are hitting the heap for lots of duplicates, the hits ...
    Bruce MomjianBruce Momjian
    Jul 30, 2001 at 4:50 pm
    Sep 6, 2001 at 4:40 am
  • I was thinking: #if SOMAXCONN = 1000 #define PG_SOMAXCONN SOMAXCONN #else #define PG_SOMAXCONN 1000 #endif -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your ...
    Bruce MomjianBruce Momjian
    Jul 10, 2001 at 9:26 pm
    Jul 17, 2001 at 2:12 am
  • Sorry to bug the list with something a bit off topic, but I've been scrounging around for some examples of someone doing some fairly serious work with postgresql, and haven't yet been able to turn ...
    Joe BrennerJoe Brenner
    Jul 3, 2001 at 5:44 pm
    Jul 10, 2001 at 11:56 pm
  • I was wondering if some of you Postgres hackers could advise me on the safety of the following. I have written a postgres C function that uses a popen linux system call. Orginally when I first tried ...
    Jul 17, 2001 at 1:47 pm
    Aug 4, 2001 at 12:57 am
  • As some of you know, Nusphere is trying to sell MySQL with an additional transaction-based table manager called Gemini. They enabled download of the source code yesterday at: ...
    Bruce MomjianBruce Momjian
    Jul 18, 2001 at 2:13 am
    Jul 19, 2001 at 3:15 pm
  • Greetings, I'm working with pqlib in asynchronous mode and I have a question about PQgetResult. I have this situation: submit a query via PQsendQuery() flush to the backend with PQflush() set my read ...
    Matthew HagertyMatthew Hagerty
    Jul 7, 2001 at 3:08 am
    Jul 10, 2001 at 9:06 pm
  • I have been making some notes about the rules for accessing shared disk buffers, since they aren't spelled out anywhere now AFAIK. In process I found what seems to be a nasty bug in the code that ...
    Tom LaneTom Lane
    Jul 3, 2001 at 1:41 am
    Jul 10, 2001 at 8:38 pm
  • I hope I'm not taking too much time from people here... Here's where I'm now (and don't beat me too hard :) I'm done with change of RangeTblEntry into three different node types: ...
    Alex PilosovAlex Pilosov
    Jul 2, 2001 at 10:21 pm
    Jul 8, 2001 at 3:41 am
  • Since I am about to add a "bulk delete" routine to the index access method APIs for concurrent VACUUM, I need to add a column to pg_am to define the associated procedure for each index AM. This seems ...
    Tom LaneTom Lane
    Jul 13, 2001 at 10:36 pm
    Sep 6, 2001 at 4:41 am
  • Hello all, Is anybody trying to solve the 8191 bytes query limit from libpq windows port ??? We've discussed this topic on "Large queries - again" thread and it seems like nobody got interested on ...
    Steve HoweSteve Howe
    Jul 26, 2001 at 4:31 am
    Aug 1, 2001 at 5:19 am
  • I sent the email below to the creator of contrib/vacuumlo/ with no reply just yet. Is it possible to get his code included in the main vacuumdb program for support to vacuum orphaned large objects? ...
    Jul 31, 2001 at 12:14 am
    Aug 1, 2001 at 1:25 am
  • Has it ever been considered to (optionally) use the iconv interface for character set conversion instead of rolling our own? It seems to be a lot more flexible, has pluggable conversion modules ...
    Peter EisentrautPeter Eisentraut
    Jul 11, 2001 at 6:13 pm
    Jul 16, 2001 at 1:13 am
  • Looks like there is no drawback in locking buffer so let's lock it. Vadim
    Mikheev, VadimMikheev, Vadim
    Jul 3, 2001 at 5:41 pm
    Jul 5, 2001 at 1:55 pm
  • in testing CVS tip(sort of), I found that you need -lcurses with -ledit on NetBSD 1.5.1. _tputs in undefined otherwise. LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: ...
    Larry RosenmanLarry Rosenman
    Jul 16, 2001 at 12:36 pm
    Aug 29, 2001 at 9:05 pm
  • [cc: to GENERAL replacedby cc: to HACKERS] Ok, let's look. First, there is a createlang issue: during build, @libdir@ as referenced in the createlang script references /usr/lib, instead of ...
    Lamar OwenLamar Owen
    Jul 20, 2001 at 10:17 pm
    Jul 21, 2001 at 11:11 am
  • Shouldn't this conversation be happening on the -hackers list? TIA - Thomas
    Thomas LockhartThomas Lockhart
    Jul 13, 2001 at 3:06 pm
    Jul 14, 2001 at 12:33 am
  • Muggins here volunteered to get RAISE to accept any expression that evaluates to a string rather than just a string constant. Think I can see why it wasn't that way already. Had a look, and this is ...
    Richard HuxtonRichard Huxton
    Jul 21, 2001 at 2:21 pm
    Aug 3, 2001 at 6:04 am
  • While this should be a nice speedup, it bothers me somewhat that the old behavior of reacting immediately to pg_hba.conf and pg_ident.conf updates has been changed. (And you didn't update the ...
    Tom LaneTom Lane
    Jul 31, 2001 at 11:05 pm
    Aug 1, 2001 at 12:52 am
  • I've packaged up what I've done so far and you can find it at http://www.cabbage.uklinux.net/pgxml.tar.gz The TODO file included indicates what still remains to be done (a lot!). In particular, it ...
    John GrayJohn Gray
    Jul 26, 2001 at 5:01 pm
    Jul 30, 2001 at 3:00 pm
  • Is there a way to debug a PL/pgSQL function? It's behaving very irradic! I have two function, one that works and one that doesn't. The part that don't work in func2 is 'SELECT INTO ... ...' and I ...
    Turbo FredrikssonTurbo Fredriksson
    Jul 25, 2001 at 1:47 pm
    Jul 29, 2001 at 4:50 am
  • Hi, I'm fighting with problem with indexes. I read documentation about performance tips, about internal logic functions which are making decision if to use or not use indexes, etc. and I'm still ...
    Robert VojtaRobert Vojta
    Jul 27, 2001 at 10:13 am
    Jul 28, 2001 at 10:49 am
  • The problem with setuid functions in general is that a database user can effectively re-grant privileges to which he has no grant privileges. E.g., user1= create table table1 (id int, secret_content ...
    Peter EisentrautPeter Eisentraut
    Jul 11, 2001 at 9:51 pm
    Jul 19, 2001 at 5:15 pm
  • Hi there, we are developing reporting software and want to support at least one open source alternative to oracle. Things were going very smoothly with postgresql and the only problem we are facing ...
    Mariano KampMariano Kamp
    Jul 3, 2001 at 7:06 am
    Jul 17, 2001 at 12:06 pm
  • It has a very cool SQL extension called COPY. Super fast. Command: COPY Description: Copies data between files and tables Syntax: COPY [ BINARY ] table [ WITH OIDS ] FROM { 'filename' | stdin } [ ...
    Mark L. WoodwardMark L. Woodward
    Jul 11, 2001 at 12:36 am
    Jul 12, 2001 at 11:19 pm
  • OK, I just talked to Tom on the phone and here is his idea for 7.2. He says he already posted this, but I missed it. His idea is that in 7.2 VACUUM will only move rows within pages. It will also ...
    Bruce MomjianBruce Momjian
    Jul 6, 2001 at 9:59 pm
    Jul 12, 2001 at 7:54 pm
  • 1. I consider particular case when Tx S' xmax is before Tx New' ID. 1.1 For this case acquiring SInval lock before ReadNewTransactionId() changes behavior of Tx Old: it postpones change of Tx Old' ...
    Mikheev, VadimMikheev, Vadim
    Jul 12, 2001 at 5:11 pm
    Jul 12, 2001 at 7:12 pm
  • In this bit of code in src/pl/plpgsql/src/gram.y in the current CVS sources, curname_def is defined as PLpgSQL_expr * but it is is allocated the space required for a PLpgSQL_var. This looks like a ...
    Ian Lance TaylorIan Lance Taylor
    Jul 12, 2001 at 12:38 am
    Jul 12, 2001 at 12:01 pm
  • If you have time, take a quick look at http://acidlab.sourceforge.net/perf/acid_perf.html PostgreSQL has serious scalability problems with snort + acid. Any advices? (Now I'm using MySQL with my ...
    Sergio BruderSergio Bruder
    Jul 10, 2001 at 12:38 pm
    Jul 11, 2001 at 11:59 am
  • I can confirm that current CVS sources have the same bug. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + ...
    Bruce MomjianBruce Momjian
    Jul 25, 2001 at 10:54 pm
    Jul 27, 2001 at 2:19 am
  • When someone issues this command: ALTER TABLE test ADD UNIQUE (a, b); What happens when: 1. A non-unique index is already defined over (a, b) - Either add new index or promote existing one to unique? ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Jul 10, 2001 at 1:44 am
    Jul 23, 2001 at 3:05 am
  • If PostgreSQL is run on a system that has a file size limit (2 gig?), where might cause us to hit the limit? -- Naomi Walker Chief Information Officer Eldorado Computing, Inc. 602-604-3100 ext 242
    Naomi WalkerNaomi Walker
    Jul 6, 2001 at 10:51 pm
    Jul 16, 2001 at 4:36 pm
  • Is there any good reason to use VARCHAR over TEXT for a string field? ie. performance hits, etc. Other than running into the row size limit problem, are there any large storage / performance ...
    Rachit SiamwallaRachit Siamwalla
    Jul 10, 2001 at 9:37 pm
    Jul 11, 2001 at 4:16 pm
  • [Repost from July 1. Hasn't made it to the list yet.] The description of the FE/BE protocol says: However, libpq doesn't do that. Instead, it leaves the connection open and returns CONNECTION_BAD to ...
    Peter EisentrautPeter Eisentraut
    Jul 5, 2001 at 7:47 pm
    Jul 10, 2001 at 4:42 pm
  • Hello, hackers! I am running postgresql 7.1 on a SMP Linux box. It runs, but it never pass a loadavg of 0.4, no matter how I try to overload the system. The same configuration, the same executable, ...
    Víctor RomeroVíctor Romero
    Jul 5, 2001 at 2:51 pm
    Jul 8, 2001 at 11:37 am
  • Comming from Oracle, I was disapointed that the users were not "per individual database". I had to promote my database owner to superuser to make it able to create users (I didn't want to su to ...
    Jean-Francois LevequeJean-Francois Leveque
    Jul 6, 2001 at 8:37 am
    Jul 6, 2001 at 6:53 pm
  • Greetings, I am going over the use of select() for a server I'm writing and I *thought* I understood the man page's description for the use of the first parameter, nfds. From MAN: The first nfds ...
    Matthew HagertyMatthew Hagerty
    Jul 6, 2001 at 5:22 am
    Jul 6, 2001 at 3:42 pm
  • Just moments after writing that, I was startled to read on another mailing list that the long-mythical Autoconf 2.50 is released! We should probably consider updating from autoconf 2.13 as our ...
    Tom LaneTom Lane
    Jul 30, 2001 at 11:34 pm
    Aug 6, 2001 at 12:24 am
  • I noticed that pltcl didn't have any way to get to SPI_lastoid like plpgsql does.. I started using pltcl a lot because I like to decide when and how my queries get planned.. so I put one together ...
    Jul 27, 2001 at 2:36 am
    Aug 2, 2001 at 1:41 am
  • /home/projects/pgsql partition at hub.org is down to zero free space... regards, tom lane
    Tom LaneTom Lane
    Jul 20, 2001 at 3:18 am
    Jul 20, 2001 at 3:17 pm
  • Hello all, Writing my interface application, which use the PQexec library, I came across the PQexec() queries 8191 bytes limit. What useful are 4Gb text fields if I have this limit ? I mean, if a ...
    Steve HoweSteve Howe
    Jul 18, 2001 at 12:14 pm
    Jul 18, 2001 at 9:33 pm
Group Navigation
period‹ prev | Jul 2001 | next ›
Group Overview
grouppgsql-hackers @

160 users for July 2001

Tom Lane: 184 posts Bruce Momjian: 143 posts Peter Eisentraut: 41 posts Hiroshi Inoue: 30 posts Alex Pilosov: 28 posts Nathan Myers: 27 posts Jan Wieck: 25 posts Andreas Zeugswetter: 23 posts Mark L. Woodward: 21 posts Vadim Mikheev: 19 posts Christopher Kings-Lynne: 16 posts Tatsuo Ishii: 16 posts Bill Studenmund: 15 posts Lamar Owen: 14 posts Larry Rosenman: 14 posts Steve Howe: 10 posts Rod Taylor: 9 posts Vince Vielhaber: 9 posts Matthew Hagerty: 8 posts Philip Warner: 8 posts
show more