Search Discussions

187 discussions - 1,681 posts

  • Some more comments: #: utils/misc/guc.c:647 msgid "collect statistics about executing commands" Is this really "statistics" about the executing commands? #: utils/misc/guc.c:892 msgid "" "The number ...
    Alvaro HerreraAlvaro Herrera
    Sep 28, 2003 at 7:37 pm
    Oct 17, 2003 at 12:06 am
  • Wow, that sounds big. The ERROR will only happen once, while the WARNING could happen a lot --- we could add code to throw the WARNING only once per COPY command --- that would probably make sense. I ...
    Bruce MomjianBruce Momjian
    Sep 26, 2003 at 6:30 pm
    Sep 29, 2003 at 3:33 pm
  • Hi, I tried 7.4 beta2 and had difficulties setting up TCP/IP with it. It complains about mising pg_hba.conf-entry. After installing and initdb I edited my postgres.conf to enable tcpip (tcpip_socket ...
    Tommi MäkitaloTommi Mäkitalo
    Sep 1, 2003 at 8:00 pm
    Sep 10, 2003 at 4:26 pm
  • I was going to have an alpha guy test it --- that was the one change I wasn't sure about. We did test for __alpha__ all over the port/*.h files, so it wasn't clear which alpha's were being hit. I can ...
    Bruce MomjianBruce Momjian
    Sep 12, 2003 at 2:28 am
    Sep 13, 2003 at 4:08 am
  • I was attempting to get pg_autovacuum to work on my database and after much hammering at it I discovered that the stats system was not working. I tried it with both 7.4beta1 and 7.4beta2 in both ...
    Adam KavanAdam Kavan
    Sep 4, 2003 at 2:51 am
    Sep 10, 2003 at 6:36 pm
  • Hi! After holding my breath for quite a while, it bursts out... I'd really like to get a status update on said port. The reason is, it's seemingly put on hold for me. After this port was talked over ...
    Joerg HessdoerferJoerg Hessdoerfer
    Sep 2, 2003 at 10:31 am
    Sep 12, 2003 at 2:43 pm
  • Hello, I just read a rather disturbing post.... PostgreSQL does not support read uncommited and repeatable read isolation levels? If that is so... then PostgreSQL is NOT ACID compliant? What is the ...
    Joshua D. DrakeJoshua D. Drake
    Sep 19, 2003 at 10:57 pm
    Oct 4, 2003 at 3:46 pm
  • Now that I have pg_autovacuum working I've bumped into another small bug. When pg_autovacuum goes to vacuum or analyze one of my tables it runs... analyze public.ConfigBackup Because ConfigBackup is ...
    Adam KavanAdam Kavan
    Sep 4, 2003 at 10:40 pm
    Sep 13, 2003 at 4:27 pm
  • Hello folks, Stumbled across an odd problem while cleaning data out of a database. I am getting these "invalid tid" errors. I tried the upgrade from 7.3.2 to 7.3.4. I tried a ...
    Wade KlaverWade Klaver
    Sep 24, 2003 at 12:13 am
    Oct 1, 2003 at 11:12 pm
  • Following up this gripe http://archives.postgresql.org/pgsql-sql/2003-09/msg00044.php I've realized that plpgsql just assumes that the test expression of an IF, WHILE, or EXIT statement is a boolean ...
    Tom LaneTom Lane
    Sep 8, 2003 at 3:40 pm
    Oct 1, 2003 at 3:27 am
  • enough), way to To be perfectly honest, I'm still trying to familiarize myself with the code sufficiently well so that I can tell which variables need to be per-thread and which are shared (and, in ...
    Claudio NatoliClaudio Natoli
    Sep 25, 2003 at 2:48 pm
    Sep 27, 2003 at 5:20 am
  • Following tests were made in linux server running pg 7.4 beta 2. I have been playing with temporary tables a little bit and noticed some interesting things. I'm not sure if this is a part of the ...
    Merlin MoncureMerlin Moncure
    Sep 16, 2003 at 6:38 pm
    Sep 22, 2003 at 7:05 pm
  • It seems "-traditional-cpp" has become nontraditional in 3.3. Or possibly Apple changed their system header files in a way that broke that preprocessor. What's certain is that gcc 3.3 rejects some of ...
    Tom LaneTom Lane
    Sep 20, 2003 at 8:37 pm
    Sep 27, 2003 at 11:32 pm
  • I've been looking at the issues involved in reindexing system tables, and I now have what I think is a fairly defensible set of proposals. We should whenever possible use the same reindexing ...
    Tom LaneTom Lane
    Sep 21, 2003 at 6:55 pm
    Sep 28, 2003 at 6:16 pm
  • Hi people, can someone add: Add an ALTER TABLE MODIFY CONSTRAINT item to the todo list? I am even willing to pick this one up in a while, after I finish some other outstanding tasks. -- Jeroen ...
    Jeroen Ruigrok/asmodaiJeroen Ruigrok/asmodai
    Sep 8, 2003 at 6:36 pm
    Sep 15, 2003 at 9:34 pm
  • Hello, I'm a beginner here at the list, my name is Daniel Pellegrini, graduation student from Brazil with no experience about pgsql. First of all I'd like to say that I have tried other lists before, ...
    Sep 5, 2003 at 2:24 pm
    Sep 12, 2003 at 4:14 pm
  • Why not list out the languages we *do* know about, and tell them it's not in the list? Or is that too much work? andrew
    Andrew DunstanAndrew Dunstan
    Sep 5, 2003 at 7:25 am
    Sep 7, 2003 at 6:20 am
  • I have emptied the patch queue, and have updated the HISTORY file for 7.4. I am looking for any improvements to that file. (I have to move it to SGML soon.) Perhaps it is time to start looking at a ...
    Bruce MomjianBruce Momjian
    Sep 29, 2003 at 6:58 pm
    Oct 3, 2003 at 11:32 pm
  • Is our maximum table size limited by the maximum block number? With our block number maximum of: #define MaxBlockNumber ((BlockNumber) 0xFFFFFFFE) 0xFFFFFFFE = 4294967294 would the max table size ...
    Bruce MomjianBruce Momjian
    Sep 9, 2003 at 4:45 am
    Sep 10, 2003 at 2:37 am
  • deleting the tuple. Is there a similar bit modified if the row in question is being waited upon by some transaction?
    Larry DouzieLarry Douzie
    Sep 8, 2003 at 2:46 am
    Sep 9, 2003 at 2:25 pm
  • If you have a check constraint that tests if a boolean column is not false by just using the column name, pg_dump doesn't include parens around the check constraint which causes a syntax error when ...
    Bruno Wolff IIIBruno Wolff III
    Sep 29, 2003 at 1:07 am
    Oct 5, 2003 at 8:11 am
  • We've spent much effort trying to solve the "int8col = 42 doesn't use an index" class of problems. AFAIR, all the recent tries have focused on trying to get the parser to choose an index-compatible ...
    Tom LaneTom Lane
    Sep 16, 2003 at 4:30 pm
    Sep 18, 2003 at 1:32 pm
  • Because MinGW/Msys doesn't come with flex/bison by default, I have added those derived files to the WIN32_DEV branch in CVS. It makes it easier for people to install _just_ MinGW and compile ...
    Bruce MomjianBruce Momjian
    Sep 10, 2003 at 4:03 pm
    Sep 15, 2003 at 7:03 am
  • Today's commits from Bruce don't seem to be there. I'm doing: cvs update -d -P (I sent another note to Marc as a safety). LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 ...
    Larry RosenmanLarry Rosenman
    Sep 4, 2003 at 3:35 am
    Sep 4, 2003 at 7:20 pm
  • Hello all, I have seen this presentation for new Novell Netware 6.5 version released about two weeks or so. http://www.novell.com/products/netware/netware65overview_popup.html If you check 'Open ...
    Terry YaptTerry Yapt
    Sep 12, 2003 at 3:38 pm
    Nov 27, 2003 at 5:52 am
  • Here is an email from the DBD:pg guys describing what _GNU_SOURCE does. --------------------------------------------------------------------------- Jeroen Ruigrok/asmodai wrote: -- Bruce Momjian | ...
    Bruce MomjianBruce Momjian
    Sep 28, 2003 at 3:08 pm
    Oct 14, 2003 at 1:02 am
  • I want to make a contribution. It is a new (to pgsql) procedural language. Currently it already works (but debugging output is not disabled yet). I've got some questions and considerations, please, ...
    Sep 25, 2003 at 7:37 am
    Sep 28, 2003 at 10:02 am
  • BTW, I've been wondering lately if we'd not be better off to look at using threading in the Windows port, if it'd help us get around the fork/exec data transfer problem. I'm not sure that it would, ...
    Tom LaneTom Lane
    Sep 25, 2003 at 12:59 pm
    Sep 26, 2003 at 6:35 am
  • FreeBSD 4.8/i386: Your gethostbyname() is _not_ thread-safe Your getpwuid() is _not_ thread-safe Your functions are _not_ all thread-safe Chris ----- Original Message ----- From: "Bruce Momjian" ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Sep 8, 2003 at 4:23 am
    Sep 12, 2003 at 4:19 pm
  • The offending source code is in pg_dump.c line 3953, where at the lack of an underlying conversion function and thus no clear namespace relationship pg_dump simply ignores the cast. IMHO a binary ...
    Jan WieckJan Wieck
    Sep 23, 2003 at 3:35 pm
    Sep 28, 2003 at 5:49 pm
  • Hi all, my impression on 7.4 performances: ===== Good news ===== How expected the use of clausole 'IN' with Postgres 7.4beta2 now is really fast ( see the result below ) ===== Bad news ===== I posted ...
    Gaetano MendolaGaetano Mendola
    Sep 18, 2003 at 7:29 pm
    Sep 20, 2003 at 9:49 pm
  • Should this produce a warning? nconway=# create table a (b int4 unique); NOTICE: CREATE TABLE / UNIQUE will create implicit index "a_b_key" for table "a" CREATE TABLE nconway=# create table c (d int8 ...
    Neil ConwayNeil Conway
    Sep 4, 2003 at 3:57 pm
    Sep 10, 2003 at 8:17 pm
  • Of course I'm not suggesting this, what I'm suggesting is put an assert( ) if the test can slow down the performances and an "if ( ) " in places that are not going to touch the performances. I think ...
    Gaetano MendolaGaetano Mendola
    Sep 8, 2003 at 9:39 am
    Sep 9, 2003 at 3:33 pm
  • I wonder if we should have an auto-responder so when someone says they are running 6.5, we can reply --- Yikes, upgrade. In fact, we could go with a little chart: 7.3.4 great 7.3.0-3 please upgrade, ...
    Bruce MomjianBruce Momjian
    Sep 24, 2003 at 10:09 pm
    Sep 29, 2003 at 6:00 pm
  • Someone asked me a question about view and function permissions. I assumed all object access done by a view would be based on the permissions on the view, and not the permissions of the objects. ...
    Bruce MomjianBruce Momjian
    Sep 11, 2003 at 3:50 pm
    Sep 29, 2003 at 12:19 am
  • I am writing a backend C function whose behavior should depend on the setting of a new runtime parameter that can be set with SET. I have several questions concerning how to implement this, as I can ...
    Sep 24, 2003 at 1:50 pm
    Sep 24, 2003 at 9:51 pm
  • Today's cvs doesn't compile. I think it is due to cvs diff -r1.7 -r1.8 src/interfaces/ecpg/include/datetime.h I have dtime_t defined in my sys/types.h. The old version of datetime.h used #define ...
    Patrick WelchePatrick Welche
    Sep 29, 2003 at 5:42 pm
    Oct 7, 2003 at 7:48 pm
  • http://developer.osdl.org/markw/74/ I had a couple of hiccups doubling the database size, but I have results with proper linux kernel profile data now. The increase in database size has decreased the ...
    Sep 22, 2003 at 9:41 pm
    Oct 6, 2003 at 7:17 pm
  • I've been observing a interesting behavior with our DBT-2 workload. It appears that a commit to a transaction is taking some time to occur. I'll try to briefly describe what we're seeing. The ...
    Sep 24, 2003 at 9:24 pm
    Sep 25, 2003 at 6:44 pm
  • There was a thread on missing pg_clog files caused due to dodgy practices in glibc *last year*. I am seeing something similar *now* with a server PostgreSQL 7.4beta1 on i386-unknown-netbsdelf1.6X, ...
    Patrick WelchePatrick Welche
    Sep 22, 2003 at 1:02 pm
    Sep 24, 2003 at 9:58 pm
  • I'm seeing the following with the current CVS code on my Linux dev box: $ make maintainer-clean $ ./configure --enable-depend --enable-cassert --enable-debug --prefix=/pgsql --with-openssl [ ... ] $ ...
    Neil ConwayNeil Conway
    Sep 3, 2003 at 7:53 pm
    Sep 15, 2003 at 6:56 pm
  • I found a few notices and warnings that inform you that the command you are executing has no effect because the object is already in the state you want it. I think these are useless, and there is ...
    Peter EisentrautPeter Eisentraut
    Sep 5, 2003 at 10:47 pm
    Sep 10, 2003 at 6:20 pm
  • http://developer.osdl.org/markw/44/ I threw together (kind of sloppily) a web page of the data I was starting to collect for our DBT-2 workload (TPC-C derivative) on PostgreSQL 7.3.4. Keep in mind ...
    Sep 4, 2003 at 5:54 pm
    Sep 8, 2003 at 6:02 pm
  • What do people think about adding the transaction status indicator to the default psql prompt, so it'd look something like this: peter=# begin; BEGIN peter*=# foo; ERROR: syntax error at or near ...
    Peter EisentrautPeter Eisentraut
    Sep 3, 2003 at 7:53 pm
    Sep 4, 2003 at 9:00 am
  • % ldd `which postgres` /usr/local/bin/postgres: libintl.so.5 = /usr/local/lib/libintl.so.5 (0x282e6000) libz.so.2 = /lib/libz.so.2 (0x282ef000) libreadline.so.4 = /lib/libreadline.so.4 (0x282fd000) ...
    Sean ChittendenSean Chittenden
    Sep 5, 2003 at 9:54 pm
    Dec 1, 2003 at 11:58 pm
  • Hi, I have been studying the basic limitation that the number of committed transactions per second possible in a relational databases. Since each transaction requires at least write-ahead log data to ...
    Seun OsewaSeun Osewa
    Sep 30, 2003 at 11:03 am
    Oct 8, 2003 at 2:19 pm
  • I think most people on this list will agree that having OIDs on user tables is a Bad Thing. For some previous discussion of why, see: ...
    Neil ConwayNeil Conway
    Sep 29, 2003 at 9:34 pm
    Sep 29, 2003 at 11:51 pm
  • From CVS logs I see: pg_dump/pg_restore now always use SET SESSION AUTHORIZATION, not \connect, to control object ownership. The use-set-session-authorization and no-reconnect switches are obsolete ...
    Bruce MomjianBruce Momjian
    Sep 29, 2003 at 4:43 am
    Sep 29, 2003 at 7:23 pm
  • I've looked through the messages in the backend and identified some areas that still deserve some cleanup. Below I list some issues that deserve some discussion or that deserve being remembered by ...
    Peter EisentrautPeter Eisentraut
    Sep 21, 2003 at 3:38 pm
    Sep 26, 2003 at 5:44 pm
  • Hey guys, Is there any chance we could have initdb show the version of postgresql it is running as when initdb is run? On my dev machine, i have all sorts of different versions in different paths and ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Sep 26, 2003 at 3:21 am
    Sep 26, 2003 at 3:23 pm
Group Navigation
period‹ prev | Sep 2003 | next ›
Group Overview
grouppgsql-hackers @

159 users for September 2003

Tom Lane: 337 posts Bruce Momjian: 291 posts Peter Eisentraut: 66 posts Andrew Dunstan: 63 posts Andreas Pflug: 46 posts Larry Rosenman: 44 posts Mendola Gaetano: 39 posts Christopher Kings-Lynne: 34 posts Alvaro Herrera Munoz: 32 posts Jan Wieck: 26 posts Greg Stark: 25 posts Marc G. Fournier: 24 posts Stephan Szabo: 20 posts Jeroen Ruigrok/asmodai: 19 posts Rod Taylor: 18 posts Shridhar Daithankar: 17 posts Matthew T. O'Connor: 16 posts Neil Conway: 16 posts Hiroshi Inoue: 15 posts Scott.marlowe: 15 posts
show more