Search Discussions
-
After reviewing a number of past threads about the INET/CIDR mess, I have concluded that we should adopt the following behavior: 1. A data value like '10.1.2.3/16' is a legal INET value (it implies ...
Tom Lane
Oct 26, 2000 at 11:15 pm
Nov 10, 2000 at 2:45 am -
I'm having the error 'relation <number modified while in use' fairly often. It is the same relation that's always giving a problem. Usually after all currently-running backends die away with that ...
Alex Pilosov
Oct 23, 2000 at 1:31 am
Nov 10, 2000 at 2:43 am -
41
My new job
As many of you know, several businesses are involved in providing PostgreSQL support. After careful consideration, I have decided to accept a job with Great Bridge. There will be a press announcement ...Bruce Momjian
Oct 10, 2000 at 5:06 am
Oct 23, 2000 at 3:22 pm -
[Taken off GENERAL, added HACKERS to cc:] Bruce Momjian wrote: May I ask: is it necessary? Have there been version-bumping changes to libpq since 7.0.x? (With the rate that necessary improvement is ...
Lamar Owen
Oct 27, 2000 at 4:51 am
Nov 2, 2000 at 9:56 pm -
Can someone comment on this? -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | ...
Bruce Momjian
Oct 3, 2000 at 3:43 am
Feb 10, 2001 at 3:19 am -
We would need to know where this separation is, but we cannot do a rollback only rollforward. Thus probably not acceptable. Andreas
Andreas Zeugswetter
Oct 12, 2000 at 11:22 am
Oct 16, 2000 at 5:02 pm -
I am tempted to apply this. This is the second person who asked for binding to a single port. The patch looks quite complete, with doc changes. It appears to be a thorough job. Any objections? -- ...
Bruce Momjian
Oct 11, 2000 at 1:32 am
Nov 21, 2000 at 5:39 am -
I just ran into a strangest thing: within transaction, select now() will always return time when transaction started. Same happens with select 'now'::timestamp. This is with 7.0. I have not tested it ...
Alex Pilosov
Oct 18, 2000 at 2:19 am
Oct 19, 2000 at 11:50 pm -
Saw Tom's commits, now it breaks here: gmake[3]: Leaving directory `/home/ler/pg-dev/pgsql/src/backend/utils' cc -O -K inline -o postgres access/SUBSYS.o bootstrap/SUBSYS.o catalog/SUBSYS.o ...
Larry Rosenman
Oct 26, 2000 at 6:36 pm
Oct 29, 2000 at 5:55 pm -
Announce: First public release of PgSQL Version 1.0 =================================================== PgSQL v1.0 has been released. This is the first public release of PgSQL. It is available at ...
Billy G. Allie
Oct 9, 2000 at 10:20 pm
Oct 13, 2000 at 12:34 pm -
It seems the length coerce for bpchar is broken since 7.0. In 6.5 when a string is inserted, bpchar() is called to properly clip the string. However in 7.0 (and probably current) bpchar() is not ...
Tatsuo Ishii
Oct 17, 2000 at 2:26 am
Jan 20, 2001 at 4:09 am -
This patch is causing compilation warnings on HPUX 10.20: gcc -c -I../../../src/include -O1 -Wall -Wmissing-prototypes -Wmissing-declarations -g -o pqcomm.o pqcomm.c In file included from ...
Tom Lane
Oct 20, 2000 at 3:09 am
Nov 23, 2000 at 3:37 pm -
Also possible would be a name like Oracle pg_exp and pg_imp for export and import. (or pg_export and pg_import) Load and unload is often more tied to data only (no dml). I agree that the current name ...
Andreas Zeugswetter
Oct 16, 2000 at 10:24 am
Oct 19, 2000 at 8:01 pm -
I have noticed that some operating system distributors ship custom-patched versions of Autoconf. That is pretty brain-dead because some of the changes make things work worse on other systems. ...
Peter Eisentraut
Oct 2, 2000 at 8:23 pm
Jan 18, 2001 at 7:53 pm -
First, since when are we in the business of hiding away documentation for a supported platform, and second, how does putting installation instructions into a file named "FAQ" make it less "obvious"? ...
Peter Eisentraut
Oct 17, 2000 at 4:35 pm
Oct 21, 2000 at 2:23 am -
While answering the n'th why-is-initdb-failing question that looked like a version mismatch problem, it occurred to me to wonder why we don't make initdb verify that the executable and library files ...
Tom Lane
Oct 26, 2000 at 3:42 pm
Oct 28, 2000 at 4:39 pm -
http://www.l-t.ee/marko/pgsql/pgcrypto-0.1.tar.gz (11k) Here is a implementation of crypto hashes for PostgreSQL. It exports 2 functions to SQL level: digest(data::text, hash_name::text) which ...
Marko Kreen
Oct 19, 2000 at 5:15 pm
Oct 23, 2000 at 11:15 pm -
I got early access to the UnixWare 7.1.1b Feature Supplement UnixWare/OpenServer Development Kit (UDK FS for short). PostgreSQL 7.0.2 compiles CLEAN (ish...) and we can now support the C++ stuff. The ...
Larry Rosenman
Oct 21, 2000 at 2:44 am
Oct 23, 2000 at 8:33 pm -
Hi, I would like to know if postgres comes with some kind of backup application? I mean something that would do database backup and restore, something like informix's ontape and logical logs. Thanks ...
Martin A. Marques
Oct 2, 2000 at 11:42 am
Oct 14, 2000 at 8:16 pm -
I was fooling around with exactly that point a couple weeks ago. You'd think it would be easy to allow extra parentheses around a sub-select, but I couldn't figure out any way to do it that didn't ...
Tom Lane
Oct 25, 2000 at 4:28 pm
Oct 28, 2000 at 8:41 pm -
First a core dump which can be relieved by: Index: catalog.c =================================================================== RCS file: ...
Patrick Welche
Oct 21, 2000 at 5:17 pm
Oct 25, 2000 at 8:22 pm -
I've just successfully completed an out of the box VPATH build of PostgreSQL (i.e., putting the object files in a different directory structure than the source files). It should be ready to go within ...
Peter Eisentraut
Oct 18, 2000 at 5:16 pm
Oct 20, 2000 at 6:55 pm -
I've just tried to checkout a clean copy of the cvs tree, and it seems that configure is missing a substitutions in Makefile.global.in, ie: make: *** No rule to make target ...
Peter Mount
Oct 30, 2000 at 9:42 am
Nov 21, 2000 at 3:23 am -
Does it mean that there would still be inconsistency between tables and their indexes ? Regards. Hiroshi Inoue
Hiroshi Inoue
Oct 30, 2000 at 5:36 am
Nov 2, 2000 at 5:37 pm -
Okay, here's my attempt at fixing the problems with parentheses in subqueries. It passes the normal 'runcheck' tests, and I've tried a few simple things like select 1 as foo union (((((select 2))))) ...
Kevin O'Gorman
Oct 28, 2000 at 1:11 am
Oct 30, 2000 at 3:43 am -
Would it be possible to add a path spec to the --with-perl configure option so that if we have 2 or more PERL versions on the system we can pick which one to use? Larry -- Larry Rosenman ...
Larry Rosenman
Oct 25, 2000 at 9:45 am
Oct 25, 2000 at 8:12 pm -
Ok, I can't find it on the web site.... How do I check out the current tree? (I want to play with Peter_E's changes...) LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 (voice) ...
Larry Rosenman
Oct 22, 2000 at 11:20 pm
Oct 23, 2000 at 1:13 am -
... with a blinding flash ... The VACUUM funnies I was complaining about before may or may not be real bugs, but they are not what's biting Alfred. None of them can lead to the observed crashes ...
Tom Lane
Oct 17, 2000 at 12:36 am
Oct 18, 2000 at 3:52 pm -
Sparc solaris 2.7 with postgres 7.0.2 It seems to be reproducable, the server crashes on us at a rate of about every few hours. Any ideas? GNU gdb 4.17 Copyright 1998 Free Software Foundation, Inc. ...
Dan Moschuk
Oct 12, 2000 at 4:47 pm
Oct 12, 2000 at 11:11 pm -
Rangetable leakage, sounds like --- the two queries are sharing the same list of rangetable entries, and that's what the planner joins over. Not sure if it's *good* that they share the same rtable ...
Tom Lane
Oct 19, 2000 at 11:36 pm
Oct 23, 2000 at 9:22 pm -
8
TIOGA
Does anyone know what backend/tioga is for? It's not Spanish for TOAST, is it? :-) It looks like it wasn't compilable for quite a while. -- Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/Peter Eisentraut
Oct 11, 2000 at 5:57 pm
Oct 13, 2000 at 7:11 pm -
Hi, I was wondering if anyone could offer me some pointers in extending the C++ classes used for client applications? I'm interested in developing a set of C++ classes which will interact directly ...
Randy Jonasz
Oct 3, 2000 at 6:45 pm
Oct 9, 2000 at 7:36 am -
(This is mostly directed at Vadim, but kibitzing is welcome.) Here's what I plan to do to make DROP TABLE rollbackable and clean up the handling of CREATE TABLE rollback. Comments? Overview: 1. ...
Tom Lane
Oct 27, 2000 at 9:21 pm
Nov 9, 2000 at 12:27 am -
The difference for a cleanup would be, that it does not need to be rolled back as a whole (like current vacuum). A cleanup could be partly done, and resumed later, thus a sofisticated cleanup could ...
Andreas Zeugswetter
Oct 13, 2000 at 7:42 am
Oct 17, 2000 at 10:17 am -
I just spent a fruitless half hour rooting around the website for our elephant-in-crystal logo. I need a moderately large, clean copy for the title slide of a presentation. Where's the original ...
Tom Lane
Oct 12, 2000 at 5:12 am
Oct 12, 2000 at 4:45 pm -
I have installed this in the current source tree, ready for 7.1. I have installed -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | ...
Bruce Momjian
Oct 2, 2000 at 3:26 am
Oct 10, 2000 at 3:48 pm -
Has anybody been getting pgsql-committers messages the last few days? -- Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/
Peter Eisentraut
Oct 2, 2000 at 7:36 pm
Oct 9, 2000 at 10:37 pm -
What happen with www.postgresql.org? My browser is always redirected to http://www.cz.postgresql.org/. But I haven't some terrible mirror (with last change "July 1999"), I want nice and native PG's ...
Karel Zak
Oct 2, 2000 at 7:21 am
Oct 9, 2000 at 10:36 pm -
Hiroshi and I had a discussion last night that needs to reach a wider audience than just the bystanders on pgsql-committers. Let me see if I can reconstruct the main points. In 7.0, a LIMIT clause ...
Tom Lane
Oct 27, 2000 at 4:18 pm
Nov 2, 2000 at 5:25 pm -
Sorry, I don't understand this sentence. Tom suggested placing a shared lock on any table that is accessed until end of tx. Noone can alter table until all users have closed their txns and not ...
Andreas Zeugswetter
Oct 23, 2000 at 9:52 am
Oct 24, 2000 at 9:52 am -
6
Re: [COMMITTERS] pgsql/src/test/regress/expected (plpgsql.out inet.out foreign_key.out errors.out)
Good idea(s). Thanks for cleaning up the error messages... - ThomasThomas Lockhart
Oct 23, 2000 at 6:37 am
Oct 23, 2000 at 10:33 pm -
Hello, I tried to do backup/restore of empty database. And get the following error: Connecting to database for restore Connecting to test4 as postgres Creating OPERATOR = Archiver(db): Could not ...
Denis Perchine
Oct 21, 2000 at 11:04 am
Oct 22, 2000 at 6:19 pm -
pg_dump uses the OID of template1 as the last builtin OID, but this now seems broken in CVS (it returns 1). Should this work? If not, what is the recommended way to find the last built-in OID? ...
Philip Warner
Oct 21, 2000 at 12:33 pm
Oct 22, 2000 at 1:57 am -
I notice that ProcessUtility() calls SetQuerySnapshot() for FETCH and COPY TO statements, and nothing else. Seems to me this is very broken. Isn't a query snapshot needed for any utility command that ...
Tom Lane
Oct 19, 2000 at 4:43 am
Oct 19, 2000 at 8:01 pm -
I have removed the new --export-dynamic item from the Solaris FAQ. Looks like 7.1 has it fixed already. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your ...
Bruce Momjian
Oct 19, 2000 at 3:19 am
Oct 19, 2000 at 4:12 pm -
-rw------- 1 postgres postgres 438386688 Oct 17 20:27 ./data/pg_group bash-2.04$ (as you can see, psql was not responding after the last drop user, I hit control-c and is said Cancel request sent, ...
Matthew
Oct 18, 2000 at 1:36 am
Oct 19, 2000 at 2:33 pm -
I just wanted to repost this one more time in case developers didn't catch it. I have a reliable way to make postgresql crash after a couple of hours over here and a backtrace that looks like a good ...
Alfred Perlstein
Oct 4, 2000 at 7:06 am
Oct 9, 2000 at 2:55 am -
Hi, Well, I discovered a strange behavior (ie 85/0.0085 < 10000 ) Is my SQL wrong or is it postgres ? We are running 7.02 (but also 6.x) on a alpha (alphaev6) box. Thanks in advance. jc Here is a ...
Jean-Christophe Pazzaglia
Oct 6, 2000 at 12:28 pm
Oct 6, 2000 at 3:45 pm -
I seem to have trouble again getting cvs logs for just the 7.0.X branch. I am running this command from a cvs checkout tree of 7.0.X: $ cvs log -d' 2000-06-07 00:00:00 GMT' -rREL7_0_PATCHES And am ...
Bruce Momjian
Oct 29, 2000 at 6:12 pm
Nov 3, 2000 at 12:26 am -
I never saw much traffic regarding Karel's work on making stored proceedures: http://people.freebsd.org/~alfred/karel-pgsql.txt What happened with this? It looked pretty interesting. :( -- -Alfred ...
Alfred Perlstein
Oct 31, 2000 at 11:11 pm
Nov 1, 2000 at 9:53 am
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 264 |
posts | 1,296 |
users | 133 |
website | postgresql.org... |
irc | #postgresql |
133 users for October 2000
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)