Search Discussions
-
Here is a simple select output. darcy=# select title_id, title_name from title; title_id | title_name ----------+------------ 2 | Mrs 3 | Ms 4 | Miss (3 rows) Now I change the border. darcy=# \pset ...
D'Arcy J.M. Cain
Aug 21, 2008 at 4:16 pm
Jan 14, 2009 at 3:32 am -
This is a followup for thread "plan invalidation vs stored procedures". The background is that it is impossible to change function return type without dropping and recreating. Unfortunately dropping ...
Martin Pihlak
Aug 6, 2008 at 6:28 pm
Sep 9, 2008 at 7:06 pm -
Current GUC units code has 2 problems: - It requires case-sensiteive representation of units ("kB"). As the main point of units is to make configuring easier, requiring byte-exact typing makes them ...
Marko Kreen
Aug 31, 2008 at 10:17 pm
Sep 11, 2008 at 12:20 pm -
"a"= "b" is a value of hstore type, so query should be: select '"a"= "b"'::hstore; " character was chosen to simplify escaping, I see, but your problem is that password is one-way encrypted, so, you ...
Teodor Sigaev
Aug 23, 2008 at 10:04 am
Aug 25, 2008 at 7:06 am -
The way pg_hba.conf is set up to be loaded/parsed now, we have: postmaster: open and tokenize file (load_hba(), tokenize_file()). backend: parse lines (parse_hba) and check for matches ...
Magnus Hagander
Aug 2, 2008 at 10:58 am
Sep 15, 2008 at 8:55 pm -
I seem to recall that there was general support for installing a smaller default postgresql.conf file with only, say, a dozen parameters mentioned for initial tuning. The complete file can stay as a ...
Peter Eisentraut
Aug 19, 2008 at 9:58 am
Aug 28, 2008 at 6:23 pm -
I'm implementing collation support. Proposal can be found at http://archives.postgresql.org/pgsql-hackers/2008-07/msg00557.php Progress so far: - created catalogs pg_collation a pg_charset which are ...
Radek Strnad
Aug 31, 2008 at 9:39 pm
Sep 24, 2008 at 5:40 am -
I would like to propose some changes to the infrastructure for recovery. These changes are beneficial in themselves, but also form the basis for other work we might later contemplate. Currently * the ...
Simon Riggs
Aug 7, 2008 at 11:37 am
Jan 27, 2009 at 3:38 pm -
Currently dblink allows regular users to initiate libpq connection to user-provided connection string. This breaks the default policy that normal users should not be allowed to freely interact with ...
Marko Kreen
Aug 7, 2008 at 1:53 pm
Sep 23, 2008 at 3:28 am -
hello ... i picked up csaba nagy's idea and implemented a very simple yet very useful extension. i introduced a GUC called statement_cost_limit which can be used to error out if a statement is ...
Hans-Jürgen Schönig
Aug 2, 2008 at 6:20 pm
Aug 17, 2008 at 3:15 pm -
Here's the latest window functions patch against HEAD. It seems to be ready for the September commit fest, as added documents, WINDOW clause feature and misc tests. I guess this would be the window ...
Hitoshi Harada
Aug 29, 2008 at 5:04 pm
Sep 9, 2008 at 4:45 pm -
I'd like to stop autovac by changing the conf file then sending the server a HUP This "appears" to work, the logs show autovac terminated by administrative command. Then a few minutes later I see a ...
Dave Cramer
Aug 25, 2008 at 2:09 am
Aug 27, 2008 at 2:45 am -
Here's an updated FSM patch. Changes since last patch: - Per comments and discussion with Simon, I've changed the "bubble up" behavior so that when a bottom-level page is updated, if the amount of ...
Heikki Linnakangas
Aug 29, 2008 at 7:47 am
Sep 18, 2008 at 10:38 pm -
Hi, Thanks to Brendan Jurd, who spent a lot of effort in creating useful Mediawiki templates, we now have moved the TODO list to the Wiki site. The new official location for the TODO list is here: ...
Alvaro Herrera
Aug 20, 2008 at 5:12 pm
Aug 22, 2008 at 5:39 pm -
When primary server fails, it would be good if the clients connected to the primary knew to reconnect to the standby servers automatically. We might want to specify that centrally and then send the ...
Simon Riggs
Aug 4, 2008 at 9:02 pm
Aug 18, 2008 at 8:49 am -
Here's a patch that allows CREATE OR REPLACE VIEW to add new columns to an existing view. Any feedback would be appreciated, especially if it meant that I could fix any problems before the next ...
Robert Haas
Aug 7, 2008 at 12:05 pm
Dec 6, 2008 at 11:23 pm -
It occurred to me a while ago that our query cancel messages are sent unencrypted, even when SSL is otherwise used. That's not a big issue on its own, because the cancellation message only contains ...
Heikki Linnakangas
Aug 8, 2008 at 6:55 pm
Nov 21, 2008 at 4:31 am -
Howdy, What is the status of plan invalidation vs stored procedures? From the initial design discussion I understand that function change handling was postponed to "some time in the future". Is ...
Martin Pihlak
Aug 5, 2008 at 8:53 am
Aug 7, 2008 at 2:11 am -
Folks, As the things stored in databases grow, we're going to start needing to think about database objects that 4 bytes of size can't describe. People are already storing video in lo and bytea ...
David Fetter
Aug 18, 2008 at 8:09 pm
Aug 20, 2008 at 1:02 pm -
If we access a 1 block table using a SeqScan then it costs seq_page_cost, or 1 by default. If we access the same 1 block table using an IndexScan then the access costs random_page_cost to access the ...
Simon Riggs
Aug 12, 2008 at 6:25 pm
Aug 20, 2008 at 5:25 pm -
Hello all, I have been digging into the database page layout (specifically the tuples) to ensure the unsigned integer types were consuming the proper storage. While digging around, I found one thing ...
Ryan Bradetich
Aug 11, 2008 at 8:07 am
Sep 3, 2008 at 3:27 pm -
I feel the above comment about Firefox is the crux of the plugin issue. Having per-operating system options for each plugin is never going to scale. Having users compile/install these plugins works, ...
Bruce Momjian
Aug 12, 2008 at 3:51 am
Aug 16, 2008 at 9:19 pm -
Hello, Here is a patch to add duration option (-T) to pgbench instead of number of transactions (-t). -t and -T are mutually exclusive. $ pgbench -n -S -c10 -T10 transaction type: SELECT only scaling ...
ITAGAKI Takahiro
Aug 13, 2008 at 1:55 am
Sep 12, 2008 at 8:29 am -
Currently, we calculate a single OldestXmin across all snapshots on the assumption that any transaction might access any table. I propose creating "Visibility Groups" that *explicitly* limit the ...
Simon Riggs
Aug 7, 2008 at 10:31 am
Aug 11, 2008 at 7:02 pm -
Hello everybody. We have a dusty old server, FreeBSD 3.3-RELEASE, PostgreSQL 6.5.3. I need to migrate four DBs from old server to new server (FreeBSD 6.2, PostgreSQL 8.3.1). I've tried to do pg_dump ...
Alexander lunyov
Aug 14, 2008 at 2:28 pm
Aug 21, 2008 at 12:31 pm -
Hello, combination functions to_ascii and convert_to is broken now. Problem is in convert_to function. It doesn't support 8bit output encoding. Current workaround: CREATE FUNCTION to_ascii(bytea, ...
Pavel Stehule
Aug 11, 2008 at 7:39 am
Aug 12, 2008 at 6:59 am -
I've attached a patch that allows the generation of code coverage statistics. To test it, apply the patch, then: autoconf ./configure --enable-coverage make make check (or execute any other ...
Michelle Caisse
Aug 27, 2008 at 11:38 pm
Sep 5, 2008 at 2:40 pm -
I happened to be looking at nodes.h and started wondering just how sane this coding really is: extern PGDLLIMPORT Node *newNodeMacroHolder; #define newNode(size, tag) \ ( \ AssertMacro((size) = ...
Tom Lane
Aug 26, 2008 at 6:57 pm
Aug 30, 2008 at 3:51 pm -
Hi, After the Magnus patch [1], that make it possible store statistics files at another (RAM-based) disk, I was thinking that would be useful to add an option at initdb time to do the symlink as we ...
Euler Taveira de Oliveira
Aug 10, 2008 at 5:33 am
Aug 25, 2008 at 3:34 pm -
It seems there's something wrong with CheckOtherDBBackends() but I haven't exactly figured out what. There are no other sessions but drop database keeps saying "regression" is being accessed by other ...
Gregory Stark
Aug 4, 2008 at 12:29 pm
Aug 5, 2008 at 6:38 pm -
Volkan YAZICI
Aug 8, 2008 at 12:01 pm
Sep 9, 2008 at 3:16 pm -
Folks, While initdb allows you to choose a directory for transaction logs, it can't already exist, so it can't be in its usual place under $PGDATA. I'd like to propose that this be allowed by having ...
David Fetter
Aug 25, 2008 at 3:40 pm
Aug 26, 2008 at 9:01 pm -
Hi, Here's a patch to make autovacuum process TOAST tables separately from main tables. The most important change is that when called from autovac, vacuum does not process the TOAST table at all. It ...
Alvaro Herrera
Aug 8, 2008 at 4:58 pm
Oct 11, 2008 at 12:15 am -
It seems that we allow several function arguments to have same name (or is it label :) hannu=# create or replace function ff(a int, a int) returns int language plpgsql as $$begin return $1+$2; ...
Hannu Krosing
Aug 31, 2008 at 9:55 pm
Sep 2, 2008 at 3:02 pm -
I was looking just now at gram.y's handling of various peculiar SQL constructs, and was reminded of a point that's bothered me before, but I don't recall if it's ever been discussed explicitly on ...
Tom Lane
Aug 25, 2008 at 1:24 am
Aug 25, 2008 at 8:01 pm -
Gregory Stark
Aug 31, 2008 at 11:25 pm
Jan 8, 2009 at 12:25 am -
So, if you edit the current version of the TODO page, you get this stern warning: Hmm ... my browser isn't failing, but I do seem to detect a certain lack of snappiness to the edits. But what's more ...
Tom Lane
Aug 26, 2008 at 4:59 am
Aug 26, 2008 at 7:01 pm -
Here's a snapshot of my current work on improving IN/EXISTS support, pursuant to the discussion here: http://archives.postgresql.org/pgsql-hackers/2008-08/msg00347.php I'm posting it because it's a ...
Tom Lane
Aug 14, 2008 at 12:40 am
Aug 22, 2008 at 12:54 am -
Hi In HEAD, pg_stop_backup waits until the history file has been archived. But, in order to ensure that the last wal file was archived, pg_stop_backup should wait until not only the history file but ...
Fujii Masao
Aug 7, 2008 at 12:14 pm
Sep 8, 2008 at 4:44 pm -
Current content of control file is insufficient to check if database is compatible with postgres server. I think we should create footprint file which will contains all page data structures and their ...
Zdenek Kotala
Aug 11, 2008 at 5:40 am
Aug 11, 2008 at 2:44 pm -
Hello, I'd like to use NDirectFileRead and NDirectFileWrite statistics counters for counting reads and writes in BufFile. They are defined, but not used now. BufFile is used for tuple sorting or ...
ITAGAKI Takahiro
Aug 1, 2008 at 7:24 am
Sep 17, 2008 at 1:22 pm -
The way my rewritten FSM works at the moment is that pages are handed out of the FSM in random order, to spread the load of multiple backends to different pages. That's good for spreading the load, ...
Heikki Linnakangas
Aug 29, 2008 at 7:45 am
Sep 13, 2008 at 7:00 am -
Reference: Bruce Momjian writes: - http://archives.postgresql.org/pgsql-committers/2007-09/msg00402.php Other references: Boyer Moore?? - ...
David Rowley
Aug 30, 2008 at 11:21 pm
Sep 11, 2008 at 7:51 am -
I've pretty much finished the project I got a bee in my bonnet about last week, which is to teach SELECT DISTINCT how to (optionally) use hashing for grouping in the same way that GROUP BY has been ...
Tom Lane
Aug 5, 2008 at 2:51 pm
Aug 6, 2008 at 7:17 pm -
I just noticed, to my dismay, that has_table_privilege() does not allow me to check for usage privileges on sequences. I suspect this may have been an oversight. If so, the attached patch fixes it ...
Abhijit Menon-Sen
Aug 7, 2008 at 8:08 am
Dec 6, 2008 at 11:57 pm -
Since 8.3, the system provides automatic I/O conversion casts between the built-in string types and other types, but there's currently no way for a user to declare additional casts using the I/O ...
Heikki Linnakangas
Aug 29, 2008 at 10:59 am
Oct 30, 2008 at 10:50 pm -
Hello. Here are these functions with detailed documentation: http://en.dklab.ru/lib/dklab_postgresql_patch/ intagg.int_array_append_aggregate(int[]): fast merge arrays into one large list ...
Dmitry Koterov
Aug 13, 2008 at 11:29 am
Sep 25, 2008 at 5:39 pm -
yeah, actually, i have not been successful to set up this, but let me give some information for you. 1. download the postgresql snapshot source code from here: ...
Leiyonghua
Aug 18, 2008 at 9:28 am
Aug 21, 2008 at 6:56 pm -
Back in April we changed EXPLAIN VERBOSE to not dump the internal plan tree anymore, on the grounds that non-hackers didn't want that info and hackers could get it with debug_print_plan and related ...
Tom Lane
Aug 19, 2008 at 4:45 pm
Aug 20, 2008 at 2:28 am -
Hi there, is there psql static binary, which I can use on my iphone (version 1) ? I have no mac available, so I can't compile it myself. I heard about gui tool for iphone, but it's not free and is ...
Oleg Bartunov
Aug 17, 2008 at 6:40 pm
Aug 18, 2008 at 4:53 pm
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 132 |
posts | 1,374 |
users | 132 |
website | postgresql.org... |
irc | #postgresql |
132 users for August 2008
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)