FAQ

Search Discussions

108 discussions - 391 posts

  • I've never seen a precise description of the samantics of LIMIT. It's not in any SQL standard I've ever seen, and no widely-used commercial database supports it. Bill - -- "The best book on ...
    Bill BrooksBill Brooks
    Jul 23, 1997 at 4:00 pm
    Jul 30, 1997 at 12:23 pm
  • Today, I have added four new ports to the list of supported platform/os's. (Thanks to Tatsuo Ishii for some of these.) They are: SCO 3.2v5 HP-UX 10 mkLinux(PowerPC) SunOS4(was broken in 6.1 and ...
    Bruce MomjianBruce Momjian
    Jul 29, 1997 at 4:45 pm
    Jul 31, 1997 at 1:44 am
  • Here is a list of fixes in 6.1.1. Did I miss anything? - --------------------------------------------------------------------------- fix for SET with options (Thomas) fix leap year boundary ...
    Bruce MomjianBruce Momjian
    Jul 12, 1997 at 4:01 pm
    Jul 16, 1997 at 2:57 pm
  • Are we still scheduled for a 6.1p1 release? We are continuing to get inter-platform endian bug reports, and missing ENDIAN define bug reports, and we have fixed a few latent bugs. I think it is worth ...
    Bruce MomjianBruce Momjian
    Jul 1, 1997 at 2:04 pm
    Jul 7, 1997 at 10:03 pm
  • I have generated my own beta patch for 6.1.1. It is at: ftp://ftp.postgresql.org/pub/patches/postgresql-v6.1.1-beta.gz It is 96k and applies over the stock 6.1 release. Let's plan on a final 6.1.1 ...
    Bruce MomjianBruce Momjian
    Jul 17, 1997 at 12:59 am
    Jul 18, 1997 at 2:19 pm
  • Hello, It repeats in many questions that people would like less overhead for each execution of postgres. Someone proposed to start more daemons at the begining like apache does. As far as I remember ...
    Michał MosiewiczMichał Mosiewicz
    Jul 25, 1997 at 2:30 pm
    Jul 26, 1997 at 5:00 pm
  • This message is in MIME format. The first part should be readable text, while the remaining parts are likely unreadable without MIME-aware tools. Send mail to mime@docserver.cac.washington.edu for ...
    Gerhard ReithoferGerhard Reithofer
    Jul 1, 1997 at 9:08 pm
    Jul 14, 1997 at 1:50 am
  • Hi to all Hackers, ========================================================================= Tatsuo Ishii's patch (I think it was his path?) repaired the "wrong-reversed" byte order in pqcomprim.c ...
    Gerhard ReithoferGerhard Reithofer
    Jul 4, 1997 at 8:55 am
    Jul 9, 1997 at 2:30 pm
  • Hi to all endians ;-) Maybe my mail was lost again, I'll repost it here into the list only. Best regards Gerhard PS: I always suggested to use NEVER *ENDIAN #defines. - ---------- Forwarded message ...
    Gerhard ReithoferGerhard Reithofer
    Jul 9, 1997 at 9:08 am
    Jul 11, 1997 at 5:24 am
  • Here is the list of platforms we support. Any changes? aix IBM on AIX 3.2.5 or 4.x alpha DEC Alpha AXP on OSF/1 2.0 BSD44_derived OSs derived from 4.4-lite BSD (NetBSD, FreeBSD) bsdi BSD/OS 2.0, ...
    Bruce MomjianBruce Momjian
    Jul 13, 1997 at 7:39 pm
    Jul 15, 1997 at 12:54 am
  • Hello, I've just noticed how painful may be doing maths in postgres. I run a command like: SELECT i, sum(x * y) FROM blabla GROUP BY i; where x - money y - float4 After a few tries I managed to ...
    Michał MosiewiczMichał Mosiewicz
    Jul 21, 1997 at 12:49 am
    Jul 24, 1997 at 2:36 am
  • One notes that the web site hasn't been updated since 27 April - thus not even the 6.1 release is noted as yet.... Or am I the only one noticing this? Adrian ------------------------------ End of ...
    AdrianAdrian
    Jul 16, 1997 at 2:21 am
    Jul 18, 1997 at 9:10 pm
  • I was scanning some Linux-related newsgroups, and came across the following, from an announcement that Postgres 6.1 was available as a RPM package: : What is it?: : - ------------ : PostgreSQL ...
    Bill BrooksBill Brooks
    Jul 14, 1997 at 6:45 pm
    Jul 30, 1997 at 11:49 pm
  • I have updated the HISTORY, FAQ, and TODO files for the 6.1.1 release. Marc, go...go...go. - -- Bruce Momjian maillist@candle.pha.pa.us ------------------------------
    Bruce MomjianBruce Momjian
    Jul 21, 1997 at 10:28 pm
    Jul 23, 1997 at 12:46 am
  • Can we make a /pub/patches/v6.1.1 directory which could contain Tatsuo's (and other's) port patches and Bruce's pg_dump patches? That would greatly reduce the necessity for v6.1.2, since the number ...
    Thomas G. LockhartThomas G. Lockhart
    Jul 24, 1997 at 2:15 am
    Jul 26, 1997 at 3:57 am
  • Aren't we generating a diff for 6.1.1 for 6.1 users? I don't see one on the ftp site. - -- Bruce Momjian maillist@candle.pha.pa.us ------------------------------
    Bruce MomjianBruce Momjian
    Jul 22, 1997 at 3:36 pm
    Jul 23, 1997 at 2:33 am
  • Is this valid: UPDATE test SET test.x = 3; or is only this valid: UPDATE test SET x = 3; - -- Bruce Momjian maillist@candle.pha.pa.us ------------------------------ End of hackers-digest V1 #414 ...
    Bruce MomjianBruce Momjian
    Jul 9, 1997 at 11:34 pm
    Jul 14, 1997 at 9:19 pm
  • Illustra and other SQL DB's have a 'REFERENCES' clause that enforces this kind of integrity. My understanding of references might be wrong, but it sounds like what this question is about. Postgresql ...
    Jason L. WrightJason L. Wright
    Jul 29, 1997 at 10:00 pm
    Jul 30, 1997 at 3:04 am
  • Hello, It seems that sequences are not locked properly. Here is what I noticed... I'm running two parallel sessions (A and B): A: BEGIN; A: INSERT INTO sometable (id, x, y, z) VALUES ( ...
    Michał MosiewiczMichał Mosiewicz
    Jul 17, 1997 at 10:04 pm
    Jul 29, 1997 at 2:46 am
  • I picked up the 6.1.1 distribution and I'm having troubles. Despite claims in the announcement ("New RDBMS database PostgreSQL 6.1 for Windows 95/NT released" crossposted 6/16/97) there is no build ...
    Kmorris692Kmorris692
    Jul 25, 1997 at 6:27 pm
    Jul 26, 1997 at 5:52 am
  • Tom, Yes, sorry, the Makefiles aren't portable yet. It's easy to build it by hand though. Chdir into each of the following directories in the given order, and in each one type "m3build": suptcp ...
    John PolstraJohn Polstra
    Jul 21, 1997 at 6:44 pm
    Jul 22, 1997 at 5:23 am
  • Any comments on this. The patch was not included in the posting, but I could get it. I am not sure about the usefulness of restarting the postmaster with a sighup. Wouldn't it be better to physically ...
    Bruce MomjianBruce Momjian
    Jul 8, 1997 at 10:21 pm
    Jul 12, 1997 at 2:32 pm
  • I now getting many compile warnings about ENDIAN-ness. Should we have these defines nested in #ifndef's? - --------------------------------------------------------------------------- gcc2 ...
    Bruce MomjianBruce Momjian
    Jul 9, 1997 at 3:23 am
    Jul 9, 1997 at 10:39 am
  • It wants a BSD version of the install program. There's one in /usr/ucb on Solaris machines. I didn't have this problem, perhaps because I have /usr/ucb early in my $path. (This improves the ...
    Henry B. HotzHenry B. Hotz
    Jul 30, 1997 at 12:42 am
    Jul 30, 1997 at 1:52 am
  • Dear folks, I have been compiling postgresql till version 6, and get the same old problem. During compilation time I get errors about the use of RUSAGE.=20 In version 6.0 I had to add "-Wno-error ...
    Ricardo Ferraro G. da SilvaRicardo Ferraro G. da Silva
    Jul 29, 1997 at 11:31 pm
    Jul 30, 1997 at 12:49 am
  • Hi, Here's a path for PQprint to print "(null)" in null fileds. BTW, I'm begining to work on column constraints, first by the "not null" constraint, and, after that, there's plans to write the code ...
    Robson Paniago de MirandaRobson Paniago de Miranda
    Jul 25, 1997 at 4:41 pm
    Jul 25, 1997 at 10:03 pm
  • This is a bad idea in my opinion. Postgres child should be started after *successful authentication* of the user. Otherwise you put yourself under a 'Denial of Service' attack by allowing people for ...
    Michał MosiewiczMichał Mosiewicz
    Jul 17, 1997 at 9:39 am
    Jul 25, 1997 at 5:08 pm
  • Dear Sirs, Our group are now trying to porting the Postgres95 to Origin 2000. Now we need to regenerate all the files in directory of data/base/template1. There is little details in the manual about ...
    Qiang caoQiang cao
    Jul 22, 1997 at 8:21 pm
    Jul 22, 1997 at 10:03 pm
  • This is very minor I know, but did the ..../src/template/.similar file get updated to guess the portname correctly for Irix 5.3. the following line needs to be added to the file: ...
    Andrew MartinAndrew Martin
    Jul 15, 1997 at 5:04 pm
    Jul 15, 1997 at 11:10 pm
  • Will somebody please tell me how to get off this list I have asked and asked and tried everything I can think of but every time a retrieve my email at least 50 messages are from this group. Now I ...
    Fergal MoranFergal Moran
    Jul 14, 1997 at 11:22 am
    Jul 15, 1997 at 2:31 pm
  • We do have some new features in 6.1p1, and I will document them when a release date is set. Do we name this 6.1p1 or 6.2? I vote for 6.2, and provide a patch to 6.1 and a full 6.2 tar file on the ftp ...
    Bruce MomjianBruce Momjian
    Jul 8, 1997 at 12:59 am
    Jul 8, 1997 at 6:30 pm
  • Hi... There is currently a file in ftp.postgresql.org/pub/6.2 called postgresql-v6.1-chngs-p1.tar.gz that is a snapshot of the *changes* since v6.1 was released... I'm going to change the cron jobs ...
    Marc G. FournierMarc G. Fournier
    Jul 1, 1997 at 7:42 pm
    Jul 2, 1997 at 2:41 am
  • Installed. - -- Bruce Momjian maillist@candle.pha.pa.us ------------------------------
    Bruce MomjianBruce Momjian
    Jul 31, 1997 at 3:46 am
    Jul 31, 1997 at 3:46 pm
  • IMHO, stored procedures/triggers are the basis for referential integrity. Once you've got triggers, its trivial to implemement foreign keys, references or cascading whatevers as triggers that the ...
    Sean LyndersaySean Lyndersay
    Jul 30, 1997 at 2:15 pm
    Jul 31, 1997 at 2:05 am
  • I've deposited a statically built cvsup client executable (and man pages and test configuration) in /pub/incoming/cvsup-15.1-client-linux.tar.gz This was built and linked on Linux/v2.0.30, RH/v4.2, ...
    Thomas G. LockhartThomas G. Lockhart
    Jul 30, 1997 at 5:46 am
    Jul 30, 1997 at 8:29 am
  • unsubscribe pgsql-hackers leskor@hron.fei.tuke.sk ------------------------------
    Gord PusnikGord Pusnik
    Jul 1, 1997 at 1:34 pm
    Jul 30, 1997 at 7:13 am
  • Just looking into this for work related tracking, and looking at the web site, it looks cool. Any comments on whether this would help us any? Marc G. Fournier scrappy@hub.org Systems Administrator @ ...
    The Hermit HackerThe Hermit Hacker
    Jul 29, 1997 at 7:21 pm
    Jul 29, 1997 at 7:52 pm
  • Yea! I was waiting. I worried, "Gee, what if Vadim comes back from vacation and decides he doesn't want to work on PostgreSQL anymore." [For those who don't know, Vadim is our most knowledgeable ...
    Bruce MomjianBruce Momjian
    Jul 29, 1997 at 1:32 am
    Jul 29, 1997 at 1:40 am
  • I got no comments, hope you did not noticed the suggestion ??? [CUT] You (we?) might do the following: 1.Apply the feature someone already developped to make libpq to return tuples to the application ...
    PostgreSQLPostgreSQL
    Jul 28, 1997 at 8:48 am
    Jul 28, 1997 at 3:04 pm
  • Only Vadim and the GEQO author knows that. There is overhead with geqo, but I don't know how much. - -- Bruce Momjian maillist@candle.pha.pa.us ------------------------------
    Bruce MomjianBruce Momjian
    Jul 24, 1997 at 5:57 pm
    Jul 24, 1997 at 8:49 pm
  • Good luck. Let's face it, this source uses a huge number of Unix features that really requires an almost 100% capable environment to run. I believe other people are working on this too. Check the ...
    Bruce MomjianBruce Momjian
    Jul 23, 1997 at 5:44 pm
    Jul 23, 1997 at 6:10 pm
  • Hi, I am a novice of PostgreSQL and I am looking for an odbc driver for Win95 and Win 3.x. Somebody can help me ? Thanks in advance. - ----------------------------------------------- Fabrizio Fachin ...
    FabriFabri
    Jul 23, 1997 at 2:10 pm
    Jul 23, 1997 at 4:09 pm
  • Excellent question. It certainly should not be doing this. - -- Bruce Momjian maillist@candle.pha.pa.us ------------------------------
    Bruce MomjianBruce Momjian
    Jul 22, 1997 at 7:11 pm
    Jul 23, 1997 at 2:05 pm
  • for a SQL server on OpenStep 4.x on Intel and am willing to port. My goal is a working EOF SQL adaptor against a postgesSQL implementation on OpenStep. From the list of unix systems on which ...
    David E FleskesDavid E Fleskes
    Jul 23, 1997 at 3:26 am
    Jul 23, 1997 at 3:35 am
  • Hiya... Once the new RAM is installed in the machine, I'm going to be migrating things over to CVSup, instead of sup. Most of you would have seen the message that John Poltra(sp?) put up about the ...
    Marc G. FournierMarc G. Fournier
    Jul 22, 1997 at 12:08 am
    Jul 22, 1997 at 12:50 am
  • I finally got the 6.1.1 beta patch installed on top of a clean 6.1 under Irix and there seem to be lots of problems. First the Beta2 patch file (like the Beta1) leaves loads of junk in the top ...
    Andrew MartinAndrew Martin
    Jul 18, 1997 at 3:34 pm
    Jul 18, 1997 at 4:29 pm
  • This is a multi-part message in MIME format. - --------------2C2D89E23381B3214A0215AC Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit - -- - ...
    David N. CicaloDavid N. Cicalo
    Jul 17, 1997 at 8:00 am
    Jul 17, 1997 at 8:16 am
  • Let's have a table : create solduri (cont char16, debit float8[], credit float8[]); and populate it : insert into solduri values('401','{1,2,3}','{4,5,6}'); The following query : update solduri set ...
    Constantin TeodorescuConstantin Teodorescu
    Jul 1, 1997 at 4:30 pm
    Jul 9, 1997 at 12:54 pm
  • Hi Gurus and Wizards I Have a question with the aggregate functions. In what file of the source where I can find these ?? I need to write another aggregate, and i want to take these like examples. ...
    AlvaroAlvaro
    Jul 8, 1997 at 4:14 pm
    Jul 8, 1997 at 6:28 pm
  • Hi - thanks but initdb dumps core without the debug option. In addition, version 6.1p1 appears to have at least one initdb patch (i.e., the 'print' problem patch which was posted on July 1 in ...
    Kenneth SimpsonKenneth Simpson
    Jul 4, 1997 at 6:06 pm
    Jul 4, 1997 at 7:12 pm
Group Navigation
period‹ prev | Jul 1997 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions108
posts391
users72
websitepostgresql.org...
irc#postgresql

72 users for July 1997

Bruce Momjian: 118 posts The Hermit Hacker: 50 posts Thomas G. Lockhart: 24 posts Maarten Boekhold: 16 posts Andrew Martin: 13 posts Henry B. Hotz: 12 posts Gerhard Reithofer: 11 posts Frank Dana: 10 posts Michał Mosiewicz: 8 posts Tatsuo Ishii: 8 posts Bill Brooks: 7 posts Michael J. Miller Jr.: 7 posts Igor: 6 posts Vadim B. Mikheev: 6 posts Thomas G. Lockhart: 5 posts Adrian Hall: 4 posts Darren King: 4 posts John Polstra: 4 posts Martin J. Laubach: 4 posts Massimo Dal Zotto: 4 posts
show more
Archives