FAQ

Search Discussions

190 discussions - 1,232 posts

  • I've been thinking about making this post for a while ... with 6.5 almost out the door, I guess now is a good time. I don't know what people have had in mind for 6.6, but I propose that there ought ...
    Tom LaneTom Lane
    Jun 3, 1999 at 5:32 pm
    Jul 8, 1999 at 12:10 am
  • Hello, Sorry that I picked this too late in the release cycle, but other work prevented my earlier involvement in the testing. There are at least two serious problems that I discovered so far with ...
    Daniel KalchevDaniel Kalchev
    Jun 9, 1999 at 8:04 am
    Jun 17, 1999 at 6:09 am
  • I have updated the TODO list, rearranging it. Here is the top of the "Enhancements" list: * Add referential integrity * Add OUTER joins, left and right(Thomas) * Allow long tuples by chaining or ...
    Bruce MomjianBruce Momjian
    Jun 7, 1999 at 2:43 am
    Jun 9, 1999 at 2:04 am
  • I've frozen the docs sources for the Programmer's Guide, and have generated the hardcopy. I'm planning on generating the Tutorial, INSTALL, and HISTORY tonight, and the User's Guide tomorrow. Bruce, ...
    Thomas LockhartThomas Lockhart
    Jun 3, 1999 at 2:05 am
    Jun 4, 1999 at 3:49 am
  • Config.h has this. Does this need to be updated because we can't vacuum multi-segment relations? I have changed it to 7F000000: /* * RELSEG_SIZE is the maximum number of blocks allowed in one disk ...
    Bruce MomjianBruce Momjian
    Jun 17, 1999 at 2:30 pm
    Jun 20, 1999 at 3:51 pm
  • Hi, I always execute 'regression test' and 'regression bigtest' when PostgreSQL was enhanced. However,'regression bigtest' needs the very long processing time in PostgreSQL-6.5. In my computer, it is ...
    SAKAIDASAKAIDA
    Jun 24, 1999 at 11:20 am
    Jul 3, 1999 at 3:31 pm
  • Just wondering, when I do a COPY in the latest CVS into a file, it makes the file both where I ask it to AND in /home/postgres/data/base/<filename . I've tried removing both files and doing it again, ...
    Chris BitmeadChris Bitmead
    Jun 13, 1999 at 5:27 pm
    Jul 10, 1999 at 2:49 pm
  • OK, so I'm working on updating the RH Linux rpm of Postgres to our new release. And so I'll have to figure out how to *really* install all of the Postgres components to make this work. Anyway, I've ...
    Thomas LockhartThomas Lockhart
    Jun 21, 1999 at 6:07 am
    Jun 30, 1999 at 5:39 pm
  • It'd probably be worthwhile to move NAMEDATALEN to config.h and make the other two symbols be computed off NAMEDATALEN. Any objections if I sneak that change into 6.5, or is it too close to being a ...
    Tom LaneTom Lane
    Jun 1, 1999 at 2:08 pm
    Jun 4, 1999 at 9:47 pm
  • Can someone explain why our money type in 6.5 requires quotes, and why there is no int() function for it? --------------------------------------------------------------------------- test= create ...
    Bruce MomjianBruce Momjian
    Jun 22, 1999 at 5:40 pm
    Jun 24, 1999 at 3:37 pm
  • has something changed with r-tree indexes in 6.5? i had a database in 6.4.2 that had a box type and would do queries on it with the box overlap operator ("&&"). the field i'm querying is indexed with ...
    Jeff HoffmannJeff Hoffmann
    Jun 18, 1999 at 7:50 pm
    Jun 22, 1999 at 3:18 pm
  • I have just talked to Thomas Lockhart, and he will need a few days to finish up the docs. He has said he needs some time once all the changes are made. There are over 800 pages of documenation, so it ...
    Bruce MomjianBruce Momjian
    Jun 9, 1999 at 3:31 am
    Jun 11, 1999 at 12:38 am
  • Folks, Not sure if this is the right place to request this, but here are some things I, as a satisfied user of PostgreSQL, would like to see done (and I'd be glad to help where I can). All of these ...
    Fred Wilson HorchFred Wilson Horch
    Jun 29, 1999 at 6:13 pm
    Jun 30, 1999 at 1:42 pm
  • I've mentioned in the past that the fsynch following every select, even when no data is modified, is a killer for high-volume web sites that make many short, read-only hits on the database (for page ...
    Don BaccusDon Baccus
    Jun 22, 1999 at 10:11 pm
    Jun 25, 1999 at 1:01 pm
  • % psql test1 Welcome to the POSTGRESQL interactive sql monitor: Please read the file COPYRIGHT for copyright terms of POSTGRESQL [PostgreSQL 6.5.0 on i386-unknown-freebsd3.2, compiled by gcc 2.7.2.1] ...
    Gene SokolovGene Sokolov
    Jun 16, 1999 at 6:42 am
    Jun 17, 1999 at 10:47 am
  • While playing with --enable-locale and the like expressions I came across this phenomenon ('somestring' is in cyrillic - last 64 codes from 0xa0 to 0xff) SELECT key FROM t WHERE key ~* 'somestring' ...
    Daniel KalchevDaniel Kalchev
    Jun 10, 1999 at 2:17 pm
    Jun 14, 1999 at 7:42 am
  • 15

    "DML"

    There are a couple of places in the docs where the term "DML" is used, but it is not defined anywhere. What exactly does it stand for and how would you define it? - Thomas -- Thomas Lockhart ...
    Thomas LockhartThomas Lockhart
    Jun 11, 1999 at 3:36 pm
    Jun 12, 1999 at 7:34 pm
  • I am just creating this now...this is to be considered the first *releaes* candidate for v6.5 ... I expect there to be *no more* commits to the source tree until after a formal release is done... ...
    The Hermit HackerThe Hermit Hacker
    Jun 7, 1999 at 3:40 am
    Jun 8, 1999 at 10:12 am
  • grant/revoke does not work in NetBSD/m68k. This is due to the wrong assumption that sizeof(AclItem) is equal to 8 in all platforms. I am going to fix this by replacing all occurrence of ...
    Tatsuo IshiiTatsuo Ishii
    Jun 29, 1999 at 3:02 am
    Jul 26, 1999 at 11:39 am
  • I am using the Sun Workshop C 5.0, noticed that I was getting the following errors: "pgconnection.h", line 65: Error: string is not defined. "pgconnection.cc", line 134: Error: string is not defined. ...
    Brian P MillettBrian P Millett
    Jun 24, 1999 at 5:04 pm
    Jul 26, 1999 at 1:46 pm
  • We are two weeks after the 6.5 release, and the anticipated problems/patches/porting issues never really materialized. I would suspect that fewer people are using PostgreSQL, but I know that is not ...
    Bruce MomjianBruce Momjian
    Jun 29, 1999 at 2:13 am
    Jul 1, 1999 at 3:35 am
  • Does anybody use postgres on this animal? UNIX_SV its-sp 4.2MP 2.1.2 i386 x86at SCO UNIX_SVR4 UX:cc: INFO: Optimizing C Compilation System (CCS) 3.0 09/26/96 (u211mr1) Postgres 6.5 current CVS I have ...
    Dmitry SamersoffDmitry Samersoff
    Jun 11, 1999 at 12:55 pm
    Jun 22, 1999 at 3:54 am
  • I posted this to Usenet today in a discussion about GPL vs. BSDL. I hope this doesn't start a huge discussion, but I thought the issues were significant enough to address to this group. ...
    Bruce MomjianBruce Momjian
    Jun 20, 1999 at 5:15 am
    Jun 21, 1999 at 8:15 pm
  • I have Web site where I use persistent connection between httpd (Apache) and database (postgres,6.5). I noticed strange results I got after reloading page with results from query when I destroydb , ...
    Oleg BartunovOleg Bartunov
    Jun 12, 1999 at 6:57 pm
    Nov 30, 1999 at 2:11 am
  • Hi. I've been mulling around a lot with this idea. I've looked around a bit for info on being able to do hot backups on a running database, but there isn't a lot of info available. The problem with ...
    Michael RichardsMichael Richards
    Jun 29, 1999 at 10:53 pm
    Jun 30, 1999 at 1:38 pm
  • it gets build I can initdb I can createdb, but not destroydb a lot of "typidTypeRelid"errors I'm in a hurry right now, should I tell anyone else? post bug report?
    GravityGravity
    Jun 17, 1999 at 9:30 am
    Jun 18, 1999 at 2:09 am
  • This patch should enable 6.5 to build on Motorola 68000 architecture. It comes from Roman Hodek <Roman.Hodek@informatik.uni-erlangen.de .
    Oliver ElphickOliver Elphick
    Jun 10, 1999 at 3:29 pm
    Jun 14, 1999 at 1:03 am
  • Here is a parody of the post-6.5 PostgreSQL history. I am interested in additional ideas and comments. Not sure if I am going to publish this or put it on the web page yet. -- Bruce Momjian | ...
    Bruce MomjianBruce Momjian
    Jun 5, 1999 at 2:12 am
    Jun 8, 1999 at 8:00 am
  • This happens, when I want do this: (4) $ sql Welcome to the POSTGRESQL interactive sql monitor: Please read the file COPYRIGHT for copyright terms of POSTGRESQL [PostgreSQL 6.5.0 on ...
    David SauerDavid Sauer
    Jun 2, 1999 at 9:01 pm
    Jul 8, 1999 at 12:05 am
  • Hi, Just thought I'd drop an email again - I was the one having neverending trouble with 6.4.2 jamming with backends waiting, and other types of problems. Although I'm still using 6.4.2, I hope this ...
    Wayne PiekarskiWayne Piekarski
    Jun 19, 1999 at 7:39 am
    Jul 3, 1999 at 7:53 am
  • subscribe
    Guillaume LairloupGuillaume Lairloup
    Jun 22, 1999 at 1:14 pm
    Jun 30, 1999 at 9:34 am
  • Hi, seems something wrong with rsync mirroring. I use rsync -avz --delete hub.org::postgresql-www /d4/Web/mirrors/pgsql/ and it does well but no images from /images directory are copied. So my mirror ...
    Oleg BartunovOleg Bartunov
    Jun 17, 1999 at 7:39 am
    Jun 17, 1999 at 4:50 pm
  • I just did a CVS update on the current version of Postgres. I loaded in my database, and then I tried to dump the database. I got this error.... getTypes(): SELECT failed. Explanation from backend: ...
    Chris BitmeadChris Bitmead
    Jun 1, 1999 at 11:22 am
    Jun 1, 1999 at 5:37 pm
  • To have them I need to add tuple id (6 bytes) to heap tuple header. Are there objections? Though it's not good to increase tuple header size, subj is, imho, very nice feature... Implementation is , ...
    Vadim MikheevVadim Mikheev
    Jun 16, 1999 at 1:13 pm
    Jun 20, 1999 at 1:51 am
  • And over 500 copies downloaded from the main site so far... Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ hub.org primary: scrappy@hub.org secondary: ...
    The Hermit HackerThe Hermit Hacker
    Jun 15, 1999 at 12:45 pm
    Jun 15, 1999 at 9:53 pm
  • What is the release date now? Still tomorrow? -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can ...
    Bruce MomjianBruce Momjian
    Jun 8, 1999 at 8:18 pm
    Jun 9, 1999 at 1:33 am
  • Hi World! Does backend сreates pid file? Postgres 6.5 backend (current CVS) stop answering query every 300 000 cursor allocation so I wish to restart it every 100 000 is there a way to do it simple ...
    Dmitry SamersoffDmitry Samersoff
    Jun 2, 1999 at 2:56 pm
    Jun 8, 1999 at 2:14 pm
  • Which list are the cvs changes posted to? I see that Tom Lane made changes to just about all of the libpq++ source files but I have no idea what was done. Vince. -- ...
    Vince VielhaberVince Vielhaber
    Jun 1, 1999 at 12:19 am
    Jun 1, 1999 at 4:26 pm
  • Two small patches: 1) make default NBuffers = DEF_MAXBACKENDS*2 as required by check in PostmasterMain(). 2) check for QueryCancel in the copy command. Maybe we should do the same in vacuum command ...
    Massimo Dal ZottoMassimo Dal Zotto
    Jun 12, 1999 at 6:46 pm
    Nov 30, 1999 at 2:14 am
  • I have been looking at the planner's handling of subplans, and I see something that I think is wrong, but I'm not quite certain. In _make_subplan() in backend/optimizer/plan/subselect.c, there is the ...
    Tom LaneTom Lane
    Jun 16, 1999 at 11:03 pm
    Jun 18, 1999 at 4:48 pm
  • The regression tests no longer seem to be using the "alternative" expected files should they exist. I have run out of time looking for the cause, but the story so far is in going from version ...
    Patrick WelchePatrick Welche
    Jun 14, 1999 at 11:48 am
    Jun 14, 1999 at 8:15 pm
  • I have been puzzling out the coding in _bt_binsrch() in backend/access/nbtree/nbtsearch.c, with an eye to speeding it up for the many-equal-keys case. I have finally worked out exactly what it's ...
    Tom LaneTom Lane
    Jun 6, 1999 at 12:41 am
    Nov 30, 1999 at 2:13 am
  • After the discussion about implementing a flag that would selectively disable fsynch on the pg_log file, I visited xact.c and tried a little test. The code in RecordTransactionCommit looks ...
    Don BaccusDon Baccus
    Jun 24, 1999 at 6:59 pm
    Jun 28, 1999 at 2:03 am
  • Is anyone else having any problems with the Perl Interface wrt Large Objects under 6.5? I compiled and installed 6.5 on an Intel/Linux/RedHat 6.0 machine that had previously had 6.4.2 and imported ...
    Kristofer MunnKristofer Munn
    Jun 23, 1999 at 10:12 pm
    Jun 25, 1999 at 3:46 am
  • Hi alls I'm working on a port of postgres on BeOS (www.be.com). BeOS is not a real UNIX, but it provide a subset of the posix API. At this stage I've a working version ofit. But since 6.4.2, I've a ...
    Cyril VELTERCyril VELTER
    Jun 15, 1999 at 9:47 pm
    Jun 19, 1999 at 6:49 pm
  • New item for TODO list: * SELECT aliname FROM pg_class aliname generates strange error test= SELECT aliname FROM pg_class aliname; NOTICE: unknown node tag 704 in rangeTableEntry_used() NOTICE: Node ...
    Bruce MomjianBruce Momjian
    Jun 17, 1999 at 3:42 pm
    Jun 18, 1999 at 2:46 pm
  • I see there's still the command: SET QUERY_LIMIT (even in the docs) but it doesn't work. prova= select * from test limit 1; num|flt8 ----+---- 1.00| 1 (1 row) prova= prova= set query_limit = '1'; SET ...
    José SoaresJosé Soares
    Jun 16, 1999 at 3:30 pm
    Jun 17, 1999 at 1:50 pm
  • There seems to be a problem with MakeIndexable(), though I haven't confirmed that the problem lies there: postgres= select * from t1 where i like '2'; ERROR: pg_atoi: error in "2ÿ": can't parse "ÿ" ...
    Thomas LockhartThomas Lockhart
    Jun 8, 1999 at 1:51 pm
    Jun 9, 1999 at 1:56 am
  • Installing postgres in 20th time, I become ready to send some wishes. 1. My standard way to install pgsql: make su useradd postgres **** mkdir ~postgres make install chown -R postgres ~postgres Is it ...
    Dmitry SamersoffDmitry Samersoff
    Jun 17, 1999 at 4:03 pm
    Jun 18, 1999 at 4:49 pm
  • I am having trouble with PQclear causing a segmentation fault, and I don't really know where to look. I have 3 identical tables (only 2 come into play) all of the form ...
    Patrick WelchePatrick Welche
    Jun 15, 1999 at 11:55 am
    Jun 18, 1999 at 2:40 pm
Group Navigation
period‹ prev | Jun 1999 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions190
posts1,232
users127
websitepostgresql.org...
irc#postgresql

127 users for June 1999

Bruce Momjian: 222 posts Tom Lane: 164 posts Vadim Mikheev: 96 posts Thomas Lockhart: 87 posts The Hermit Hacker: 70 posts Jan Wieck: 50 posts Tatsuo Ishii: 36 posts Don Baccus: 35 posts Vince Vielhaber: 29 posts Dmitry Samersoff: 20 posts Hiroshi Inoue: 20 posts ZEUGSWETTER Andreas IZ5: 19 posts "D'Arcy" "J.M." Cain: 18 posts Chris Bitmead: 16 posts Oleg Bartunov: 16 posts Hannu Krosing: 15 posts Kaare Rasmussen: 14 posts Daniel Kalchev: 13 posts Oliver Elphick: 12 posts Massimo Dal Zotto: 11 posts
show more
Archives