FAQ

Search Discussions

186 discussions - 856 posts

  • If anyone has been watching my trials and tribulations building and running the latest CVS snapshot under S/Linux on a SUN SPARCstation IPX. The latest position is:- If I compile with optimization ...
    Keith ParksKeith Parks
    Aug 29, 1998 at 6:29 pm
    Sep 3, 1998 at 2:56 am
  • With the 6.4 beta just over a week away, here are the open items I see for 6.4. We actually have fewer than usual, so that is a good thing. Many of the latter ones are fairly rare bugs. ...
    Bruce MomjianBruce Momjian
    Aug 24, 1998 at 2:08 am
    Sep 23, 1998 at 3:03 am
  • Let me ask about type coersion. When you have an int2 column called x, how do you place the conversion functions when it is being compared to an in4 constant? x = int2(500) int4(x) = 500 The first is ...
    Bruce MomjianBruce Momjian
    Aug 8, 1998 at 7:00 am
    Aug 23, 1998 at 10:27 pm
  • Is this a bug that the index doesn't work on floats or is it a datatype mismatch thing? ----- template1= create table foo (x float4, y float4); CREATE template1= create index foox on foo(x); CREATE ...
    Vince VielhaberVince Vielhaber
    Aug 3, 1998 at 12:26 am
    Aug 7, 1998 at 6:07 am
  • I did a cvsup and a fresh recompile this morning. But I still get ERROR: fmgr_info: function 683: cache lookup failed from initdb. Guess I have to dig into it more deeply. Is anyone else running ...
    Michael MeskesMichael Meskes
    Aug 20, 1998 at 5:47 pm
    Aug 28, 1998 at 3:48 am
  • backend/libpq/pgcomm.c no longer compiles on my system. The cvs log sez Massimo Dal Zotto <dz@cs.unitn.it flock is *VERY* far from portable. I am aware of three or four different, mutually ...
    Tom LaneTom Lane
    Aug 30, 1998 at 5:42 am
    Oct 30, 1998 at 8:20 pm
  • vacuum still doesn't work for me. I did a regresion test and found the sanity_check test failed. The result shows that the backend died while doing vacuum. I destroyed and re-created the regression ...
    Tatsuo IshiiTatsuo Ishii
    Aug 25, 1998 at 9:59 am
    Aug 30, 1998 at 12:18 am
  • I am working on a patch to: remove oidname, oidint2, and oidint4 allow the bootstrap code to create multi-key indexes change procname index to procname, nargs, argtypes remove many sequential scans ...
    Bruce MomjianBruce Momjian
    Aug 16, 1998 at 2:33 pm
    Aug 24, 1998 at 4:18 am
  • Well, initdb doesn't give the same errors, but it's still failing. Now it's just saying: initdb: could not create template database initdb: cleaning up by wiping out ...
    Peter T MountPeter T Mount
    Aug 2, 1998 at 9:54 am
    Aug 26, 1998 at 4:44 pm
  • Hello! I've written the SPI procedure which allows to delete large objects referenced by currently deleted or updated tuples. I tested it with PostgreSQL v6.3.2 and seem it works. If PostgreSQL ...
    Sergey E. LevovSergey E. Levov
    Aug 5, 1998 at 2:24 pm
    Aug 23, 1998 at 8:00 pm
  • While testing my 6.4 patch to allow functions/expressions to be specified in the ORDER/GROUP BY clause (and not in the target list) I came across a nasty little bug. A segmentation fault gets thrown ...
    David HartwigDavid Hartwig
    Aug 1, 1998 at 1:43 pm
    Sep 8, 1998 at 8:29 am
  • I found that current pg_dump command produces wrong output if a table name includes upper letters (See below). in bin/pg_dump.c: sprintf(q, "CREATE TABLE \"%s\" (", fmtId(tblinfo[i].relname)); Here ...
    T-ishiiT-ishii
    Aug 18, 1998 at 5:01 am
    Sep 1, 1998 at 5:01 am
  • Hi. A month or two ago I put an int8 data type into Postgres. Aside from being useful on its own, it could also form the basis for other types needing extended range, such as money, decimal, and ...
    Thomas G. LockhartThomas G. Lockhart
    Aug 14, 1998 at 3:39 pm
    Aug 24, 1998 at 1:11 am
  • Bruce, I'll send the patch itself directly to you. It's a bigger one and I don't want to waste bandwidth on the list. Would you please apply that one and forget the two others I posted recently? The ...
    Jan WieckJan Wieck
    Aug 21, 1998 at 2:25 pm
    Aug 27, 1998 at 8:51 pm
  • Hi, got a lot of things working up to now. Most things on the relation level are fixed now, including qualified instead rules. Update rules can now correctly refer to *new* and *current*. Must check ...
    Jan WieckJan Wieck
    Aug 15, 1998 at 11:39 pm
    Aug 25, 1998 at 3:17 am
  • Attached is a patch that uses autoconf to determine whether there is a working 64-bit-int type available. In playing around with it on my machine, I found that gcc provides perfectly fine support for ...
    Tom LaneTom Lane
    Aug 16, 1998 at 8:57 pm
    Aug 23, 1998 at 10:30 pm
  • On Friday I asked. Since then I have downloaded the most current sources and I still get this problem. Am I the only one seeing this? -- D'Arcy J.M. Cain <darcy@{druid|vex}.net | Democracy is three ...
    D'Arcy J.M. CainD'Arcy J.M. Cain
    Aug 11, 1998 at 9:13 pm
    Aug 13, 1998 at 4:14 pm
  • I've just run CVS UPDATE again, in another attempt to get initdb to run. Anyhow, I noticed that there was a message saying that there were conflicts. Any ideas? -- Peter T Mount peter@retep.org.uk or ...
    Peter T MountPeter T Mount
    Aug 5, 1998 at 9:16 pm
    Aug 8, 1998 at 1:26 pm
  • I have worked with Vadim privately on the remaining OR clause index issues, and I am done. Please start testing, everyone. The only open item is whether MergeJoin will try to use a multi-index OR ...
    Bruce MomjianBruce Momjian
    Aug 5, 1998 at 1:18 am
    Aug 8, 1998 at 6:49 am
  • Here is a comment in path/indxpath.c that says they don't want to use multi-key indexes with OR clauses. Of course, we now support multi-key indexes, and this code was disabled anyway because it was ...
    Bruce MomjianBruce Momjian
    Aug 1, 1998 at 12:00 pm
    Aug 4, 1998 at 9:07 pm
  • This is the first I have heard of this. The file commands/copy.c does use a file descriptor cache, but that is really just used for allowing more file opens that the OS permits. Actual opens and ...
    Bruce MomjianBruce Momjian
    Aug 25, 1998 at 5:30 pm
    Aug 29, 1998 at 6:16 pm
  • Hmm. I'm on Linux-libc5, i686, gcc 2.7.2.1, and select_views is still core dumping: QUERY: SELECT * FROM toyemp WHERE name = 'sharon'; pqReadData() -- backend closed the channel unexpectedly. These ...
    Thomas G. LockhartThomas G. Lockhart
    Aug 16, 1998 at 4:29 am
    Aug 26, 1998 at 7:21 pm
  • Hi, I really wonder if anybody ever used functions returning tuples or sets of tuples. If so, be careful! Let's have a look at the following test: create table emp (name text, salary money); create ...
    Jan WieckJan Wieck
    Aug 13, 1998 at 11:32 am
    Aug 22, 1998 at 12:39 pm
  • Hi, just updated development version from cvs and got strange problem : select * from WORK_FLATS where DISTRICT_ID in (4,101); select * from WORK_FLATS where DISTRICT_ID in (101,4); Does anyone ...
    Oleg BartunovOleg Bartunov
    Aug 18, 1998 at 7:28 pm
    Aug 20, 1998 at 6:28 pm
  • When experimenting with threaded perl I noticed I had to lock access to the database a one user at the time in order get reliable (no SEGV). Unfortunely it is 3 layer between my server and the wire, ...
    Goran ThyniGoran Thyni
    Aug 7, 1998 at 6:20 pm
    Aug 10, 1998 at 12:01 am
  • As far as I am concerned, we are ready to go. -- 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
    Aug 30, 1998 at 1:44 am
    Sep 5, 1998 at 1:09 am
  • Hi, who's the parser guru? I need help! I have a table t1(a int4, b int4) When I update t1 set b = 2 where a = 1; I get a targetlist with 1 entry and resno=2. But when I update t1 set b = t2.b where ...
    Jan WieckJan Wieck
    Aug 14, 1998 at 5:01 pm
    Aug 24, 1998 at 1:52 am
  • I did a CVSup a few minutes ago, and tried to do a clean install. configure seemed to do the right thing, but initdb was not happy. Looks like (perhaps) the recent changes to initdb to allow ...
    Thomas G. LockhartThomas G. Lockhart
    Aug 5, 1998 at 3:01 pm
    Aug 19, 1998 at 9:26 am
  • hello tom, did you try informix SE on linux ? could you install it on red hat 4.2 ? i'll be installing red hat 5.0 on my machine and would like to know if informix SE works with red hat. oracle too ...
    NARAYANINARAYANI
    Aug 7, 1998 at 1:32 pm
    Aug 8, 1998 at 8:00 pm
  • Currently, large objects are stored internally as xinv### and xinx###. I would like to rename this for 6.4 to be _lobject_### to prevent namespace collisions, and make them clearer for ...
    Bruce MomjianBruce Momjian
    Aug 6, 1998 at 4:00 am
    Aug 6, 1998 at 11:10 pm
  • I just tried: select oid from pg_type; and it worked. -- Bruce Momjian | 830 Blythe Avenue maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026 + If your life is a hard drive, | (610) ...
    Bruce MomjianBruce Momjian
    Aug 19, 1998 at 2:51 pm
    Aug 25, 1998 at 4:19 am
  • Today I am wondering whether it wouldn't be a good idea to just go ahead and move those struct declarations into libpq-int.h. Then a pointer to PGconn would be truly an opaque type for applications; ...
    Tom LaneTom Lane
    Aug 21, 1998 at 2:20 pm
    Aug 24, 1998 at 4:47 pm
  • Hi I found some bug on next example: ---------------------------- /* step 1 -------------- */ test= select pubid,bn into table l1 from l; SELECT test= select pubid,bn into table n1 from n; SELECT /* ...
    SerjSerj
    Aug 11, 1998 at 10:29 am
    Aug 12, 1998 at 8:00 am
  • Hi, the following patch fixes a bug in the oracle compatibility functions btrim() ltrim() and rtrim(). The error was that the character after the set was included in the tests (ptr2 pointed to the ...
    Jan WieckJan Wieck
    Aug 11, 1998 at 2:12 pm
    Aug 11, 1998 at 6:38 pm
  • I am planning on running pgindent on Monday, in preparation for the next release. I assume no one will be sitting on any big patches. If you are, let me know and I will wait. Marc, I assume we are on ...
    Bruce MomjianBruce Momjian
    Aug 30, 1998 at 1:17 pm
    Aug 30, 1998 at 9:01 pm
  • I have added this to the developer's FAQ. Any comments or corrections? -- Bruce Momjian | 830 Blythe Avenue maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026 + If your life is a hard drive, ...
    Bruce MomjianBruce Momjian
    Aug 19, 1998 at 3:30 am
    Aug 23, 1998 at 8:34 am
  • I tried to initdb as Bruce applied that huge patch but: Running: postgres -boot -C -F -D/usr/local/pgsql/data -Q template1 ERROR: fmgr_info: function 683: cache lookup failed ERROR: fmgr_info: ...
    Dr. Michael MeskesDr. Michael Meskes
    Aug 19, 1998 at 9:41 am
    Aug 20, 1998 at 4:41 am
  • Hi, here's the second patch for the rule system. It fixes the backend crashes that occur when using views/rules in the same session where they are created. The bug was that the new actions parsetrees ...
    Jan WieckJan Wieck
    Aug 19, 1998 at 10:40 am
    Aug 19, 1998 at 11:07 pm
  • I need to make some more updates to the libpq documentation, and I'm confused (again) about whether to work on libpq.sgml or libpq.3. The last I heard libpq.3 was the primary doco, but I find that ...
    Tom LaneTom Lane
    Aug 16, 1998 at 10:11 pm
    Aug 17, 1998 at 1:05 am
  • Did I forget to send it out? Or was it lost? It seems it never made it into cvs. I don't like the idea of submitting the next one and it won't fit in. :-) Michael -- Dr. Michael Meskes ...
    Dr. Michael MeskesDr. Michael Meskes
    Aug 11, 1998 at 6:19 pm
    Aug 13, 1998 at 3:37 pm
  • What is a partial index? I have never known. -- 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
    Aug 11, 1998 at 7:31 pm
    Aug 13, 1998 at 1:36 am
  • Let's say we have a table with two entries: name nr ---------- foo 1 bar 2 and a C program doing the following: ... i=1; exec sql declare C cursor for select name from table where nr=:i; i=2; exec ...
    Dr. Michael MeskesDr. Michael Meskes
    Aug 4, 1998 at 5:09 pm
    Aug 6, 1998 at 4:26 am
  • It appears to me that there is a bug in gram.y. From looking at the code (while working on ecpg) it seems that it doesn't accept a createdb with th eoption: with location = ... but without the option ...
    Dr. Michael MeskesDr. Michael Meskes
    Aug 3, 1998 at 5:28 pm
    Aug 4, 1998 at 5:37 pm
  • Hi, as proposed here comes the first patch for the query rewrite system. The tar archive contains mainly a little test suite that would fit into our regression tests. You'll find the patch itself ...
    Jan WieckJan Wieck
    Aug 17, 1998 at 1:15 pm
    Sep 8, 1998 at 12:32 am
  • As I mentioned before, I did some trials on my LinuxPPC box last week end. First I compiled with -O0. To my surprise, things got worse than - O2. Seems tas() for PPC (storage/buffer/s_lock.c) never ...
    Tatsuo IshiiTatsuo Ishii
    Aug 31, 1998 at 9:15 am
    Sep 3, 1998 at 5:31 pm
  • It currently looks like all developers are on a platform where USE_LOCALE is defined. If it is not defined (e.g. on AIX) I get all sorts of Function argument assignment between types "unsigned char*" ...
    Andreas ZeugswetterAndreas Zeugswetter
    Aug 24, 1998 at 12:54 pm
    Sep 3, 1998 at 9:18 am
  • Hi, I managed to recreate a simple example that's crashing postgres. I am running on a DEC Alpha with Digital Unix Version 4.0d and Postgres 3.2. I tried this example several times, on several ...
    George KousiGeorge Kousi
    Aug 13, 1998 at 4:31 pm
    Aug 25, 1998 at 2:52 am
  • Is there a reason why anyone renamed struct index to struct RelationGetRelidindex in ecpg's type.h? I'm surprised it doesn't break the ecpg compilation procedure since the usage in preproc.y hasn't ...
    Dr. Michael MeskesDr. Michael Meskes
    Aug 19, 1998 at 9:41 am
    Aug 24, 1998 at 1:19 am
  • Hi hackers. I grabbed the latest CVS from this morning and did a clean build and initdb. Things look a little broken as I get a SIGSEGV when trying to create a table. Any idea what went wrong? Keith. ...
    Keith ParksKeith Parks
    Aug 20, 1998 at 11:09 am
    Aug 21, 1998 at 5:30 am
  • Just tried to shutdown database (PostgreSQL) by killing postmaster and keeping established connections (backends) alive. This works fine - I still can access database using these connections (through ...
    Oleg BartunovOleg Bartunov
    Aug 3, 1998 at 1:27 pm
    Aug 20, 1998 at 2:57 pm
Group Navigation
period‹ prev | Aug 1998 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions186
posts856
users73
websitepostgresql.org...
irc#postgresql

73 users for August 1998

Bruce Momjian: 288 posts Thomas G. Lockhart: 86 posts Jan Wieck: 50 posts Tom Lane: 50 posts Michael Meskes: 39 posts The Hermit Hacker: 38 posts Peter T Mount: 28 posts Tatsuo Ishii: 25 posts Andreas Zeugswetter: 24 posts Keith Parks: 24 posts Vadim Mikheev: 20 posts David Hartwig: 16 posts David Gould: 12 posts Oleg Bartunov: 12 posts D'Arcy J.M. Cain: 10 posts Massimo Dal Zotto: 10 posts Jackson, DeJuan: 8 posts Brook Milligan: 7 posts David Hartwig: 7 posts Maarten Boekhold: 7 posts
show more
Archives