Search Discussions

302 discussions - 852 posts

  • I thought there was a "Powered by Postgres95" icon already. Or do do you want something more unique in concept? Leo Subject: Re: [QUESTIONS] PostgreSQL Website From: "Marc G. Fournier" ...
    Leo ShusterLeo Shuster
    Apr 2, 1997 at 1:59 pm
    Apr 3, 1997 at 5:18 pm
  • Hi, folks. I've made a small patch to allow postgresql to compile cleanly on Digital Unix 3.2c using the DEC C compiler. Also, /usr/bin/installbsd should be used instead of the default ...
    Pedro J. LoboPedro J. Lobo
    Apr 1, 1997 at 8:52 am
    Apr 14, 1997 at 4:12 pm
  • - --============_-1351994057==_============ Content-Type: text/plain; charset="us-ascii" Colours are of course easily changed, but given the logo discussion so far I think that this could be close to ...
    J. Douglas DunlopJ. Douglas Dunlop
    Apr 4, 1997 at 4:33 am
    Apr 4, 1997 at 6:53 pm
  • I suggest move SUBJ from vacuum.c to another file - i.g. analyze.c - and add new command ANALYZE. 1. 6.0 vacuum of ~60M table with 652688 tuples reports about 37 sec in user-mode, 6.1 vacuum - about ...
    Vadim B. MikheevVadim B. Mikheev
    Apr 18, 1997 at 2:57 am
    Apr 22, 1997 at 8:11 am
  • I don't, but I will CC this to the development team as a whole... we've had discussions on the usefulness of this, and the camp is currently split :) Marc G. Fournier Systems Administrator @ hub.org ...
    The Hermit HackerThe Hermit Hacker
    Apr 8, 1997 at 5:50 pm
    Apr 9, 1997 at 4:42 am
  • Hi... I've just finished doing a compile of the current source tree, and made several modifications to get it to compile 'cleanly'. As well, I've performed several cleanup passes on the regression ...
    The Hermit HackerThe Hermit Hacker
    Apr 26, 1997 at 6:36 am
    Apr 26, 1997 at 8:10 pm
  • Based on? Marc G. Fournier Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org ------------------------------
    The Hermit HackerThe Hermit Hacker
    Apr 25, 1997 at 3:54 am
    Apr 25, 1997 at 5:55 pm
  • Hi... I have a table I'm reading in that had one field of type int4... unfortunately, the table that I'm trying to do a 'copy from' from has 25000 records, not all of which have a value in that field ...
    The Hermit HackerThe Hermit Hacker
    Apr 15, 1997 at 2:19 pm
    Apr 16, 1997 at 3:42 am
  • Here it is. I have done some minimal testing and there may be more to do but the basic functionality is here. The header is at the end. /* cash.c Written by D'Arcy J.M. Cain Functions to allow input ...
    D'Arcy J.M. CainD'Arcy J.M. Cain
    Apr 8, 1997 at 5:01 pm
    Apr 9, 1997 at 4:44 pm
  • Evening... Was just creating a database for one of my users, and something dawned on me that I hadn't thought about before... If I create a database, who owns it? For instance, if I create a database ...
    Marc G. FournierMarc G. Fournier
    Apr 4, 1997 at 2:20 am
    Apr 4, 1997 at 4:08 pm
  • I think that there are other problems with v6.1alpha/beta which are _not_ Sparc-specific. My guess is that folks will be willing to postpone the release until the problems (or suspicion of such) are ...
    Thomas LockhartThomas Lockhart
    Apr 28, 1997 at 8:44 pm
    Apr 29, 1997 at 8:19 am
  • In my attempts to port Postgres to Unixware 2.03 (univel), I've run into apparently insurmountable problems. The major sticking point seems to be either an OS-level library incompatibility, or a ...
    Michael P. SnyderMichael P. Snyder
    Apr 15, 1997 at 4:01 pm
    Apr 16, 1997 at 4:02 am
  • The concensis appears to be that x.0 versions should be the stable, finished ones and all other version numbers are development. I gather that there was some discussion before I joined you and it was ...
    Henry B. HotzHenry B. Hotz
    Apr 10, 1997 at 10:29 pm
    Apr 11, 1997 at 9:00 pm
  • As someone here suggested I added setsockopt (TCP_NODELAY) to backend and frontend code. My test (586/75, 24M, FreeBSD): BEGIN; 2000 INSERTs into table with 9 attrs (6 int4, 2 text, date, time) (2 ...
    Vadim B. MikheevVadim B. Mikheev
    Apr 16, 1997 at 8:08 am
    Apr 18, 1997 at 7:58 pm
  • Hi... Well, now that ppl are starting to gripe about too much traffic on the hackers list (and there is alot of it *grin*), I think its time to branch off some of the stuff so that hackers can get ...
    The Hermit HackerThe Hermit Hacker
    Apr 15, 1997 at 5:19 pm
    Apr 16, 1997 at 11:12 am
  • I've made a first attempt at a 64-bit integer package, and have placed two files in /pub/incoming: int8_970403.tar.gz and README.int8. Perhaps they could be added to the contrib area of the 6.1 tree? ...
    Thomas LockhartThomas Lockhart
    Apr 3, 1997 at 12:54 pm
    Apr 5, 1997 at 3:51 am
  • Using PostgreSQL-6.0 on a FreeBSD 2.2 system, I've written a few C functions to support IP address formatting. These aren't fancy but allow documenting a network LAN using very simple CGI scripts. ...
    Hal SnyderHal Snyder
    Apr 29, 1997 at 8:27 am
    Apr 30, 1997 at 9:03 am
  • Not *entirely* accurate...we do have table locking right now, what would it take to be able to do database locking? Okay, far fetched idea here, but if the pg_superuser were to be able to *lock* a ...
    The Hermit HackerThe Hermit Hacker
    Apr 28, 1997 at 3:01 am
    Apr 28, 1997 at 9:02 pm
  • Hello! I need a lite version of PostgeSQL for use on a notebook with W95 to use the same client-programs in the net as on the notebook. Before trying a port I want to ask you, if anybody else is ...
    Martin H. LudwigMartin H. Ludwig
    Apr 11, 1997 at 7:03 pm
    Apr 16, 1997 at 8:09 pm
  • Hi... I just updated the ports section of FreeBSD so that it uses v6.0 of PostgreSQL vs v1.09...there is an associated comment that I don't *really* like, and was wondering if someone could suggest ...
    The Hermit HackerThe Hermit Hacker
    Apr 10, 1997 at 7:29 pm
    Apr 11, 1997 at 3:58 pm
  • Just tried to compile the 970410? snap shot (todays)...it fails when compiling cash.c...is this a new file? Adrian ------------------------------
    Apr 10, 1997 at 7:16 pm
    Apr 11, 1997 at 1:09 am
  • - --Multipart_Fri_Apr__4_09:18:57_1997-1 Content-Type: text/plain; charset=US-ASCII Gentlepeople, Here a few patches that works around a bug in large objects, and a few other random patches I needed ...
    Raymond ToyRaymond Toy
    Apr 4, 1997 at 2:18 pm
    Apr 7, 1997 at 2:46 pm
  • I assume that part of the reason a tigress was suggested was because it is similar in name to Postgres? However, I think it would be hard to make a tigress not look Exxonish. I would like to suggest ...
    David FriendDavid Friend
    Apr 3, 1997 at 1:55 pm
    Apr 3, 1997 at 8:11 pm
  • There has been a lot of discussion on the docs list lately about moving forward on documentation. One of the questions is "can we convert the man pages" to something else. I think we can find ...
    Christopher HicksChristopher Hicks
    Apr 28, 1997 at 6:03 am
    Apr 28, 1997 at 2:12 pm
  • Yes - with current code. update pg_proc set oid = 1138::oid where proname = 'date_larger'; and others in Tom' update6_0-6_1.sql don't work! OIDs can't be changed. Just try to do it but do 'select oid ...
    Vadim B. MikheevVadim B. Mikheev
    Apr 10, 1997 at 2:49 am
    Apr 15, 1997 at 7:41 am
  • Hi: This is my first trial to play with 6.1. I've downloaded 970409, built it (minor Makefile problem with YACC), installed it, loaded databases, etc.... Almost everything seems to be OK (including ...
    Quang B. VuQuang B. Vu
    Apr 10, 1997 at 9:35 pm
    Apr 12, 1997 at 3:55 am
  • Hi... When we first took on this project almost 8 months ago, our primary goal was to shape things up to be a stable RBMS, based on the groundwork put forth by Jolly and Andrew. From what I have seen ...
    The Hermit HackerThe Hermit Hacker
    Apr 10, 1997 at 6:53 am
    Apr 10, 1997 at 6:47 pm
  • Let me reproduce these comments from nbtree.h first (sorry): * BTItems are what we store in the btree. Each item has an index * tuple, including key and pointer values. In addition, we must * ...
    Vadim B. MikheevVadim B. Mikheev
    Apr 8, 1997 at 4:01 am
    Apr 8, 1997 at 5:23 am
  • Hi there, here are little patches to get Postgres 6.1 works with locale stuff. This is a patch against 970402.tar.gz, there are no problem to apply them by hand to 6.0 release. Collate stuff tested ...
    Oleg BartunovOleg Bartunov
    Apr 2, 1997 at 2:44 pm
    Apr 7, 1997 at 4:42 pm
  • I think this is a solution for the performance problems under FreeBSD, but I'm not familiar enough with the PostgreSQL code to know where to make the proper setsockopt call... - ---------- Forwarded ...
    Derek GliddenDerek Glidden
    Apr 3, 1997 at 4:59 am
    Apr 4, 1997 at 4:12 pm
  • Hi, I've noticed something strange when running the regression tests on my system, SPARC Solaris-2.5 PostgreSQL-6.1sup270497. After the "sanity_check" step there appears to be 3 copies of the "tenk1" ...
    Keith ParksKeith Parks
    Apr 27, 1997 at 6:23 pm
    Apr 28, 1997 at 6:20 pm
  • Hi ! I think i solve the problem ! It was my fould but PSQL has to prevent this kind of error. I had defined the following table/index: create table BESTELLUNG ( USER varchar(30), ID int, MENGE int ...
    Volker RichertVolker Richert
    Apr 18, 1997 at 7:40 pm
    Apr 25, 1997 at 5:26 pm
  • Hi, I'm still getting problems with pg_dump in the latest sup'd version of PostgreSQL. The pg_dump query .. - ---- query is: SELECT t1.relname as indexrelname, t2.relname as indrelname, i.indproc, ...
    Keith ParksKeith Parks
    Apr 19, 1997 at 11:10 am
    Apr 22, 1997 at 6:17 pm
  • Hi... How does 'pgsql-tests' sound for a mailing list dedicated to discussions on: - performance - regression tests - speed - benchmarks - other related topics Marc G. Fournier Systems Administrator ...
    The Hermit HackerThe Hermit Hacker
    Apr 16, 1997 at 9:33 pm
    Apr 17, 1997 at 5:39 pm
  • As we aren't going to get any performance improvements out of v6.0, could someone come up with and upload to ftp.postgresql.org/pub/incoming a tar file containing: test table test data ('insert into' ...
    The Hermit HackerThe Hermit Hacker
    Apr 15, 1997 at 2:42 pm
    Apr 15, 1997 at 5:16 pm
  • 970413 and 970414 seem to be broken looking for /Makefile.port. make -C port all PORTNAME=sparc_solaris make[2]: Entering directory `/export/home/postgres/Source/970414/src/backend/port' ...
    Apr 14, 1997 at 10:48 pm
    Apr 15, 1997 at 4:39 pm
  • Hello, this evening I tried again to cope with dates, I defined DATEDEBUG in backend/utils/adt/dt.c, recompiled and started with "postmaster -B 1024 -d 99 -o '-Fe'" an "insert into dtest values ...
    Christoph KaeslingChristoph Kaesling
    Apr 3, 1997 at 7:42 pm
    Apr 4, 1997 at 3:04 am
  • Here are some additional patches mostly related to the date and time data types. It includes some type conversion routines to move between the different date types and some other date manipulation ...
    Thomas LockhartThomas Lockhart
    Apr 2, 1997 at 5:33 pm
    Apr 4, 1997 at 2:21 am
  • - -- I was under the assumption that only float8 and datetime (possibly) would - -- be broken right now...but it seems others (point/polygon and create - -- function, and a couple of others) are ...
    Apr 29, 1997 at 2:07 am
    Apr 29, 1997 at 1:43 pm
  • Can anyone using C++, or who is working on the current libpq++ comment on this? What it sounds like to me is Ben is creating a front-end interface, not a libpq++ replacement... Marc G. Fournier ...
    The Hermit HackerThe Hermit Hacker
    Apr 26, 1997 at 6:18 am
    Apr 28, 1997 at 9:02 pm
  • There was some interest on bencmarks a while back. This provides a good places to jump off from: http://www.ideasinternational.com/benchmark/bench.html Anybody want to implement TPC-[CDE] for ...
    Christopher HicksChristopher Hicks
    Apr 27, 1997 at 3:57 am
    Apr 28, 1997 at 2:55 am
  • 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 ...
    Christopher HicksChristopher Hicks
    Apr 18, 1997 at 2:08 am
    Apr 18, 1997 at 4:13 am
  • Hi... Over the past few weeks, as everyone is well aware, the volume on the PostgreSQL lists has been increasing. Personally, I think its a good thing, as it indicates more and more ppl are using ...
    The Hermit HackerThe Hermit Hacker
    Apr 15, 1997 at 1:22 pm
    Apr 15, 1997 at 5:28 pm
  • Hello, When updating a record, Postgres create a new record with the new values and disble the old record but does not DELETE it, I suppose this is for history purpose ? Can this be disabled ?? ...
    Yann CourtiesYann Courties
    Apr 15, 1997 at 1:09 pm
    Apr 15, 1997 at 4:31 pm
  • Hi... Was just going through the search engine at www.hotbot.com, and found references to a Japanese web site that ran the Wisconsin Benchmark on PostgreSQL...as I can't read Japanese, the site ...
    The Hermit HackerThe Hermit Hacker
    Apr 12, 1997 at 2:39 pm
    Apr 14, 1997 at 10:58 pm
  • AFAIK, nobody is talking about libpq++ and I was the only one who did anything with what existed in 1.09. I have not seen an issue of libpq++ come up once on the list since it was last posted on the ...
    Leo ShusterLeo Shuster
    Apr 11, 1997 at 6:42 pm
    Apr 14, 1997 at 2:12 pm
  • It occured to me that option setting using 'SET VAL ...' should be accessible to people creating user defined types without them having to recompile the backend. For instance, I've created a new ...
    Apr 8, 1997 at 12:00 am
    Apr 8, 1997 at 4:10 am
  • Implemented. Now we can do something like select month(date) as m, sum(profit) from ... group by m; Vadim ------------------------------
    Vadim B. MikheevVadim B. Mikheev
    Apr 5, 1997 at 7:11 am
    Apr 7, 1997 at 8:37 pm
  • Thomas (or anyone else)... Have you done a recent regression test? I just did one after all the changes I made, and regress.out has some pretty substantial differences from expected.out, and the ...
    The Hermit HackerThe Hermit Hacker
    Apr 4, 1997 at 11:55 am
    Apr 5, 1997 at 3:22 am
  • Some people seem to be of the feeling that bug reports for development releases should go to hackers and some feel they should go to bugs or ports (as appropriate). Obviously patches should always go ...
    Christopher HicksChristopher Hicks
    Apr 30, 1997 at 9:29 am
    Apr 30, 1997 at 5:29 pm
Group Navigation
period‹ prev | Apr 1997 | next ›
Group Overview
grouppgsql-hackers @

109 users for April 1997

The Hermit Hacker: 248 posts Vadim B. Mikheev: 69 posts Christopher Hicks: 53 posts Thomas Lockhart: 48 posts Bruce Momjian: 44 posts D'Arcy J.M. Cain: 29 posts Adrian Hall: 27 posts Leo Shuster: 20 posts Bibach: 19 posts Darren King: 18 posts David Friend: 17 posts Keith Parks: 16 posts Pedro J. Lobo: 12 posts System Administrator: 12 posts Oleg Bartunov: 10 posts J. Douglas Dunlop: 9 posts Raymond Toy: 8 posts James A. Hillyerd: 7 posts Martin J. Laubach: 7 posts Ben Elliston: 6 posts
show more