Search Discussions

177 discussions - 888 posts

  • 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. ReedstromRoss 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 BeanJules 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 KrosingHannu 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 IshiiTatsuo 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 HollomonMark 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 RasmussenKaare Rasmussen
    Aug 9, 2000 at 3:51 pm
    Oct 12, 2000 at 4:55 pm
  • 23


    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 RosenmanLarry 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 MilliganBrook 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 HackerThe 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 LaneTom 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 khalsaSuchet 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 LaneTom 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 PerlsteinAlfred 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 LockhartThomas 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 SelleAndrew 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 LaneTom 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 ZeugswetterAndreas 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 WeilguniMario 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 HollomonMark 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 HollomonMark 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 HackerThe 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 EisentrautPeter 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 LockhartThomas 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 LaneTom 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 McKownJohn 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 WarnerPhilip 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 LaneTom 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 SzaboStephan 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 LaneTom 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 ReinaG. 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 PerlsteinAlfred 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 InoueHiroshi 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 BrowningRob 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 WarnerPhilip 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 LaneTom 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 LockhartThomas 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ãoTiago 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 SwanThomas 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 MilliganBrook 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 ZeugswetterAndreas 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 MilliganBrook 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 InoueHiroshi 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 VielhaberVince 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 HollomonMark 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 ...
    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 DanielHorá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 EisentrautPeter 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 MacDonaldJeff 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 PerdueTim 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 LockhartThomas Lockhart
    Aug 6, 2000 at 11:57 pm
    Aug 7, 2000 at 5:02 pm
Group Navigation
period‹ prev | Aug 2000 | next ›
Group Overview
grouppgsql-hackers @

119 users for August 2000

Tom Lane: 152 posts Thomas Lockhart: 76 posts The Hermit Hacker: 55 posts Don Baccus: 48 posts Philip Warner: 41 posts Ross J. Reedstrom: 26 posts Vince Vielhaber: 23 posts Chris Bitmead: 22 posts Stephan Szabo: 22 posts Bruce Momjian: 20 posts Andreas Zeugswetter: 18 posts Peter Eisentraut: 17 posts Hannu Krosing: 16 posts Thomas Swan: 16 posts Alfred Perlstein: 15 posts Mark Hollomon: 14 posts Tatsuo Ishii: 13 posts Larry Rosenman: 12 posts Magnus Hagander: 12 posts Brook Milligan: 11 posts
show more