Search Discussions
-
129
massive quotes?
What is the state of things regarding having to use massive strings of quotes like this (taken from the 7.3 docs)?: a_output := a_output || '' if v_'' || referrer_keys.kind || '' like '''''''''' then ...Andrew Dunstan
Aug 28, 2003 at 6:17 pm
Sep 16, 2003 at 7:50 pm -
120
2-phase commit
Hi, As the 7.4 beta rolls on, I thought now would be a good time to start talking about the future. I have a potential need in the future for distributed transactions (XA). To get that from Postgres, ...Andrew Sullivan
Aug 26, 2003 at 9:56 pm
Oct 25, 2003 at 1:25 pm -
Everything looks like it built clean ... will do a quick, more general announce tomorrow, but if someone can confirm that things are good, that would be great ...
Marc G. Fournier
Aug 27, 2003 at 3:21 am
Sep 13, 2003 at 2:49 pm -
Yes, in practice, you'd have to put IS NOT NULL checks in the subselect, which is fine for the two match types we support since a referenced row with a NULL isn't a choice for a referenced row for ...
Stephan Szabo
Aug 15, 2003 at 2:59 pm
Oct 9, 2003 at 2:44 am -
Here are the changes for 7.4. I am looking for any improvements. This will be adjusted as we move through beta. I need to work on the other sections of a major release, like a compatibility section. ...
Bruce Momjian
Aug 3, 2003 at 11:30 pm
Aug 7, 2003 at 2:13 pm -
Hi every one, I've tried to reindex one of my customer's table to gain some disk space. I had to stop after 90 m cpu... I've then pg_dump'ed the database and recreate an other both on 7.3.4 and 7.4b ...
Ohp
Aug 28, 2003 at 12:42 pm
Mar 17, 2004 at 5:02 pm -
I did some basic profiling of CVS HEAD after having read Bruce's post the other day: When did we get so fast. It seemed to me that the number of inserts per second wasn't actually all that high so I ...
Gavin Sherry
Aug 12, 2003 at 1:05 am
Aug 25, 2003 at 4:12 am -
I received this from a friend: Lance Rushing wrote: This is a 7.3.3 installation on Red Hat (9 I think). I don't have any more detail yet on exactly what he was doing at this point, but I grabbed a ...
Joe Conway
Aug 30, 2003 at 5:32 pm
Sep 5, 2003 at 4:58 pm -
[ Beta discussion moved to hackers.] Peter Childs wrote: There will be a lost of config name and other changes in a special section soon. Rolling backups should be in 7.5, I hope. -- Bruce Momjian | ...
Bruce Momjian
Aug 14, 2003 at 10:13 pm
Aug 16, 2003 at 4:29 am -
Just wondering, what other databases has transactable DDLs? oracle seems to have autonomous transactions which is arthogonal. If we are going to compare it, we are going to need it against other ...
Shridhar Daithankar
Aug 21, 2003 at 10:10 am
Aug 24, 2003 at 11:22 pm -
This is a spill over from some discussions on some of the FreeBSD mailing lists about FS performance. After FreeBSD 4.5-RELEASE, the file system block size was bumped from 8K to 16K. Right now, ...
Sean Chittenden
Aug 28, 2003 at 7:21 pm
Aug 30, 2003 at 3:55 pm -
(Responding to the deafening silence regarding my posts a couple of days ago about logging dbnames and disconnections) ;-) The dbname patch is now done. If nobody objects to the format ...
Andrew Dunstan
Aug 5, 2003 at 4:19 pm
Aug 6, 2003 at 1:30 am -
Hi! Would it be possible to implement a "truncate all" that purges all tuples from *all* tables, without taking account any rules or triggers, but leaving all table structures and rules, triggers, ...
Andreas
Aug 4, 2003 at 9:25 am
Aug 24, 2003 at 10:59 pm -
20
TODO items
I am marking the completed TODO items. Are these done? * Have standalone backend read postgresql.conf * Prevent whole-row references from leaking memory, e.g. SELECT COUNT(tab.*) * Use index to ...Bruce Momjian
Aug 8, 2003 at 2:01 am
Aug 13, 2003 at 12:53 am -
Seems we have a problem with pooled connections and WITH HOLD cursors. We have code to reset transaction state and variables via RESET ALL, but how do we remove WITH HOLD cursors when we pass a ...
Bruce Momjian
Aug 8, 2003 at 5:36 pm
Aug 17, 2003 at 4:44 am -
Hi, I dropped the owner of a table (with no complaints), and now I get this: psql: asdf=# \dt List of relations Schema | Name | Type | Owner --------+------+-------+------------ public | a1 | table | ...
Christopher Kings-Lynne
Aug 11, 2003 at 2:07 am
Aug 12, 2003 at 6:57 pm -
I definitely don't want pg_dump using the pretty-print stuff ;-). I'm neutral on whether to use it in psql's \d commands. regards, tom lane
Tom Lane
Aug 7, 2003 at 3:18 pm
Aug 12, 2003 at 3:22 pm -
Hi Tom, Hi Larry After updating from cvs I'm going a little further. But still have problems: UX:acomp: ERROR: "fe-protocol3.c", line 1402: internal compiler error: can't deal with op BMOVE gmake[3]: ...
Ohp
Aug 7, 2003 at 5:10 pm
Aug 8, 2003 at 8:07 pm -
Well, let's see what additional functionality we need. I am not feeling too friendly on SCO/Unixware right now to jump through hoops. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us ...
Bruce Momjian
Aug 4, 2003 at 5:20 pm
Aug 7, 2003 at 12:13 am -
I have done some beta testing with PostgreSQL 7.4beta2. I have run a simple set of SQL statements 1 million times: -- START TRANSACTION ISOLATION LEVEL READ COMMITTED; INSERT INTO t_data (data) ...
Hans-Jürgen Schönig
Aug 30, 2003 at 12:09 pm
Sep 10, 2003 at 3:53 pm -
Hi, I've just tried the cvs on uw 7.13. It fails on compiling hba.c: UX:acomp: ERROR: "hba.c", line 651: undefined symbol: AI_NUMERICHOST UX:acomp: ERROR: "hba.c", line 1237: undefined symbol: ...
Ohp
Aug 7, 2003 at 12:43 pm
Aug 14, 2003 at 7:15 pm -
16
Farewell
FarewellIt's time for formal acknowledgement that I'm not in The Project any more. I'm not interested in small features/fixes and have no time for big ones. It was this way for very long time and I ...Vadim Mikheev
Aug 11, 2003 at 4:35 am
Aug 12, 2003 at 5:35 pm -
Will it be possible to tell a PostgreSQL back end to use *only* the new version of the FE/BE protocol? That is, will it be possible to set up a database that will reject connection attempts that do ...
Bruce Badger
Aug 29, 2003 at 12:32 am
Sep 4, 2003 at 4:11 pm -
Umm.. What does FSM does then? I was under impression that FSM stores page pointers and vacuum work on FSM information only. In that case, it wouldn't have to waste time to find out which pages to ...
Shridhar Daithankar
Aug 22, 2003 at 10:56 am
Aug 22, 2003 at 5:20 pm -
Hackers, I've been searching the archives, but I can't find the thread from last month where we discussed the problem with Linux memory overcommits in kernel 2.4.x. Can someone point me to the right ...
Josh Berkus
Aug 20, 2003 at 6:04 pm
Aug 21, 2003 at 7:24 pm -
(Not sure if hackers is the right place for this, but I'm not subscribed to all the lists!) The distributed 7.3.4 RPMs for RH 7.3 require libcrypto.so.3 and libssl.so.3, but there does not appear to ...
Andrew Dunstan
Aug 4, 2003 at 3:40 pm
Aug 5, 2003 at 2:48 pm -
Hi, I notice on the SET CONSTRAINTS doc page, it says SET CONSTRAINTS <constraint ... But it doesn't at all make it clear what <constraint is, since cosntraint names are per-relation I thought? Chris
Christopher Kings-Lynne
Aug 13, 2003 at 5:40 am
Sep 5, 2003 at 1:10 am -
Can someone explain in succinct and general terms what the difference between a NOTICE and a WARNING is? I'm currently examining the validity of notice and warning messages throughout the backend, ...
Peter Eisentraut
Aug 25, 2003 at 6:37 pm
Sep 3, 2003 at 10:45 pm -
Greg Stark
Aug 22, 2003 at 10:16 pm
Aug 24, 2003 at 8:32 pm -
I notice you can use the 'DROP TYPE' syntax to drop a domain. Should that be allowed? Chris
Christopher Kings-Lynne
Aug 4, 2003 at 5:18 am
Aug 17, 2003 at 4:28 am -
This is the situation, I create a user called " test=# create user """"; CREATE USER test=# drop user """"; DROP USER test=# create user """"; CREATE USER test=# create table temp(a int4); CREATE ...
Christopher Kings-Lynne
Aug 8, 2003 at 8:27 am
Aug 14, 2003 at 9:56 pm -
12
SetVariable
Hi all, I found this code on the file variables.c and in the function SetVariable I read: if (strcmp(current- name, name) == 0) { free(current- value); current- value = strdup(value); return current- ...Mendola Gaetano
Aug 27, 2003 at 2:59 pm
Sep 1, 2003 at 10:37 pm -
Hi all, I noticed that some date are not anymore accepted: Postgres 7.3.3: test=# select '18/03/71'::date; date ------------ 1971-03-18 (1 row) Postgres 7.4beta1: test=# select '18/03/71'::date; ...
Mendola Gaetano
Aug 26, 2003 at 3:39 pm
Aug 30, 2003 at 9:35 pm -
Hi all, the following code was working properly under Postgres 7.3.X I'm now running my regression test with Postgres 7.4beta1 and I'm having the error in subj. CREATE TABLE test ( a integer, b ...
Gaetano Mendola
Aug 8, 2003 at 1:36 am
Aug 8, 2003 at 7:22 pm -
Hi all, Following is from Documentation/vm/overcommit-accounting ------------- 2 - (NEW) strict overcommit. The total address space commit for the system is not permitted to exceed swap + a ...
Shridhar Daithankar
Aug 28, 2003 at 10:42 am
Sep 1, 2003 at 2:40 am -
I did some profiling and soon realized that the main problem is the executor's trick for not returning the same row multiple times in a multiple-indexscan plan node. The point is that given WHERE a = ...
Tom Lane
Aug 21, 2003 at 8:42 pm
Aug 24, 2003 at 9:37 pm -
following is taken from postgresql-7.3.2/src/backend/storage/lmgr/readme: "If we are setting a table level lock both the blockId and tupleId (in an item pointer this is called the position) are set ...
Jenny -
Aug 5, 2003 at 6:47 pm
Oct 6, 2003 at 2:44 am -
I've always wanted to be a PoatgreSQL hacker, and I am going to try this change out first. Bruce said that it's kind of low on the priority list, so hopefully I won't be holding anyone up if I take a ...
Jonathan Gardner
Aug 30, 2003 at 3:33 pm
Aug 30, 2003 at 11:12 pm -
So where are the new array functions and syntaces documented? Specifically I want to know how to replace my int_array_aggregate(int) and int_array_enum(_int) calls. And how to replace my "arr *= n" ...
Greg Stark
Aug 28, 2003 at 5:13 pm
Aug 28, 2003 at 11:04 pm -
Thanks to Tom and Bruce, we can now compile CVS 7.4 on UnixWare with OUT any tweaks, including the --enable-thread-safety switch. Here is what I used, and is now running on lerami: CC=cc CXX=CC ...
Larry Rosenman
Aug 15, 2003 at 3:23 am
Aug 25, 2003 at 4:04 am -
Hey, Just wondering if there is currently any mechanism in the contrib makefile hierarchy for installing header files into an appropriate directory. I didn't find anything. I'm using PGSphere ...
Robert Creager
Aug 23, 2003 at 4:18 am
Aug 24, 2003 at 9:27 pm -
(Thought triggered by something Tom said the other day) Is this a security hole? Looks like one to me. Would it be better to use a sequence generator for sysids instead of using max+1 on the user ...
Andrew Dunstan
Aug 12, 2003 at 2:37 pm
Aug 13, 2003 at 4:52 pm -
SuSE 7.3, PostgreSQL cvshead (7.4) This is as far as I've gotten with 7.4. It is built and configured like my 7.3 installation on the same machine. I have built from CVS previously. And the ...
Elein
Aug 11, 2003 at 3:11 am
Aug 11, 2003 at 9:46 pm -
I've been thinking about Ludwig Lim's recent report of a "stuck spinlock" failure on a heavily loaded machine. Although I originally found this hard to believe, there is a scenario which makes it ...
Tom Lane
Aug 5, 2003 at 8:11 pm
Aug 6, 2003 at 4:56 pm -
Is it intended that libpq is always compiled with the so-called "thread-safe" compiler option, regardless of whether I used --enable-thread-thing? -- Peter Eisentraut peter_e@gmx.net
Peter Eisentraut
Aug 4, 2003 at 1:29 pm
Aug 4, 2003 at 5:13 pm -
Hi, My name is Markus Kräutner, I am using PostgreSQL to build a distributed biological database as part of my diploma thesis. I hope this is the right forum for my question. At the end of several ...
Markus Kräutner
Aug 27, 2003 at 7:20 pm
Aug 28, 2003 at 1:58 pm -
Can we modify pg_dumpall (or pg_dump?) to include a \pset pager off to prevent the setval() calls from halting an interactive \i of the dump file? Thanks, LER -- Larry Rosenman ...
Larry Rosenman
Aug 11, 2003 at 5:39 pm
Aug 14, 2003 at 7:13 pm -
I've noticed that when the stats are wrong (like in cases where you've loaded data but reltuples hasn't been updated yet) that a hashed NOT IN seems to take a significant time penalty. Is this to be ...
Stephan Szabo
Aug 17, 2003 at 3:39 am
Aug 19, 2003 at 1:44 am -
I appear to have a hang on my system (40 minutes so far, it's now 17:40). The code is from CVS updated 8/6 if I remember correctly. The machine is idle, with a vacuum waiting and an INSERT doing ...
Robert Creager
Aug 9, 2003 at 11:49 pm
Aug 10, 2003 at 7:51 pm -
Guys, I've been testing 7.4 against an application today. Recompiled everything against the new libraries. However the application includes code which builds up a bulkload file in the documented 7.1 ...
Lee Kindness
Aug 1, 2003 at 3:12 pm
Aug 5, 2003 at 1:29 pm
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 227 |
posts | 1,343 |
users | 129 |
website | postgresql.org... |
irc | #postgresql |
129 users for August 2003
Archives
- August 2013 (1,430)
- July 2013 (1,772)
- June 2013 (2,428)
- May 2013 (1,555)
- April 2013 (1,283)
- March 2013 (1,441)
- February 2013 (1,366)
- January 2013 (2,520)
- December 2012 (1,701)
- November 2012 (1,618)
- October 2012 (1,580)
- September 2012 (1,195)
- August 2012 (1,180)
- July 2012 (1,125)
- June 2012 (1,850)
- May 2012 (1,584)
- April 2012 (1,459)
- March 2012 (1,921)
- February 2012 (1,517)
- January 2012 (1,777)
- December 2011 (1,347)
- November 2011 (1,764)
- October 2011 (1,687)
- September 2011 (1,623)
- August 2011 (1,433)
- July 2011 (1,658)
- June 2011 (2,404)
- May 2011 (1,664)
- April 2011 (1,834)
- March 2011 (1,956)
- February 2011 (2,476)
- January 2011 (2,965)
- December 2010 (2,587)
- November 2010 (2,109)
- October 2010 (2,113)
- September 2010 (2,173)
- August 2010 (2,061)
- July 2010 (1,612)
- June 2010 (1,560)
- May 2010 (1,961)
- April 2010 (1,575)
- March 2010 (1,314)
- February 2010 (2,439)
- January 2010 (3,118)
- December 2009 (2,514)
- November 2009 (493)
- October 2009 (1,903)
- September 2009 (1,990)
- August 2009 (2,170)
- July 2009 (2,025)
- June 2009 (1,565)
- May 2009 (1,518)
- April 2009 (1,431)
- March 2009 (1,424)
- February 2009 (1,399)
- January 2009 (2,641)
- December 2008 (2,011)
- November 2008 (1,918)
- October 2008 (1,695)
- September 2008 (1,887)
- August 2008 (1,374)
- July 2008 (1,495)
- June 2008 (1,149)
- May 2008 (1,112)
- April 2008 (1,908)
- March 2008 (1,288)
- February 2008 (1,309)
- January 2008 (1,220)
- December 2007 (989)
- November 2007 (1,369)
- October 2007 (1,553)
- September 2007 (1,225)
- August 2007 (1,221)
- July 2007 (1,007)
- June 2007 (1,127)
- May 2007 (1,189)
- April 2007 (1,266)
- March 2007 (1,866)
- February 2007 (1,916)
- January 2007 (1,645)
- December 2006 (1,423)
- November 2006 (1,021)
- October 2006 (1,565)
- September 2006 (2,375)
- August 2006 (2,039)
- July 2006 (1,626)
- June 2006 (1,624)
- May 2006 (1,366)
- April 2006 (1,150)
- March 2006 (1,327)
- February 2006 (1,259)
- January 2006 (1,030)
- December 2005 (1,252)
- November 2005 (1,568)
- October 2005 (1,417)
- September 2005 (1,464)
- August 2005 (1,191)
- July 2005 (1,150)
- June 2005 (1,576)
- May 2005 (1,592)
- April 2005 (1,004)
- March 2005 (1,069)
- February 2005 (969)
- January 2005 (1,100)
- December 2004 (949)
- November 2004 (1,210)
- October 2004 (1,059)
- September 2004 (951)
- August 2004 (1,601)
- July 2004 (1,397)
- June 2004 (1,037)
- May 2004 (1,446)
- April 2004 (1,167)
- March 2004 (1,330)
- February 2004 (1,003)
- January 2004 (861)
- December 2003 (827)
- November 2003 (1,618)
- October 2003 (1,602)
- September 2003 (1,683)
- August 2003 (1,343)
- July 2003 (1,045)
- June 2003 (1,302)
- May 2003 (802)
- April 2003 (1,012)
- March 2003 (1,242)
- February 2003 (1,323)
- January 2003 (1,315)
- December 2002 (1,176)
- November 2002 (1,220)
- October 2002 (1,449)
- September 2002 (1,816)
- August 2002 (2,295)
- July 2002 (1,290)
- June 2002 (1,024)
- May 2002 (1,157)
- April 2002 (1,532)
- March 2002 (1,207)
- February 2002 (1,225)
- January 2002 (1,397)
- December 2001 (963)
- November 2001 (1,301)
- October 2001 (1,155)
- September 2001 (895)
- August 2001 (1,204)
- July 2001 (938)
- June 2001 (1,131)
- May 2001 (1,458)
- April 2001 (1,168)
- March 2001 (1,672)
- February 2001 (1,154)
- January 2001 (1,450)
- December 2000 (1,222)
- November 2000 (1,390)
- October 2000 (1,296)
- September 2000 (633)
- August 2000 (888)
- July 2000 (1,428)
- June 2000 (1,283)
- May 2000 (1,648)
- April 2000 (184)
- March 2000 (291)
- February 2000 (1,464)
- January 2000 (1,639)
- December 1999 (1,056)
- November 1999 (916)
- October 1999 (949)
- September 1999 (946)
- August 1999 (695)
- July 1999 (1,070)
- June 1999 (1,242)
- May 1999 (1,136)
- April 1999 (218)
- March 1999 (1,002)
- February 1999 (692)
- January 1999 (758)
- December 1998 (591)
- November 1998 (600)
- October 1998 (1,208)
- September 1998 (678)
- August 1998 (856)
- July 1998 (482)
- June 1998 (496)
- May 1998 (618)
- April 1998 (702)
- March 1998 (1,118)
- February 1998 (1,307)
- January 1998 (855)
- December 1997 (346)
- November 1997 (374)
- October 1997 (575)
- September 1997 (549)
- August 1997 (404)
- July 1997 (391)
- June 1997 (595)
- May 1997 (478)
- April 1997 (854)
- March 1997 (526)
- February 1997 (297)
- January 1997 (927)
- December 1996 (2)
- November 1996 (1)
- October 1996 (1)
- October 1995 (2)
- July 1995 (1)