FAQ

PostgreSQL > pgsql-hackers > November 1998

Search Discussions

156 discussions - 600 posts

  • CORBA in fifty words or less: CORBA is an architecture which specifies how to: - define the method signatures of an object type - obtain a reference to a object instance - invoke a method, with ...
    Michael RobinsonMichael Robinson
    Nov 13, 1998 at 5:20 pm
    Nov 17, 1998 at 8:55 pm
  • It seems that we have a small problem with the operators and functions in the inet and cidr types. If the value in a field is null then the backend crashes when you try to apply one of the operators ...
    D'Arcy J.M. CainD'Arcy J.M. Cain
    Nov 1, 1998 at 6:19 pm
    Jan 7, 1999 at 12:38 pm
  • Tomorrow afternoon, at ~5pm ADT, I will be tag'ng and releasing v6.4 to the world *muhahahaha* Any last minute "no, don't do it" naysayers out there? :) Marc G. Fournier Systems Administrator @ ...
    The Hermit HackerThe Hermit Hacker
    Nov 3, 1998 at 9:29 pm
    Dec 12, 1998 at 8:03 pm
  • RedHat 5.1 i386 with PostgreSQL v6.4 final version ./configure --with-tcl after installing libpgtcl , cannot run pgaccess because library crypt hasn't been linked into libpgtcl.so must manually add ...
    Constantin TeodorescuConstantin Teodorescu
    Nov 5, 1998 at 4:50 pm
    Dec 7, 1998 at 1:57 pm
  • It seems that full support for CORBA and the COS Query Service requires us to enable the user to parse, prepare, and execute the query in three separate stages. Are we also planning to support ...
    TaralTaral
    Nov 16, 1998 at 8:19 pm
    Nov 19, 1998 at 6:13 pm
  • I think this is a bug in 6.4: bray= select rcname, rcsrc from pg_relcheck where rcrelid = '115404'::oid and rcrelid in (select min(rcrelid) from pg_relcheck group by rcname); ERROR: parser: Subselect ...
    Oliver ElphickOliver Elphick
    Nov 23, 1998 at 5:18 pm
    Dec 5, 1998 at 10:31 pm
  • hi. I hope this is not a rehash of anything; a quick look at the mailing list archives turned up similar, but not identical stories. When I use the "-z" option (dump permissions)when dumping a ...
    Karl AuerKarl Auer
    Nov 24, 1998 at 3:49 pm
    Nov 25, 1998 at 2:58 am
  • Hi, I have run into a problem dropping and re-creating tables with type SERIAL: CREATE TABLE t ( s SERIAL); DROP TABLE t; CREATE TABLE t ( s SERIAL); gives ERROR: t_s_seq relation already exists This ...
    Jan IvenJan Iven
    Nov 27, 1998 at 3:21 pm
    Dec 13, 1998 at 3:49 am
  • It appears that when a function is called if any of the paramaters are NULL all of the parameters are NULL. try: drop function nvl(int, int); create function nvl(int, int) returns boolean as ' ...
    Jackson, DeJuanJackson, DeJuan
    Nov 4, 1998 at 7:51 pm
    Nov 11, 1998 at 3:15 pm
  • With the initial positive response, I dived into the CORBA spec, the ORBit source, and the PostgreSQL source. I have good news to report. - CORBA and PostgreSQL were made for each other. The ...
    Michael RobinsonMichael Robinson
    Nov 13, 1998 at 5:37 am
    Nov 14, 1998 at 5:38 pm
  • Thus spake Jan Wieck Well, this is the first example that I have seen that wouldn't work unless a function with a null argument actually called the function but you do realize that this wouldn't work ...
    D'Arcy J.M. CainD'Arcy J.M. Cain
    Nov 3, 1998 at 2:06 pm
    Nov 4, 1998 at 1:00 pm
  • Hi, here are some details I would like to discuss before beeing too deep in the implementation that it's hard to change them later. Point 1 is an extension of the pg_database relation that is ...
    Jan WieckJan Wieck
    Nov 27, 1998 at 9:10 pm
    Dec 18, 1998 at 12:55 am
  • Terry MackintoshTerry Mackintosh
    Nov 15, 1998 at 6:22 pm
    Dec 14, 1998 at 5:13 am
  • I've never actually installed mysql, so can't really compare the two, but I've been using PostgreSQL for everything I need an RDBMS for since I first took on the project 3 years ago now (wow, time ...
    The Hermit HackerThe Hermit Hacker
    Nov 27, 1998 at 12:55 pm
    Dec 1, 1998 at 11:29 pm
  • prova= select * from a; int_2| int_4| int_8 -----+----------+------------------- 32767|2147483647|9223372036620802086 32767|2147483647|9223372036620802086 (2 rows) prova= select avg(int_2), ...
    José SoaresJosé Soares
    Nov 3, 1998 at 8:24 am
    Dec 8, 1998 at 6:40 am
  • Hi I have the following problem using PostgreSQL 6.4 on RedHat Linux 5.1 on x86 using the following table thplus= \d envelope Table = envelope ...
    Hannu KrosingHannu Krosing
    Nov 18, 1998 at 7:24 pm
    Nov 24, 1998 at 4:15 am
  • Morning all... Well, v6.4 is branched and in a "released state"...those wanting to start moving on, go for it. Those with committer's access to the source tree, Thomas and I are working up docs for ...
    The Hermit HackerThe Hermit Hacker
    Nov 4, 1998 at 11:50 pm
    Nov 6, 1998 at 12:09 pm
  • Until earlier this week, the various snapshots have been working fine on my system, NetBSD 1.3.2/i386. As of a couple of days ago the backend started to crash. I hoped this was a temporary glitch ...
    Brook MilliganBrook Milligan
    Nov 1, 1998 at 4:09 pm
    Nov 2, 1998 at 11:40 am
  • Hi. I've been doing some more tests with the above configuration, and have noticed the following problems when running the regression tests: 1) THE REGRESSION TEST FOR FLOAT8 IS BROKEN!!! Indeed, the ...
    Pedro J. LoboPedro J. Lobo
    Nov 18, 1998 at 6:09 pm
    Nov 24, 1998 at 3:56 pm
  • I am getting signal 10/bus error on cvs checkouts. Looks like others are having the same problem. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your ...
    Bruce MomjianBruce Momjian
    Nov 23, 1998 at 6:14 am
    Nov 24, 1998 at 5:57 am
  • I've been banging and banging my head against the specific problem of how to tightly couple the object-relational part of postgres with the object- list processing part of Python. In the midst of ...
    Michael RobinsonMichael Robinson
    Nov 11, 1998 at 5:33 am
    Nov 12, 1998 at 5:56 pm
  • Does this remove the need for vsnprintf? -- 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 be ...
    Bruce MomjianBruce Momjian
    Nov 8, 1998 at 9:44 pm
    Dec 12, 1998 at 9:03 pm
  • Hi all I'm working on writing a search engine, and need a branching linked list, or tree. When I did the message board there was a similar need which was over come at the application level. But I ...
    Terry MackintoshTerry Mackintosh
    Nov 17, 1998 at 12:39 pm
    Nov 24, 1998 at 1:39 pm
  • Hi all Minor detail, but when I did 'pg_dump -z -f dump.file dbname' and then went to restore it, I found that the grant statments are like: GRANT ALL on "tablename" to "tablename"; instead of GRANT ...
    Terry MackintoshTerry Mackintosh
    Nov 15, 1998 at 4:23 am
    Nov 15, 1998 at 10:08 pm
  • Do any of you sit on IRC somewhere? Sometimes I feel like the discussions would be smoother/faster with real-time... I'm on efnet all the time (as Taral, of course :) Taral
    TaralTaral
    Nov 15, 1998 at 3:26 am
    Nov 15, 1998 at 6:05 pm
  • The attached commands crash the backend, which exits with status 11. The backend log (debug level 255) does not show anything that is meaningful to me. It shows a query, which seems to relate to the ...
    Oliver ElphickOliver Elphick
    Nov 4, 1998 at 1:12 pm
    Nov 4, 1998 at 10:14 pm
  • I'm going to remove subj... buf_internals.h: /* * I padded this structure to a power of 2 (PADDED_SBUFDESC_SIZE) * because BufferDescriptorGetBuffer is called a billion times and it * does an C ...
    Vadim MikheevVadim Mikheev
    Nov 30, 1998 at 5:07 am
    Dec 2, 1998 at 1:39 am
  • I apologize. pgsql-questions has disappeared? (out of the loop, I am)
    IntegrationIntegration
    Nov 25, 1998 at 6:37 am
    Dec 1, 1998 at 11:29 pm
  • This thing would also handled by subqueries in FROM! Having support in planner/executor for queries like this: select * from A, (select c, max(d) as m from B group by c) SQ where SQ.c = A.x and SQ.m ...
    Vadim MikheevVadim Mikheev
    Nov 24, 1998 at 2:08 pm
    Dec 1, 1998 at 5:38 am
  • I changed some minor stuff in Thomas Good's man page for ecpg and would like to see this one replace the man page for ecpg we currently have in CVS. It's attached. Or should this one go to patches ...
    Michael MeskesMichael Meskes
    Nov 28, 1998 at 2:56 pm
    Dec 14, 1998 at 6:50 pm
  • Hi, while on the redolog, I've came across a little detail I'm in doubt about. Currently it seems, that the 'C' response to the frontend is sent before the transaction get's really committed in the ...
    Jan WieckJan Wieck
    Nov 30, 1998 at 4:29 pm
    Dec 13, 1998 at 7:33 pm
  • Hi all OK, just built 6.4, a couple of things ... :) When I did make all runtest for the regression tests, I guess stderr used to be sent to /dev/null? but now it goes to the screen with *LOTS* of ...
    Terry MackintoshTerry Mackintosh
    Nov 8, 1998 at 1:16 am
    Dec 12, 1998 at 8:57 pm
  • Pardon the message, I received no responses in the other pgsql lists I posted this too. I'm using a fully updated RedHat 5.1 box flex version 2.5.4 GNU Bison version 1.25 ---------- Forwarded message ...
    Dkelson-list-pgsql-hackersDkelson-list-pgsql-hackers
    Nov 17, 1998 at 1:43 am
    Nov 17, 1998 at 6:41 pm
  • Hello! A background postgres porocess gets larger with Abort Transactions. Memory seems to leak. This occurs also on 6.3.2. You can see it with user aborts: ...
    SHIOZAKI TakehikoSHIOZAKI Takehiko
    Nov 13, 1998 at 1:39 am
    Dec 13, 1998 at 3:45 am
  • Hi, I'm currently hacking around on a solution for logging all database operations at query level that can recover a crashed database from the last successful backup by redoing all the commands. ...
    Jan WieckJan Wieck
    Nov 13, 1998 at 6:21 pm
    Dec 12, 1998 at 10:40 pm
  • Dear all, I have some difficult time in using postgresql 6.4 with chinese BIG5 characters. I am just looking for storing BIG characters in a text field and retrieve correctly. I have --enable-mb when ...
    Hui Chun Kit, JackyHui Chun Kit, Jacky
    Nov 21, 1998 at 6:35 pm
    Dec 3, 1998 at 1:35 am
  • Hi all CREATE RULE "_RETmessages" AS ON SELECT TO "messages" DO INSTEAD SELECT "title", "mess", "iurl", "lurl", "posted", "fname", "lname", "email", "uid", "ppid", "pid", "bid" FROM "post", "users" ...
    Terry MackintoshTerry Mackintosh
    Nov 25, 1998 at 5:11 pm
    Nov 25, 1998 at 5:59 pm
  • Still trying to fix the bug with inherited check constraints... I have tried to create a min(oid) aggregate, but when I use it, I get the message `ERROR: fmgr_info: function 108994: cache lookup ...
    Oliver ElphickOliver Elphick
    Nov 20, 1998 at 11:30 pm
    Nov 25, 1998 at 12:18 pm
  • Just noticed that doc/FAQ_Linux and doc/FAQ_Irix have been zero-length files in the CVS repository since the end of August. They're also that way in the 6.4 distribution tarball. There are still ...
    Tom LaneTom Lane
    Nov 22, 1998 at 9:51 pm
    Nov 24, 1998 at 3:50 am
  • hi! I just checked postgres 6.4 and I have to tell you it was a great work!!! it's 3-4 times faster than 6.3.2 was. more stable. I have a little question: the TEXT fieldtype how many data can store? ...
    Zsolt VargaZsolt Varga
    Nov 13, 1998 at 8:30 am
    Nov 21, 1998 at 11:15 am
  • Since we're supposedly an "object relational database", is there any chance we might be able to move towards supporting OQL93? Taral
    TaralTaral
    Nov 16, 1998 at 3:02 am
    Nov 17, 1998 at 6:13 pm
  • I've gotten part-way toward implementing a CASE construct in Postgres: select case when i = 1 then 10 when i = 2 then 20 end from t; (the other parts of the case clause are supported also). But I'm ...
    Thomas G. LockhartThomas G. Lockhart
    Nov 12, 1998 at 5:49 am
    Nov 13, 1998 at 10:56 am
  • 6.4 allows to use ORDER BY with a column that does not appear in a target list. This is great. However, following result seems strange to me. Sometimes DISTINCT does not remove duplication. Is this ...
    Tatsuo IshiiTatsuo Ishii
    Nov 7, 1998 at 11:53 pm
    Dec 12, 1998 at 8:35 pm
  • Hi all I started with the contrib/spi/*.c stuff and am working toward a function to be used by a trigger to update a datetime field upon doing an UPDATE to a record. It is about ready to test, except ...
    Terry MackintoshTerry Mackintosh
    Nov 6, 1998 at 7:25 pm
    Dec 12, 1998 at 8:21 pm
  • Hi, The subject says all. Regards, Ole Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, ...
    Oleg BartunovOleg Bartunov
    Nov 29, 1998 at 8:36 pm
    Nov 30, 1998 at 4:09 am
  • Hi all, I have a strange behavior while copying from a text file, I don't know if this will be considered a bug or a feature. I have this text file: ------------------------ XXX|QWERTYUIOPASDFGHJKLA ...
    Sferacarta SoftwareSferacarta Software
    Nov 27, 1998 at 2:32 pm
    Nov 27, 1998 at 7:17 pm
  • I noticed that when installing postgres the following directory is formed: ~pgsql/include/port/bsd (presumably the bsd changes with the port upon which it's compiled). This is created as part of the ...
    Brook MilliganBrook Milligan
    Nov 10, 1998 at 3:34 pm
    Nov 10, 1998 at 9:14 pm
  • I brought my snapshot up-to-date this morning, recompiled everything and tried to connect to my test database that is about a month old. I can ´select * from pg_attribute´ without a problem. But ...
    Michael MeskesMichael Meskes
    Nov 4, 1998 at 11:08 am
    Nov 5, 1998 at 6:55 pm
  • I'm currently experimenting with the Debian packaging of 6.4. The question arises of how to handle the change in library versions from 1.0 to 2.0. It has been suggested that I should keep libpq.so.1 ...
    Oliver ElphickOliver Elphick
    Nov 4, 1998 at 12:10 am
    Nov 4, 1998 at 3:01 pm
  • This was reported as a bug with the Debian package of 6.3.2; the same behaviour is still present in 6.4. bray= create table foo ( t text[]); CREATE bray= insert into foo values ( '{"a"}'); INSERT ...
    Oliver ElphickOliver Elphick
    Nov 25, 1998 at 11:48 pm
    May 31, 2000 at 9:19 pm
Nov 1998
1234
Group Navigation
period‹ prev | Nov 1998 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions156
posts600
users98
websitepostgresql.org...
irc#postgresql

98 users for November 1998

The Hermit Hacker: 62 posts Tom Lane: 60 posts Thomas G. Lockhart: 58 posts Bruce Momjian: 51 posts Michael Meskes: 34 posts Jan Wieck: 29 posts Terry Mackintosh: 25 posts D'Arcy J.M. Cain: 23 posts Oliver Elphick: 17 posts Constantin Teodorescu: 14 posts Hannu Krosing: 13 posts Taral: 13 posts Vadim Mikheev: 13 posts A James Lewis: 8 posts Michael Robinson: 8 posts Brook Milligan: 7 posts Jackson, DeJuan: 7 posts Sferacarta Software: 7 posts 송기원: 6 posts Oleg Bartunov: 6 posts
show more
Archives