FAQ

Search Discussions

295 discussions - 926 posts

  • Hi, I'd welcome constructive criticism of the following patch to "backend/storage/file/fd.c" that I hope will allow postgreSQL to inteligently use the system limit on the number of open files. It's ...
    Keith ParksKeith Parks
    Jan 5, 1997 at 12:29 am
    Jan 13, 1997 at 12:17 am
  • Hi... I've done a very slight change to psql.c and config.h in order to prepare the distribution for the use of configure. Enabling readline in Makefile.custom currently remains the same ...
    The Hermit HackerThe Hermit Hacker
    Jan 25, 1997 at 3:59 am
    Jan 28, 1997 at 4:07 am
  • Here is the current list: OID = integer not using index (Erich) include libpq++ fixes? (Leo) prevent UNIQUE on non-btree indexes svr4 Unixware problem, need SB_PAD(Gordon) lo_close broken(Edmund) ...
    Bruce MomjianBruce Momjian
    Jan 13, 1997 at 3:37 am
    Jan 27, 1997 at 8:47 pm
  • I found the following bugs in the version 6.0 (dated 961229). At least the first two should be fixed before the final release of 6.0. 1) There is a mismatch between the type declared in the catalog ...
    Massimo Dal ZottoMassimo Dal Zotto
    Jan 2, 1997 at 7:20 pm
    Jan 10, 1997 at 5:43 pm
  • These changes allow customization to be done first then defaults added. This fixes the problems people found with the current system I think. I am not suggesting an immediate update to the source ...
    D'Arcy J.M. CainD'Arcy J.M. Cain
    Jan 6, 1997 at 9:56 pm
    Jan 9, 1997 at 8:39 am
  • Looking at the code is there a particular reason why we are using tzset()? From the man page for tzset(), I can't find a particular benefit to using tzset() vs the #else that the code includes... I ...
    The Hermit HackerThe Hermit Hacker
    Jan 24, 1997 at 1:55 am
    Jan 25, 1997 at 8:53 pm
  • OK, having got the compilation out of the way, there are a couple of little problems once you get started. - --------------------------------------------------------------------- 1. Since psql uses ...
    AndrewAndrew
    Jan 22, 1997 at 1:56 pm
    Jan 23, 1997 at 7:40 pm
  • Hi, I have made some modifications to version 1.09 to make it compile and run on NeXTStep. In spite of the fact in the README is claimed this version runs on NeXTStep the support files are incomplete ...
    Ovidiu PredescuOvidiu Predescu
    Jan 4, 1997 at 4:16 pm
    Jan 13, 1997 at 7:27 pm
  • not sure exactly what the bug is here...but why *is* vacuum so verbose? It is kind of interesting to watch, but if I didn't know any better, I would be worried it was a bunch of error messages, and, ...
    The Hermit HackerThe Hermit Hacker
    Jan 12, 1997 at 9:32 am
    Jan 14, 1997 at 3:04 am
  • This seems wise, but it'd be nice to have some sort of initialization file of default parameters. Having the path to said file compiled in as the default wouldn't necesarily be a problem if there was ...
    Christopher HicksChristopher Hicks
    Jan 6, 1997 at 9:42 pm
    Jan 8, 1997 at 10:57 am
  • ============================================================================ POSTGRES95 (970120.tar.gz) COMPILE BUG ============================================================================ Your ...
    AfcAfc
    Jan 20, 1997 at 3:23 pm
    Jan 23, 1997 at 10:51 am
  • Thus spake eigenstr@mixi.net I guess this is one reason to distribute with -Werror. People find these things and we know about them. It isn't that hard to fix it and we have one more thing for our ...
    D'Arcy J.M. CainD'Arcy J.M. Cain
    Jan 23, 1997 at 2:54 pm
    Jan 23, 1997 at 9:52 pm
  • To report a bug, please complete the following form and send it by email to hackers@postgreSQL.org. ============================================================================ POSTGRES95 BUG REPORT ...
    Mark WahlMark Wahl
    Jan 22, 1997 at 3:22 am
    Jan 23, 1997 at 8:28 pm
  • OK, take a look at this, tell me if there's a patch, or whether my table's corrupted, or what; you'll remember I had a problem with identical oids earlier this week: iris2= select distinct * from ...
    John RobinsonJohn Robinson
    Jan 11, 1997 at 10:19 pm
    Jan 17, 1997 at 9:58 pm
  • This message is in MIME format. The first part should be readable text, while the remaining parts are likely unreadable without MIME-aware tools. Send mail to mime@docserver.cac.washington.edu for ...
    Anton de WetAnton de Wet
    Jan 11, 1997 at 3:13 pm
    Jan 16, 1997 at 7:52 pm
  • ============================================================================ POSTGRES95 BUG REPORT TEMPLATE ============================================================================ Your name : ...
    Chana SlutzkinChana Slutzkin
    Jan 16, 1997 at 8:28 pm
    Jan 25, 1997 at 9:08 pm
  • create table users ( uid integer unique, uname text ); or create table users ( uid integer primary key, uname text ); or create table chess-pieces ( row integer, column integer, piece text ) primary ...
    Christopher HicksChristopher Hicks
    Jan 21, 1997 at 10:51 am
    Jan 21, 1997 at 7:08 pm
  • Well here's my run-down of comments on installing 970116. 1. INSTALL still suggests you edit Makefile.global. I know this is perfectly possible, but surely changing Makefile.custom is the preferred ...
    Andrew MartinAndrew Martin
    Jan 16, 1997 at 3:14 pm
    Jan 18, 1997 at 8:03 am
  • Hi, I've just been playing with the "date" type in postgreSQL and I'm getting some horrible output!! The platform is sparc_solaris, postgreSQL is V6 sup 14th Jan. I think it may be due to the ...
    Keith ParksKeith Parks
    Jan 14, 1997 at 7:50 pm
    Jan 16, 1997 at 4:40 am
  • I grabbed the 6.0 beta dated 970109 and noted these minor problems in the /src/Makefile.global file: 1) SRCDIR has no definition, but is referenced by other variables in the Makefile.global. Lines ...
    Daniel J. DisterDaniel J. Dister
    Jan 13, 1997 at 4:13 am
    Jan 13, 1997 at 9:48 am
  • It failed last night with gzip core dumping. </chris (chicks@chicks.net) I went to a restaurant that serves "breakfast at any time." So I ordered French Toast during the Renaissance. - Steven Wright ...
    Christopher HicksChristopher Hicks
    Jan 10, 1997 at 11:41 am
    Jan 12, 1997 at 3:49 am
  • Wow, my posting must have worked because we have gotten hammered with patches/issues. We certainly have their attention, and they have 100% of ours. If we are still going make January 10th, we will ...
    Bruce MomjianBruce Momjian
    Jan 4, 1997 at 1:45 am
    Jan 5, 1997 at 9:20 pm
  • Hello hackers, I'm new to this list, so excuse me, if I repeat things others have said before. Due to problems with our old postgres (see separate mail on the normal mailing list), I played around ...
    EgghatEgghat
    Jan 19, 1997 at 6:35 pm
    Jan 27, 1997 at 8:53 pm
  • I would be intersted in what people thought of moving to a two-track release program, similar to the one used for linux kernel development. In this model, major releases alternate between being ...
    Cary B. O'BrienCary B. O'Brien
    Jan 26, 1997 at 1:42 pm
    Jan 27, 1997 at 10:04 am
  • A few hours ago, I needed a continious protocol of the select()'s made against my database to debug a CGI script that does a few complicated things. If I had used "-d 2" or "-d 3" I would have ...
    Hakan TandoganHakan Tandogan
    Jan 11, 1997 at 10:21 pm
    Jan 23, 1997 at 2:46 am
  • Hi, I wonder if the regression tests could be modified to be run in the same timezone as the original data? I realize that this would require the postmaster to be stopped and started in the correct ...
    Keith ParksKeith Parks
    Jan 16, 1997 at 8:16 pm
    Jan 18, 1997 at 3:17 am
  • I just grabbed 970114.tar, and when compiling got the following message: make -C bin all make[1]: Entering directory `/a/home/rose/val/farm/postgres95-6.0/src/bin' make -C pg_id all make[2]: Entering ...
    Craig S. AndersonCraig S. Anderson
    Jan 15, 1997 at 1:13 am
    Jan 16, 1997 at 7:38 am
  • Hi... I'm running v6.0 on a P133 with 32Meg of RAM on it and absolutely no load except that I have X running (ie. the machine is totally idle). I'm starting up postmaster with: postmaster ...
    The Hermit HackerThe Hermit Hacker
    Jan 8, 1997 at 9:51 am
    Jan 9, 1997 at 12:38 am
  • Because to change POSTGRESDIR, you have to make 8 defines because the Makefile.global automatically defines these once you change POSTGRESDIR. Also, there are no comments in Makefile.custom, you have ...
    Bruce MomjianBruce Momjian
    Jan 6, 1997 at 5:11 pm
    Jan 7, 1997 at 6:24 pm
  • I am trying to write some code that finds tuples based on a comparison with the "primary key." The routine needs to know what the primary key for a table is. For my purposes I define "primary key" as ...
    D'Arcy J.M. CainD'Arcy J.M. Cain
    Jan 5, 1997 at 5:55 pm
    Jan 6, 1997 at 7:20 am
  • It is trying to use sysconf to find the number of open file descriptors your system supports. Please check all your include files and see if you can find _SC_OPEN_MAX or something like it. Ultrix ...
    Bruce MomjianBruce Momjian
    Jan 26, 1997 at 8:20 pm
    Jan 27, 1997 at 8:32 pm
  • I'm going to have to unsubscribe from the hackers mailing list because there's just too much traffic for me to deal with. (I have time for about 5 Postgres messages a day; I got 65 today). Of course, ...
    Bryan HendersonBryan Henderson
    Jan 24, 1997 at 5:18 am
    Jan 26, 1997 at 2:45 pm
  • gnu very clearly states in the info file for autoconf that the files generated are all free of the GPL. </chris Karma Express: don't leave your body without it. (chicks@chicks.net, 23 Jan 97) ...
    Christopher HicksChristopher Hicks
    Jan 23, 1997 at 9:39 pm
    Jan 24, 1997 at 9:49 pm
  • OK, I've tried running through an installation under Linux and hit a number of small problems as described below (with fixes...) I'm mailing this from home since that's where my Linux box is :-) 1. ...
    AndrewAndrew
    Jan 22, 1997 at 1:24 pm
    Jan 23, 1997 at 10:40 am
  • I am hacking in some support for password-based authentication using crypt() on top of the HBA auth code, and I want to add a password column to the pg_user table. I am looking at the 970114 snapshot ...
    DaveDave
    Jan 15, 1997 at 10:28 pm
    Jan 16, 1997 at 4:58 am
  • Currently, it appears only LINUX_ELF has shared librarys created by default, I think. There is code in libpq/Makefile and libpgtcl that checks for LINUX_ELF and defines shared library names. If some ...
    Bruce MomjianBruce Momjian
    Jan 12, 1997 at 4:39 am
    Jan 14, 1997 at 2:37 am
  • I am working on a way to dump/load postgres users. Is there a way to identify the user who is the super-user from in the pg_user table? I don't want to dump/load that user. ...
    Bruce MomjianBruce Momjian
    Jan 10, 1997 at 10:01 pm
    Jan 13, 1997 at 4:23 am
  • There is a buffer leak in vacuum or nbtree (I haven't really understood what's happening and where) which occurs while running vacuum after all the tuples of an index are deleted (by setting ...
    Massimo Dal ZottoMassimo Dal Zotto
    Jan 3, 1997 at 12:39 pm
    Jan 13, 1997 at 1:48 am
  • Here is the most recent FAQ item: How do I install PostgreSQL somewhere other than /usr/local/pgsql? You need to edit Makefile.global and change POSTGRESDIR accordingly, or create a Makefile.custom ...
    Bruce MomjianBruce Momjian
    Jan 6, 1997 at 5:13 pm
    Jan 7, 1997 at 10:38 pm
  • This makes sense. Let's use it in 6.1. ------------------------------
    Bruce MomjianBruce Momjian
    Jan 1, 1997 at 4:34 pm
    Jan 6, 1997 at 3:09 pm
  • Hi, I am still having problems with creating and dropping databases. The following tests have been made with 970102.tar.gz. In order to start with a clean installation, I always run the following ...
    Edmund MerglEdmund Mergl
    Jan 3, 1997 at 12:19 pm
    Jan 6, 1997 at 11:39 am
  • Hi, Here's another small patch to pg_dump that allows it to recognise and dump the creation statement for UNIQUE indexes. BTW: Do we explain anywhere that we only honour UNIQUE indexes where the ...
    Keith ParksKeith Parks
    Jan 1, 1997 at 10:49 pm
    Jan 3, 1997 at 6:28 pm
  • Hi Just one stupid question. Why does psql print \ as \\, while it still prints ' as '? It's really hard to understand this: mydb= insert into test values ('\'\\'); INSERT 76192 mydb= select * from ...
    Alvaro Martinez EchevarriaAlvaro Martinez Echevarria
    Jan 25, 1997 at 5:20 am
    Jan 28, 1997 at 5:42 pm
  • What is the difference between the above two? ------------------------------
    The Hermit HackerThe Hermit Hacker
    Jan 24, 1997 at 3:52 am
    Jan 25, 1997 at 3:02 am
  • Hello all. For compile, postgres 6.0 version from 970121 needs some modification in the #include in the module dl.c and port-protos.h for FreeBSD. (FreeBSD does not need link.h). All in the directory ...
    Lenzi, SergioLenzi, Sergio
    Jan 22, 1997 at 3:38 pm
    Jan 24, 1997 at 6:38 pm
  • I'm currently using the latest 6.0 release 970122, and I'm trying to dump my database to a file, here's the result I get: sisa:/home/dev$ pg_dump -f billing.bak -d billing isViewRule(): SELECT failed ...
    Horace PosadasHorace Posadas
    Jan 23, 1997 at 5:45 am
    Jan 23, 1997 at 10:09 pm
  • Has anyone added a plaintext password authentication method yet? I need this, so I think I will add it. It will be convenient, and not very secure, but it will be the same level of security used on ...
    Dan McGuirkDan McGuirk
    Jan 21, 1997 at 4:31 pm
    Jan 23, 1997 at 6:11 pm
  • Hi... Bruce, you were mentioning something about 10,000 records being loaded in in 40secs? Well, I'm still hitting the 4:46min barrier here... any recommendations on *what* sort of debug I should be ...
    The Hermit HackerThe Hermit Hacker
    Jan 13, 1997 at 7:55 am
    Jan 23, 1997 at 2:47 am
  • Has anyone tried both perl interfaces to postgres recently? If they really are truly complimentary then I'd like to see both included in the distribution. We do have both libpq and libpq++. ...
    Christopher HicksChristopher Hicks
    Jan 21, 1997 at 3:36 pm
    Jan 21, 1997 at 9:33 pm
  • Hi Marc, during the incorporation of the GEQO module in the current code I encountered serious problem. There seem to many dirty things to be left until the 6.0 release. There is a 'S_IFREG' tag ...
    Martin S. UteschMartin S. Utesch
    Jan 15, 1997 at 8:59 am
    Jan 20, 1997 at 9:36 am
Group Navigation
period‹ prev | Jan 1997 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions295
posts926
users101
websitepostgresql.org...
irc#postgresql

101 users for January 1997

Bruce Momjian: 252 posts The Hermit Hacker: 174 posts Andrew Martin: 62 posts Bryan Henderson: 50 posts Christopher Hicks: 40 posts Keith Parks: 37 posts Vadim B. Mikheev: 31 posts Edmund Mergl: 18 posts D'Arcy J.M. Cain: 12 posts Darren King: 11 posts Erik Bertelsen: 11 posts Wieck: 9 posts Erich Stamberger: 9 posts Nyang: 8 posts Lsh: 8 posts Brandon Ibach: 7 posts Craig S. Anderson: 7 posts John Robinson: 7 posts Afc: 6 posts Andrew: 6 posts
show more
Archives