Search Discussions
-
After some further experimentation, I believe I understand the reason for the reports we've had of 7.2 producing heavy context-swap activity where 7.1 didn't. Here is an extract from tracing lwlock ...
Tom Lane
Dec 29, 2001 at 7:10 pm
Jan 23, 2002 at 7:16 pm -
After reading through the strong opinions about the location of the configuration files in the current and in previous threads, I must concede that despite the best intentions, the current ...
Peter Eisentraut
Dec 18, 2001 at 10:24 pm
Dec 30, 2001 at 3:20 am -
what is meant by the TODO-item "Disallow missing columns in INSERT ... VALUES, per ANSI" ? rgds Pavlo Baron
Pavlo Baron
Dec 27, 2001 at 8:57 pm
Mar 9, 2002 at 3:26 pm -
Hi, I'm trying to clean up a bug in pg_dump where specifying a table with the '-t tablename' argument fails to generate the necessary CREATE SEQUENCE statements for columns of type SERIAL that are ...
Brent Verner
Dec 15, 2001 at 3:53 am
Mar 8, 2002 at 1:28 am -
I was browsing through the TODO list and stumbled upon the connection pooling item discussed over a year ago. Is it safe to assume that since it's still listed in the TODO that it's still a desirable ...
Michael Owens
Dec 18, 2001 at 12:28 am
Dec 20, 2001 at 5:48 am -
I know I have expressed these concerns before but lost the argument, or at least no one rallied to my position, but I feel I have to mention these again because they came up during beta. My first ...
Bruce Momjian
Dec 18, 2001 at 2:43 pm
Dec 20, 2001 at 1:45 am -
We've got most platforms ironed out, with just a few left to get a definitive report. It looks like we'll end up dropping a few platforms for this release (the first time in several years that the ...
Thomas Lockhart
Dec 7, 2001 at 4:14 pm
Dec 16, 2001 at 2:28 am -
I guess I will maintain this for people who want it. This allows postmaster -C /etc/pgsql/mydb.conf The "-C" option specifies a configuration file. In the config file there are two more options: ...
Mark L. Woodward
Dec 16, 2001 at 2:39 pm
Dec 20, 2001 at 3:02 am -
Manuel Sugawara
Dec 3, 2001 at 7:42 pm
Mar 7, 2002 at 8:48 pm -
I have added the option of explicitly specifying a postgresql.conf (-C) file on the command line. I have also added two config file entries: pghbaconfig, and pgdatadir. "pghbaconfig" allows multiple ...
Mark L. Woodward
Dec 8, 2001 at 4:01 pm
Dec 13, 2001 at 2:40 am -
Okay, here's a follow up to my previous messages "ACK table corrupted, unique index violated." I've been trying to clean up the corruptions that i mentioned earlier. I felt most comfortable shutting ...
Brian Hirt
Dec 12, 2001 at 9:02 pm
Dec 19, 2001 at 5:23 pm -
Hi, While daily using pg_dump for a while the need for the following features grew significantly. I finally came to the point of implementing them myself ;-) - pg_dump outputs the data unsorted but ...
Christof Petig
Dec 6, 2001 at 11:05 am
Dec 13, 2001 at 1:41 pm -
Having heard nothing on the list yet about the reported unsuccessful parallel regression tests on Cygwin with 7.2b3, I thought I'd have a play myself having found a spare few minutes. System: Windows ...
Dave Page
Dec 12, 2001 at 10:16 pm
Dec 17, 2001 at 3:38 pm -
I haven't tested with the new 7.2 betas, but here are some results from 7.1. We have a developement computer, IBM x series 250, with 4 processors (PIII Xeon 750Mhz), 1 Gb memory and 2SCSI disks ...
Jussi Mikkola
Dec 18, 2001 at 10:55 am
Jan 9, 2002 at 10:02 am -
Things have firmed up nicely for the 7.2 release. We currently have several NetBSD platforms which have not reported success for 7.2, maybe only because they have a relatively small user base (and ...
Thomas Lockhart
Dec 13, 2001 at 4:03 pm
Dec 14, 2001 at 5:17 am -
Hi, I threw this to cygwin but it doesn't seem to have elisited any interest over the weekend so I'm sending it here as a beta problem (not entirely sure if this is correct or if it should go to ...
Henshall, Stuart - WCP
Dec 3, 2001 at 10:07 am
Dec 4, 2001 at 11:56 pm -
In HEAD contrib/dbase: gcc -pipe -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -I../../src/ interf aces/libpq -I. -I../../src/include -c -o dbf2pg.o dbf2pg.c dbf2pg.c:19: iconv.h: No such ...
Christopher Kings-Lynne
Dec 21, 2001 at 3:26 am
Dec 21, 2001 at 6:22 am -
In the vacuum tuple-chain moving logic, shouldn't the lines that update the new tuple's t_ctid (vacuum.c lines 1882-1891 in current sources) be moved up to before the log_heap_move call at line 1866? ...
Tom Lane
Dec 19, 2001 at 12:22 am
Jan 3, 2002 at 5:54 am -
I noticed an incorrect example in doc/src/sgml/func.sgml... brent=# SELECT EXTRACT(SECOND FROM TIME '17:12:28.5'); date_part ----------- 28 (1 row) The documentation says this should return 28.5. ...
Brent Verner
Dec 4, 2001 at 1:27 pm
Dec 29, 2001 at 4:54 pm -
14
7.2 is slow?
With the freshly retrieved current source, now PostgreSQL is running fine on an AIX 5L box. Thanks Tom. BTW, I have done some benchmarking using pgbench on this machine and found that 7.2 is almost ...Tatsuo Ishii
Dec 17, 2001 at 6:57 am
Dec 22, 2001 at 12:27 am -
This is an intermediate report for AIX 5L port. o gmake check sometimes hungs up o pgbench almost always hungs up In summary current on AIX 5L is quite unstable(7.1 worked very well). FYI, here are ...
Tatsuo Ishii
Dec 5, 2001 at 8:44 am
Dec 15, 2001 at 2:16 am -
13
contrib idea
Hi All, You know how when you create a foreign key in postgres it isn't automatically indexed, and it seems to me that it's very useful to have indexed foreign keys, especially if you use lots of ...Christopher Kings-Lynne
Dec 21, 2001 at 2:46 am
Jan 3, 2002 at 6:26 am -
Hi, Is it me (who hasn't read some FAQ or a doc/man page) or it's a bug in the psql interactive terminal? A sample session is provided at the bottom. I just typed a simple CREATE TABLE command and ...
Serguei Mokhov
Dec 2, 2001 at 6:58 am
Dec 28, 2001 at 7:33 pm -
Well, it'd be an easy enough addition: if (strlen(delim) != 1) elog(ERROR, "COPY delimiter must be a single character"); This isn't multibyte-aware, but then neither is the implementation; delimiters ...
Tom Lane
Dec 4, 2001 at 8:16 pm
Dec 28, 2001 at 7:43 pm -
12
SunOS4 port
So far I think I have done the SunOS4 port except the parallel regression test. Unfortunately the machine is in production and I could not increase the shmem parameters. Instead I have done the ...Tatsuo Ishii
Dec 5, 2001 at 2:49 am
Dec 19, 2001 at 7:15 pm -
12
Licensing
I may have some spare hacking time coming up, and I was thinking about adding a PL (Scheme) to PostgreSQL. I've found some code out there for a small Scheme interpreter, but it appears to be licensed ...Doug McNaught
Dec 5, 2001 at 6:17 pm
Dec 6, 2001 at 8:19 pm -
The problem here is that the planner is being way too optimistic about the selectivity of LIKE '%DAVID%' --- notice the estimate that only one matching row will be found in cliente, rather than 54 as ...
Tom Lane
Dec 4, 2001 at 3:21 pm
Dec 29, 2001 at 5:08 am -
configure unfortunately does not include the tcl library for linking libpgtcl.so on AIX :-( In the meantime Jacques, your tcl installation should have a shared tcl library (libtcl8.2.so) or better ...
Andreas Zeugswetter
Dec 14, 2001 at 9:01 am
Dec 20, 2001 at 1:35 am -
Apparently there's been a change in the way views are handled within PostreSQL. The following program works fine in earlier versions. It also works if the select on the view is replaced with a direct ...
Don Baccus
Dec 17, 2001 at 7:47 pm
Dec 19, 2001 at 8:59 pm -
I'm looking at gram.y to munge the precision support for date/time per recent discussions, and am noticing once again the extensions added to support ODBC by allowing empty parens after some ...
Thomas Lockhart
Dec 7, 2001 at 4:43 pm
Dec 11, 2001 at 2:41 pm -
Hello, After fresh install of PostgreSQL 7.1.3 I was having one particular query (JOIN), running for several hours. Upon closer investigation, it was returning weird EXPLAIN 'optimisations' (in ...
Daniel Kalchev
Dec 3, 2001 at 4:59 pm
Dec 3, 2001 at 10:53 pm -
Is there any reason why recursive SQL functions are not allowed in PG 7.2? After all this: create function foo() returns setof integer as 'select 1' language 'sql'; create or replace function foo() ...
Don Baccus
Dec 17, 2001 at 6:30 pm
Feb 23, 2002 at 7:23 pm -
Got a report the other day of a "problem" with pg_dump where, if in the middle of a dump, someone happens to drop a table, it errors out with: SQL query to dump the contents of Table 'server_2' did ...
Marc G. Fournier
Dec 17, 2001 at 7:10 pm
Jan 12, 2002 at 2:09 am -
See: ./configure --prefix=/usr/lib/postgresql \ --with-unixodbc \ --enable-odbc \ --with-openssl \ --with-pam \ --with-python \ --with-perl \ --with-tcl \ --enable-nls \ --enable-multibyte \ ...
Karel Zak
Dec 20, 2001 at 1:53 pm
Dec 29, 2001 at 9:44 pm -
Someone reported to me that they can't get their queries to use indexes. It turns out this is because timestamp() has pg_proc.proiscachable set to false in many cases. Date() also has this in some ...
Bruce Momjian
Dec 26, 2001 at 5:36 am
Dec 27, 2001 at 4:45 am -
Maybe I am missing something obvious, but I am unable to load larger tables (~300k rows) with COPY command that pg_dump by default produces. Yes, dump as INSERTs works but is slow. "Cant" as in "it ...
Marko Kreen
Dec 11, 2001 at 3:09 pm
Dec 11, 2001 at 7:39 pm -
Where are we on the RC1 release? What are the open items? I have gotten lost. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 ...
Bruce Momjian
Dec 20, 2001 at 11:15 pm
Jan 3, 2002 at 6:11 am -
I just found out something about Oracle which that looks like something that could be doable in PostgreSQL. What do you all think: Oracle's version is something like this: create [public] database ...
Mark L. Woodward
Dec 6, 2001 at 6:26 pm
Dec 7, 2001 at 5:26 pm -
Bizarre. That patch was never committed. If you check src/backend/commands/command.c and search for 'CONSTR_' you'll notice that the CONSTR_UNIQUE function I implemented is there, but CONSTR_PRIMARY ...
Christopher Kings-Lynne
Dec 4, 2001 at 2:22 am
Jan 2, 2002 at 3:36 am -
I have just run 7.2b4 on FreeBSD/alpha. The float8 and geometry tests failed. Attatched is the regression stuff. I have submitted it to the database. I'm not certain how significant the results are. ...
Christopher Kings-Lynne
Dec 18, 2001 at 7:20 am
Dec 19, 2001 at 3:48 pm -
hello hackers here is the patch for the INSERT INTO t VALUES (..., DEFAULT, ...) from the current TODO list. It's my first patch so please forgive me if it's not the best solution - I'm now learning ...
Pavlo Baron
Dec 27, 2001 at 11:04 am
Mar 8, 2002 at 1:01 am -
Hi Marko, Just testing pgcrypto on freebsd/alpha. I get some warnings: gcc -pipe -O -Wall -Wmissing-prototypes -Wmissing-declarations -fpic -DPIC -DRAND_SILLY -I. -I. -I../../src/include -c - o ...
Christopher Kings-Lynne
Dec 21, 2001 at 3:42 am
Jan 3, 2002 at 7:33 am -
This has got to stop. We've seen "my cursor keys don't work in psql", now we see "compression doesn't work" every so often. Somehow we have to get deterministic output from configure without "paying ...
Peter Eisentraut
Dec 4, 2001 at 9:21 pm
Dec 28, 2001 at 9:51 pm -
I just looked at the source for dbase. I have a long hacked version of this. The one in contrib is based on a newer version of what I have been using. It is funny, because I made some of the same ...
Mark L. Woodward
Dec 21, 2001 at 7:50 pm
Jan 3, 2002 at 8:04 am -
Presently, the RESUME_INTERRUPTS() and END_CRIT_SECTION() macros implicitly do a CHECK_FOR_INTERRUPTS(); that is, if a cancel request arrived during the interrupt-free section it will be serviced ...
Tom Lane
Dec 30, 2001 at 6:46 pm
Dec 31, 2001 at 5:02 pm -
Peter Eisentraut
Dec 22, 2001 at 9:41 pm
Dec 24, 2001 at 1:17 pm -
Changing the default data location at this point would imho be a major hassle for those actually using the default. Thus I object to changing it. Andreas
Andreas Zeugswetter
Dec 19, 2001 at 9:52 am
Dec 20, 2001 at 5:12 pm -
I was wondering, when we start to reuse a WAL file, do we know that all dirty buffers modified in that WAL file have been flushed to disk? Do we fsync() dirty buffers at time of checkpoint, and do we ...
Bruce Momjian
Dec 19, 2001 at 3:03 am
Dec 19, 2001 at 4:34 am -
Hi all, I've examined a cygwin hangup issue for a pretty long time. It seems there are plural causes though it's hard for me to identify them all. Anyway I found some unexpected SIGALRM cases. It may ...
Hiroshi Inoue
Dec 16, 2001 at 9:53 pm
Dec 17, 2001 at 3:15 am -
I'm having a very scary problem. First, here's my system: smp dual PIII800 512MB memory running redhat 6.2 kernel 2.2.18 PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC egcs-2.91.66 In a ...
Brian Hirt
Dec 12, 2001 at 5:39 pm
Dec 13, 2001 at 12:22 am
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 143 |
posts | 962 |
users | 117 |
website | postgresql.org... |
irc | #postgresql |
117 users for December 2001
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)