FAQ

PostgreSQL > pgsql-hackers > August 2004

Search Discussions

234 discussions - 1,601 posts

  • Dear hackers, Some minor comments about the new tablespace feature in 8.0beta1: It seems to me that tablespaces and sequences are not yet prefectly integrated. (1) the "CREATE SEQUENCE foo TABLESPACE ...
    Fabien COELHOFabien COELHO
    Aug 17, 2004 at 2:34 pm
    Oct 13, 2004 at 7:12 pm
  • Here are the open items. I think once they are resolved we can head into beta: pg_dump multiple -t (?) PITR backup status file win32 binary version stamps server logging process (?) pg_autovacuum ...
    Bruce MomjianBruce Momjian
    Aug 2, 2004 at 7:35 pm
    Aug 19, 2004 at 6:49 am
  • Tom, Et Al: Going over the .conf, I just noticed that add_missing_from is still set to True in postgresql.conf.sample. By my memory of our discussion, this option was introduced in 7.4 and was to be ...
    Josh BerkusJosh Berkus
    Aug 8, 2004 at 11:26 pm
    Aug 12, 2004 at 9:30 am
  • Would people like this applied to 8.0? It addresses another of the tablespace deficiency. One item of concern is that it moves the default location for new items created, and does not move items ...
    Bruce MomjianBruce Momjian
    Aug 20, 2004 at 7:47 pm
    Aug 31, 2004 at 6:57 pm
  • I've started work on a patch for this problem. Doing regression tests at present. I'll get back when done. Regards, John
    John HansenJohn Hansen
    Aug 6, 2004 at 4:20 am
    Aug 8, 2004 at 3:11 am
  • I have shortened your paragraph to: Because Win32 is significantly different from the Unix platforms supported in previous releases, this port might have more bugs than other supported platforms in ...
    Bruce MomjianBruce Momjian
    Aug 26, 2004 at 1:05 pm
    Aug 27, 2004 at 2:09 am
  • Kind people, I've brought this up before, and with Dennis BjÅ‘rklund's help, would like to bring it up again. Here's the idea: I'd like to be able to create functions with named parameters that could ...
    David FetterDavid Fetter
    Aug 13, 2004 at 9:41 pm
    Aug 16, 2004 at 11:00 pm
  • 'k, saw Bruce's commit for the pgport stuff under Win32 ... is anyone sitting on that 'one last thing' that should be fixed/corrected before Beta proceeds, or am I clear for doing the bundle up ...
    Marc G. FournierMarc G. Fournier
    Aug 8, 2004 at 2:43 pm
    Aug 10, 2004 at 8:03 pm
  • Hi all, It seems that there is no way to know the postgres uptime, a sort of uptime() function could be usefull. I had recently the necessity of detect a node fail over, and the only way I can do it ...
    Gaetano MendolaGaetano Mendola
    Aug 19, 2004 at 11:43 pm
    Aug 21, 2004 at 9:46 am
  • I was looking through the code of psql and had a few questions: 1. Do we want to use quote_ident on object names? Ideally, column names with a space in them, for example, should be surrounded by ...
    Greg Sabino MullaneGreg Sabino Mullane
    Aug 27, 2004 at 11:17 pm
    Sep 10, 2004 at 12:09 pm
  • In 8.0 beta 1 I just tried: psql template1 ERROR: current transaction is aborted.... Should psql run every statement in a nested transaction and only rollback that TX? Or is that not ...
    Philip WarnerPhilip Warner
    Aug 11, 2004 at 2:20 pm
    Aug 19, 2004 at 4:39 pm
  • I never got any feedback on v7.3.7's packaging, so I'm guessing that it looked okay to everyone, even though it was substantially smaller? The only two things that I can think of that might have ...
    Marc G. FournierMarc G. Fournier
    Aug 19, 2004 at 2:38 pm
    Aug 20, 2004 at 3:35 pm
  • Just random speculation, but could we use a pg_subtrans-like setup to do row share locks? ie. Store them in a sort of table to avoid the problems with limited shared memory size? Chris Tom Lane wrote:
    Christopher Kings-LynneChristopher Kings-Lynne
    Aug 24, 2004 at 1:17 am
    Aug 25, 2004 at 10:43 pm
  • If I were loony enough to want to make an attempt at a version updater (i.e. migrate a 7.4 database to 8.0 without an initdb), any suggestions on where to poke first? Does a catalog/list of system ...
    Andrew RawnsleyAndrew Rawnsley
    Aug 31, 2004 at 1:59 am
    Sep 4, 2004 at 4:06 am
  • P O S T G R E S Q L 8 . 0 O P E N I T E M S Current version at ftp://momjian.postgresql.org/pub/postgresql/open_items. Changes ------- * Win32 o add binary version stamps? o fix signal-safe socket ...
    Bruce MomjianBruce Momjian
    Aug 20, 2004 at 8:28 pm
    Aug 24, 2004 at 2:59 pm
  • Hi! I'm currently working on the psql tab-complete code, fixing quite a lot of bugs/annoyances in the process. One of the things I'm trying to do is syncing the available commands in psql with the ...
    Stefan KaltenbrunnerStefan Kaltenbrunner
    Aug 9, 2004 at 5:23 pm
    Aug 16, 2004 at 9:55 pm
  • Is anyone working on this patch? --------------------------------------------------------------------------- Tom Lane wrote: -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) ...
    Bruce MomjianBruce Momjian
    Aug 2, 2004 at 7:16 pm
    Aug 18, 2004 at 3:19 am
  • This is a first pass on a simple shared memory variable system for PostgreSQL. I would appriciate anyone interested in this functionality to rip it apart. It basically adds this functionality: ...
    Mark L. WoodwardMark L. Woodward
    Aug 25, 2004 at 8:54 pm
    Aug 31, 2004 at 1:59 am
  • This patch is wrong. Something involving "!seen_dot || dec < fpoint" would probably be better. On the other hand, I can see half a dozen other brokennesses in that routine on idly glancing over it ...
    Tom LaneTom Lane
    Aug 22, 2004 at 5:29 pm
    Aug 23, 2004 at 2:19 pm
  • In CVS tip, try running the regression tests against an installed postmaster (ie, make installcheck); then as soon as the tests are done, kill -9 the bgwriter process to force a database restart. ...
    Tom LaneTom Lane
    Aug 4, 2004 at 6:40 pm
    Oct 6, 2004 at 7:16 pm
  • 8.0.0beta1 tarball built with gcc 3.2.3 under Solaris 9 on a E250 (ultrasparc). I see the same bug as described in http://archives.postgresql.org/pgsql-admin/2004-05/msg00248.php: a mask of ...
    Oliver JowettOliver Jowett
    Aug 18, 2004 at 5:37 am
    Aug 20, 2004 at 8:23 pm
  • Hi, I've compiled 8.0 beta 1 on a R5900 V3.1 (a playstation 2) running Linux (PS2 Linux 1) for portability testing. Here is what make check gave: Without --disable-spinlocks compilation *appears* to ...
    ChrisChris
    Aug 24, 2004 at 12:21 am
    Aug 30, 2004 at 7:39 pm
  • (moved to HACKERS) I just created and posted a source RPM for 8.0.0beta1. As I'm not the usual packager, and a pure hack when it comes to building my own RPMs, it would be a Good Thing(tm) if someone ...
    Joe ConwayJoe Conway
    Aug 15, 2004 at 5:58 am
    Aug 19, 2004 at 5:10 pm
  • Just found this: createdb zzz createlang plpgsql zzz psql zzz create function xxx() returns integer as $$ begin return 1; end; $$ language plpgsql; \q pg_dump -Fc zzz zzz.bck dropdb zzz createdb zzz ...
    Philip WarnerPhilip Warner
    Aug 11, 2004 at 3:47 pm
    Aug 17, 2004 at 5:11 pm
  • will PITR in 8.0 be usable for "hot spare"/"log shipping" type of replication or is it just for Point In Time RECOVERY ? ----------- Hannu
    Hannu KrosingHannu Krosing
    Aug 11, 2004 at 7:56 am
    Aug 15, 2004 at 11:12 pm
  • [redirecting] I have abstracted this problem, and we definitely have a newline bug that has to be fixed, IMNSHO. Attached are 2 scripts that are identical except that one has DOS-style line endings ...
    Andrew DunstanAndrew Dunstan
    Aug 13, 2004 at 12:22 pm
    Aug 15, 2004 at 5:07 pm
  • I don't think it was a problem of committers. To me it was a problem of reviewers. Those are very scarce (for the bigger items it's mostly only Tom). Maybe a better SCM could help with this, but I ...
    Alvaro HerreraAlvaro Herrera
    Aug 7, 2004 at 9:44 pm
    Aug 14, 2004 at 5:11 am
  • I did a little test on the various options of fsync. I'm not sure my tests are scientific enough for general publication or evaluation, all I am doing is performaing a loop that inserts a value into ...
    Mark L. WoodwardMark L. Woodward
    Aug 9, 2004 at 6:02 pm
    Aug 10, 2004 at 6:46 pm
  • Someone just asked about a COPY capability to supply the column headings as the first line of the copy statement. Do we want to support something like that? Does anyone else want such functionality? ...
    Bruce MomjianBruce Momjian
    Aug 16, 2004 at 2:53 pm
    Aug 19, 2004 at 2:36 am
  • AFAIK there are no major patches still outstanding, with the exception of the Windows-symlinks patch that arrived today from Andreas. Bruce and I both think that's worth getting in, if no one has any ...
    Tom LaneTom Lane
    Aug 5, 2004 at 11:58 pm
    Aug 15, 2004 at 1:48 pm
  • I have two things left before beta. I want to make sure the release notes are current against CVS and I want to make sure the win32 tablespace symlink changes I just made work. -- Bruce Momjian | ...
    Bruce MomjianBruce Momjian
    Aug 8, 2004 at 2:08 am
    Aug 8, 2004 at 7:09 am
  • While fixing the gui for pg_dump and pg_restore, I painfully noticed there's no option for the password. After some tests, I found that using the PGPASSWORD environment variable will do the job. I'm ...
    Andreas PflugAndreas Pflug
    Aug 18, 2004 at 8:43 pm
    Dec 3, 2004 at 4:47 am
  • The default setting of 'false' is a pain. And the fact it can't be changed by an option is even more of a pain. Any objections to adding an option to pg_restore to allow 'die_on_errors' to be set to ...
    Philip WarnerPhilip Warner
    Aug 11, 2004 at 4:03 pm
    Aug 20, 2004 at 8:00 pm
  • Will do a short announce tomorrow, but if anyone wants to look it over, make sure that I didn't miss anything? the files are available at ftp://ftp.postgresql.org/pub/source/v8.0.0beta1 ... both gz ...
    Marc G. FournierMarc G. Fournier
    Aug 8, 2004 at 11:50 pm
    Aug 9, 2004 at 9:13 pm
  • I've tested pgxs with PL/R and it allows me to build successfully without using a Postgres source tree. Many thanks to both Fabien and Peter for this! One question did arise, however. In order to use ...
    Joe ConwayJoe Conway
    Aug 3, 2004 at 6:27 pm
    Aug 6, 2004 at 3:38 pm
  • Just so you know --- core has agreed that it's about time for beta2. If you've got any "must fix" issues, please get 'em in over the weekend. regards, tom lane
    Tom LaneTom Lane
    Aug 27, 2004 at 5:25 pm
    Aug 29, 2004 at 11:34 pm
  • Short bug report: When installing PgSQL into a non-standard location (like /opt/foo) the configure script decides to install all the contrib libraries and plpglsq into /opt/foo/lib/postgresql. This ...
    Paul RamseyPaul Ramsey
    Aug 19, 2004 at 4:00 am
    Aug 19, 2004 at 5:29 am
  • Hi all, I'm having some spare time and I'm testing what Tom Lane was suggesting: =========================================================================== Tom Lane wrote: 1. You set up WAL ...
    Gaetano MendolaGaetano Mendola
    Aug 13, 2004 at 2:54 pm
    Aug 14, 2004 at 3:09 pm
  • The PITR docs that have just been put up say: But if you want to recover to some previous point in time (say, right before the junior DBA dropped your main transaction table), just specify the ...
    Oliver ElphickOliver Elphick
    Aug 4, 2004 at 4:42 pm
    Aug 7, 2004 at 6:08 pm
  • If %t is used in log_line_prefix, win32's strftime will print a very long timezone information, e.g. "W. Europe Daylight Time" where Linux would write "UTC". This makes the timestamp consuming more ...
    Andreas PflugAndreas Pflug
    Aug 4, 2004 at 7:38 pm
    Aug 16, 2004 at 5:08 pm
  • Hello Peter, backend/po/fr.po had 99% translations done for 7.4, and nos it is totally missing for the current CVS tip (it is in the Attic)....mmmm... why? Most of those messasge are still applicable ...
    Serguei A. MokhovSerguei A. Mokhov
    Aug 9, 2004 at 11:41 pm
    Aug 11, 2004 at 12:06 pm
  • Hi all, I have seen the big debat about to have the delay off or on by default. Why not enable it by default and introduce a new parameter to vacuum command itself ? Something like: VACUUM .... WITH ...
    Gaetano MendolaGaetano Mendola
    Aug 9, 2004 at 11:21 am
    Aug 10, 2004 at 5:11 pm
  • Tom, you didn't like Andreas' idea of allowing the user to rotate the log files on demand. Isn't that standard functionality for any logging program in case you want to manually start a new log file? ...
    Bruce MomjianBruce Momjian
    Aug 8, 2004 at 2:27 am
    Aug 9, 2004 at 7:11 pm
  • Hello, Is there ANY chance to recover data from a database system that suffered disk crash, and is not missing the data/global directory? Version is 7.2.4. Database files seem to be intact as well as ...
    Daniel KalchevDaniel Kalchev
    Aug 23, 2004 at 1:01 pm
    Aug 25, 2004 at 4:35 pm
  • I see stats collector processes die in current when I suspend postmaster then put it in background from a terminal: $ ps x : : 21638 pts/1 S 0:00 /bin/bash -i 30525 pts/1 S 0:00 postmaster 30527 ...
    Tatsuo IshiiTatsuo Ishii
    Aug 15, 2004 at 3:03 am
    Aug 15, 2004 at 6:15 am
  • trying to test beta 1 on Debian linux mipsel (sarge). I am getting the following error "PANIC: stuck spinlock (0x2b052030) detected at lwlock.c:246" during initdb. here is the complete initdb run. ...
    Jim ButtafuocoJim Buttafuoco
    Aug 29, 2004 at 6:23 pm
    Aug 31, 2004 at 11:36 am
  • While trying to understand dollar-quoting, I found the following in psql: select $a$ hello $a$; behaves as expected, but psql does not like select $a$ \ $a$; or select $a$ \\ $a$; Should it? How ...
    Philip WarnerPhilip Warner
    Aug 12, 2004 at 1:29 am
    Aug 12, 2004 at 3:53 am
  • I've continued to hack on array literal parsing today, and in doing so came up with a question regarding behavior. Currently the following works: regression=# select '{0 second,0 ...
    Joe ConwayJoe Conway
    Aug 5, 2004 at 11:54 pm
    Aug 11, 2004 at 9:05 am
  • With the new timezone stuff, is there any reason this shouldn't be made to work now in CVS: test=# select current_timestamp at time zone 'Australia/Perth'; ERROR: time zone "australia/perth" not ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Aug 24, 2004 at 5:13 am
    Aug 26, 2004 at 3:09 am
  • My discovery last night of a WAL synchronization error in pg_clog led me to take a look at pg_subtrans too. I soon realized that in fact we are not WAL-logging pg_subtrans updates at all: ...
    Tom LaneTom Lane
    Aug 10, 2004 at 4:24 pm
    Aug 20, 2004 at 8:19 pm
Aug 2004
12345
Group Navigation
period‹ prev | Aug 2004 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions234
posts1,601
users152
websitepostgresql.org...
irc#postgresql

152 users for August 2004

Tom Lane: 342 posts Bruce Momjian: 201 posts Christopher Kings-Lynne: 108 posts Gaetano Mendola: 69 posts Marc G. Fournier: 68 posts Andrew Dunstan: 48 posts Philip Warner: 47 posts Josh Berkus: 36 posts Joe Conway: 34 posts Peter Eisentraut: 33 posts Alvaro Herrera Munoz: 29 posts Andreas Pflug: 25 posts Gavin Sherry: 24 posts Robert Treat: 24 posts Fabien COELHO: 21 posts Oliver Jowett: 20 posts Mark L. Woodward: 19 posts Greg Stark: 17 posts John Hansen: 15 posts Devrim Gündüz: 14 posts
show more
Archives