Search Discussions
-
We were discussing prepared statement support for libpqxx just now (Bruce, Peter Eisentraut & myself are manning the postgres booth at LinuxTag 2004 in Karlsruhe, Germany), when we ran into a problem ...
Jeroen T. Vermeulen
Jun 23, 2004 at 4:16 pm
Jul 12, 2004 at 9:59 am -
(warning: rehashing of issues ahead) Sometimes when I talk to technical people about using PostgreSQL, I get a strong reaction along the lines of "it's ugly, complex, and hard to set up." While we ...
Greg Sabino Mullane
Jun 9, 2004 at 10:20 am
Jun 16, 2004 at 6:49 pm -
I have an idea, let me know what you all think. rather than do: select sum( field) from largetable I want (need) to be able to do something like this: select setval('myseq', select sum(field) from ...
Mark L. Woodward
Jun 8, 2004 at 3:15 am
Oct 21, 2004 at 4:32 pm -
Hi, This is a preview patch - DON'T COMMIT IT TO HEAD! What I've done in this patch is add the following: ALTER AGGREGATE / OWNER TO ALTER CONVERSION / OWNER TO ALTER FUNCTION / OWNER TO ALTER ...
Christopher Kings-Lynne
Jun 15, 2004 at 2:57 am
Jun 19, 2004 at 8:29 am -
I see the problems with the existing mechanisms, but just to float an idea - what about adding a GUC variable that can be used to specify an amount of shared memory to use as a fifo area in which a ...
Dave Page
Jun 7, 2004 at 1:44 pm
Jun 19, 2004 at 3:05 am -
I am wondering why thread_test.c is checking for mktemp()? That function is nowhere used in the libpq. Also, I would suggest that we allow to build the libpq with thread specific compiler options, ...
Jan Wieck
Jun 9, 2004 at 1:13 pm
Jul 10, 2004 at 1:23 am -
They still suck; I'm not aware of any situation where I'd recommend hash over btree indexes in Postgres. I think we have fixed the hash indexes' deadlock problems as of 7.4, but there's still no real ...
Tom Lane
Jun 5, 2004 at 8:03 pm
Aug 14, 2004 at 12:35 am -
I was just about to commit a patch that revises the btree index build procedure as discussed here: http://archives.postgresql.org/pgsql-general/2004-05/msg00480.php specifically, not using shared ...
Tom Lane
Jun 1, 2004 at 12:28 am
Jun 1, 2004 at 8:31 pm -
I've been down several roads about how to handle data that has to change on a very frequent and rapid manner. Think about summary tables, WEB session tables, etc. As great as MVCC is for the vast ...
Mark L. Woodward
Jun 8, 2004 at 7:07 pm
Jun 10, 2004 at 5:42 pm -
I think a warning is missing if I create a table without OIDS that inherits from a table with oids: kalman=# create table test ( a integer ); CREATE TABLE kalman=# create table test_2 ( b integer ) ...
Gaetano Mendola
Jun 22, 2004 at 10:38 pm
Jun 28, 2004 at 11:14 am -
I have been harping for the last few days (years, actually) about tweaks and changes to PostgreSQL for a number of reasons ranging from session management to static tables. I even had a notion to ...
Mark L. Woodward
Jun 12, 2004 at 4:19 am
Jun 14, 2004 at 11:21 am -
Why does postgres maintain a loader logic of its own? I can understand that the dynamic_library_path is necessary in order to configure everything in one single place. But why not just merge it with ...
Thomas Hallgren
Jun 8, 2004 at 8:48 am
Jun 9, 2004 at 2:36 pm -
Hello all, I've created a lock timeout patch and it's attached. When a transaction is blocked by another transaction because of waiting a lock, we need a lock timeout in some cases. Using this patch, ...
Satoshi Nagayasu
Jun 28, 2004 at 3:29 am
Jun 30, 2004 at 3:19 am -
OK, I think it might save me some time if I get some guidance on how we should modify pg_dump to fix the owner/grants issue. I intend to make new archives created with 7.5 pg_dump have the fix, and ...
Christopher Kings-Lynne
Jun 24, 2004 at 3:52 am
Jun 28, 2004 at 3:46 am -
I have tried your patches and it works great. Thanks. One thing I noticed was if I change tablespace for a table having indexes, they are left in the old tablespace and the table itself was moved to ...
Tatsuo Ishii
Jun 20, 2004 at 12:39 pm
Jun 21, 2004 at 5:14 am -
I'm getting the following error when trying to initdb with CVS tip. This is on win XP, though I don't know if it's win32 specific. Also of note, although it says it's clearing the contents of the ...
Dave Page
Jun 18, 2004 at 10:21 pm
Jul 28, 2004 at 2:30 pm -
Hi all, Can anyone tell me if postgresql has problems with xeon processors? If so, there is any fix or project of fix it? Thanx in advance, Jaime Casanova
Jaime Casanova
Jun 25, 2004 at 8:13 pm
Jul 1, 2004 at 5:03 pm -
I've noticed yet another hole in our handling of object permissions, which is that ALTER OWNER doesn't modify the object ACL list at all. This leads to unpleasant results. For example, in CVS tip: ...
Tom Lane
Jun 1, 2004 at 10:07 pm
Jun 3, 2004 at 10:10 am -
In line with my idea of keeping the hackers up to date with stuff in the IRC channel, here are the topics of the week: * We have a request for granting on all tables every other day (already in TODO) ...
Christopher Kings-Lynne
Jun 15, 2004 at 6:18 am
Jun 16, 2004 at 6:37 am -
Hi, I checked out the windows port to play with. It compiled file but 'make check' produced attached regression diff. I am using the nightly snapshot. Is it too early to look at these failures or did ...
Shridhar Daithankar
Jun 7, 2004 at 10:57 am
Jun 8, 2004 at 4:33 pm -
Yes, Slonik's, it't true. After nearly a year the Slony-I project is entering the BETA phase for the 1.0 release. Please visit http://gborg.postgresql.org/project/slony1/news/newsfull.php?news_id=174 ...
Jan Wieck
Jun 4, 2004 at 5:01 am
Jun 8, 2004 at 12:35 pm -
Near the end of repair_frag() in vacuum.c -- under the comment /* clean moved tuples from last page in Nvacpagelist list */ -- there is code that marks itemids as unused. Itemids affected are those ...
Manfred Koizar
Jun 10, 2004 at 8:07 pm
Feb 15, 2005 at 3:50 am -
hi, i am wondering what you think about including evgen potemkin's patch for recursive SQL in the next postgres version: http://gppl.terminal.ru/ cons: - its not standard SQL (uses oracle style ...
jacob koehler (RRes-Roth)
Jun 26, 2004 at 7:21 pm
Jul 1, 2004 at 5:04 am -
Next Monday, we're going to put out a 7.4.3 release, incorporating all the little patches that have been back-patched to date ... I just setup a cron job that will build a nightly snapshot of ...
Marc G. Fournier
Jun 8, 2004 at 4:03 pm
Jun 14, 2004 at 2:24 pm -
Stop me if you've heard this before. I'm looking at fast calculation of aggregates (sum(), max(), count()) across large tables, or across fairly simply defined subsets of those tables. Lets say that, ...
Steve Atkins
Jun 11, 2004 at 7:42 am
Jun 15, 2004 at 3:47 am -
(moved to -hackers) Is it conceivable that different SERIAL sequence names could now be generated? ie. If I upgrade from 7.4 with a dump that looks like this: CREATE TABLE blah ( id SERIAL ); COPY ...
Christopher Kings-Lynne
Jun 11, 2004 at 1:42 am
Jun 13, 2004 at 5:24 pm -
There's just one thing left to do to make composite types useful as table columns: we have to support I/O of composite values. (Without this, pg_dump would fail to work on such columns, rendering ...
Tom Lane
Jun 5, 2004 at 4:57 pm
Jun 10, 2004 at 2:26 pm -
Would anyone else think that dumping: SET client_min_messages TO warning; In pg_dumps would be cool? It would mean that while restoring a dump you can actually see the wood for the trees when trying ...
Christopher Kings-Lynne
Jun 29, 2004 at 2:43 am
Jul 11, 2004 at 9:50 pm -
Hi! since we have a lot of databases here that suffer from pg_dump's deficits in 7.3 and 7.4 regarding dependencies, we tried pg_dump from the upcoming 7.5 release. This version works much better, ...
Stefan Kaltenbrunner
Jun 18, 2004 at 2:38 pm
Jun 25, 2004 at 6:16 am -
Although DROP TABLESPACE can detect tables existing in the target tablespace, it doesn't have any way to detect schemas that reference that tablespace as their default tablespace. Thus you can get ...
Tom Lane
Jun 19, 2004 at 1:10 am
Jun 19, 2004 at 10:26 pm -
template1=# BEGIN; BEGIN template1=# CREATE TABLE foobar (foo char(10)); CREATE TABLE template1=# select relname, relfilenode from pg_class where relname='foobar'; relname | relfilenode ...
Heikki Linnakangas
Jun 12, 2004 at 12:49 pm
Jun 14, 2004 at 1:49 pm -
Dear hackers, It seems that current cvs head regression tests are broken, at least on my debian laptop. That does not help with developping some new patch... sh uname -a Linux sablons 2.4.20-3-686 #1 ...
Fabien COELHO
Jun 8, 2004 at 1:53 pm
Jun 9, 2004 at 4:53 am -
For adminstrator's convenience, I'd like to see a function that returns the serverlog. Are there any security or other issues that should prevent me from implementing this? Regards, Andreas
Andreas Pflug
Jun 7, 2004 at 12:01 am
Jun 7, 2004 at 3:54 pm -
Is it me or has the default locale of created databases change at some point? Currently, on Linux, if one does not specify a locale, the locale is taken from the system environment and it is not "C." ...
Mark L. Woodward
Jun 2, 2004 at 5:39 pm
Jun 3, 2004 at 2:10 am -
Now that PG will have tablespaces I can stick my really high I/O data on a fiberchannel array, and save some money by putting the rest of it (also the majority of it) on less expensive SCSI RAID ...
Mike Rylander
Jun 28, 2004 at 7:14 pm
Aug 6, 2004 at 2:11 pm -
Chris KL just raised an issue on IRC: test= create table test (a int4) tablespace pg_default; ERROR: permission denied for tablespace pg_default This wasn't encountered in my original patch because ...
Gavin Sherry
Jun 28, 2004 at 5:35 am
Jun 29, 2004 at 1:45 pm -
Tom doesn't like returning the server's logfile using a pgsql function unless logfile rotation is implemented, so here it is. This proposal doesn't include a daemon that triggers pg_logfile_rotate ...
Andreas Pflug
Jun 13, 2004 at 4:43 pm
Jun 19, 2004 at 9:10 am -
Hi All, I've been attempting to recover some data from a data file that was dumped and compressed using pg_dump. I've noticed that the pg_restore application was supposed to have some work put into ...
Chris Bowlby
Jun 15, 2004 at 4:54 pm
Jun 16, 2004 at 2:09 am -
(sorry I have to post it again in plain text) I'm currently working on a master student research project ¡°support triggers on columns¡± that is supervised by a professor from my university (Ottawa ...
Mark
Jun 28, 2004 at 1:44 pm
Jan 29, 2005 at 4:20 am -
Hackers, I think there a bug in the GUC mechanism. The custom variables patch added several malloc() and a strdup() call, and they are never checked for an out of memory condition. -- Alvaro Herrera ...
Alvaro Herrera
Jun 24, 2004 at 5:27 am
Jun 24, 2004 at 5:29 pm -
Dear Gurus, I tried to shuffle through the archives but was lost in the technical details. Please feel free to tell me a search keyword suitable for my case if there's any. QUESTION1: is this error ...
Szűcs Gábor
Jun 9, 2004 at 8:30 am
Jun 10, 2004 at 3:03 pm -
It has been suggested a couple of times that we should use a different syntax for subtransactions than for main transactions. This would for example allow things like BEGIN; do something; SUBBEGIN; ...
Alvaro Herrera
Jun 26, 2004 at 4:49 am
Jul 11, 2004 at 12:21 am -
...on the assumption we now have archived xlogs, how do we do recovery? Default is to put all xlogs back into pg_xlog and then let recovery do its work...though clearly we all want finer ...
Simon Riggs
Jun 15, 2004 at 8:52 pm
Jun 23, 2004 at 8:46 am -
In phpPgAdmin, I need to know if the backend supports tablespaces or not. What is the most reliable way of detecting that the backend is the win32 native version and hence does not support ...
Christopher Kings-Lynne
Jun 30, 2004 at 2:45 pm
Jun 30, 2004 at 10:06 pm -
I'm having trouble accessing specific schemas and wonder if maybe I haven't installed something properly in 7.4.2. Here is what is happening: SELECT * FROM INFORMATION_SCHEMA.SCHEMATA; ERROR: parser: ...
Cason, Kenny
Jun 29, 2004 at 7:07 pm
Jun 30, 2004 at 12:27 am -
Where are we on this? --------------------------------------------------------------------------- Tom Lane wrote: -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + ...
Bruce Momjian
Jun 11, 2004 at 6:22 pm
Jun 24, 2004 at 11:01 am -
Hi all, I have defined a datatype called "varcharci", shamelessly yanking the input, output, recv and send functions from varchar. This means (as far as I understand things) that this type is binary ...
Shachar Shemesh
Jun 17, 2004 at 4:58 pm
Jun 22, 2004 at 1:46 pm -
(Moved to -hackers) Comment on TABLESPACE is impossible, no? Tablespaces are a global relation and pg_description isn't. I'll do RENAME and OWNER TO for tablespaces with this patch I'm working on atm ...
Christopher Kings-Lynne
Jun 18, 2004 at 6:37 am
Jun 19, 2004 at 8:24 am -
[ Thread moved to hackers and win32.] Andreas Pflug wrote: What is the recommended way to create mutex objects (CreateMutex) from Win32 libraries? There must be a clean way like there is in pthreads. ...
Bruce Momjian
Jun 11, 2004 at 6:03 pm
Jun 14, 2004 at 5:33 am -
DBMS like MySQL and hsqldb (the only two I know that can keep and process tables on the heap) have a CREATE DATABASE case in which the 'database' is specified to reside in memory, that is RAM. For ...
Albretch
Jun 6, 2004 at 6:17 pm
Jun 8, 2004 at 12:44 am
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 156 |
posts | 1,037 |
users | 138 |
website | postgresql.org... |
irc | #postgresql |
138 users for June 2004
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)