Search Discussions
-
Thanks to Rod Taylor's kind help in donating a system account, I've been able to test libpqxx against postgres 7.3. Unfortunately, I'm running into several problems. One thing that broke libpqxx was ...
Jeroen T. Vermeulen
Dec 4, 2002 at 9:33 am
Dec 17, 2002 at 12:23 pm -
I wanted to outline some of the big items we are looking at for 7.4: Win32 Port: Katie Ward and Jan are working on contributing their Win32 port for 7.4. They plan to have a patch available by the ...
Bruce Momjian
Dec 13, 2002 at 6:22 am
Dec 17, 2002 at 5:22 pm -
Going to announce later this evening to give the mirrors a chance to catch up ... let me know if there are any problems ..
Marc G. Fournier
Dec 18, 2002 at 2:18 pm
Dec 20, 2002 at 12:03 am -
44
IPv6 patch
I have been working on a patch to implement IPv6 connections. A working patch was supplied by Nigel Kukard about two weeks ago, and I have been improving it. The original patch assumed the system has ...Bruce Momjian
Dec 29, 2002 at 4:36 am
Jan 28, 2003 at 3:12 am -
Update on replication: We have several things happening with Postgres-R replication: o Someone is porting the 7.2-based Postgres-R code to 7.3 o Darren and I are in discussion with the Spread folks, ...
Bruce Momjian
Dec 17, 2002 at 5:57 pm
Dec 18, 2002 at 1:36 pm -
I'm evaluating tsearch contrib module, and i get a backend crash when i'm about to use a tsearch function. When i issue update things set nidx=txt2txtidx(productname), ...
Magnus Naeslund(f)
Dec 3, 2002 at 2:53 pm
Dec 6, 2002 at 5:16 am -
Hi, Some guys from Turkey claim that they have a code to crack PostgreSQL passwords, defined in pg_hba.conf . http://www.core.gen.tr/pgcrack/ Maybe some of you want to get the code... Best regards, ...
Devrim Gündüz
Dec 31, 2002 at 5:17 pm
Jan 4, 2003 at 1:38 am -
I have prepared the 7.3 CVS branch in preparation of a 7.3.1 release soon. Please check it. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard ...
Bruce Momjian
Dec 18, 2002 at 2:17 am
Dec 28, 2002 at 9:15 pm -
We support "alter table add foreign key". How about supporting "alter table drop foreign key"? - he said as he went to drop a foreign key -- Dan Langille : http://www.langille.org/
Dan Langille
Dec 5, 2002 at 4:01 pm
Dec 5, 2002 at 9:25 pm -
[ moved to hackers from pgsql-patches ] "Christopher Kings-Lynne" <chriskl@familyhealth.com.au writes: ... and that was already proposed for "show schemas" (namespaces). I'm inclined to think it's ...
Tom Lane
Dec 9, 2002 at 9:12 pm
Dec 12, 2002 at 4:14 am -
The notes below are the results of various tuning issues experienced recently on a large database (several GB) that has many tables and a high transient data flow (ie. thousands of records added, ...
Philip Warner
Dec 8, 2002 at 2:43 pm
Dec 11, 2002 at 5:19 am -
Hi, I've been trying to ask on general, and tried to search the archives without much result, so I'll try here. I'm using PostgreSQL 7.2.1 on Solaris 8/sparc. In a table, I have a text field, which ...
Tomas Berndtsson
Dec 4, 2002 at 3:39 pm
Dec 6, 2002 at 1:03 pm -
Hi! subject says it all, I guess. There is hardly no difference between 7.3 libpq and 7.3.1 libpq. Why the version shift? Isn't the only thing rectifying a version shift that there is a change in the ...
Palle Girgensohn
Dec 30, 2002 at 3:41 am
Jan 4, 2003 at 4:59 am -
Someone asked earlier about how to change a bunch of existing tables int the PUBLIC schema to some other schema. For grins I tried: regression=# select oid,* from pg_namespace ; oid | nspname | ...
Joe Conway
Dec 1, 2002 at 5:29 am
Dec 3, 2002 at 5:03 pm -
Here's something that's been bothering me for a while... Perhaps this is correct behaviour, but I can't quite see how. This does not happen if I replace the FETCHes by MOVEs. Here's the reference ...
Jeroen T. Vermeulen
Dec 26, 2002 at 1:44 am
Dec 30, 2002 at 6:50 pm -
I was bemused to notice that pg_dump is currently unable to dump the regression database. The domain regression test leaves an empty table (one with zero columns), which causes pg_dump to produce -- ...
Tom Lane
Dec 12, 2002 at 9:09 pm
Dec 16, 2002 at 11:37 pm -
Hi folks, Let's create a release team. This strategy is one well established in other projects and in industry. For lack of a better starting reference, let me suggest ...
Dan Langille
Dec 8, 2002 at 3:03 am
Dec 10, 2002 at 7:12 pm -
Just wondering where I should put my modified tuning notes. I was planning on making them section 3.7 in the Admin guide. Does that sound reasonable? The current version can be seen at: ...
Philip Warner
Dec 11, 2002 at 2:42 pm
Dec 14, 2002 at 12:31 am -
I've been looking at the recently-committed ALTER DOMAIN patch, and I think it's got some serious if not fatal problems. Specifically, the approach to adding/dropping constraints associated with ...
Tom Lane
Dec 10, 2002 at 5:39 pm
Dec 12, 2002 at 2:45 pm -
Steve King
Dec 13, 2002 at 9:29 am
Dec 18, 2002 at 8:47 pm -
I just sync'd up with cvs and tried to make clean then configure, and I'm getting this: config.status: linking ./src/backend/libpq/v6util.c to src/interfaces/libpq/v6util.c config.status: error: ...
Joe Conway
Dec 6, 2002 at 4:09 am
Dec 9, 2002 at 6:13 pm -
I am not going to apply this patch because I think it will mess up the handling of other locales. --------------------------------------------------------------------------- Nicolai Tufar wrote: -- ...
Bruce Momjian
Dec 5, 2002 at 6:19 am
Dec 9, 2002 at 5:47 pm -
Unfortunately there doesn't seem to be any easy way to do this. There is no ALTER SEQUENCE command and you can't use UPDATE on a sequence. Hackers: Could this be a TODO item for 7.4? The easiest way ...
Oliver Elphick
Dec 4, 2002 at 2:17 pm
Dec 5, 2002 at 7:25 pm -
Tom, Folks: Joe and I were discussing your recent discussion about the costs of VACUUM and tuple maintainence, and I had an interesting idea. How hard would it be to add a "WITH (VACUUM)" option to ...
Josh Berkus
Dec 16, 2002 at 10:04 pm
Dec 17, 2002 at 6:38 pm -
I've found a situation that doesn't look correct to me in 7.3.1 (and presumably 7.3 as well). If I alter a column so that it no longer uses a sequence for default values and then try to drop the ...
Tara Piorkowski
Dec 30, 2002 at 4:09 pm
Dec 31, 2002 at 6:05 pm -
I wonder if EXECUTE could/should be made to return the appropriate command status string for the executed statement, instead of "EXECUTE". regards, tom lane
Tom Lane
Dec 20, 2002 at 2:36 pm
Dec 23, 2002 at 1:35 am -
I've been playing around with making it possible to create user defined guc variables. This has been discussed, at least in passing, before. And it is even anticipated in guc.c as a possible future ...
Joe Conway
Dec 19, 2002 at 1:01 am
Dec 19, 2002 at 11:36 pm -
Joe, have you heard of a standard called SQL/MED? I came across a description of it the other day. You might think it's got some medical connotation, but actually the acronym is Management of ...
Tom Lane
Dec 6, 2002 at 4:09 pm
Dec 6, 2002 at 8:57 pm -
Cool :) I'm now working on postmaster windows shell. It's not finished yet but main things work. Funcionality implemented now is : Console redirection for capture output from postmaster ...
Igor Georgiev
Dec 5, 2002 at 12:47 pm
Dec 6, 2002 at 11:08 am -
I think the python interface in /interfaces/python should be moved to gborg. It already has its own web site: http://www.druid.net/pygresql/ and there is also another one, pyPgSQL, at: ...
Bruce Momjian
Dec 17, 2002 at 7:10 pm
Jan 8, 2003 at 3:17 pm -
Hi every one and happy Xmas. Hope you can still answer that one. Waiting for my brand you server, I've installed an old bi-PII 300 unser unixware 713 and trying postgresql 7.3.1 with it. Compile ...
Olivier PRENANT
Dec 26, 2002 at 5:25 pm
Dec 27, 2002 at 7:07 pm -
Hi all, I've been thinking about resource management and postgres. I want to develop a user profile system (a-la oracle) which allows a DBA to restrict/configure access to system resources. This ...
Gavin Sherry
Dec 21, 2002 at 2:29 am
Dec 22, 2002 at 6:01 am -
Hi guys, Just a thought - do we explicitly wipe password strings from RAM after using them? I just read an article (by MS in fact) that illustrates a cute problem. Imagine you memset the password to ...
Christopher Kings-Lynne
Dec 17, 2002 at 2:07 am
Dec 17, 2002 at 6:28 pm -
Can anyone tell me how to get a tuple's TupleDesc if all that is known is the tid? Or is there an easy way to step through a tuple, retrieving the data and data type from each field? Thanks, Nate ...
Nate Sommer
Dec 10, 2002 at 4:08 am
Dec 10, 2002 at 7:14 am -
I am working on getting a shrink-wrapped version of PostgreSQL for Windows Currently it installs a customized version of Cygwin, PostgreSQL 7.2.3, cygipc, psqlodbc, and pgadminII I currently have the ...
Mark L. Woodward
Dec 3, 2002 at 6:14 am
Dec 3, 2002 at 7:24 pm -
The following statements do not utilize an index when executed inside a plpgsql procedure, but does when executed interactively in psql! Does not use index: FOR somemorerows IN SELECT zipcode_list ...
Ryan Mahoney
Dec 20, 2002 at 10:19 pm
Dec 21, 2002 at 8:56 pm -
Hi, I am doing some experiments on dead tuples, I am looking of reusing the dead tuples apace in a particular page during the "Update".This patch is meant for the tables which are heavily updated to ...
Janardhan
Dec 11, 2002 at 2:40 am
Dec 18, 2002 at 8:21 am -
(crossposting to hackers) Something along the lines of char *PQversion(const PGconn *conn) ? Sounds good to me. Is it on the todo-list? (Couldn't see it there). Ian Barwick barwick@gmx.net
Ian Barwick
Dec 10, 2002 at 3:38 pm
Dec 12, 2002 at 12:19 am -
Looking at my problem with changed cursor behaviour in 7.3 again, I noticed something interesting: a cursor in 7.3 apparently does not let you scroll back to its first row at all! Neither a "move ...
Jeroen T. Vermeulen
Dec 8, 2002 at 6:28 pm
Dec 8, 2002 at 10:58 pm -
Was it necessary? No idea, you're welcome to search through the pgsql-hackers archives to determine the reasoning behind the change. I believe the change was made by Bruce Momjian (going by the ...
Lee Kindness
Dec 3, 2002 at 11:08 am
Dec 3, 2002 at 5:22 pm -
Is there a known problem with TOAST tables growing indefinitely in 7.2? We have a database that has large text chunks inserted & deleted regularly, and despite regular vacuums, the toast table ...
Philip Warner
Dec 2, 2002 at 3:25 am
Dec 3, 2002 at 6:34 am -
Hello In PostgreSQL 7.2/7.1: template1=# select text(2.000::numeric); text ------ 2 (1 row) In 7.3: template1=# select text(2.000::numeric); text ------- 2.000 (1 row) The text(numeric) function ...
Szima Gábor
Dec 1, 2002 at 4:48 pm
Dec 2, 2002 at 8:18 pm -
I have not been aggressive about backpatching documentation improvements into 7.3.1. Is that something I should check? As I remember, we didn't update the official docs for minor releases. Is that ...
Bruce Momjian
Dec 18, 2002 at 2:25 am
Dec 19, 2002 at 11:38 pm -
I'm working on the TODO item "Allow easy display of usernames in a group" in the context of a slightly larger effort to improve usability of arrays. I'm far enough down the road to have a better idea ...
Joe Conway
Dec 8, 2002 at 4:52 pm
Dec 11, 2002 at 10:33 pm -
Rod, can you comment on these warnings Joe Conway's compiler is showing? I don't see the warnings with gcc, but clearly they look like problems. I can just assign a NULL on definition, but I thought ...
Bruce Momjian
Dec 7, 2002 at 3:58 am
Dec 9, 2002 at 6:44 pm -
Han Holl's recent complaint about memory leaks in SQL-language functions has started me thinking again about making plan trees read-only to the executor. This would make it a lot easier to manage ...
Tom Lane
Dec 2, 2002 at 12:21 am
Dec 2, 2002 at 5:03 pm -
Last night, we packaged up v7.3.1 of PostgreSQL, our latest stable release. Purely meant to be a bug fix release, this one does have one major change, in that the major number of the libpq library ...
Marc G. Fournier
Dec 22, 2002 at 7:12 pm
Dec 30, 2002 at 3:51 am -
Hi all, I'm planning an upgrade from 7.2.3 to 7.3.1 on some HP-UX systems. With the major number bump in 7.3.1 I was expecting to be able to do this upgrade without a flag day to re-compile clients, ...
Giles Lean
Dec 23, 2002 at 2:24 am
Dec 23, 2002 at 10:24 pm -
I'm working on a new interface to PostgreSQL and having a difficult time. Perhaps someone here can shed some light on the subject. 1. Am I correct in thinking that the OID that I receive with the ...
Reggie Burnett
Dec 6, 2002 at 2:57 pm
Dec 6, 2002 at 3:40 pm -
Not that anyone cares, but I notice in the commit logs for MySQL 4.1, it now has subselects. Chris
Christopher Kings-Lynne
Dec 4, 2002 at 2:55 am
Dec 4, 2002 at 2:55 pm
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 161 |
posts | 1,176 |
users | 131 |
website | postgresql.org... |
irc | #postgresql |
131 users for December 2002
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)