Search Discussions
-
It seems to me that it has always been implicitly assumed around here that the MERGE command would be a substitute for a MySQL-like REPLACE functionality. After rereading the spec it seems that this ...
Peter Eisentraut
Nov 11, 2005 at 8:01 pm
Nov 23, 2005 at 7:24 pm -
Currently, the overhead of NUMERIC datatype is 8 bytes. Each value is stored on disk as typedef struct NumericData { int32 varlen; /* Variable size (std varlena header) */ int16 n_weight; /* Weight ...
Simon Riggs
Nov 1, 2005 at 9:24 pm
Nov 9, 2005 at 10:42 pm -
It's been about a month since 8.1.0 was released, and we've found about the usual number of bugs for a new release, so it seems like it's time for 8.1.1. The core committee has tentatively agreed to ...
Tom Lane
Nov 30, 2005 at 3:56 pm
Dec 11, 2005 at 5:30 am -
One of the major complaints is always "Select count(*) is slow". I have a somewhat broadbrush idea as to how we might do this (for larger tables). Previously, we've said that maintaining a running ...
Simon Riggs
Nov 17, 2005 at 7:28 pm
Dec 1, 2005 at 10:33 pm -
Hey all, I was doing a test run of a live dump from 8.0.2 to 8.1.0, and 8.1.0 took a segmentation violation 1 hour into the operation. My plan is to re-do the dump/restore, and if it fails again, to ...
Robert Creager
Nov 6, 2005 at 11:34 pm
Nov 13, 2005 at 9:50 pm -
I am considering add an "ice-broker scan thread" to accelerate PostgreSQL sequential scan IO speed. The basic idea of this thread is just like the "read-ahead" method, but the difference is this one ...
Qingqing Zhou
Nov 29, 2005 at 3:22 am
Nov 30, 2005 at 2:38 pm -
As you can see, we have duplicates within the table (heap) of a primary key value. The index itself only references one of these tuples. Nearly all data inserted into this table is wrapped in a ...
Rod Taylor
Nov 9, 2005 at 6:38 pm
Jan 11, 2006 at 2:58 pm -
Hi everybody, My questions may seem kind of odd. I would like to run PostGreSQL on a DVD (database on the DVD and if possible executable on DVD too) on windows. I want no installation at all, so I ...
Eric Leguillier
Nov 14, 2005 at 11:30 am
Nov 16, 2005 at 1:48 am -
Hi, there is someone working in add the MERGE statement? i don't find much about what a good implementation of merge must have... i think what it needs to do is something like: - try to lock the rows ...
Jaime Casanova
Nov 11, 2005 at 2:03 pm
Nov 25, 2005 at 2:55 pm -
Since we just discussed using a multi-row per buffer lock technique with Seq Scans, it seems appropriate to discuss a similar technique with COPY FROM that I had been mulling over. COPY FROM can read ...
Simon Riggs
Nov 27, 2005 at 7:44 pm
Dec 2, 2005 at 9:40 am -
Hackers, Is anybody opposed to having PL/php in pg_pltemplate in the 8.1 branch? If not, I will add it on monday. (I plan to add it to 8.2 at the same time.) -- Alvaro Herrera ...
Alvaro Herrera
Nov 23, 2005 at 1:28 pm
Nov 30, 2005 at 3:42 pm -
I did some gprof on a simple "SELECT COUNT(*) FROM test" query on cvs tip. Linux josh.db 2.4.29-1 #2 Tue Jan 25 17:03:33 EST 2005 i686 unknown gcc: 2.96 gprof: 2.13.90.0.2 ./configure ...
Qingqing Zhou
Nov 24, 2005 at 6:25 pm
Nov 29, 2005 at 2:28 pm -
I am looking at creating a few generic functions builtin for the enum stuff. These would be tied to each enum type as it is created. However, they should not really appear in pg_proc initially, as ...
Andrew Dunstan
Nov 10, 2005 at 5:03 pm
Dec 9, 2005 at 1:26 am -
What's going on here? Some sort of integer wraparound? WORKS ===== mysql=# select interval '2378 seconds'; interval ---------- 00:39:38 (1 row) mysql=# mysql=# select 2378 * interval '1 second'; ...
Christopher Kings-Lynne
Nov 27, 2005 at 3:15 pm
Dec 1, 2005 at 8:45 pm -
I've been running 8.1.0 on a test box since the FreeBSD port has been available, and it appears that the catalog has become corrupted. There's plenty of free space on all volumes, so it hasn't run ...
Bob Ippolito
Nov 21, 2005 at 8:29 pm
Nov 22, 2005 at 5:05 pm -
Using both PostgreSQL 8.1.0 and CVS current of Nov 7, 9:00 am CET I get a regression failure in the interval tests. I am no export for the interval type, but the expected "9 days 28 hours" seem ...
Michael Paesold
Nov 7, 2005 at 8:23 am
Aug 11, 2006 at 5:07 am -
I'm starting to think about what it'll take to allow arrays to contain elements that are NULL. The behavioral semantics seem pretty straightforward, but there are a couple of areas that need ...
Tom Lane
Nov 8, 2005 at 12:09 am
Nov 14, 2005 at 10:09 am -
While hacking on the nulls-in-arrays addition, I noticed a couple of behaviors that seem a bit bogus to me. First, array slicing returns NULL any time the requested slice falls completely outside the ...
Tom Lane
Nov 16, 2005 at 5:48 pm
Nov 19, 2005 at 5:35 am -
[copying this one over to hackers] Very interesting. As this seems to be a resource error, a couple of questions. Sorry if you've already answered some of them, couldn't find it in the archives. 1) ...
Magnus Hagander
Nov 17, 2005 at 9:29 am
Dec 1, 2005 at 8:26 pm -
Can you post a diff showing what would change exactly? I'd like to hold off for at least a little bit on reindenting HEAD, because I've got a fair size set of changes for nulls-in-arrays that I'm ...
Tom Lane
Nov 15, 2005 at 1:01 am
Nov 15, 2005 at 4:58 pm -
I've noticed that in 8.1 the output of SHOW ALL includes a description column. This makes the output very wide which makes it hard to use from psql (I need to make the terminal window 164 characters ...
Dennis Bjorklund
Nov 22, 2005 at 10:56 am
Dec 1, 2005 at 9:36 pm -
Hi, I'm using PG_DUMP for backing up a postgres 7.4 database. As I have seen, the pg_dump aquires a table lock while dump the table's content. What will happen, if I have a basic table and several ...
Yann Michel
Nov 13, 2005 at 2:22 am
Nov 16, 2005 at 10:48 pm -
I was unaware of this. I've looked at the release notes and searched the archives, but this doesn't seem to be mentioned by CVE number. (The vulnerabilities and their resolutions are described, just ...
Simon Riggs
Nov 24, 2005 at 10:13 am
Nov 25, 2005 at 9:10 pm -
I've been thinking about this and wondered if this is a way to get it done without too much work. 1. Create an "anyrecord" type to which any record type can be cast. It's essentially a heaptuple with ...
Martijn van Oosterhout
Nov 19, 2005 at 3:13 pm
Nov 23, 2005 at 8:22 pm -
If you've ever loaded 100 million rows, you'll know just how annoying it is to find that you have a duplicate row somewhere in there. Experience shows that there is always one, whatever oath the ...
Simon Riggs
Nov 21, 2005 at 10:41 pm
Nov 23, 2005 at 4:19 am -
New in 8.1 it seems functions marked STABLE are not allowed to have any INSERT statement in them. However in this particular case, the insert does not violate the rule: "STABLE indicates that within ...
Tino Wildenhain
Nov 14, 2005 at 3:03 pm
Nov 15, 2005 at 4:41 pm -
On a fresh installation of postgrsql 8.1 if you drop the 'postgres' database, psql, createdb, etc. no longer works. psql -l; ignores -dtemplate1, and createdb doesn't have such an option. Maybe it ...
John Hansen
Nov 17, 2005 at 1:01 pm
Dec 2, 2005 at 10:45 pm -
Hi guys, Does anyone know how I'd go about implementing the following MySQL operator in PostgreSQL? --- NULL-safe equal. This operator performs an equality comparison like the = operator, but returns ...
Christopher Kings-Lynne
Nov 25, 2005 at 2:16 am
Nov 25, 2005 at 3:25 pm -
Hi folks I have all operators required for b-tree, gist up here, and gist index defined. But still "order by custom_type" won't work. I have kind of wild card masks in my type definition, so b-tree ...
Grzegorz Jaskiewicz
Nov 18, 2005 at 6:15 pm
Nov 22, 2005 at 4:23 pm -
I have an interesting situation...am staging a mock upgrade from 8.0 to 8.1 on a bzip compressed backup image from one of our production servers. The dump image is big (270 mb compressed) and so is ...
Merlin Moncure
Nov 10, 2005 at 8:35 pm
Nov 17, 2005 at 4:04 pm -
Hey all, While trying to get a reproducible test case for my CS storm problem (see http://archives.postgresql.org/pgsql-hackers/2005-10/msg00585.php), I upgraded to 8.1RC1 and encountered the ...
Robert Creager
Nov 2, 2005 at 7:27 pm
Nov 8, 2005 at 9:45 pm -
Hello, I'm using PostgreSQL 8.0.4 in Fedora Core 3, right now I'm learning a little about the postgresql internals and the way some kind of SPs could be written in c language; I found something ...
Cristian Prieto
Nov 4, 2005 at 4:19 pm
Nov 6, 2005 at 7:28 pm -
Yipes. So we really want to do that only once. AFAICS it is appropriate to move the sigsetjmp and setup_cancel_handler calls in front of the per-line loop inside MainLoop --- can anyone see a reason ...
Tom Lane
Nov 4, 2005 at 6:01 pm
Nov 6, 2005 at 5:10 pm -
Hello, uname -a: Darwin fulcrum.local 8.3.0 Darwin Kernel Version 8.3.0: Mon Oct 3 20:04:04 PDT 2005; root:xnu-792.6.22.obj~2/RELEASE_PPC Power Macintosh powerpc gcc --version: ...
Idar Tollefsen
Nov 2, 2005 at 2:15 pm
Nov 2, 2005 at 11:34 pm -
G'day folks. We have a production database running 8.0.3 which gets fully pg_dump'd and vacuum analyze'd hourly by cron. Something strange happened to us on the 5AM Friday Nov. 25'th cron run -- the: ...
James Robinson
Nov 28, 2005 at 4:04 pm
Nov 28, 2005 at 10:03 pm -
Hi, I've installed a 8.1.0 PostgreSQL server on a SCO OpenServer 5.0.6. It seemed to work well with psql and such tools. I tried to connect to this server with pgAdmin3 and a query failed. I tried to ...
Guillaume LELARGE
Nov 10, 2005 at 10:53 pm
Nov 23, 2005 at 7:37 am -
Hi list. I've mostly used Oracle in the past, but for a web-project I took the opportunity to try Postgres. When a select is done in Oracle, it first checks if the select is cached (ie parsed tree, ...
Marcus Engene
Nov 15, 2005 at 6:34 pm
Nov 22, 2005 at 8:44 pm -
So the recent thread about getting 7.4 compiling on OS X inspired me. But what I can't understand is that I've yanked --with-ssl, but it's still looking for libssl: ...
Jim C. Nasby
Nov 16, 2005 at 3:40 am
Nov 21, 2005 at 10:50 pm -
Hi, I've been thinking about running postgres from read-only media. It's handy for creating demo CDs etc. I hacked together a patch that allows you to run Postgres without write permissions to the ...
Heikki Linnakangas
Nov 20, 2005 at 8:43 pm
Nov 21, 2005 at 9:52 pm -
11
BIN()
Hi guys, How would I go about implementing MySQL's BIN() function easily in PL/SQL. mysql SELECT BIN(12); - '1100' Basically it converts a bigint to a string containing 1's and 0's. I've tried ...Christopher Kings-Lynne
Nov 30, 2005 at 2:13 am
Nov 30, 2005 at 7:16 am -
Hi folks We're developing here gist index (which works finally, and I remember about writing some docs about it). I have few fprintf(stderr,""") in function that converts internal rep. into string. I ...
Grzegorz Jaskiewicz
Nov 16, 2005 at 12:18 pm
Nov 16, 2005 at 4:38 pm -
Someone wanted to rename a database while someone else was running a rather long pg_dump, so the rename had to wait, and everyone else had to wait for the rename because no new connections would be ...
Peter Eisentraut
Nov 3, 2005 at 5:12 pm
Nov 9, 2005 at 11:02 am -
Windows certainly supports large files. I don't see why we wouldn't pick this up in autoconf, perhaps the mingw libraries don't? Definitly worth investigating, no time for 8.1, so putting it on TODO ...
Magnus Hagander
Nov 2, 2005 at 2:37 pm
Dec 4, 2005 at 9:28 pm -
Hi. In the course of porting a database from Microsoft SQL Server to PostgreSQL I have rewritten a few of the date and string functions in pl/pgSQL. Started with just datepart, datediff and soundex, ...
Fredrik Olsson
Nov 23, 2005 at 2:52 pm
Nov 24, 2005 at 3:39 pm -
I assume CREATE TABLESPACE refuses to use a non-empty directory because of the risk of trashing existing files. Makes sense, but consider the following: # mkfs -t ext2 /dev/sdc1 # mount -t ext2 ...
Philip Yarra
Nov 17, 2005 at 4:14 am
Nov 23, 2005 at 4:16 am -
The 7.4 tree has never built cleanly on Wallaroo, a Mac OS X 10.3.8 member of the build farm. Currently it's failing in the make contrib stage. I'd like to get it to build properly, but I don't know ...
Michael Glaesemann
Nov 15, 2005 at 12:24 am
Nov 16, 2005 at 9:48 am -
Consider the following: CREATE TEMP TABLE tbl ( id SERIAL NOT NULL, PRIMARY KEY (id) ); COPY tbl (id) FROM stdin; 1 2 3 4 \. SELECT substring ('1234567890' FOR (SELECT count (*) FROM tbl)::int); This ...
Harald Fuchs
Nov 11, 2005 at 1:49 pm
Nov 13, 2005 at 7:13 pm -
Hi, I'm just a little bit confused because I expected postgresql to be able t "connect by prior" but as I have seen it is not. :-( Are there any plans to support this in the main distribution? If ...
Yann Michel
Nov 12, 2005 at 9:08 am
Nov 15, 2005 at 5:25 pm -
I've been going through the thread that Andrew Dunstan started with his enumkit. Maybe I missed it, but I didn't see any conclusion. If I want to design an Open Source system now that may be in beta ...
Kaare Rasmussen
Nov 8, 2005 at 7:41 am
Nov 9, 2005 at 1:29 am -
Hi, I have been playing around with pg_reload_conf() and the pg_settings view. I understand that the pg_settings view, if updated, applies to the current session only. However I was under the ...
Tony Caduto
Nov 4, 2005 at 11:05 pm
Nov 7, 2005 at 9:09 am
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 185 |
posts | 1,568 |
users | 174 |
website | postgresql.org... |
irc | #postgresql |
174 users for November 2005
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)