Search Discussions
-
It is time for people to report their port testing. Please test against current CVS or beta5 and report your 'uname -a'. The current list is at: ...
Bruce Momjian
Oct 24, 2003 at 3:38 pm
Nov 9, 2003 at 4:03 am -
Attached is an extremely crude prototype patch for making VACUUM delay by a configurable amount between pages, in hopes of throttling its disk bandwidth consumption. By default, there is no delay (so ...
Tom Lane
Oct 31, 2003 at 2:41 am
Nov 12, 2003 at 5:18 am -
Hi, This is for relational database theory experts on one hand and imlementers of real-world alications on the other hand. If there was a chance to start again and design SQL afresh, for best ...
Seun Osewa
Oct 3, 2003 at 7:20 pm
Nov 9, 2003 at 11:24 pm -
Hello, With the recent stint of pg_upgrade statements and the impending release of 7.4 what do people think about having a dedicated maintenance team for 7.3? 7.3 is a pretty solid release and I ...
Joshua D. Drake
Oct 1, 2003 at 3:06 am
Oct 9, 2003 at 7:39 pm -
Hi, Now that DEFAULT 'now' will not work in PostgreSQL 7.4, will DEFAULT 'infinity' and DEFAULT '-infinity' and the like stop working as well? What is the workaround for those defaults? Chris
Christopher Kings-Lynne
Oct 22, 2003 at 2:18 am
Oct 31, 2003 at 8:59 pm -
So when I suggested on linux-kernel that vacuumcould benefit from some way to prioritize i/o resourcse, someone suggested vacuum could just throttle its own disk accesses. While I think they their ...
Greg Stark
Oct 16, 2003 at 5:18 am
Oct 17, 2003 at 9:13 pm -
Barring the discovery of any major new bugs, the core committee has agreed to release 7.4RC1 on Monday. Time to get those last-minute fixes in place. I currently have the following issues on my radar ...
Tom Lane
Oct 30, 2003 at 11:43 pm
Nov 1, 2003 at 12:50 am -
31
Open items
We only have a few open items left. Can we finish them so we can move toward final release? --------------------------------------------------------------------------- P O S T G R E S Q L 7 . 4 O P E ...Bruce Momjian
Oct 28, 2003 at 2:39 am
Oct 30, 2003 at 11:16 pm -
P O S T G R E S Q L 7 . 4 O P E N I T E M S Current at ftp://momjian.postgresql.org/pub/postgresql/open_items. Changes ------- Fix REVOKE ALL ON FUNCTION error when removing owner permissions Improve ...
Bruce Momjian
Oct 5, 2003 at 4:42 am
Oct 10, 2003 at 3:55 am -
26
*sigh*
psql cannot \i a file which name contains a blank character. Why doesn't it take the rest of the command line as the name of the file?!? Why doesn't it use any of the standard command line parsing ...Thomas Zehetbauer
Oct 18, 2003 at 1:15 am
Jan 4, 2004 at 4:23 pm -
While fooling with adding -fno-strict-aliasing to configure, I realized that there are still some oddities about its selection of CFLAGS. The problems stem from the fact that autoconf will always ...
Tom Lane
Oct 15, 2003 at 10:50 pm
Oct 28, 2003 at 1:45 am -
There is a bug in Unicode upper() which has been present since 7.2: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=139389 I had thought I had reported it before, but I can't find a record of it. ...
Oliver Elphick
Oct 19, 2003 at 11:56 pm
Nov 19, 2003 at 7:20 pm -
Hi, I installed 7.4beta5, created a data-dir and tried to start postgresql with pg_ctl without initdb. As expected, this will fail. But pg_ctl tells me "postmaster successfully started", after a ...
Tommi Maekitalo
Oct 23, 2003 at 8:29 am
Oct 29, 2003 at 4:17 am -
This appears to have been a deliberate change: 2003-03-27 11:45 momjian * src/bin/psql/tab-complete.c: Attached are two patches for psql's tab-completion.c. [snip] Note that tables, indexes, views ...
Tom Lane
Oct 28, 2003 at 9:49 pm
Oct 30, 2003 at 9:39 pm -
[ CC added for hackers.] Well, this is really embarassing. I can't imagine why we would not set at least -O on all platforms. Looking at the template files, I see these have no optimization set: ...
Bruce Momjian
Oct 8, 2003 at 6:32 pm
Oct 14, 2003 at 8:42 pm -
Hi, Is there demand for modifying psql to work against previous backends, pg_dump-style? I feel like looking into it, but tell me if I'm wasting my time... Chris
Christopher Kings-Lynne
Oct 21, 2003 at 1:24 am
Oct 23, 2003 at 1:09 pm -
Hi, I am running a large and mature mission-critical PostgreSQL implementation with multiple tables that are growing at a rate of several million rows per month (the rate of addition is growing as ...
James Rogers
Oct 1, 2003 at 6:34 am
Oct 7, 2003 at 7:34 am -
The more I think about this vacuum i/o problem, the more I think we have it wrong. The added i/o from vacuum really ought not be any worse than a single full table scan. And there are probably the ...
Greg Stark
Oct 17, 2003 at 8:23 pm
Nov 1, 2003 at 5:17 am -
See subject. If we want to force an initdb to ensure the recent information_schema updates take effect, we have to do it before beta5 release, I think. I'm inclined to do it --- I don't get the sense ...
Tom Lane
Oct 20, 2003 at 9:35 pm
Oct 23, 2003 at 8:57 am -
There was a discussion on -interfaces that might need more consideration. http://archives.postgresql.org/pgsql-interfaces/2003-09/msg00026.php Apparently, it has so far been an undocumented feature ...
Peter Eisentraut
Oct 5, 2003 at 2:38 pm
Oct 10, 2003 at 2:42 am -
15
db encoding
pg_encoding appears to have 2 personalities, (name= number and vice versa) depending on whther or not its parameter begins with a digit (which is in itself fragile - what if you gave it "3foo"?). ...Andrew Dunstan
Oct 6, 2003 at 5:36 pm
Oct 8, 2003 at 1:00 pm -
I've always been uneasy about the notice at the end of the installation process that asks the user to register at http://www.pgsql.com/register/submit.php Now some users have also complained to me ...
Peter Eisentraut
Oct 12, 2003 at 1:02 pm
Oct 13, 2003 at 9:40 pm -
Greg Stark
Oct 12, 2003 at 10:13 pm
Oct 26, 2003 at 4:13 am -
I'm seeing this compile warning on today's CVS tip: $ make src/backend/commands/tablecmds.o gcc -O2 -g -Wall -Wmissing-prototypes -Wmissing-declarations -I./src/include -D_GNU_SOURCE -c -o ...
Alvaro Herrera
Oct 8, 2003 at 4:14 pm
Oct 11, 2003 at 4:44 pm -
FreeBSD 4.9 was released today. In the release notes was: 2.2.6 File Systems A new DIRECTIO kernel option enables support for read operations that bypass the buffer cache and put data directly into a ...
Christopher Kings-Lynne
Oct 29, 2003 at 2:06 pm
Oct 31, 2003 at 5:05 am -
Folks, I can't seem to find a Bison 1.875 RPM for a SuSE 8.1 machine I can't afford to upgrade right now. Does such an animal exist? Help! -- -Josh Berkus Aglio Database Solutions San Francisco
Josh Berkus
Oct 16, 2003 at 8:40 pm
Oct 17, 2003 at 5:55 pm -
We only have a few open items left. Let's make final decisions on these and schedule RC1. --------------------------------------------------------------------------- P O S T G R E S Q L 7 . 4 O P E N ...
Bruce Momjian
Oct 12, 2003 at 11:07 pm
Oct 14, 2003 at 3:18 pm -
12
initdb
The following code is in initdb.sh: exit_nicely(){ stty echo /dev/null 2 &1 echo 1 &2 echo "$CMDNAME: failed" 1 &2 if [ "$noclean" != yes ]; then if [ "$made_new_pgdata" = yes ]; then echo "$CMDNAME: ...Andrew Dunstan
Oct 1, 2003 at 8:04 pm
Oct 12, 2003 at 5:14 pm -
Check her over and let me know if there are any problems ... will do a full general announce tomorrow for it ...
Marc G. Fournier
Oct 3, 2003 at 3:40 am
Oct 4, 2003 at 10:08 pm -
All, After toying with a few builds of the up coming OS X 10.3 (Panther) release, I've written a doc on how to get postgresql to build using Panther build 7B85 and Xcode build 7B85 (which are rumored ...
James Wilson
Oct 11, 2003 at 1:34 am
Nov 5, 2003 at 4:09 pm -
Hi guys, What is the limit on the number of rows in a PostgreSQL table? If it's more than MAXINT, we have a problem: phppgadmin# select * from test limit 2147483648; ERROR: integer out of range Same ...
Christopher Kings-Lynne
Oct 22, 2003 at 7:58 am
Oct 26, 2003 at 4:44 am -
Env: Postgres 7.3.4 on Unix I have a script to create a new database user and update pg_hba.conf. I was wondering whether I need to restart server, or simply run pg_ctl reload. The question is what ...
Michael Brusser
Oct 11, 2003 at 3:09 am
Oct 14, 2003 at 8:03 pm -
My gcc 2.95.3 manual says: -pipe Use pipes rather than temporary files for communi- cation between the various stages of compilation. This fails to work on some systems where the assem- bler cannot ...
Bruce Momjian
Oct 9, 2003 at 2:47 pm
Oct 10, 2003 at 12:20 am -
[ Moved to hackers.] I think we should change the "check_function_bodies" to something more general. I like "restore_validation_mode" because it could also be used to disable foreign key checks which ...
Bruce Momjian
Oct 6, 2003 at 10:53 pm
Oct 8, 2003 at 2:58 pm -
Is this a bug? (using CVS code from yesterday) nconway=# create view baz (a,b) as select 'hello', 'world'; WARNING: column "a" has type "unknown" DETAIL: Proceeding with relation creation anyway. ...
Neil Conway
Oct 2, 2003 at 6:59 am
Oct 3, 2003 at 5:26 pm -
What does this in the date/time type docs mean? zulu, allballs, z time 00:00:00.00 UTC Cos it has bizarro behaviour: In 7.3.4: australia=# select 'zulu'::time; ERROR: Bad time external representation ...
Christopher Kings-Lynne
Oct 22, 2003 at 7:17 am
Oct 27, 2003 at 6:11 pm -
Dear friends, I would like to port Compiere CRM from Oracle to PostgreSQL (and release it for free). At first I would like to convert the data schema. This is not difficult as Compiere is written ...
Jean-Michel POURE
Oct 17, 2003 at 8:11 am
Oct 18, 2003 at 1:12 pm -
Dear PostgreSQL masters, I know this might like a childish question and you probably might have a good laugh over this but I would like to learn how PostgreSQL works inside-out. Could anyone please ...
Gevik Babakhani
Oct 5, 2003 at 9:04 pm
Oct 7, 2003 at 9:23 pm -
Hi guys, I've asked this of a few people now, but I haven't managed to get a straightforward solution. I'm working on COMMENT ON LARGE OBJECT. If you could help me with this one, it would be really ...
Christopher Kings-Lynne
Oct 26, 2003 at 8:38 am
Nov 10, 2003 at 1:47 am -
Hi All, i'm running Postgresql 2.2x, so i am not quitse sure wether the bug i am reporting is already fixed in newer versions or not. In my version select round(2.5); returns 2; select ...
Jochen Westland [invigo]
Oct 22, 2003 at 9:46 am
Oct 27, 2003 at 10:53 pm -
Some comments on random TODO entries: * Allow INET subnet tests using non-constants This should say "Allow ... to be indexed" as it's otherwise a nonissue. * ARRAYS o -Allow arrays to be ORDER'ed ...
Tom Lane
Oct 20, 2003 at 1:13 am
Oct 21, 2003 at 3:52 pm -
Is there any reason other than historical that the System Views setup isn't a separate script fed to postgres by initdb, like, say, the information schema file? If there isn't a good reason should we ...
Andrew Dunstan
Oct 5, 2003 at 9:25 pm
Oct 6, 2003 at 4:28 pm -
Do to a bug in pgtypeslin I've been experimenting with the day of week stuff a little bit and I found that we do not agree with the output of the cal command on older dates. I have no idea which one ...
Michael Meskes
Oct 5, 2003 at 11:07 am
Nov 29, 2003 at 5:57 am -
Hi, Was just wondering if pg_autovacuum watches transaction ids and issues a vacuum freeze before they roll over? If not, is it hard to do? Chris
Christopher Kings-Lynne
Oct 16, 2003 at 5:28 am
Oct 21, 2003 at 3:44 am -
Some of you may remember that we discussed libpqxx's higher-level support for transactionality. It was pointed out (by Tom, IIRC) that the connection to the backend may be lost just after you've sent ...
Jeroen T. Vermeulen
Oct 20, 2003 at 1:36 pm
Oct 20, 2003 at 7:57 pm -
I looked through all the information_schema stuff, and found a few more nits. The CHECK_CONSTRAINTS view should use pg_get_constraintdef() function rather than consrc, for the same reasons as psql ...
Tom Lane
Oct 16, 2003 at 11:48 pm
Oct 17, 2003 at 3:45 pm -
Ladies and Gentemen, in a database project I ported an Oracle database definition to PostgreSQL 7.3.2 as an aside. During this process I found a couple of incompatibilities in the SQL dialects of ...
Rainer Klute
Oct 2, 2003 at 5:38 pm
Oct 6, 2003 at 6:35 pm -
Could this be made a TODO item, perhaps with your attack plan. Of course as strictly optional feature useful only for special situations (see below) I cross-post this to [HACKERS] as it seem relevant ...
Hannu Krosing
Oct 4, 2003 at 9:01 am
Oct 5, 2003 at 1:37 pm -
Hi guys, I'm just trying to understand this situation: Session 1 --------- BEGIN; SELECT * FROM tab WHERE id=1 FOR UPDATE; Session 2 --------- UPDATE tab SET blah=1 WHERE id=1; <waits Session 1 ...
Christopher Kings-Lynne
Oct 2, 2003 at 8:25 am
Oct 4, 2003 at 9:39 am -
In addition to the -g issue, I get the following failure: *** ./expected/privileges.out Thu Oct 9 20:49:31 2003 --- ./results/privileges.out Fri Oct 24 14:07:18 2003 *************** *** 247,253 **** ...
Larry Rosenman
Oct 25, 2003 at 6:18 am
Oct 31, 2003 at 11:17 pm
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 208 |
posts | 1,602 |
users | 178 |
website | postgresql.org... |
irc | #postgresql |
178 users for October 2003
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)