FAQ

PostgreSQL > pgsql-hackers > April 2000

Search Discussions

44 discussions - 184 posts

  • Hi, this is not first letter about pg_dumplo which I head. What add pg_dumplo to contrib or main tree? Karel ---------- Forwarded message ---------- Date: Wed, 05 Apr 2000 11:51:53 -0400 From: CTN ...
    Karel ZakKarel Zak
    Apr 6, 2000 at 11:02 am
    Jun 12, 2000 at 8:46 am
  • I have found I can crash the backend with the following queries: test= BEGIN WORK; BEGIN test= DECLARE bigtable_cursor CURSOR FOR test- SELECT * FROM bigtable; SELECT test= FETCH 3 prior FROM ...
    Bruce MomjianBruce Momjian
    Apr 4, 2000 at 7:13 pm
    Apr 6, 2000 at 9:42 pm
  • Am I correct that we are targeting all these for 7.1? WAL/write ahead log TOAST/long tuples outer joins query tree redesign -- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610) ...
    Bruce MomjianBruce Momjian
    Apr 5, 2000 at 7:38 pm
    Apr 6, 2000 at 4:20 pm
  • I'd like to collect info on the platforms we are supporting for v7.0. I've listed below all of the platforms which have been supported in the past and any new platforms such as QNX which have a new ...
    Thomas LockhartThomas Lockhart
    Apr 2, 2000 at 12:13 am
    Apr 3, 2000 at 11:51 am
  • I am doing the chapter on temporary tables. Should I show examples using TEMP or TEMPORARY? -- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a ...
    Bruce MomjianBruce Momjian
    Apr 6, 2000 at 3:13 pm
    Apr 6, 2000 at 6:58 pm
  • I am aware of at least three non-backward-compatible changes in 7.0, ie, things that will break existing applications in perhaps non-obvious ways. I think the "Release Notes" document ought to call ...
    Tom LaneTom Lane
    Apr 2, 2000 at 9:13 pm
    Apr 3, 2000 at 5:32 am
  • OK, can someone confirm which items still need to be done to update the documentation? I can't imagine they are all done, and I don't think we can release 7.0 without them all being done. ...
    Bruce MomjianBruce Momjian
    Apr 5, 2000 at 5:32 pm
    Apr 7, 2000 at 12:27 am
  • You'll probably recall reports of messages like this out of VACUUM: NOTICE: Index ind1: NUMBER OF INDEX' TUPLES (2002) IS NOT THE SAME AS HEAP' (3003). I've figured out the cause (or at least a ...
    Tom LaneTom Lane
    Apr 6, 2000 at 12:33 am
    Apr 6, 2000 at 5:00 am
  • You can mark BSDi 4.01 as totally passing the regression tests. -- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe ...
    Bruce MomjianBruce Momjian
    Apr 4, 2000 at 1:50 pm
    Apr 5, 2000 at 2:26 am
  • Hi, In doing some more 7.0 testing, I ran across a difference in functionality concerning unique indexes and errors that are reported when you try to violate the index. I'm not sure if this change is ...
    Brian HirtBrian Hirt
    Apr 7, 2000 at 12:31 am
    Apr 7, 2000 at 1:22 am
  • Hi all, There was a bug(??) report about LIKE optimization of 7.0 beta3 in Japan from Akira Imagawa. It may be difficult to solve. Let t_hoge be a table like { hoge_cd int4 primary key, shimeinn ...
    Hiroshi InoueHiroshi Inoue
    Apr 6, 2000 at 2:59 pm
    Apr 7, 2000 at 1:12 am
  • Hi, here is an updated version of the bit type with a bugfix and all the necessary SQL functions defined. This should replace what is currently in contrib. I'd appreciate any comments on what is ...
    Adriaan JoubertAdriaan Joubert
    Apr 3, 2000 at 5:39 pm
    Apr 5, 2000 at 5:39 am
  • We have this in the CURSOR documentation: Once all rows are fetched, every other fetch access returns no rows. Is this still true? -- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us ...
    Bruce MomjianBruce Momjian
    Apr 4, 2000 at 7:28 pm
    Apr 5, 2000 at 12:15 am
  • If you run 6.5 pg_dump against a 7.0 database, or vice versa, you get very obscure error messages: parseNumericArray: too many numbers getInherits(): SELECT failed. Explanation from backend: 'ERROR: ...
    Tom LaneTom Lane
    Apr 3, 2000 at 6:48 pm
    Apr 4, 2000 at 2:42 pm
  • Hi, I have got another problem. I have a table(table tempOne) that has two fields, seqid(int) and phredscore(int). They are one to many relationship, e.g. one seqid has many phredscore. I would like ...
    Wenjin ZhengWenjin Zheng
    Apr 3, 2000 at 5:51 pm
    Apr 4, 2000 at 1:27 am
  • This should wait until after the proposed querytree overhaul we have in mind. I already discussed it with Tom Lane. The idea goes like this: After the overhaul, the rewriter is a very simple and fast ...
    Jan WieckJan Wieck
    Apr 3, 2000 at 5:15 pm
    Apr 5, 2000 at 11:34 am
  • It appears that some code in backend/utils/adt/int8.c tickles a compiler bug in SCO's UDK when it is compiled with optimazation turned on. The attached patch, which rewrites a for statement as a ...
    Billy G. AllieBilly G. Allie
    Apr 1, 2000 at 7:27 am
    Apr 5, 2000 at 4:01 am
  • Hello! When running multiple concurrent backends on my benchmark database, I see consistent crashing when running with 8 clients, and sporadic crashes when running with 4. After the crash, at least ...
    Magnus HaganderMagnus Hagander
    Apr 2, 2000 at 2:32 pm
    Apr 3, 2000 at 1:43 pm
  • Do we have temporary indexes? test= CREATE TABLE temptest(col INTEGER); CREATE test= create index ix on temptest (col); CREATE test= CREATE TEMP TABLE masktest (col INTEGER); CREATE test= create ...
    Bruce MomjianBruce Momjian
    Apr 6, 2000 at 3:59 pm
    Apr 6, 2000 at 6:06 pm
  • IIRC there was a problem with pg_dump and the serial datatype. I'm about to do some massive upgrades and part of it is going to 7.0 from 6.5.? I use serial datatypes heavily and reference them in ...
    Vince VielhaberVince Vielhaber
    Apr 6, 2000 at 1:52 pm
    Apr 6, 2000 at 4:07 pm
  • 9. drop old table If you do 9. you can skip 1. because that's done automatically. Not exactly. The OIDs in the trigger names are just ones that CREATE CONSTRAINT TRIGGER allocates itself to give any ...
    Jan WieckJan Wieck
    Apr 4, 2000 at 3:08 pm
    Apr 5, 2000 at 11:58 am
  • I finally managed to catch up with the 7.0 betas (provided beta5 does not come out in the next few hours :). My web site has been updated with the Linux/Alpha patches for 7.0beta4 (see the software ...
    Ryan KirkpatrickRyan Kirkpatrick
    Apr 5, 2000 at 12:32 am
    Apr 5, 2000 at 3:20 am
  • Hi, I'm running PostgreSQL 6.5.3 on Linux-2.2.12 on a 2-way SMP machine. I noticed that even after VACUUMing there are some indexes that still remain very big. For example, here's what I found for ...
    Daniele OrlandiDaniele Orlandi
    Apr 4, 2000 at 4:54 pm
    Apr 4, 2000 at 8:48 pm
  • The following code works under 6.5 and doesn't work in 7.0 beta 3. Comments? ------------------snip--------------------------------------- create table paths ( pathnum serial, pathname text ); CREATE ...
    Eric Lee GreenEric Lee Green
    Apr 3, 2000 at 9:45 pm
    Apr 4, 2000 at 1:10 am
  • Is this something that is safe to do just before a release like this? If so, I'll do it ... if not, someone remind me right afer the release .. Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems ...
    The Hermit HackerThe Hermit Hacker
    Apr 3, 2000 at 12:50 pm
    Apr 3, 2000 at 2:31 pm
  • Playing around with rules and views, I noticed the following: CREATE TABLE t ( i INTEGER, b BOOLEAN DEFAULT false ); CREATE VIEW v AS SELECT * FROM t; CREATE RULE v_insert AS ON INSERT TO v DO ...
    Mark HollomonMark Hollomon
    Apr 6, 2000 at 7:50 pm
    Apr 6, 2000 at 8:35 pm
  • Seems temporary tables can not be vacuumed. It is because vacuum.c does a sequential scan of the pg_class table, rather than using the cache. Should this be fixed? test= create temporary table test ...
    Bruce MomjianBruce Momjian
    Apr 6, 2000 at 5:10 pm
    Apr 6, 2000 at 5:55 pm
  • Hi, I got error when running vacuum analyze: discovery= vacuum analyze; ERROR: No one parent tuple was found discovery= discovery= vacuum analyze hits; NOTICE: CreatePortal: portal <vacuum already ...
    Oleg BartunovOleg Bartunov
    Apr 4, 2000 at 3:11 pm
    Apr 5, 2000 at 12:06 am
  • Hi all! When I login with correct login and incorrect password I can do all like I enter correct password. What's I do wrong? ...
    Sergey V. MikheevSergey V. Mikheev
    Apr 4, 2000 at 2:47 pm
    Apr 4, 2000 at 3:06 pm
  • The man page for initdb says that the -t option will overwrite the template1 database with the up-to-date structure and suggests that this is the way to upgrade to a newer release: --template -t ...
    Oliver ElphickOliver Elphick
    Apr 2, 2000 at 6:10 am
    Apr 2, 2000 at 9:15 pm
  • This isn't enough information. What exactly do you mean by "doesn't work"? What query did you issue, what result did you get, what did you expect to get? And which locale are you using? regards, tom ...
    Tom LaneTom Lane
    Apr 2, 2000 at 5:41 am
    Apr 2, 2000 at 9:14 pm
  • Gee, it is pretty late in beta to be doing this. Comments? -- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + ...
    Bruce MomjianBruce Momjian
    Apr 2, 2000 at 2:30 pm
    Apr 2, 2000 at 4:39 pm
  • I just repaired (I hope) a resource leakage problem in execMain.c. When EvalPlanQual is used, any subplans it creates need to be shut down at the end of the query to release their resources. There ...
    Tom LaneTom Lane
    Apr 7, 2000 at 1:07 am
    Apr 7, 2000 at 1:07 am
  • Fixed: test= CREATE TEMPORARY TABLE test(x int); CREATE test= VACUUM test; VACUUM Look at the comment I found in the code: /* * we could use the cache here, but it is clearer to use scankeys * for ...
    Bruce MomjianBruce Momjian
    Apr 6, 2000 at 6:02 pm
    Apr 6, 2000 at 6:02 pm
  • Hi, I noticed a behaviour in PostgreSql 7 (beta 3, Alpha, Digital Unix 4.0f, cc) that probably needs to be addressed. If I create a table referencing a view create table mytable (id serial, name ...
    Alessio BragadiniAlessio Bragadini
    Apr 6, 2000 at 12:21 pm
    Apr 6, 2000 at 12:21 pm
  • Applied. [Charset iso-8859-1 unsupported, filtering to ASCII...] [Attachment, skipping...] -- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a ...
    Bruce MomjianBruce Momjian
    Apr 5, 2000 at 2:48 pm
    Apr 5, 2000 at 2:48 pm
  • I'm in no way an ODBC or BDE guy - anyway. First of all, 6.5.* didn't had the FOREIGN KEY implementation your 7.0 message is coming from. It's completely new stuff. Second, since an ERROR is ...
    Jan WieckJan Wieck
    Apr 5, 2000 at 12:33 pm
    Apr 5, 2000 at 12:33 pm
  • Andreas, can we count AIX as a supported platform for Postgres-7.0? - Thomas -- Thomas Lockhart lockhart@alumni.caltech.edu South Pasadena, California
    Thomas LockhartThomas Lockhart
    Apr 5, 2000 at 2:06 am
    Apr 5, 2000 at 2:06 am
  • Hi, are there an efficient way to count distinct result from join ? I know it's possible in 7.0 to do select count(distinct m.msg_id) from messages m, message_section_map ms where m.msg_id = ...
    Oleg BartunovOleg Bartunov
    Apr 4, 2000 at 7:35 pm
    Apr 4, 2000 at 7:35 pm
  • Seems this no longer true, so I removed it from the FETCH manual page: Once all rows are fetched, every other fetch access returns no rows. -- Bruce Momjian | http://www.op.net/~candle ...
    Bruce MomjianBruce Momjian
    Apr 4, 2000 at 7:29 pm
    Apr 4, 2000 at 7:29 pm
  • Hmm. The patch is not backward compatible. Presumably there is provision in the code to know what version of DBMS to connect to? In that case, I can probably carry along two different queries and a ...
    Thomas LockhartThomas Lockhart
    Apr 2, 2000 at 9:06 pm
    Apr 2, 2000 at 9:06 pm
  • I have one bug that I simply cannot track down. Both the attached files are mostly identical except that m.pgc calls a function before selecting data. What happens is that both give an identical ...
    Michael MeskesMichael Meskes
    Apr 2, 2000 at 8:50 am
    Apr 2, 2000 at 8:50 am
  • Just looking around, and in one of my databases, there is a core file from tonight, as well, that a quick gdb shows: (gdb) where #0 0x8060f92 in nocachegetattr () #1 0x809018f in ExecEvalVar () #2 ...
    The Hermit HackerThe Hermit Hacker
    Apr 1, 2000 at 1:47 am
    Apr 1, 2000 at 1:47 am
  • Jsut doing a vacuum of my database, and foundsomething that I consider to be "odd" ... while vacuuming one of the tables, doign a ps shows: 64185 p8 S 0:00.10 /home/database/v6.5.3/bin/postgres pgsql ...
    The Hermit HackerThe Hermit Hacker
    Apr 1, 2000 at 1:43 am
    Apr 1, 2000 at 1:43 am
Apr 2000
Group Navigation
period‹ prev | Apr 2000 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions44
posts184
users33
websitepostgresql.org...
irc#postgresql

33 users for April 2000

Bruce Momjian: 39 posts Tom Lane: 34 posts Thomas Lockhart: 19 posts Hiroshi Inoue: 12 posts Don Baccus: 10 posts Karel Zak: 10 posts The Hermit Hacker: 9 posts Jan Wieck: 7 posts Peter Eisentraut: 6 posts Tatsuo Ishii: 5 posts Adriaan Joubert: 3 posts Ryan Kirkpatrick: 3 posts Brian Hirt: 2 posts Magnus Hagander: 2 posts Michael Meskes: 2 posts Oleg Bartunov: 2 posts Vince Vielhaber: 2 posts Wenjin Zheng: 2 posts Alessio Bragadini: 1 post Alfred Perlstein: 1 post
show more
Archives