Search Discussions
-
43
Disaster!
We ran out of disk space on our main server, and now I've freed up space, we cannot start postgres! Jan 23 12:18:50 canaveral postgres[563]: [2-1] LOG: checkpoint record is at 2/96500B94 Jan 23 ...Christopher Kings-Lynne
Jan 23, 2004 at 8:29 pm
Jan 31, 2004 at 4:54 am -
Hello, Is is possible to change the transaction behaviour not to abort when a syntax error occurs. I've done some searches on the list, and have not found anything. -ESR-
Edwin S. Ramirez
Jan 30, 2004 at 3:50 pm
Feb 23, 2004 at 5:40 pm -
34
What's left?
Hello, I think it's safe to say there is a working implementation of a signal handler. The one tricky part left is to identify some smart places for the backend to check the awaiting signal queue. ...Merlin Moncure
Jan 22, 2004 at 3:00 pm
Mar 14, 2004 at 5:37 am -
As some know, win32 doesn't have sync, and some are concerned that sync isn't reliable enough during checkpoint anyway. The trick is to somehow record all files modified since the last checkpoint, ...
Bruce Momjian
Jan 30, 2004 at 5:01 pm
May 14, 2004 at 11:34 am -
We frequently recommend to people that they increase sort_mem while creating btree indexes. It is reasonable to have a larger setting for that purpose, since (1) a single backend isn't going to be ...
Tom Lane
Jan 31, 2004 at 10:00 pm
Feb 12, 2004 at 5:06 pm -
[ Moved to hackers.] I am starting to agree that our \d* handling is just too overloaded. Look at the option list from \?: Informational \d [NAME] describe table, index, sequence, or view ...
Bruce Momjian
Jan 4, 2004 at 1:26 am
Mar 31, 2004 at 1:06 am -
How feasible would it be to have a btree index on ctid? I'm thinking it ought to work simply enough for the normal case of insert/delet/update, but I'm not completely certain how vacuum, vacuum full, ...
Greg Stark
Jan 27, 2004 at 8:41 pm
Jan 31, 2004 at 12:50 am -
Hi, Is this all that's planned for 7.5? (based on current TODO list) -Change factorial to return a numeric (Gavin) -COMMENT ON [ CAST | CONVERSION | OPERATOR CLASS | LARGE OBJECT | LANGUAGE ] ...
Ow
Jan 12, 2004 at 7:14 pm
Jan 26, 2004 at 6:33 pm -
hello, this note is intended to describe my work on beginning to further integrate xml into postgresql. first, i'd like to thank the contributers of contrib/xml as their work was instrumental in ...
Brian Moore
Jan 25, 2004 at 9:07 am
Jan 31, 2004 at 3:35 am -
In CreateSharedMemoryAndSemaphores, there is the following comment, just before CreateLWLocks(): /* * Now initialize LWLocks, which do shared memory allocation and are * needed for InitShmemIndex. */ ...
Claudio Natoli
Jan 12, 2004 at 9:12 am
Jan 27, 2004 at 2:46 pm -
So one of the client machines for one of my databases at work resides on 10.128.0.45. I had to enter something in pg_hba.conf for it today, as we're bringing this database up. We have a lot of 10/8 ...
Alex J. Avriette
Jan 7, 2004 at 2:33 am
Jan 7, 2004 at 9:56 pm -
19
Write cache
Because I've lost a lot of data using postgresql (and I know for sure this should'nt happen) I've gone a bit further reading documentations on my disks and... I have FUJITSU MAP3367NC 36G 10000 rpm ...Ohp
Jan 27, 2004 at 9:44 pm
Jan 31, 2004 at 9:19 pm -
I've been looking (and coded) a little bit on named function calls. Calls on the form: foo (x = 13, y = 42) Implementing this means that the symbol = no longer can be defined by the user as an ...
Dennis Bjorklund
Jan 25, 2004 at 9:13 am
Jan 26, 2004 at 7:48 pm -
Just had a client point this out to me, and am wondering if its supposed to happen: 420_test= select dropgeometrycolumn('420_test','lroadline61','roads61_geom'); ERROR: permission denied for relation ...
Marc G. Fournier
Jan 19, 2004 at 7:50 pm
Feb 4, 2004 at 5:36 pm -
(I hope this is -hackers appropriate - feel free to point me elsewhere) I'm using 7.4.1 as the backend to several applications. Until recently, I've been developing solely single-threaded ...
Steve Atkins
Jan 14, 2004 at 6:46 am
Jan 31, 2004 at 8:17 pm -
This is not directly related to current development, but it is something that might need a low-level solution. I've been thinking for some time about how to enchance the current "XML support" (e.g., ...
Peter Eisentraut
Jan 9, 2004 at 6:46 pm
Jan 21, 2004 at 5:06 am -
libpq needs additional changes for complete thread safety: - openssl needs different initialization. - kerberos is not thread safe. - functions such as gethostbyname are not thread safe, and could be ...
Manfred Spraul
Jan 11, 2004 at 2:11 pm
Feb 11, 2004 at 9:58 pm -
I've created a stub AM that literally does nothing. It indexes nothing. It scans for nothing. Nadda. It does just enough work to specify return values that prevent PG from dumping core. What I've ...
Eric Ridge
Jan 18, 2004 at 2:26 am
Jan 19, 2004 at 3:59 am -
http://www.postgresql.org/docs/7.3/static/transaction-iso.html#XACT-READ-COMMITTED Reading this: " BEGIN; UPDATE accounts SET balance = balance + 100.00 WHERE acctnum = 12345; UPDATE accounts SET ...
Marc G. Fournier
Jan 29, 2004 at 5:38 pm
Jan 30, 2004 at 11:47 am -
11
nomenclature
Just overheard one of my colleagues on the phone to one of our users taking them through the process of moving their PGDATA to a partition with space... With the various paths, service names, config ...Lee Kindness
Jan 16, 2004 at 11:09 am
Jan 16, 2004 at 5:42 pm -
I've been looking in the sql200x draft and there are no function calls with named arguments. Thinking more about it, I'm not sure if it really is an important addition at all. I've got a number of ...
Dennis Bjorklund
Jan 27, 2004 at 4:34 pm
Jan 28, 2004 at 5:16 pm -
hello, i would like to begin work on the TODO item Allow backend to output result sets in XML i would like to know if anyone has already begun work on this item. if someone has already started work, ...
Brian Moore
Jan 20, 2004 at 6:34 am
Jan 23, 2004 at 3:04 am -
I am looking at the possibility of cleaning up the binary tree on the ftp site, and was wondering what the group thought about purging old binaries. What I was thinking would be to remove all but the ...
Lamar Owen
Jan 19, 2004 at 7:36 pm
Jan 21, 2004 at 1:42 am -
Hi all, After unsuccessfully trying to join the current OLE DB project on gborg, I'm writing my own. So far I don't have anything too fancy (just trying to get over the initial shock of what OLE DB ...
Shachar Shemesh
Jan 8, 2004 at 8:06 pm
Jan 12, 2004 at 1:18 pm -
The default installation in fedora does not work very well for non english people. For example. if I run psql and type COMMIT i get: dennis=# commit; WARNING: COMMIT: ingen transaktion p g while it ...
Dennis Björklund
Jan 9, 2004 at 7:10 am
Jan 9, 2004 at 10:41 pm -
10
time format
how can i change default time format because now i have for example 2004-01-01 16:51:46.995927 but i want only 2004-01-01 16:51:46, with out millisec. a tryed with Data-Style but there arent custom ...Ivan
Jan 1, 2004 at 3:54 pm
Jan 5, 2004 at 8:41 pm -
Hi all, From the OLE DB manual: The problem - it appears there is no requirement to execute the command before asking about the rowset returned. Only setting the actual command and preparing it. This ...
Shachar Shemesh
Jan 19, 2004 at 2:14 pm
Jan 30, 2004 at 10:50 am -
Would it be okay if I add some .cvsignore files to cvs? So we don't need to get rows like ? po/tr.mo ? po/zh_CN.mo ? po/zh_TW.mo ? utils/mb/conversion_procs/euc_jp_and_sjis/libeuc_jp_and_sjis.so.0.0 ...
Dennis Bjorklund
Jan 24, 2004 at 7:43 am
Jan 24, 2004 at 8:13 pm -
Dear friends, In the past, there were several discussions in order to find suitable answers for MS Windows users willing to install and run PostgreSQL. Some of you suggested that users should ...
Jean-Michel POURE
Jan 22, 2004 at 3:16 pm
Jan 24, 2004 at 4:01 pm -
I have hacked analyze.c to automatically create a unique index on the oid when a table is created and I am getting the failed to re-find parent key in pg_attribute_relid_attnam_index every 8 attempts ...
Dave Cramer
Jan 13, 2004 at 9:31 pm
Jan 14, 2004 at 2:41 pm -
What is needed to provide spinlock support for linux on hppa? make[5]: Entering directory `/build/buildd/postgresql-7.4.1/build-tree/postgresql-7.4.1/src/backend/access/transam' ... hppa-linux-gcc ...
Oliver Elphick
Jan 1, 2004 at 3:23 am
Jan 4, 2004 at 6:52 pm -
Hi Is it just me, or is there any way a sort could be relevant in a subquery? (except on queries containing volatile functions) select a.* from test1 a, (select id from test1 order by num) as b where ...
Dennis Haney
Jan 27, 2004 at 4:27 pm
Jan 27, 2004 at 10:31 pm -
The GEQO planner module contains six different recombination algorithms, only one of which is actually used --- the others are ifdef'd out, and have been ever since we got the code. Does anyone see a ...
Tom Lane
Jan 22, 2004 at 4:16 am
Jan 23, 2004 at 5:51 am -
This is what we did: 0. BEGIN; 1. ALTER TABLE ... SET WITHOUT OIDS 2. A bunch of things are selected out of this table and inserted into another (using INSERT ... SELECT) 3. An index is created on a ...
Christopher Kings-Lynne
Jan 21, 2004 at 8:04 am
Feb 12, 2004 at 5:40 am -
I would like to register a "transaction callback" in the backend. Don't think it's possible today and my question is, how hard would it be to implement something that would enable this registration? ...
Thomas Hallgren
Jan 31, 2004 at 4:50 pm
Jan 31, 2004 at 11:20 pm -
[ CC to hackers added.] Uh, a password? What purpose would that serve? Isn't that something you control when attaching to the database? Is this for prompting for a username password? The problem is ...
Bruce Momjian
Jan 27, 2004 at 2:42 am
Jan 28, 2004 at 10:25 pm -
Yes, my patch only handles pl/pgsql so far. The patch was big enough as it was. I've not looked at it since I sent it in, I wanted to see what happend with it before spending more time on it. Things ...
Dennis Björklund
Jan 7, 2004 at 5:59 am
Jan 8, 2004 at 1:43 am -
be merged (hope it hasn't bitrotted in the meantime): and user statements configurable using your setup. I thought we had thrashed this out back in August. Certainly the only thing I recall seeing ...
Andrew Dunstan
Jan 6, 2004 at 10:57 am
Jan 6, 2004 at 10:36 pm -
Gavin Sherry
Jan 27, 2004 at 7:22 am
Feb 12, 2004 at 7:21 pm -
With improvement I can see that it can be materialized and thus used as a normal table in the planner. Is there any additional reasons that I can't see? But this limited optimization makes me wonder, ...
Dennis Haney
Jan 23, 2004 at 6:37 pm
Jan 27, 2004 at 5:28 pm -
Floating point math itself is not precise, but rather an approximation, usually of 8 or 14 digits. You can't approximate money. This isn't a PostgreSQL issue but rather a general programming issue. ...
Bruce Momjian
Jan 5, 2004 at 12:53 am
Jan 12, 2004 at 6:14 pm -
Hi there, I'm pleased to present pilot version of http://www.pgsql.ru - search system on postgresql related resources. Currently, we have crawled 27 sites, new resources are welcome. It has ...
Oleg Bartunov
Jan 5, 2004 at 2:49 pm
Jan 9, 2004 at 8:13 am -
Hi, Was wondering if there was anything akin to an evaluate statement in Postgresql for dynamic strings? Alex
A E
Jan 4, 2004 at 9:09 pm
Jan 6, 2004 at 4:25 pm -
Is it possible to make a composite GiST index? I want to create an index on a txtidx and a timestamp column - is that at all possible? Chris
Christopher Kings-Lynne
Jan 5, 2004 at 6:40 am
Jan 5, 2004 at 3:41 pm -
2 things. I submitted a patch for this 5 months ago, which is still waiting to be merged (hope it hasn't bitrotted in the meantime): . Allow log lines to include session-level information, like ...
Andrew Dunstan
Jan 5, 2004 at 6:54 pm
Mar 31, 2004 at 3:55 pm -
I needed these, so I went and implemented them myself. I have to admit I'm not so wise on PostgreSQL backend stuff, and so I abstained from editing the fmgrtab.c and postgres.bki. Sorry for that, but ...
David Helgason
Jan 23, 2004 at 12:59 am
Feb 12, 2004 at 4:06 pm -
Dear Hackers, First: I think I have sent out a msg with no body. I'm sorry, I have to communicate thru a weird Win98 machine, it gets things screwed up sometimes. I would like to take up the ...
BARTKO, Zoltan
Jan 29, 2004 at 6:24 am
Feb 2, 2004 at 7:57 am -
Hi folks, I upgraded two servers today from 7.3.* to 7.4.1. In both cases, the schemas which existed in the original databases were not created in the new database. The CREATE SCHEMA commands are ...
Dan Langille
Jan 31, 2004 at 2:10 am
Jan 31, 2004 at 5:11 pm -
Hi, I've upgraded my production system to 741 yesterday, and just discovered this log message: statistic buffer is full. What does it mean? filing up too fast, no more stats, need to grow? What ...
Ohp
Jan 26, 2004 at 1:26 pm
Jan 26, 2004 at 5:53 pm -
Hi all, We are building security system for a project where the security is modeled based on the sql-92 GRANT/REVOKE statements. I was going through the documentation of postgresql related to ...
Potuganti Ramu
Jan 9, 2004 at 2:10 pm
Jan 9, 2004 at 5:56 pm
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 138 |
posts | 861 |
users | 134 |
website | postgresql.org... |
irc | #postgresql |
134 users for January 2004
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)