Search Discussions

214 discussions - 1,464 posts

  • Does SQL92 syntax allow dropping several columns, i.e. ALTER TABLE mytable DROP COLUMN col1,col5,col6; If it does, it would be very desirable to implement it to avoid the need for vacuum between each ...
    Hannu KrosingHannu Krosing
    Feb 27, 2000 at 5:58 pm
    Oct 10, 2000 at 12:01 pm
  • Having been away for some time I'm very anxious to see that there's a 7.0 release coming very soon. I extracted the TODO list from the CVS (latest update February 9). The only really really big issue ...
    Kaare RasmussenKaare Rasmussen
    Feb 21, 2000 at 8:25 pm
    Mar 8, 2000 at 5:39 am
  • We have discussed in the past the need for the optimizer to take LIMIT into account when choosing plans. Currently, since planning is done on the basis of total plan cost for retrieving all tuples, ...
    Tom LaneTom Lane
    Feb 10, 2000 at 4:48 pm
    Feb 16, 2000 at 11:46 pm
  • Yes, but how do you keep that accurate? If I add indexes, then drop them, does relhasindex go to false. Could you do that for relhassubclass? -- Bruce Momjian | http://www.op.net/~candle ...
    Bruce MomjianBruce Momjian
    Feb 3, 2000 at 12:21 pm
    Feb 5, 2000 at 2:07 am
  • In the TODO file: * -Allow transaction commits with rollback with no-fsync performance [fsync](Vadim) Has this been done in current? I see almost no performance improvement on copying data into a ...
    Tatsuo IshiiTatsuo Ishii
    Feb 5, 2000 at 10:33 am
    Feb 10, 2000 at 12:27 am
  • I have the new developer's globe online. Please check your BIOs and let me know if there's anything that needs correcting. For those without pictures, don't be so shy. Submit a picture - if you need ...
    Vince VielhaberVince Vielhaber
    Feb 7, 2000 at 12:12 pm
    Jun 9, 2000 at 12:31 pm
  • Hi, as I said, I tring implement PREPARE / EXECUTE command for user a controllable query cache (in TODO: Cache most recent query plan(s)). I have implement first usable version now (I know that it is ...
    Karel ZakKarel Zak
    Feb 22, 2000 at 3:48 pm
    Mar 1, 2000 at 9:35 am
  • I've just committed changes to "reunify" the date/time types. "timestamp" and "interval" are now the two primary date/time types for users. Also, I've changed the default date style to "ISO" (not ...
    Thomas LockhartThomas Lockhart
    Feb 16, 2000 at 5:33 pm
    Feb 19, 2000 at 10:25 pm
  • I'm comparing v6.5.2 against v7.0 and I see now: UPDATEs and INSERTs are faster in v7.0 than v5.6.2 but SELECTs are slow, specially: SELECT ... UNION (is 3 / 4 times slow) and SELECT...HAVING, this ...
    José SoaresJosé Soares
    Feb 28, 2000 at 2:11 pm
    Mar 4, 2000 at 12:43 am
  • This is probably related to Lockhart's changes to allow not null/not deferrable to work (foreign key stuff). I'm sympathetic, I looked at gram.y for awhile myself trying to figure a way out of the ...
    Don BaccusDon Baccus
    Feb 28, 2000 at 3:24 pm
    Mar 1, 2000 at 8:24 pm
  • I've got most of the regression tests running, but one of the rules tests has uncovered a problem in my code, at least for a query involving a merge join. Could someone run a "-d 99" query using the ...
    Thomas LockhartThomas Lockhart
    Feb 11, 2000 at 6:03 am
    Feb 18, 2000 at 5:06 am
  • Hi, there was discussion about readding the lztext type for internal use in pg_rewrite for 7.0, then remove it again once we have TOAST. Was because significant growth of the rule plan strings due to ...
    Jan WieckJan Wieck
    Feb 25, 2000 at 8:48 pm
    Feb 27, 2000 at 1:33 am
  • Well, don't I look stupid here. Once upon a time I recall to have fixed exactly this issue, apparently it snuck back in. If you run psql in non-interactive mode the psqlrc file shouldn't be read at ...
    Peter EisentrautPeter Eisentraut
    Feb 24, 2000 at 12:47 pm
    Feb 25, 2000 at 1:07 am
  • Um, you're right of course --- those are lexer not parser datastructures you're poking into. Sorry for my confusion. We do in fact work with non-bison parser generators, or did last time I tried it ...
    Tom LaneTom Lane
    Feb 21, 2000 at 1:03 am
    Jun 9, 2000 at 12:40 pm
  • When will we release 7.0? I just checked and found that I'm way behind my schedule. The parser is in sync, but there are quite some open bugs. So hopefully there is either enough time left or someone ...
    Michael MeskesMichael Meskes
    Feb 22, 2000 at 7:54 pm
    Feb 23, 2000 at 9:10 am
  • Hi, For PostgreSQL We tend to use the Phrase "Most Advanced Open Source RDBMS" alot. Will this statement still hold true when/if Inprise becomes open source ? Jeff ...
    "Jeff MacDonald"Jeff MacDonald
    Feb 15, 2000 at 2:51 pm
    Feb 18, 2000 at 1:51 pm
  • libpq should be back to normal (printing and all). Sorry once again for the mess. The psql quoting issue should be fixed as well. As is usual for hand-crafted parsers, there's probably something I ...
    Peter EisentrautPeter Eisentraut
    Feb 7, 2000 at 11:07 pm
    Feb 11, 2000 at 6:47 am
  • Hi, The following phenomenon was reported to pgsql-jp(ML in Japan). rest=# select -1234567890.1234567; ERROR: Unable to convert left operator '-' from type 'unknown' -1234567890.1234567 is treated as ...
    Hiroshi InoueHiroshi Inoue
    Feb 21, 2000 at 7:00 am
    Feb 26, 2000 at 11:46 pm
  • Attached is a patch for the ONLY inheritance functionality... *) It includes a SET compatibility mode. *) The overhead for non-inheritance has been cut down to 30 microseconds (on a pc). *) It needs ...
    Feb 5, 2000 at 3:36 am
    Feb 7, 2000 at 1:13 am
  • IMHO, the syntax for create user is a hell and a half. Adding more keywords in the current fashion is a dead end. (Note: you have to remember the order in which the user "features" have to be ...
    Peter EisentrautPeter Eisentraut
    Feb 28, 2000 at 11:17 pm
    Mar 6, 2000 at 6:38 pm
  • I've since seen the article in the latest issue of PCWeek. The article was not at all clear on the *specific* features which would disqualify Postgres from having SQL92 entry level compliance (for ...
    Thomas LockhartThomas Lockhart
    Feb 17, 2000 at 6:22 am
    Mar 2, 2000 at 2:40 pm
  • Well, LZTEXT is there again, and pg_rewrite uses it for action and qual strings. This is what it tells: pgsql=# select rulename, length(ev_action), octet_length(ev_action) pgsql-# from pg_rewrite; ...
    Jan WieckJan Wieck
    Feb 27, 2000 at 12:15 pm
    Feb 28, 2000 at 7:53 am
  • Hi, what's happen with network_ops in current CVS ? I just synced sources and couldn't load dump from 6.5.3 - problem occures on CREATE INDEX "face_key" on "face" using btree ( "eid" "int4_ops", "ip" ...
    Oleg BartunovOleg Bartunov
    Feb 7, 2000 at 8:34 pm
    Feb 9, 2000 at 12:21 am
  • We've already seen how column alias were breaking pg_dump's ability to restore views unless a table alias were created, fixed now thanks to Tom's hack. Here's an observation that's not really a bug ...
    Don BaccusDon Baccus
    Feb 23, 2000 at 4:20 pm
    Feb 29, 2000 at 3:55 pm
  • Just downloaded a completely fresh cvs copy. When I do initdb... This user will own all the files and must also own the server process. Creating Postgres database system directory ...
    Feb 1, 2000 at 12:14 pm
    Feb 2, 2000 at 4:09 am
  • I am afraid of lots of user complaints, even if we had not already used TEMP. -- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | ...
    Bruce MomjianBruce Momjian
    Feb 29, 2000 at 5:59 am
    Mar 1, 2000 at 6:35 am
  • Hi all, The transactions should be the way to distinguish a relational database from others no-relational databases, (MySQL is the right example). We are very proud of PostgreSQL transactions but ...
    José SoaresJosé Soares
    Feb 22, 2000 at 11:48 am
    Feb 25, 2000 at 7:27 pm
  • Why isn't this casted automatically? Michael -- Michael Meskes | Go SF 49ers! Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire! Tel.: (+49) 2431/72651 | Use Debian GNU/Linux! Email: ...
    Michael MeskesMichael Meskes
    Feb 16, 2000 at 11:51 am
    Feb 19, 2000 at 2:11 pm
  • Hi I'm running postgres v6.5.3. I need to make calls to the functions in libpq in my code. For this I need the files - libpq.lib/libpq.lib.dll/libpqdll.lib. When I run 'nmake /f win32.mak' in the src ...
    Rini DuttaRini Dutta
    Feb 10, 2000 at 12:02 am
    Feb 11, 2000 at 3:14 pm
  • The following used to work in 6.5, works in Oracle, and is very useful: donb=# create table foo(c varchar); CREATE donb=# insert into foo values('abc'); INSERT 72649 1 donb=# select distinct c from ...
    Don BaccusDon Baccus
    Feb 7, 2000 at 3:06 am
    Feb 7, 2000 at 6:53 pm
  • 11


    I've been poking around in the libpq area and I'm thinking of tackling the streaming interface which was suggested recently. What I have in mind is that a new API PQexecStream() doesn't retrieve the ...
    Feb 10, 2000 at 12:24 pm
    Feb 17, 2000 at 11:27 pm
  • (This is mostly directed at Bruce, but anyone else who's looked at the planner/optimizer is welcome to chime in.) On the way to implementing estimates of WHERE-clause costs, I was forced to notice ...
    Tom LaneTom Lane
    Feb 6, 2000 at 2:22 am
    Feb 6, 2000 at 11:27 pm
  • We were having some trouble doing updates to our database, a lot of our database sort of works like this: dbfunc(data) somedatatype *data; { somedatatype *existing_row; existing_row = ...
    Alfred PerlsteinAlfred Perlstein
    Feb 3, 2000 at 10:28 pm
    Feb 4, 2000 at 10:08 pm
  • pqbool is removed from libpq-fe.h. Couldn't compile interfaces/perl5 now. In addition,this seems to change external interface of PQprint(). Is it OK ? Regards. Hiroshi Inoue Inoue@tpf.co.jp
    Hiroshi InoueHiroshi Inoue
    Feb 2, 2000 at 2:25 am
    Feb 2, 2000 at 8:06 pm
  • subscribe
    Feb 21, 2000 at 2:50 pm
    Feb 28, 2000 at 2:34 pm
  • Is it possible to define a function in language 'C' that needs more libraries to work? I've got a small example of a function that works like a charm when run against from a binary. However if I put ...
    Michael MeskesMichael Meskes
    Feb 15, 2000 at 12:15 pm
    Feb 17, 2000 at 7:46 pm
  • Peter E. can you look at this? I see simple prompt doing: fputs(prompt, stdout); which I think should be stderr. Peter, can you check on those? -- Bruce Momjian | http://www.op.net/~candle ...
    Bruce MomjianBruce Momjian
    Feb 16, 2000 at 11:37 pm
    Feb 17, 2000 at 11:25 am
  • Hi there, I've just had a look at the 7.0beta and I've seen your enhancements about LIMIT optimization. Did you read by chance my previous message intitled "Generalized Top Queries on PostgreSQL"? ...
    Roberto CornacchiaRoberto Cornacchia
    Feb 23, 2000 at 5:41 am
    Feb 24, 2000 at 9:48 pm
  • This is a Call For Hackers: Some time ago, I floated a little discussion on this list about doing some distributed database work with PostgreSQL. The project got back burnered at work, but now has a ...
    Ross J. ReedstromRoss J. Reedstrom
    Feb 7, 2000 at 9:11 pm
    Feb 8, 2000 at 3:44 pm
  • Been trying to read the SQL3 draft. My best guess is that this is the appropriate section... Let T be the table identified by <ANSI <table name <ISO <table or query name contained in a <table ...
    Chris BitmeadChris Bitmead
    Feb 7, 2000 at 5:25 am
    Feb 8, 2000 at 12:00 am
  • Hi, looking at all the complications about dealing with segmented files etc., I wonder if it's really worth the efford to add file buffering to the trigger queue. The memory footprint left by ...
    Jan WieckJan Wieck
    Feb 8, 2000 at 4:05 pm
    Jun 10, 2000 at 10:12 pm
  • Here is my list of 7.0 changes. Please let me know of any changes I should make to it. -- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard ...
    Bruce MomjianBruce Momjian
    Feb 23, 2000 at 8:13 pm
    Feb 27, 2000 at 2:56 pm
  • MS Access has transactions and Informix (Version 5.00 - 9.20) performs create, drop, alter inside the transaction, same as Oracle and DB2. I am pretty sure that the behavior of the others is the ...
    Andreas ZeugswetterAndreas Zeugswetter
    Feb 23, 2000 at 8:27 am
    Feb 23, 2000 at 5:03 pm
  • I have written a man page for pg_ctl. I will appreciate if someone would give me comments on it including grammatical corrections. -- Tatsuo Ishii NAME pg_ctl - starts/stops/restarts postmaster ...
    Tatsuo IshiiTatsuo Ishii
    Feb 6, 2000 at 3:46 am
    Feb 22, 2000 at 1:42 am
  • Hi I have a crash while creating regression database in pararell regression test. Seems it's due to the following change. @@ -2638,7 +2705,14 @@ n- dbname = $3; n- dbpath = $5; #ifdef MULTIBYTE - n- ...
    Hiroshi InoueHiroshi Inoue
    Feb 17, 2000 at 12:36 am
    Feb 18, 2000 at 2:47 pm
  • Are we still 'go' for a beta release the 15th? Before I pull a latenighter RPM building.....it would be nice to have an idea. TIA! -- Lamar Owen WGCR Internet Radio 1 Peter 4:11
    Lamar OwenLamar Owen
    Feb 14, 2000 at 9:19 pm
    Feb 16, 2000 at 3:01 am
  • Someone mentioned recently that a timezone style of "GMT+0800" was on their FreeBSD machine as an allowed time zone, that its behavior was the same as the usual ISO8601 timezone of "-0800", and that ...
    Thomas LockhartThomas Lockhart
    Feb 6, 2000 at 10:16 pm
    Feb 10, 2000 at 6:44 am
  • As you surely noticed, the psql -e flag ("echo" modus, if you will) has changed its format (regression tests ring a bell?) in that it echoes the input file verbatim. For the particular case of the ...
    Peter EisentrautPeter Eisentraut
    Feb 6, 2000 at 1:06 pm
    Feb 7, 2000 at 7:49 pm
  • Looking at the example I just cited, it's hard to avoid noticing how much space is being used on purely-decorative field labels. For example, { TARGETENTRY :resdom { RESDOM :resno 1 :restype 23 ...
    Tom LaneTom Lane
    Feb 27, 2000 at 10:39 pm
    Feb 28, 2000 at 2:40 pm
  • Hi everybody, I'm done my tests of PostgreSQL and Interbase. I concentrated on two tests, an OLTP Single Read Test, where we read a single row out of a 200K row indexed table, and the OLTP Read Mix ...
    Timothy DyckTimothy Dyck
    Feb 4, 2000 at 10:53 am
    Feb 26, 2000 at 5:35 am
Group Navigation
period‹ prev | Feb 2000 | next ›
Group Overview
grouppgsql-hackers @

110 users for February 2000

Tom Lane: 255 posts Bruce Momjian: 188 posts Don Baccus: 126 posts Thomas Lockhart: 84 posts Chris Bitmead: 80 posts Peter Eisentraut: 55 posts Peter Eisentraut: 52 posts Hannu Krosing: 51 posts The Hermit Hacker: 49 posts Jan Wieck: 47 posts Hiroshi Inoue: 39 posts Chris: 34 posts Michael Meskes: 33 posts Lamar Owen: 26 posts Karel Zak: 22 posts Tatsuo Ishii: 21 posts Andreas Zeugswetter: 18 posts Ross J. Reedstrom: 17 posts Vince Vielhaber: 14 posts Alfred Perlstein: 13 posts
show more