Search Discussions
-
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 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 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 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 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 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 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 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 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 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 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 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 Vielhaber
Oct 13, 1999 at 12:55 am
Oct 21, 1999 at 4:56 pm -
19
book status
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 Momjian
Oct 11, 1999 at 10:31 pm
Oct 15, 1999 at 11:59 am
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 169 |
posts | 947 |
users | 111 |
website | postgresql.org... |
irc | #postgresql |
111 users for October 1999
Archives
- August 2013 (1,430)
- July 2013 (1,772)
- June 2013 (2,428)
- May 2013 (1,555)
- April 2013 (1,283)
- March 2013 (1,441)
- February 2013 (1,366)
- January 2013 (2,520)
- December 2012 (1,701)
- November 2012 (1,618)
- October 2012 (1,580)
- September 2012 (1,195)
- August 2012 (1,180)
- July 2012 (1,125)
- June 2012 (1,850)
- May 2012 (1,584)
- April 2012 (1,459)
- March 2012 (1,921)
- February 2012 (1,517)
- January 2012 (1,777)
- December 2011 (1,347)
- November 2011 (1,764)
- October 2011 (1,687)
- September 2011 (1,623)
- August 2011 (1,433)
- July 2011 (1,658)
- June 2011 (2,404)
- May 2011 (1,664)
- April 2011 (1,834)
- March 2011 (1,956)
- February 2011 (2,476)
- January 2011 (2,965)
- December 2010 (2,587)
- November 2010 (2,109)
- October 2010 (2,113)
- September 2010 (2,173)
- August 2010 (2,061)
- July 2010 (1,612)
- June 2010 (1,560)
- May 2010 (1,961)
- April 2010 (1,575)
- March 2010 (1,314)
- February 2010 (2,439)
- January 2010 (3,118)
- December 2009 (2,514)
- November 2009 (493)
- October 2009 (1,903)
- September 2009 (1,990)
- August 2009 (2,170)
- July 2009 (2,025)
- June 2009 (1,565)
- May 2009 (1,518)
- April 2009 (1,431)
- March 2009 (1,424)
- February 2009 (1,399)
- January 2009 (2,641)
- December 2008 (2,011)
- November 2008 (1,918)
- October 2008 (1,695)
- September 2008 (1,887)
- August 2008 (1,374)
- July 2008 (1,495)
- June 2008 (1,149)
- May 2008 (1,112)
- April 2008 (1,908)
- March 2008 (1,288)
- February 2008 (1,309)
- January 2008 (1,220)
- December 2007 (989)
- November 2007 (1,369)
- October 2007 (1,553)
- September 2007 (1,225)
- August 2007 (1,221)
- July 2007 (1,007)
- June 2007 (1,127)
- May 2007 (1,189)
- April 2007 (1,266)
- March 2007 (1,866)
- February 2007 (1,916)
- January 2007 (1,645)
- December 2006 (1,423)
- November 2006 (1,021)
- October 2006 (1,565)
- September 2006 (2,375)
- August 2006 (2,039)
- July 2006 (1,626)
- June 2006 (1,624)
- May 2006 (1,366)
- April 2006 (1,150)
- March 2006 (1,327)
- February 2006 (1,259)
- January 2006 (1,030)
- December 2005 (1,252)
- November 2005 (1,568)
- October 2005 (1,417)
- September 2005 (1,464)
- August 2005 (1,191)
- July 2005 (1,150)
- June 2005 (1,576)
- May 2005 (1,592)
- April 2005 (1,004)
- March 2005 (1,069)
- February 2005 (969)
- January 2005 (1,100)
- December 2004 (949)
- November 2004 (1,210)
- October 2004 (1,059)
- September 2004 (951)
- August 2004 (1,601)
- July 2004 (1,397)
- June 2004 (1,037)
- May 2004 (1,446)
- April 2004 (1,167)
- March 2004 (1,330)
- February 2004 (1,003)
- January 2004 (861)
- December 2003 (827)
- November 2003 (1,618)
- October 2003 (1,602)
- September 2003 (1,683)
- August 2003 (1,343)
- July 2003 (1,045)
- June 2003 (1,302)
- May 2003 (802)
- April 2003 (1,012)
- March 2003 (1,242)
- February 2003 (1,323)
- January 2003 (1,315)
- December 2002 (1,176)
- November 2002 (1,220)
- October 2002 (1,449)
- September 2002 (1,816)
- August 2002 (2,295)
- July 2002 (1,290)
- June 2002 (1,024)
- May 2002 (1,157)
- April 2002 (1,532)
- March 2002 (1,207)
- February 2002 (1,225)
- January 2002 (1,397)
- December 2001 (963)
- November 2001 (1,301)
- October 2001 (1,155)
- September 2001 (895)
- August 2001 (1,204)
- July 2001 (938)
- June 2001 (1,131)
- May 2001 (1,458)
- April 2001 (1,168)
- March 2001 (1,672)
- February 2001 (1,154)
- January 2001 (1,450)
- December 2000 (1,222)
- November 2000 (1,390)
- October 2000 (1,296)
- September 2000 (633)
- August 2000 (888)
- July 2000 (1,428)
- June 2000 (1,283)
- May 2000 (1,648)
- April 2000 (184)
- March 2000 (291)
- February 2000 (1,464)
- January 2000 (1,639)
- December 1999 (1,056)
- November 1999 (916)
- October 1999 (949)
- September 1999 (946)
- August 1999 (695)
- July 1999 (1,070)
- June 1999 (1,242)
- May 1999 (1,136)
- April 1999 (218)
- March 1999 (1,002)
- February 1999 (692)
- January 1999 (758)
- December 1998 (591)
- November 1998 (600)
- October 1998 (1,208)
- September 1998 (678)
- August 1998 (856)
- July 1998 (482)
- June 1998 (496)
- May 1998 (618)
- April 1998 (702)
- March 1998 (1,118)
- February 1998 (1,307)
- January 1998 (855)
- December 1997 (346)
- November 1997 (374)
- October 1997 (575)
- September 1997 (549)
- August 1997 (404)
- July 1997 (391)
- June 1997 (595)
- May 1997 (478)
- April 1997 (854)
- March 1997 (526)
- February 1997 (297)
- January 1997 (927)
- December 1996 (2)
- November 1996 (1)
- October 1996 (1)
- October 1995 (2)
- July 1995 (1)