FAQ

PostgreSQL > pgsql-hackers > October 2000

Search Discussions

264 discussions - 1,296 posts

  • After reviewing a number of past threads about the INET/CIDR mess, I have concluded that we should adopt the following behavior: 1. A data value like '10.1.2.3/16' is a legal INET value (it implies ...
    Tom LaneTom Lane
    Oct 26, 2000 at 11:15 pm
    Nov 10, 2000 at 2:45 am
  • I'm having the error 'relation <number modified while in use' fairly often. It is the same relation that's always giving a problem. Usually after all currently-running backends die away with that ...
    Alex PilosovAlex Pilosov
    Oct 23, 2000 at 1:31 am
    Nov 10, 2000 at 2:43 am
  • As many of you know, several businesses are involved in providing PostgreSQL support. After careful consideration, I have decided to accept a job with Great Bridge. There will be a press announcement ...
    Bruce MomjianBruce Momjian
    Oct 10, 2000 at 5:06 am
    Oct 23, 2000 at 3:22 pm
  • [Taken off GENERAL, added HACKERS to cc:] Bruce Momjian wrote: May I ask: is it necessary? Have there been version-bumping changes to libpq since 7.0.x? (With the rate that necessary improvement is ...
    Lamar OwenLamar Owen
    Oct 27, 2000 at 4:51 am
    Nov 2, 2000 at 9:56 pm
  • Can someone comment on this? -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | ...
    Bruce MomjianBruce Momjian
    Oct 3, 2000 at 3:43 am
    Feb 10, 2001 at 3:19 am
  • We would need to know where this separation is, but we cannot do a rollback only rollforward. Thus probably not acceptable. Andreas
    Andreas ZeugswetterAndreas Zeugswetter
    Oct 12, 2000 at 11:22 am
    Oct 16, 2000 at 5:02 pm
  • I am tempted to apply this. This is the second person who asked for binding to a single port. The patch looks quite complete, with doc changes. It appears to be a thorough job. Any objections? -- ...
    Bruce MomjianBruce Momjian
    Oct 11, 2000 at 1:32 am
    Nov 21, 2000 at 5:39 am
  • I just ran into a strangest thing: within transaction, select now() will always return time when transaction started. Same happens with select 'now'::timestamp. This is with 7.0. I have not tested it ...
    Alex PilosovAlex Pilosov
    Oct 18, 2000 at 2:19 am
    Oct 19, 2000 at 11:50 pm
  • Saw Tom's commits, now it breaks here: gmake[3]: Leaving directory `/home/ler/pg-dev/pgsql/src/backend/utils' cc -O -K inline -o postgres access/SUBSYS.o bootstrap/SUBSYS.o catalog/SUBSYS.o ...
    Larry RosenmanLarry Rosenman
    Oct 26, 2000 at 6:36 pm
    Oct 29, 2000 at 5:55 pm
  • Announce: First public release of PgSQL Version 1.0 =================================================== PgSQL v1.0 has been released. This is the first public release of PgSQL. It is available at ...
    Billy G. AllieBilly G. Allie
    Oct 9, 2000 at 10:20 pm
    Oct 13, 2000 at 12:34 pm
  • It seems the length coerce for bpchar is broken since 7.0. In 6.5 when a string is inserted, bpchar() is called to properly clip the string. However in 7.0 (and probably current) bpchar() is not ...
    Tatsuo IshiiTatsuo Ishii
    Oct 17, 2000 at 2:26 am
    Jan 20, 2001 at 4:09 am
  • This patch is causing compilation warnings on HPUX 10.20: gcc -c -I../../../src/include -O1 -Wall -Wmissing-prototypes -Wmissing-declarations -g -o pqcomm.o pqcomm.c In file included from ...
    Tom LaneTom Lane
    Oct 20, 2000 at 3:09 am
    Nov 23, 2000 at 3:37 pm
  • Also possible would be a name like Oracle pg_exp and pg_imp for export and import. (or pg_export and pg_import) Load and unload is often more tied to data only (no dml). I agree that the current name ...
    Andreas ZeugswetterAndreas Zeugswetter
    Oct 16, 2000 at 10:24 am
    Oct 19, 2000 at 8:01 pm
  • I have noticed that some operating system distributors ship custom-patched versions of Autoconf. That is pretty brain-dead because some of the changes make things work worse on other systems. ...
    Peter EisentrautPeter Eisentraut
    Oct 2, 2000 at 8:23 pm
    Jan 18, 2001 at 7:53 pm
  • First, since when are we in the business of hiding away documentation for a supported platform, and second, how does putting installation instructions into a file named "FAQ" make it less "obvious"? ...
    Peter EisentrautPeter Eisentraut
    Oct 17, 2000 at 4:35 pm
    Oct 21, 2000 at 2:23 am
  • While answering the n'th why-is-initdb-failing question that looked like a version mismatch problem, it occurred to me to wonder why we don't make initdb verify that the executable and library files ...
    Tom LaneTom Lane
    Oct 26, 2000 at 3:42 pm
    Oct 28, 2000 at 4:39 pm
  • http://www.l-t.ee/marko/pgsql/pgcrypto-0.1.tar.gz (11k) Here is a implementation of crypto hashes for PostgreSQL. It exports 2 functions to SQL level: digest(data::text, hash_name::text) which ...
    Marko KreenMarko Kreen
    Oct 19, 2000 at 5:15 pm
    Oct 23, 2000 at 11:15 pm
  • I got early access to the UnixWare 7.1.1b Feature Supplement UnixWare/OpenServer Development Kit (UDK FS for short). PostgreSQL 7.0.2 compiles CLEAN (ish...) and we can now support the C++ stuff. The ...
    Larry RosenmanLarry Rosenman
    Oct 21, 2000 at 2:44 am
    Oct 23, 2000 at 8:33 pm
  • Hi, I would like to know if postgres comes with some kind of backup application? I mean something that would do database backup and restore, something like informix's ontape and logical logs. Thanks ...
    Martin A. MarquesMartin A. Marques
    Oct 2, 2000 at 11:42 am
    Oct 14, 2000 at 8:16 pm
  • I was fooling around with exactly that point a couple weeks ago. You'd think it would be easy to allow extra parentheses around a sub-select, but I couldn't figure out any way to do it that didn't ...
    Tom LaneTom Lane
    Oct 25, 2000 at 4:28 pm
    Oct 28, 2000 at 8:41 pm
  • First a core dump which can be relieved by: Index: catalog.c =================================================================== RCS file: ...
    Patrick WelchePatrick Welche
    Oct 21, 2000 at 5:17 pm
    Oct 25, 2000 at 8:22 pm
  • I've just successfully completed an out of the box VPATH build of PostgreSQL (i.e., putting the object files in a different directory structure than the source files). It should be ready to go within ...
    Peter EisentrautPeter Eisentraut
    Oct 18, 2000 at 5:16 pm
    Oct 20, 2000 at 6:55 pm
  • I've just tried to checkout a clean copy of the cvs tree, and it seems that configure is missing a substitutions in Makefile.global.in, ie: make: *** No rule to make target ...
    Peter MountPeter Mount
    Oct 30, 2000 at 9:42 am
    Nov 21, 2000 at 3:23 am
  • Does it mean that there would still be inconsistency between tables and their indexes ? Regards. Hiroshi Inoue
    Hiroshi InoueHiroshi Inoue
    Oct 30, 2000 at 5:36 am
    Nov 2, 2000 at 5:37 pm
  • Okay, here's my attempt at fixing the problems with parentheses in subqueries. It passes the normal 'runcheck' tests, and I've tried a few simple things like select 1 as foo union (((((select 2))))) ...
    Kevin O'GormanKevin O'Gorman
    Oct 28, 2000 at 1:11 am
    Oct 30, 2000 at 3:43 am
  • Would it be possible to add a path spec to the --with-perl configure option so that if we have 2 or more PERL versions on the system we can pick which one to use? Larry -- Larry Rosenman ...
    Larry RosenmanLarry Rosenman
    Oct 25, 2000 at 9:45 am
    Oct 25, 2000 at 8:12 pm
  • Ok, I can't find it on the web site.... How do I check out the current tree? (I want to play with Peter_E's changes...) LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 (voice) ...
    Larry RosenmanLarry Rosenman
    Oct 22, 2000 at 11:20 pm
    Oct 23, 2000 at 1:13 am
  • ... with a blinding flash ... The VACUUM funnies I was complaining about before may or may not be real bugs, but they are not what's biting Alfred. None of them can lead to the observed crashes ...
    Tom LaneTom Lane
    Oct 17, 2000 at 12:36 am
    Oct 18, 2000 at 3:52 pm
  • Sparc solaris 2.7 with postgres 7.0.2 It seems to be reproducable, the server crashes on us at a rate of about every few hours. Any ideas? GNU gdb 4.17 Copyright 1998 Free Software Foundation, Inc. ...
    Dan MoschukDan Moschuk
    Oct 12, 2000 at 4:47 pm
    Oct 12, 2000 at 11:11 pm
  • Rangetable leakage, sounds like --- the two queries are sharing the same list of rangetable entries, and that's what the planner joins over. Not sure if it's *good* that they share the same rtable ...
    Tom LaneTom Lane
    Oct 19, 2000 at 11:36 pm
    Oct 23, 2000 at 9:22 pm
  • Does anyone know what backend/tioga is for? It's not Spanish for TOAST, is it? :-) It looks like it wasn't compilable for quite a while. -- Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/
    Peter EisentrautPeter Eisentraut
    Oct 11, 2000 at 5:57 pm
    Oct 13, 2000 at 7:11 pm
  • Hi, I was wondering if anyone could offer me some pointers in extending the C++ classes used for client applications? I'm interested in developing a set of C++ classes which will interact directly ...
    Randy JonaszRandy Jonasz
    Oct 3, 2000 at 6:45 pm
    Oct 9, 2000 at 7:36 am
  • (This is mostly directed at Vadim, but kibitzing is welcome.) Here's what I plan to do to make DROP TABLE rollbackable and clean up the handling of CREATE TABLE rollback. Comments? Overview: 1. ...
    Tom LaneTom Lane
    Oct 27, 2000 at 9:21 pm
    Nov 9, 2000 at 12:27 am
  • The difference for a cleanup would be, that it does not need to be rolled back as a whole (like current vacuum). A cleanup could be partly done, and resumed later, thus a sofisticated cleanup could ...
    Andreas ZeugswetterAndreas Zeugswetter
    Oct 13, 2000 at 7:42 am
    Oct 17, 2000 at 10:17 am
  • I just spent a fruitless half hour rooting around the website for our elephant-in-crystal logo. I need a moderately large, clean copy for the title slide of a presentation. Where's the original ...
    Tom LaneTom Lane
    Oct 12, 2000 at 5:12 am
    Oct 12, 2000 at 4:45 pm
  • I have installed this in the current source tree, ready for 7.1. I have installed -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | ...
    Bruce MomjianBruce Momjian
    Oct 2, 2000 at 3:26 am
    Oct 10, 2000 at 3:48 pm
  • Has anybody been getting pgsql-committers messages the last few days? -- Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/
    Peter EisentrautPeter Eisentraut
    Oct 2, 2000 at 7:36 pm
    Oct 9, 2000 at 10:37 pm
  • What happen with www.postgresql.org? My browser is always redirected to http://www.cz.postgresql.org/. But I haven't some terrible mirror (with last change "July 1999"), I want nice and native PG's ...
    Karel ZakKarel Zak
    Oct 2, 2000 at 7:21 am
    Oct 9, 2000 at 10:36 pm
  • Hiroshi and I had a discussion last night that needs to reach a wider audience than just the bystanders on pgsql-committers. Let me see if I can reconstruct the main points. In 7.0, a LIMIT clause ...
    Tom LaneTom Lane
    Oct 27, 2000 at 4:18 pm
    Nov 2, 2000 at 5:25 pm
  • Sorry, I don't understand this sentence. Tom suggested placing a shared lock on any table that is accessed until end of tx. Noone can alter table until all users have closed their txns and not ...
    Andreas ZeugswetterAndreas Zeugswetter
    Oct 23, 2000 at 9:52 am
    Oct 24, 2000 at 9:52 am
  • Good idea(s). Thanks for cleaning up the error messages... - Thomas
    Thomas LockhartThomas Lockhart
    Oct 23, 2000 at 6:37 am
    Oct 23, 2000 at 10:33 pm
  • Hello, I tried to do backup/restore of empty database. And get the following error: Connecting to database for restore Connecting to test4 as postgres Creating OPERATOR = Archiver(db): Could not ...
    Denis PerchineDenis Perchine
    Oct 21, 2000 at 11:04 am
    Oct 22, 2000 at 6:19 pm
  • pg_dump uses the OID of template1 as the last builtin OID, but this now seems broken in CVS (it returns 1). Should this work? If not, what is the recommended way to find the last built-in OID? ...
    Philip WarnerPhilip Warner
    Oct 21, 2000 at 12:33 pm
    Oct 22, 2000 at 1:57 am
  • I notice that ProcessUtility() calls SetQuerySnapshot() for FETCH and COPY TO statements, and nothing else. Seems to me this is very broken. Isn't a query snapshot needed for any utility command that ...
    Tom LaneTom Lane
    Oct 19, 2000 at 4:43 am
    Oct 19, 2000 at 8:01 pm
  • I have removed the new --export-dynamic item from the Solaris FAQ. Looks like 7.1 has it fixed already. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your ...
    Bruce MomjianBruce Momjian
    Oct 19, 2000 at 3:19 am
    Oct 19, 2000 at 4:12 pm
  • -rw------- 1 postgres postgres 438386688 Oct 17 20:27 ./data/pg_group bash-2.04$ (as you can see, psql was not responding after the last drop user, I hit control-c and is said Cancel request sent, ...
    MatthewMatthew
    Oct 18, 2000 at 1:36 am
    Oct 19, 2000 at 2:33 pm
  • I just wanted to repost this one more time in case developers didn't catch it. I have a reliable way to make postgresql crash after a couple of hours over here and a backtrace that looks like a good ...
    Alfred PerlsteinAlfred Perlstein
    Oct 4, 2000 at 7:06 am
    Oct 9, 2000 at 2:55 am
  • Hi, Well, I discovered a strange behavior (ie 85/0.0085 < 10000 ) Is my SQL wrong or is it postgres ? We are running 7.02 (but also 6.x) on a alpha (alphaev6) box. Thanks in advance. jc Here is a ...
    Jean-Christophe PazzagliaJean-Christophe Pazzaglia
    Oct 6, 2000 at 12:28 pm
    Oct 6, 2000 at 3:45 pm
  • I seem to have trouble again getting cvs logs for just the 7.0.X branch. I am running this command from a cvs checkout tree of 7.0.X: $ cvs log -d' 2000-06-07 00:00:00 GMT' -rREL7_0_PATCHES And am ...
    Bruce MomjianBruce Momjian
    Oct 29, 2000 at 6:12 pm
    Nov 3, 2000 at 12:26 am
  • I never saw much traffic regarding Karel's work on making stored proceedures: http://people.freebsd.org/~alfred/karel-pgsql.txt What happened with this? It looked pretty interesting. :( -- -Alfred ...
    Alfred PerlsteinAlfred Perlstein
    Oct 31, 2000 at 11:11 pm
    Nov 1, 2000 at 9:53 am
Oct 2000
123456
Group Navigation
period‹ prev | Oct 2000 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions264
posts1,296
users133
websitepostgresql.org...
irc#postgresql

133 users for October 2000

Tom Lane: 234 posts Bruce Momjian: 201 posts Peter Eisentraut: 107 posts Larry Rosenman: 68 posts The Hermit Hacker: 61 posts Vadim Mikheev: 47 posts Andreas Zeugswetter: 40 posts Philip Warner: 40 posts Hiroshi Inoue: 36 posts Alex Pilosov: 27 posts Alfred Perlstein: 26 posts Lamar Owen: 23 posts Vince Vielhaber: 22 posts Kevin O'Gorman: 20 posts Stephan Szabo: 18 posts Thomas Lockhart: 16 posts Hannu Krosing: 15 posts Tatsuo Ishii: 15 posts Chris: 12 posts Marko Kreen: 11 posts
show more
Archives