Search Discussions
-
Gah, typo'ed the name of pgsql-hackers. This should be better. Sorry to those who got this twice, once on GENERAL, once on HACKERS. Ross Breaking working apps is never a good thing, but that's part ...
Ross J. Reedstrom
Aug 14, 2000 at 6:52 pm
Jun 5, 2001 at 4:21 am -
[Meta: Please advise if this is the wrong list. I think, since this observation relates to Pg internals, this might be the right one, but feel free to move it back to -general if I'm wrong; I ...
Jules Bean
Aug 24, 2000 at 10:04 am
Oct 16, 2000 at 5:03 am -
It seems that optimiser is unaware that currval('seq') can be treated as a constant within an expression and thus produces suboptimal plans for WHERE clauses that use currval thus using a seq scan ...
Hannu Krosing
Aug 20, 2000 at 12:42 pm
Oct 14, 2000 at 4:39 am -
Can anyone explain the ERROR below? Is this a bug or a feature? This is 7.0.2. test=# select (1,2,3) = (1,2,3); ?column? ---------- t (1 row) test=# select (1,2,3) = (1,2,9); ?column? ---------- f (1 ...
Tatsuo Ishii
Aug 3, 2000 at 1:07 am
Aug 6, 2000 at 2:41 am -
This patch is for the TODO item * Disallow LOCK on view src/backend/commands/command.c is the only affected file -- Mark Hollomon mhh@mindspring.com
Mark Hollomon
Aug 29, 2000 at 2:25 pm
Oct 17, 2000 at 2:28 pm -
Seems that it's not possible to combine arrays and foreign keys ? CREATE TABLE table1 ( fld1 integer NOT NULL, number integer, level integer, PRIMARY KEY (fld1) ); CREATE TABLE table2 ( pkey integer ...
Kaare Rasmussen
Aug 9, 2000 at 3:51 pm
Oct 12, 2000 at 4:55 pm -
23
mac.c
Any comments at all from anyone on my mail from Sunday Nite on making the macaddr_manuf function just return a masked MACADDR (I.E. set the low 3 bytes to 0x00) and how we do this in the code? Any ...Larry Rosenman
Aug 2, 2000 at 1:55 am
Aug 21, 2000 at 4:18 am -
I am trying to create a view and have run across a, to me, bizarre occurance. One CREATE VIEW statement creates the view fine; changing the name of the view and repeating the same statement does not. ...
Brook Milligan
Aug 22, 2000 at 6:40 pm
Oct 16, 2000 at 9:02 pm -
Earlier this week, I reported getting core dumps with the following bt: (gdb) where #0 0x18271d90 in kill () from /usr/lib/libc.so.4 #1 0x182b2e09 in abort () from /usr/lib/libc.so.4 #2 0x80ee847 in ...
The Hermit Hacker
Aug 27, 2000 at 3:53 pm
Dec 24, 2000 at 3:59 am -
The comment in the random() function indicates that its author thought it'd produce output in the range 0..1, which seems like a pretty reasonable definition: /* result 0.0-1.0 */ result = ((double) ...
Tom Lane
Aug 1, 2000 at 4:02 pm
Aug 5, 2000 at 2:25 am -
Hello Everybody, Sorry for mailing at both the addresses. The situation is a nightmare at our installation facility, hence the need to capture as much attention as possible. We are using PostgreSQL ...
Suchet singh khalsa
Aug 21, 2000 at 2:58 am
Aug 25, 2000 at 9:02 pm -
The second update is failing to find any tuple that satisfies f1 = 10.1, because f1 is a float4 variable whereas 10.1 is implicitly a float8 constant. 6.5 also treated 10.1 as float8, but managed to ...
Tom Lane
Aug 7, 2000 at 3:36 pm
Aug 8, 2000 at 5:36 pm -
I noticed that INHERITS doesn't propogate indecies, It'd be nice if there was an toption to do so. thanks, -- -Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org] "I have the heart of a ...
Alfred Perlstein
Aug 28, 2000 at 7:00 pm
Oct 23, 2000 at 9:13 pm -
Uh, I was wondering where it was in the first place! Will fix it asap... There was some string copying stuff in a middle layer of the like() code, but I had thought that it was there only to get a ...
Thomas Lockhart
Aug 8, 2000 at 3:15 pm
Aug 22, 2000 at 2:35 pm -
Alright. My situation is this. I have a list of things that need to be done in a table called tasks. I have a list of users who will complete these tasks. I want these users to be able to come in and ...
Andrew Selle
Aug 17, 2000 at 6:05 pm
Mar 12, 2001 at 8:18 pm -
I have made a first cut at completing integration of Adriaan Joubert's BIT code into the backend. There are a couple little things left to do (for example, scalarltsel doesn't know what to do with ...
Tom Lane
Aug 21, 2000 at 5:05 am
Jan 21, 2001 at 1:58 pm -
Hmm? Are you suggesting that the PostQuel Postgres is still under development, and those zealots exist ? I thought it is dead since Version 4.2. Could you give me a pointer ? Thanks Andreas
Andreas Zeugswetter
Aug 24, 2000 at 8:29 am
Oct 15, 2000 at 6:43 pm -
-----BEGIN PGP SIGNED MESSAGE----- Last week I created a patch for the Postgres client side libraries to allow something like a (not so mighty) form of Oracle TNS, but nobody showed any interest. ...
Mario Weilguni
Aug 30, 2000 at 6:03 pm
Oct 17, 2000 at 1:01 am -
NB: I will be on vacation from 1-Sep to 5-Sep On the patches list I sent the following: ----------------------------------------- This patch implements a different "relkind" for views. Views are now ...
Mark Hollomon
Aug 31, 2000 at 4:56 pm
Oct 16, 2000 at 10:03 pm -
Here is a patch against CVS (without my earlier patch) to disallow LOCK x if x is a view. It does not use the SPI interface. -- Mark Hollomon mhh@mindspring.com
Mark Hollomon
Aug 29, 2000 at 6:20 pm
Sep 12, 2000 at 4:35 am -
We had a crash this morning of our server ... not the machine, just the postmaster processes ... all three of them spread across three seperate ports ... Just looking through logs now, I'm finding: ...
The Hermit Hacker
Aug 23, 2000 at 5:21 pm
Aug 25, 2000 at 9:02 am -
Short of someone sitting down and making it happen I don't see any. You'd only need to implement some sort of fall-through in `pg_hba.conf', which in my estimate can't be exceedingly hard. -- Peter ...
Peter Eisentraut
Aug 4, 2000 at 9:58 pm
Aug 16, 2000 at 12:38 pm -
It finally dawned on my how to easily implement the LIKE/ESCAPE clause. Currently, LIKE is transformed to the "~~" operator in the parser. For LIKE/ESCAPE, we should instead transform it to a ...
Thomas Lockhart
Aug 5, 2000 at 6:21 am
Aug 6, 2000 at 5:35 am -
I noticed you've got some really ugly stuff in gram.y to handle SELECT * FROM foo UNION JOIN bar which has a shift/reduce conflict with SELECT * FROM foo UNION SELECT * FROM bar Looks like you ...
Tom Lane
Aug 26, 2000 at 11:37 pm
Oct 16, 2000 at 3:59 am -
Is anybody considering this? So that people can write program which access a database via the Internet. What I'm getting at is that we have applications which run on our Intranet. They query and ...
John McKown
Aug 25, 2000 at 5:56 pm
Oct 16, 2000 at 3:25 am -
I noticed that the COALESCE function is implemented as a case statement, with the result that: update t1 set f = Coalesce( (select fn from t2 x where x.f1 = t1.f1), t1.f1) has the following plan: Seq ...
Philip Warner
Aug 5, 2000 at 7:07 am
Aug 6, 2000 at 4:50 am -
Those of you with long memories may recall a benchmark that Edmund Mergl drew our attention to back in May '99. That test showed extremely slow performance for updating a table with many indexes ...
Tom Lane
Aug 28, 2000 at 12:05 am
Jan 19, 2001 at 7:38 pm -
I think my last message to Tom (and the list) about the foreign key stuff and oids ended up in /dev/null due to a problem on the local mailer. Tom had suggested storing a more understandable form of ...
Stephan Szabo
Aug 6, 2000 at 5:30 pm
Aug 8, 2000 at 8:28 am -
I would like to see if we can't get some amount of OUTER JOIN functionality into the 7.1 release. It seems that the executor implementation should be pretty simple, at least for the left-join case ...
Tom Lane
Aug 25, 2000 at 8:07 pm
Aug 27, 2000 at 5:37 pm -
I know that I've seen this answer before but can't seem to find it for 7.0.2 in the archives. Which file(s) need to be changed to have Postgres default to 32K size row limits rather than 8K? Has ...
G. Anthony Reina
Aug 8, 2000 at 4:55 pm
Aug 8, 2000 at 10:59 pm -
Here's two ideas I had for optimizing vacuum, I apologize in advance if the ideas presented here are niave and don't take into account the actual code that makes up postgresql. ================ #1 ...
Alfred Perlstein
Aug 18, 2000 at 12:01 am
Oct 12, 2000 at 6:58 pm -
Hi all, I have seen discussions about iscachable attribute of functions. Now I'm confused to see a solution in 6.5 (by Shigeru Matsumoto). =# explain select * from pg_class where oid=1259; Index Scan ...
Hiroshi Inoue
Aug 31, 2000 at 8:07 am
Sep 4, 2000 at 9:07 am -
(Please cc: me in any replies. I'm not on the mailing list ATM, but I'd be happy to subscribe if that's preferred or if this turns out to be worth pursuing.) We've been toying with switching to using ...
Rob Browning
Aug 28, 2000 at 8:49 pm
Aug 29, 2000 at 4:30 pm -
I have a table for which the SEQSCAN and INDEXSCAN estimates are the same up to a point, after which the SEQSCAN estimates remain fixed, and the indexscan estimates continue to grow. However, the ...
Philip Warner
Aug 12, 2000 at 5:26 am
Aug 14, 2000 at 1:43 am -
The "target list" that's added to function-call nodes in expressions has bugged me for a long time, because it seems to clutter expression trees quite a bit (thus wasting space in stored rules, for ...
Tom Lane
Aug 3, 2000 at 10:15 pm
Aug 4, 2000 at 6:30 am -
Hi Lamar. I got around to building 7.0.2 RPMs for Mandrake, and afaict your .src.rpm built without trouble. It even got the ".bz2" man page compression right (of course, without explicitly doing this ...
Thomas Lockhart
Aug 1, 2000 at 4:17 am
Aug 1, 2000 at 5:27 pm -
Hi! About analyze.c: If taken out vacuum, couldn't it be completly taken out of pg? Say, to an external program? What's the big reason not to do that? I know that there is some code in analyze.c ...
Tiago Antão
Aug 23, 2000 at 11:17 am
Oct 15, 2000 at 6:23 pm -
Using Postgresql 7.0.2 (Linux x86, 2.2.16) CERATE FUNCTION foo(text) CREATE TABLE bar( fud TEXT CHECK (foo(fud)) ); DROP FUNCTION foo(TEXT); CREATE FUNCTION foo( .....); INSERT INTO bar VALUES ...
Thomas Swan
Aug 18, 2000 at 7:35 pm
Oct 12, 2000 at 8:25 pm -
I'm in the process of extending PostgreSQL and need a bit of advice that I don't seem to get from the manuals. - When dynamically linking functions must there be at most one function per shared ...
Brook Milligan
Aug 25, 2000 at 2:08 pm
Aug 26, 2000 at 6:53 am -
They mention Linux as one of the OS'es tested. Dont tell me they compared numbers under different OS's, like PostgreSQL on RedHat and M$Sql on NT. Thus my conclusion would be it can't be M$sql. ...
Andreas Zeugswetter
Aug 16, 2000 at 8:40 am
Aug 16, 2000 at 7:31 pm -
Is anyone working on a set of types and transformations suitable for geographic coordinates, e.g., to use in mapping or GIS applications? Do there exist any such types already? Note that I'm familiar ...
Brook Milligan
Aug 16, 2000 at 1:55 pm
Aug 16, 2000 at 6:53 pm -
Hi all, I have a question. As far as I see,constraints are stored into PG database ordinarily as follows. 1) RelationAddRawConstraints() converts each raw constaint to bin form. 2) StoreRelCheck() ...
Hiroshi Inoue
Aug 3, 2000 at 4:37 am
Aug 4, 2000 at 2:38 am -
How do pronounce PostgreSQL - the final word (pun intended). Listen to the wav file to know for sure how it's pronounced. http://www.postgresql.org/postgresql.wav And no, it's not my voice. Vince. -- ...
Vince Vielhaber
Aug 23, 2000 at 8:47 pm
Oct 15, 2000 at 7:26 pm -
Attached is a patch to allow functinal indecies to use functions that are for 'binary-compatible' types. eg create function foobar(text) returns text as .... create table vc ( a varchar ); create ...
Mark Hollomon
Aug 21, 2000 at 2:52 pm
Aug 22, 2000 at 12:39 pm -
Hi I have a big problem, when I try to lock a row locked previouly, It wait until commit / rollback operation. How could lock a row if It is not locked already? Could I now if a row is locked? Could ...
Cray2
Aug 20, 2000 at 12:55 pm
Aug 21, 2000 at 8:42 pm -
Hello, can our autoconf guru create a test for checking the availability of AF_UNIX sockets? It could be defined in config.h as HAVE_UNIX_SOCKET or similar. It will enable to use them in the newest ...
Horák Daniel
Aug 17, 2000 at 12:08 pm
Aug 21, 2000 at 9:12 am -
Barring protests, I will instruct configure and the makefiles to only look for and use Flex rather than any old Lex, since the latter won't work anyway. If at a later date someone has a burning ...
Peter Eisentraut
Aug 20, 2000 at 10:52 am
Aug 20, 2000 at 9:00 pm -
I have a friend who works at IBM on DB2, i showed her "the benchmark" just for kicks.. (we teach each other over who's is better etc.. all good fun) anyway she sends me back this article about how ...
Jeff MacDonald
Aug 18, 2000 at 4:11 pm
Aug 18, 2000 at 6:59 pm -
I didn't hear anything back on this. Does someone have a little time or a pointer to a good resource that will clarify the use of the SELECT FOR UPDATE syntax? Tim -------- Original Message -------- ...
Tim Perdue
Aug 11, 2000 at 3:35 am
Aug 11, 2000 at 4:38 am -
I've updated the LIKE code to make it more SQL9x compliant. I've left in the "permanent backslash" escape character, but I would like to remove it now. Here's why: Usually, we would want to preserve ...
Thomas Lockhart
Aug 6, 2000 at 11:57 pm
Aug 7, 2000 at 5:02 pm
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 177 |
posts | 888 |
users | 119 |
website | postgresql.org... |
irc | #postgresql |
119 users for August 2000
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)