Search Discussions

157 discussions - 943 posts

  • Thanks. I have updated the release.sgml and the HISTORY file. I should have posted the list of changes. Here it is. Gee, it is quite a lot. Thomas, any way to get the dates from the release.sgml into ...
    Bruce MomjianBruce Momjian
    Sep 13, 1999 at 5:12 pm
    Sep 21, 1999 at 7:36 pm
  • Pursuant to a phone conversation I had with Bruce, I added code this morning to reject DROP TABLE or DROP INDEX inside a transaction block; that is, you can't do BEGIN; DROP TABLE foo; END anymore. ...
    Tom LaneTom Lane
    Sep 6, 1999 at 2:12 am
    Sep 29, 1999 at 1:34 pm
  • Can I get comments on this? Is a bit type something we want installed by default, or in contrib? Seems to me it should be in the main tree. [application/x-gzip is not supported, skipping...] -- Bruce ...
    Bruce MomjianBruce Momjian
    Sep 21, 1999 at 9:00 pm
    Nov 30, 1999 at 7:05 am
  • I have finished applying Mike Ansley's changes for long queries, along with a bunch of my own. The current status is: * You can send a query string of indefinite length to the backend. (This is ...
    Tom LaneTom Lane
    Sep 11, 1999 at 10:50 pm
    Sep 28, 1999 at 4:23 am
  • I know Tom Lane has done some work on pg_upgrade -- the last message was on 8/2/99, and left the thread hanging. What is the current status of pg_upgrade in 6.5.x?? I ask because the presence of a ...
    Lamar OwenLamar Owen
    Sep 8, 1999 at 2:41 pm
    Sep 28, 1999 at 6:06 pm
  • Hiroshi spotted the fundamental problem we were having: RelationFlushRelation would happily flush a relation-cache entry that still had an open file entry at the md.c and fd.c levels. This resulted ...
    Tom LaneTom Lane
    Sep 2, 1999 at 4:36 am
    Sep 28, 1999 at 1:30 pm
  • Using the exact same data, and the exact same queries (dbi is cool): MySQL: 0.498u 0.150s 0:02.50 25.6% 10+1652k 0+0io 0pf+0w PgSQL: 0.494u 0.061s 0:19.78 2.7% 10+1532k 0+0io 0pf+0w The main query ...
    The Hermit HackerThe Hermit Hacker
    Sep 19, 1999 at 2:39 pm
    Sep 23, 1999 at 1:47 pm
  • I know people were wondering about Jan, so I just talked to him via e-mail, and he has been busy on a big project. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) ...
    Bruce MomjianBruce Momjian
    Sep 20, 1999 at 1:35 pm
    Sep 22, 1999 at 7:26 am
  • I found weird behavior with temp tables. test= create table u1(i int); CREATE test= insert into u1 values(1); INSERT 3408201 1 test= insert into u1 values(1); INSERT 3408202 1 test= create temp table ...
    Tatsuo IshiiTatsuo Ishii
    Sep 4, 1999 at 2:10 pm
    Sep 7, 1999 at 4:04 am
  • I think I found some bugs in SELECT... I have two tables MASTER1 and DETAIL1 both of them with only one field CODE of data type VARCHAR but MASTER1.CODE is 11 char long and DETAIL1.CODE 16 char l ...
    José SoaresJosé Soares
    Sep 1, 1999 at 10:49 am
    Sep 7, 1999 at 3:43 pm
  • Hi Okee, I have caught the vacuum analyse crash that was giving me a load of grief Firstly, I create the following database $psql crashtest Welcome to the POSTGRESQL interactive sql monitor: Please ...
    Michael SimmsMichael Simms
    Sep 9, 1999 at 1:40 am
    Sep 28, 1999 at 4:22 am
  • Hi, I wrote new buildin functions (inspired with ...src/backend/utils/adt): text *asterisk(text *string) - Returns string, with all letters is '*' and length of new string is equal to original ...
    Karel ZakKarel Zak
    Sep 29, 1999 at 1:40 pm
    Oct 2, 1999 at 2:48 pm
  • I've got a big problem: I had an operator defined as follows: CREATE OPERATOR ^ ( leftarg = bit1, rightarg = bit1, procedure = bit1xor ); and this was fine until 6.5.1, but in 6.5.2 I get ERROR: ...
    Adriaan JoubertAdriaan Joubert
    Sep 22, 1999 at 1:38 pm
    Sep 28, 1999 at 3:20 pm
  • Exec-on-startup was removed by Bruce long time ago. Why we still attach to shmem after fork? Or shmem inheritance is not portable? Also, all this ShmemIndex stuff seems to be useless (except of ...
    Vadim MikheevVadim Mikheev
    Sep 20, 1999 at 3:35 am
    Sep 20, 1999 at 2:50 pm
  • [Charset iso-8859-1 unsupported, filtering to ASCII...] [CC'ing to hackers for comments.] Well, one idea is to create a server that listens on a certain port for CORBA requests, sends them to a ...
    Bruce MomjianBruce Momjian
    Sep 3, 1999 at 2:31 am
    Sep 10, 1999 at 3:02 pm
  • Thanks a lot for your explanations. We have started working with the snapshot and have found a problem with the selectivity estimation of join clauses, probably you just know of this. When the join ...
    Roberto CornacchiaRoberto Cornacchia
    Sep 7, 1999 at 7:24 pm
    Oct 8, 1999 at 4:33 pm
  • You're welcome. I've CC'd the hackers list because we might get some ideas from there too (and to surface once in a while - Bruce already missed me). Currently I'm very busy for serious work so I ...
    Jan WieckJan Wieck
    Sep 20, 1999 at 10:02 am
    Sep 21, 1999 at 9:13 pm
  • 1. Why did the new pgaccess get installed into REL6_5 branch but not main development branch? 2. New pgaccess no longer has a Makefile in src/bin/pgaccess, which is a problem because src/bin/Makefile ...
    Tom LaneTom Lane
    Sep 17, 1999 at 1:54 am
    Sep 21, 1999 at 12:44 am
  • ATTENTION: catalog changes - initdb required! General support for deferred constraint triggers is finished and committed to CURRENT tree. Implemented so far: CREATE CONSTRAINT TRIGGER ...
    Jan WieckJan Wieck
    Sep 29, 1999 at 5:16 pm
    Oct 3, 1999 at 7:57 pm
  • Hi, how I could create table with datetime field default to 'now'::text in a way Jan did in his shoes rule example ? If I do: test= create table test ( a datetime default 'now', b int4); CREATE test= ...
    Oleg BartunovOleg Bartunov
    Sep 20, 1999 at 9:50 pm
    Sep 21, 1999 at 2:27 pm
  • Michael Simms was kind enough to give me login privileges on his system to poke at his problems with vacuum running concurrently with table create/drop operations. I am not sure why his setup seems ...
    Tom LaneTom Lane
    Sep 11, 1999 at 5:58 pm
    Sep 13, 1999 at 6:29 pm
  • Whilst chasing down a few more aggregate-related bug reports, I realized that the planner is doing the Wrong Thing when a query's FROM clause mentions tables that are not used elswhere in the query. ...
    Tom LaneTom Lane
    Sep 29, 1999 at 2:35 pm
    Oct 5, 1999 at 2:09 pm
  • Hi, this select produces error message: test= select test2(NULL); ERROR: typeidTypeRelid: Invalid type - oid = 0 test2: CREATE FUNCTION test2 (int4) RETURNS int4 AS ' Declare keyval Alias For $1; cnt ...
    Oleg BartunovOleg Bartunov
    Sep 27, 1999 at 6:00 pm
    Oct 4, 1999 at 11:22 am
  • postgres= select * from t4; NOTICE: Adding missing FROM-clause entry for table t4 m|n -+- ... I updated my current tree and now this message comes out on even simple queries. Is it supposed to be ...
    Thomas LockhartThomas Lockhart
    Sep 29, 1999 at 1:47 pm
    Sep 30, 1999 at 1:16 am
  • Hi, all, Whoever is doing the SSL stuff: In postmaster.c, at lines 995, and 1841, there is code that is not wrapped in the USE_SSL define. Last night I checked out the latest source, and couldn't get ...
    Ansley, MichaelAnsley, Michael
    Sep 28, 1999 at 8:44 am
    Sep 28, 1999 at 11:28 am
  • Hello all, Cache invalidation mechanism was much improved. Thanks to Tom. But as far as I see,neither relation cache nor system catalog cache aren't be rollbacked correctly. This should be solved if ...
    Hiroshi InoueHiroshi Inoue
    Sep 17, 1999 at 1:37 am
    Sep 24, 1999 at 1:11 pm
  • I have been finding a lot of interesting stuff while looking into the buffer reference count/leakage issue. It turns out that there were two specific things that were camouflaging the existence of ...
    Tom LaneTom Lane
    Sep 23, 1999 at 12:06 am
    Sep 23, 1999 at 9:43 pm
  • Someone mentioned that it took them quite a while to compile the PostgreSQL code. My wallclock time is 3:52 for a compile with -O1 using gcc This is on a dual-PII 350MHz running BSD/OS 4.01. ...
    Bruce MomjianBruce Momjian
    Sep 22, 1999 at 8:27 pm
    Sep 23, 1999 at 3:02 pm
  • Following case statement is legal but fails in 6.5.1. drop table t1; DROP create table t1(i int); CREATE insert into t1 values(-1); INSERT 4047465 1 insert into t1 values(0); INSERT 4047466 1 insert ...
    Tatsuo IshiiTatsuo Ishii
    Sep 11, 1999 at 8:07 am
    Sep 19, 1999 at 9:43 am
  • Is there Changes list for 6.5.2 ? I checked REL6_5 tree and didn't find it. It seems that Vadim's patch for nbtinsert.c (row-reuse) still didn't applied. This patch prevents index file to grow ...
    Oleg BartunovOleg Bartunov
    Sep 1, 1999 at 6:09 am
    Sep 2, 1999 at 1:40 am
  • In the course of building and testing the rpm's for 6.5.2, unexpected results were found in the regression testing. I am curious as to what the results for 'float8' mean (geometry also failed, but ...
    Lamar OwenLamar Owen
    Sep 27, 1999 at 4:02 pm
    Oct 2, 1999 at 5:48 pm
  • I didn't look *carefully*, but I'm sure this is all just fine. If you have a chance, could you please try adding every new keyword to the existing alphabetical list in ColId and/or ColLabel? In many ...
    Thomas LockhartThomas Lockhart
    Sep 28, 1999 at 2:11 pm
    Sep 29, 1999 at 5:32 pm
  • Hi all, I have been working with user defined types and user defined c functions. One problem that I have encountered with the function manager is that it does not allow the user to define type ...
    Bernard FrankpittBernard Frankpitt
    Sep 13, 1999 at 8:27 pm
    Sep 28, 1999 at 1:46 pm
  • Hi, I have small problem with text array in union query.. see: abil= select 5 union select 5; ?column? -------- 5 (1 row) abil= select 5 union select 6; ?column? -------- 5 6 (2 rows) abil= select ...
    Karel ZakKarel Zak
    Sep 27, 1999 at 2:20 pm
    Sep 28, 1999 at 8:37 am
  • Do we have problems with int8 indexes? Seems select on an int8 does not use an index. This is PostgreSQL 6.5.2 on RedHat 6.0. -- Tatsuo Ishii
    Tatsuo IshiiTatsuo Ishii
    Sep 24, 1999 at 6:12 am
    Sep 27, 1999 at 1:31 pm
  • Hi All, Summary of the problem: I have another patch for a problem that I have run across, I describe the problem, the solution I propose, and I have included the patch as an attachment. The problem ...
    Bernard FrankpittBernard Frankpitt
    Sep 21, 1999 at 7:54 pm
    Sep 22, 1999 at 3:36 pm
  • Do people want pgaccess updated to 0.98 for the 6.5.2 release? -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe ...
    Bruce MomjianBruce Momjian
    Sep 13, 1999 at 12:29 am
    Sep 13, 1999 at 4:43 pm
  • Hi, I have made a small tool called "pgbench," that may be useful for some stress testings and performance measurements for PostgreSQL. pgbench can be obtained from: ...
    Tatsuo IshiiTatsuo Ishii
    Sep 30, 1999 at 1:24 am
    Oct 15, 1999 at 2:29 am
  • Hi all, just to give anyone a chance to complain, I'd like to describe what I plan to implement for v6.6 in the referential integrity (RI) corner. 1. What will be supported I'm concentrating on ...
    Jan WieckJan Wieck
    Sep 27, 1999 at 6:48 pm
    Oct 2, 1999 at 6:24 pm
  • Hi I will admit I am getting reeeeeallllly frustrated right now. Currently postgresql is crashing approximately once every 5 minutes on me template1= select version(); version ...
    Michael SimmsMichael Simms
    Sep 24, 1999 at 12:37 am
    Sep 28, 1999 at 12:40 am
  • Hi! How do you profile backend? It complains about 'profile timer expired' apparently due to waiting on socket. Maybe some compile option is missing or there is other trick? -- Leon. ------- He knows ...
    Sep 25, 1999 at 3:16 pm
    Sep 27, 1999 at 11:39 pm
  • Hi, I got a few reports from users that postmaster disappears for unknown reason. Inspecting the postmaster log, I found that postmaster exited at: if (select(nSockets, &rmask, &wmask, (fd_set *) ...
    Tatsuo IshiiTatsuo Ishii
    Sep 21, 1999 at 4:26 am
    Sep 22, 1999 at 4:41 pm
  • I have the requirement for ISO dates with European format and would like to change backend/utils/adt/dt.c:EncodeDateTime() and EncodeDateOnly() to effect this if this is a general requirement. Please ...
    Theo KramerTheo Kramer
    Sep 14, 1999 at 11:19 am
    Sep 14, 1999 at 5:06 pm
  • I have configured, built, and installed ProsgreSQL 6.5.1 using: --with-tcl and --with-tkconfig=<dir As far as I have looked, everything was built and installed without a hitch. The pltcl library is ...
    Patrick LoganPatrick Logan
    Sep 8, 1999 at 4:49 pm
    Sep 9, 1999 at 12:36 pm
  • 5


    ran= create table test_source (src text); CREATE ran= insert into test_source values('First distinct'); INSERT 235913 1 ran= insert into test_source values('First distinct'); INSERT 235914 1 ran= ...
    Oleg BroytmannOleg Broytmann
    Sep 17, 1999 at 10:39 am
    Oct 6, 2000 at 5:58 am
  • Someone had the bright idea that the postmaster's -i switch could be redefined as -i same as it ever was -is accept only SSL connections Unfortunately, implementing that requires a getopt() that ...
    Tom LaneTom Lane
    Sep 30, 1999 at 3:05 am
    Oct 2, 1999 at 3:49 pm
  • One idea, which takes into account the thought that moving the admin commands out of /usr/bin is a good thing, but moving them into /usr/sbin is bad, and we want to keep it simple for new people. ...
    Michael SimmsMichael Simms
    Sep 19, 1999 at 4:31 pm
    Sep 20, 1999 at 9:40 pm
  • The query you've presented is rather convoluted, but if I'm reading your query correctly, it should reduce to a simple, three-way join: SELECT c.id, c.name, c.url FROM aecEntMain a, aecWebEntry b, ...
    Mike MascariMike Mascari
    Sep 19, 1999 at 7:17 am
    Sep 20, 1999 at 9:27 pm
  • Just tried to do a vacuum analyze on a new database, and the backend started spewing out: FATAL: pq_endmessage failed: errno=32 pq_flush: send() failed: Broken pipe FATAL: pq_endmessage failed: ...
    The Hermit HackerThe Hermit Hacker
    Sep 18, 1999 at 8:52 pm
    Sep 19, 1999 at 2:16 am
  • Hey hackers: I'vebeen using pg_dump in a typical three db setup: development, staging, and live. The output of pg_dump is ordered by oid, so as the db's histories diverge, the output does as well. ...
    Ross J. ReedstromRoss J. Reedstrom
    Sep 13, 1999 at 1:19 am
    Sep 13, 1999 at 5:31 pm
Group Navigation
period‹ prev | Sep 1999 | next ›
Group Overview
grouppgsql-hackers @

99 users for September 1999

Bruce Momjian: 195 posts Tom Lane: 194 posts Thomas Lockhart: 66 posts The Hermit Hacker: 54 posts Jan Wieck: 42 posts Lamar Owen: 36 posts Vadim Mikheev: 33 posts Hiroshi Inoue: 26 posts Leon: 22 posts Tatsuo Ishii: 20 posts Ansley, Michael: 18 posts Michael Simms: 15 posts Oleg Bartunov: 14 posts José Soares: 12 posts Adriaan Joubert: 9 posts Andreas Zeugswetter: 9 posts Bernard Frankpitt: 8 posts Dmitry Samersoff: 7 posts Karel Zak: 7 posts Vince Vielhaber: 7 posts
show more