FAQ

Search Discussions

149 discussions - 827 posts

  • PG Folks, What follows are a couple of proposed TODO items to make up for some of the places our planner is weak compared to other leading databases. Particularly, I'm personally concerned that as of ...
    Josh BerkusJosh Berkus
    Dec 5, 2003 at 7:09 pm
    Nov 4, 2004 at 3:15 pm
  • I thought the default was fdatasync, but looking at the code it seems the default is open_datasync if O_DSYNC is available. I assume the logic is that we usually do only one write() before fsync(), ...
    Bruce MomjianBruce Momjian
    Dec 12, 2003 at 6:50 am
    Mar 26, 2004 at 11:22 pm
  • I am planning to solve the ancient problem of updating to a new major version without dump/reload, by means of writing a new, more bulletproof implementation of Bruce's old pg_upgrade script. Here ...
    Tom LaneTom Lane
    Dec 12, 2003 at 7:00 pm
    Dec 17, 2003 at 8:18 am
  • If people are happy with Tom's suggestion of using '*' instead of 'all' in pg_hba.conf I will prepare a patch for it. (I will also replace the ugly long IP6 localhost netmask with a CIDR mask). ...
    Andrew DunstanAndrew Dunstan
    Dec 18, 2003 at 5:15 pm
    Jan 28, 2004 at 12:31 am
  • Has this subject been discussed before? I did not find any references to it in the archives. I think that a co-bundle between an open source J2EE container like JBoss and a scalable database like ...
    Ivelin IvanovIvelin Ivanov
    Dec 9, 2003 at 3:16 pm
    Dec 26, 2003 at 9:33 pm
  • Attached is a compile failure I am seeing in CVS HEAD in bin/pg_dump. The offending lines are: gmake[3]: Leaving directory `/usr/var/local/src/gen/pgsql/CURRENT/pgsql/src/backend/parser' gcc -O2 ...
    Bruce MomjianBruce Momjian
    Dec 7, 2003 at 10:15 pm
    Dec 8, 2003 at 9:04 pm
  • I've been usin psql for quite a long time and I found it to be very comfortable. Since some web providers in my country refuse to put psql while some thing are still in psql TODO list, I'm interested ...
    Marko ZmakMarko Zmak
    Dec 17, 2003 at 8:34 pm
    Dec 22, 2003 at 10:40 pm
  • To accomodate ppls travel scheduales, we are going to move the 7.4.1 release up to Monday, *unless* there is a report before then about something that needs to be fixed first ... we know of nothing ...
    Marc G. FournierMarc G. Fournier
    Dec 5, 2003 at 4:50 pm
    Dec 7, 2003 at 9:27 pm
  • I have included the JDBC mailing list since I guess most Java developers are around here, but not necessarily on Hackers. Dave Cramer and I where discussing a few issues about the PL/Java ...
    Jan WieckJan Wieck
    Dec 31, 2003 at 9:29 pm
    Jan 5, 2004 at 9:24 pm
  • Are we going to regenerate the 7.4.1 tar ball? -- Tatsuo Ishii
    Tatsuo IshiiTatsuo Ishii
    Dec 22, 2003 at 8:58 am
    Jan 4, 2004 at 6:18 pm
  • [ Moved to hackers and win32. Discussion is writing postmaster-constant and per-backend variables to a file for exec'ed backends to read.] Sure --- I am all ears. I am looking for suggestions. I ...
    Bruce MomjianBruce Momjian
    Dec 14, 2003 at 9:57 pm
    Dec 18, 2003 at 6:10 pm
  • I'm curious if anyone has ever looked into adding OLAP functionality (per the SQL99 specs) into PostGreSQL. I don't actually own the proper SQL99 specifications, and since the newer sql2003 ones are ...
    Robert BedellRobert Bedell
    Dec 17, 2003 at 9:57 pm
    Dec 18, 2003 at 4:12 pm
  • Hi, I'm working on a new pl/java prototype that I hope will become production quality some time in the future. Before my project gets to far, I'd like to gather some input from other users. I've ...
    Thomas HallgrenThomas Hallgren
    Dec 10, 2003 at 3:30 pm
    Dec 12, 2003 at 3:07 pm
  • (I started with this addressed to the -general list, but it just doesn't seem like a general usage topic. If -hackers is the wrong place, please point me in the right direction). I've been working on ...
    Eric RidgeEric Ridge
    Dec 26, 2003 at 7:55 pm
    Jan 13, 2004 at 4:32 am
  • Our dbcommands.c has for create database: snprintf(buf, sizeof(buf), "cp -r '%s' '%s'", src_loc, target_dir); but my BSD/OS manual only documents 'cp -R' and mentions: Historic versions of the cp ...
    Bruce MomjianBruce Momjian
    Dec 11, 2003 at 11:36 pm
    Dec 29, 2003 at 5:19 pm
  • Hello, I saw another post on this list about some conflicts on building an rpm on redhat that seemed similar. I wanted to add that I was building PHP with the individual directory flags, (./configure ...
    Ray AspeitiaRay Aspeitia
    Dec 4, 2003 at 9:46 pm
    Dec 18, 2003 at 6:59 pm
  • I get the following error when vacuuming a db or inserting a big value in a column of a toastable datatype (GEOMETRY). ERROR: Index pg_toast_8443892_index is not a btree My last action has been ...
    StrkStrk
    Dec 8, 2003 at 9:39 am
    Dec 10, 2003 at 8:16 pm
  • That's irrelevant to the problem, though. Unless the ARC code uses data structures that are more amenable to localized locking than the old global buffer freelist. (Jan?) regards, tom lane
    Tom LaneTom Lane
    Dec 30, 2003 at 4:15 am
    Feb 23, 2004 at 2:33 pm
  • I just had the parallel regression tests hang up due to what appears to be a bug in the new ARC code. The CLUSTER test gets into an infinite loop trying to do "CLUSTER clstr_1;". The loop is in ...
    Tom LaneTom Lane
    Dec 23, 2003 at 6:12 pm
    Jan 7, 2004 at 7:36 pm
  • as new know plpgsql has special cache which remember too long (event non-existing tables (i mean old oid)) so i suggest to create same function only in plpgsql which would clear this cache, or sth ...
    IvanIvan
    Dec 30, 2003 at 10:34 pm
    Jan 5, 2004 at 9:14 am
  • We reject the following query: nconway=# create table abc (a int, b int, c int); CREATE TABLE nconway=# select distinct on (a) a, b, c from abc order by b, c, a; ERROR: SELECT DISTINCT ON expressions ...
    Neil ConwayNeil Conway
    Dec 12, 2003 at 11:39 pm
    Dec 15, 2003 at 2:53 pm
  • Kind people, I'm looking to the SQL WITH clause as a way to get better regex support in PostgreSQL. I've been chatting a little bit about this, and here's an idea for a behavior. Implementation ...
    David FetterDavid Fetter
    Dec 12, 2003 at 6:14 pm
    Dec 14, 2003 at 2:56 am
  • If I'm not wrong Neil Conway is working on reimplement a double linked list. Looking around I found this post of "Herb Sutter" on comp.lang.c++: ...
    Gaetano MendolaGaetano Mendola
    Dec 6, 2003 at 4:04 pm
    Dec 8, 2003 at 11:07 am
  • We (mostly Bruce, Tom, Peter, and I) have been having a discussion on the PATCHES list regarding some new functionality related to read-only GUC variables. The net result is pasted at the bottom of ...
    Joe ConwayJoe Conway
    Dec 2, 2003 at 7:50 pm
    Dec 6, 2003 at 3:32 pm
  • hi i need to connect to by my database more then 100 connections, but after ~20-30 conn, postmaster says me "Resource temporarily unavailable", what are this resource ? im using debain with kernel ...
    IvanIvan
    Dec 26, 2003 at 6:02 pm
    Dec 26, 2003 at 10:08 pm
  • Hi, while changing a column from base255 encoded text (all except null byte) to bytea, I found the following bug in Postgresql's LIKE operator with indexes (it follows a more detailed description ...
    Alvar FreudeAlvar Freude
    Dec 4, 2003 at 9:25 pm
    Dec 6, 2003 at 2:01 am
  • I'd like to request the following feature: Frequently when answering questions on IRC for people, questions fall into one of two categories, "what function can I use to manipulate datatype xyz," and ...
    Alex J. AvrietteAlex J. Avriette
    Dec 25, 2003 at 5:56 pm
    Apr 9, 2004 at 1:10 pm
  • Hi, I use PgSql for a lot of our company's need and I lack some features. I would like to know if there is plans to implement: - User permissions based on columns? (Ex: User1 has Select on Column ...
    Jean-Eric CuendetJean-Eric Cuendet
    Dec 16, 2003 at 8:42 am
    Jan 23, 2004 at 5:03 am
  • [ please respect moving of thread to pg-hackers ] Joe Conway <mail@joeconway.com writes: Reverting the change will bring back the bug for which it was created. It does seem though that we have an ...
    Tom LaneTom Lane
    Dec 27, 2003 at 7:11 pm
    Dec 28, 2003 at 8:43 pm
  • I have committed some fairly wide-ranging revisions to pg_dump to make it dump database objects in a "safe" order according to the dependency information available from pg_depend. While I know that I ...
    Tom LaneTom Lane
    Dec 6, 2003 at 5:18 am
    Dec 8, 2003 at 4:32 am
  • Wouldn't the above put a limit on a number of records one could have in table? One have to use pg_dump/pg_restore to be able to upgrade between pgSql releases and/or to backup data. If one cannot ...
    OwOw
    Dec 1, 2003 at 3:33 pm
    Dec 1, 2003 at 5:41 pm
  • Would it make sense to also have a nice little global function and/or macro available for the author of C-language recursive functions to perform a depth test before recursing? Mike Mascari ...
    Mike MascariMike Mascari
    Dec 31, 2003 at 3:14 am
    Dec 31, 2003 at 5:51 pm
  • Speaking of fund raising, SourceForge has just started a 'donations' system whereby people can donate money to projects. Maybe you want to enable it on the PostgreSQL project. We at the phpPgAdmin ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Dec 21, 2003 at 1:47 am
    Dec 22, 2003 at 5:34 pm
  • Hi, I developing a program using postgres and linux like operating system. My problem is this: I have a quite complicated view with roughly 10000 record. When I execute a simple query like this ...
    Claudia D'amatoClaudia D'amato
    Dec 16, 2003 at 9:17 am
    Dec 22, 2003 at 4:56 pm
  • Hm. I'm of the opinion that the real problem here is the code's assumption that it is reasonable to force dbname = servicename when the service file doesn't say any such thing. For all other ...
    Tom LaneTom Lane
    Dec 17, 2003 at 5:39 pm
    Dec 20, 2003 at 8:06 am
  • [Moved to hackers -- this belongs to -docs anyway, doesn't it?] BTW, what happened to the $QUOTE$ quoting idea? Was it applied, or even developed? -- Alvaro Herrera (<alvherre[a]dcc.uchile.cl ) "The ...
    Alvaro HerreraAlvaro Herrera
    Dec 16, 2003 at 7:32 pm
    Dec 17, 2003 at 6:50 pm
  • Hello, It appears that the count('x') will no longer work without a type cast. Is this on purpose? I've already modified my code to use count(*) instead, but I decided to mention it anyway. ...
    Edwin S. RamirezEdwin S. Ramirez
    Dec 2, 2003 at 6:58 pm
    Dec 15, 2003 at 10:34 pm
  • Hi, there seems to be no way of searching partial matches with tsearch. Would it be hard to implement prefix based matching, i.e. "hu" matches "human", "humanity", "humming", "huge"? With some ...
    UrmoUrmo
    Dec 9, 2003 at 12:29 pm
    Dec 10, 2003 at 10:07 am
  • Hi all, I'm still experiencing problem trying to rebuild the rpm from the file: postgresql-7.4-0.5PGDG.src.rpm what I get is: checking for library containing com_err... -lcom_err checking for library ...
    Gaetano MendolaGaetano Mendola
    Dec 2, 2003 at 1:54 am
    Dec 4, 2003 at 7:39 pm
  • People have a distressing tendency to want to shoot themselves in the foot; and the somewhat unfortunate naming of those files contributes to the problem. While it is satisfying to see stupidity ...
    Oliver ElphickOliver Elphick
    Dec 1, 2003 at 7:31 am
    Dec 1, 2003 at 5:51 pm
  • I find this a little strange: select date_part('year', '0002-01-01 BC'::date); date_part ----------- -1 It seems 1 BC and 0 are the same year. In backend/utils/adt/formatting.c: if (tmfc.bc) { if ...
    Kurt RoeckxKurt Roeckx
    Dec 18, 2003 at 1:12 pm
    Mar 30, 2004 at 4:20 pm
  • Hi Manfred, I'm using unixware 7 but couldn't compile your source with native cc, I had to compile it with gcc. here are the results: Script started on Sat Dec 27 17:50:49 2003 /tmp 17:50:50: ./a.out ...
    OhpOhp
    Dec 27, 2003 at 4:56 pm
    Jan 4, 2004 at 6:57 am
  • I have put up a list of projects being worked on and their TODO lists in hope that people will find it easier to work on them: http://momjian.postgresql.org/main/writings/pgsql/project -- Bruce ...
    Bruce MomjianBruce Momjian
    Dec 18, 2003 at 2:38 am
    Dec 22, 2003 at 5:30 pm
  • Hey Tom, With regards to our previous conversation about dropping columns now properly dropping indexes that contain predicates that reference that column, I now find it a bit disconcerting that such ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Dec 22, 2003 at 6:22 am
    Dec 22, 2003 at 4:19 pm
  • Is there any good reason for this restriction? regression=# begin; BEGIN regression=# declare c cursor for select * from tenk1 for update; ERROR: DECLARE CURSOR ... FOR UPDATE is not supported ...
    Tom LaneTom Lane
    Dec 18, 2003 at 3:20 pm
    Dec 20, 2003 at 6:49 pm
  • Folks, I brought up this issue a couple of weeks ago on the Performance list. Since then, I've gotten e-mail confirmation from a few other users seeing this problem. Here's the shape of the problem, ...
    Josh BerkusJosh Berkus
    Dec 19, 2003 at 6:39 pm
    Dec 20, 2003 at 6:20 pm
  • test_thread.pgc:51: undefined reference to `pthread_create' undefined reference to `pthread_join' Dave
    Dave CramerDave Cramer
    Dec 18, 2003 at 12:08 pm
    Dec 19, 2003 at 11:28 pm
  • Hi all, I've upgraded my system from 7.3.4 to 7.3.5 yesterday and have already experienced to crash during vacuum full. I have'nt recompiled with debug yet but it's a sigsegv in function repair_frag ...
    OhpOhp
    Dec 8, 2003 at 6:05 pm
    Dec 10, 2003 at 1:33 pm
  • I have updated the release notes for 7.4.1 and HISTORY as of Dec 14. I will make further adjustments before the 7.4.1 release. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | ...
    Bruce MomjianBruce Momjian
    Dec 15, 2003 at 10:29 pm
    Dec 17, 2003 at 7:07 am
  • I'm trying to change all the walkers and mutators to have a more strict prototype. I had to do this with lots of casts. I don't really like the idea of having all those generic pointer types (Node * ...
    Kurt RoeckxKurt Roeckx
    Dec 12, 2003 at 11:43 pm
    Dec 14, 2003 at 11:45 pm
Group Navigation
period‹ prev | Dec 2003 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions149
posts827
users143
websitepostgresql.org...
irc#postgresql

143 users for December 2003

Tom Lane: 158 posts Bruce Momjian: 83 posts Andrew Dunstan: 53 posts Jan Wieck: 22 posts Peter Eisentraut: 20 posts Christopher Kings-Lynne: 19 posts Joe Conway: 19 posts Marc G. Fournier: 19 posts Alvaro Herrera Munoz: 16 posts David Fetter: 15 posts Greg Stark: 14 posts Hannu Krosing: 14 posts Ivan: 12 posts Kurt Roeckx: 12 posts Joshua D. Drake: 10 posts Gaetano Mendola: 9 posts Neil Conway: 8 posts Robert Bedell: 8 posts Ohp: 7 posts Bruno Wolff III: 7 posts
show more
Archives