FAQ

PostgreSQL > pgsql-hackers > November 2000

Search Discussions

240 discussions - 1,390 posts

  • Hello, I've looked at the resources available through the web page to CVS and other stuff, however I cant find a statement of whats likely to be in 7.1 and what is planned for later. Reason: I want ...
    John HuttleyJohn Huttley
    Nov 23, 2000 at 5:00 am
    Dec 7, 2000 at 8:28 pm
  • You shouldn't normally use it - postmaster will start backend each 3-5 minutes to do this automatically. Yes, though we can change this. We also can implement now feature that Bruce wanted so long ...
    Mikheev, VadimMikheev, Vadim
    Nov 8, 2000 at 6:01 pm
    Jan 24, 2001 at 1:27 pm
  • Here is a patch for allowing the syslog facility to be set. Index: doc/src/sgml/runtime.sgml =================================================================== RCS file: ...
    Larry RosenmanLarry Rosenman
    Nov 12, 2000 at 5:16 pm
    Nov 16, 2000 at 5:51 am
  • We can do the same thing with a 5-line change in pg_dumpall. We don't need an extra copy&pasted program for that. -- Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/
    Peter EisentrautPeter Eisentraut
    Nov 2, 2000 at 7:09 pm
    Nov 6, 2000 at 8:47 am
  • We've hacked up pg_dump so that it won't dump objects inherited from template1. Unfortunately I have realized there are a couple of serious problems: 1. What if the inherited object is a table or a ...
    Tom LaneTom Lane
    Nov 3, 2000 at 12:35 am
    Nov 17, 2000 at 1:55 pm
  • ... and I am not going to allow 7.1 to go out without a fix for this class of problems. I'm fed up ;-) As near as I can tell from the setlocale() man page, the only locale categories that are really ...
    Tom LaneTom Lane
    Nov 24, 2000 at 9:20 pm
    Nov 27, 2000 at 6:40 pm
  • Philip pointed out awhile back that it does not work to load a 7.0.* dump into current sources if the dumped database contains any procedural language definitions. The dumped handler-function ...
    Tom LaneTom Lane
    Nov 10, 2000 at 5:07 pm
    Nov 20, 2000 at 9:05 pm
  • Hi, I was looking at the ALTER TABLE DROP CONSTRAINT bit of PostgreSQL, and I started thinking about trying to implement it (as a bit of mental exercise). (And because it's highly annoying not being ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Nov 20, 2000 at 7:15 am
    Nov 23, 2000 at 3:44 pm
  • I'm tryin to figure out how to speed up udmsearch when run under postgresql, and am being hit by atrocious performance when using a LIKE query ... the query looks like: SELECT ...
    The Hermit HackerThe Hermit Hacker
    Nov 6, 2000 at 1:05 am
    Nov 7, 2000 at 1:09 am
  • I'm trying to compile the CVS (fresh download) of postgres and I get this running the configure script: checking for tzname... yes checking for union semun... no checking for struct sockaddr_un... ...
    Martin A. MarquesMartin A. Marques
    Nov 3, 2000 at 11:08 pm
    Nov 9, 2000 at 5:17 pm
  • We've expended a lot of worry and discussion in the past about what happens if the OID generator wraps around. However, there is another 4-byte counter in the system: the transaction ID (XID) ...
    Tom LaneTom Lane
    Nov 3, 2000 at 10:47 pm
    Jan 20, 2001 at 4:03 pm
  • The last batch of commits break on FreeBSD 4.2-STABLE. $ uname -a FreeBSD lerbsd.lerctr.org 4.2-STABLE FreeBSD 4.2-STABLE #90: Tue Nov 28 04:07:50 CST 2000 ...
    Larry RosenmanLarry Rosenman
    Nov 29, 2000 at 1:35 am
    Dec 5, 2000 at 3:23 pm
  • This snippet in xlog.c makes we wonder... else if (ControlFile- state == DB_IN_RECOVERY) { elog(LOG, "Data Base System was interrupted being in recovery at %s\n" "\tThis propably means that some data ...
    Peter EisentrautPeter Eisentraut
    Nov 21, 2000 at 10:00 pm
    Dec 4, 2000 at 9:16 pm
  • This is just a curiosity. Why is the default postgres block size 8192? These days, with caching file systems, high speed DMA disks, hundreds of megabytes of RAM, maybe even gigabytes. Surely, 8K is ...
    Mark L. WoodwardMark L. Woodward
    Nov 27, 2000 at 11:27 pm
    Nov 29, 2000 at 1:25 pm
  • I have to agree with Peter E. on this patch: it's poorly thought out. I don't mind the idea of being able to relocate the socket file, but the client-side interface they've chosen is silly. Having to ...
    Tom LaneTom Lane
    Nov 13, 2000 at 5:35 pm
    Nov 22, 2000 at 1:40 am
  • At present the Unix socket's location is hard-coded as /tmp. As a result of a bug report, I have moved it in the Debian package to /var/run/postgresql/. (The bug was that tmpreaper was deleting it ...
    Oliver ElphickOliver Elphick
    Nov 18, 2000 at 12:38 am
    Nov 30, 2000 at 6:08 pm
  • Situation: 7.1 has a new backend interface for loadable modules. (but it supports old 7.0 interface too) Now the problem: How do you tell the backend with what interface to use for particular ...
    Marko KreenMarko Kreen
    Nov 16, 2000 at 3:47 pm
    Nov 23, 2000 at 3:15 pm
  • How will they wait? Without a semaphore involved, your answer must be either "timed sleep" or "busy-wait loop", neither of which is attractive ... regards, tom lane
    Tom LaneTom Lane
    Nov 18, 2000 at 5:17 am
    Jan 24, 2001 at 2:25 pm
  • Note: CC'd to Hackers, as this has wandered into deeper feature issues. Tom Lane wrote: This does have an unfortunate denial-of-service implication, where an attack can effectively suck up all ...
    Ron ChmaraRon Chmara
    Nov 26, 2000 at 12:26 am
    Nov 27, 2000 at 6:44 pm
  • Thought this may be of interest to some... http://www.phpbuilder.com/columns/tim20001112.php3 Michael Fork - CCNA - MCP - A+ Network Support - Toledo Internet Access - Toledo Ohio
    Michael ForkMichael Fork
    Nov 13, 2000 at 4:39 am
    Nov 26, 2000 at 4:36 am
  • I've been examining the pg_dump source and output, and I've come to the conclusion that I can modify it so that UNIQUE constraints appear as part of the CREATE TABLE statement, rather than as a ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Nov 22, 2000 at 8:00 am
    Nov 23, 2000 at 3:44 am
  • Anyone care if I build a patch to kill the -m486 type options in the following files: $ grep -i -- 486 * bsdi: i?86) CFLAGS="$CFLAGS -m486";; freebsd:CFLAGS='-O2 -m486 -pipe' univel:CFLAGS='-v -O -K ...
    Larry RosenmanLarry Rosenman
    Nov 14, 2000 at 9:42 pm
    Nov 16, 2000 at 5:30 am
  • Here's what I'm planning to do to make the world safe for backup/restore of user-added template1 data: 1. pg_database will have two new boolean columns, dbistemplate and dballowconn --- if ...
    Tom LaneTom Lane
    Nov 13, 2000 at 4:50 pm
    Nov 15, 2000 at 5:04 am
  • Well, yes. Why isn't it? Full text indexing should be just as much a feature as any other key feature in PG. With the advent of unlimited file and record lengths in 7.1, this would be a good time to ...
    John HuttleyJohn Huttley
    Nov 28, 2000 at 1:51 am
    Nov 28, 2000 at 3:05 pm
  • I have a program that does a: DECLARE getsitescursor CURSOR FOR select... I ^C'd it and it didn't properly shut down the channel to postgresql and I got this crash: #0 0x4828ffc8 in kill () from ...
    Alfred PerlsteinAlfred Perlstein
    Nov 10, 2000 at 1:05 am
    Nov 11, 2000 at 10:25 am
  • Hi, Remember also that the GiST library has been integrated into PG, (my brother is doing some thesis workon that at the moment), and you can create new index types relatively quickly (assuming that ...
    Michael AnsleyMichael Ansley
    Nov 26, 2000 at 11:32 am
    Nov 28, 2000 at 5:07 am
  • Just playing with the syslog functionality on 7.1devel, and the explain output looks weird to me: Nov 22 14:58:44 lerami pg-test[4005]: [2] DEBUG: MoveOfflineLogs: skip 0000000000000006 Nov 22 ...
    Larry RosenmanLarry Rosenman
    Nov 22, 2000 at 9:01 pm
    Nov 26, 2000 at 8:19 pm
  • I like this "not really a database" idea. Might even be something for $libdir, no ? Then all that would be needed is a command that creates a database from this location instead of template1. Andreas
    Andreas ZeugswetterAndreas Zeugswetter
    Nov 9, 2000 at 7:57 am
    Nov 10, 2000 at 8:38 am
  • I think alot of it has to do with the web server/db setup not pg. They are using Apache/PHP and looking at their code every page has the additional overhead of making the db connection. Now if they ...
    Carl garlandCarl garland
    Nov 15, 2000 at 1:42 pm
    Dec 1, 2000 at 3:12 am
  • Trying to compile current sources using: ./configure --prefix=/home/ler/pg-test --enable-syslog \ --with-CXX --with-perl --enable-multibyte --enable-cassert \ --with-openssl --with-tcl \ ...
    Larry RosenmanLarry Rosenman
    Nov 25, 2000 at 10:24 pm
    Nov 27, 2000 at 2:06 am
  • Configured as: CC=cc CXX=CC ./configure --prefix=/home/ler/pg-test --enable-syslog --with-CXX --with-perl --enable-multibyte --with-includes=/usr/local/include --with-libs=/usr/local/lib I get: gmake ...
    Larry RosenmanLarry Rosenman
    Nov 20, 2000 at 3:06 pm
    Nov 20, 2000 at 7:38 pm
  • Hi I fixed a few bugs caused by SearchSysCacheTuple() recently. There seems to remain more similar bugs. They are ill-natured and so we seem to have to avoid such bugs by some means. The simplest way ...
    Hiroshi InoueHiroshi Inoue
    Nov 14, 2000 at 5:50 am
    Nov 16, 2000 at 4:51 am
  • [Cced to hackers list] As long as frontend side knows the current client side encoding is Big5, this should be no problem. At least for libpq. It examins the first byte of Big5. If it is greater than ...
    Tatsuo IshiiTatsuo Ishii
    Nov 14, 2000 at 5:52 am
    Dec 30, 2000 at 3:08 am
  • Why is a "select * from table1 where field in (select field from table2 where condition )" is so dramatically bad compared to: "select * from table1, table2 where table1.field = table2.field and ...
    Mark L. WoodwardMark L. Woodward
    Nov 29, 2000 at 10:50 pm
    Dec 10, 2000 at 7:06 pm
  • Nope. Still fails... *** ./expected/opr_sanity.out Tue Nov 14 13:32:58 2000 --- ./results/opr_sanity.out Mon Nov 20 20:27:46 2000 *************** *** 482,489 **** (p2.pronargs = 1 AND p1.aggbasetype ...
    Larry RosenmanLarry Rosenman
    Nov 21, 2000 at 2:34 am
    Nov 21, 2000 at 10:00 am
  • C code compatible with Informix: int32 intadd (int32 a, int32 b) { return a + b; } This is the same code that was standard in PostgreSQL 7.0 Andreas
    Andreas ZeugswetterAndreas Zeugswetter
    Nov 15, 2000 at 1:44 pm
    Nov 16, 2000 at 4:00 pm
  • One thing that worries me though is, that it extends the sql language, and there has been no discussion about the chosen syntax. Imho the standard embedded SQL syntax (prepare ...) could be a ...
    Andreas ZeugswetterAndreas Zeugswetter
    Nov 2, 2000 at 8:35 am
    Nov 12, 2000 at 11:36 am
  • With the new oid file naming, the alternative database location feature has disappeared. Not good. Also, is there any merit in keeping the #ifdef OLD_FILE_NAMING code path? I could probably go ...
    Peter EisentrautPeter Eisentraut
    Nov 3, 2000 at 9:04 pm
    Nov 6, 2000 at 8:08 pm
  • is anyone working on the port of PostgreSQL for Alpha FreeBSD ?? I have been waiting for over a year very very patiently !!! I really love my Alpha FreeBSD box and I want to use PostgreSQL on it... ...
    Nathan BoegerNathan Boeger
    Nov 3, 2000 at 11:34 pm
    Nov 4, 2000 at 3:39 am
  • Am I misunderstanding how to use rule w/conditionals, or is there a bug in this? -- I love to use Pgsql comments, but find the 'comment on field...' language a bit of a pain for documenting a large ...
    Joel BurtonJoel Burton
    Nov 29, 2000 at 11:04 pm
    Dec 3, 2000 at 11:48 pm
  • how about a .pid/.port/.??? file in the /data directory, and a lock on that? -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: ler@lerctr.org US Mail: 1905 Steamboat Springs ...
    Larry RosenmanLarry Rosenman
    Nov 25, 2000 at 10:40 pm
    Nov 29, 2000 at 10:09 pm
  • TINTERVAL is a poorly supported, old and creaky data type. It is based on ABSTIME, which is not as capable as TIMESTAMP. Maybe. The SQL9x function/operator OVERLAPS is recognized by PostgreSQL 7.x, ...
    Thomas LockhartThomas Lockhart
    Nov 27, 2000 at 6:21 pm
    Nov 28, 2000 at 6:00 pm
  • Sorry if I'm posting to the wrong list, but I don't know which list is appropriate for this question. I've a question concerning compatibilty Postgres <- Oracle. In Oracle, empty strings and null are ...
    Mario WeilguniMario Weilguni
    Nov 27, 2000 at 5:09 pm
    Nov 28, 2000 at 3:04 pm
  • $ psql -U psql: option requires an argument -- U Try -? for help. $ psql -? psql: No match. $ Vince. -- ========================================================================== Vince Vielhaber -- ...
    Vince VielhaberVince Vielhaber
    Nov 19, 2000 at 7:33 pm
    Nov 25, 2000 at 7:28 pm
  • Trying to get my FreeBSD box (lerbsd.lerctr.org, 4.2-BETA) up on current sources. Got this error: make[3]: Entering directory `/home/ler/pg-dev/src/backend/parser' cc -O2 -m486 -pipe -Wall ...
    Larry RosenmanLarry Rosenman
    Nov 14, 2000 at 9:01 pm
    Nov 15, 2000 at 5:58 pm
  • This should not be so. Your setup should definitely work without regression failures. There is something wrong with your dynamic loading of shared libs. Can you give more details, e.g. did you add ...
    Andreas ZeugswetterAndreas Zeugswetter
    Nov 7, 2000 at 9:58 am
    Nov 7, 2000 at 9:58 pm
  • I too got somehow on the list without subscribing. Something is wrong. But I like it and will stay on. :) Bob Kernell Research Scientist Surface Validation Group Atmospheric Sciences Competency ...
    Robert KernellRobert Kernell
    Nov 2, 2000 at 6:23 pm
    Nov 4, 2000 at 12:12 am
  • Which one of these should we use? int4 is a data type, int32 isn't. c.h has DatumGetInt8, but no DatumGetInt64; it also has DatumGetInt32 but no DatumGetInt4. fmgr has PG_GETARG_INT32 et al. ...
    Peter EisentrautPeter Eisentraut
    Nov 15, 2000 at 7:37 pm
    Jan 23, 2001 at 2:24 am
  • There is a special case in nabstime.h for AIX, which imho got swapped. The normal case for me would be INT_MIN and not the 0x80000001. There is a comment that I don't understand at all given the ...
    Andreas ZeugswetterAndreas Zeugswetter
    Nov 10, 2000 at 6:19 pm
    Jan 23, 2001 at 1:19 am
  • I've a problem with initdb on beos with the current tree. (The last one running clean is one month old). when I run initdb, I get the following : $ initdb -d -n Running with debug mode on. Running ...
    Cyril VELTERCyril VELTER
    Nov 26, 2000 at 10:25 am
    Nov 29, 2000 at 4:26 pm
Nov 2000
12345
Group Navigation
period‹ prev | Nov 2000 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions240
posts1,390
users131
websitepostgresql.org...
irc#postgresql

131 users for November 2000

Tom Lane: 295 posts Bruce Momjian: 129 posts Peter Eisentraut: 101 posts Larry Rosenman: 96 posts Philip Warner: 70 posts Andreas Zeugswetter: 60 posts Don Baccus: 55 posts Vadim Mikheev: 46 posts The Hermit Hacker: 42 posts Alfred Perlstein: 30 posts Thomas Lockhart: 30 posts Lamar Owen: 21 posts Christopher Kings-Lynne: 20 posts Hannu Krosing: 19 posts Hiroshi Inoue: 19 posts Martin A. Marques: 18 posts Mitch Vincent: 17 posts Ross J. Reedstrom: 17 posts Tatsuo Ishii: 16 posts Mark L. Woodward: 12 posts
show more
Archives