Search Discussions
-
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 Broytmann
Dec 3, 1998 at 7:00 pm
Dec 23, 1998 at 4:33 pm -
Bruce 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 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. 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 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 Bartunov
Dec 8, 1998 at 3:00 pm
Dec 14, 1998 at 5:35 am -
... in SELECT * FROM street; Vadim
Vadim 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 Software
Dec 15, 1998 at 12:40 pm
Dec 16, 1998 at 5:19 am -
10
2 patches
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 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 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 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 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. 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. 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 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 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 IZ5
Dec 9, 1998 at 10:28 am
Dec 9, 1998 at 6:17 pm -
7
NT port
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 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. Lockhart
Dec 31, 1998 at 4:59 pm
Jan 5, 1999 at 5:28 pm -
subscribe
Cd 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 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 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. 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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. 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. Lockhart
Dec 15, 1998 at 8:32 pm
Dec 15, 1998 at 11:31 pm -
============================================================================ POSTGRESQL BUG REPORT TEMPLATE ============================================================================ Your name : ...
Billy 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 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. 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 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 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 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. 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 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 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 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 Momjian
Dec 13, 1998 at 4:45 am
Dec 18, 1998 at 6:08 pm
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 147 |
posts | 591 |
users | 81 |
website | postgresql.org... |
irc | #postgresql |
81 users for December 1998
Archives
- August 2013 (1,430)
- July 2013 (1,772)
- June 2013 (2,428)
- May 2013 (1,555)
- April 2013 (1,283)
- March 2013 (1,441)
- February 2013 (1,366)
- January 2013 (2,520)
- December 2012 (1,701)
- November 2012 (1,618)
- October 2012 (1,580)
- September 2012 (1,195)
- August 2012 (1,180)
- July 2012 (1,125)
- June 2012 (1,850)
- May 2012 (1,584)
- April 2012 (1,459)
- March 2012 (1,921)
- February 2012 (1,517)
- January 2012 (1,777)
- December 2011 (1,347)
- November 2011 (1,764)
- October 2011 (1,687)
- September 2011 (1,623)
- August 2011 (1,433)
- July 2011 (1,658)
- June 2011 (2,404)
- May 2011 (1,664)
- April 2011 (1,834)
- March 2011 (1,956)
- February 2011 (2,476)
- January 2011 (2,965)
- December 2010 (2,587)
- November 2010 (2,109)
- October 2010 (2,113)
- September 2010 (2,173)
- August 2010 (2,061)
- July 2010 (1,612)
- June 2010 (1,560)
- May 2010 (1,961)
- April 2010 (1,575)
- March 2010 (1,314)
- February 2010 (2,439)
- January 2010 (3,118)
- December 2009 (2,514)
- November 2009 (493)
- October 2009 (1,903)
- September 2009 (1,990)
- August 2009 (2,170)
- July 2009 (2,025)
- June 2009 (1,565)
- May 2009 (1,518)
- April 2009 (1,431)
- March 2009 (1,424)
- February 2009 (1,399)
- January 2009 (2,641)
- December 2008 (2,011)
- November 2008 (1,918)
- October 2008 (1,695)
- September 2008 (1,887)
- August 2008 (1,374)
- July 2008 (1,495)
- June 2008 (1,149)
- May 2008 (1,112)
- April 2008 (1,908)
- March 2008 (1,288)
- February 2008 (1,309)
- January 2008 (1,220)
- December 2007 (989)
- November 2007 (1,369)
- October 2007 (1,553)
- September 2007 (1,225)
- August 2007 (1,221)
- July 2007 (1,007)
- June 2007 (1,127)
- May 2007 (1,189)
- April 2007 (1,266)
- March 2007 (1,866)
- February 2007 (1,916)
- January 2007 (1,645)
- December 2006 (1,423)
- November 2006 (1,021)
- October 2006 (1,565)
- September 2006 (2,375)
- August 2006 (2,039)
- July 2006 (1,626)
- June 2006 (1,624)
- May 2006 (1,366)
- April 2006 (1,150)
- March 2006 (1,327)
- February 2006 (1,259)
- January 2006 (1,030)
- December 2005 (1,252)
- November 2005 (1,568)
- October 2005 (1,417)
- September 2005 (1,464)
- August 2005 (1,191)
- July 2005 (1,150)
- June 2005 (1,576)
- May 2005 (1,592)
- April 2005 (1,004)
- March 2005 (1,069)
- February 2005 (969)
- January 2005 (1,100)
- December 2004 (949)
- November 2004 (1,210)
- October 2004 (1,059)
- September 2004 (951)
- August 2004 (1,601)
- July 2004 (1,397)
- June 2004 (1,037)
- May 2004 (1,446)
- April 2004 (1,167)
- March 2004 (1,330)
- February 2004 (1,003)
- January 2004 (861)
- December 2003 (827)
- November 2003 (1,618)
- October 2003 (1,602)
- September 2003 (1,683)
- August 2003 (1,343)
- July 2003 (1,045)
- June 2003 (1,302)
- May 2003 (802)
- April 2003 (1,012)
- March 2003 (1,242)
- February 2003 (1,323)
- January 2003 (1,315)
- December 2002 (1,176)
- November 2002 (1,220)
- October 2002 (1,449)
- September 2002 (1,816)
- August 2002 (2,295)
- July 2002 (1,290)
- June 2002 (1,024)
- May 2002 (1,157)
- April 2002 (1,532)
- March 2002 (1,207)
- February 2002 (1,225)
- January 2002 (1,397)
- December 2001 (963)
- November 2001 (1,301)
- October 2001 (1,155)
- September 2001 (895)
- August 2001 (1,204)
- July 2001 (938)
- June 2001 (1,131)
- May 2001 (1,458)
- April 2001 (1,168)
- March 2001 (1,672)
- February 2001 (1,154)
- January 2001 (1,450)
- December 2000 (1,222)
- November 2000 (1,390)
- October 2000 (1,296)
- September 2000 (633)
- August 2000 (888)
- July 2000 (1,428)
- June 2000 (1,283)
- May 2000 (1,648)
- April 2000 (184)
- March 2000 (291)
- February 2000 (1,464)
- January 2000 (1,639)
- December 1999 (1,056)
- November 1999 (916)
- October 1999 (949)
- September 1999 (946)
- August 1999 (695)
- July 1999 (1,070)
- June 1999 (1,242)
- May 1999 (1,136)
- April 1999 (218)
- March 1999 (1,002)
- February 1999 (692)
- January 1999 (758)
- December 1998 (591)
- November 1998 (600)
- October 1998 (1,208)
- September 1998 (678)
- August 1998 (856)
- July 1998 (482)
- June 1998 (496)
- May 1998 (618)
- April 1998 (702)
- March 1998 (1,118)
- February 1998 (1,307)
- January 1998 (855)
- December 1997 (346)
- November 1997 (374)
- October 1997 (575)
- September 1997 (549)
- August 1997 (404)
- July 1997 (391)
- June 1997 (595)
- May 1997 (478)
- April 1997 (854)
- March 1997 (526)
- February 1997 (297)
- January 1997 (927)
- December 1996 (2)
- November 1996 (1)
- October 1996 (1)
- October 1995 (2)
- July 1995 (1)