FAQ

PostgreSQL > pgsql-hackers > July 1998

Search Discussions

121 discussions - 482 posts

  • 61

    cidr

    i didn't realize that anybody else was working on an IP address data type or i'd've posted this six months ago when i first wrote it. it lacks only the stuff needed to make it usable as a UNIQUE KEY. ...
    Paul A VixiePaul A Vixie
    Jul 19, 1998 at 7:27 pm
    Aug 11, 1998 at 8:59 pm
  • I said the days would be fewer, not gone. -- Bruce Momjian | 830 Blythe Avenue maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026 + If your life is a hard drive, | (610) 353-9879(w) + Christ ...
    Bruce MomjianBruce Momjian
    Jul 15, 1998 at 2:44 pm
    Sep 19, 1999 at 2:57 pm
  • (I'm back on-line, I think...) I committed several changes to the development source tree this morning (~15 hours ago). The changes affect the following areas: 1) There is an 8-byte integer data ...
    Thomas G. LockhartThomas G. Lockhart
    Jul 9, 1998 at 5:38 am
    Jul 15, 1998 at 5:04 pm
  • I have succeeded in making OR clauses use indexes. I have not dealt with some of the more complex issues like x=3 or y=5 as Vadim mentioned, but at least it works. test= select * from test where ...
    Bruce MomjianBruce Momjian
    Jul 31, 1998 at 5:32 am
    Aug 1, 1998 at 1:21 am
  • Hi, compilation of the current snapshot 4137013 Jul 25 07:02 postgresql.snapshot.tar.gz dies on linux with the following error: make[2]: Entering directory ...
    Edmund MerglEdmund Mergl
    Jul 25, 1998 at 7:21 pm
    Jul 28, 1998 at 10:07 am
  • Dear PostgreSQL gurus, first of all, many thanks to everyone involved in writing and enhancing PostgreSQL! It has grown enourmously during the last months and is a most impressive system. Sorry if ...
    Ernst MolitorErnst Molitor
    Jul 29, 1998 at 3:04 pm
    Aug 2, 1998 at 9:56 am
  • Ok, I'm not sure that LLL will appear in 6.4 but it's good time to discuss about it. First, PostgreSQL is multi-version system due to its non-overwriting storage manager. And so, first proposal is ...
    Vadim MikheevVadim Mikheev
    Jul 15, 1998 at 11:47 pm
    Jul 27, 1998 at 6:16 pm
  • Hello Sorry for asking the hackers directly, but I think my question will be very implementation specific so I think only one of yor can give me the answer or thow me out the door. First some ...
    Dr. Armin SchloesserDr. Armin Schloesser
    Jul 8, 1998 at 7:37 am
    Jul 10, 1998 at 8:15 am
  • Things I'd like to see get in there before 6.4: 1. On HPUX, the new no-exec method of starting the backend means that all the backends claim to be "postmaster"; there's no way to tell 'em apart via ...
    Tom LaneTom Lane
    Jul 8, 1998 at 11:26 pm
    Aug 22, 1998 at 3:31 am
  • This is said in Oracle7 Server Concepts Manual, Data Concurrency, Additional Considerations for Serializable Isolation: --- Both read committed and serializable transactions use row-level locking, ...
    Vadim MikheevVadim Mikheev
    Jul 14, 1998 at 11:05 am
    Jul 30, 1998 at 7:41 pm
  • With fairly current sources (last cvs update on 7/20), I am seeing occasional occurrences of NOTICE: Non-functional update, only first update is performed I think this is a bug. The update commands ...
    Tom LaneTom Lane
    Jul 25, 1998 at 11:38 pm
    Jul 30, 1998 at 1:17 am
  • Is there an HPUX port of Postgres SQL ? Hi, David
    Davide LibenziDavide Libenzi
    Jul 13, 1998 at 2:14 pm
    Jul 14, 1998 at 2:11 pm
  • Hi, I was having trouble with user authentication, so I submerged myself in the source (UTSL ie. Use The Source luke ;) to see if I could figure out what I was doing wrong: While using passwords ...
    Maarten BoekholdMaarten Boekhold
    Jul 31, 1998 at 7:23 pm
    Aug 2, 1998 at 7:55 pm
  • DROP INDEX fails on overlength table names: tgl= CREATE UNIQUE INDEX MarketOrderHistory_sequenceNo_Index tgl- ON MarketOrderHistory USING btree (sequenceNo); CREATE tgl= DROP INDEX ...
    Tom LaneTom Lane
    Jul 26, 1998 at 3:10 pm
    Aug 29, 1998 at 2:57 am
  • We should develop (or at least prominently promote _and_ document) some kind of file/package format or tool (maybe like illustra datablades), that would standardize the layout of contrib types. Also, ...
    Hannu KrosingHannu Krosing
    Jul 21, 1998 at 3:08 pm
    Jul 21, 1998 at 4:36 pm
  • I am trying to finish off my Python interface with some extra helper functions and I need to find the primary key in a table if it exists. I have two questions. Although I can't imagine doing so, ...
    D'Arcy J.M. CainD'Arcy J.M. Cain
    Jul 20, 1998 at 1:22 pm
    Jul 21, 1998 at 1:33 pm
  • I want to remove the recipe, tioga, and Tee node code from the system. They are all interdependant. I don't believe any of the code is useful. It was designed for a special tioga application that ...
    Bruce MomjianBruce Momjian
    Jul 19, 1998 at 10:30 am
    Jul 19, 1998 at 7:00 pm
  • I still cannot get postgres 6.3.2 libpq to build under Solaris 2.6 ... this means I can't test any of my apps using postgres on my deployment platform. can anyone help? gcc version 2.7.2.3 looks like ...
    De ClarkeDe Clarke
    Jul 2, 1998 at 9:45 pm
    Jul 3, 1998 at 7:49 am
  • Hi, Below is an example of my query, which returns no plan and produces FATAL 1: palloc failure: memory exhausted while postgres 'eats' almost 113 Mb of RAM. This happens with pgsql 6.3.2+patches ...
    Oleg BartunovOleg Bartunov
    Jul 30, 1998 at 11:52 pm
    Jul 31, 1998 at 2:27 am
  • I tried the following to find out whether a table has any records with field1 < X (for a constant X): tgl= SELECT EXISTS(SELECT * FROM table WHERE field1 < X); ERROR: internal error: do not know how ...
    Tom LaneTom Lane
    Jul 14, 1998 at 10:33 pm
    Jul 15, 1998 at 4:02 am
  • Jan, I remember you steering away from rewrite cleanups because we were so close to 6.3. Any chance you can make those changes for 6.4, or are you already working on them? We really need cleanup in ...
    Bruce MomjianBruce Momjian
    Jul 5, 1998 at 12:01 am
    Aug 12, 1998 at 8:51 am
  • Do you mean using two indices in one access plan, or the decision which index to use ? I think the case Bruce has fixed was the most important for those "alien MS Access users" among us. Thanks Bruce ...
    Andreas ZeugswetterAndreas Zeugswetter
    Jul 31, 1998 at 8:53 am
    Aug 1, 1998 at 5:14 am
  • I've just noticed that libpq doesn't cope very gracefully if the backend exits when not in the middle of a query (ie, because the postmaster told it to quit after some other BE crashed). The behavior ...
    Tom LaneTom Lane
    Jul 28, 1998 at 5:23 pm
    Jul 29, 1998 at 3:02 pm
  • After a lot of changes I've compiled,linked and tested (regression) my PostgreSQL installation no HPUX 9.*. I've also built and installed the ODBC driver and I get Ms Access error which the ...
    Davide LibenziDavide Libenzi
    Jul 23, 1998 at 5:02 pm
    Jul 23, 1998 at 8:14 pm
  • Hi David. Do you have access to the latest cvs development tree for Postgres? I'm seeing backend crashes from the "junkfilter" regression test, and have been for some time. I (just this morning) ...
    Thomas G. LockhartThomas G. Lockhart
    Jul 9, 1998 at 4:42 am
    Jul 19, 1998 at 4:30 am
  • ... because the conditional structure assumes that pgsql will only be built with non-gcc compilers on HPUX. This is an entirely bogus assumption not only for HPUX, but for any other architecture that ...
    Tom LaneTom Lane
    Jul 6, 1998 at 8:03 pm
    Jul 18, 1998 at 3:00 pm
  • Hmm. I find that SIGUSR1 and SIGUSR2 are both already in use for communication between backends. We can't really commandeer SIGURG, either, because it's apparently the same as SIGUSR1 on SCO (see ...
    Tom LaneTom Lane
    Jul 6, 1998 at 10:18 pm
    Jul 9, 1998 at 9:20 pm
  • Yes, master would be a better name than template1. -- Bruce Momjian | 830 Blythe Avenue maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026 + If your life is a hard drive, | (610) 353-9879(w) ...
    Bruce MomjianBruce Momjian
    Jul 24, 1998 at 4:32 pm
    Jul 24, 1998 at 8:20 pm
  • Backends fetch 1024 XIDs now and place them in shmem. There is space in VariableCache struct for OIDs as well but I didn't change GetNewObjectId() due to the CheckMaxObjectId() stuff... Bruce ? All ...
    Vadim MikheevVadim Mikheev
    Jul 21, 1998 at 6:31 am
    Jul 21, 1998 at 5:46 pm
  • Enybody knows as to receive the information about the users transmitting inquiries as: - username, - string of sql-request, transmitted by him. Thank you for your answer.
    Alexzander BlashkoAlexzander Blashko
    Jul 6, 1998 at 9:29 am
    Jul 21, 1998 at 4:17 am
  • The weekend's hacking on s_lock.h broke it for all platforms that need non-default definitions of S_UNLOCK or S_INIT_LOCK (hpux, alpha, a couple others). Someone put unconditional definitions of ...
    Tom LaneTom Lane
    Jul 20, 1998 at 5:12 pm
    Jul 20, 1998 at 7:43 pm
  • It looks to me like pgsql-announce has found its way onto the spammers' target lists. Since the announce list was switched to unmoderated status at the beginning of May, my mail logs show its traffic ...
    Tom LaneTom Lane
    Jul 16, 1998 at 3:54 pm
    Jul 17, 1998 at 2:38 pm
  • I'm almost back on-line (I hope) after massive hacker activity took out the alumni pop server at Caltech. From looking through the hackers mhonarc archive (hmm, don't much like that name "hackers" ...
    Thomas G. LockhartThomas G. Lockhart
    Jul 7, 1998 at 3:09 pm
    Jul 7, 1998 at 11:04 pm
  • I have applied this fine patch to allow WIN32 compiles of libpq. Nice job, and a good feature for us. -- Bruce Momjian | 830 Blythe Avenue maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026 ...
    Bruce MomjianBruce Momjian
    Jul 3, 1998 at 4:30 am
    Jul 3, 1998 at 4:22 pm
  • Can an SQL database (PostgreSQL) be connected to shell in a way that if a directory is changed on shell it will update the database with the changes? If so how? A prompt reply would be appreciated. ...
    Gregory HolstonGregory Holston
    Jul 1, 1998 at 2:13 pm
    Jul 1, 1998 at 4:40 pm
  • New 6.4 psql help will show: test= \h select Command: select Description: retrieve tuples Syntax: SELECT [DISTINCT [ON attrN]] expr1 [AS attr1], ...exprN [INTO [TABLE] class_name] [FROM from_list] ...
    Bruce MomjianBruce Momjian
    Jul 25, 1998 at 12:18 am
    Jul 25, 1998 at 4:04 am
  • I've successfully ported PostgreSQL to HPUX 9.0.* but there is a strange behaviour with the datetime data type. If do do this sequence : $ createdb mydb [OK] $ psqk mydb mydb== create table foo (ffoo ...
    Davide LibenziDavide Libenzi
    Jul 23, 1998 at 12:45 pm
    Jul 23, 1998 at 4:56 pm
  • I need in help: let's say you have serialized transaction in one session... Now, some other user drops a table that was in data base when serialized transaction began but does it before this ...
    Vadim MikheevVadim Mikheev
    Jul 23, 1998 at 3:50 am
    Jul 23, 1998 at 6:59 am
  • I have found cvs creating many directories that I know were removed from the source tree. I now use the -P option to cvs update/checkout to prevent this from happening. -P Prune (remove) directories ...
    Bruce MomjianBruce Momjian
    Jul 20, 1998 at 8:45 pm
    Jul 21, 1998 at 3:14 pm
  • After shying away from the Linux platform for several months, Informix Corp. will do an about face at its international users conference in Seattle this week. Archrival Oracle Corp. is expected to ...
    Thomas G. LockhartThomas G. Lockhart
    Jul 21, 1998 at 5:15 am
    Jul 21, 1998 at 12:06 pm
  • Hello, Sorry to disturb the hacker list for a question that seems not so hard. But I got no answers elsewhere... Is is definitively impossible to use C++ to define new SQL functions or operators in ...
    David GrossDavid Gross
    Jul 17, 1998 at 8:59 am
    Jul 20, 1998 at 2:48 pm
  • I have applied this fine patch from Stephan. It fixes many problems with Having, and some other problems that exist. Vadim, can you check on the psort_end() issue, and see where that should go. I am ...
    Bruce MomjianBruce Momjian
    Jul 19, 1998 at 5:49 am
    Jul 19, 1998 at 10:06 am
  • Hi all, I got strange result with PQgetisnull, say for empty table(I think that it's empty so null) I guess that after fetch some selection PQgetisnull(result, 0, 0) should give me "1 or true" But it ...
    Park, Chul-SuPark, Chul-Su
    Jul 16, 1998 at 8:06 am
    Jul 16, 1998 at 3:51 pm
  • I'm planning to use a "sequence" object to allow multiple clients of a shared database to label table records with guaranteed-increasing serial numbers. (The underlying problem is to let all the ...
    Tom LaneTom Lane
    Jul 13, 1998 at 8:30 pm
    Jul 13, 1998 at 10:02 pm
  • Well, I've got this new code running, and it works. Sort of. The postmaster and backend seem to be fine ... but psql has a tendency to coredump right after sending a cancel request. After digging ...
    Tom LaneTom Lane
    Jul 7, 1998 at 10:56 pm
    Jul 8, 1998 at 1:56 pm
  • does anyone have any idea how difficult it would be to implement, and perhaps point me in the right direction?
    Brett McCormickBrett McCormick
    Jul 3, 1998 at 2:33 am
    Jul 3, 1998 at 4:08 am
  • select max(ccorderseq) from ccorder; max --- 603 (1 row) icv= select * From the_view where ccorderseq = 603; [ I get the row back ] select * From the_view where ccorderseq = (select max(ccorderseq) ...
    Brett McCormickBrett McCormick
    Jul 23, 1998 at 2:03 am
    Aug 22, 1998 at 4:24 am
  • I. First, we need not in long-term page/row locking unlike systems using locks for concurrency/consistency control. All what we need we already have: xmax. When UPDATE/DELETE will like to change row ...
    Vadim MikheevVadim Mikheev
    Jul 30, 1998 at 6:28 pm
    Jul 31, 1998 at 2:46 am
  • Hi David. I see that Informix now has a no-cost developers version of a database available for Linux (Informix-SE; sounds sort of light-weight). I am planning on installing it to see what it can do ...
    Thomas G. LockhartThomas G. Lockhart
    Jul 29, 1998 at 2:51 pm
    Jul 29, 1998 at 4:33 pm
  • I have posted to the general news group but need a more definitive response. I am running Postgresql 6.1 on SunOS 5.5.1. We are presently looking into upgrading to Postgresql 6.3.2, but are having a ...
    J Christopher BowerJ Christopher Bower
    Jul 27, 1998 at 3:32 pm
    Jul 28, 1998 at 2:42 pm
Jul 1998
123
Group Navigation
period‹ prev | Jul 1998 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions121
posts482
users75
websitepostgresql.org...
irc#postgresql

75 users for July 1998

Bruce Momjian: 146 posts Tom Lane: 53 posts Vadim Mikheev: 37 posts The Hermit Hacker: 23 posts Thomas G. Lockhart: 20 posts D'Arcy J.M. Cain: 11 posts Dr. Michael Meskes: 11 posts Hannu Krosing: 11 posts Tatsuo Ishii: 11 posts Vince Vielhaber: 11 posts Paul A Vixie: 10 posts Peter T Mount: 9 posts Thomas G. Lockhart: 9 posts David Gould: 8 posts Andreas Zeugswetter: 7 posts Davide Libenzi: 6 posts Brett McCormick: 5 posts David Hartwig: 5 posts Matthew N. Dodd: 4 posts Oleg Bartunov: 4 posts
show more
Archives