FAQ

PostgreSQL > pgsql-hackers > June 2008

Search Discussions

113 discussions - 1,149 posts

  • Howdy, [N.B.: I tried to send this a while ago but it didn't get delivered, I'm assuming because, with the uncompressed patch, the email was too big for -hackers. So this is a re-send with the patch ...
    David E. WheelerDavid E. Wheeler
    Jun 28, 2008 at 1:22 am
    Jul 9, 2008 at 4:49 pm
  • Hi, This is a small patch I posted a few months back, and then kinda forgot about / got distracted with other things. Is there any interest in this? If so I am willing to put more work into it, if ...
    Dean RasheedDean Rasheed
    Jun 30, 2008 at 12:34 pm
    Nov 19, 2008 at 3:00 am
  • pg_dump restore times can be high when they include many ALTER TABLE ADD FORIEGN KEY statements, since each statement checks the data to see if it is fully valid in all cases. I've been asked "why we ...
    Simon RiggsSimon Riggs
    Jun 5, 2008 at 6:20 am
    Jun 10, 2008 at 12:55 am
  • Hi, attached are two patches against HEAD. The smaller one is meant to be commited - it adds some functions that manipulate double-linked lists, namely inserting a new cell after or before another ...
    Jan UrbańskiJan Urbański
    Jun 27, 2008 at 7:12 am
    Jul 14, 2008 at 12:38 pm
  • Howdy, I'm sure I'm just showing off my ignorance here, but here goes… I really need case-insensitive string comparison in my database. Ideally there'd be a nice ITEXT data type (and friends, ichar, ...
    David E. WheelerDavid E. Wheeler
    Jun 2, 2008 at 3:53 am
    Jun 5, 2008 at 4:38 pm
  • Folks, With lots of help from Greg Sabino Mullane, I've set up a git repository for the WITH RECURSIVE patches on <http://git.postgresql.org/ . What other patches would people like to try maintaining ...
    David FetterDavid Fetter
    Jun 24, 2008 at 4:38 am
    Jul 7, 2008 at 5:48 pm
  • Could someone using the pgcrypto extension please verify this? SELECT encode(digest(null, 'md5'::text), 'hex'); or SELECT digest(null, 'md5'); Takes a few seconds, and then crashes the server with a ...
    Mario WeilguniMario Weilguni
    Jun 16, 2008 at 10:46 am
    Jun 18, 2008 at 2:01 am
  • This thread http://archives.postgresql.org/pgsql-hackers/2008-01/msg00134.php kind of wandered off into the weeds after identifying a semi-related bug in CLUSTER, but the original problem still ...
    Tom LaneTom Lane
    Jun 27, 2008 at 3:45 pm
    Jul 12, 2008 at 4:49 pm
  • Hi all, There is a TODO Item to allow pg_hba.conf to specify host names along with IP addresses. I'd like to work on this feature, if nobody is working too and no objection exists. Thanks. -- []s ...
    Dickson S. GuedesDickson S. Guedes
    Jun 12, 2008 at 7:24 pm
    Jun 26, 2008 at 9:19 pm
  • Currently eqsel assumes that, except for the values stored as mcv's, the number of times that a value appears in a table column is independent of it's value. Unfortunately, this often yields ...
    Nathan BoleyNathan Boley
    Jun 8, 2008 at 6:24 pm
    Jun 12, 2008 at 6:07 pm
  • We have written a FAQ, where are common issues collected, there are also discussion about design decisions and why concentrating only to functions is good idea. ...
    Marko KreenMarko Kreen
    Jun 28, 2008 at 1:36 pm
    Jul 24, 2008 at 4:05 pm
  • Howdy, I just wanted to report the latest on my pet project: implementing a new case-insensitive text type, "citext", to be locale-aware and to build and run on PostgreSQL 8.3. I'm not much of a C ...
    David E. WheelerDavid E. Wheeler
    Jun 25, 2008 at 6:47 pm
    Jul 1, 2008 at 4:08 pm
  • I was thinking a bit about how we pad columns of type NAME to fixed-width, even though they're semantically equivalent to C strings. The reason for wasting that space is that it makes it possible to ...
    Tom LaneTom Lane
    Jun 23, 2008 at 7:53 pm
    Jul 1, 2008 at 2:35 pm
  • Folks, I forgot to post the fact that I'd put up a <http://wiki.postgresql.org/wiki/How_to_sponsor_a_feature , per my TODO from the developers' meeting in Ottawa. Sorry about that. Anyhow, Jignesh ...
    David FetterDavid Fetter
    Jun 11, 2008 at 7:34 pm
    Jun 16, 2008 at 6:41 pm
  • Is it desirable that pg_dump doesn't dump config settings set via ALTER DATABASE? http://archives.postgresql.org/pgsql-novice/2008-04/msg00016.php I just got bitten by a DateStyle not being restored ...
    Richard HuxtonRichard Huxton
    Jun 27, 2008 at 1:50 pm
    Aug 22, 2008 at 2:31 pm
  • Hello There was more time questions about array's initialisation. I propose function array_init. CREATE OR REPLACE FUNCTION array_init(sizes int[], v anyelement) RETURNS anyarray; First parameter is ...
    Pavel StehulePavel Stehule
    Jun 2, 2008 at 4:04 pm
    Jun 5, 2008 at 4:01 am
  • Hello, Postgres 8.4 has pg_stat_user_functions view to track number of calls of stored functions and time spent in them. Then, I'm thinking a "sql statement" version of similar view -- ...
    ITAGAKI TakahiroITAGAKI Takahiro
    Jun 13, 2008 at 8:33 am
    Jun 24, 2008 at 7:03 am
  • I would like to request a change to the PGBE_ACTIVITY_SIZE #define in the pgstat.h file. This value determines the max length of the SQL query contained in the PgBackendStatus structure. By ...
    David MillerDavid Miller
    Jun 19, 2008 at 2:54 pm
    Jun 22, 2008 at 6:34 pm
  • Attached is a worked-out patch for the approach proposed here: http://archives.postgresql.org/pgsql-hackers/2008-06/msg00777.php namely, that cache management for de-TOASTed datums is handled by ...
    Tom LaneTom Lane
    Jun 29, 2008 at 8:57 pm
    Aug 26, 2008 at 1:10 am
  • I found this error message in my log files repeatedly: Error: failed to re-find parent key in "ledgerdetail_2008_03_idx2" for deletion target page 64767 I though "hmm, that index looks broken. I'd ...
    Andrew HammondAndrew Hammond
    Jun 25, 2008 at 7:40 am
    Jul 7, 2008 at 10:04 pm
  • Hi, After pondering on the problem for quite some time and discussing it on IRC with RhodiumToad I thought the most sensible thing is to post the problem here (as RhodiumToad suggested as well). The ...
    Andres FreundAndres Freund
    Jun 25, 2008 at 3:10 pm
    Jun 27, 2008 at 4:14 pm
  • 1) Overview This proposal is part of inplace upgrade project. PostgreSQL should be able to read any page in old version. This is basic for all possible upgrade method. 2) Background We have several ...
    Zdenek KotalaZdenek Kotala
    Jun 11, 2008 at 2:15 pm
    Jun 13, 2008 at 4:18 pm
  • I have a VIEW that consists of two tables, of which contain a POINT column. When trying to select from the view I get an error... ERROR: could not identify an ordering operator for type point HINT: ...
    NickNick
    Jun 25, 2008 at 6:08 pm
    Jun 26, 2008 at 11:33 am
  • Marc Munro wrote: -- Start of PGP signed section. Yes, I can confirm this behavior on CVS HEAD, and it is odd: test= CREATE SCHEMA internal; CREATE SCHEMA test= CREATE VIEW internal.all_objects AS ...
    Bruce MomjianBruce Momjian
    Jun 30, 2008 at 10:39 pm
    Aug 23, 2008 at 8:33 pm
  • The way I read it, the current btree index stores the index value and the TID of every tuple having that value. When you have a table with three columns, you index one of them and you get an index ...
    Jeffrey BakerJeffrey Baker
    Jun 24, 2008 at 8:34 pm
    Jun 25, 2008 at 8:51 am
  • Hi, I'm getting following error while envoking psql: $ psql psql: symbol lookup error: /usr/lib/libreadline.so.5: undefined symbol: BC This is Linux glibc 2.3.4 and readline 5.1. -- Tatsuo Ishii SRA ...
    Tatsuo IshiiTatsuo Ishii
    Jun 25, 2008 at 7:42 am
    Jul 28, 2008 at 10:12 pm
  • Folks, I've noticed that a big hunk of our build system has gratuitous dependencies on some variety of shell and on tools like sed, none of which makes Windows developers feel welcome. I know people ...
    David FetterDavid Fetter
    Jun 17, 2008 at 2:04 pm
    Jun 19, 2008 at 3:57 am
  • Hello, I am trying to compile libpq.dll with MSVC 2003 on windows, using postgresql-8.3.3, but I get the following compile error: Creating library .\Release\libpqdll.lib and object .\Release ...
    Jeff McKennaJeff McKenna
    Jun 24, 2008 at 6:45 pm
    Jun 27, 2008 at 4:33 pm
  • Recent discussions with the PostGIS hackers led me to think about ways to reduce overhead when the same TOAST value is repeatedly detoasted. In the example shown here ...
    Tom LaneTom Lane
    Jun 16, 2008 at 7:35 pm
    Jun 18, 2008 at 4:01 pm
  • Howdy, Possibly showing my ignorance here, but as I'm working on updating citext to be locale-aware and to work on 8.3, I've run into this peculiarity: try=# \encoding UTF8 try=# select setting from ...
    David E. WheelerDavid E. Wheeler
    Jun 16, 2008 at 5:46 am
    Jun 17, 2008 at 3:09 am
  • In my .psqlrc I have: \pset format wrapped and this outputs this on psql startup: $ psql test -- Output format is wrapped. psql (8.4devel) Type "help" for help. Is this desirable? \set QUIET at the ...
    Bruce MomjianBruce Momjian
    Jun 11, 2008 at 11:24 pm
    Jul 20, 2008 at 6:15 am
  • Is there anyway to bind a cursor with SCROLL and WITH HOLD at the protocol level? Or perhaps configuring it so after binding it? I know you can use DECLARE, but I believe that this inhibits the ...
    James William PyeJames William Pye
    Jun 12, 2008 at 4:42 pm
    Jun 14, 2008 at 12:59 am
  • Hi there, I'm currently looking at a bug report in PostGIS where we are getting extremely long index scan times querying an index in one case, but the same scan can take much less time if the input ...
    Mark Cave-AylandMark Cave-Ayland
    Jun 9, 2008 at 2:00 pm
    Jun 10, 2008 at 9:15 am
  • There are common cases where we want to remove unwanted joins from queries, especially with view and Object Relational Mapping systems such as Hibernate etc.. (I've mentioned this before on -hackers ...
    Simon RiggsSimon Riggs
    Jun 26, 2008 at 10:52 am
    Aug 16, 2008 at 12:40 am
  • I would like to add the flags given to pg_dump into the output of the pg_dump file. For text dumps, the output would go on a line below the current header, so output would look like: -- -- PostgreSQL ...
    Robert TreatRobert Treat
    Jun 2, 2008 at 8:54 pm
    Jul 16, 2008 at 1:22 am
  • Buildfarm bobcat is broken running the pltcl regression tests - see http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=bobcat&dt=2008-06-15%2022:43:01 and I have reproduced this on Fedora 9 myself. ...
    Andrew DunstanAndrew Dunstan
    Jun 16, 2008 at 12:54 am
    Jun 17, 2008 at 11:43 am
  • One of the areas where libpq seems to be severely lacking is in handling arrays and composites in query results. I'd like to set about rectifying that. Ideally this would mean that drivers using ...
    Andrew DunstanAndrew Dunstan
    Jun 8, 2008 at 11:59 pm
    Jun 10, 2008 at 3:29 pm
  • I have attached a patch for phrase search with respect to the cvs head. Basically it takes a a phrase (text) and a TSVector. It checks if the relative positions of lexeme in the phrase are same as in ...
    Sushant SinhaSushant Sinha
    Jun 1, 2008 at 2:26 am
    Jul 22, 2008 at 6:59 pm
  • It is impossible to dump (with pg_dump -Ocx) and restore (with psql) a database which contains sequences in any of 8.1, 8.2, or 8.3: [...] -- -- Name: transaction_transaction_id_seq; Type: SEQUENCE ...
    Jeffrey BakerJeffrey Baker
    Jun 17, 2008 at 4:53 pm
    Jun 18, 2008 at 2:36 pm
  • So while tagging the upcoming releases, I got annoyed once again about what a tedious, error-prone bit of donkeywork it is. You've got to find and update the sub-version numbers, and *not* any chance ...
    Tom LaneTom Lane
    Jun 9, 2008 at 1:12 am
    Jun 12, 2008 at 3:54 pm
  • I would like to consider adding constraints to GiST indexes. I think it is possible to add constraints that are more sophisticated than just UNIQUE. My use case is a non-overlapping constraint, but I ...
    Jeff DavisJeff Davis
    Jun 9, 2008 at 4:16 pm
    Jun 10, 2008 at 9:30 pm
  • Hello I found following bug - using explain in stored procedures like: CREATE OR REPLACE FUNCTION test(int) RETURNS void AS $$ DECLARE s varchar; BEGIN FOR s IN EXECUTE 'EXPLAIN SELECT * FROM o WHERE ...
    Pavel StehulePavel Stehule
    Jun 1, 2008 at 9:30 am
    Jun 1, 2008 at 6:59 pm
  • One of our guys in Pakistan noticed a problem with Slony that seems to have manifested itself since the last zic update. Slony uses timeofday() as the default value for a timestamp column: -- ...
    Dave PageDave Page
    Jun 10, 2008 at 1:23 pm
    Jun 10, 2008 at 4:04 pm
  • Hi, We've been making noises about dealing with TOAST tables as separate entities in autovacuum for some time now. So here's a proposal: Let's do it. That's about it :-) The only change of some ...
    Alvaro HerreraAlvaro Herrera
    Jun 8, 2008 at 11:04 pm
    Jun 9, 2008 at 7:14 pm
  • Currently there are two modes of LWLock : SHARED and EXCLUSIVE Mostly you need to have EXCLUSIVE lock mode to make any changes, add, delete and SHARED if you are just reading it. Multiple backends ...
    Jignesh K. ShahJignesh K. Shah
    Jun 6, 2008 at 4:22 pm
    Jun 6, 2008 at 8:25 pm
  • Hi, I keep seeing these files show up in the source tree in a VPATH build: ? src/interfaces/ecpg/compatlib/libecpg_compatddll.def ? src/interfaces/ecpg/ecpglib/libecpgddll.def ? ...
    Alvaro HerreraAlvaro Herrera
    Jun 18, 2008 at 11:16 pm
    Jul 17, 2008 at 9:18 pm
  • [ after recovering from choking... ] Tom "spot" Callaway presents a vivid new image in this line: https://www.redhat.com/archives/fedora-devel-list/2008-June/msg01501.html So is that a "golf club ...
    Tom LaneTom Lane
    Jun 30, 2008 at 4:57 am
    Jul 1, 2008 at 11:13 pm
  • Folks, I'm doing some analysis of PostgreSQL site traffic, and am being frequently hung up by the compile-time-fixed size of our regex cache (32 regexes, per MAX_CACHED_RES). Is there a reason why it ...
    Josh BerkusJosh Berkus
    Jun 18, 2008 at 1:22 am
    Jun 18, 2008 at 10:32 pm
  • looking in my freshly installed 8.3.3, I see this in the postgresql.conf #client_encoding = sql_ascii # actually, defaults to database # encoding Now, certainly initdb can't know for sure what ...
    Robert TreatRobert Treat
    Jun 12, 2008 at 9:30 pm
    Jun 13, 2008 at 4:15 pm
  • I believe i have found a math bug/rounding problem with Money type when its used with SUM()... Postgresql 8.3.1 --------------- Background on the Problem-------------------- We have gl_trans table ...
    JustinJustin
    Jun 7, 2008 at 10:08 pm
    Jun 11, 2008 at 2:04 pm
Jun 2008
123
Group Navigation
period‹ prev | Jun 2008 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions113
posts1,149
users145
websitepostgresql.org...
irc#postgresql

145 users for June 2008

Tom Lane: 224 posts Bruce Momjian: 53 posts Alvaro Herrera: 50 posts Andrew Dunstan: 49 posts Simon Riggs: 47 posts David E. Wheeler: 40 posts Gregory Stark: 34 posts Josh Berkus: 34 posts Greg Smith: 28 posts Robert Treat: 27 posts Pavel Stehule: 25 posts Heikki Linnakangas: 24 posts Joshua D. Drake: 22 posts David Fetter: 21 posts Decibel!: 20 posts Magnus Hagander: 19 posts Peter Eisentraut: 18 posts Jeff Davis: 15 posts Zdenek Kotala: 15 posts Teodor Sigaev: 13 posts
show more
Archives