Search Discussions
-
Currently, pgAdmin supports editing postgresql.conf remotely using the adminpack to open the file, change it locally in memory, and using the adminpack again to write it back. This means that in ...
Magnus Hagander
Feb 19, 2008 at 2:36 pm
Feb 22, 2008 at 11:18 am -
Hackers, As you know we've finally released PostgreSQL 8.3, after a development cycle that lasted well over a year despite our original plans for a 6 month cycle. The core team are aware that there ...
Dave Page
Feb 6, 2008 at 8:56 am
Feb 12, 2008 at 12:59 am -
pg_dump allows you to specify -s --schema-only, or -a --data-only. The -s option creates the table, as well as creating constraints and indexes. These objects need to be dropped prior to loading, if ...
Simon Riggs
Feb 6, 2008 at 3:12 pm
Mar 24, 2008 at 2:17 pm -
Hello, I have been testing a migration for a week now trying to get it into a reasonable state. This is what we have: Restore file 220G 8.2.6 and 8.3.0 are configured identically: shared_buffers = ...
Joshua D. Drake
Feb 7, 2008 at 6:52 am
Apr 24, 2008 at 5:33 pm -
Folks, Let's put PL/PgSQL in template1 by default, as some downstream packagers are already doing. If someone really must remove it, they can still do that. Cheers, David. -- David Fetter ...
David Fetter
Feb 19, 2008 at 4:47 pm
Feb 27, 2008 at 2:09 am -
This page http://linux-mm.org/OOM_Killer says that you can hint the OOM killer to be more deferential towards certain processes. I am wondering if we can set the system up so that it skips ...
Alvaro Herrera
Feb 1, 2008 at 10:33 pm
Feb 8, 2008 at 7:59 pm -
38
Patch review
so.... I went to look for the held patches queue to start reviewing patches. There are over 2000 messages in the queue in 300 separate threads. At that rate it would probably be just as easy to scan ...Gregory Stark
Feb 8, 2008 at 2:32 pm
Feb 14, 2008 at 3:51 am -
Hello hackers, psql's \du command currently does not list the INHERIT role attribute. It does show the other privilege attributes (superuser, create role, create db), and INHERIT seems like the kind ...
Brendan Jurd
Feb 14, 2008 at 4:52 am
Apr 15, 2008 at 8:24 am -
Hi All, I just noticed a minor bug in our search results. Searching for is_insteadbool in 8.3 docs returns the following page: http://www.postgresql.org/docs/8.3/static/catalog-pg-rewrite.html ...
Gurjeet Singh
Feb 2, 2008 at 1:18 pm
Apr 16, 2008 at 9:25 am -
We've got various facilities now for looking at LWLock waits, but I'd like to have more information about the *reasons* for lock waits. I know its possible to get backtraces in Dtrace at various ...
Simon Riggs
Feb 4, 2008 at 6:46 pm
Feb 8, 2008 at 3:15 am -
In heapgetpage() we hold the buffer locked while we look for visible tuples. That works well in most cases since the visibility check is fast if we have status bits set. If we don't have visibility ...
Simon Riggs
Feb 4, 2008 at 4:06 pm
Mar 23, 2008 at 11:03 am -
I have compiled 8.3 (CVS HEAD) with NLS on a XP box. But it seems that NLS support is broke. Could someone please confirm this. My test: Gevik=# Gevik=# show lc_messages ; lc_messages ...
Gevik Babakhani
Feb 12, 2008 at 11:53 am
Feb 14, 2008 at 6:21 am -
Architecture: Intel Core 2 Duo OS: linux-2.6.20-gentoo-r8 Filesystem: ext3 Postgres v8.2.3 compiled with gcc 4.1.1-r3 RAM - 2GB Shared buffers - 24MB [All other Postgres configuration parameters are ...
John Smith
Feb 29, 2008 at 1:54 am
Apr 24, 2008 at 6:32 pm -
Hello, Congratulations to the 8.3 release. No, that pre-release stress is over I'd really like to put attention on my Avahi patches again. Avahi/Bonjour/DNS-SD support[1] is very important, for ...
Mathias Hasselmann
Feb 23, 2008 at 12:34 pm
Apr 16, 2008 at 5:26 pm -
[ "include/access/relscan.h" ] In IndexScanDescData, whats the purpose of having two Relation variables. typedef struct IndexScanDescData { Relation heapRelation; /* heap relation descriptor, or NULL ...
Suresh
Feb 17, 2008 at 3:33 pm
Oct 29, 2008 at 3:22 am -
Hello. I am currently playing with UUID data type and try to use it to store provided by third party (Hewlett-Packard) application. The problem is they format UUIDs as ...
Dawid Kuroczko
Feb 27, 2008 at 11:15 pm
Mar 3, 2008 at 7:04 pm -
As far as I can see the main difficulty in making COPY run faster (on the server) is that pretty involved conversion from plain-text lines into tuples. Trying to get rid of this conversion by having ...
Florian G. Pflug
Feb 27, 2008 at 2:43 am
Feb 27, 2008 at 5:47 pm -
Hi all. I thinks to the option of "AS" by the syntax of table reference. The problem on structure had restricted it until now. Then, conversion was required of this by the degree of migration from ...
Hiroshi Saito
Feb 8, 2008 at 5:20 pm
Feb 10, 2008 at 3:46 am -
I remember Heikki mentioned improving redo recovery in one of the emails in the past, so I know people are already thinking about this. I have some ideas and just wanted to get comments here. ISTM ...
Pavan Deolasee
Feb 29, 2008 at 11:30 am
Mar 3, 2008 at 6:48 pm -
Hello there, I'm running a conversion of PostgreSQL's CVS repository, but I'm stuck on a revision that cscvs fails to parse. The hint that the error gives me is: Parser error: failed to parse ...
Christian Robottom Reis
Feb 15, 2008 at 4:59 pm
Feb 20, 2008 at 10:53 pm -
To avoid double-patching effort. I think we'll branch fairly shortly, like in a week or so, but right now it'd mostly just create make-work for committers. regards, tom lane
Tom Lane
Feb 4, 2008 at 6:20 pm
Feb 6, 2008 at 8:24 am -
This is a proposal of fast data loading using batch update of indexes for 8.4. It is a part of pg_bulkload (http://pgbulkload.projects.postgresql.org/) and I'd like to integrate it in order to ...
ITAGAKI Takahiro
Feb 21, 2008 at 4:25 am
Apr 24, 2008 at 11:27 am -
Hi all. The door was opened by Mr. Ralf S. Engelschall of a great developer. http://www.ossp.org/pkg/lib/uuid/ It can be used from Version 1.6.1. Please see, ...
Hiroshi Saito
Feb 21, 2008 at 4:08 pm
Mar 1, 2008 at 10:15 am -
Motivation: To enable probes to work with Mac OS X Leopard and other OSes that will support DTrace in the future. Bug filed on this issue ...
Robert Lor
Feb 22, 2008 at 5:23 pm
Feb 27, 2008 at 4:15 pm -
Question: We have recently moved PostgreSql as we just migrated to OpenMfg. i really like the database and PL/pgSQL its very similar to how FoxPro language layout so learning has been pretty easy. ...
Justin
Feb 18, 2008 at 7:47 pm
Feb 19, 2008 at 3:59 am -
Tom did most of the 8.4 stamping and I incremented the library minor version numbers. I have updated the library bump wording in RELEASE_CHANGES: o Bump minor library versions, major if appropriate ...
Bruce Momjian
Feb 13, 2008 at 6:33 pm
Feb 13, 2008 at 9:35 pm -
I'd like to add a way for a client (in this case, typicallyi pgadmin, phppgadmin or similar) to get the available options on the server for the GUC settings we have that take fixed options. This is ...
Magnus Hagander
Feb 19, 2008 at 1:22 pm
Feb 21, 2008 at 12:23 pm -
All Is there an interest in developing bitemporal functionality in PostgreSQL Regards Luke From: bruce@momjian.us Subject: Re: bitemporal functionality for PostgreSQL To: luke_porter@hotmail.com ...
Luke Porter
Feb 1, 2008 at 3:42 pm
Feb 4, 2008 at 10:25 pm -
Currently trying to "enhance" the way we can make binaries that run on Solaris. One thing I found was a scalability bottleneck in the use of the ProcArrayLock. (this one has also been reported by a ...
Paul van den Bogaard
Feb 6, 2008 at 5:19 pm
Mar 28, 2008 at 7:34 am -
I had this idea sometime back. Not sure if this has been discussed before In a typical scenario, user might create a table and load data in the table as part of a single transaction (e.g pg_restore). ...
Pavan Deolasee
Feb 28, 2008 at 9:09 am
Feb 29, 2008 at 11:28 am -
Hi, I would like to start a discussion for a solution regarding this item. At this moment these functions only accept English month/day names due formatting.c:172:months_full[] and datetime.c:53-58 ...
Gevik Babakhani
Feb 4, 2008 at 11:48 pm
Feb 10, 2008 at 10:51 am -
Hi Tom-san. I look at that all regression tests pass by tools/msvc. It is very comfortable.! Then, the reason, it is because no-locale is an default value. -- my @args = ( ...
Hiroshi Saito
Feb 8, 2008 at 1:13 pm
Feb 8, 2008 at 5:31 pm -
I notice that several of the call sites of tuplestore_puttuple() start with arrays of datums and nulls, call heap_form_tuple(), and then switch into the tstore's context and call ...
Neil Conway
Feb 27, 2008 at 8:33 pm
Mar 25, 2008 at 7:33 pm -
Hi all: I'm at PostgreSQL 8.3 for my production database and everything is working great. I had no problems converting free text search from 8.2 to 8.3, and I really like the improvements. I tried ...
Mark Mielke
Feb 24, 2008 at 9:31 pm
Mar 3, 2008 at 9:26 pm -
Here is a patch so that the backend is linked in one piece instead of using the SUBSYS.o files. The question is how we want to activate that. I currently used make BIGLINK=1, which is obviously just ...
Peter Eisentraut
Feb 22, 2008 at 7:48 am
Feb 22, 2008 at 5:28 pm -
Hi guys, I saw a strange behaviour on one of the production boxes. The pg_stat_activity shows a process as <IDLE and yet 'waiting' !!! On top of it (understandably, since its IDLE), there are no ...
Gurjeet Singh
Feb 1, 2008 at 1:51 am
Feb 2, 2008 at 11:39 pm -
Hi, As I promised before we would like to propose implementing the recursive query as defined in the standard for PostgreSQL 8.4. The work is supported by Sumitomo Electric Information Systems Co., ...
Tatsuo Ishii
Feb 19, 2008 at 8:36 am
Mar 4, 2008 at 2:45 pm -
There is a build farm failure now because (apparently) an old make version: http://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=dawn_bat&dt=2008-02-26%2019:00:01 The new amended backend linking ...
Peter Eisentraut
Feb 26, 2008 at 9:14 pm
Feb 27, 2008 at 7:21 pm -
Hi The database is initialized with utf8, so in order for LIKE to use the index on a text field, I used text_pattern_ops when I created it. So far so good. It's in the documentation, but there's no ...
Kaare Rasmussen
Feb 25, 2008 at 1:15 pm
Feb 25, 2008 at 6:54 pm -
Hello -hackers, In the process of converting a multi-Tb datadabe from 8.2 to 8.3, Postgres 8.3 died at the failed assertion: TRAP: FailedAssertion("!(((toast_pointer).va_extsize < ...
Sergey E. Koposov
Feb 20, 2008 at 10:39 am
Feb 20, 2008 at 1:06 pm -
There seems to have been a bit of a brain cramp upstream :-(. Previously, AC_FUNC_FSEEKO did this to test if fseeko was available: return !fseeko; Now it does this: return fseeko (stdin, 0, 0) && ...
Tom Lane
Feb 18, 2008 at 11:31 pm
Feb 19, 2008 at 5:35 pm -
hi there, I recently found myself trying to build a trigger to modify some fields in a good dozen similarly structured tables in which the similar columns had different names. in fact, I got stuck in ...
Raphaël Jacquot
Feb 14, 2008 at 6:51 am
Feb 19, 2008 at 6:07 am -
Hi all, I'm using 8.2.6 and I'm observing a trange behaviour using offset and limits. This are the two queries that are puzzling me: explain SELECT c.id, tsk, lir, nctr, nctn, ncts, rvel,ecp, pvcp, ...
Gaetano Mendola
Feb 1, 2008 at 11:08 am
Feb 1, 2008 at 5:18 pm -
Hackers, Over the last 2 years, Google Summer of Code has been responsible for several new features of PostgreSQL: XML, ghost XID, phpPgAdmin upgrade, and more, as well as some new long-term ...
Josh Berkus
Feb 28, 2008 at 9:45 pm
Mar 18, 2008 at 4:51 pm -
Don't forget that our first "commit fest" for 8.4 development starts Saturday March 1. If you've got a patch that you'd like reviewed in this fest, it's time to send it in. (But there's plenty more ...
Tom Lane
Feb 29, 2008 at 3:23 am
Mar 3, 2008 at 10:56 pm -
I'm now looking into toast code and I found following code in pglz_decompress: 00704 if (destsize != source- rawsize) 00705 elog(destsize source- rawsize ? FATAL : ERROR, 00706 "compressed data is ...
Zdenek Kotala
Feb 29, 2008 at 1:56 pm
Feb 29, 2008 at 7:32 pm -
Hi I just stumbled over the following behaviour, introduced with 8.3, and wondered if this is by design or an oversight. If you define a domain over some existing type, constrain it to non-null ...
Florian G. Pflug
Feb 24, 2008 at 4:55 pm
Feb 24, 2008 at 7:27 pm -
Paul van den Bogaard (Sun) suggested to me that we could use more than two WAL locks to improve concurrency. I think its possible to introduce such a scheme with some ease. All mods within xlog.c The ...
Simon Riggs
Feb 14, 2008 at 1:43 pm
Mar 23, 2008 at 12:05 am -
Hello I thing RETURN QUERY is successful idea. It should be completed with support of dynamic SQL. Syntax: RETURN EXECUTE sqlstring [USING]; This is shortcut for FOR r IN EXECUTE sqlstring USING LOOP ...
Pavel Stehule
Feb 27, 2008 at 2:25 pm
Mar 3, 2008 at 8:42 pm -
Hackers, As you may have read, Coverity is running their static analysis tool ("Scan") against the PostgreSQL codebase daily: http://scan.coverity.com/ We need two (or more) PostgreSQL hackers to ...
Josh Berkus
Feb 26, 2008 at 8:02 pm
Feb 27, 2008 at 8:19 am
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 150 |
posts | 1,309 |
users | 144 |
website | postgresql.org... |
irc | #postgresql |
144 users for February 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)