FAQ

PostgreSQL > pgsql-hackers > February 2006

Search Discussions

134 discussions - 1,259 posts

  • Something came to my mind today, I'm not sure if it's feasible but I would like to know opinions on it. We've seen database applications that PostgreSQL simply could not manage because one would have ...
    Peter EisentrautPeter Eisentraut
    Feb 27, 2006 at 6:20 pm
    May 3, 2006 at 6:14 pm
  • The pg_config program needs to display more information, specifically where the location of pg_service.conf would reside. Also, I know I've been harping on this for years (literally), but since the ...
    Mark L. WoodwardMark L. Woodward
    Feb 21, 2006 at 2:11 pm
    Mar 1, 2006 at 10:39 pm
  • For some reason I hadn't immediately twigged to the fact that your test script is just N repetitions of the exact same structure with random data. So it's not so surprising that you get random ...
    Tom LaneTom Lane
    Feb 15, 2006 at 11:28 pm
    Mar 21, 2006 at 8:08 pm
  • justify_days doesn't currently do anything with this result --- it thinks its charter is only to reduce day components that are = 30 days. However, I think a good case could be made that it should ...
    Tom LaneTom Lane
    Feb 18, 2006 at 6:30 pm
    Mar 8, 2006 at 3:54 pm
  • I am working on an issue that I deal with a lot, there is of course a standard answer, but maybe it is something to think about for PostgreSQL 9.0 or something. I think I finally understand what I ...
    Mark L. WoodwardMark L. Woodward
    Feb 2, 2006 at 2:59 pm
    Feb 25, 2006 at 2:28 am
  • PostgreSQL promptly uses all available memory for the query and subsequently crashes. I'm sure it can be corrected with a setting, but should it crash? freedb=# create table ucode as select distinct ...
    Mark L. WoodwardMark L. Woodward
    Feb 9, 2006 at 2:44 pm
    Feb 11, 2006 at 5:31 pm
  • Hello all. I've got a question with regard to the INFORMATION_SCHEMA of PostgreSQL, specificially related to constraints. In the SQL92 specification, the DEFINITION_SCHEMA.DOMAIN_CONSTRAINTS (the ...
    Clark C. EvansClark C. Evans
    Feb 25, 2006 at 12:07 am
    Mar 15, 2006 at 3:29 pm
  • The core committee has agreed that it's about time for a new set of update releases (8.1.3, 8.0.7, etc). Barring surprises, we'll wrap Sunday evening with expectation of general announcement Tuesday. ...
    Tom LaneTom Lane
    Feb 8, 2006 at 4:06 pm
    Feb 11, 2006 at 8:37 pm
  • Hi, The idea of using a so called dead space map to speed up vacuum has come up multiple times in this list in the last couple of years. I wrote an initial implementation of it to measure the ...
    Heikki LinnakangasHeikki Linnakangas
    Feb 27, 2006 at 5:53 pm
    Feb 28, 2006 at 11:06 pm
  • I have updated my email signature because I think it is no longer necessary to list contact information now that my home page has all that information. (At the time I created it, email was becoming ...
    Bruce MomjianBruce Momjian
    Feb 17, 2006 at 3:40 pm
    Feb 22, 2006 at 4:49 pm
  • Having run had both pgfoundary and gborg for several years, I think we have to conclude that any clean migration is never going to happen, so let's just pick a server and announce date, and shut one ...
    Bruce MomjianBruce Momjian
    Feb 18, 2006 at 2:31 pm
    Feb 23, 2006 at 12:16 am
  • I looked into the problem reported here: http://archives.postgresql.org/pgsql-admin/2006-02/msg00261.php To wit, a pg_restore of a foreign key constraint involving user-defined types produces ...
    Tom LaneTom Lane
    Feb 23, 2006 at 6:10 pm
    Mar 4, 2006 at 3:46 pm
  • I'm interested in the behaviour of ExecSort, which *for all queries* prepares the sort result for randomAccess, even when part of a plan that will *never* go backwards/rewind etc. A recent ...
    Simon RiggsSimon Riggs
    Feb 10, 2006 at 1:32 pm
    Feb 27, 2006 at 11:20 pm
  • I've written some complicated queries that I'd like to save inside the server and then call from my clients using a short name. For the queries that require no external information, views are ...
    Chris CampbellChris Campbell
    Feb 3, 2006 at 12:12 am
    Feb 3, 2006 at 9:01 pm
  • As part of integrating PostgreSQL into our production environment, we're working on monitoring software, to provide the same kinds of status reporting and alerts we have implemented for our outgoing ...
    Kevin GrittnerKevin Grittner
    Feb 23, 2006 at 11:54 pm
    Feb 24, 2006 at 11:35 pm
  • I just tried using ipcclean in 8.1.3. It doesn't work when I su to the pgsql user. This part of the script: if [ "$USER" = 'root' -o "$LOGNAME" = 'root' ] Always fails because even tho $USER is set ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Feb 28, 2006 at 6:41 am
    Mar 3, 2006 at 7:48 pm
  • Hello, Is there not some other alternative to pg_hba.conf? I have the problem where the system administrators at our company obviously have access to the whole filesystem, and our database records ...
    Q BeukesQ Beukes
    Feb 8, 2006 at 12:34 pm
    Feb 13, 2006 at 8:32 am
  • Hi, I'd like to enable UDT's written in Java and made some initial trial and error. I don't get very far. Here's what I do: I take the 'complex' type example described in '31.11 User-Defined Types' ...
    Thomas HallgrenThomas Hallgren
    Feb 9, 2006 at 12:08 pm
    Feb 13, 2006 at 7:13 pm
  • I believe PQescapeString() has an important design bug and it casues a security risk. The function's signature is: size_t PQescapeString (char *to, const char *from, size_t length); As you might ...
    Tatsuo IshiiTatsuo Ishii
    Feb 19, 2006 at 6:10 am
    Feb 28, 2006 at 1:19 am
  • Hi all, I decided to start implementing a streamlined WAL shipping based standby building procedure. My aim is fairly simple: to be able to build a standby as automated as possible. The ultimate ...
    Csaba NagyCsaba Nagy
    Feb 7, 2006 at 3:11 pm
    Feb 22, 2006 at 1:07 am
  • Dear developers of PostgreSQL! We (City of Vienna) have many Oracle databases, but plan to use PostgreSQL for our future database installations as much as possible. The following idea is inspired by ...
    Albe LaurenzAlbe Laurenz
    Feb 20, 2006 at 1:36 pm
    Feb 28, 2006 at 5:33 pm
  • Thanks for bringing the SQL 92 row constructor into spec for operations involving and <. This is just fantastic. I just benchmarked ISAM style access to tables on multi-part keys and the speedup is ...
    Merlin MoncureMerlin Moncure
    Feb 7, 2006 at 5:31 pm
    Feb 8, 2006 at 4:06 pm
  • toast_compress_datum() considers compression to be "successful" if the compressed version of the datum is smaller than the uncompressed version. I think this is overly generous: if compression ...
    Neil ConwayNeil Conway
    Feb 26, 2006 at 2:38 am
    Feb 27, 2006 at 9:37 am
  • This took me hours to find ... On my Windows box, CVS HEAD gets an execution failure on "initdb foo" but succeeds happily with "initdb -D foo". This is not true for REL8_1_STABLE, nor is it true for ...
    Andrew DunstanAndrew Dunstan
    Feb 21, 2006 at 1:36 pm
    Feb 22, 2006 at 5:23 pm
  • I've got a domain based on a text type. I've overridden the equal operator with lower(text) = lower(text). I created a table containing my new domain type and can see that the equals operator is not ...
    EleinElein
    Feb 19, 2006 at 5:32 am
    Feb 20, 2006 at 8:52 pm
  • Many patch submitters discover that they fall foul of various "you should have done"s at a late stage of the patch review process. These include the usual: - major feature change not discussed on ...
    Simon RiggsSimon Riggs
    Feb 14, 2006 at 5:21 pm
    Mar 22, 2006 at 3:50 pm
  • I could not find anything in the Frontend/Backend protocol docs about character encoding in the StartupMessage. Assuming it is legal for a database or user name to have unicode characters, how is ...
    John DeSoiJohn DeSoi
    Feb 28, 2006 at 5:05 am
    Feb 28, 2006 at 7:49 pm
  • I'm interested in poking though and taking a shot at getting my feet wet with pl/python. I see the file is copyright Andrew Bosma -- is he still around perhance? Is anyone currently the 'owner' ? ...
    James RobinsonJames Robinson
    Feb 25, 2006 at 3:35 am
    Feb 26, 2006 at 9:45 pm
  • Greets folks, [YABLP: Yet Another Bulk Loading Proposal] The subject of this letter is referring to giving INSERT and COPY FROM STDIN the ability to alter the destination of rows that violate any ...
    James William PyeJames William Pye
    Feb 4, 2006 at 1:39 am
    Feb 14, 2006 at 7:35 pm
  • I did an audio interview today, and it is online now: http://bsdtalk.blogspot.com/2006/02/bsdtalk015-interview-with-postgresql.html -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | ...
    Bruce MomjianBruce Momjian
    Feb 8, 2006 at 4:43 am
    Feb 9, 2006 at 3:53 am
  • Dear all, I am writing a C-language shared-object file which is dynamically linked with postgres, and uses the various SPI functions for executing queries from numerous trigger functions. My question ...
    RichardRichard
    Feb 5, 2006 at 2:04 pm
    Feb 6, 2006 at 2:18 pm
  • Greetings, I've just run smack-dab into the bug described here: http://archives.postgresql.org/pgsql-interfaces/2002-05/msg00083.php and it's somewhat frustrating since the end of that thread is a ...
    Stephen FrostStephen Frost
    Feb 3, 2006 at 2:18 am
    Mar 6, 2006 at 5:59 pm
  • Hi PostgreSQL developers! On [1], Stephen and I are currently discussing how to provide seamless automatic version upgrades of PostgreSQL databases with third party modules like PostGIS. The core ...
    Martin PittMartin Pitt
    Feb 18, 2006 at 2:31 pm
    Mar 3, 2006 at 6:36 pm
  • Just a "wouldn't it be nice if" sort of feature request. I'm not sure how practical it is. Someone in our organization wrote a data fix query, which has sort of odd logic, but it does what they need. ...
    Kevin GrittnerKevin Grittner
    Feb 28, 2006 at 3:44 pm
    Mar 1, 2006 at 4:31 pm
  • AC_REPLACE_FUNCS([getaddrinfo]) won't correctly detect getaddrinfo on Tru64 UNIX because the function doesn't exist under that name in libc. From <netdb.h : #if defined (_SOCKADDR_LEN) || defined ...
    Albert ChinAlbert Chin
    Feb 19, 2006 at 11:43 pm
    Feb 25, 2006 at 2:35 am
  • Something broke snake again :-(. Looks like tsearch2 through the haze of my Lemsip... I hate winter :-( /D
    Dave PageDave Page
    Feb 10, 2006 at 8:24 am
    Feb 13, 2006 at 5:09 pm
  • I hope in pg_dump there should be an option that will dump a schema without the indexes (except of course primary indexes) regards
    Jan CruzJan Cruz
    Feb 23, 2006 at 11:39 pm
    Mar 20, 2006 at 2:35 am
  • During Josh Berkus' presentation at the JPUG PostgreSQL Conference, I was particularly struck by the fact that 8.1 had a shorter beta period than previous releases, rolled out on time, and enjoyed a ...
    Michael GlaesemannMichael Glaesemann
    Feb 22, 2006 at 6:29 am
    Feb 24, 2006 at 7:24 am
  • Has anyone here seen this one before? Do the values appear realistic? http://www.sqlite.org/cvstrac/wiki?p=SpeedComparison
    Andrej Ricnik-BayAndrej Ricnik-Bay
    Feb 11, 2006 at 8:00 pm
    Feb 12, 2006 at 4:11 pm
  • I took a first swing at this and rearranged some of these calls. A couple of other findings: nsl -- This might contain socket functions on some older platforms. ipc, IPC, lc -- unknown ld -- On AIX ...
    Peter EisentrautPeter Eisentraut
    Feb 4, 2006 at 12:54 am
    Feb 7, 2006 at 5:34 pm
  • (This is better asked in -hackers, I htink, copying there) What platform is this? I use it with krb5 1.4.3 on Linux (slackware) without any modifications at all. Perhaps platform specific behaviour? ...
    Magnus HaganderMagnus Hagander
    Feb 5, 2006 at 12:14 pm
    Feb 7, 2006 at 1:33 am
  • we are using postgresql 7.3.2 version. We are facing a problem in nextval of sequence. The problem is as follows, If the server shuts down abrupotly because of power failuar or any other cause then ...
    SuvarnaSuvarna
    Feb 28, 2006 at 5:38 am
    Mar 3, 2006 at 4:55 am
  • The topic of improving vacuum for use in heavy-update environments seems to come up frequently on the list. Has anyone weighed the costs of allowing VACUUM to reclaim tuples that are not older than ...
    Paul TillotsonPaul Tillotson
    Feb 28, 2006 at 3:27 am
    Mar 2, 2006 at 4:38 pm
  • Hi, A little while ago there was someone asking for tools to make it easier to connect to multiple servers. It occured to me that it might be useful to have a config file the way ssh does it: Host ...
    Martijn van OosterhoutMartijn van Oosterhout
    Feb 18, 2006 at 6:52 pm
    Feb 28, 2006 at 7:48 pm
  • http://www.flamingspork.com/blog/2006/02/16/enterprisedb-where-is-the-source/ Any comments on this? Is he referring to EnterpriseDB extensions that they don't make public? Chris
    Christopher Kings-LynneChristopher Kings-Lynne
    Feb 16, 2006 at 7:12 am
    Feb 24, 2006 at 10:02 pm
  • I've been modifying tuplesort.c to keep all the sort's local data in a separate memory context, to simplify and speed up cleaning up the data during tuplesort_end. I thought this would be a ...
    Tom LaneTom Lane
    Feb 23, 2006 at 9:10 pm
    Feb 24, 2006 at 4:51 pm
  • Hello There isn't possibility change opclass for generated UNIQUE indexes. I found syntax for CREATE TABLE command USING INDEX TABLESPACE ..., This form can be enhanced to USING INDEX [TABLESPACE ..] ...
    Pavel StehulePavel Stehule
    Feb 22, 2006 at 3:09 pm
    Feb 23, 2006 at 5:29 pm
  • We are currently maintaining information about configuration parameters in at least three places: the documentation, guc.c, and postgresql.conf.sample. I would like to generate these from a single ...
    Peter EisentrautPeter Eisentraut
    Feb 16, 2006 at 1:36 am
    Feb 20, 2006 at 10:08 pm
  • I found any query exceeds 4096 charactors will be pruned automatically. i am wondering which knob should i change to make it larger , say, 10000 charactors. i searched for a while but was not able to ...
    UwcssaUwcssa
    Feb 19, 2006 at 9:07 pm
    Feb 20, 2006 at 6:58 am
  • I have a PL/Java bug entry from Peter E. that reads "It is customary in PostgreSQL land and elsewhere, that dynamically loadable modules do not have a lib prefix (compare plpgsql.so, pltcl.so, etc.). ...
    Thomas HallgrenThomas Hallgren
    Feb 25, 2006 at 12:18 pm
    Feb 26, 2006 at 8:59 pm
Feb 2006
123
Group Navigation
period‹ prev | Feb 2006 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions134
posts1,259
users159
websitepostgresql.org...
irc#postgresql

159 users for February 2006

Tom Lane: 205 posts Bruce Momjian: 87 posts Martijn van Oosterhout: 74 posts Mark L. Woodward: 53 posts Andrew Dunstan: 50 posts Jim C. Nasby: 47 posts Peter Eisentraut: 28 posts Josh Berkus: 26 posts Simon Riggs: 26 posts Stephen Frost: 25 posts Alvaro Herrera: 24 posts Magnus Hagander: 23 posts Stephan Szabo: 21 posts Christopher Kings-Lynne: 19 posts Marc G. Fournier: 16 posts Thomas Hallgren: 16 posts Chris Browne: 15 posts Hannu Krosing: 15 posts Joshua D. Drake: 15 posts Ron Peacetree: 15 posts
show more
Archives