FAQ

PostgreSQL > pgsql-hackers > December 1998

Search Discussions

147 discussions - 591 posts

  • Hello! The following gave me wrong result: xxx= select datetime(current_date, '11:00'); datetime ---------------------------- Thu 03 Dec 17:00:00 1998 MSK (1 row) and I started investigation. Soon I ...
    Oleg BroytmannOleg Broytmann
    Dec 3, 1998 at 7:00 pm
    Dec 23, 1998 at 4:33 pm
  • Bruce MomjianBruce Momjian
    Dec 18, 1998 at 7:33 am
    Dec 21, 1998 at 12:56 pm
  • CVS is just updated... Please try concurrent writes/reads... It'll take some time to implement READ COMMITTED mode... Note: 1. Vacuum is not updated yet and so will remove deleted tuples though some ...
    Vadim MikheevVadim Mikheev
    Dec 16, 1998 at 5:02 pm
    Jan 12, 1999 at 12:38 am
  • Well, I've started looking through my books for info on joins. The cross join was pretty easy: postgres= select * from (a cross join b); i| j|i| k -+----+-+-- 1|10.1|1|-1 2|20.2|1|-1 4| |1|-1 <snip ...
    Thomas G. LockhartThomas G. Lockhart
    Dec 11, 1998 at 6:35 am
    Jan 12, 1999 at 3:58 pm
  • When are we doing it? With two development trees, we don't seem to have any motivation to release it. I think we should release 6.4.1 soon. -- Bruce Momjian | http://www.op.net/~candle ...
    Bruce MomjianBruce Momjian
    Dec 10, 1998 at 7:16 pm
    Dec 14, 1998 at 6:47 pm
  • Hi, I tried to compile 6.4 with latest egcs and have experienced problem to compile several files on my Linux x86 box. Sorry, I don't remember right now actually what files but will reinstall egcs ...
    Oleg BartunovOleg Bartunov
    Dec 8, 1998 at 3:00 pm
    Dec 14, 1998 at 5:35 am
  • ... in SELECT * FROM street; Vadim
    Vadim MikheevVadim Mikheev
    Dec 16, 1998 at 11:01 am
    Jan 17, 1999 at 12:13 pm
  • Hi all, I tried to divide 123.45 by 123.00 but PostgreSQL gives me a wrong result: hygea= select 123.45 - 123.00; ?column? ----------------- 0.450000000000003 (1 row) -Jose'-
    Sferacarta SoftwareSferacarta Software
    Dec 15, 1998 at 12:40 pm
    Dec 16, 1998 at 5:19 am
  • Two small patches are attached, both against current CVS: 1. Some security, since we now have vsnprintf, I remade an old patch with some extra ugly sprintfs fixed. More work in this area is needed ...
    Goran ThyniGoran Thyni
    Dec 31, 1998 at 9:26 pm
    Jan 2, 1999 at 6:22 pm
  • Hi Tom, This looks like a parser bug in 6.4. I found it while trying to run pg_upgrade: bray= create table junk ("singleton" "char"); CREATE bray= drop table junk; DROP bray= create table junk ...
    Oliver ElphickOliver Elphick
    Dec 5, 1998 at 7:57 pm
    Dec 13, 1998 at 1:32 pm
  • I just got a note from Chris Williams to the effect that when he built 6.4 on his HPUX setup, the install step failed. Seems that HP has a largely incompatible program called "install" living in ...
    Tom LaneTom Lane
    Dec 7, 1998 at 4:34 pm
    Dec 9, 1998 at 8:06 am
  • Hi all, Seems that I found a bug on HAVING clause, see attached file. -Jose'-
    Sferacarta SoftwareSferacarta Software
    Dec 3, 1998 at 6:53 pm
    Dec 14, 1998 at 3:10 pm
  • I seem to have a CASE statement implemented (examples at end). Is anyone in the middle of preparing a big patch, or can I go ahead and commit my changes? They touch roughly a dozen files. Also, I ...
    Thomas G. LockhartThomas G. Lockhart
    Dec 4, 1998 at 6:59 am
    Dec 14, 1998 at 12:29 am
  • Sheesh. After that long song and dance about why we can't implement this, it turns out that it works fine. We had been trying to implement a slightly different syntax, "WITH NULL", which conflicted ...
    Thomas G. LockhartThomas G. Lockhart
    Dec 24, 1998 at 2:06 pm
    Dec 30, 1998 at 3:17 pm
  • HISTORY file coming with 6.4.1 seems old one. I tried http://www.postgresql.org/ to get latest HISTORY but it miserably failed. Also, I noticed that the name of 6.4.1 source directory is "pgsql" not ...
    Tatsuo IshiiTatsuo Ishii
    Dec 24, 1998 at 1:42 am
    Dec 25, 1998 at 2:18 am
  • Got the latest Tcl/Tk 8.0.4 from scriptics, compiled it and installed it with great success. RedHat 5.2 i386, Pentium machine, kernel 2.0.36 All my tcl/tk applications are working fine but : After ...
    Constantin TeodorescuConstantin Teodorescu
    Dec 9, 1998 at 7:42 am
    Dec 14, 1998 at 12:42 am
  • It should be called NVL() from "Null VaLue" like in Oracle and Informix. isnull() would suggest a boolean return value to me. Andreas
    Zeugswetter Andreas IZ5Zeugswetter Andreas IZ5
    Dec 9, 1998 at 10:28 am
    Dec 9, 1998 at 6:17 pm
  • Just a quick question. What is the current state of PostgreSQL on Windows NT (yeuch). I'm asking, because I'm pushing PostgreSQL here, and their eye's lit up as soon as they heared that someone has ...
    Peter T MountPeter T Mount
    Dec 1, 1998 at 4:43 pm
    Dec 2, 1998 at 7:59 pm
  • Here are some patches which fix the recently reported date/time problems on linux/glibc2 machines. Note that these will also fix any machine which "tests positive" for HAVE_TM_ZONE, which might ...
    Thomas G. LockhartThomas G. Lockhart
    Dec 31, 1998 at 4:59 pm
    Jan 5, 1999 at 5:28 pm
  • subscribe
    Cd ChenCd Chen
    Dec 7, 1998 at 1:45 pm
    Dec 29, 1998 at 11:25 am
  • Hi, sometimes it's good not to spend too much efford implementing the final solution first. So for the NUMERIC. First I wonder why the can_coerce... stuff is #if'd out of parse_relation.c? For the ...
    Jan WieckJan Wieck
    Dec 22, 1998 at 8:46 am
    Dec 23, 1998 at 1:54 am
  • Hi all, the exact NUMERIC datatype materializes more and more. What I got so far are the four arithmetic base operators, all six comparision operators and these functions: ABS(n) CEIL(n) EXP(n) ...
    Jan WieckJan Wieck
    Dec 30, 1998 at 3:16 am
    Dec 30, 1998 at 8:13 pm
  • Can we *really* fix up the docs list, or kill it? People ask what list they should be posting on for docs questions, and I'm not sure what answer I should give them. Without it being archived, it ...
    Thomas G. LockhartThomas G. Lockhart
    Dec 23, 1998 at 4:15 pm
    Dec 28, 1998 at 5:02 pm
  • char * crypt_getpwdfilename() { static char *pfnam = NULL; if (!pfnam) { int bufsize; bufsize = strlen(DataDir) + strlen(CRYPT_PWD_FILE) + 2; pfnam = (char *) palloc(bufsize); spprintf(pfnam, ...
    The Hermit HackerThe Hermit Hacker
    Dec 14, 1998 at 6:21 am
    Dec 14, 1998 at 7:01 pm
  • Can someone check the following '#if 0'd code and remove, if its useless? File: catalog/heap.c Line: 1474 Marc G. Fournier Systems Administrator @ hub.org primary: scrappy@hub.org secondary: ...
    The Hermit HackerThe Hermit Hacker
    Dec 14, 1998 at 3:31 am
    Dec 14, 1998 at 7:19 am
  • While investigating a user's complaint, I have found some memory destructions in 6.4 source using purify. (1) parser/gram.y:fmtId() It writes n+3 bytes into n+1 byte-long memory area if mixed case or ...
    Tatsuo IshiiTatsuo Ishii
    Dec 8, 1998 at 8:45 am
    Dec 13, 1998 at 2:49 pm
  • Hi Hackers, With the following query from the opr_sanity regression test I'm getting a backend crash. SELECT p1.oid, p1.oprcode, p2.oid, p2.oprcode FROM pg_operator AS p1, pg_operator AS p2 WHERE ...
    Keith ParksKeith Parks
    Dec 14, 1998 at 9:48 am
    Jan 17, 1999 at 12:13 pm
  • has anyone noticed that the backend still dies when you do a "\d" from psql ? This is with 6.4.1 on bsdi 3.1 -- Incredible Networks LTD Angelos Karageorgiou 20 Karea st, +30.1.92.12.312 (voice) 116 ...
    Angelos KarageorgiouAngelos Karageorgiou
    Dec 26, 1998 at 6:25 pm
    Dec 28, 1998 at 8:45 am
  • I get this error: gcc2 -I../../../include -I../../../backend -I/usr/local/include/readline -O2 - m486 -pipe -g -Wall -I../.. -c nabstime.c -o nabstime.o nabstime.c: In function ...
    Bruce MomjianBruce Momjian
    Dec 18, 1998 at 7:56 pm
    Dec 19, 1998 at 4:30 am
  • Hi all I found 2 BUGs ? caused by ParseComplexProject() function in parse_func.c. The result of the following cases are different from the design of ParseComplexProject() in parse_func.c ? 1. ...
    Hiroshi InoueHiroshi Inoue
    Dec 9, 1998 at 5:53 am
    Dec 14, 1998 at 11:48 pm
  • A while back there was some discussion about NULL. Right now I'm trying to do something that 'Practical SQL' seems to think is normal yet brings up the questions from earlier conversations. I'm ...
    Vince VielhaberVince Vielhaber
    Dec 9, 1998 at 12:56 am
    Dec 9, 1998 at 6:31 am
  • Hi all I just noticed that when loading a dump file, all the echoes of the stuff in the dump file go to stderr. Is that really what you want? I would have thought errors would be sent to stderr and ...
    Terry MackintoshTerry Mackintosh
    Dec 30, 1998 at 11:52 pm
    Dec 31, 1998 at 8:29 pm
  • Dunno if it's known or even important, but I don't recall seeing this before during cvsup: Cannot calculate checksum for "/usr/local/src/pgsql/pgsql/src/interfaces/odbc/config.h": No such file or ...
    Vince VielhaberVince Vielhaber
    Dec 29, 1998 at 6:18 pm
    Dec 29, 1998 at 7:19 pm
  • My database (pgsql 6.4.1, linux i386, compiled by egcs-1.1.1) does weird things: david= create table t( i int primary key ); NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index t_pkey for ...
    David SauerDavid Sauer
    Dec 23, 1998 at 1:26 pm
    Dec 29, 1998 at 8:41 am
  • Hi, it would have been a much cleaner solution to increment the version number after realizing, that a wrong version has been distributed. To distribute another software with the same version number ...
    Edmund MerglEdmund Mergl
    Dec 25, 1998 at 8:39 am
    Dec 28, 1998 at 4:22 pm
  • Long awaited port for NetBSD/m68k was finally done by Mr. Mutsuki Nakajima. Since he is not subscribing the mailing list, I'm posting his patches by his request. According to him, he has successfully ...
    Tatsuo IshiiTatsuo Ishii
    Dec 26, 1998 at 3:14 pm
    Dec 26, 1998 at 8:12 pm
  • Hello! Continuing getting bug reports... This guy see the same error on FreeBSD 2.2.5, pgsql 6.4. He reports 6.3.2 had no the problem... Oleg. ---- Oleg Broytmann National Research Surgery Centre ...
    Oleg BroytmannOleg Broytmann
    Dec 21, 1998 at 10:26 am
    Dec 22, 1998 at 8:21 am
  • Shall we include this in the v6.4.1 release? It looks pretty harmless wrt other systems. I'll update the docs... - Tom
    Thomas G. LockhartThomas G. Lockhart
    Dec 17, 1998 at 3:46 pm
    Dec 17, 1998 at 6:39 pm
  • (taken on-list so this is indexed in mhonarc) Bingo. I can build docs on postgresql.org (a FreeBSD machine) using the FreeBSD packages of the tools if I set an environment variable, specifying these ...
    Thomas G. LockhartThomas G. Lockhart
    Dec 15, 1998 at 8:32 pm
    Dec 15, 1998 at 11:31 pm
  • ============================================================================ POSTGRESQL BUG REPORT TEMPLATE ============================================================================ Your name : ...
    Billy G. AllieBilly G. Allie
    Dec 3, 1998 at 1:56 am
    Dec 14, 1998 at 3:05 pm
  • My database is in weird state after some operation. Here is an example: [david@kerberos david]$ psql ..... david= begin; BEGIN david= create table tbl ( i int ); CREATE david= insert into tbl ...
    David SauerDavid Sauer
    Dec 2, 1998 at 11:30 am
    Dec 13, 1998 at 4:07 am
  • I've posted a new statically-linked CVSup client for linux-libc5 boxes in: ftp://postgresql.org/pub/CVSup/cvsup-15.4.2-client-linux-libc5.tar.gz I've noticed many checksum errors when using my older ...
    Thomas G. LockhartThomas G. Lockhart
    Dec 2, 1998 at 5:49 am
    Dec 3, 1998 at 2:24 am
  • Hi! I have to recover old db, produced by pgsql 6.1. The binaries are lost and fresh compiled postgres dumps core. Investigation narrowed the problem down to ...
    Andrey V KhavryutchenkoAndrey V Khavryutchenko
    Dec 30, 1998 at 11:28 am
    Dec 31, 1998 at 11:21 am
  • Decided to start from scratch. Did a gmake distclean and a fresh cvsup. Reinstalled and did an initdb. Starting the postmaster gives me this: IpcMemoryCreate: shmget failed (Invalid argument) ...
    Vince VielhaberVince Vielhaber
    Dec 29, 1998 at 7:50 pm
    Dec 29, 1998 at 8:46 pm
  • Apologies if this has been raised before. This: create table a12345678901234567890 ( b1234567890 serial ); causes this: pqReadData() -- backend closed the channel unexpectedly. This probably means ...
    Nat HowardNat Howard
    Dec 29, 1998 at 5:32 pm
    Dec 29, 1998 at 6:34 pm
  • The recent report of success for NetBSD-m68k reminded me that there are a few platforms on our "supported list" which have not had reports of success for Postgres-v6.4 (or if there were reports I ...
    Thomas G. LockhartThomas G. Lockhart
    Dec 29, 1998 at 3:08 pm
    Dec 29, 1998 at 6:14 pm
  • Hello, I'm looking for a int8-like type or equivalent substitute. float8 is the first one that comes to mind, but a question arises : isn't there a chance that if I store float8 values be integers, ...
    Jan VicherekJan Vicherek
    Dec 27, 1998 at 6:29 pm
    Dec 27, 1998 at 7:31 pm
  • Due to an error on my part, I mistakenly packaged up the -CURRENT source tree as being v6.4.1, vs the actual v6.4.1 source tree... This has *just* been fixed as of two minutes ago... For those ...
    The Hermit HackerThe Hermit Hacker
    Dec 24, 1998 at 8:13 pm
    Dec 25, 1998 at 2:18 am
  • Hallo, I'm trying postgres 6.4.1 and I have problem with select command: This command makes no sense, but causes crash in backend: pqReadData() -- backend closed the channel unexpectedly. This ...
    David SauerDavid Sauer
    Dec 23, 1998 at 12:06 am
    Dec 23, 1998 at 12:36 pm
  • Do we need to install this in the main source trees? -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + ...
    Bruce MomjianBruce Momjian
    Dec 13, 1998 at 4:45 am
    Dec 18, 1998 at 6:08 pm
Dec 1998
123
Group Navigation
period‹ prev | Dec 1998 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions147
posts591
users81
websitepostgresql.org...
irc#postgresql

81 users for December 1998

Bruce Momjian: 139 posts Thomas G. Lockhart: 94 posts The Hermit Hacker: 39 posts Tom Lane: 36 posts Jan Wieck: 23 posts Oleg Broytmann: 23 posts Vadim Mikheev: 22 posts Constantin Teodorescu: 17 posts Sferacarta Software: 12 posts Tatsuo Ishii: 12 posts Vince Vielhaber: 12 posts Terry Mackintosh: 10 posts Hiroshi Inoue: 9 posts Oleg Bartunov: 7 posts Dan Gowin: 6 posts Hannu Krosing: 6 posts Keith Parks: 6 posts Oliver Elphick: 6 posts Zeugswetter Andreas IZ5: 6 posts Samara CIT: 5 posts
show more
Archives