Search Discussions
-
When we started on 7.4 development, I was hoping for three major features: o PITR (point-in-time recovery) o Win32 port o Master-slave Postgres-R Now, the last one isn't going to happen because we ...
Bruce Momjian
May 5, 2003 at 7:23 pm
May 15, 2003 at 3:00 am -
Looking through the TODO list I noticed this item apparently unclaimed: * Allow CIDR format to be used in pg_hba.conf I can look at doing this, having done similar code some years ago. Internally, it ...
Andrew Dunstan
May 7, 2003 at 1:51 pm
May 9, 2003 at 4:12 pm -
pgsql-core have agreed to put out a 7.3.3 release on Wednesday (5/21), God willin' an' the creek don't rise. If anyone's got anything you've been planning to fix in the 7.3 branch, now is a real good ...
Tom Lane
May 16, 2003 at 5:15 am
May 22, 2003 at 8:31 am -
I didn't find any documentation mentioning scheduled jobs. I assume there is no such a feature yet. I would like to implement it if someone helps me with the development process (I am brand new to ...
Zlatko Michailov
May 12, 2003 at 10:03 pm
May 22, 2003 at 2:15 pm -
[Please CC any replies to me. Thanks.] I'm going suggest a feature like what Oracle calls "partitions" and later on something with indexes. The idea is to generate some discussion to see if they are ...
Martijn van Oosterhout
May 17, 2003 at 3:00 pm
Jun 2, 2003 at 6:43 pm -
Folks, I'm trying to prepare comprehensive documentation on the contents of the postgresql.conf file for 7.3.2. However, I'm running into some confusion in the docs (which is why I'm preparing the ...
Josh Berkus
May 12, 2003 at 5:20 pm
May 15, 2003 at 3:49 pm -
Pgsql developers: Based on a question posed me by David Fetter of Bricolage, I realized that we have what looks to me to be a serious inconsistency in our permissions model. Please ignore me if this ...
Josh Berkus
May 20, 2003 at 5:08 pm
Jun 2, 2003 at 6:54 pm -
At least in 7.3, triggered actions specified as AFTER seem to be deferred to the completion of the outer-most SQL statement. So, if two triggering statements are executed as part of a PLPGSQL ...
Philip Warner
May 5, 2003 at 5:31 am
Jul 21, 2003 at 7:05 pm -
SET CONSTRAINTS doesn't allow you to schema-qualify a constraint name. Here's an example: create schema test; create table test.foo (a int primary key); create table test.bar (b int primary key, c ...
Peter Eisentraut
May 11, 2003 at 4:44 pm
Jun 4, 2003 at 9:50 pm -
Folks, An area in which postgresql planner & indexing could be improved have occurred to me over the last week. I'd like to share this ideas with you in case it is worthy of the todo list. Please ...
Josh Berkus
May 5, 2003 at 7:20 pm
May 7, 2003 at 2:19 pm -
Moved to -hackers. Well, I'm not sure about this. In fact, if the reasoning below is correct, we can get away with static Serializable- and QuerySnapshots. I don't think it makes sense to change the ...
Alvaro Herrera
May 13, 2003 at 3:59 am
May 23, 2003 at 7:34 pm -
I'm about to start going through the backend's elog() calls to update them to ereport() style, add error code numbers, polish wording, etc. So it's time to nail down our style guide for message ...
Tom Lane
May 14, 2003 at 8:58 pm
Aug 17, 2003 at 12:14 am -
*Way* off topic ... but I'm tired of processing through 300 messages nightly of which 10 are stuff that need to be approved for the lists, and 290 are trash ... What are ppl using / trusting out ...
Marc G. Fournier
May 27, 2003 at 8:41 pm
May 30, 2003 at 7:57 pm -
I see an obvious problem in the way pg_dump dumps serials. At the moment, we have length 64 identifiers. If someone has a 64 character table name and adds a serial to it, it will get a truncated ...
Christopher Kings-Lynne
May 4, 2003 at 4:14 am
May 5, 2003 at 3:50 pm -
I remember there was some talk about removing the width=xxx part from the EXPLAIN plans. Any movement towards this? I myself would like to see this happen as it does not provide useful information ...
Greg Sabino Mullane
May 19, 2003 at 10:17 pm
May 22, 2003 at 7:59 am -
We're running into problem with vacuum analyze. We first noticed that with Postgres v.7.2.1. Now with v.7.3.2 it appears again. After nightly maintenance application isn't functioning. It looks that ...
Michael Brusser
May 23, 2003 at 3:08 pm
May 28, 2003 at 2:17 pm -
The discussion below has been taking place on the PATCHES list. I'm forwarding it to HACKERS to get a wider audience. We're looking for opinions on (at a minimum): 1) Which of these functions should ...
Joe Conway
May 25, 2003 at 6:16 pm
May 27, 2003 at 3:25 am -
In working on an rint() for Win32, I found two --- one in port/qnx4/rint.c and another in dt_common.c. The first is very simple, using fmod, while the second is very complicated. I would like to pick ...
Bruce Momjian
May 9, 2003 at 2:13 am
May 10, 2003 at 11:54 am -
Hi-- I've recently installed Slackware 9 (after using Mandrake and RedHat in the past), and I've been attempted to build both Postgres 7.3 and 7.1, and I'm not having success with either of them. The ...
Brian janaszek
May 4, 2003 at 1:57 pm
May 4, 2003 at 6:52 pm -
What's the rationale for not including the trailing zero byte in the protocol representation of the text format? The output functions of data types generate one, and the client most likely wants one, ...
Peter Eisentraut
May 13, 2003 at 11:11 pm
May 23, 2003 at 2:15 pm -
Are there any plans to make index names unique to a table instead of to a schema? I was thinking similar to the way that constraints are handled. It's not really necessary, but it would be kinda nice ...
Sean Chittenden
May 8, 2003 at 8:06 pm
May 12, 2003 at 12:25 am -
I've been starting to look at assigning SQLSTATE values to all the backend elog() calls, and have realized that the set of values defined by the spec is very, how you say, uneven. They have ...
Tom Lane
May 30, 2003 at 1:32 pm
May 30, 2003 at 11:03 pm -
Dear Sir, I want to know the compilaiton and execution of my code. Suppose if i add a test printf statement in the src/backend/tcop/postgres.c and after compilation and execution i should get that ...
Srikanth M
May 28, 2003 at 7:19 am
May 28, 2003 at 2:25 pm -
I am seeing a compile failure in variable.c because it references timezone, but I only have struct tm on BSD/OS. --------------------------------------------------------------------------- Tom Lane ...
Bruce Momjian
May 22, 2003 at 8:35 am
May 22, 2003 at 9:00 pm -
Hi, I was going thr. a oracle refresher course today. I came across this concept of system triggers which can be installed on things like database/connection startup. I think it would be a good ...
Shridhar Daithankar
May 16, 2003 at 2:16 pm
May 20, 2003 at 3:03 pm -
Running some process on Postgres 7.3.2 I consistently end up with a crash. This happens on Linux RedHat 6.2, kernel 2.2 Here's the fragment from the database log. 2003-05-07 14:38:48 LOG: recycled ...
Michael Brusser
May 7, 2003 at 7:30 pm
May 9, 2003 at 3:56 pm -
Tom, are we moving to a C locale by default for 7.4? -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can ...
Bruce Momjian
May 6, 2003 at 11:08 pm
May 8, 2003 at 2:40 am -
Now that expressions can be used in indexes in 7.4 you can have multicolumn indexes that are ordered in different directions. However the planner doesn't seem to understand that order by -col asc is ...
Bruno Wolff III
May 30, 2003 at 3:59 pm
May 30, 2003 at 7:54 pm -
What capabilities do we have for removing a user's password? The only way I can see to do it is to insert a NULL into pg_shadow, but clearly that is pretty ugly. I don't see any mention in the ALTER ...
Bruce Momjian
May 26, 2003 at 5:33 pm
May 27, 2003 at 1:45 am -
I would like to re-table my proposal from many moons ago to allow pattern-matching operations to use indexes under any locale. The idea is that since pattern matching works on a ...
Peter Eisentraut
May 12, 2003 at 5:32 pm
May 13, 2003 at 4:47 pm -
RH7.3 is a supported distribution for at least 6 months. Any plans to add Postgres 7.3.3 RPMs for RH7.3? Thanks
Ow
May 29, 2003 at 11:26 am
May 29, 2003 at 10:24 pm -
My understanding (from the documentation and from a quick code check is that the PL/Python code uses Python's "rexec" ability to provide a restricted execution environment for the Python code. For ...
Sean Reifschneider
May 25, 2003 at 10:48 pm
May 28, 2003 at 2:47 am -
Something we've discussed repeatedly is adding a log rotation program to the distribution so that we don't have to hand-wave in the part of the documentation that talks about setting up ...
Tom Lane
May 23, 2003 at 7:14 pm
May 24, 2003 at 1:22 pm -
Hi I would like to notify a server whenever a certain table is updated. I wonder if this hasn't been solved before. I looked at contrib and Gborg with no success. Maybe it could be a function that ...
Kaare Rasmussen
May 20, 2003 at 9:31 am
May 20, 2003 at 7:32 pm -
I think that would be reasonable, yes. After all one argument for using binary mode is speed and efficiency, and not it's editability with a text editor. Andreas
Andreas Zeugswetter
May 14, 2003 at 4:27 pm
May 15, 2003 at 2:26 pm -
Anyone know whats up with the postgresql cookbook website? (http://www.brasileiro.net/postgres/cookbook/) Seems like it's been down for awhile now. The site maintainers name escapes me (I thought it ...
Robert Treat
May 9, 2003 at 5:11 pm
May 12, 2003 at 11:05 pm -
I just noticed that there is an inconsistency between the way that PREPARE executes multiple queries (since PREPARE itself accepts only one SQL statement, any such multiple queries must have been ...
Tom Lane
May 1, 2003 at 3:55 pm
May 3, 2003 at 2:18 pm -
I have noticed that after "/etc/init.d/postgresql restart", postmaster is no longer writes to "serverlog". (RedHat 9). Here is fixed "restart" section. restart) echo -n "Restarting PostgreSQL: " su - ...
Darko Prenosil
May 29, 2003 at 6:37 pm
Jun 12, 2003 at 2:02 am -
Hi, The following (link to a) patch is a first attempt to add updates during a \copy. This is so that one has some idea of progress. The output looks as follows: kleptog=# \copy website to /tmp/g ...
Martijn van Oosterhout
May 19, 2003 at 10:38 pm
Jun 6, 2003 at 7:47 pm -
Hi! Simple test suite for current CVS: %initdb ... %createdb q %psql q q=# select * from pg_class limit 1; SELECT q=# select * from pg_class limit 2; server sent data ("D" message) without prior row ...
Teodor Sigaev
May 26, 2003 at 10:17 am
May 26, 2003 at 5:54 pm -
Would anyone object to replacing $Header$ and $Id$ with $PostgreSQL$ for a file version marker? This would some of us to work in our own repo's without losing the PostgreSQL version information -- ...
Rod Taylor
May 22, 2003 at 3:46 am
May 23, 2003 at 5:23 pm -
On my Red Hat 9 machine I'm getting the following error during compile when configured --with-krb5=/usr/kerberos: i386-redhat-linux-gcc -O2 -g -Wall -Wmissing-prototypes -Wmissing-declarations -fpic ...
Joe Conway
May 16, 2003 at 4:27 am
May 19, 2003 at 10:09 pm -
Per the discussion earlier re: sockets and psql
Alex avriette
May 12, 2003 at 2:55 am
May 14, 2003 at 12:09 am -
Hi People! As a project manager I decided to migrate the full project from Oracle to PostgreSQL. We bought a new Intel box to host the database, it is a dual Xeon 2.2 and I intend to use it with ...
Lista
May 8, 2003 at 3:55 pm
May 8, 2003 at 7:57 pm -
This is what I have seen in the SAP DB mailing list this weekend ... Maybe all of us should have some fun. SAP has finally gone completely insane. I can already see Monty on every SAP advertisment ...
Hans-Jürgen Schönig
May 25, 2003 at 7:35 pm
Jun 5, 2003 at 5:49 am -
We need to track sequence usage in things like defaults. nextval() function calls don't easily allow this to happen. The 200N spec has NEXT VALUE FOR <seqname as the equivalent to nextval(), which ...
Rod Taylor
May 25, 2003 at 3:39 am
May 29, 2003 at 7:17 pm -
Hi Tom and Fernando! I can see on the todo-list, that you have subscribed to the item regarding "WITH RECURSIVE" select statements. I really look forward to this feature, but can't find anything ...
XST
May 26, 2003 at 12:38 pm
May 29, 2003 at 4:13 pm -
It is a common problem that a server uses a nontrivial character set encoding (e.g., Unicode) but users forget to set an appropriate client-side encoding. Then they get bogus displays for non-ASCII ...
Peter Eisentraut
May 28, 2003 at 9:53 pm
May 29, 2003 at 9:09 am -
While playing with the array stuff earlier, I noticed this (using a non-array example to be sure it wasn't related to anything unique to my development environment): regression=# create function ...
Joe Conway
May 27, 2003 at 3:52 am
May 28, 2003 at 6:38 pm -
Since several hours I'm getting errors on accessing http://techdocs.postgresql.org/ Same on http://www.postgresql.org/ Did I miss something? Regards, Christoph
Christoph Haller
May 27, 2003 at 12:40 pm
May 27, 2003 at 2:34 pm
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 159 |
posts | 802 |
users | 129 |
website | postgresql.org... |
irc | #postgresql |
129 users for May 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)