FAQ

PostgreSQL > pgsql-hackers > November 2005

Search Discussions

185 discussions - 1,568 posts

  • 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 EisentrautPeter 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 RiggsSimon 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 LaneTom 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 RiggsSimon 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 CreagerRobert 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 ZhouQingqing 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 TaylorRod 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 LeguillierEric 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 CasanovaJaime 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 RiggsSimon 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 HerreraAlvaro 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 ZhouQingqing 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 DunstanAndrew 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-LynneChristopher 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 IppolitoBob 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 PaesoldMichael 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 LaneTom 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 LaneTom 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 HaganderMagnus 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 LaneTom 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 BjorklundDennis 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 MichelYann 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 RiggsSimon 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 OosterhoutMartijn 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 RiggsSimon 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 WildenhainTino 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 HansenJohn 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-LynneChristopher 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 JaskiewiczGrzegorz 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 MoncureMerlin 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 CreagerRobert 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 PrietoCristian 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 LaneTom 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 TollefsenIdar 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 RobinsonJames 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 LELARGEGuillaume 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 EngeneMarcus 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. NasbyJim 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 LinnakangasHeikki 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-LynneChristopher 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 JaskiewiczGrzegorz 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 EisentrautPeter 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 HaganderMagnus 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 OlssonFredrik 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 YarraPhilip 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 GlaesemannMichael 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 FuchsHarald 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 MichelYann 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 RasmussenKaare 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 CadutoTony Caduto
    Nov 4, 2005 at 11:05 pm
    Nov 7, 2005 at 9:09 am
Nov 2005
1234
Group Navigation
period‹ prev | Nov 2005 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions185
posts1,568
users174
websitepostgresql.org...
irc#postgresql

174 users for November 2005

Tom Lane: 294 posts Martijn van Oosterhout: 90 posts Bruce Momjian: 77 posts Jim C. Nasby: 73 posts Andrew Dunstan: 69 posts Simon Riggs: 61 posts Christopher Kings-Lynne: 49 posts Alvaro Herrera: 41 posts Peter Eisentraut: 33 posts Magnus Hagander: 29 posts Qingqing Zhou: 26 posts Michael Fuhr: 23 posts Jaime Casanova: 21 posts Kevin Grittner: 20 posts Michael Glaesemann: 19 posts Greg Stark: 18 posts Gavin Sherry: 16 posts Tino Wildenhain: 16 posts Mark: 15 posts Marc G. Fournier: 14 posts
show more
Archives