FAQ

Search Discussions

163 discussions - 692 posts

  • Hello! A week ago I reported a problem with VACUUM ANALYZE on linux and memory error. Three good guys saw my database and two of them for VACUUM problem, I hope (Tom Lane and Thomas Lockhart). Have ...
    Oleg BroytmannOleg Broytmann
    Feb 8, 1999 at 12:37 pm
    Mar 21, 1999 at 3:50 pm
  • Hi, I saw a message a couple of weeks ago from someone having problems with larger than 2GB tables. I have similar problems. PostgreSQL: anon-cvs as of today (2/5/1999) OS: Redhat Linux 5.2 (running ...
    GjerdeGjerde
    Feb 5, 1999 at 11:07 pm
    Mar 17, 1999 at 1:47 pm
  • Hi! can somebody see this too? create table t1(i1 int4); create table t2(i1 int4); create table t3(i2 int4); test= create rule rm_t1 as on delete to t1 test- do ( delete from t2 where old.i1 = i1; ...
    Erich StambergerErich Stamberger
    Feb 2, 1999 at 7:44 am
    Feb 23, 1999 at 3:53 am
  • For discussion: I've committed two little changes to CURRENT and REL6_4. 1. ExecBRDeleteTriggers() now free's the return tuple from the trigger procedure if that isn't the tuple given to it as OLD. ...
    Jan WieckJan Wieck
    Feb 7, 1999 at 5:25 pm
    Feb 10, 1999 at 4:09 am
  • Some compilation problem found while compiling PostgreSQL-6.4.2 on OSF1 V4.0 878 alpha 1. configure (problem because . not in $PATH) 743c743 < . ./conftest.sh --- 2. gram.y did not compile by yacc ...
    Dmitry SamersoffDmitry Samersoff
    Feb 3, 1999 at 6:52 pm
    Feb 9, 1999 at 6:14 am
  • Hi all, The inet regression test has been failed on my LinuxPPC. While investigating the reason, I found a code that doesn't work on LinuxPPC. From network_broadcast() in utils/adt/network.c: int ...
    Tatsuo IshiiTatsuo Ishii
    Feb 22, 1999 at 2:54 am
    May 11, 1999 at 10:14 am
  • subscribe
    Venkatesh. KVenkatesh. K
    Feb 1, 1999 at 5:45 pm
    May 10, 1999 at 12:45 am
  • I have just checked in code changes (no doc updates yet :-() that address our recent discussions about how many backend processes can be used. Specifically: configure takes a --with-maxbackends=N ...
    Tom LaneTom Lane
    Feb 19, 1999 at 6:58 am
    Mar 7, 1999 at 11:51 am
  • uname -a SunOS vlad 5.7 Generic_106541-01 sun4u sparc SUNW,Ultra-5_10 gcc -v Reading specs from /opt/gnu/lib/gcc-lib/sparc-sun-solaris2.7/egcs-2.91.60/specs gcc version egcs-2.91.60 19981201 ...
    Brian P MillettBrian P Millett
    Feb 23, 1999 at 3:41 pm
    Mar 7, 1999 at 2:36 am
  • Hello, I am running 6.4.2 on Sparc/Solaris 2.7. Occasionally (far more often than I would like - which is never :), the postmaster refuses connections. Upon investigation, there are 48 postmaster ...
    Daryl W. DunbarDaryl W. Dunbar
    Feb 10, 1999 at 3:00 am
    Feb 11, 1999 at 7:10 pm
  • Already asked this in the other lists so here. I need to store some polygons that are larger than 8K. I was reading in hackers archives talk about a solution to the 8K limit. Was anything done? If ...
    Ken MortKen Mort
    Feb 13, 1999 at 4:12 am
    Feb 18, 1999 at 10:50 am
  • It's time, as we've seen on the recent question, the time qualification code has to be modified again. I think a little extension to Vadim's SnapshotData could do the trick. Following is what I so ...
    Jan WieckJan Wieck
    Feb 8, 1999 at 4:20 pm
    Feb 12, 1999 at 2:26 am
  • I have just rejiggered the int8 support so that it only depends on snprintf instead of sprintf and sscanf. The interesting thing about this is that we have our own version of snprintf that we use if ...
    Tom LaneTom Lane
    Feb 3, 1999 at 12:38 am
    Mar 14, 1999 at 2:59 am
  • The equal() updates I installed yesterday (to fix the "don't know whether nodes of type 600 are equal" problem) have had an unintended side effect. Am I right in thinking that UNION (without ALL) is ...
    Tom LaneTom Lane
    Feb 7, 1999 at 6:47 pm
    Jul 7, 1999 at 1:47 pm
  • Postgres 6.4.2, gcc 2.8.1, hpux 10.20 and Sparc/Solaris 2.6 (All debugging attempts were on the hpux machine, but the symptom also occurs on the Solaris box. Also tried the latest (feb 18) snapshot ...
    Ron SnyderRon Snyder
    Feb 18, 1999 at 10:14 pm
    Mar 14, 1999 at 4:08 pm
  • Can someone comment on what Bushy plans do in the optimizer, and whether the code has any value? -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life ...
    Bruce MomjianBruce Momjian
    Feb 14, 1999 at 7:21 pm
    Feb 15, 1999 at 7:10 am
  • I am working on it now, but it is currently not working properly. -- 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
    Feb 11, 1999 at 10:00 pm
    Feb 15, 1999 at 2:39 am
  • Could anyone tell me why a term like 'int' is not a keyword? Also I need a list of postgresql types so I know which ones should be accepted by ecpg. Finally I wonder whether we should make all ecpg ...
    Michael MeskesMichael Meskes
    Feb 8, 1999 at 5:39 pm
    Feb 11, 1999 at 6:09 am
  • I have been looking at optimizer runtime using Charles Hornberger's example case, and what I find is that the number of tables involved in the query is a very inadequate predictor of the optimizer's ...
    Tom LaneTom Lane
    Feb 2, 1999 at 12:18 am
    Feb 6, 1999 at 5:52 pm
  • Hi, I've just committed two very simple patches to copy.c and trigger.c which caused backend to grow until transaction end. trigger.c didn't expected that trigger function could have returned another ...
    Jan WieckJan Wieck
    Feb 1, 1999 at 8:33 pm
    Feb 2, 1999 at 4:57 pm
  • How do you propose doing outer joins in non-mergejoin situations? Mergejoins can only be used currently in equal joins. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) ...
    Bruce MomjianBruce Momjian
    Feb 24, 1999 at 9:58 am
    Mar 9, 1999 at 3:25 am
  • Is there any documentation on database recovery. I am new to Postgres. I really like what I see. I have written a membership database application for a NPO in New Mexico. It is written in Access 97. ...
    Michael DavisMichael Davis
    Feb 14, 1999 at 12:13 am
    Feb 24, 1999 at 2:29 pm
  • Can someone please take a minute to look at this? I've gzip'd and moved his errorlog to ftp.postgresql.org:/pub/debugging...one thing that appears to be lacking...what version of PostgreSQL are you ...
    The Hermit HackerThe Hermit Hacker
    Feb 19, 1999 at 5:45 pm
    Feb 20, 1999 at 9:50 pm
  • I have fixed bushy plans, enabled with the postgres -b option. Here is proof from OPTIMIZER_DEBUG: levels left: 7 (9 8 7 6 ): size=1 width=16 path list: Nestloop size=1 cost=0.000000 MergeJoin size=1 ...
    Bruce MomjianBruce Momjian
    Feb 18, 1999 at 12:48 am
    Feb 18, 1999 at 5:10 am
  • Thus spake Neil Burrows This makes me think of two features missing in PostgreSQL that I would love to see. I know it's probably to late to think about it now for 6.5 but I wonder what others think ...
    "D'Arcy" "J.M." Cain"D'Arcy" "J.M." Cain
    Feb 11, 1999 at 12:33 pm
    Feb 12, 1999 at 7:10 pm
  • I am writing a Postgres interface for Guile. (I know, I am the other one of the two people doing this!) I sent a message at the weekend, but I used mime encoding of the files which I understand some ...
    Ian GrantIan Grant
    Feb 2, 1999 at 11:15 am
    Feb 12, 1999 at 2:20 pm
  • I tried this wih 6.4.2 and found that it was only accepted if I explicitly identified which index operator class to use: play= create table customer (email text); CREATE play= create unique index ...
    Tom LaneTom Lane
    Feb 6, 1999 at 5:29 pm
    Mar 15, 1999 at 2:54 pm
  • ERROR: RestrictionClauseSelectivity: bad value 163645.593750 The query is: SELECT p.first_name, p.last_name, t.title, t.rundate, t.app_version, p.email FROM sw_password p, tools t WHERE p.userid = ...
    The Hermit HackerThe Hermit Hacker
    Feb 7, 1999 at 6:24 am
    Feb 24, 1999 at 5:32 pm
  • It used to be that Postgres' shared memory was sized on the basis of the hard-wired MaxBackendId constant. I have altered things so that it is sized on the basis of the actual -N switch given to the ...
    Tom LaneTom Lane
    Feb 21, 1999 at 6:58 pm
    Feb 23, 1999 at 3:07 pm
  • I have a record in table cust with the username of joblo and it's already lower case. This is from a cvsup a couple of weeks old. classifieds= select count(*) from cust where username = ...
    Vince VielhaberVince Vielhaber
    Feb 19, 1999 at 6:31 pm
    Feb 22, 1999 at 3:44 pm
  • I've been seeing the following behavior with the CVS sources for the last several days: $ psql regression regression= SELECT * INTO TABLE ramp FROM road ; SELECT regression= \d ramp Couldn't find ...
    Tom LaneTom Lane
    Feb 5, 1999 at 4:54 am
    Feb 6, 1999 at 8:43 pm
  • src/template/alpha_cc seems missing in 6.4.2 but does exist in current. What about 6.4_REL? I belive that file should exist in any version of source tree. -- Tatsuo Ishii
    Tatsuo IshiiTatsuo Ishii
    Feb 3, 1999 at 7:02 am
    Feb 4, 1999 at 2:18 pm
  • Hello! Query: SELECT DISTINCT p.subsec_id FROM central cn, shops sh, districts d, positions p WHERE cn.shop_id = sh.shop_id AND sh.distr_id = d.distr_id AND d.city_id = %d AND cn.pos_id = p.pos_id ...
    Oleg BroytmannOleg Broytmann
    Feb 24, 1999 at 1:03 pm
    May 10, 1999 at 10:34 am
  • I have some patches which will change rules.sql to avoid using getpgusername() altogether, since that returns an installation-dependent result. Will apply sometime soon, along with some other changes ...
    Thomas G. LockhartThomas G. Lockhart
    Feb 22, 1999 at 2:58 am
    Feb 23, 1999 at 2:58 am
  • Hello again, Thanks again to those who pointed me to the semaphore problem. I, unfortunately have another problem: Solaris7 on a Sparc20 running 6.4.2. Occasionally (once or twice a day) under a very ...
    Daryl W. DunbarDaryl W. Dunbar
    Feb 12, 1999 at 3:39 pm
    Feb 13, 1999 at 11:15 pm
  • Bruce, did you ever commit the temp table stuff? If so what was the syntax? FYI using snapshot 2/10/1999. -DEJ
    Jackson, DeJuanJackson, DeJuan
    Feb 11, 1999 at 5:13 pm
    Feb 12, 1999 at 12:00 am
  • Nice idea. But a word of caution seems appropriate. Commercial support doesn't mean only that you can hire someone who takes care about your actual problems with the product. It also means that there ...
    Jan WieckJan Wieck
    Feb 8, 1999 at 2:06 pm
    Feb 8, 1999 at 4:57 pm
  • Could anyone tell me whether the EXEC SQL PREPARE statement is to be interpreted by the preprocessor or during run-time? That is can it be placed outside a function? Does it have to stand above the ...
    Michael MeskesMichael Meskes
    Feb 3, 1999 at 6:30 pm
    Feb 5, 1999 at 6:40 am
  • Bruce, would this be a good time to start the v6.5 release notes? Certainly the temp tables capability would make the short list of "highlighted features" in the 1-paragraph-per-topic summary above ...
    Thomas G. LockhartThomas G. Lockhart
    Feb 1, 1999 at 1:19 pm
    Feb 2, 1999 at 3:30 am
  • Hello hackers... Enclosed below I have a patch to allow a btree index on the int8 type. I would like some feedback on what the hash function for the int8 hash function in the ...
    Ryan BradetichRyan Bradetich
    Feb 22, 1999 at 11:26 pm
    Mar 21, 1999 at 7:04 pm
  • [I'm posting this to the hackers list, as I think this is something deep in the backend, and not JDBC - Peter] I've been talking to Jason Venner <jason@idiom.com over the last couple of days with an ...
    Peter T MountPeter T Mount
    Feb 17, 1999 at 10:04 pm
    Feb 18, 1999 at 10:04 pm
  • I have changed comments like my-function-name-- to my_function_name. This affects only comments. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life ...
    Bruce MomjianBruce Momjian
    Feb 13, 1999 at 10:50 pm
    Feb 15, 1999 at 7:20 pm
  • Hello Hackers ... The following patch is needed to compile the current development tree with perl support. The addition of MemoryContextAlloc, MemoryContextFree, and MemoryContexRealloc in ...
    Ryan BradetichRyan Bradetich
    Feb 11, 1999 at 2:36 am
    Feb 11, 1999 at 11:43 pm
  • Unfortunately, that is true, at least for Postgres 6.4.0: template1= select text('12345678'::float8); text ----------------------------- Tue May 23 00:21:18 2000 EEST (1 row) Please, guys, take care ...
    Postgres DBAPostgres DBA
    Feb 10, 1999 at 1:31 pm
    Feb 10, 1999 at 3:38 pm
  • I think I have solved the optimizer problem. It appears in samekeys(). Can someone check that function, and see if you come up with the same fix I do (without knowing my fix)? A 9-table join that ...
    Bruce MomjianBruce Momjian
    Feb 8, 1999 at 9:29 pm
    Feb 9, 1999 at 5:00 pm
  • Hi, I found a bug in 6.4.2 which seems to be related to the char(n) type and shows up if one assigns a zero-length default value. Here is an example: test= create table t1 ( test- str1 char(2) ...
    Erich StambergerErich Stamberger
    Feb 5, 1999 at 7:32 pm
    Jul 7, 1999 at 1:51 am
  • Hi, I have seen what I concider to be a bug in either the libpq library or in the backend. To see the effects, first, install the execq() function from the SPI section of the Programmers Guide. Then ...
    Gerald L. GayGerald L. Gay
    Feb 25, 1999 at 5:09 am
    Feb 27, 1999 at 4:52 pm
  • Hi all I'm now building up a new server, Red Hat 5.2 with updates and the new 2.2.2 kernel. I may have missed it, but do not recall seeing any thing about semaphores in the "make menuconfig", is it ...
    Terry MackintoshTerry Mackintosh
    Feb 25, 1999 at 5:38 pm
    Feb 27, 1999 at 12:11 am
  • Hello all, AFAIC the relation between objects is not copied correctly by copyObject() (i.e the same pointers to an object are copied to different pointers by copyObject()). I think it makes ...
    Hiroshi InoueHiroshi Inoue
    Feb 23, 1999 at 12:10 am
    Feb 25, 1999 at 1:55 am
  • I updated the cvs. Forgot to update the web site. Done now. You should see the updated list now. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life ...
    Bruce MomjianBruce Momjian
    Feb 22, 1999 at 9:28 pm
    Feb 25, 1999 at 12:06 am
Group Navigation
period‹ prev | Feb 1999 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions163
posts692
users94
websitepostgresql.org...
irc#postgresql

94 users for February 1999

Bruce Momjian: 138 posts Tom Lane: 75 posts Jan Wieck: 54 posts Thomas G. Lockhart: 48 posts Oleg Broytmann: 33 posts The Hermit Hacker: 28 posts Tatsuo Ishii: 27 posts Vadim Mikheev: 25 posts Michael Meskes: 20 posts Peter T Mount: 17 posts Daryl W. Dunbar: 15 posts Hannu Krosing: 14 posts Jackson, DeJuan: 10 posts "D'Arcy" "J.M." Cain: 9 posts Michael Davis: 9 posts Vince Vielhaber: 8 posts Hiroshi Inoue: 6 posts Jose' soares: 6 posts Thomas Reinke: 6 posts Zeugswetter Andreas IZ5: 6 posts
show more
Archives