FAQ

Search Discussions

188 discussions - 1,002 posts

  • OK, I have installed a rotating globe on the developers page. After I get all the developer locations, I will add red dots to the globe. -- Bruce Momjian | http://www.op.net/~candle ...
    Bruce MomjianBruce Momjian
    Mar 8, 1999 at 5:34 pm
    Mar 23, 1999 at 11:02 pm
  • I've just committed my last changes to the www module and put the files onto the site. Now the globe is on the page again without a separate frame (much better). Jan -- ...
    Jan WieckJan Wieck
    Mar 16, 1999 at 9:48 am
    Mar 27, 1999 at 7:27 pm
  • Hello hackers... I've spent the last couple of evening tracing through the drop table/sequence code trying to figure out the best to drop the sequence when the table is dropped. Here is what I am ...
    Ryan BradetichRyan Bradetich
    Mar 15, 1999 at 10:20 am
    May 10, 1999 at 12:53 am
  • Hi all, While compiling of 6.4.2 I've realized that int8's are not supported on FreeBSD by default. The Configure script looks if %ld or %lld will do the job but FreeBSD is using %qd as the long long ...
    Holm TiffeHolm Tiffe
    Mar 3, 1999 at 7:28 am
    Mar 8, 1999 at 12:51 pm
  • It is nice looking. Would people prefer this? -- 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
    Mar 9, 1999 at 11:04 pm
    Mar 10, 1999 at 9:34 pm
  • ^^^^^^ Hmmm... Seems that vacuum wasn't run for table1. Why is index used ?!!! It's bug! Run vacuum table1 Vadim
    Vadim MikheevVadim Mikheev
    Mar 18, 1999 at 1:55 pm
    Mar 19, 1999 at 6:44 pm
  • Hi, How did XML get into this discussion? What I was talking about was a bug where, utility queries in a SPI procedure send command complete messages between data type messages (T) and data value ...
    Gerald L. GayGerald L. Gay
    Mar 1, 1999 at 12:03 am
    May 9, 1999 at 8:11 pm
  • Platform: Alpha, Digital UNIX 4.0D Software: PostgreSQL 6.4.2 and 6.5 snaphot (11 March 1999) I have a table as follows: Table = lineitem ...
    Erik RiedelErik Riedel
    Mar 19, 1999 at 8:58 pm
    Mar 24, 1999 at 6:06 pm
  • Platform: Alpha, Digital UNIX 4.0D Software: PostgreSQL 6.5 snaphot (11 March 1999) I have two tables as follows: Table = orderfoo +-------------------------+----------------------------+-------+ ...
    Erik RiedelErik Riedel
    Mar 24, 1999 at 4:21 am
    May 17, 1999 at 2:22 pm
  • I have a problem with Access97 not working properly when entering new records using a sub form, i.e. entering a new order/orderlines or master and detail tables. The problem is caused by a SQL ...
    Michael DavisMichael Davis
    Mar 3, 1999 at 7:52 pm
    May 10, 1999 at 4:30 pm
  • I still cannot get pg_dump to work since I fixed the system yesterday. This is a real mess and I need to make sure I have a current backup. -I upgraded from 6.4 - 6.4.2 and applied the 2GB patch -I ...
    Tim PerdueTim Perdue
    Mar 16, 1999 at 1:27 am
    Mar 24, 1999 at 1:00 pm
  • Not sure if I should post this here, but it seemed kinda appropriate. Anyway, I'm using 6.4.2 and execute the following query in psql, piping the results to a file: "select autos.*, owners.name, ...
    PostgresPostgres
    Mar 24, 1999 at 8:59 am
    Mar 29, 1999 at 8:07 pm
  • [last week aggregation, this week, the optimizer] I have a somewhat general optimizer question/problem that I would like to get some input on - i.e. I'd like to know what is "supposed" to work here ...
    Erik RiedelErik Riedel
    Mar 22, 1999 at 11:33 pm
    Mar 24, 1999 at 7:47 pm
  • I have been looking into what it would take to remove derived files from the CVS repository, and it doesn't look bad at all. I propose we do so before 6.5 beta. In case anyone's forgotten: the issue ...
    Tom LaneTom Lane
    Mar 19, 1999 at 2:40 am
    Apr 1, 1999 at 3:16 am
  • I just deleted all 50,000 rows from a table that has one int4 and one text field. Why does vacuum take so long? If all the rows are superceeded, so no rows actually have to be moved, should it take ...
    Bruce MomjianBruce Momjian
    Mar 17, 1999 at 6:31 pm
    May 10, 1999 at 1:07 am
  • Hmm. That shouldn't happen, especially not randomly; if the accept works the first time then it should work forever after, since the arguments being passed in never change. The error is coming from ...
    Tom LaneTom Lane
    Mar 15, 1999 at 2:36 am
    Mar 23, 1999 at 4:42 pm
  • I pulled the latest version of the source tree yesterday and complied PosgtreSQL 6.5. The get the following error on any select statement containing min() and max(): mp= select max(addressid) from ...
    Michael DavisMichael Davis
    Mar 20, 1999 at 7:11 am
    Mar 22, 1999 at 1:55 am
  • Hi! I am continuing playing with the query (I reduced it to): SELECT sh.distr_id , d.distr_id FROM central cn, shops sh, districts d WHERE cn.shop_id = sh.shop_id and got 27963 rows. I filtered it ...
    Oleg BroytmannOleg Broytmann
    Mar 5, 1999 at 1:13 pm
    Mar 15, 1999 at 1:36 pm
  • I just noticed that the palloc.h problem still exists. That is we do not install utils/mcxt.h but is included by palloc.h. Did we find a solution for this yet? Michael -- Michael Meskes | Go SF ...
    Michael MeskesMichael Meskes
    Mar 3, 1999 at 6:27 am
    Mar 9, 1999 at 6:07 am
  • The "Integrated Document" on the web page has the following paragraph in the section "CREATE TABLE" in chapter 20. In the current release (v6.4), Postgres evaluates all default expressions at the ...
    "D'Arcy" "J.M." Cain"D'Arcy" "J.M." Cain
    Mar 8, 1999 at 4:50 pm
    Jul 14, 1999 at 5:30 am
  • So, beta can be started... My vacation begins today. I'll come back Apr 5th and run mooore tests. There are also some small things to do. BTW, btrees are changed - initdb is required... Have a good ...
    Vadim MikheevVadim Mikheev
    Mar 28, 1999 at 9:35 pm
    Mar 30, 1999 at 5:39 pm
  • I was trying to describe a more general solution, where the operator is marked if it is associative when it is created. This would allow the same mechanism to be used for user defined types. :) Clark
    Clark EvansClark Evans
    Mar 16, 1999 at 10:38 pm
    Mar 26, 1999 at 3:29 pm
  • I have checked in fixes for all of the genuine bugs that I found in pg_operator and pg_proc by means of mechanical consistency checks. I would like to add these consistency checks to the regression ...
    Tom LaneTom Lane
    Mar 11, 1999 at 3:57 pm
    Mar 21, 1999 at 3:11 pm
  • Who are maintainer of libpq++? --- Dmitry Samersoff, dms@wplus.net, ICQ:3161705 http://devnull.wplus.net
    Dmitry SamersoffDmitry Samersoff
    Mar 29, 1999 at 12:33 pm
    Apr 1, 1999 at 12:59 am
  • Is there a CVS target for docs? I don't like the idea to check the whole source out just to change ecpg.sgml. Yes, I am actively editing some stuff in this file. :-) I'd like to commit my changes ...
    Michael MeskesMichael Meskes
    Mar 20, 1999 at 11:28 am
    Mar 23, 1999 at 6:21 am
  • Let me comment on this. In the first statement, "AA" is used in an SQL command, and we handle this correctly. In the second case, NEXTVAL is a function, called with a string. Now in parse_func.c, we ...
    Bruce MomjianBruce Momjian
    Mar 15, 1999 at 3:56 pm
    Mar 16, 1999 at 4:58 am
  • select id from clients where id = ( select id from clients where count(id) = 1 ) ; The error I get is that you can't do the AGGREGATE int he WHERE clause, but this is with a pre-v6.5 server ...
    The Hermit HackerThe Hermit Hacker
    Mar 30, 1999 at 5:18 pm
    Mar 30, 1999 at 7:08 pm
  • Hi all, I'm using postgres 6.3.2 as built by RedHat 5.2. Every time one of my programs tries to read the _2nd_ large object it gets an error. Well actually, closing the descriptor on the 1st large ...
    Chris BitmeadChris Bitmead
    Mar 29, 1999 at 11:00 am
    Mar 30, 1999 at 4:36 pm
  • ============================================================================ POSTGRESQL BUG REPORT TEMPLATE ============================================================================ Your name : ...
    Billy G. AllieBilly G. Allie
    Mar 3, 1999 at 3:51 am
    Mar 17, 1999 at 10:28 am
  • If you think about the query long enough you'll realize that several things have to be assummed for that query to be efficient. Looking at you final query first, and assuming that you have an index ...
    Jackson, DeJuanJackson, DeJuan
    Mar 10, 1999 at 8:15 pm
    Mar 11, 1999 at 6:01 pm
  • Hello! A week ago I reported this, but haven't got any good help. I am trying to repeat. Postgres 6.4.2 on Solaris. Query: SELECT p.subsec_id FROM positions p, central cn, shops sh, districts d WHERE ...
    Oleg BroytmannOleg Broytmann
    Mar 4, 1999 at 11:50 am
    Mar 9, 1999 at 8:59 am
  • Hi, I have a 2 tables and in some cases joining them are very slow. Here are details. create table postal ( oldcode varchar(5), -- has an btree index newcode char(7), -- has an btree index pid int2, ...
    Tatsuo IshiiTatsuo Ishii
    Mar 5, 1999 at 3:50 am
    Mar 7, 1999 at 5:31 pm
  • These used to work: regression= select %f.f1 FROM FLOAT8_TBL f; ERROR: parser: parse error at or near "%" regression= select f.f1 % FROM FLOAT8_TBL f; ERROR: parser: parse error at or near "from" ...
    Tom LaneTom Lane
    Mar 21, 1999 at 1:34 am
    Mar 21, 1999 at 8:32 pm
  • Here is the list. It is up-to-date as of Monday. Let me know if I have missed anything, or attributed something incorrectly to someone. I will shortly add some descriptive text to the release. ...
    Bruce MomjianBruce Momjian
    Mar 19, 1999 at 3:39 am
    Mar 21, 1999 at 2:11 am
  • That's no joke! Well - you wanted mountains - there they are (Example 2). But please don't tell me next you want planes in the air, smog over NY and dolphins in the sea :-) Jan -- ...
    Jan WieckJan Wieck
    Mar 18, 1999 at 2:48 am
    Mar 20, 1999 at 4:15 am
  • In this QUERY: SELECT keyname FROM markmain WHERE mark_id NOT IN(SELECT mark_id FROM markaty) I have an index on markaty.mark_id, and have vacuum analyzed. EXPLAIN shows: Seq Scan on markmain ...
    Bruce MomjianBruce Momjian
    Mar 16, 1999 at 11:00 pm
    Mar 18, 1999 at 2:40 am
  • I just want to go on record stating that I don't think we need a 6.4.3 release because I am concerned about making a more buggy release than 6.4.2 because of inadequate testing and 6.5 retrofitting ...
    Bruce MomjianBruce Momjian
    Mar 7, 1999 at 6:53 pm
    Mar 9, 1999 at 3:05 am
  • Are Tom Lane's fixes included in 6.4.3 beta? I think his findings are so important. --- Tatsuo Ishii
    Tatsuo IshiiTatsuo Ishii
    Mar 3, 1999 at 10:28 pm
    Mar 6, 1999 at 11:53 pm
  • Hi all, I just finished with a little password manager workaround for Postgres and I'd like to tell you to use it. Comments are welcome! I hope I could do something with this user authentication and ...
    Peter BlazsoPeter Blazso
    Mar 1, 1999 at 2:34 pm
    Mar 4, 1999 at 2:33 am
  • Hello all, "Hiroshi Inoue" <Inoue@tpf.co.jp writes: This time,I tested the following 2 cases under CURRENT(99/02/23) environment and the result was same. Those bugs are caused by copyObject(). The ...
    Hiroshi InoueHiroshi Inoue
    Mar 2, 1999 at 9:14 am
    Jul 7, 1999 at 2:03 am
  • Part of the problem is that PostgreSQL Assumes that a functions value will change each time it is required, therefore automatic table scan and the function is called for each row. Try using ...
    Jackson, DeJuanJackson, DeJuan
    Mar 30, 1999 at 4:07 am
    Mar 30, 1999 at 6:13 pm
  • Backed by PostgreSQL -Michael Robinson
    Michael RobinsonMichael Robinson
    Mar 27, 1999 at 6:05 am
    Mar 29, 1999 at 12:56 pm
  • Hi, When I try on current: abr= select sum(endt-begt-pausen)/count(*)::float8 from tage; ERROR: Unable to identify an operator '/' for types 'timespan' and 'float8' You will have to retype this query ...
    Michael ReifenbergerMichael Reifenberger
    Mar 8, 1999 at 8:33 am
    Mar 26, 1999 at 4:33 pm
  • I notice you used portals for vacuum, rather than a separate memory context. Can I ask why? I am considering creating an expression portal or memory context to prevent the memory leaks from the ...
    Bruce MomjianBruce Momjian
    Mar 23, 1999 at 3:00 am
    Mar 23, 1999 at 4:30 am
  • I was able to fix this problem by recompiling everything using xlc 3.6.4 (AIX native compiler). This leads me to believe there is some evil bug in gcc. I have no idea how to pursue this. For now I ...
    David R. FavorDavid R. Favor
    Mar 4, 1999 at 2:55 pm
    Mar 5, 1999 at 2:40 am
  • I didn't forget! istm that we risk cvs bloat by checking in derived files like gram.c, when there are probably minor differences in how each system generates them. So I don't usually check in those ...
    Thomas G. LockhartThomas G. Lockhart
    Mar 3, 1999 at 2:45 am
    Mar 3, 1999 at 3:09 pm
  • --- Situation Description --- I'm writing a quota system to a web-by-mail robot, on a database which consists of email text, url text, action varchar(8), -- in "sent", "toobig", "refused", ... bytes ...
    Oliver SmithOliver Smith
    Mar 31, 1999 at 10:54 am
    Mar 31, 1999 at 4:19 pm
  • Oleg BroytmannOleg Broytmann
    Mar 25, 1999 at 2:43 pm
    Mar 29, 1999 at 11:43 am
  • Hello! I ran the query update producers SET cor_id = producer_id % 9 + 1; and found that result is eqiuvalent to update producers SET cor_id = producer_id % 9; I added parens: update producers SET ...
    Oleg BroytmannOleg Broytmann
    Mar 17, 1999 at 8:50 am
    Mar 26, 1999 at 4:54 pm
  • Hi, I need some static oids to add new datatypes and procs to the system catalog. Can I just grab the first unused oids or should I choose oids from specific ranges for types and procs. -- Massimo ...
    Massimo Dal ZottoMassimo Dal Zotto
    Mar 24, 1999 at 5:31 pm
    Mar 25, 1999 at 4:42 am
Group Navigation
period‹ prev | Mar 1999 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions188
posts1,002
users94
websitepostgresql.org...
irc#postgresql

94 users for March 1999

Bruce Momjian: 224 posts Tom Lane: 105 posts The Hermit Hacker: 94 posts Jan Wieck: 65 posts Thomas Lockhart: 48 posts Vince Vielhaber: 43 posts Clark Evans: 37 posts Michael Davis: 34 posts Tatsuo Ishii: 29 posts Oleg Broytmann: 27 posts Vadim Mikheev: 27 posts "D'Arcy" "J.M." Cain: 20 posts Erik Riedel: 13 posts Jackson, DeJuan: 13 posts James Thompson: 12 posts Michael Meskes: 9 posts Peter Mount: 9 posts Dmitry Samersoff: 8 posts Hiroshi Inoue: 8 posts Ryan Bradetich: 7 posts
show more
Archives