FAQ

PostgreSQL > pgsql-hackers > March 1998

Search Discussions

253 discussions - 1,116 posts

  • Massimo, now that 6.3 is released, any chance of getting these patches against the 6.3 source code? -- Bruce Momjian | 830 Blythe Avenue maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026 + ...
    Bruce MomjianBruce Momjian
    Mar 16, 1998 at 3:07 am
    Apr 2, 1998 at 7:08 am
  • I, for one, am in favor of converting some of the type packages to loadable modules. Having those in the backend when they aren't being used is much like compiling extra modules into my Apache web ...
    Brandon IbachBrandon Ibach
    Mar 24, 1998 at 12:22 pm
    Mar 30, 1998 at 3:00 pm
  • I just finally got a copy of that article in Linux Journal (wow, they even spelt my name right!)...I think the first paragraph, in itself, is most comical: "...it is now developed similarly to Linux" ...
    The Hermit HackerThe Hermit Hacker
    Mar 2, 1998 at 8:22 pm
    Mar 4, 1998 at 9:14 pm
  • Have managed to delete char2,4,8 and 16. The char16 was tricky since it was still one of the builtins. Removed fine everywhere but the bootstrap code. Had to leave a dummy entry in the Procid array ...
    Darren KingDarren King
    Mar 23, 1998 at 2:45 pm
    Apr 26, 1998 at 4:04 am
  • Since postgres will still read the data row (even for this count(*)) I would guess, that this is a data distribution problem. Maybe you could cluster your data ? Maybe the '^rol' rows stick pretty ...
    Zeugswetter AndreasZeugswetter Andreas
    Mar 11, 1998 at 3:43 pm
    Mar 16, 1998 at 8:07 am
  • Of course a first mail after a release must have the earned praise: Very nicely done, I like it all ;-) Reading the TODO, I see 'Allow text, char(), and varchar() overhead to be only 2 bytes, not 4 ...
    Zeugswetter Andreas SARZZeugswetter Andreas SARZ
    Mar 3, 1998 at 1:42 pm
    Mar 17, 1998 at 7:50 am
  • I ran some timing tests to check the performance of varchar() vs char16. The results of the test indicate that there is no difference in performance (within the timing scatter of the tests): char16 ...
    Thomas G. LockhartThomas G. Lockhart
    Mar 11, 1998 at 2:37 pm
    Mar 19, 1998 at 6:04 pm
  • Hi, It turns of that one of the bugs I detected with Electric Fence is caused by an assumption that memory return by palloc and malloc is aligned on 8 bytes boundaries (double alignment). Adjusting ...
    Maurice GittensMaurice Gittens
    Mar 21, 1998 at 7:44 pm
    Mar 26, 1998 at 4:48 pm
  • Nice to see the MySQL crashme page has updated to its PostgreSQL title to PostgreSQL 6.3, but it seems nonee of the items haven't been updated for this release, http://www.tcx.se/crash-me.html. I see ...
    Bruce MomjianBruce Momjian
    Mar 16, 1998 at 3:31 am
    Mar 21, 1998 at 10:44 am
  • -----BEGIN PGP SIGNED MESSAGE----- I've gotten 6.3 initdb to run to a successful completion on my Alpha running OSF/1 V3.2c. Forget the change that I sent in earlier. While I still think that there's ...
    Dwayne BaileyDwayne Bailey
    Mar 16, 1998 at 9:22 pm
    Mar 20, 1998 at 3:53 am
  • Does anybody know why getrusage() in backend/port/getrusage.c is removed (surrounded by #if 0)? Some ports including Solaris 2.4, NEWS OS 6 (I'm trying now) etc. need getrusage(). -- Tatsuo Ishii ...
    T-ishiiT-ishii
    Mar 12, 1998 at 3:15 am
    Mar 12, 1998 at 9:26 pm
  • I've made a little headway -- it can't find the mkoidname function because the attributes that it looks up for the argument types have a atttypid of 0 (see the following example): also, other ...
    Brett McCormickBrett McCormick
    Mar 4, 1998 at 11:22 pm
    Mar 5, 1998 at 4:32 pm
  • I think we should depreciate the BEGIN/END keywords in SQL to allow them to be used for the new PL/SQL. So definitely leave them out of ecpg now. Only accept BEGIN WORK and BEGIN TRANSACTION. (do a ...
    Zeugswetter AndreasZeugswetter Andreas
    Mar 13, 1998 at 11:50 am
    Mar 26, 1998 at 1:26 pm
  • Hi folks, Remember me? Remember I was bitching about hashed and indexes scans not being indexed? Guess what - it magically fixed itself. If you want to talk about things that *bother* me, this one ...
    Karl DenningerKarl Denninger
    Mar 9, 1998 at 9:05 pm
    Mar 10, 1998 at 12:56 pm
  • well, it looks like we're moving postgres to a linux machine, so I won't be doing any more alpha debugging for a while (BTW, adjusting some types on the attribute struct to make it 64-bit aligned had ...
    Brett McCormickBrett McCormick
    Mar 10, 1998 at 4:15 am
    Mar 11, 1998 at 5:20 pm
  • Just thought you'd like another data point. I just installed Cristian's glibc2-2.0.7 packages. Like Thomas, I still get: postgres= select '1 min'::timespan; ?column? ------------ @ 60.00 secs (1 row) ...
    Thomas A. SzybistThomas A. Szybist
    Mar 4, 1998 at 2:58 pm
    Mar 8, 1998 at 5:40 am
  • What version of tar understands how to ungzip a .gz file? Is this what the 'z' flag is for? Untar'd and installed them manually...look good, Thomas. Nice work. darrenk
    Darren KingDarren King
    Mar 2, 1998 at 9:41 pm
    Mar 3, 1998 at 6:26 pm
  • ftp.postgresql.org/pub/patches/.test/v6.3p1beta3.gz Marc G. Fournier Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
    The Hermit HackerThe Hermit Hacker
    Mar 20, 1998 at 11:57 pm
    Apr 2, 1998 at 2:11 am
  • Hi ! Please help, the FreeBSD port update to version 6.3 drives me to despair ;-) --with-tcl configure switch doesn't work to build libpgtcl I only get it to work if I set in the make environment ...
    Andreas KlemmAndreas Klemm
    Mar 22, 1998 at 5:23 pm
    Mar 24, 1998 at 6:46 pm
  • I have noted with 2000+ records in a table (using a btree unique index on the primary key, btw) performance of a query takes 15+ minutes to respond. The query is in the structure of this select foo ...
    CoronachCoronach
    Mar 20, 1998 at 4:29 pm
    Mar 22, 1998 at 9:01 am
  • Hi, as I proposed, I'm now starting on the PL/pgSQL loadable procedural language. As far as I'm now I have a pl_handler with an independent flex/bison parser that can parse a rudimentary ...
    Jan WieckJan Wieck
    Mar 12, 1998 at 3:32 pm
    Mar 14, 1998 at 7:42 am
  • Bruce... Did I miss something here? I just looked through the migration file for 6.2.1- 6.3, and it doesn't seem to say, but how do you dump the data from a v6.2.1 database and then reload it to a ...
    The Hermit HackerThe Hermit Hacker
    Mar 8, 1998 at 11:23 pm
    Mar 10, 1998 at 3:59 am
  • Can someone tell us how "groups" work? I'm not finding enough clues just by looking in the parser, and haven't stumbled across it in the docs... Once a group is manually created with insert into ...
    Zeugswetter AndreasZeugswetter Andreas
    Mar 23, 1998 at 5:10 pm
    Mar 25, 1998 at 2:55 pm
  • I have just made a change to allow configure to properly find tcl/tk. The old code never found tk.h if it existed in /usr/include, and their were other problems. I also removed the version-specific ...
    Bruce MomjianBruce Momjian
    Mar 23, 1998 at 4:09 am
    Mar 24, 1998 at 6:24 pm
  • whew.. after some more debugging, it would appear that the problem lies somewhere in the page stuff, which I know less than nothing about. Here's the point where I'm at: heapam.c line 442 a macro ...
    Brett McCormickBrett McCormick
    Mar 7, 1998 at 12:04 am
    Mar 8, 1998 at 11:31 pm
  • Hi, just to let anyone know: I did some analyzing and searched for areas that could gain more speedups for 6.4. First I had something like an optimizer cache in mind (planner remembers parsetree and ...
    Jan WieckJan Wieck
    Mar 4, 1998 at 3:36 pm
    Mar 6, 1998 at 2:59 pm
  • I think you are getting a better result than the regression test machine gets. That's good. No, you still have date/time trouble, and it looks as though the timezone stuff is not being set properly. ...
    Thomas G. LockhartThomas G. Lockhart
    Mar 18, 1998 at 3:36 pm
    Mar 19, 1998 at 3:42 pm
  • This is going to be slightly painful to do, since it has to be done manually, but I've put up a patch against v6.3 based on reports that have come in since it was released 2 weeks ago. The patch is ...
    The Hermit HackerThe Hermit Hacker
    Mar 16, 1998 at 3:35 pm
    Mar 19, 1998 at 5:34 am
  • What do you all think about the fact that cast(anytype as varchar) results in a call to a procedure that is not creatable with 'create function'? Perhaps we should re-think our casting ...
    Brett McCormickBrett McCormick
    Mar 13, 1998 at 7:10 am
    Mar 16, 1998 at 3:34 pm
  • I think it is a time from connect to disconnect, which currently equals to backends lifetime, but may in future be shorter, if we will implement a backend pool for quick-starting servers. How are ...
    Hannu KrosingHannu Krosing
    Mar 13, 1998 at 2:45 pm
    Mar 16, 1998 at 7:30 am
  • -- Bruce Momjian | 830 Blythe Avenue maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026 + If your life is a hard drive, | (610) 353-9879(w) + Christ can be your backup. | (610) 853-3000(h)
    Bruce MomjianBruce Momjian
    Mar 11, 1998 at 3:01 pm
    Mar 14, 1998 at 9:41 am
  • don't you think there should be some sort of automatic conversion here?
    Brett McCormickBrett McCormick
    Mar 3, 1998 at 9:42 pm
    Mar 4, 1998 at 9:57 pm
  • Hi Hackers, I (and at least four others) reported strange behaviour of PG 6.3(.1), which under certain circumstances doesn't use indices like the versions before. So we still have to use 6.2.1 (now ...
    Ulrich VossUlrich Voss
    Mar 27, 1998 at 10:39 am
    Apr 3, 1998 at 7:56 pm
  • Hi, all I'm writing Reference Manual and I have two questions: 1 - Why PostgreSQL accept HOUR, MINUTE and SECOND to extract if from a date ? EXTRACT (field FROM date_expression) There are no such ...
    Jose' Soares Da SilvaJose' Soares Da Silva
    Mar 30, 1998 at 2:33 pm
    Apr 2, 1998 at 10:26 am
  • I am using the following info to migrate a table from 6.2.1 to 6.3 \connect template1 drop database magecal; create database magecal; \connect magecal \connect - julie CREATE TABLE dates (id int4, ...
    Julia A.CaseJulia A.Case
    Mar 10, 1998 at 3:04 pm
    Mar 11, 1998 at 3:53 pm
  • I had developed a "cheat" to help people convert Unix system time stored as an integer into a true date/time type. I noticed that it did not work prior to the v6.3 release, but have now gone back to ...
    Thomas G. LockhartThomas G. Lockhart
    Mar 3, 1998 at 1:53 pm
    Mar 4, 1998 at 3:04 pm
  • No way to cancel them, but it is on the TODO list. I am CC'ing Vadim on this. Looks strange. Any way we can reproduce this? Does the removal of the DISTINCT help? Are there a lot of values without ...
    Bruce MomjianBruce Momjian
    Mar 28, 1998 at 9:29 pm
    Mar 31, 1998 at 7:48 am
  • xxxx= \d logdt Table = logdt +----------------------------------+----------------------------------+-------+ Length| +----------------------------------+----------------------------------+-------+ ...
    Michal MosiewiczMichal Mosiewicz
    Mar 25, 1998 at 3:18 am
    Mar 30, 1998 at 2:37 am
  • Hi everybody, The electricfence library is a tool which helps us to detect buffer overruns in C programs. Linking Postgresql with this library gives at least 3 errors I have found until now. The ...
    Maurice GittensMaurice Gittens
    Mar 18, 1998 at 3:18 pm
    Mar 21, 1998 at 1:02 am
  • It can be complicated (especially for extensible hashing) but the theory for this seems to be on in the database handbooks under the name of 'segmented hash' or some like fancy name. The trick is to ...
    Hannu KrosingHannu Krosing
    Mar 17, 1998 at 8:15 am
    Mar 18, 1998 at 3:25 pm
  • This seems like a good idea. Any comments? -- Bruce Momjian | 830 Blythe Avenue maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026 + If your life is a hard drive, | (610) 353-9879(w) + ...
    Bruce MomjianBruce Momjian
    Mar 7, 1998 at 4:30 pm
    Mar 10, 1998 at 10:22 pm
  • To aid those of us that don't want to use sequences, can we add a feature to 6.4 that allows the use of an AUTO_INCREMENT statement when defining tables? MySQL does this, and I like it. It resembles ...
    D. Dante LorensoD. Dante Lorenso
    Mar 5, 1998 at 4:58 pm
    Mar 9, 1998 at 12:06 pm
  • Forget about my last question. I found the begin call in ecpglib.c. It doesn what you expect from a embedded SQL preprocessor, it starts a new transaction as soon as one ends. Nevertheless I thought ...
    Michael MeskesMichael Meskes
    Mar 13, 1998 at 11:01 am
    Mar 25, 1998 at 2:52 pm
  • On BSDI, 'perl' is perl4 and 'perl5' is perl5. This causes interfaces/Makefile to fail when running perl5/Makefile.PL. Does anyone else have such a problem? I don't want to fix it unless it is a ...
    Bruce MomjianBruce Momjian
    Mar 23, 1998 at 6:38 am
    Mar 23, 1998 at 5:31 pm
  • I ran some timing tests to check the performance of varchar() vs char16. The results of the test indicate that there is no difference in performance (within the timing scatter of the tests): char16 ...
    Zeugswetter AndreasZeugswetter Andreas
    Mar 11, 1998 at 3:30 pm
    Mar 19, 1998 at 9:54 pm
  • Is there a standard that defines how to return information from an embedded SQL statement? ORACLE uses the sqlca. In particular it uses sqlca.sqlerrd[2] for affected tuples. Is this correct with the ...
    Michael MeskesMichael Meskes
    Mar 17, 1998 at 3:55 pm
    Mar 19, 1998 at 6:29 pm
  • I've noticed recently that after making certain changes to the database (adding indices, attributes) they aren't immediately known about. for example, I add an attribute, then try to update that ...
    Brett McCormickBrett McCormick
    Mar 12, 1998 at 11:52 pm
    Mar 13, 1998 at 11:30 pm
  • Hi, In the file large_object/inv_api.c there is a statement in the function inv_create which goes: file_oid=newoid() + 1; later on a heap_create_with_catalog call is performed to create a heap for ...
    Maurice GittensMaurice Gittens
    Mar 6, 1998 at 3:32 pm
    Mar 10, 1998 at 6:54 pm
  • May I make a suggestion? In future versions, include the version number in the names of the libraries. Herouth
    Herouth MaozHerouth Maoz
    Mar 8, 1998 at 9:44 am
    Mar 9, 1998 at 8:27 pm
  • I'm planning to modify some string functions so that they would be aware of multi-byte strings if compiled with the multi-byte capability. Followings are files I'm going to modify. I would like to ...
    T-ishiiT-ishii
    Mar 19, 1998 at 4:10 am
    Apr 28, 1998 at 12:52 am
Mar 1998
123456
Group Navigation
period‹ prev | Mar 1998 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions253
posts1,116
users114
websitepostgresql.org...
irc#postgresql

114 users for March 1998

Bruce Momjian: 250 posts The Hermit Hacker: 107 posts Thomas G. Lockhart: 104 posts David Gould: 47 posts Michael Meskes: 44 posts Zeugswetter Andreas SARZ: 41 posts Brett McCormick: 34 posts Jan Wieck: 31 posts Darren King: 24 posts Maurice Gittens: 24 posts Tatsuo Ishii: 21 posts Vadim B. Mikheev: 21 posts Ocie: 20 posts Andrew Martin: 20 posts Pedro J. Lobo: 17 posts Mattias Kregert: 16 posts Peter T Mount: 13 posts Hannu Krosing: 12 posts Jackson, DeJuan: 12 posts Cristian Gafton: 11 posts
show more
Archives