FAQ

PostgreSQL > pgsql-hackers > December 2001

Search Discussions

143 discussions - 962 posts

  • After some further experimentation, I believe I understand the reason for the reports we've had of 7.2 producing heavy context-swap activity where 7.1 didn't. Here is an extract from tracing lwlock ...
    Tom LaneTom Lane
    Dec 29, 2001 at 7:10 pm
    Jan 23, 2002 at 7:16 pm
  • After reading through the strong opinions about the location of the configuration files in the current and in previous threads, I must concede that despite the best intentions, the current ...
    Peter EisentrautPeter Eisentraut
    Dec 18, 2001 at 10:24 pm
    Dec 30, 2001 at 3:20 am
  • what is meant by the TODO-item "Disallow missing columns in INSERT ... VALUES, per ANSI" ? rgds Pavlo Baron
    Pavlo BaronPavlo Baron
    Dec 27, 2001 at 8:57 pm
    Mar 9, 2002 at 3:26 pm
  • Hi, I'm trying to clean up a bug in pg_dump where specifying a table with the '-t tablename' argument fails to generate the necessary CREATE SEQUENCE statements for columns of type SERIAL that are ...
    Brent VernerBrent Verner
    Dec 15, 2001 at 3:53 am
    Mar 8, 2002 at 1:28 am
  • I was browsing through the TODO list and stumbled upon the connection pooling item discussed over a year ago. Is it safe to assume that since it's still listed in the TODO that it's still a desirable ...
    Michael OwensMichael Owens
    Dec 18, 2001 at 12:28 am
    Dec 20, 2001 at 5:48 am
  • I know I have expressed these concerns before but lost the argument, or at least no one rallied to my position, but I feel I have to mention these again because they came up during beta. My first ...
    Bruce MomjianBruce Momjian
    Dec 18, 2001 at 2:43 pm
    Dec 20, 2001 at 1:45 am
  • We've got most platforms ironed out, with just a few left to get a definitive report. It looks like we'll end up dropping a few platforms for this release (the first time in several years that the ...
    Thomas LockhartThomas Lockhart
    Dec 7, 2001 at 4:14 pm
    Dec 16, 2001 at 2:28 am
  • I guess I will maintain this for people who want it. This allows postmaster -C /etc/pgsql/mydb.conf The "-C" option specifies a configuration file. In the config file there are two more options: ...
    Mark L. WoodwardMark L. Woodward
    Dec 16, 2001 at 2:39 pm
    Dec 20, 2001 at 3:02 am
  • Manuel SugawaraManuel Sugawara
    Dec 3, 2001 at 7:42 pm
    Mar 7, 2002 at 8:48 pm
  • I have added the option of explicitly specifying a postgresql.conf (-C) file on the command line. I have also added two config file entries: pghbaconfig, and pgdatadir. "pghbaconfig" allows multiple ...
    Mark L. WoodwardMark L. Woodward
    Dec 8, 2001 at 4:01 pm
    Dec 13, 2001 at 2:40 am
  • Okay, here's a follow up to my previous messages "ACK table corrupted, unique index violated." I've been trying to clean up the corruptions that i mentioned earlier. I felt most comfortable shutting ...
    Brian HirtBrian Hirt
    Dec 12, 2001 at 9:02 pm
    Dec 19, 2001 at 5:23 pm
  • Hi, While daily using pg_dump for a while the need for the following features grew significantly. I finally came to the point of implementing them myself ;-) - pg_dump outputs the data unsorted but ...
    Christof PetigChristof Petig
    Dec 6, 2001 at 11:05 am
    Dec 13, 2001 at 1:41 pm
  • Having heard nothing on the list yet about the reported unsuccessful parallel regression tests on Cygwin with 7.2b3, I thought I'd have a play myself having found a spare few minutes. System: Windows ...
    Dave PageDave Page
    Dec 12, 2001 at 10:16 pm
    Dec 17, 2001 at 3:38 pm
  • I haven't tested with the new 7.2 betas, but here are some results from 7.1. We have a developement computer, IBM x series 250, with 4 processors (PIII Xeon 750Mhz), 1 Gb memory and 2SCSI disks ...
    Jussi MikkolaJussi Mikkola
    Dec 18, 2001 at 10:55 am
    Jan 9, 2002 at 10:02 am
  • Things have firmed up nicely for the 7.2 release. We currently have several NetBSD platforms which have not reported success for 7.2, maybe only because they have a relatively small user base (and ...
    Thomas LockhartThomas Lockhart
    Dec 13, 2001 at 4:03 pm
    Dec 14, 2001 at 5:17 am
  • Hi, I threw this to cygwin but it doesn't seem to have elisited any interest over the weekend so I'm sending it here as a beta problem (not entirely sure if this is correct or if it should go to ...
    Henshall, Stuart - WCPHenshall, Stuart - WCP
    Dec 3, 2001 at 10:07 am
    Dec 4, 2001 at 11:56 pm
  • In HEAD contrib/dbase: gcc -pipe -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -I../../src/ interf aces/libpq -I. -I../../src/include -c -o dbf2pg.o dbf2pg.c dbf2pg.c:19: iconv.h: No such ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Dec 21, 2001 at 3:26 am
    Dec 21, 2001 at 6:22 am
  • In the vacuum tuple-chain moving logic, shouldn't the lines that update the new tuple's t_ctid (vacuum.c lines 1882-1891 in current sources) be moved up to before the log_heap_move call at line 1866? ...
    Tom LaneTom Lane
    Dec 19, 2001 at 12:22 am
    Jan 3, 2002 at 5:54 am
  • I noticed an incorrect example in doc/src/sgml/func.sgml... brent=# SELECT EXTRACT(SECOND FROM TIME '17:12:28.5'); date_part ----------- 28 (1 row) The documentation says this should return 28.5. ...
    Brent VernerBrent Verner
    Dec 4, 2001 at 1:27 pm
    Dec 29, 2001 at 4:54 pm
  • With the freshly retrieved current source, now PostgreSQL is running fine on an AIX 5L box. Thanks Tom. BTW, I have done some benchmarking using pgbench on this machine and found that 7.2 is almost ...
    Tatsuo IshiiTatsuo Ishii
    Dec 17, 2001 at 6:57 am
    Dec 22, 2001 at 12:27 am
  • This is an intermediate report for AIX 5L port. o gmake check sometimes hungs up o pgbench almost always hungs up In summary current on AIX 5L is quite unstable(7.1 worked very well). FYI, here are ...
    Tatsuo IshiiTatsuo Ishii
    Dec 5, 2001 at 8:44 am
    Dec 15, 2001 at 2:16 am
  • Hi All, You know how when you create a foreign key in postgres it isn't automatically indexed, and it seems to me that it's very useful to have indexed foreign keys, especially if you use lots of ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Dec 21, 2001 at 2:46 am
    Jan 3, 2002 at 6:26 am
  • Hi, Is it me (who hasn't read some FAQ or a doc/man page) or it's a bug in the psql interactive terminal? A sample session is provided at the bottom. I just typed a simple CREATE TABLE command and ...
    Serguei MokhovSerguei Mokhov
    Dec 2, 2001 at 6:58 am
    Dec 28, 2001 at 7:33 pm
  • Well, it'd be an easy enough addition: if (strlen(delim) != 1) elog(ERROR, "COPY delimiter must be a single character"); This isn't multibyte-aware, but then neither is the implementation; delimiters ...
    Tom LaneTom Lane
    Dec 4, 2001 at 8:16 pm
    Dec 28, 2001 at 7:43 pm
  • So far I think I have done the SunOS4 port except the parallel regression test. Unfortunately the machine is in production and I could not increase the shmem parameters. Instead I have done the ...
    Tatsuo IshiiTatsuo Ishii
    Dec 5, 2001 at 2:49 am
    Dec 19, 2001 at 7:15 pm
  • I may have some spare hacking time coming up, and I was thinking about adding a PL (Scheme) to PostgreSQL. I've found some code out there for a small Scheme interpreter, but it appears to be licensed ...
    Doug McNaughtDoug McNaught
    Dec 5, 2001 at 6:17 pm
    Dec 6, 2001 at 8:19 pm
  • The problem here is that the planner is being way too optimistic about the selectivity of LIKE '%DAVID%' --- notice the estimate that only one matching row will be found in cliente, rather than 54 as ...
    Tom LaneTom Lane
    Dec 4, 2001 at 3:21 pm
    Dec 29, 2001 at 5:08 am
  • configure unfortunately does not include the tcl library for linking libpgtcl.so on AIX :-( In the meantime Jacques, your tcl installation should have a shared tcl library (libtcl8.2.so) or better ...
    Andreas ZeugswetterAndreas Zeugswetter
    Dec 14, 2001 at 9:01 am
    Dec 20, 2001 at 1:35 am
  • Apparently there's been a change in the way views are handled within PostreSQL. The following program works fine in earlier versions. It also works if the select on the view is replaced with a direct ...
    Don BaccusDon Baccus
    Dec 17, 2001 at 7:47 pm
    Dec 19, 2001 at 8:59 pm
  • I'm looking at gram.y to munge the precision support for date/time per recent discussions, and am noticing once again the extensions added to support ODBC by allowing empty parens after some ...
    Thomas LockhartThomas Lockhart
    Dec 7, 2001 at 4:43 pm
    Dec 11, 2001 at 2:41 pm
  • Hello, After fresh install of PostgreSQL 7.1.3 I was having one particular query (JOIN), running for several hours. Upon closer investigation, it was returning weird EXPLAIN 'optimisations' (in ...
    Daniel KalchevDaniel Kalchev
    Dec 3, 2001 at 4:59 pm
    Dec 3, 2001 at 10:53 pm
  • Is there any reason why recursive SQL functions are not allowed in PG 7.2? After all this: create function foo() returns setof integer as 'select 1' language 'sql'; create or replace function foo() ...
    Don BaccusDon Baccus
    Dec 17, 2001 at 6:30 pm
    Feb 23, 2002 at 7:23 pm
  • Got a report the other day of a "problem" with pg_dump where, if in the middle of a dump, someone happens to drop a table, it errors out with: SQL query to dump the contents of Table 'server_2' did ...
    Marc G. FournierMarc G. Fournier
    Dec 17, 2001 at 7:10 pm
    Jan 12, 2002 at 2:09 am
  • See: ./configure --prefix=/usr/lib/postgresql \ --with-unixodbc \ --enable-odbc \ --with-openssl \ --with-pam \ --with-python \ --with-perl \ --with-tcl \ --enable-nls \ --enable-multibyte \ ...
    Karel ZakKarel Zak
    Dec 20, 2001 at 1:53 pm
    Dec 29, 2001 at 9:44 pm
  • Someone reported to me that they can't get their queries to use indexes. It turns out this is because timestamp() has pg_proc.proiscachable set to false in many cases. Date() also has this in some ...
    Bruce MomjianBruce Momjian
    Dec 26, 2001 at 5:36 am
    Dec 27, 2001 at 4:45 am
  • Maybe I am missing something obvious, but I am unable to load larger tables (~300k rows) with COPY command that pg_dump by default produces. Yes, dump as INSERTs works but is slow. "Cant" as in "it ...
    Marko KreenMarko Kreen
    Dec 11, 2001 at 3:09 pm
    Dec 11, 2001 at 7:39 pm
  • Where are we on the RC1 release? What are the open items? I have gotten lost. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 ...
    Bruce MomjianBruce Momjian
    Dec 20, 2001 at 11:15 pm
    Jan 3, 2002 at 6:11 am
  • I just found out something about Oracle which that looks like something that could be doable in PostgreSQL. What do you all think: Oracle's version is something like this: create [public] database ...
    Mark L. WoodwardMark L. Woodward
    Dec 6, 2001 at 6:26 pm
    Dec 7, 2001 at 5:26 pm
  • Bizarre. That patch was never committed. If you check src/backend/commands/command.c and search for 'CONSTR_' you'll notice that the CONSTR_UNIQUE function I implemented is there, but CONSTR_PRIMARY ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Dec 4, 2001 at 2:22 am
    Jan 2, 2002 at 3:36 am
  • I have just run 7.2b4 on FreeBSD/alpha. The float8 and geometry tests failed. Attatched is the regression stuff. I have submitted it to the database. I'm not certain how significant the results are. ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Dec 18, 2001 at 7:20 am
    Dec 19, 2001 at 3:48 pm
  • hello hackers here is the patch for the INSERT INTO t VALUES (..., DEFAULT, ...) from the current TODO list. It's my first patch so please forgive me if it's not the best solution - I'm now learning ...
    Pavlo BaronPavlo Baron
    Dec 27, 2001 at 11:04 am
    Mar 8, 2002 at 1:01 am
  • Hi Marko, Just testing pgcrypto on freebsd/alpha. I get some warnings: gcc -pipe -O -Wall -Wmissing-prototypes -Wmissing-declarations -fpic -DPIC -DRAND_SILLY -I. -I. -I../../src/include -c - o ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Dec 21, 2001 at 3:42 am
    Jan 3, 2002 at 7:33 am
  • This has got to stop. We've seen "my cursor keys don't work in psql", now we see "compression doesn't work" every so often. Somehow we have to get deterministic output from configure without "paying ...
    Peter EisentrautPeter Eisentraut
    Dec 4, 2001 at 9:21 pm
    Dec 28, 2001 at 9:51 pm
  • I just looked at the source for dbase. I have a long hacked version of this. The one in contrib is based on a newer version of what I have been using. It is funny, because I made some of the same ...
    Mark L. WoodwardMark L. Woodward
    Dec 21, 2001 at 7:50 pm
    Jan 3, 2002 at 8:04 am
  • Presently, the RESUME_INTERRUPTS() and END_CRIT_SECTION() macros implicitly do a CHECK_FOR_INTERRUPTS(); that is, if a cancel request arrived during the interrupt-free section it will be serviced ...
    Tom LaneTom Lane
    Dec 30, 2001 at 6:46 pm
    Dec 31, 2001 at 5:02 pm
  • Peter EisentrautPeter Eisentraut
    Dec 22, 2001 at 9:41 pm
    Dec 24, 2001 at 1:17 pm
  • Changing the default data location at this point would imho be a major hassle for those actually using the default. Thus I object to changing it. Andreas
    Andreas ZeugswetterAndreas Zeugswetter
    Dec 19, 2001 at 9:52 am
    Dec 20, 2001 at 5:12 pm
  • I was wondering, when we start to reuse a WAL file, do we know that all dirty buffers modified in that WAL file have been flushed to disk? Do we fsync() dirty buffers at time of checkpoint, and do we ...
    Bruce MomjianBruce Momjian
    Dec 19, 2001 at 3:03 am
    Dec 19, 2001 at 4:34 am
  • Hi all, I've examined a cygwin hangup issue for a pretty long time. It seems there are plural causes though it's hard for me to identify them all. Anyway I found some unexpected SIGALRM cases. It may ...
    Hiroshi InoueHiroshi Inoue
    Dec 16, 2001 at 9:53 pm
    Dec 17, 2001 at 3:15 am
  • I'm having a very scary problem. First, here's my system: smp dual PIII800 512MB memory running redhat 6.2 kernel 2.2.18 PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC egcs-2.91.66 In a ...
    Brian HirtBrian Hirt
    Dec 12, 2001 at 5:39 pm
    Dec 13, 2001 at 12:22 am
Dec 2001
123
Group Navigation
period‹ prev | Dec 2001 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions143
posts962
users117
websitepostgresql.org...
irc#postgresql

117 users for December 2001

Tom Lane: 186 posts Bruce Momjian: 131 posts Thomas Lockhart: 53 posts Peter Eisentraut: 48 posts Mark L. Woodward: 35 posts Christopher Kings-Lynne: 33 posts Hannu Krosing: 24 posts Don Baccus: 23 posts Tatsuo Ishii: 20 posts Doug McNaught: 19 posts Brent Verner: 17 posts Hiroshi Inoue: 17 posts Pavlo Baron: 16 posts Dave Page: 13 posts Stephan Szabo: 13 posts Andreas Zeugswetter: 12 posts Karel Zak: 12 posts Serguei Mokhov: 12 posts Daniel Kalchev: 11 posts Lamar Owen: 11 posts
show more
Archives