FAQ

PostgreSQL > pgsql-hackers > October 2003

Search Discussions

208 discussions - 1,602 posts

  • It is time for people to report their port testing. Please test against current CVS or beta5 and report your 'uname -a'. The current list is at: ...
    Bruce MomjianBruce Momjian
    Oct 24, 2003 at 3:38 pm
    Nov 9, 2003 at 4:03 am
  • Attached is an extremely crude prototype patch for making VACUUM delay by a configurable amount between pages, in hopes of throttling its disk bandwidth consumption. By default, there is no delay (so ...
    Tom LaneTom Lane
    Oct 31, 2003 at 2:41 am
    Nov 12, 2003 at 5:18 am
  • Hi, This is for relational database theory experts on one hand and imlementers of real-world alications on the other hand. If there was a chance to start again and design SQL afresh, for best ...
    Seun OsewaSeun Osewa
    Oct 3, 2003 at 7:20 pm
    Nov 9, 2003 at 11:24 pm
  • Hello, With the recent stint of pg_upgrade statements and the impending release of 7.4 what do people think about having a dedicated maintenance team for 7.3? 7.3 is a pretty solid release and I ...
    Joshua D. DrakeJoshua D. Drake
    Oct 1, 2003 at 3:06 am
    Oct 9, 2003 at 7:39 pm
  • Hi, Now that DEFAULT 'now' will not work in PostgreSQL 7.4, will DEFAULT 'infinity' and DEFAULT '-infinity' and the like stop working as well? What is the workaround for those defaults? Chris
    Christopher Kings-LynneChristopher Kings-Lynne
    Oct 22, 2003 at 2:18 am
    Oct 31, 2003 at 8:59 pm
  • So when I suggested on linux-kernel that vacuumcould benefit from some way to prioritize i/o resourcse, someone suggested vacuum could just throttle its own disk accesses. While I think they their ...
    Greg StarkGreg Stark
    Oct 16, 2003 at 5:18 am
    Oct 17, 2003 at 9:13 pm
  • Barring the discovery of any major new bugs, the core committee has agreed to release 7.4RC1 on Monday. Time to get those last-minute fixes in place. I currently have the following issues on my radar ...
    Tom LaneTom Lane
    Oct 30, 2003 at 11:43 pm
    Nov 1, 2003 at 12:50 am
  • We only have a few open items left. Can we finish them so we can move toward final release? --------------------------------------------------------------------------- P O S T G R E S Q L 7 . 4 O P E ...
    Bruce MomjianBruce Momjian
    Oct 28, 2003 at 2:39 am
    Oct 30, 2003 at 11:16 pm
  • P O S T G R E S Q L 7 . 4 O P E N I T E M S Current at ftp://momjian.postgresql.org/pub/postgresql/open_items. Changes ------- Fix REVOKE ALL ON FUNCTION error when removing owner permissions Improve ...
    Bruce MomjianBruce Momjian
    Oct 5, 2003 at 4:42 am
    Oct 10, 2003 at 3:55 am
  • psql cannot \i a file which name contains a blank character. Why doesn't it take the rest of the command line as the name of the file?!? Why doesn't it use any of the standard command line parsing ...
    Thomas ZehetbauerThomas Zehetbauer
    Oct 18, 2003 at 1:15 am
    Jan 4, 2004 at 4:23 pm
  • While fooling with adding -fno-strict-aliasing to configure, I realized that there are still some oddities about its selection of CFLAGS. The problems stem from the fact that autoconf will always ...
    Tom LaneTom Lane
    Oct 15, 2003 at 10:50 pm
    Oct 28, 2003 at 1:45 am
  • There is a bug in Unicode upper() which has been present since 7.2: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=139389 I had thought I had reported it before, but I can't find a record of it. ...
    Oliver ElphickOliver Elphick
    Oct 19, 2003 at 11:56 pm
    Nov 19, 2003 at 7:20 pm
  • Hi, I installed 7.4beta5, created a data-dir and tried to start postgresql with pg_ctl without initdb. As expected, this will fail. But pg_ctl tells me "postmaster successfully started", after a ...
    Tommi MaekitaloTommi Maekitalo
    Oct 23, 2003 at 8:29 am
    Oct 29, 2003 at 4:17 am
  • This appears to have been a deliberate change: 2003-03-27 11:45 momjian * src/bin/psql/tab-complete.c: Attached are two patches for psql's tab-completion.c. [snip] Note that tables, indexes, views ...
    Tom LaneTom Lane
    Oct 28, 2003 at 9:49 pm
    Oct 30, 2003 at 9:39 pm
  • [ CC added for hackers.] Well, this is really embarassing. I can't imagine why we would not set at least -O on all platforms. Looking at the template files, I see these have no optimization set: ...
    Bruce MomjianBruce Momjian
    Oct 8, 2003 at 6:32 pm
    Oct 14, 2003 at 8:42 pm
  • Hi, Is there demand for modifying psql to work against previous backends, pg_dump-style? I feel like looking into it, but tell me if I'm wasting my time... Chris
    Christopher Kings-LynneChristopher Kings-Lynne
    Oct 21, 2003 at 1:24 am
    Oct 23, 2003 at 1:09 pm
  • Hi, I am running a large and mature mission-critical PostgreSQL implementation with multiple tables that are growing at a rate of several million rows per month (the rate of addition is growing as ...
    James RogersJames Rogers
    Oct 1, 2003 at 6:34 am
    Oct 7, 2003 at 7:34 am
  • The more I think about this vacuum i/o problem, the more I think we have it wrong. The added i/o from vacuum really ought not be any worse than a single full table scan. And there are probably the ...
    Greg StarkGreg Stark
    Oct 17, 2003 at 8:23 pm
    Nov 1, 2003 at 5:17 am
  • See subject. If we want to force an initdb to ensure the recent information_schema updates take effect, we have to do it before beta5 release, I think. I'm inclined to do it --- I don't get the sense ...
    Tom LaneTom Lane
    Oct 20, 2003 at 9:35 pm
    Oct 23, 2003 at 8:57 am
  • There was a discussion on -interfaces that might need more consideration. http://archives.postgresql.org/pgsql-interfaces/2003-09/msg00026.php Apparently, it has so far been an undocumented feature ...
    Peter EisentrautPeter Eisentraut
    Oct 5, 2003 at 2:38 pm
    Oct 10, 2003 at 2:42 am
  • pg_encoding appears to have 2 personalities, (name= number and vice versa) depending on whther or not its parameter begins with a digit (which is in itself fragile - what if you gave it "3foo"?). ...
    Andrew DunstanAndrew Dunstan
    Oct 6, 2003 at 5:36 pm
    Oct 8, 2003 at 1:00 pm
  • I've always been uneasy about the notice at the end of the installation process that asks the user to register at http://www.pgsql.com/register/submit.php Now some users have also complained to me ...
    Peter EisentrautPeter Eisentraut
    Oct 12, 2003 at 1:02 pm
    Oct 13, 2003 at 9:40 pm
  • Greg StarkGreg Stark
    Oct 12, 2003 at 10:13 pm
    Oct 26, 2003 at 4:13 am
  • I'm seeing this compile warning on today's CVS tip: $ make src/backend/commands/tablecmds.o gcc -O2 -g -Wall -Wmissing-prototypes -Wmissing-declarations -I./src/include -D_GNU_SOURCE -c -o ...
    Alvaro HerreraAlvaro Herrera
    Oct 8, 2003 at 4:14 pm
    Oct 11, 2003 at 4:44 pm
  • FreeBSD 4.9 was released today. In the release notes was: 2.2.6 File Systems A new DIRECTIO kernel option enables support for read operations that bypass the buffer cache and put data directly into a ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Oct 29, 2003 at 2:06 pm
    Oct 31, 2003 at 5:05 am
  • Folks, I can't seem to find a Bison 1.875 RPM for a SuSE 8.1 machine I can't afford to upgrade right now. Does such an animal exist? Help! -- -Josh Berkus Aglio Database Solutions San Francisco
    Josh BerkusJosh Berkus
    Oct 16, 2003 at 8:40 pm
    Oct 17, 2003 at 5:55 pm
  • We only have a few open items left. Let's make final decisions on these and schedule RC1. --------------------------------------------------------------------------- P O S T G R E S Q L 7 . 4 O P E N ...
    Bruce MomjianBruce Momjian
    Oct 12, 2003 at 11:07 pm
    Oct 14, 2003 at 3:18 pm
  • The following code is in initdb.sh: exit_nicely(){ stty echo /dev/null 2 &1 echo 1 &2 echo "$CMDNAME: failed" 1 &2 if [ "$noclean" != yes ]; then if [ "$made_new_pgdata" = yes ]; then echo "$CMDNAME: ...
    Andrew DunstanAndrew Dunstan
    Oct 1, 2003 at 8:04 pm
    Oct 12, 2003 at 5:14 pm
  • Check her over and let me know if there are any problems ... will do a full general announce tomorrow for it ...
    Marc G. FournierMarc G. Fournier
    Oct 3, 2003 at 3:40 am
    Oct 4, 2003 at 10:08 pm
  • All, After toying with a few builds of the up coming OS X 10.3 (Panther) release, I've written a doc on how to get postgresql to build using Panther build 7B85 and Xcode build 7B85 (which are rumored ...
    James WilsonJames Wilson
    Oct 11, 2003 at 1:34 am
    Nov 5, 2003 at 4:09 pm
  • Hi guys, What is the limit on the number of rows in a PostgreSQL table? If it's more than MAXINT, we have a problem: phppgadmin# select * from test limit 2147483648; ERROR: integer out of range Same ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Oct 22, 2003 at 7:58 am
    Oct 26, 2003 at 4:44 am
  • Env: Postgres 7.3.4 on Unix I have a script to create a new database user and update pg_hba.conf. I was wondering whether I need to restart server, or simply run pg_ctl reload. The question is what ...
    Michael BrusserMichael Brusser
    Oct 11, 2003 at 3:09 am
    Oct 14, 2003 at 8:03 pm
  • My gcc 2.95.3 manual says: -pipe Use pipes rather than temporary files for communi- cation between the various stages of compilation. This fails to work on some systems where the assem- bler cannot ...
    Bruce MomjianBruce Momjian
    Oct 9, 2003 at 2:47 pm
    Oct 10, 2003 at 12:20 am
  • [ Moved to hackers.] I think we should change the "check_function_bodies" to something more general. I like "restore_validation_mode" because it could also be used to disable foreign key checks which ...
    Bruce MomjianBruce Momjian
    Oct 6, 2003 at 10:53 pm
    Oct 8, 2003 at 2:58 pm
  • Is this a bug? (using CVS code from yesterday) nconway=# create view baz (a,b) as select 'hello', 'world'; WARNING: column "a" has type "unknown" DETAIL: Proceeding with relation creation anyway. ...
    Neil ConwayNeil Conway
    Oct 2, 2003 at 6:59 am
    Oct 3, 2003 at 5:26 pm
  • What does this in the date/time type docs mean? zulu, allballs, z time 00:00:00.00 UTC Cos it has bizarro behaviour: In 7.3.4: australia=# select 'zulu'::time; ERROR: Bad time external representation ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Oct 22, 2003 at 7:17 am
    Oct 27, 2003 at 6:11 pm
  • Dear friends, I would like to port Compiere CRM from Oracle to PostgreSQL (and release it for free). At first I would like to convert the data schema. This is not difficult as Compiere is written ...
    Jean-Michel POUREJean-Michel POURE
    Oct 17, 2003 at 8:11 am
    Oct 18, 2003 at 1:12 pm
  • Dear PostgreSQL masters, I know this might like a childish question and you probably might have a good laugh over this but I would like to learn how PostgreSQL works inside-out. Could anyone please ...
    Gevik BabakhaniGevik Babakhani
    Oct 5, 2003 at 9:04 pm
    Oct 7, 2003 at 9:23 pm
  • Hi guys, I've asked this of a few people now, but I haven't managed to get a straightforward solution. I'm working on COMMENT ON LARGE OBJECT. If you could help me with this one, it would be really ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Oct 26, 2003 at 8:38 am
    Nov 10, 2003 at 1:47 am
  • Hi All, i'm running Postgresql 2.2x, so i am not quitse sure wether the bug i am reporting is already fixed in newer versions or not. In my version select round(2.5); returns 2; select ...
    Jochen Westland [invigo]Jochen Westland [invigo]
    Oct 22, 2003 at 9:46 am
    Oct 27, 2003 at 10:53 pm
  • Some comments on random TODO entries: * Allow INET subnet tests using non-constants This should say "Allow ... to be indexed" as it's otherwise a nonissue. * ARRAYS o -Allow arrays to be ORDER'ed ...
    Tom LaneTom Lane
    Oct 20, 2003 at 1:13 am
    Oct 21, 2003 at 3:52 pm
  • Is there any reason other than historical that the System Views setup isn't a separate script fed to postgres by initdb, like, say, the information schema file? If there isn't a good reason should we ...
    Andrew DunstanAndrew Dunstan
    Oct 5, 2003 at 9:25 pm
    Oct 6, 2003 at 4:28 pm
  • Do to a bug in pgtypeslin I've been experimenting with the day of week stuff a little bit and I found that we do not agree with the output of the cal command on older dates. I have no idea which one ...
    Michael MeskesMichael Meskes
    Oct 5, 2003 at 11:07 am
    Nov 29, 2003 at 5:57 am
  • Hi, Was just wondering if pg_autovacuum watches transaction ids and issues a vacuum freeze before they roll over? If not, is it hard to do? Chris
    Christopher Kings-LynneChristopher Kings-Lynne
    Oct 16, 2003 at 5:28 am
    Oct 21, 2003 at 3:44 am
  • Some of you may remember that we discussed libpqxx's higher-level support for transactionality. It was pointed out (by Tom, IIRC) that the connection to the backend may be lost just after you've sent ...
    Jeroen T. VermeulenJeroen T. Vermeulen
    Oct 20, 2003 at 1:36 pm
    Oct 20, 2003 at 7:57 pm
  • I looked through all the information_schema stuff, and found a few more nits. The CHECK_CONSTRAINTS view should use pg_get_constraintdef() function rather than consrc, for the same reasons as psql ...
    Tom LaneTom Lane
    Oct 16, 2003 at 11:48 pm
    Oct 17, 2003 at 3:45 pm
  • Ladies and Gentemen, in a database project I ported an Oracle database definition to PostgreSQL 7.3.2 as an aside. During this process I found a couple of incompatibilities in the SQL dialects of ...
    Rainer KluteRainer Klute
    Oct 2, 2003 at 5:38 pm
    Oct 6, 2003 at 6:35 pm
  • Could this be made a TODO item, perhaps with your attack plan. Of course as strictly optional feature useful only for special situations (see below) I cross-post this to [HACKERS] as it seem relevant ...
    Hannu KrosingHannu Krosing
    Oct 4, 2003 at 9:01 am
    Oct 5, 2003 at 1:37 pm
  • Hi guys, I'm just trying to understand this situation: Session 1 --------- BEGIN; SELECT * FROM tab WHERE id=1 FOR UPDATE; Session 2 --------- UPDATE tab SET blah=1 WHERE id=1; <waits Session 1 ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Oct 2, 2003 at 8:25 am
    Oct 4, 2003 at 9:39 am
  • In addition to the -g issue, I get the following failure: *** ./expected/privileges.out Thu Oct 9 20:49:31 2003 --- ./results/privileges.out Fri Oct 24 14:07:18 2003 *************** *** 247,253 **** ...
    Larry RosenmanLarry Rosenman
    Oct 25, 2003 at 6:18 am
    Oct 31, 2003 at 11:17 pm
Oct 2003
12345
Group Navigation
period‹ prev | Oct 2003 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions208
posts1,602
users178
websitepostgresql.org...
irc#postgresql

178 users for October 2003

Tom Lane: 272 posts Bruce Momjian: 259 posts Peter Eisentraut: 97 posts Christopher Kings-Lynne: 80 posts Andrew Dunstan: 64 posts Rod Taylor: 34 posts Jan Wieck: 33 posts Alvaro Herrera Munoz: 30 posts Neil Conway: 30 posts Joshua D. Drake: 27 posts Marc G. Fournier: 27 posts Hannu Krosing: 23 posts Greg Stark: 22 posts Scott.marlowe: 19 posts Robert Treat: 17 posts Stephan Szabo: 17 posts Gaetano Mendola: 16 posts Larry Rosenman: 16 posts Andrew Sullivan: 15 posts Chris Browne: 15 posts
show more
Archives