FAQ

Search Discussions

176 discussions - 1,210 posts

  • plperl's error handling is not completely broken, but it's close :-( Consider for example the following sequence on a machine with a relatively old Perl installation: regression=# create or replace ...
    Tom LaneTom Lane
    Nov 19, 2004 at 9:58 pm
    Dec 3, 2004 at 9:03 pm
  • Darcy Buskermolen has drawn my attention to unfortunate behaviour of COPY CSV with fields containing embedded line end chars if the embedded sequence isn't the same as those of the file containing ...
    Andrew DunstanAndrew Dunstan
    Nov 10, 2004 at 11:10 pm
    Dec 3, 2004 at 5:13 pm
  • Is there any reason the length of pg_catalog.pg_stat_activity.current_query is capped at 255 characters? Why can't it be a pointer to the currently running query? Seems silly to me and is a PITA to ...
    Sean ChittendenSean Chittenden
    Nov 6, 2004 at 7:11 pm
    Dec 1, 2004 at 7:11 pm
  • I have counted three times you have said that in the recent past. IMHO this really screams of changing the SCM tool. Can this be discussed for 8.1? -- Alvaro Herrera (<alvherre[a]dcc.uchile.cl ) "La ...
    Alvaro HerreraAlvaro Herrera
    Nov 4, 2004 at 6:35 pm
    Nov 15, 2004 at 7:55 am
  • I am looking at implementing this TODO item. e.g. (max case): rewrite SELECT max(foo) FROM bar as SELECT foo FROM bar ORDER BY foo DESC LIMIT 1 if there is an index on bar(foo) Suggestions about the ...
    Mark KirkwoodMark Kirkwood
    Nov 10, 2004 at 10:45 pm
    Nov 24, 2004 at 8:23 pm
  • Check her out and let me know if there are any problems ... I've changed the mk script to pull in the beta3 man pages that I found in the dev/doc directory ... ---- Marc G. Fournier Hub.Org ...
    Marc G. FournierMarc G. Fournier
    Nov 22, 2004 at 3:40 am
    Nov 26, 2004 at 9:00 am
  • I have some initial results using 8.0beta5 with our OLTP workload. Off the bat I see about a 23% improvement in overall throughput. The most significant thing I've noticed was in the oprofile report ...
    Mark WongMark Wong
    Nov 30, 2004 at 12:01 am
    Dec 12, 2004 at 8:41 am
  • If there were a comp.databases.postgresql.hackers newsgroup created and carried by all the news servers ... would you move to using it vs using the mailing lists? The USENET community seems to think ...
    Marc G. FournierMarc G. Fournier
    Nov 29, 2004 at 7:03 pm
    Nov 30, 2004 at 5:04 pm
  • Recent runs of DBT-2 show very occasional ExclusiveLock (s) being held by transactions, sometimes waiting to be granted. order_line, right?: (by me, that is...) According to the manual, Exclusive ...
    Simon RiggsSimon Riggs
    Nov 8, 2004 at 7:59 pm
    Nov 24, 2004 at 4:50 pm
  • A remember specifically that I somewhat recently fixed psql to accept editors with arguments, say EDITOR="pico -t". This was apparently broken again during some Windows-related reshuffling. It now ...
    Peter EisentrautPeter Eisentraut
    Nov 14, 2004 at 6:30 pm
    Nov 16, 2004 at 4:41 pm
  • The fix for unflushed changed to pg_database records seems to have fixed the problem we were seeing on spoonbill ... but it is now seeing problems with the seg module: ...
    Andrew DunstanAndrew Dunstan
    Nov 18, 2004 at 5:44 pm
    Nov 24, 2004 at 4:53 pm
  • Folks, Some issues have come up repeatedly on IRC with new users, enough so that they might be worth addressing in the code: a) new users try just to "psql" as postgres, and get a "no such database ...
    Josh BerkusJosh Berkus
    Nov 18, 2004 at 9:04 pm
    Nov 22, 2004 at 8:17 pm
  • Hi there, I just wanted to try the PITR feature in beta and got it working somehow. However I think the docs on this point are still not sufficient enough. We have to assume that people will have a ...
    Joachim WielandJoachim Wieland
    Nov 5, 2004 at 3:28 pm
    Dec 21, 2004 at 1:23 am
  • It should do the same as plpgsql: throw an error about "set-returning function called in a context that cannot accept a set", or however that was phrased. I'll put in a fix. regards, tom lane
    Tom LaneTom Lane
    Nov 22, 2004 at 4:52 pm
    Dec 1, 2004 at 10:08 pm
  • Hi, I got extremely frustrated with having to create a temp table every time I wanted to access an arbitrary column from a record plpgsql. After seeing a note on the developers TODO about accessing ...
    MattMatt
    Nov 18, 2004 at 1:18 pm
    Nov 24, 2004 at 3:08 pm
  • LWLockRelease() currently does something like (simplifying a lot): acquire lwlock spinlock decrement lock count if lock is free if first waiter in queue is waiting for exclusive lock, awaken him; ...
    Neil ConwayNeil Conway
    Nov 24, 2004 at 8:24 am
    Dec 3, 2004 at 2:23 am
  • It seems that in the new PL/Perl, the result of the spi_exec_query function changes in meaning depending on the command. For a SELECT, the value of $res- {rows} is a reference to an array of the ...
    Peter EisentrautPeter Eisentraut
    Nov 6, 2004 at 1:35 pm
    Nov 19, 2004 at 11:23 pm
  • Hi, I'm in the phase of implementing CLOB's and BLOB's in PL/Java. I found the inv_api.c and will use that as the base for my implementation. I lack two calls: int inv_length(LargeObjectDesc* lo); ...
    Thomas HallgrenThomas Hallgren
    Nov 28, 2004 at 9:22 am
    Dec 13, 2004 at 3:07 am
  • libpq compiled with --enable-thread-safety thinks it can set the SIGPIPE signal handler. It thinks once is enough. psql thinks it can arbitrarily flip the signal handler between SIG_IGN and SIG_DFL. ...
    Tom LaneTom Lane
    Nov 15, 2004 at 4:55 pm
    Dec 2, 2004 at 4:11 pm
  • Hello, I'm working on a thesis project where I explore the addition of a specialized, bioinformatics-related data type to a RDBMS. My choice of RDBMS is PostgreSQL, of course, and I've started by ...
    Troels ArvinTroels Arvin
    Nov 19, 2004 at 10:42 am
    Dec 3, 2004 at 4:27 pm
  • I've looked into storing charset/collation in the string values. This means that we change varchar/text/BpChar to be structures that have a charset oid field and a collation oid field, the rest of ...
    Dennis BjorklundDennis Bjorklund
    Nov 1, 2004 at 6:41 am
    Nov 3, 2004 at 6:08 am
  • Hello All, with the new Beta5 you will receive an error ""column "nsptablespace" does not exist"" on phpPgAdmin and EMS PostgreSQL-Manager. Perhaps there will be some more applications around which ...
    Roland VolkmannRoland Volkmann
    Nov 27, 2004 at 12:51 am
    Dec 5, 2004 at 10:33 pm
  • A few minor typos/notes: INDEXES 1. On 2nd bullet... "The main difficulty with this item is the problem of creating an index that can spam more than one table." should be span, not spam 2. On 6th ...
    Simon RiggsSimon Riggs
    Nov 4, 2004 at 9:34 am
    Nov 4, 2004 at 7:16 pm
  • We have this open item: Win32 o Handle "lost signals" on backend startup (eg. shutdown, config file changes, etc); signals are SIG_DFL on startup The problem here is that the postmaster might send ...
    Bruce MomjianBruce Momjian
    Nov 1, 2004 at 1:16 am
    Nov 1, 2004 at 9:42 pm
  • Moved to -hackers where this belongs :) I'm not sure if I like this one too much ... but it would be nice if something like this triggered a warning in the logs, maybe a feature of pg_autovacuum ...
    Marc G. FournierMarc G. Fournier
    Nov 4, 2004 at 10:26 pm
    Nov 29, 2004 at 1:14 pm
  • I have a minor issue with Makefile.shlib. Compiling with win32 it spits out these warnings (the same is true for Cygwin) Makefile.shlib:327: warning: overriding commands for target `libpljava.a' ...
    Thomas HallgrenThomas Hallgren
    Nov 16, 2004 at 8:28 pm
    Nov 17, 2004 at 4:39 pm
  • I'd like to propose that we get rid of GUC's USERLIMIT category and convert all the variables in it to plain SUSET. In my mind, USERLIMIT is a failed experiment: it's way too complicated, and it ...
    Tom LaneTom Lane
    Nov 9, 2004 at 10:27 pm
    Nov 14, 2004 at 7:36 pm
  • What is the general opinion of this? I'd like to implement it, but not so much so that I'm going to beat my head against a brick wall on it ... ---- Marc G. Fournier Hub.Org Networking Services ...
    Marc G. FournierMarc G. Fournier
    Nov 28, 2004 at 11:34 pm
    Nov 29, 2004 at 12:49 pm
  • As requested by Reini I set up a Cygwin buildfarm client, and immediately got this build failure: gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wendif-labels -fno-strict-aliasing -g pg_dump.o ...
    Andrew DunstanAndrew Dunstan
    Nov 6, 2004 at 6:35 pm
    Nov 17, 2004 at 5:47 pm
  • Hi, this query makes postmaster (beta4) die with signal 11: (echo "CREATE TABLE footest("; for i in `seq 0 66000`; do echo "col$i int NOT NULL,"; done; echo "PRIMARY KEY(col0));") | psql test ERROR: ...
    Joachim WielandJoachim Wieland
    Nov 14, 2004 at 9:33 am
    Nov 17, 2004 at 12:19 am
  • Hi all, I missed the discussion on hacker about this, and I'd like to give my HO. The fact that a non-volatile function can not perform update is a good improvement but on the other side will limit ...
    Gaetano MendolaGaetano Mendola
    Nov 1, 2004 at 7:53 pm
    Nov 4, 2004 at 11:53 am
  • I am running of postgresql database servers with generally 30-50 users at a time per server. I have noticed one thing for web based databases that they fail to initialse a pg_connection connection ...
    DruDru
    Nov 19, 2004 at 3:16 am
    Nov 23, 2004 at 12:51 am
  • I'd like to propose removing -Wold-style-definition from the default gcc flags. It is cluttering my make logs with warnings that can't be got rid of because they are about code generated by flex. ...
    Tom LaneTom Lane
    Nov 17, 2004 at 6:50 pm
    Nov 18, 2004 at 3:51 am
  • Yes, sounds good for me also. I think that would be a good thing even if viewed isolated from the rest of the proposal. I am sorry if I made the impression that I don't like a change in this ...
    Andreas ZeugswetterAndreas Zeugswetter
    Nov 29, 2004 at 11:29 am
    Nov 30, 2004 at 10:57 am
  • Oleg & Teodor, If I understand the code correctly, GiST will only pass the first attribute of each index tuple to the user-defined PickSplit method when it wants to split a node. (see circa line 1269 ...
    Neil ConwayNeil Conway
    Nov 14, 2004 at 9:22 am
    Nov 16, 2004 at 9:37 pm
  • Joachim Wieland has diligently and sensibly pointed out a potential for user error with the current PITR implementation. This is not a bug *per se*, but is a design flaw that more than one person ...
    Simon RiggsSimon Riggs
    Nov 6, 2004 at 10:08 pm
    Nov 7, 2004 at 7:14 pm
  • Hi, we use 7.4 and suffer from table and index bloat. I tracked down the issue to vacuum using GetOldestXmin() which returns the oldest xmin of any database in cluster, not xmin of the current ...
    Kuba OuhrabkaKuba Ouhrabka
    Nov 4, 2004 at 8:53 am
    Nov 4, 2004 at 4:53 pm
  • Hi All, I am doing serious thinking about the implementation of Auto Vacuum as part of the backend, Not using libpq, but classing internal functions directly. It appears to me that calling internal ...
    Russell SmithRussell Smith
    Nov 29, 2004 at 2:20 am
    Nov 30, 2004 at 4:22 am
  • Kris, Environment #1: WinXP 8.0beta4 server, 8.0jdbc client I get random failures with the following errors: $ grep ERROR postgresql-2004-11-19_091524.log 2004-11-19 12:19:06 ERROR: unrecognized node ...
    Barry LindBarry Lind
    Nov 20, 2004 at 1:40 am
    Nov 28, 2004 at 10:23 pm
  • I would like to beg for some sort of fix to psql's handling of COPY data if the COPY fails. Presently you get a million lines of '\N command not recognised' and various other random things because if ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Nov 29, 2004 at 4:24 am
    Nov 30, 2004 at 3:47 am
  • Attached, array - rows iterator. select * from unnest(array[1,2,3,4,5]); Unnest --------------- 1 2 3 4 5 5 rows The switch statement could probably be done in a different way, but there doesn't seem ...
    John HansenJohn Hansen
    Nov 5, 2004 at 12:10 pm
    Nov 29, 2004 at 6:02 pm
  • There's been some previous discussion of getting rid of the pg_class columns relpages and reltuples, in favor of having the planner check the current relation block count directly ...
    Tom LaneTom Lane
    Nov 26, 2004 at 10:56 pm
    Nov 29, 2004 at 12:06 am
  • Josh, what is a status of press release http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/press/pr/releases/8.0/en/release and it's translations ? Does it somehow confirmed ? What do you mean under "To ...
    Oleg BartunovOleg Bartunov
    Nov 12, 2004 at 8:27 pm
    Nov 12, 2004 at 9:47 pm
  • Hi, When doing CREATE or REPLACE FUNCTION of a builtin function, it seems to have no effect if its in the 'C" language. SQL functions seem to work, but as neilc pointed out, it may be due to the SQL ...
    John HansenJohn Hansen
    Nov 10, 2004 at 4:44 am
    Nov 10, 2004 at 11:42 pm
  • Has anyone else had any problem installing plpgsql into a 7.4.6 database? When I try (on NetBSD 2.0RC5) I get the following message: createlang: language installation failed: server closed the ...
    D'Arcy J.M. CainD'Arcy J.M. Cain
    Nov 18, 2004 at 6:41 pm
    Nov 24, 2004 at 11:52 am
  • I have a query where I want to override one of the output column names. The problem is that the columns are coming from a subquery. So I have do something like: select *, coalesce(a,b) as a from ...
    Greg StarkGreg Stark
    Nov 17, 2004 at 9:07 pm
    Nov 18, 2004 at 4:58 am
  • Ramy, glad to hear from you ! AFAIK, posgresql doesnt' supports several indices for the same type. I think this is a problem of optimizer. Probably other hackers know better. I forward your message ...
    Oleg BartunovOleg Bartunov
    Nov 10, 2004 at 5:35 am
    Nov 11, 2004 at 12:44 am
  • Hi, Environment: SunOS 5.7 Generic_106541-29 sun4u sparc SUNW,UltraSPARC-IIi-Engine Postgresql-7.4.6 Build config: --with-java --enable-thread-safety gcc version 3.3.1 less-381 readline-4.3 $ echo ...
    Jim SeymourJim Seymour
    Nov 21, 2004 at 5:40 pm
    Dec 2, 2004 at 11:55 pm
  • Hi, I have an intermittent bug in PL/Java that only shows up on Win32. Is there any way of debugging the postgres.exe process that corresponds to your connection on a win32 (MinGW) platform? I have a ...
    Thomas HallgrenThomas Hallgren
    Nov 24, 2004 at 11:16 pm
    Nov 25, 2004 at 6:17 pm
  • In a PL language it's sometimes desirable to prevent execution of some commands. I would like to prevent the commands "begin [work or transaction]", "commit", and "rollback", completely and I would ...
    Thomas HallgrenThomas Hallgren
    Nov 21, 2004 at 3:55 pm
    Nov 22, 2004 at 1:28 pm
Group Navigation
period‹ prev | Nov 2004 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions176
posts1,210
users161
websitepostgresql.org...
irc#postgresql

161 users for November 2004

Tom Lane: 237 posts Bruce Momjian: 93 posts Andrew Dunstan: 57 posts Thomas Hallgren: 54 posts Simon Riggs: 52 posts Neil Conway: 46 posts Greg Stark: 41 posts Marc G. Fournier: 29 posts Peter Eisentraut: 25 posts Gaetano Mendola: 22 posts John Hansen: 19 posts Josh Berkus: 16 posts Oleg Bartunov: 16 posts Magnus Hagander: 15 posts Andreas Zeugswetter: 14 posts Joshua D. Drake: 13 posts Reini Urban: 12 posts Robert Treat: 12 posts Gevik Babakhani: 11 posts Mark Kirkwood: 11 posts
show more
Archives