Search Discussions

150 discussions - 1,366 posts

  • Sorry to interrupt, but I have had the "opportinuty" to have to work with MySQL. This nice little gem is packed away in the reference for mysql_use_result(). "On the other hand, you shouldn't use ...
    Mark L. WoodwardMark L. Woodward
    May 18, 2006 at 12:29 am
    May 23, 2006 at 11:32 pm
  • A recent post Tom made in -bugs about how bad performance would be if we spilled after-commit triggers to disk got me thinking... There are several operations the database performs that potentially ...
    Jim C. NasbyJim C. Nasby
    May 15, 2006 at 5:45 pm
    Jun 7, 2006 at 5:27 pm
  • Hellow PostgreSQL hackers, Quick question. Why does the 'i = i + 1' syntax work in this PL/pgSQL function? try=# CREATE OR REPLACE FUNCTION inc_by_two( try(# upfrom int, try(# upto int try(# ) ...
    David WheelerDavid Wheeler
    May 16, 2006 at 11:21 pm
    May 19, 2006 at 9:47 pm
  • I've been thinking about the planner's costing problems again, particularly in connection with Philippe Lang's complaint here: http://archives.postgresql.org/pgsql-general/2006-05/msg01526.php ...
    Tom LaneTom Lane
    May 31, 2006 at 7:45 pm
    Jun 7, 2006 at 12:32 am
  • Long mail, but I think it's interesting... I think this is a generic problem, which is often encountered : selecting a bunch of records based on a list of primary keys (or other indexed, unique ...
    May 9, 2006 at 8:37 am
    May 18, 2006 at 7:49 am
  • Hi all. I've experienced several times that PG has died somehow and the postmaster.pid file still exists 'cause PG hasn't had the ability to delete it upon proper shutdown. Upon start-up, after such ...
    Andreas Joseph KroghAndreas Joseph Krogh
    May 23, 2006 at 3:23 pm
    May 25, 2006 at 2:10 pm
  • After re-reading what I just wrote to Andreas about how compression of COPY data would be better done outside the backend than inside, it struck me that we are missing a feature that's fairly common ...
    Tom LaneTom Lane
    May 31, 2006 at 3:03 pm
    Jun 4, 2006 at 9:39 pm
  • It comes up repeatedly that I need to load fresh data into a new table, build indexes and vacuum - then drop the old table and substitute the new. Deleting old and inserting new records is too slow - ...
    April LorenzenApril Lorenzen
    May 22, 2006 at 6:25 pm
    May 31, 2006 at 7:59 pm
  • Hi Yesterday I helped a guy on irc with a locking problem, he thought that locking in postgresql was broken. It turned out that he had a PHP function that he called inside his transaction and the ...
    Dennis BjorklundDennis Bjorklund
    May 10, 2006 at 5:44 am
    May 18, 2006 at 2:32 am
  • I am trying desperately to find a way to create an audit table to log...who SELECTED what... as I am dealing with HR data and Health Care Patient Data Any help would be greatly appreciated and put to ...
    Hogan, James F. Jr.Hogan, James F. Jr.
    May 12, 2006 at 5:11 pm
    May 17, 2006 at 7:17 am
  • [ Email moved to hackers list.] Good question. This has come up a few times. You can check if the installation has threading with "pg_config --configure", and I though there was a way to test at ...
    Bruce MomjianBruce Momjian
    May 13, 2006 at 12:38 am
    May 17, 2006 at 7:02 pm
  • anoncvs (svr4, is still slow responding to "cvs update"; it's been spotty for about a week now. Tcpdump shows connections being established but then long delays for ACKs, sometimes ...
    Michael FuhrMichael Fuhr
    May 27, 2006 at 7:07 pm
    May 31, 2006 at 12:32 am
  • Well, there's our smoking gun. IIRC, all the failures you showed us are consistent with race conditions caused by multiple archiver processes all trying to do the same tasks concurrently. Do you ...
    Tom LaneTom Lane
    May 19, 2006 at 3:59 pm
    May 23, 2006 at 3:26 pm
  • I have spent some time figuring out how to resolve the parsing conflicts in Bernd Helmle's updatable views patch. The problem has now been reduced to specifically this situation: CREATE VIEW foo AS ...
    Peter EisentrautPeter Eisentraut
    May 24, 2006 at 11:13 am
    May 29, 2006 at 9:22 am
  • Hi William(uniware), Chuck and Hackers, I have been interested in doing complete PGSQL development in MSVC for a long time now. With reference to one of Chuck's mails to -hackers-win32 with the same ...
    Gurjeet SinghGurjeet Singh
    May 5, 2006 at 3:28 am
    Jul 13, 2006 at 3:25 pm
  • When preparing to transfer blob data from one database to another (8.0.5 to 8.1.4), I found some interesting numbers that made me suspect that bytea dumping is more ineffective than expectable. I ...
    Andreas PflugAndreas Pflug
    May 25, 2006 at 4:17 pm
    May 30, 2006 at 7:44 am
  • PG-Hackers, I got the following picture: detran=# \d sa_dut.tb_usuario Table "sa_dut.tb_usuario" Column | Type | Modifiers -------------------------+-----------------------------+----------- ...
    Rodrigo HjortRodrigo Hjort
    May 23, 2006 at 11:11 pm
    May 29, 2006 at 6:52 am
  • Currently, WAL files will be archived as soon as archive_command is set. IMHO, this is not desirable if no permanent backup is wanted, but only scheduled online backup because; it will flood the ...
    Andreas PflugAndreas Pflug
    May 25, 2006 at 11:01 am
    May 27, 2006 at 11:52 am
  • pg_dump is designed to produce dumps that can be loaded into newer PostgreSQL versions, and it can read from older database versions. The new backslash escape warning and sql standard strings might ...
    Bruce MomjianBruce Momjian
    May 13, 2006 at 7:38 pm
    May 18, 2006 at 4:08 pm
  • Just experienced a server that was spending over 50% of CPU time in the system, apparently dealing with postmasters that were in the sblock state. Looking at the FreeBSD source, this indicates that ...
    Jim C. NasbyJim C. Nasby
    May 3, 2006 at 12:39 am
    May 11, 2006 at 8:47 pm
  • The function static int32 text_position(text *t1, text *t2, int matchnum) defined in src/backend/utils/adt/varlena.c uses repeated calls to strncmp (or pg_wchar_strncmp) to find the location of the ...
    Mark DilgerMark Dilger
    May 19, 2006 at 12:17 am
    May 20, 2006 at 4:54 am
  • Hi everyone, Having browsed the TODO list, one of the items that I would be interested on working on is a debugger for stored procedures. Having searched on this topic in the archives, I'm still ...
    Mark Cave-AylandMark Cave-Ayland
    May 29, 2006 at 4:26 pm
    Jun 13, 2006 at 7:56 pm
  • I am asking again: what is the timetable for merging gborg and pgfoundry, and if not, can we set a date to shut down to force the move. -- Bruce Momjian http://candle.pha.pa.us EnterpriseDB ...
    Bruce MomjianBruce Momjian
    May 25, 2006 at 2:33 am
    May 26, 2006 at 12:57 am
  • I have a side project that needs to "intelligently" know if two strings are contextually similar. Think about how CDDB information is collected and sorted. It isn't perfect, but there should be ...
    Mark L. WoodwardMark L. Woodward
    May 19, 2006 at 7:49 pm
    May 22, 2006 at 11:36 am
  • Hi, I'm trying to write a PL/Python function which is to be called from a rule. I'd need pass the OLD and NEW tuple records to the function. Unfortunately that does not work: 'pl/python functions ...
    Markus SchiltknechtMarkus Schiltknecht
    May 4, 2006 at 2:13 pm
    May 7, 2006 at 3:37 am
  • I would have gotten this out sooner but I'm having trouble with our infrastructure. Here's a link to a table of data I've started putting together regarding XLOG_BLCKSZ and wal_buffers on a 4-way ...
    Mark WongMark Wong
    May 1, 2006 at 5:15 am
    Jun 5, 2006 at 9:42 am
  • Greetings, I've got a patch to be reviewed for having the stats system keep track of the last time a table was vacuumed or analyzed either by the user or via AutoVacuum. The patch is at: ...
    Larry RosenmanLarry Rosenman
    May 2, 2006 at 6:18 pm
    May 20, 2006 at 12:25 am
  • I can create a function that takes a two dimension int array: CREATE FUNCTION twodims(int[][]) RETURNS void AS ... but there's nothing stopping me from calling this function with an arbitrary number ...
    Thomas HallgrenThomas Hallgren
    May 8, 2006 at 4:34 pm
    May 9, 2006 at 11:13 pm
  • Am I correct in the thought that the various files listed below are not used by the database and can be safely removed? There were no other active db connections when I issued this command. I think ...
    Rod TaylorRod Taylor
    May 5, 2006 at 5:55 pm
    May 5, 2006 at 11:23 pm
  • Normally Postgres extends SQL to allow ORDER BY to include arbitrary expressions not in the select list. However this doesn't seem to work with SELECT DISTINCT. stark= \d test Table "public.test" ...
    Greg StarkGreg Stark
    May 3, 2006 at 9:58 pm
    May 4, 2006 at 5:18 pm
  • Coverity picked up an error in dumpStdStrings() since last night. At line 1448 there's PQclear(res) yet it's used several times further down (lines 1452, 1454 and 1456). I'd actually suggest zeroing ...
    Martijn van OosterhoutMartijn van Oosterhout
    May 28, 2006 at 12:32 pm
    May 28, 2006 at 5:42 pm
  • Greetings Guys As a newbie person moving away from my technical background to marketing, I think a refreshed course for pg is needed! So far I have read all 5000 or so of this month's emails and want ...
    Michael DeanMichael Dean
    May 18, 2006 at 8:32 pm
    May 20, 2006 at 7:04 pm
  • Moving to -hackers So you actually write out schemaname.tablename.fieldname for every field in the SELECT clause? Yikes! In any case, I agree that there should be a way to have EXPLAIN (and other ...
    Jim C. NasbyJim C. Nasby
    May 15, 2006 at 5:54 pm
    May 17, 2006 at 2:19 pm
  • Hello, I was dinking around wand came across something that may (or may not be useful). What if single line statements that were seperated by ; within psql were implicitly within a transaction? E.g; ...
    Joshua D. DrakeJoshua D. Drake
    May 16, 2006 at 2:58 am
    May 16, 2006 at 8:39 pm
  • Hey everyone, I'm reworking hierarchical queries and am adding a LEVEL pseudocolumn. As it's a totally calculated attribute, what's the best way to handle it keeping in mind that LEVEL is only used ...
    Jonah H. HarrisJonah H. Harris
    May 15, 2006 at 3:03 pm
    May 16, 2006 at 1:44 pm
  • I would like to implement following item from TODO list: * Allow commenting of variables in postgresql.conf to restore them to defaults. Currently, if a variable is commented out, it keeps the ...
    Zdenek KotalaZdenek Kotala
    May 10, 2006 at 6:48 pm
    May 15, 2006 at 6:11 pm
  • Veil http://pgfoundry.org/projects/veil is currently not a very good Postgres citizen. It steals what little shared memory it needs from postgres' shared memory using ShmemAlloc(). For Postgres 8.2 I ...
    Marc MunroMarc Munro
    May 19, 2006 at 12:39 am
    May 23, 2006 at 4:10 pm
  • There's been some new code added to pg_resetxlog which is confusing enough that Coverity is convinced there's a possible memory leak in InsertXLogFile. I think it may actually be a bug. At the least ...
    Martijn van OosterhoutMartijn van Oosterhout
    May 1, 2006 at 10:26 am
    May 6, 2006 at 4:31 pm
  • Hi, I cant find any function, which tells me something like session id. Is there something like that? I need it in my AM, because I need to know, if something which I wrote in file was written in ...
    David HokszaDavid Hoksza
    May 30, 2006 at 1:20 pm
    Jun 29, 2006 at 2:11 pm
  • Now that the magic-block patch is in, we need to revisit this bit of the discussion. I'm for making lack of a magic block an ERROR immediately. I don't see the point of waiting; in fact, if we wait ...
    Tom LaneTom Lane
    May 30, 2006 at 10:20 pm
    Jun 3, 2006 at 8:05 am
  • ppport.h is throwing warnings when compiling on Fedora Core 5 (with perl-5.8.8-4). I gather from the comments in the head of that file that we ought to look for a newer version. regards, tom lane
    Tom LaneTom Lane
    May 30, 2006 at 12:29 pm
    May 31, 2006 at 9:05 pm
  • Hi, In PL/Py, I had the bright idea of storing bytecode in the probin field of the function's pg_proc row. However, this idea has lately become rather dim as I have recently rediscovered(thanks ...
    James William PyeJames William Pye
    May 27, 2006 at 2:42 am
    May 29, 2006 at 10:10 pm
  • Hi, Below is the notes from postgresql-8.1.3/src/backend/storage/lmgr/README: Lock acquisition (routines LockAcquire and ProcSleep) follows these rules: 1. A lock request is granted immediately if it ...
    May 29, 2006 at 11:07 am
    May 29, 2006 at 4:16 pm
  • Hi All, I am constantly getting this error: make -C pl all make[2]: Entering directory `/d/Dev/postgres/pgsql_tip/src/pl' make[3]: Entering directory `/d/Dev/postgres/pgsql_tip/src/pl/plpgsql' make ...
    Gurjeet SinghGurjeet Singh
    May 27, 2006 at 5:57 pm
    May 28, 2006 at 2:42 am
  • hi all, i've working built-from-source v813 installs on OSX 10.4.6. staring with a clean 814 src tree, a similarly-config'd build completes without error: % postmaster --version postmaster ...
    May 24, 2006 at 11:53 pm
    May 26, 2006 at 12:59 pm
  • Shouldn't SELECT max(*) FROM foo; give an error? Instead it's executed like SELECT max(1) FROM foo; Just like count(*) is executed as count(1). Something for the TODO or is it a feature? ps. I know ...
    Dennis BjorklundDennis Bjorklund
    May 26, 2006 at 8:22 am
    May 26, 2006 at 11:32 pm
  • I attempt to execute a "COPY test FROM STDIN" using PQsendQuery. Subsequently, after the appropriate poll()/PQconsumeInput/PQisBusy calls, PQgetResult returns tens of millions of (invalid?) non-null ...
    Max PolettoMax Poletto
    May 19, 2006 at 6:51 pm
    May 25, 2006 at 2:03 pm
  • I've been working on a function which returns a setof a composite type. Everytime I've changed the structure of the returning setof, I've had to change the type accordingly, which current means doing ...
    John JawedJohn Jawed
    May 24, 2006 at 12:30 am
    May 24, 2006 at 8:50 pm
  • The last few days the CVS server seems to be much slower than it used to be. No network changes here. Anything changed server side, or should I ask elsewhere? -- Simon Riggs EnterpriseDB ...
    Simon RiggsSimon Riggs
    May 23, 2006 at 3:21 pm
    May 24, 2006 at 7:18 pm
  • I have the following doubts. 1. Does postgres create an index on every primary key? Usually, queries are performed against a table on the primary key, so, an index on it will be very useful. 2. If 'm ...
    Dhanaraj MDhanaraj M
    May 23, 2006 at 11:55 am
    May 24, 2006 at 4:28 am
Group Navigation
period‹ prev | May 2006 | next ›
Group Overview
grouppgsql-hackers @

158 users for May 2006

Tom Lane: 256 posts Jim Nasby: 123 posts Martijn van Oosterhout: 82 posts Bruce Momjian: 75 posts Andrew Dunstan: 48 posts Simon Riggs: 36 posts Alvaro Herrera: 33 posts Hannu Krosing: 33 posts Joshua D. Drake: 31 posts Thomas Hallgren: 29 posts Josh Berkus: 27 posts Greg Stark: 25 posts Andreas Pflug: 24 posts Gurjeet Singh: 23 posts Jonah H. Harris: 20 posts Magnus Hagander: 19 posts Mark L. Woodward: 16 posts Andreas Zeugswetter: 15 posts Christopher Kings-Lynne: 15 posts Larry Rosenman: 15 posts
show more