FAQ

PostgreSQL > pgsql-hackers > January 1998

Search Discussions

207 discussions - 852 posts

  • Vadim, I know you are still thinking about subselects, but I have some more clarification that may help. We have to add phantom range table entries to correlated subselects so they will pass the ...
    Bruce MomjianBruce Momjian
    Jan 9, 1998 at 4:00 am
    Jan 21, 1998 at 4:03 pm
  • When the postmaster crashes, it leaves the /tmp/.s.pgsql file in /tmp. Is there a way to auto-remove it after a postmaster crash? -- Bruce Momjian maillist@candle.pha.pa.us
    Bruce MomjianBruce Momjian
    Jan 26, 1998 at 9:30 pm
    Jan 30, 1998 at 3:41 am
  • OK, general question. Does pg_user need to be readable? Do non-postgres users want to see who owns each table? I don't know. -- Bruce Momjian maillist@candle.pha.pa.us
    Bruce MomjianBruce Momjian
    Jan 11, 1998 at 9:54 pm
    Jan 20, 1998 at 8:01 pm
  • I just wrote about issues regarding upping the max blocksize. There is stuff in storage/itemid.h that would need to be modified (also in bufmgr.h, but that is trivial). Th idea is that: typedef ...
    IntegrationIntegration
    Jan 4, 1998 at 4:05 am
    Jan 5, 1998 at 1:31 pm
  • I was thinking about subselects, and how to attach the two queries. What if the subquery makes a range table entry in the outer query, and the query is set up like the UNION queries where we put the ...
    Bruce MomjianBruce Momjian
    Jan 5, 1998 at 5:16 am
    Jan 6, 1998 at 5:31 am
  • Yes, that's one of the things I don't understand with PostgreSQL. ERROR would be much better. It would be even better if the backend would have an option to log all messages via syslog. That would be ...
    Mattias KregertMattias Kregert
    Jan 2, 1998 at 4:30 pm
    Jan 6, 1998 at 12:08 am
  • Without order by the result set is never guaranteed to be ordered in a specific way (standard speak). The order is dependent on the chosen query path, which changes from query to query. Andreas
    Zeugswetter Andreas DBTZeugswetter Andreas DBT
    Jan 27, 1998 at 10:13 am
    Jan 29, 1998 at 3:01 pm
  • Hi again, It seems unfortunate, but if I can't efficiently (i.e. no copying of whole table, no blocking and using index) browse the table, I might not be able to "sell" postgres into the commercial ...
    Jan VicherekJan Vicherek
    Jan 23, 1998 at 9:51 pm
    Jan 24, 1998 at 10:43 pm
  • Not sure, but this one is about the only major thing that is continuing to bother me :( Is there any method of improving this? This oen is improved upon in v6.3, where at compile time you can ...
    The Hermit HackerThe Hermit Hacker
    Jan 17, 1998 at 11:08 pm
    Jan 21, 1998 at 8:17 pm
  • Hi, I created a table with two columns of type int, and loaded about 300 K records in it. So, the total size of the table is approx. that of 600 K integers, roughly 2.4 MB. But, the file ...
    Shiby ThomasShiby Thomas
    Jan 6, 1998 at 11:10 pm
    Jan 7, 1998 at 7:30 pm
  • Mark me down for it... ------------------------------
    The Hermit HackerThe Hermit Hacker
    Jan 2, 1998 at 6:38 pm
    Jan 5, 1998 at 4:10 pm
  • Now that we know the storage manager code that splits tables over 2GB into separate files doesn't work(Irix), can we rip out that code and just use the OS code to access 2GB files as normal files. ...
    Bruce MomjianBruce Momjian
    Jan 29, 1998 at 5:32 am
    Mar 21, 1998 at 2:58 pm
  • The last we discussed in pgsql-hackers was that OIDs would not be dropped... Nobody is actively *removing* OO features...or at least not that I'm aware of...we (the developers) are addressing ...
    The Hermit HackerThe Hermit Hacker
    Jan 14, 1998 at 1:17 pm
    Jan 17, 1998 at 6:45 am
  • Hello all, WARNING : It's a long mail, but please have patience and read it *all* I have reached a point in developing PgAccess when I discovered that some functions in libpgtcl are bad implemented ...
    Constantin TeodorescuConstantin Teodorescu
    Jan 5, 1998 at 6:43 pm
    Jan 7, 1998 at 3:49 pm
  • I am still wondering why postmaster fork/exec instead of just forking when receiving a new connection. Fork on modern unices (linux and (a think) *BSD) cost almost nothing (in time and memory) thanks ...
    Goran ThyniGoran Thyni
    Jan 24, 1998 at 7:25 pm
    Jan 25, 1998 at 6:39 pm
  • A few things that I have noticed will be affected by allowing the disk block size to be other than 8k. (4k, 8k, 16k or 32k) 1. Rules The rule system currently stores plans as tuples in pg_rewrite. ...
    Darren KingDarren King
    Jan 8, 1998 at 5:32 pm
    Jan 10, 1998 at 12:39 pm
  • The Hermit HackerThe Hermit Hacker
    Jan 25, 1998 at 7:12 am
    Jan 28, 1998 at 12:52 am
  • Here they are: --------------------------------------------------------------------------- GROUP BY bug of duplicates GROUP BY nulls bug ORDER BY nulls(Vadim?) many OR's exhaust optimizer ...
    Bruce MomjianBruce Momjian
    Jan 22, 1998 at 3:08 am
    Jan 23, 1998 at 11:45 am
  • OK, we never installed this for 6.2 because we were already in Beta. Can we do this for 6.3? Vadim suggested we make this part of libpq, so all applications could make use of it. I have one of the ...
    Bruce MomjianBruce Momjian
    Jan 11, 1998 at 8:18 pm
    Jan 18, 1998 at 7:34 pm
  • I am now thinking about this patch, and I don't think I like it. The original code allowed APPEND-only for users who can create databases, but no DELETE. The patch gives them DELETE permission, so ...
    Bruce MomjianBruce Momjian
    Jan 6, 1998 at 5:00 pm
    Jan 7, 1998 at 2:31 am
  • Let me add, I am not inlining all the functions, but only the top part of them that deals with cachoffsets and nulls. These are the easy ones, and the ones that get used most often. -- Bruce Momjian ...
    Bruce MomjianBruce Momjian
    Jan 30, 1998 at 6:01 am
    Feb 1, 1998 at 7:28 pm
  • While looking thru the nodeGroup code, I noticed the following that I'm not sure is correct. -- Using 01-09 snapshot create table t1 (a int4, b char(2), c char(2)); CREATE insert into t1 (a,c) values ...
    Darren KingDarren King
    Jan 17, 1998 at 10:11 pm
    Jan 27, 1998 at 3:39 pm
  • I've been seeing trouble with varchar() columns for a little while, and since it is still there with a fresh install of the development tree it's time to report it: postgres= create table t (v ...
    Thomas G. LockhartThomas G. Lockhart
    Jan 12, 1998 at 2:54 pm
    Jan 19, 1998 at 7:12 pm
  • Vadim, can you look at this for me. If you set a break at ExecEvalVar before executing the SELECT, you will see its tupledescriptor- attrs[0].attlen is the max length, and not -1 as it should be. I ...
    Bruce MomjianBruce Momjian
    Jan 13, 1998 at 6:01 am
    Jan 18, 1998 at 8:29 am
  • While implementing a method to retrieve the permissions on a table, the statement: "grant all on test to public;" kills the backend. -- Peter T Mount petermount@earthling.net or ...
    Peter T MountPeter T Mount
    Jan 8, 1998 at 10:07 pm
    Jan 11, 1998 at 12:44 pm
  • unsubscribe
    Andy DoerrAndy Doerr
    Jan 12, 1998 at 3:08 pm
    Jan 29, 1998 at 2:57 pm
  • I have a potential patch for the glibc2 date problem; however I can't test it because the snapshot won't build. Has this build error been cured recently, or do I have my own unique problem? O/S: ...
    Oliver ElphickOliver Elphick
    Jan 15, 1998 at 12:48 pm
    Jan 16, 1998 at 3:55 pm
  • Well, I've rebuilt postgres again, using a fresh cvs snapshot, and grant is still broken. Infact, it gets worse. Once you try to use the grant statement, then any other connection that was active at ...
    Peter T MountPeter T Mount
    Jan 13, 1998 at 8:06 pm
    Jan 14, 1998 at 3:40 pm
  • Does someone want to remind me why we allocate the full size for char() and varchar(), when we really can just allocate the size of the given string? I relize char() has to be padded, but why ...
    Bruce MomjianBruce Momjian
    Jan 7, 1998 at 6:00 pm
    Jan 13, 1998 at 8:57 am
  • Do people want the overhead of char(), varchar(), and text to be reduced from 4-bytes to 2-bytes. We store the length in this overhead, but since we have a size limit on tuple size, we can't have a ...
    Bruce MomjianBruce Momjian
    Jan 21, 1998 at 10:00 pm
    Jan 22, 1998 at 4:01 pm
  • Got my Linux Journal today and the first featured article is entitled "PostgreSQL - The Linux of Databases" Now scrappy, before you get bent out of joint, they mean this in a nice way ;-) The author ...
    Thomas G. LockhartThomas G. Lockhart
    Jan 15, 1998 at 4:24 am
    Jan 16, 1998 at 4:25 pm
  • Hi all, in the current snapshot there is no default for PGHOST in src/interfaces/libpq/fe-connect.c. In 6.2 this was 'localhost', which is a reasonable default. If there is no real reason for not ...
    Edmund MerglEdmund Mergl
    Jan 10, 1998 at 8:50 am
    Jan 10, 1998 at 8:02 pm
  • Hi, I read this message on the debian development list. Thought it might be of interest to scrappy on the PostODBC thingie... Maarten ...
    Maarten BoekholdMaarten Boekhold
    Jan 24, 1998 at 10:32 am
    Jan 26, 1998 at 10:31 am
  • Developers Frequently Asked Questions (FAQ) for PostgreSQL Last updated: Thu Jan 22 15:04:10 EST 1998 Current maintainer: Bruce Momjian (maillist@candle.pha.pa.us) The most recent version of this ...
    Bruce MomjianBruce Momjian
    Jan 22, 1998 at 8:05 pm
    Jan 22, 1998 at 10:35 pm
  • Here's a blast from the past. Shows how I keep those open issues in my mailbox. Forwarded message: -- Bruce Momjian maillist@candle.pha.pa.us
    Bruce MomjianBruce Momjian
    Jan 10, 1998 at 3:30 am
    Jan 22, 1998 at 3:02 am
  • I installed some patches today for the univel port, and one of the changes did the following to include/storage/s_lock.h: 302c318 < __asm__("xchgb %0,%1": "=q"(_res), "=m"(*lock):"0"(0x1)); \ --- ...
    The Hermit HackerThe Hermit Hacker
    Jan 18, 1998 at 1:39 am
    Jan 20, 1998 at 7:39 pm
  • With Ingres and Informix char() is fixed size, while varchar() is VARiable size. -- Bruce Momjian maillist@candle.pha.pa.us
    Bruce MomjianBruce Momjian
    Jan 8, 1998 at 3:17 am
    Jan 9, 1998 at 6:30 pm
  • On linux-elf: pqcomm.c: In function `StreamServerPort': pqcomm.c:605: structure has no member named `sun_len' pqcomm.c: In function `StreamOpen': pqcomm.c:760: structure has no member named `sun_len' ...
    SerjSerj
    Jan 27, 1998 at 8:45 am
    Jan 28, 1998 at 1:05 am
  • They optimise sorting (use indexes) as well and so make it doable using cursors I even think that Oracle can use indexes for some cases of count(*) and min() and max(). It actually works for forward ...
    Hannu KrosingHannu Krosing
    Jan 24, 1998 at 9:21 am
    Jan 25, 1998 at 5:37 am
  • Unfortunately, with the way that the currencies fluctuate, it will vary greatly...but yes, it is in Canadian dollars. Yes, this is not a problem Marc G. Fournier Systems Administrator @ hub.org ...
    The Hermit HackerThe Hermit Hacker
    Jan 23, 1998 at 4:01 am
    Jan 23, 1998 at 5:26 pm
  • Hi... Well, since this has all sort of died off, and since I'd like to get some resolution on it. Does anyone here *understand* the LGPL? If we put the ODBC drivers *under* src/interfaces, does that ...
    The Hermit HackerThe Hermit Hacker
    Jan 12, 1998 at 6:13 pm
    Jan 16, 1998 at 4:31 pm
  • Seems like the discussion on views and access control is drifting in a direction that interests me. At the risk of once again bringing up an issue that's already been solved and tabled, I offer the ...
    De ClarkeDe Clarke
    Jan 14, 1998 at 8:24 pm
    Jan 16, 1998 at 4:21 am
  • Hi, I have installed PostgreSQL6.2.1 from my own user account (I was just trying to test out something first). It seems to be running too slow. For example, the self join of a table with roughly 300K ...
    Shiby ThomasShiby Thomas
    Jan 15, 1998 at 6:02 pm
    Jan 16, 1998 at 3:31 am
  • Hi all, Have just tried 9. Jan snapshot on AIX 4.1.5, compiles with gcc not with cc (fails in heaptuple.c), aix won't get defined though, did a -Daix The as keyword is now obligatory as in: ...
    Zeugswetter Andreas DBTZeugswetter Andreas DBT
    Jan 9, 1998 at 3:18 pm
    Jan 9, 1998 at 8:11 pm
  • I have just fixed many of these WARN problems. I am looking at the new results. The first problem: ====== boolean ====== 166,168d165 < |f |f < |f |f < |f |f 170a168 173a172 176a176 is because the ...
    Bruce MomjianBruce Momjian
    Jan 6, 1998 at 7:58 pm
    Jan 7, 1998 at 9:45 am
  • PostgreSQL seem to have a lot of names; Postgres 95, Postgres, Pg, Pgsql ... All these names are used in FAQ, filenames, docs, installation info, messages etc. Examples: The backend executable is ...
    Mattias KregertMattias Kregert
    Jan 20, 1998 at 2:00 pm
    Mar 18, 1998 at 3:25 pm
  • Try changing your OS default memory size. Unsure how to do this under AIX. -- Bruce Momjian maillist@candle.pha.pa.us
    Bruce MomjianBruce Momjian
    Jan 12, 1998 at 5:00 pm
    Mar 16, 1998 at 5:09 am
  • As far as I know, none of these are ready for 6.3, which is due on Sunday. What is the game plan, folks? And the tools/RELEASE_CHANGES files have not been updated. I will do the FAQ, TODO, HISTORY ...
    Bruce MomjianBruce Momjian
    Jan 30, 1998 at 6:30 am
    Feb 1, 1998 at 5:30 am
  • Any reason why the whole domain appears to be dead? Anything I can do to help? ---------- Sincerely Yours, Simon Shapiro Shimon@Simon-Shapiro.ORG Voice: 503.799.2313
    Simon ShapiroSimon Shapiro
    Jan 28, 1998 at 1:27 am
    Jan 28, 1998 at 4:52 pm
  • I believe I found a bug. If a user other than the postgres superuser is given permission to create databases, then he should be able to destroy the databases he creates. Currently he can't, at least ...
    Kevin WittenKevin Witten
    Jan 6, 1998 at 3:57 am
    Jan 6, 1998 at 5:30 am
Jan 1998
12345
Group Navigation
period‹ prev | Jan 1998 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions207
posts852
users76
websitepostgresql.org...
irc#postgresql

76 users for January 1998

Bruce Momjian: 267 posts The Hermit Hacker: 117 posts Vadim B. Mikheev: 68 posts Thomas G. Lockhart: 64 posts Darren King: 36 posts Peter T Mount: 34 posts Andrew Martin: 23 posts Zeugswetter Andreas DBT: 19 posts Goran Thyni: 16 posts Jan Vicherek: 15 posts Keith Parks: 13 posts Brett McCormick: 11 posts Mattias Kregert: 11 posts James Hughes: 10 posts D'Arcy J.M. Cain: 9 posts Todd brandys: 9 posts Edmund Mergl: 6 posts Serj: 6 posts Shiby Thomas: 6 posts Teunis: 6 posts
show more
Archives