Search Discussions

186 discussions - 1,057 posts

  • Hello Tom, Tuesday, July 06, 1999 you wrote: T No, you are not right. Tuple updates can *never* be done without T moving the tuple, because the old tuple value must not be overwritten T until and ...
    Jul 5, 1999 at 7:33 pm
    Jul 27, 1999 at 1:52 pm
  • ADMIN * Allow international error message support and add error codes The JDBC driver already has the international error message support. All it needs are some translations of the errors.properties ...
    Peter MountPeter Mount
    Jul 8, 1999 at 8:30 am
    Jul 27, 1999 at 1:40 pm
  • Well, doing arbitrary tuple size should be as generic as possible. Thus I think the best place to do it is down in the heapam routines (heap_fetch(), heap_getnext(), heap_insert(), ...). I'm not 100% ...
    Jan WieckJan Wieck
    Jul 27, 1999 at 3:17 pm
    Jul 28, 1999 at 12:33 pm
  • Trawling through the code last night I noticed that: #define MAX_QUERY_SIZE (BLCKSZ * 2) Is there any conceivable reason why the query length would be dependent on the block size? Or do I just have ...
    Ansley, MichaelAnsley, Michael
    Jul 14, 1999 at 7:50 am
    Jul 28, 1999 at 5:03 am
  • I have PostgreSQL 6.4.2 installed since before and it was pretty easy to compile it except for a few minor things. But but today I planned to upgrade to version 6.5.1. So I made a pg_dumpall and ...
    Roberth AnderssonRoberth Andersson
    Jul 31, 1999 at 3:52 am
    Aug 2, 1999 at 4:57 pm
  • Yup. OK, I'm trying to do this to help the Alpha folks, in such a way that it helps the Alpha-linux-RH folks to get RPMs also. Having a 6.5.2 which does not run on Intel or Sparc does not help. ...
    Thomas LockhartThomas Lockhart
    Jul 30, 1999 at 12:16 am
    Jul 31, 1999 at 5:02 pm
  • subscribe
    Wilson vargheseWilson varghese
    Jul 8, 1999 at 4:48 am
    Jul 31, 1999 at 11:01 pm
  • Other db's usually use the value count(*) / nunique for the light weight statistics. This makes the assumptoin that the distinct index values are evenly distributed. That is on average a correct ...
    Zeugswetter Andreas IZ5Zeugswetter Andreas IZ5
    Jul 28, 1999 at 7:49 am
    Jul 31, 1999 at 5:01 pm
  • on the patches list, I posted the first files for suuport for using perl as the procedural language. The makefile uses libtool (probably incorrectly). It is not 'safe'. Perl XS modules cannot be ...
    Mark HollomonMark Hollomon
    Jul 24, 1999 at 1:46 am
    Jul 27, 1999 at 6:05 pm
  • I just began to learn rules with 6.5 and notice: test= \dt Database = test +------------------+----------------------------------+----------+ ...
    Oleg BartunovOleg Bartunov
    Jul 11, 1999 at 5:27 pm
    Sep 27, 1999 at 12:10 am
  • Using 6.5 (via Thomas Lockhart's Linux RPM build of Jul 2), I get a phantom row when doing the following: create table foo (a int); select t1.a, count(*) from foo t1, foo t2 group by t1.a; I get ...
    Malcolm BeattieMalcolm Beattie
    Jul 22, 1999 at 1:38 pm
    Jul 24, 1999 at 12:00 pm
  • 16


    [Man, I am applying all the fixes. If there is a problem with 6.5.1, they are going to know it was me.] -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If ...
    Bruce MomjianBruce Momjian
    Jul 9, 1999 at 6:00 pm
    Jul 12, 1999 at 1:38 pm
  • Well. Yeah, I do. Well. The problem is that the client sends the StartupPacket without reading anything at all from the server, which means it is too late to do SSL negotiation after the ...
    Magnus HaganderMagnus Hagander
    Jul 23, 1999 at 5:32 pm
    Jul 27, 1999 at 2:13 am
  • In the regression test rules.sql there is this SQL command update rtest_v1 set a = rtest_t3.a + 20 where b = rtest_t3.b; Which causes my alpha port to go core. The above line can be reduced to: ...
    Uncle GeorgeUncle George
    Jul 20, 1999 at 12:29 am
    Nov 30, 1999 at 2:21 am
  • Please Cc: to teo@flex.ro I have a table called "note" that looks like this : create table "note" (id serial,perioada int2,schema int2,explicatie text,...); The "note" table has 22.000 records and ...
    Constantin TeodorescuConstantin Teodorescu
    Jul 14, 1999 at 7:09 am
    Jul 16, 1999 at 1:06 am
  • Hi. I think I've created a monster... Working on an email system I have the following: Table = usermail +----------------------------------+--------------------------+-------+ etc... And: Table = ...
    Michael RichardsMichael Richards
    Jul 13, 1999 at 11:25 pm
    Oct 6, 2000 at 5:04 am
  • I re-enabled pg_upgrade this afternoon, thinking that it would be easier to use than dump/initdb/reload for coping with the pg_statistic change I'm about to commit. However, testing shows that it ...
    Tom LaneTom Lane
    Jul 31, 1999 at 10:18 pm
    Nov 29, 1999 at 11:01 pm
  • I got a problem with query: select distinct (date), bytes from access_log; which works but not as I expect. I thought this query will select all rows with distinct values of 'date' column, but it get ...
    Oleg BartunovOleg Bartunov
    Jul 10, 1999 at 8:16 pm
    Sep 23, 1999 at 11:42 pm
  • Many thanks to everyone who helped so far especially Todd Vierling for the RTFF. I think I am closer but I still have a problem. Here is the rule in my makefile now. .o.so: ld -shared -L${PGDIR}/lib ...
    "D'Arcy" "J.M." Cain"D'Arcy" "J.M." Cain
    Jul 27, 1999 at 1:33 pm
    Jul 27, 1999 at 8:39 pm
  • Hi, I'm a little bit confused with http://www.postgresql.org 1. Netscape 3.04 totally unusable to browse postgres site - I see only text of javascript 2. Lynx works better, but still when select ...
    Oleg BartunovOleg Bartunov
    Jul 26, 1999 at 12:29 pm
    Jul 27, 1999 at 1:38 pm
  • If you have a default value for a column, say create table t (a int4, b int4 default 12345); and you write a command that depends on the default, say insert into t (a) values (1); the way that the ...
    Tom LaneTom Lane
    Jul 7, 1999 at 11:50 pm
    Jul 27, 1999 at 1:30 pm
  • Try this one: create table fltsrc (f1 float8); insert into fltsrc values (1.0); insert into fltsrc values (1.1); create table intdest (f1 int4); insert into intdest select distinct f1 from fltsrc; ...
    Tom LaneTom Lane
    Jul 20, 1999 at 4:22 am
    Jul 22, 1999 at 2:25 pm
  • I have added two new files to the /doc directory called KNOWN_BUGS and MISSING_FEATURES. The files say: PostgreSQL has a single combined bugs, missing features, and todo list simply called TODO, in ...
    Bruce MomjianBruce Momjian
    Jul 1, 1999 at 5:36 am
    Jul 21, 1999 at 5:29 pm
  • It took a little work to recompile after the include-file cleanups :-(. You got overenthusiastic about removing #includes, apparently. I have checked in changes for the ones that caused compile ...
    Tom LaneTom Lane
    Jul 16, 1999 at 11:31 pm
    Jul 18, 1999 at 3:27 am
  • For Digital UNIX 4.0D, shared libraries are created by: $ ld -shared -expect_unresolved "*" -o foo.so [objects] This presents a problem for mkMakefile.tcldefs.sh.in. In tclConfig.sh: TCL_SHLIB_LD='ld ...
    Jul 10, 1999 at 5:55 am
    Sep 22, 1999 at 1:28 am
  • Hi. There is interest at work in doing some fairly simple inventory control using a database. We've already got Postgres up and running (for obvious reasons) and I was wondering if anyone had ...
    Thomas LockhartThomas Lockhart
    Jul 29, 1999 at 4:20 pm
    Jul 30, 1999 at 6:18 pm
  • This is *not* cool. Breaking both clients and servers, whether they actually support SSL or not, is a bit much, don't you think? Especially when the way you propose to do it makes it impossible for a ...
    Tom LaneTom Lane
    Jul 23, 1999 at 4:25 pm
    Jul 26, 1999 at 10:43 am
  • I did some benchmarks of my Web site and notice I lost some hits which I accumulate in postgres (6.5.1) database on Linux 2.0.36 system Here is what I had before testing - 181 hits for msg_id=1463 ...
    Oleg BartunovOleg Bartunov
    Jul 24, 1999 at 9:48 am
    Jul 26, 1999 at 6:57 am
  • We are not going to trash it, but we *must* evolve how it will be used. (btw, I've taken this on-list per Tom Lane's suggestion; the short summary is that the new bug tracking system is getting ...
    Thomas LockhartThomas Lockhart
    Jul 27, 1999 at 4:52 pm
    Jul 29, 1999 at 2:38 pm
  • I just installed 6.5.1 on my RH 6.0 PII/400 MHz machine. I had previously been running the database on 6.4.2 and had several backups made through pgdump. When I tried to restore the database (i.e. ...
    G. Anthony ReinaG. Anthony Reina
    Jul 28, 1999 at 10:15 pm
    Jul 29, 1999 at 5:55 am
  • Can I have votes on what people want the next version number to be? We have to brand the release when we start development(PG_VERSION file). 6.5 probably should have been called 7.0, but we had ...
    Bruce MomjianBruce Momjian
    Jul 17, 1999 at 4:51 pm
    Jul 19, 1999 at 3:32 pm
  • I have updated the needed files in preparation for 6.5.1. Thomas, release.sgml and install.sgml are ready to be converted to text files. -- Bruce Momjian | http://www.op.net/~candle ...
    Bruce MomjianBruce Momjian
    Jul 10, 1999 at 5:17 pm
    Jul 14, 1999 at 11:39 pm
  • Hi, after I got DBIlogging work, I run several tests and noticed performance degradation when doing sequential updating of *one* row. I have 5 processes updated the same row. I use LOCK TABLE hits IN ...
    Oleg BartunovOleg Bartunov
    Jul 27, 1999 at 1:39 pm
    Jul 28, 1999 at 3:41 am
  • What is the ideal setup to have when contributing to PG development? I can always just download the latest CVS tree, and then presumably run diff when I want to send something in. However, my ...
    Ansley, MichaelAnsley, Michael
    Jul 16, 1999 at 4:13 pm
    Jul 20, 1999 at 3:44 pm
  • Tagged with a release tag of 'REL6_5' ... Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
    The Hermit HackerThe Hermit Hacker
    Jul 22, 1999 at 9:40 am
    Jul 22, 1999 at 9:40 am
  • Me, again... In psql, is the \ that appears before a command supposed to terminate the existing query line (if any), as well as escape the command from the query? It seems that way, because anything ...
    Ansley, MichaelAnsley, Michael
    Jul 20, 1999 at 12:32 pm
    Jul 21, 1999 at 2:44 pm
  • I spent some time today trying to persuade the grammar to accept unadorned array subscripting, ie SELECT arraycolname[2] FROM table; rather than what you have to do in 6.5: SELECT ...
    Tom LaneTom Lane
    Jul 11, 1999 at 10:08 pm
    Jul 15, 1999 at 7:35 am
  • Can someone tell me what the maximum tuple length is? Is it sort of BLCKSZ or BLCKSZ/2? I don't remember if we require the ability to have at least two tuples in a block. -- Bruce Momjian | ...
    Bruce MomjianBruce Momjian
    Jul 3, 1999 at 7:17 pm
    Jul 4, 1999 at 10:32 pm
  • Hi all, I have a question about "explain" output. Could someone teach me ? Let a and b tables such that create table a ( int4 pkey primary key, .... ); create table b ( int4 key1, int2 key2, ...., ...
    Hiroshi InoueHiroshi Inoue
    Jul 14, 1999 at 2:36 am
    Jan 5, 2000 at 7:38 am
  • Is there any autoconf guru? I have lots problems Autoconf + C++ library. if I make CC=CXX, configure can't find libpq, AC_CHECK_LIB(pq, PQexec) because it try link PQexec() - and it is missing if I ...
    Dmitry SamersoffDmitry Samersoff
    Jul 29, 1999 at 12:04 pm
    Jul 29, 1999 at 3:52 pm
  • Hi, testing of DBIlogging to postgres I've got serious problem with performance degradation during updates. In my case I got 15-16 req/sec for the first 1000 updates which drops down to 1-2 req. sec ...
    Oleg BartunovOleg Bartunov
    Jul 28, 1999 at 10:41 am
    Jul 28, 1999 at 4:10 pm
  • Note: Sent to NetBSD and PostgreSQL mailing lists as I am not sure exactly where the problem lies. I am running PostgreSQL 6.5 on a NetBSD system running -current. When I try to include my user ...
    "D'Arcy" "J.M." Cain"D'Arcy" "J.M." Cain
    Jul 25, 1999 at 1:06 pm
    Jul 26, 1999 at 1:32 pm
  • A very useful feature in some database systems is the ability to restrict who can run certain external or stored procedures, and to grant extra access rights to users when they do run those ...
    Philip WarnerPhilip Warner
    Jul 23, 1999 at 11:09 am
    Jul 24, 1999 at 4:34 pm
  • Ok, sorry I see the difference now. Those that are for linking are named lib*.so and those that are for dyn loading into postgres don't have the lib. Good, thanks. Andreas
    Zeugswetter Andreas IZ5Zeugswetter Andreas IZ5
    Jul 16, 1999 at 3:55 pm
    Jul 17, 1999 at 3:33 pm
  • Marc, do you have a release date set? I remember July 15. I know Thomas has to regenerate the INSTALL and HISTORY files. I am glad you did not split the CVS tree. Tom Lane and I are both sitting on ...
    Bruce MomjianBruce Momjian
    Jul 11, 1999 at 3:58 am
    Jul 12, 1999 at 3:32 pm
  • Hi all, There is a TODO item * Overhaul mdmgr/smgr to fix double unlinking and double opens, cleanup In Windows-NT,we could see the following error reported by yutaka tanida [yutaka@marin.or.jp]. ...
    Hiroshi InoueHiroshi Inoue
    Jul 28, 1999 at 5:32 am
    Sep 27, 1999 at 4:07 pm
  • Ryan KirkpatrickRyan Kirkpatrick
    Jul 30, 1999 at 4:59 pm
    Aug 1, 1999 at 4:28 am
  • Todd Vierling (tv@pobox.com) suggested the following test for ELFness. Seems pretty portable to me. Thus spake Todd Vierling (tv@pobox.com) -- D'Arcy J.M. Cain <darcy@{druid|vex}.net | Democracy is ...
    "D'Arcy" "J.M." Cain"D'Arcy" "J.M." Cain
    Jul 27, 1999 at 9:58 pm
    Jul 28, 1999 at 4:16 pm
  • Hi, Well, I got psql to work with arbitrary query string lengths, eventually, by implementing an expandable buffer struct. Unfortunately, I didn't bring the stuff to work today, so it'll only be in ...
    Ansley, MichaelAnsley, Michael
    Jul 26, 1999 at 10:58 am
    Jul 26, 1999 at 3:53 pm
  • Per Leon's recent gripe in the bugs list, I have confirmed that create table t1 (f1 int4, f2 timestamp default text 'now'); does *not* work as expected --- the stored constraint expression has been ...
    Tom LaneTom Lane
    Jul 18, 1999 at 10:20 pm
    Jul 19, 1999 at 3:56 pm
Group Navigation
period‹ prev | Jul 1999 | next ›
Group Overview
grouppgsql-hackers @

109 users for July 1999

Bruce Momjian: 237 posts Tom Lane: 170 posts Thomas Lockhart: 57 posts The Hermit Hacker: 43 posts Oleg Bartunov: 41 posts Jan Wieck: 37 posts Vadim Mikheev: 34 posts Ansley, Michael: 30 posts Leon: 24 posts Hiroshi Inoue: 21 posts Philip Warner: 21 posts Vince Vielhaber: 21 posts Zeugswetter Andreas IZ5: 17 posts Hannu Krosing: 16 posts "D'Arcy" "J.M." Cain: 15 posts Gene Sokolov: 14 posts Mark Hollomon: 14 posts Ross J. Reedstrom: 14 posts Ryan Kirkpatrick: 14 posts : 13 posts
show more