FAQ

PostgreSQL > pgsql-hackers > February 2008

Search Discussions

150 discussions - 1,309 posts

  • 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 HaganderMagnus 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 PageDave 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 RiggsSimon 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. DrakeJoshua 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 FetterDavid 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 HerreraAlvaro Herrera
    Feb 1, 2008 at 10:33 pm
    Feb 8, 2008 at 7:59 pm
  • 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 StarkGregory 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 JurdBrendan 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 SinghGurjeet 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 RiggsSimon 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 RiggsSimon 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 BabakhaniGevik 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 SmithJohn 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 HasselmannMathias 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 ...
    SureshSuresh
    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 KuroczkoDawid 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. PflugFlorian 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 SaitoHiroshi 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 DeolaseePavan 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 ReisChristian 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 LaneTom 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 TakahiroITAGAKI 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 SaitoHiroshi 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 LorRobert 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. ...
    JustinJustin
    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 MomjianBruce 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 HaganderMagnus 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 PorterLuke 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 BogaardPaul 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 DeolaseePavan 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 BabakhaniGevik 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 SaitoHiroshi 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 ConwayNeil 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 MielkeMark 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 EisentrautPeter 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 SinghGurjeet 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 IshiiTatsuo 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 EisentrautPeter 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 RasmussenKaare 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. KoposovSergey 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 LaneTom 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 JacquotRaphaë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 MendolaGaetano 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 BerkusJosh 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 LaneTom 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 KotalaZdenek 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. PflugFlorian 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 RiggsSimon 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 StehulePavel 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 BerkusJosh Berkus
    Feb 26, 2008 at 8:02 pm
    Feb 27, 2008 at 8:19 am
Feb 2008
123
Group Navigation
period‹ prev | Feb 2008 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions150
posts1,309
users144
websitepostgresql.org...
irc#postgresql

144 users for February 2008

Tom Lane: 222 posts Magnus Hagander: 82 posts Andrew Dunstan: 72 posts Joshua D. Drake: 71 posts Alvaro Herrera: 64 posts Simon Riggs: 63 posts Gregory Stark: 50 posts Peter Eisentraut: 38 posts Gevik Babakhani: 28 posts Bruce Momjian: 26 posts Hiroshi Saito: 24 posts Heikki Linnakangas: 19 posts Josh Berkus: 19 posts Aidan Van Dyk: 17 posts Jeff Davis: 17 posts Dimitri Fontaine: 16 posts Florian G. Pflug: 16 posts Zdenek Kotala: 15 posts Martijn van Oosterhout: 14 posts Roberts, Jon: 14 posts
show more
Archives