Search Discussions

169 discussions - 947 posts

  • I came across problems with sorting a huge (2.4GB) table. o it took 46 minutes to complete following query: select * from test2 order by i desc limit 100; to get 0 results. i|t -+- (0 rows) I assume ...
    Tatsuo IshiiTatsuo Ishii
    Oct 13, 1999 at 10:03 am
    Dec 24, 1999 at 9:29 pm
  • Here is something I read as part of the Alladin Ghostscript 6.0 beta release. I must admit I don't understand the logic of the issue. It seems the issue is that you can link non-GPL to GPL libraries, ...
    Bruce MomjianBruce Momjian
    Oct 19, 1999 at 2:03 pm
    Oct 22, 1999 at 8:15 am
  • I have been doing some testing with multi-segment relations. (Not having sixty gigabytes laying around, like some folk I've been talking to recently, I rebuilt with a very small RELSEG_SIZE for ...
    Tom LaneTom Lane
    Oct 12, 1999 at 4:13 am
    Nov 17, 1999 at 12:47 pm
  • OK, I am applying the following patch to fix the above problem. The old code, which I wrote, took care of trailing semicolons, but did not really fix the problems of comment-only lines, and lines ...
    Bruce MomjianBruce Momjian
    Oct 5, 1999 at 8:39 pm
    Oct 9, 1999 at 1:37 am
  • Here is my proposal for an outline for a PostgreSQL book. Many of us have been asked by publishers about writing a book. Here is what I think would be a good outline for the book. I am interested in ...
    Bruce MomjianBruce Momjian
    Oct 12, 1999 at 5:16 pm
    Oct 21, 1999 at 3:11 pm
  • Oops, the stuff I posted yesterday contained a few pretty funky bugs. I have put up a new tarball. Also, I have written updated DocBook documentation. It's not a great work of literature yet but it's ...
    Peter EisentrautPeter Eisentraut
    Oct 27, 1999 at 4:09 pm
    Nov 6, 1999 at 5:17 pm
  • Found this quote by Philip Greenspun (who is unabashedly in love with Oracle) in a LinuxWorld article: " The open source purist's only realistic choice for an RDBMS Cheers! (the full series of ...
    Lamar OwenLamar Owen
    Oct 8, 1999 at 5:29 pm
    Oct 13, 1999 at 7:53 am
  • While you're at it... The following example shows psql correctly clearing its input buffer when a line containing *only* a comment is seen, but not completely clearing the buffer (or not realizing ...
    Thomas LockhartThomas Lockhart
    Oct 6, 1999 at 2:07 pm
    Nov 30, 1999 at 12:31 am
  • Because the next release is going to probably be 7.0, if people have backward compatability library code that they have been dying to remove, this is the time for it. I don't recommend removing ...
    Bruce MomjianBruce Momjian
    Oct 9, 1999 at 12:53 pm
    Oct 12, 1999 at 11:14 pm
  • This is a followup to a message I wrote in June about reworking the fmgr interface. I've had a couple of good ideas (I think ;-)) since then, but there are some parts of the proposal that still need ...
    Tom LaneTom Lane
    Oct 23, 1999 at 11:53 pm
    Nov 2, 1999 at 3:16 am
  • Hi, I'm planning to implement a new type of scan,scan by TID. It's on TODO * Allow WHERE restriction on ctid. First,I want to define an equal operator between TID. Seems OID's 1700-1799 are reserved ...
    Hiroshi InoueHiroshi Inoue
    Oct 5, 1999 at 9:50 am
    Oct 13, 1999 at 10:13 am
  • The installation can be quick and painless. I'll explain more tomorrow. Vince. -- ========================================================================== Vince Vielhaber -- KA8CSH email: ...
    Vince VielhaberVince Vielhaber
    Oct 13, 1999 at 12:55 am
    Oct 21, 1999 at 4:56 pm
  • OK, yesterday I signed contracts from Addison, Wesley, Longman for a book on PostgreSQL. I got approval from Marc, Thomas, Vadim, and Tom Lane. I also sent them a resume which was approved by the ...
    Bruce MomjianBruce Momjian
    Oct 19, 1999 at 10:33 pm
    Aug 15, 2000 at 11:27 pm
  • Hmm. I see a problem coming up for myself :( I'm working on JOIN syntax and (hopefully) OUTER JOIN capabilities for the next release. That will take a lot of time afaik. We also have lots of great ...
    Thomas LockhartThomas Lockhart
    Oct 8, 1999 at 3:07 pm
    Oct 12, 1999 at 4:33 pm
  • Okay, I have the following voting results: 2 for pgcreatedb, pgdropdb, pgcreateuser, pgdropuser (Bruce, me) 1 for pg_createdb, pg_dropdb, etc. (Sergio K.) 1/2 for pgadduser, etc., or sth. like that ...
    Peter EisentrautPeter Eisentraut
    Oct 13, 1999 at 8:47 am
    Oct 15, 1999 at 12:07 pm
  • OK, I have installed it in the current tree and stable tree. I will keep pgaccess up-to-date in both trees in the future. The tricky part is that pgaccess must know the 'wish' path that is determined ...
    Bruce MomjianBruce Momjian
    Oct 31, 1999 at 12:50 pm
    Nov 4, 1999 at 4:02 pm
  • Request For Comments: Towards an industrial-strength logging facility 1999-10-19, Tim Holloway mtsinc@leading.net Introduction. PostgreSQL is a commercial-quality DBMS. However, one item generally ...
    Tim HollowayTim Holloway
    Oct 23, 1999 at 12:13 am
    Oct 26, 1999 at 7:18 am
  • In related news I'd like to point out that psql's \dd command now supports aggregates, functions, operators, types, relations (tables, views, indices, sequences), rules, and triggers. In addition all ...
    Peter EisentrautPeter Eisentraut
    Oct 24, 1999 at 7:49 pm
    Oct 26, 1999 at 11:33 am
  • AFAICT, the last remaining textual length limits in the backend are a couple of fixed-size buffers in rewriteDefine.c and array support. In the next few days (probably this weekend) I intend to fix ...
    Tom LaneTom Lane
    Oct 20, 1999 at 3:38 pm
    Oct 22, 1999 at 6:29 pm
  • Hello: (This is a repost from a mail to -general, as nobody could answer me, and acording to the Mailing Lists home page, I'm sending it here.) Maybe somebody could give some clue about what is ...
    Fernando SchapachnikFernando Schapachnik
    Oct 21, 1999 at 4:12 pm
    Oct 26, 1999 at 12:47 pm
  • http://www.PostgreSQL.org/~wieck/ The new developers globe is updated with all photos I got so far. Still missing are: Andrew Martin Bruce Momjian Byron Nikolaidis Constantin Teodorescu Edmund Mergl ...
    Jan WieckJan Wieck
    Oct 30, 1999 at 3:41 pm
    Oct 31, 1999 at 2:05 am
  • The following is the next-to-last paragraph on our main news page: RedHat RPMs for v6.5.1 on i386 machines are now available at ftp://postgresql.org/pub/RPMS/ Please report any questions or problems ...
    Thomas LockhartThomas Lockhart
    Oct 19, 1999 at 2:50 pm
    Oct 20, 1999 at 8:18 am
  • Ah, yes. Much better. -- Lamar Owen WGCR Internet Radio Pisgah Forest, North Carolina 1 Peter 4:11
    Lamar OwenLamar Owen
    Oct 12, 1999 at 5:40 pm
    Oct 19, 1999 at 10:53 am
  • I see a todo item * Views with spaces in view name fail when referenced I have another one for you: * Databases with spaces in name fail to be created and destroyed despite responses to the contrary. ...
    Peter EisentrautPeter Eisentraut
    Oct 5, 1999 at 8:39 pm
    Jun 1, 2000 at 6:05 am
  • Is this the way distinct is supposed to work? My intent is to give only one for each different value of x - like it does in the first distinct example. But when order by is added for the date/time ...
    Vince VielhaberVince Vielhaber
    Oct 20, 1999 at 11:56 pm
    Oct 21, 1999 at 5:00 pm
  • Folks, I've been struggling to copy a large table (200 million records, 60GB) to tape using: psql -qc "copy psc to STDOUT;" Winter99 | dd of=/dev/st0 bs=32k After processing about 10 million records ...
    Martin WeinbergMartin Weinberg
    Oct 9, 1999 at 3:04 pm
    Oct 11, 1999 at 3:59 pm
  • As you might recognize, this is supposed to be a psql \d imitation in one shot: SELECT usename as "Owner", relname as "Relation", (CASE WHEN relkind='r' THEN (CASE WHEN 0<(select count(*) from ...
    Peter EisentrautPeter Eisentraut
    Oct 2, 1999 at 1:52 am
    Dec 1, 1999 at 5:19 am
  • Does anybody know how to use UNION and LIMIT together ? I want to get 10 rows from publications and 10 rows from keys. select msg_id from publications limit 10 union select key_id from keys limit 10 ...
    Oleg BartunovOleg Bartunov
    Oct 6, 1999 at 7:06 pm
    Nov 30, 1999 at 10:32 am
  • Subject says all. In general I want to limit output from select ...... intersect select ...... Current implementation of LIMIT doesn't support this. Are there any solutions ? Regards, Oleg Oleg ...
    Oleg BartunovOleg Bartunov
    Oct 17, 1999 at 4:40 pm
    Oct 19, 1999 at 5:34 am
  • ... yeah, me neither. Hi all, I have an interesting one for you today. I'm writing a new \dd command (one that actually works), and I have come across the following situation: SELECT DISTINCT ...
    Peter EisentrautPeter Eisentraut
    Oct 17, 1999 at 7:41 pm
    Oct 18, 1999 at 5:16 am
  • Here's the summary of my wheelings and dealings. No code yet, but trust me, you don't want it. * Changed one file into many * Changed few functions into countless * Added GNU long option support ...
    Peter EisentrautPeter Eisentraut
    Oct 5, 1999 at 8:39 pm
    Oct 7, 1999 at 3:26 am
  • Jan, I like it. There's an oldish pic of me on http://www.retep.org.uk/contact/ - it's about 6 months old, so I could do a new one if you want. Peter -- Peter Mount Enterprise Support Maidstone ...
    Peter MountPeter Mount
    Oct 19, 1999 at 11:14 am
    Oct 20, 1999 at 5:49 am
  • Hello Bruce, I've just submitted a patch to the patches list which implements Oracle's COMMENT statement. It will insert/update/delete the appropriate OID for the table or column targeted for the ...
    Mike MascariMike Mascari
    Oct 15, 1999 at 1:31 am
    Oct 18, 1999 at 1:04 am
  • Hello again, I thought I should start making some small contibutions before 7.0. Attached is a patch to the old problem discussed feverly before 6.5. What is does: for locale-enabled servers: use ...
    Goran ThyniGoran Thyni
    Oct 15, 1999 at 6:12 pm
    Nov 30, 1999 at 1:53 am
  • Whilst cleaning up query-length dependencies, I noticed that our handling of maximum file pathname lengths is awfully messy. Different parts of the system rely on no fewer than four different symbols ...
    Tom LaneTom Lane
    Oct 23, 1999 at 4:47 am
    Nov 11, 1999 at 2:34 am
  • I just received a message from someone complaining about SERIAL/sequence. I think there is a problem: test= create table test (x int, y serial); NOTICE: CREATE TABLE will create implicit sequence ...
    Bruce MomjianBruce Momjian
    Oct 29, 1999 at 9:29 pm
    Oct 31, 1999 at 1:19 pm
  • Don't remember if really or what, but wasn't there some problem with cached system relations, unique indices and concurrency? Jan -- ...
    Jan WieckJan Wieck
    Oct 26, 1999 at 8:15 am
    Oct 28, 1999 at 12:31 am
  • While doing some tests, I have encountered too many problems with incompatible BLKSZ (the backend comipled in different BLKSZ with the one in database). I know this is my fault, but it would be nice ...
    Tatsuo IshiiTatsuo Ishii
    Oct 12, 1999 at 1:06 am
    Oct 17, 1999 at 12:52 am
  • First of all, great work. I love it. Just some minor nitpits: My mail address while correct in the text is incorrect in the graphic. The mail address listed there is no longer valid, so mail may ...
    Michael MeskesMichael Meskes
    Oct 13, 1999 at 7:54 pm
    Oct 16, 1999 at 10:32 am
  • Marc, I added a dead directory called interfaces/pgeasy that I have removed via CVS, but I know the directory still exists in the CVS tree. (Now called libpgeasy). In fact, I know there are many ...
    Bruce MomjianBruce Momjian
    Oct 12, 1999 at 2:52 pm
    Oct 13, 1999 at 2:08 pm
  • This is a Debian bug report, which needs upstream attention. ------- Forwarded Message Date: Thu, 28 Oct 1999 13:45:18 -0400 From: Brian Ristuccia <brianr@osiris.978.org To: submit@bugs.debian.org ...
    Oliver ElphickOliver Elphick
    Oct 28, 1999 at 7:53 pm
    Oct 29, 1999 at 4:51 am
  • There is a todo item for the postgres user to have a password by default. I'm not sure though how that would be done. Probably in initdb. (?) I had this on my personal things-to-consider-working-on ...
    Peter EisentrautPeter Eisentraut
    Oct 13, 1999 at 8:39 pm
    Oct 14, 1999 at 5:09 pm
  • Here's the long-awaited next edition. For those who must get their hands on some code I have a tarball at http://www.pathwaynet.com/~peter/psql.tar.bz2 It includes a file RELEASENOTES which should ...
    Peter EisentrautPeter Eisentraut
    Oct 11, 1999 at 7:50 pm
    Oct 14, 1999 at 1:34 am
  • I apologize if this is the wrong group for this message, but I'm not sure where else this would go. I don't have a specific problem, but I would like to ask some questions about how postgres works. ...
    Bryan IngramBryan Ingram
    Oct 22, 1999 at 8:13 pm
    Oct 30, 1999 at 12:13 pm
  • Hi, I try dump (via pg_dump) my database, but if I write dumped data back to DB, views (as select on ingerit table) not work. The bug is in routine pg_get_ruledef(pg_rewrite.rulename), which _not_ ...
    Karel ZakKarel Zak
    Oct 27, 1999 at 10:50 am
    Oct 29, 1999 at 2:26 pm
  • Hi All, A make on a "cvs update" from this morning fails with the following error message. make -C commands all make[2]: Entering directory `/usr/local/pgsql/src/backend/commands' make[2]: *** No ...
    Keith ParksKeith Parks
    Oct 26, 1999 at 9:58 am
    Oct 26, 1999 at 5:55 pm
  • Tom, I suspect that this is your work: ./psql: error in loading shared libraries : undefined symbol: createPQExpBuffer which happens if you run several versions of everything all at once and forget ...
    Peter EisentrautPeter Eisentraut
    Oct 6, 1999 at 4:14 pm
    Oct 25, 1999 at 1:41 pm
  • For external reasons I didn't get as much done as I wanted. Originally, I planned for 4 weeks and I think I can keep that. The source is posted at http://www.pathwaynet.com/~peter/psql3.tar.gz ...
    Peter EisentrautPeter Eisentraut
    Oct 19, 1999 at 7:39 pm
    Oct 20, 1999 at 10:20 am
  • Does anyone have an archive of Marc's request to gather developers for Postgres95 development? It would in the May-June, 1996 time period. I had it for a long time, but accidentally deleted it. Isn't ...
    Bruce MomjianBruce Momjian
    Oct 17, 1999 at 3:01 am
    Oct 17, 1999 at 4:58 am
  • Too complicated. Issue a warning if invoked with old args and remove old link in 8.x. You can test basename $0 and test to see how you were invoked. I like the scripts too. -- Bruce Momjian | ...
    Bruce MomjianBruce Momjian
    Oct 11, 1999 at 10:31 pm
    Oct 15, 1999 at 11:59 am
Group Navigation
period‹ prev | Oct 1999 | next ›
Group Overview
grouppgsql-hackers @

111 users for October 1999

Bruce Momjian: 219 posts Tom Lane: 137 posts Jan Wieck: 48 posts Peter Eisentraut: 43 posts Thomas Lockhart: 37 posts The Hermit Hacker: 33 posts Vince Vielhaber: 32 posts Hiroshi Inoue: 27 posts Lamar Owen: 27 posts Tatsuo Ishii: 23 posts Oleg Bartunov: 22 posts Peter Mount: 19 posts Vadim Mikheev: 19 posts Karel Zak: 12 posts Mike Mascari: 11 posts Brook Milligan: 10 posts Peter Eisentraut: 10 posts Ansley, Michael: 9 posts Oliver Elphick: 9 posts Peter Eisentraut: 9 posts
show more