Search Discussions

63 discussions - 291 posts

  • I see following in HISTORY: Disallow DROP TABLE/DROP INDEX inside a transaction block However, it seems that this is not done with current? test=# create table t1(i int); CREATE test=# begin; BEGIN ...
    Tatsuo IshiiTatsuo Ishii
    Mar 5, 2000 at 9:02 am
    Mar 9, 2000 at 2:01 am
  • Hello, I've recently written to pgsql-ports about a problem with PG7.0 on NT (Subj: [PORTS] initdb problem on NT with 7.0). Since nobody helped me, I had to find out the reson. The difference between ...
    Alexei ZakharovAlexei Zakharov
    Mar 6, 2000 at 6:06 am
    Jun 9, 2000 at 4:04 pm
  • What exactly is our policy towards global variables in libraries? I take is these variables are harmless in multi tasking operation as each process has its seperate data space. But they may do harm ...
    Michael MeskesMichael Meskes
    Mar 7, 2000 at 3:08 pm
    Mar 8, 2000 at 7:50 pm
  • Again, if you read my post carefully I was simply pointing out that RI semantics will degrade rapidly (for some tables) once the index is unusable because a full table scan will be necessary (where ...
    Don BaccusDon Baccus
    Mar 31, 2000 at 12:24 am
    Apr 3, 2000 at 3:58 pm
  • In the alter table regression test, alter_table.sql, it says: -- 20 values, sorted SELECT unique1 FROM ten_k WHERE unique1 < 20; -- 20 values, sorted SELECT unique2 FROM ten_k WHERE unique2 < 20; Why ...
    Patrick WelchePatrick Welche
    Mar 7, 2000 at 2:52 pm
    Mar 8, 2000 at 11:52 pm
  • I clearly dropped the ball on this one. Don't think it can go into 7.0 because it would require catalog changes/initdb. However, I would like to keep it in contrib and add it as soon as 7.0 finalizes ...
    Bruce MomjianBruce Momjian
    Mar 1, 2000 at 4:43 pm
    Mar 1, 2000 at 8:26 pm
  • Heads up to packagers: src/bin/pgaccess/pgaccess.sh has been changed in CURRENT CVS to use hardcoded PATH_TO_WISH and PGACCESS_HOME, rather than using __wish__ and __POSTGRESDIR__. Bruce?? -- Lamar ...
    Lamar OwenLamar Owen
    Mar 31, 2000 at 1:56 pm
    Mar 31, 2000 at 2:45 pm
  • Hey I just got bitten by something in the docs: http://www.postgresql.org/docs/user/datatype1029.htm specifically: Note: To ensure compatibility to earlier versions of PostgreSQL we also continue to ...
    Alfred PerlsteinAlfred Perlstein
    Mar 2, 2000 at 4:03 am
    Mar 2, 2000 at 4:32 pm
  • Yeah, I've thought about it, and it is not at all clear. I understand all of your points, but for the hardcopy versions of docs having a single 600 page doc seems more unwieldy than having several ...
    Thomas LockhartThomas Lockhart
    Mar 31, 2000 at 2:39 pm
    Apr 3, 2000 at 1:21 am
  • Sorry about the length of this one, but I wanted to include backtrace info. I've been getting a segfault when I try to setup a test version of the current CVS tree, to run along beside a 'production' ...
    Ross J. ReedstromRoss J. Reedstrom
    Mar 7, 2000 at 12:37 am
    Mar 8, 2000 at 1:09 am
  • Hello, I just downloaded the 7.0 beta to test it with my database to make sure there will be no unexpected problems when I upgrade my production site. I've run into a problem that I hope you can help ...
    Brian HirtBrian Hirt
    Mar 5, 2000 at 9:27 am
    Mar 8, 2000 at 12:15 am
  • While applying the NT regression tests, I remember Tom Lane's comment that people are being much more picky about the regression results. In the old days, we could just say that they will have ...
    Bruce MomjianBruce Momjian
    Mar 31, 2000 at 2:18 pm
    Apr 2, 2000 at 3:39 pm
  • now, this is weird. no idea if I have LOCALE enabled, I don't use it that's for sure. anyone? tinus. (I'll try upgrading anyhow)
    Mar 31, 2000 at 8:24 am
    Mar 31, 2000 at 4:43 pm
  • Using perl DBI, I would like to catch a backend error and, if the pgsql error string matches a particular regex (/ExecInitIndexScan: both left and right op's are rel-vars/), vacuum on the fly and ...
    Ed LoehrEd Loehr
    Mar 8, 2000 at 5:37 pm
    Mar 9, 2000 at 4:21 am
  • I have a 50MB +- table with about 70,000 records which on which I was doing LIKE selects. It was taking approx 20 secs to complete the search. The table is something like... CREATE TABLE info ( ...
    Mar 8, 2000 at 12:04 am
    Mar 8, 2000 at 5:19 am
  • Hi, First of all I want to congratulate all the people working on PostgreSQL for a job well done. Now my problem. I want to change the default behaviour of the data_in function without recompiling ...
    Willy De la CourtWilly De la Court
    Mar 1, 2000 at 7:57 pm
    Mar 2, 2000 at 3:51 am
  • Can someone look into this, and followup with Don? :) ==================== From: Don Baccus <dhogaza@pacifier.com Slightly less minor bug. Forward this to the right place, too. acs=# create function ...
    The Hermit HackerThe Hermit Hacker
    Mar 1, 2000 at 1:11 am
    Mar 1, 2000 at 10:38 am
  • I've got patches to fix the CREATE VIEW command to support SQL92 syntax for result column names, a la CREATE VIEW (a, b, c) AS SELECT ... It is an almost trivial fix, requiring the addition of a ...
    Thomas LockhartThomas Lockhart
    Mar 7, 2000 at 4:05 pm
    Mar 8, 2000 at 5:20 am
  • I have (almost) nothing to do for about 3 weeks, so I thought I'd get started on some stuff for next time around. The idea here is to unify all the various configuration settings into one coherent ...
    Peter EisentrautPeter Eisentraut
    Mar 6, 2000 at 3:57 pm
    Mar 8, 2000 at 12:07 am
  • Hi, I'm wondering why the transaction star time in TransactionStateData is Absolutetime. From nabstime.h: * Although time_t generally is a long int on 64 bit systems, these two * types must be 4 ...
    Tatsuo IshiiTatsuo Ishii
    Mar 5, 2000 at 1:47 am
    Mar 7, 2000 at 1:35 am
  • Hi, I a little study on DejaNews a large discussion (October 1999) about new fmgr and functions which return tuples. (IMHO 'function' is not good name for this, better is 'procedure'.) A question, is ...
    Karel ZakKarel Zak
    Mar 31, 2000 at 3:33 pm
    Apr 4, 2000 at 12:27 pm
  • Believe it or not, this is good news for me as it reduces my work for 7.0 to one bug report. :-) Michael -- Michael Meskes | Go SF 49ers! Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire! Tel.: ...
    Michael MeskesMichael Meskes
    Mar 31, 2000 at 5:45 am
    Mar 31, 2000 at 10:02 am
  • Mailing list turnaround? You mean where it takes seemingly forever to get anything you posted to finally return? Nope, not local to you. Vince. -- ...
    Vince VielhaberVince Vielhaber
    Mar 30, 2000 at 8:21 pm
    Mar 31, 2000 at 12:03 am
  • In the PostgreSQL TODO is "Get faster regex() code from Henry Spencer..". I look at current available regex used (a example) in apache, php, .etc. But if I look at changes (via diff) between ...
    Karel ZakKarel Zak
    Mar 8, 2000 at 4:26 pm
    Mar 9, 2000 at 1:02 am
  • I have just applied a user patch to fix this reported problem. -- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue ...
    Bruce MomjianBruce Momjian
    Mar 7, 2000 at 10:53 pm
    Mar 8, 2000 at 1:45 am
  • Because of the problems that were pointed out, I'm inclined to remove the pg_pwd updating trigger again. I can offer you the non-initdb requiring variant (just remove the trigger definition in ...
    Peter EisentrautPeter Eisentraut
    Mar 5, 2000 at 1:27 pm
    Mar 8, 2000 at 12:22 am
  • Yes, that was also the general consensus on the list. No statement is ever going to do an implicit commit of previous statements. Andreas
    Andreas ZeugswetterAndreas Zeugswetter
    Mar 6, 2000 at 8:31 am
    Mar 6, 2000 at 10:47 am
  • But if the two queries are the same, the union CAN be simplified, since the union of two identical masses (I don't know the correct word here) is still that one mass. Thus 6.5 simplification is ...
    Andreas ZeugswetterAndreas Zeugswetter
    Mar 2, 2000 at 9:04 am
    Mar 2, 2000 at 4:23 pm
  • Hello, I have a report from compiling PostgreSQL 6.5.3 on Solaris/SPARC with gcc/ld (it was not run by me, I was ask to help to solve this problem). Everything goes OK (with template ...
    Horák DanielHorák Daniel
    Mar 1, 2000 at 4:01 pm
    Mar 2, 2000 at 4:14 pm
  • Can somebody point me to a place where I can get one of those public drafts of SQL3? I heard DEC has the somewhere, but where? -- Peter Eisentraut Sernanders väg 10:115 peter_e@gmx.net 75262 Uppsala ...
    Peter EisentrautPeter Eisentraut
    Mar 1, 2000 at 3:04 pm
    Mar 1, 2000 at 4:35 pm
  • As Jeff mentioned earlier today, there is a poll going on at http://www.linux.com that asks: Several high-quality databases are available for Linux. Which database, if any, does your company ...
    The Hermit HackerThe Hermit Hacker
    Mar 1, 2000 at 4:02 am
    Mar 1, 2000 at 9:20 am
  • I have committed fixes for all the so-far-reported regression test discrepancies, with the exception that some of the 'geometry' expected files look to be out of date and I have no proposed updates. ...
    Tom LaneTom Lane
    Mar 31, 2000 at 6:01 am
    Mar 31, 2000 at 2:34 pm
  • Hello, I have tested the beta3 on WinNT and here are the results: - I was unable to compile ecpg due to the ":=" instead of "=" in defining LIBPQDIR and some other variables in Makefile.global.in - ...
    Horák DanielHorák Daniel
    Mar 31, 2000 at 1:51 pm
    Mar 31, 2000 at 2:14 pm
  • I've just committed a bunch o' patches for the docs. Changes include: o a chapter on index cost estimating (indexcost.sgml) from Tom Lane. o a chapter on the PL/perl language from Mark Hollomon. o a ...
    Thomas LockhartThomas Lockhart
    Mar 30, 2000 at 10:43 pm
    Mar 30, 2000 at 11:25 pm
  • Hi, The regression test script runcheck.sh doesn't seem able to handle the blank line on the end of the resultmap file. Here's a patch to remove it!! Keith. *** src/test/regress/resultmap.orig Wed ...
    Keith ParksKeith Parks
    Mar 8, 2000 at 4:53 pm
    Mar 8, 2000 at 7:37 pm
  • Hi, query cache hacking continue ... I just implement my (context-per-plan) query cache (qCache) to SPI. Changed: SPI_saveplan() - save plan to qcache instead to never unallocated TopMemoryContext. ...
    Karel ZakKarel Zak
    Mar 2, 2000 at 4:32 pm
    Mar 8, 2000 at 4:33 pm
  • Yup, 7.0beta1 is missing a couple of lines of code needed to handle casts applied to function parameters. Thanks for catching that. I have patched current CVS sources; tonight's snapshot should have ...
    Tom LaneTom Lane
    Mar 8, 2000 at 12:07 am
    Mar 8, 2000 at 4:19 pm
  • Hello. I noticed you are the maintainer of the TODO list for PostgreSQL. I am an enthusiastic user of PostgreSQL, and I feel that with little effort we could add pam authentication functionality. ...
    Jacopo SilvaJacopo Silva
    Mar 8, 2000 at 1:17 am
    Mar 8, 2000 at 3:43 pm
  • [etc] I thought I had shut up those warnings by making the variables in question volatile. There's no need to worry about them since they're re-initialized right after the longjmp, but does anyone ...
    Peter EisentrautPeter Eisentraut
    Mar 4, 2000 at 5:03 pm
    Mar 7, 2000 at 6:55 am
  • Here is a new MAkefile.PL for plperl. It not only solves the problem for the missing symbol, but there is also now a 'make install'. By the way, earlier, I sent a patch to add plperl to createlang, ...
    Mark HollomonMark Hollomon
    Mar 1, 2000 at 3:03 pm
    Mar 1, 2000 at 7:13 pm
  • Thanks for the information Thorsten. I'm forwarding this message to the "hackers" list for further comment. afaik, the IPC issue on Solaris is a FAQ, and the fix requires configuring IPC in the Sun ...
    Thomas LockhartThomas Lockhart
    Mar 1, 2000 at 1:48 pm
    Mar 1, 2000 at 3:40 pm
  • Another one here ... ============= From: Don Baccus <dhogaza@pacifier.com donb=# create table foo(c char(2), v varchar(2)); CREATE donb=# select * from foo where c::varchar = v::varchar; ERROR: ...
    The Hermit HackerThe Hermit Hacker
    Mar 1, 2000 at 1:14 am
    Mar 1, 2000 at 5:42 am
  • Okay, done. Apparently they switched from i386-pc-qnx* to i386-qnx-qnx* and back and now they mangled the versions as well. In any case I don't see any support for QNX2 in config.guess so we ...
    Peter EisentrautPeter Eisentraut
    Mar 31, 2000 at 10:05 pm
    Mar 31, 2000 at 10:05 pm
  • The publisher says it is fine to use the tables from Chapter 9 of my book in the PostgreSQL docs. I recommend the function and operator tables specifically. -- Bruce Momjian | ...
    Bruce MomjianBruce Momjian
    Mar 31, 2000 at 11:41 am
    Mar 31, 2000 at 11:41 am
  • Hi all! Can anybody help me with it? Used FreeBSD 3.3-STABLE, PostgreSQL7.0beta2( and 6.5.Х ) compiled with options: --enable-locale --enable-recode --enable-multibyte=KOI8 --with-odbc --with-CC=gcc ...
    Sergey V. MikheevSergey V. Mikheev
    Mar 31, 2000 at 9:17 am
    Mar 31, 2000 at 9:17 am
  • Just want to make sure it works for all the lists ... if someone notices I happened to have missed one, please let me know ... There is currently a gap between the 9th and 30th, that I will be fillig ...
    The Hermit HackerThe Hermit Hacker
    Mar 30, 2000 at 8:16 pm
    Mar 30, 2000 at 8:16 pm
  • change made! Vince. -- ========================================================================== Vince Vielhaber -- KA8CSH email: vev@michvhf.com http://www.pop4.net 128K ISDN: $24.95/mo or less - ...
    Vince VielhaberVince Vielhaber
    Mar 30, 2000 at 8:15 pm
    Mar 30, 2000 at 8:15 pm
  • Testing the archive "redirect" feature of Majordomo2 ... there will be a temporary gap until I merge the two back together again ... Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems ...
    The Hermit HackerThe Hermit Hacker
    Mar 30, 2000 at 8:06 pm
    Mar 30, 2000 at 8:06 pm
  • try this .. Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
    The Hermit HackerThe Hermit Hacker
    Mar 9, 2000 at 6:25 am
    Mar 9, 2000 at 6:25 am
  • Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
    The Hermit HackerThe Hermit Hacker
    Mar 9, 2000 at 6:21 am
    Mar 9, 2000 at 6:21 am
Group Navigation
period‹ prev | Mar 2000 | next ›
Group Overview
grouppgsql-hackers @

51 users for March 2000

Bruce Momjian: 45 posts Tom Lane: 43 posts Thomas Lockhart: 28 posts The Hermit Hacker: 20 posts Peter Eisentraut: 14 posts Karel Zak: 11 posts Peter Eisentraut: 11 posts Ross J. Reedstrom: 11 posts Lamar Owen: 10 posts Michael Meskes: 9 posts Hiroshi Inoue: 7 posts Tatsuo Ishii: 7 posts Vince Vielhaber: 6 posts Andreas Zeugswetter: 4 posts Don Baccus: 4 posts Mike Mascari: 4 posts Patrick Welche: 4 posts Philip Warner: 4 posts Sergio A. Kessler: 4 posts Ed Loehr: 3 posts
show more