FAQ

PostgreSQL > pgsql-hackers > September 1997

Search Discussions

188 discussions - 542 posts

  • With arrays now fixed in 6.2 beta, I have about five items left that are problems with the release. Vadim, I will need your help to solve them. - -- Bruce Momjian maillist@candle.pha.pa.us ...
    Bruce MomjianBruce Momjian
    Sep 11, 1997 at 3:41 am
    Sep 13, 1997 at 5:17 am
  • Hi, just want to say that beta 10 doesn't compiles on my Linux box (2.0.29) - -- Versions installed: zeus Kernel modules Gnu C 2.7.2.2 Binutils 2.7.0.9 Linux C Library 5.4.23 Dynamic Linker (ld.so) ...
    Oleg BartunovOleg Bartunov
    Sep 23, 1997 at 5:40 pm
    Sep 25, 1997 at 3:05 am
  • Hi: I am having a few problems compiling beta 10. My system is a 43p running AIX 4.1.5 and compiling with gcc. I've been able to get betas up through beta 9 to work. 1. backend/utils/adt/float.c ...
    D. Jay NewmanD. Jay Newman
    Sep 23, 1997 at 8:44 pm
    Sep 25, 1997 at 6:12 pm
  • Hey Webmaster(s)... Can we get this added as part of the Web site? Jose', can you help us keep it up to date? BTW..you list v6.2beta6, but you forgot to include the numbers? To the developers...why ...
    The Hermit HackerThe Hermit Hacker
    Sep 8, 1997 at 4:47 pm
    Sep 23, 1997 at 3:52 pm
  • I am starting to suspect tcp/ip or libpq library overhead. I just did a test of many inserts, and while profiling shows the backend takes 23 seconds, wallclock time on the load was 327 seconds. It is ...
    Bruce MomjianBruce Momjian
    Sep 24, 1997 at 8:03 pm
    Sep 25, 1997 at 8:56 pm
  • I have changed uint32 to unsigned int. - -- Bruce Momjian maillist@candle.pha.pa.us ------------------------------
    Bruce MomjianBruce Momjian
    Sep 16, 1997 at 4:08 pm
    Sep 19, 1997 at 12:11 pm
  • Marc, I'm not sure exactly how things work on the different platforms, but the recent changes to support "linuxalpha" had the annoying side effect that _my_ linux box (formerly a linux-elf machine :) ...
    Thomas G. LockhartThomas G. Lockhart
    Sep 20, 1997 at 11:29 pm
    Sep 23, 1997 at 12:55 am
  • When can I run PGINDENT? Does anyone have outstanding patches they want to apply before I run it? I have recently modified PGINDENT so it will not over-indent block comments if you run it several ...
    Bruce MomjianBruce Momjian
    Sep 4, 1997 at 9:34 pm
    Sep 8, 1997 at 12:45 am
  • I've sent a patch to the patches list to provide the missing multiply and divide functions for the money type. Previously, one could only do "_money * _float8" and "_money / _float8". The patch ...
    Darren KingDarren King
    Sep 19, 1997 at 4:47 pm
    Sep 22, 1997 at 6:28 pm
  • Hi all, I've just tried building from the CVS tree as of this afternoon and got the following error:- gmake[2]: Leaving directory `/postgres95/src/backend/utils' gcc -o postgres access/SUBSYS.o ...
    Keith ParksKeith Parks
    Sep 6, 1997 at 5:16 pm
    Sep 9, 1997 at 7:32 pm
  • I would sure like to change our comment characters from -- to //, now that we have /* */ comments from Thomas. We can keep -- for backward compatability. This would make us consistent with C++. ...
    Bruce MomjianBruce Momjian
    Sep 4, 1997 at 7:16 pm
    Sep 7, 1997 at 1:43 am
  • Still a problem with beta10 and java? Marc, ideas? - -- Bruce Momjian maillist@candle.pha.pa.us ------------------------------
    Bruce MomjianBruce Momjian
    Sep 24, 1997 at 3:57 pm
    Sep 25, 1997 at 2:55 pm
  • (I've been asking in the Questions-list and in a couple of Newsgroups) In short: ORDER BY Name returns first 'a-z' and then mutated vowels but I would like to have mutated vowels near the vowles. ...
    Marcus BauerMarcus Bauer
    Sep 21, 1997 at 8:41 am
    Sep 23, 1997 at 6:09 pm
  • Thanks Vadim! I'm going to commit changes then, since Marc wanted basic v6.2 functionality committed by Sept 1, and will then work on the no-trick DEFAULT and CHECK parsing, which should come along ...
    Thomas G. LockhartThomas G. Lockhart
    Sep 1, 1997 at 1:09 am
    Sep 4, 1997 at 5:39 am
  • I have found a problem. It appears the backslashes are being eaten, rather than being converted and inserted into the string. In the second and third inserts, their should be a backslash in the ...
    Bruce MomjianBruce Momjian
    Sep 24, 1997 at 6:22 pm
    Sep 25, 1997 at 4:22 pm
  • (In statistics below 1st line is user/system time, 2nd line is direct blocks read/written by tape method). I. ORDER BY perfomance using -S 128, -S 512 and -S 1024 for tables with 100 000 tuples (=~ ...
    Vadim B. MikheevVadim B. Mikheev
    Sep 17, 1997 at 9:44 am
    Sep 18, 1997 at 4:09 am
  • - --==_Exmh_219990984P Content-Type: multipart/mixed ; boundary="==_Exmh_2199820240" This is a multipart MIME message. - --==_Exmh_2199820240 Content-Type: text/plain; charset=us-ascii Machine: ...
    Oliver ElphickOliver Elphick
    Sep 16, 1997 at 11:48 am
    Sep 18, 1997 at 3:33 am
  • Can we get a new beta before I announce the list of changes in 6.2 to the questions list? I want a new one so any patches will use the new source code format. - -- Bruce Momjian ...
    Bruce MomjianBruce Momjian
    Sep 13, 1997 at 2:11 am
    Sep 13, 1997 at 9:12 pm
  • I ran the regression tests in 6.2beta5. This was on a Linux Pentium Pro with libc6. There were various errors which will go away when the expected data is revised, but I found the following problems: ...
    Oliver ElphickOliver Elphick
    Sep 9, 1997 at 9:10 am
    Sep 10, 1997 at 8:55 am
  • The freeze is only meant to occur once so that a current set of documentation can be produced. The idea is that this documentation should be of a sufficiently high standard that it is easy for others ...
    Eze OgwumaEze Ogwuma
    Sep 30, 1997 at 3:32 pm
    Sep 30, 1997 at 11:10 pm
  • Anyone else need functions to multiply and divide Cash by integers, not just float8? Say, rename existing cash_mul/div to cash_fmul/fdiv and create cash_imul/idiv and cash_smul/sdiv for int4 and ...
    Darren KingDarren King
    Sep 17, 1997 at 7:44 pm
    Sep 18, 1997 at 8:15 pm
  • Hi all, I'm seeing some strange problems with the parser, look at this:- (The data was restored from a previous dump) I see "day" is a keyword now. calendar= \d Database = calendar ...
    Keith ParksKeith Parks
    Sep 6, 1997 at 9:16 pm
    Sep 7, 1997 at 2:43 pm
  • Marc, I have some preliminary results: Postgres MySql 1000 rec insert 27 11 " " select 33 20 10,000 rec insert 273 111 " " Error 8M Seg Fault These tests were run from PHP, not Perl, and I didn't ...
    Charles HallCharles Hall
    Sep 24, 1997 at 6:06 pm
    Sep 25, 1997 at 3:46 am
  • We are only going to get major performance improvments on INSERT/UPDATE/DELETE when we remove time travel? Vadim, is that true? I think you had indicated it was. - -- Bruce Momjian ...
    Bruce MomjianBruce Momjian
    Sep 19, 1997 at 10:12 pm
    Sep 22, 1997 at 4:10 pm
  • from current CVS: initdb: creating template database in /home/postgres/data/base/template1 Running: postgres -boot -C -F -D/home/postgres/data -Q template1 Failed Assertion("!(proc- sLocks[i] == ...
    Vadim B. MikheevVadim B. Mikheev
    Sep 22, 1997 at 3:54 am
    Sep 22, 1997 at 4:09 pm
  • First of all, sorry my poor English. This is not my native language. When PostgreSql will be released in a CD-ROM, much more people will use it. This implies that will be more requests for technical ...
    Claudio R ZamanaClaudio R Zamana
    Sep 18, 1997 at 1:09 pm
    Sep 19, 1997 at 3:04 am
  • I ran strace on 6.2beta6 and found out that the backend does a lot of useless system calls. Perhaps this useless consumption of CPU cycles could be eliminated (and speed up execution)? The backend... ...
    Mattias KregertMattias Kregert
    Sep 13, 1997 at 1:30 pm
    Sep 15, 1997 at 2:00 am
  • I have been thinking about how people choose a free database, and what they look for. These are the items I think they consider, in this order. How do we rate? Is the order correct? The question ...
    Bruce MomjianBruce Momjian
    Sep 14, 1997 at 12:07 am
    Sep 14, 1997 at 6:46 pm
  • Here is what I have. Does anyone have changes/additions? Vadim, I am a little confused about what will be in 6.2. Triggers, contraints, etc. Bug Fixes - --------- Fix problems with pg_dump for ...
    Bruce MomjianBruce Momjian
    Sep 12, 1997 at 7:43 pm
    Sep 13, 1997 at 5:34 pm
  • In a related note, why does my type conversion of treating cash as int4 work? I know they are both int4, but doesn't cash store 1 differently than an int4 of 1? test= select * from testc where x < ...
    Bruce MomjianBruce Momjian
    Sep 10, 1997 at 1:31 am
    Sep 11, 1997 at 1:55 pm
  • plaut= \h alter table ... alter table <class_name1 rename to <class_name2 Bye! - ---- Michael Reifenberger Plaut Software GmbH, R/3 Basis ------------------------------
    Michael ReifenbergerMichael Reifenberger
    Sep 1, 1997 at 12:57 pm
    Sep 3, 1997 at 2:36 pm
  • This is a multi-part message in MIME format. - --------------55D8B421222A02884BA57E2B Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Oh, thanks, Tatsuo! Keith, Mike - does ...
    Vadim B. MikheevVadim B. Mikheev
    Sep 25, 1997 at 3:36 am
    Sep 25, 1997 at 4:54 pm
  • pgsql 6.2beta10 On Linux 2.0.30 Pentium 75 GCC 2.7.2.1 libc.so.5.4.23 ld.so: version 1.9.5 flex version 2.5.2 Regression test horology .. failed. See attached. Otherwise everything look great. Perl5 ...
    Paul HoPaul Ho
    Sep 24, 1997 at 5:06 pm
    Sep 25, 1997 at 1:26 pm
  • Hi everyone. Well I have just tried out the 6.2 beta of postgresql and I think I have stumbled across a bug. I imported a table of about 20000 records into it and did the following query on the ...
    Michael J SchoutMichael J Schout
    Sep 25, 1997 at 2:54 am
    Sep 25, 1997 at 4:07 am
  • I have found the solutin to the HUPIX 10.20 link failure. There are som duplicate routines in libPW and libc. libc routines should be used, but the default compile finds them in libPW first. The fix ...
    Stan BrownStan Brown
    Sep 23, 1997 at 11:21 pm
    Sep 24, 1997 at 4:23 am
  • Vadim... You had asked for me to wait a few extra days...have those elapsed, or would you like me to wait a couple of more? Marc G. Fournier Systems Administrator @ hub.org primary: scrappy@hub.org ...
    The Hermit HackerThe Hermit Hacker
    Sep 20, 1997 at 1:14 pm
    Sep 23, 1997 at 1:54 am
  • of I had to do a few more things, besides those you list, to compile and install under AIX 3.2.5: 1- configure - put missing square brackets around 'a-z' and ':lower:' for tr tests; - put missing ...
    Fidelis AssisFidelis Assis
    Sep 22, 1997 at 2:48 pm
    Sep 23, 1997 at 1:18 am
  • On a related note, psql used to allow you to run a query, then type \e to edit the query you just ran, or \p to see the query you just ran. What psql does is to keep the old query in the buffer until ...
    Bruce MomjianBruce Momjian
    Sep 18, 1997 at 5:04 pm
    Sep 19, 1997 at 4:26 pm
  • I have added a MemSet macro to c.h, and replaces calls to memset() to MemSet(). As you will see in c.h, the macro does an int copy of zero's if the start and end are int aligned, the value to be ...
    Bruce MomjianBruce Momjian
    Sep 18, 1997 at 8:20 pm
    Sep 19, 1997 at 3:40 pm
  • Going through old mail from April... (For Postgres) Neither of my reference texts indicate that the parentheses are allowed. However, COLUMN is optional in the standard and will become optional for ...
    Thomas G. LockhartThomas G. Lockhart
    Sep 18, 1997 at 2:17 am
    Sep 18, 1997 at 2:25 pm
  • I. ORDER BY perfomance using -S 128 and -S 512 for tables with 100 000 tuples (=~ 6M) of int4 (table SASC pre-sorted, table SUNS unsorted; psort used tape files): 1. select * from SASC order by x: -S ...
    Vadim B. MikheevVadim B. Mikheev
    Sep 15, 1997 at 4:51 pm
    Sep 17, 1997 at 3:48 am
  • It seems v6.2beta6 did not build cleanly out of the box on my Solaris 2.5 system. The fix was easy see below Please e-mail if the following is not clear. I attempted to build ...
    Chris AlbertsonChris Albertson
    Sep 13, 1997 at 2:10 am
    Sep 15, 1997 at 9:38 pm
  • Beta8 has been created... Code is frozen as of midnight tonight, today being the 14th. No new features, no new extensions...we have two weeks to make this rock solid! Marc G. Fournier scrappy@hub.org ...
    The Hermit HackerThe Hermit Hacker
    Sep 14, 1997 at 8:48 am
    Sep 15, 1997 at 12:04 am
  • I have completed running PGINDENT on all the *.c and *.h files, except the C++ files. I will do the lex/yacc files by hand. People using sup or cvsup, you might as well delete all your source code ...
    Bruce MomjianBruce Momjian
    Sep 7, 1997 at 5:23 am
    Sep 8, 1997 at 4:29 am
  • Is there any way for me to request a CVS update of source? CVSup gives me this: (very helpful, eh?) Connected to postgresql.org Falling back to protocol version 15.1 Timed out waiting for connection ...
    Teunis PetersTeunis Peters
    Sep 25, 1997 at 9:48 pm
    Sep 25, 1997 at 11:17 pm
  • Marc, I went ahead and installed the Perl interfaces for MySql and Postgres. Both tests run OK now, so PHP was the culprit. Here are the results for a test inserting 1000 & 8000 random 156-byte ...
    Charles HallCharles Hall
    Sep 25, 1997 at 4:06 pm
    Sep 25, 1997 at 9:01 pm
  • (redirected from questions) vchar() is not a Postgres data type. Try varchar()... - Tom ------------------------------
    Thomas G. LockhartThomas G. Lockhart
    Sep 24, 1997 at 4:27 pm
    Sep 25, 1997 at 1:34 am
  • Hello, I think this was discussed in the past... :) [---] Neil D. Quiogue (neil@iphil.net) IPhil Communications Network, Inc. Other: neil@postgresql.org - ---------- Forwarded message ---------- ...
    Neil d. quiogueNeil d. quiogue
    Sep 24, 1997 at 12:29 am
    Sep 24, 1997 at 2:38 am
  • Ah, thanks for finding this. I had mis-read the SQL/92 specification and was forcing a length of one for varchar. In fact, the implicit length of one is only for "char". Actually, according to the ...
    Thomas G. LockhartThomas G. Lockhart
    Sep 23, 1997 at 2:19 pm
    Sep 23, 1997 at 9:15 pm
  • I've just committed a bunch of small changes to the regression test to try to force more ordering in the output results. On my installation, several tests showed ordering differences, in addition to ...
    Thomas G. LockhartThomas G. Lockhart
    Sep 20, 1997 at 4:49 pm
    Sep 23, 1997 at 1:49 am
Sep 1997
1234
Group Navigation
period‹ prev | Sep 1997 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions188
posts542
users82
websitepostgresql.org...
irc#postgresql

82 users for September 1997

Bruce Momjian: 165 posts The Hermit Hacker: 60 posts Thomas G. Lockhart: 50 posts Vadim B. Mikheev: 47 posts Keith Parks: 19 posts Teunis Peters: 11 posts Darren King: 9 posts Mattias Kregert: 9 posts Oliver Elphick: 8 posts : 7 posts Eze Ogwuma: 7 posts Frank Dana: 7 posts Henry B. Hotz: 7 posts Oleg Bartunov: 7 posts Peter T Mount: 7 posts Gerhard Reithofer: 6 posts Stan Brown: 6 posts Adrian Hall: 5 posts Charles Hall: 5 posts Neil d. quiogue: 5 posts
show more
Archives