FAQ

Search Discussions

260 discussions - 2,295 posts

  • I'm a little out of my league on this list, but I thought I might discuss a problem I'm having since it seems to have come up here recently. I have read the archives w/ respect to the inheritance ...
    Daniel LyonsDaniel Lyons
    Aug 9, 2002 at 10:57 am
    Sep 7, 2002 at 5:00 pm
  • Surprised it took this long. Vince. -- ========================================================================== Vince Vielhaber -- KA8CSH email: vev@michvhf.com http://www.pop4.net 56K Nationwide ...
    Vince VielhaberVince Vielhaber
    Aug 19, 2002 at 4:44 pm
    Aug 22, 2002 at 9:21 am
  • Ok, here are some crude benchmarks to attempt to measure the effect of changing FUNC_MAX_ARGS. The benchmark script executed: CREATE FUNCTION test_func(int, int, int, int, int, int, int, int) RETURNS ...
    Neil ConwayNeil Conway
    Aug 1, 2002 at 10:23 pm
    Aug 14, 2002 at 5:49 am
  • Woh, I didn't think we had agreement on this. This populates the 'X' all over the system (postgres, postmaster, initdb, pg_ctl), while the simple solution would be to add the flag only to initdb and ...
    Bruce MomjianBruce Momjian
    Aug 4, 2002 at 2:21 pm
    Aug 20, 2002 at 2:45 am
  • Removed, still on TODO. Removed. Added to TODO. We will see... Well, we don't really want porting fixes during beta unless we can help it. ;-) There is concern that using pg_resetxlog by accident ...
    Bruce MomjianBruce Momjian
    Aug 16, 2002 at 4:43 am
    Aug 20, 2002 at 3:16 am
  • Here's yet another. He claims malicious code can be run on the server with this one. Vince. -- ========================================================================== Vince Vielhaber -- KA8CSH ...
    Vince VielhaberVince Vielhaber
    Aug 20, 2002 at 7:53 pm
    Aug 22, 2002 at 11:30 am
  • Hi, My primary use of Postgres is as the backend database for a busy web site. We have a cron job that just emails us the tail of our database, php, apache logs every night. That way we can see some ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Aug 23, 2002 at 2:04 am
    Sep 2, 2002 at 5:42 am
  • Hi all, I just spent some of the morning helping a customer build Pg 7.2.1 from source in order to get Linux largefile support in pg_dump etc. They possibly would have kept using the binary RPMs if ...
    mark Kirkwoodmark Kirkwood
    Aug 8, 2002 at 8:34 am
    Aug 13, 2002 at 7:50 pm
  • Are these changes available for 7.2, too? There is at least a DoS potential lurking here. :-( -- Florian Weimer Weimer@CERT.Uni-Stuttgart.DE University of Stuttgart ...
    Florian WeimerFlorian Weimer
    Aug 4, 2002 at 5:53 pm
    Aug 21, 2002 at 9:28 pm
  • Hi all, I'm thinking that temporary views should be pretty trivial to implement. * Allow temporary views This should be as simple as modifying gram.y (to set ViewStmt- view- istemp) and some logic in ...
    Gavin SherryGavin Sherry
    Aug 13, 2002 at 11:35 am
    Aug 14, 2002 at 6:04 am
  • Hi all, It occured to me on the plane home that now that CLUSTER is fixed we may be able to put pg_index.indisclustered to use. If CLUSTER was to set indisclustered to true when it clusters a heap ...
    Gavin SherryGavin Sherry
    Aug 4, 2002 at 1:41 am
    Aug 13, 2002 at 6:25 am
  • OK, no one has commented on this, so I guess I am going to have to guess the group's preference. My guess, seeing as very few probably use LIMIT and FOR UPDATE together, is to swap them and document ...
    Bruce MomjianBruce Momjian
    Aug 27, 2002 at 9:02 pm
    Aug 30, 2002 at 3:19 am
  • Seems like this one was lost or was filtered out... //@(#)Mordred Labs advisory 0x0002 Release data: 19/08/02 Name: Buffer overflow in PostgreSQL Versions affected: all versions Risk: high --[ ...
    Sir Mordred The TraitorSir Mordred The Traitor
    Aug 21, 2002 at 2:45 pm
    Aug 22, 2002 at 11:27 pm
  • Okay ... since this is pretty much going to be 'one camp for, one camp against' without anything to really back up either camps perspectives / arguments, I did some research on CVS in order to find a ...
    Marc G. FournierMarc G. Fournier
    Aug 1, 2002 at 1:38 am
    Aug 2, 2002 at 12:50 pm
  • //@(#) Mordred Labs advisory 0x0007 Release data: 26/08/02 Name: Remote DoS condition in PostgreSQL Versions affected: all versions Conditions: entry in a pg_hba.conf file that matches attacker's ...
    Sir Mordred The TraitorSir Mordred The Traitor
    Aug 26, 2002 at 2:46 pm
    Aug 30, 2002 at 4:41 am
  • I have been getting the subject message ever since upgrading to 7.2.1. I tried 7.2.2 with the same thing. It seems to be related to my chkpass type (see contrib) as it only happens on tables with ...
    D'Arcy J.M. CainD'Arcy J.M. Cain
    Aug 26, 2002 at 10:03 pm
    Aug 30, 2002 at 1:27 am
  • Excellent idea you pointed this out. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. ...
    Bruce MomjianBruce Momjian
    Aug 24, 2002 at 3:36 am
    Aug 26, 2002 at 1:43 pm
  • Okay, I read http://archives.postgresql.org/pgsql-bugs/2002-06/msg00086.php and never saw a fix offered up. Since I'm gearing up to use Postgres and Python soon, I figured I'd have a hand at trying ...
    Greg CopelandGreg Copeland
    Aug 8, 2002 at 2:55 am
    Aug 15, 2002 at 3:39 am
  • In include/c.h, MemSet() is defined to be different than the stock function memset() only when copying less than or equal to MEMSET_LOOP_LIMIT bytes (currently 64). The comments above the macro ...
    Neil ConwayNeil Conway
    Aug 29, 2002 at 6:47 am
    Sep 1, 2002 at 11:41 pm
  • Large file support is now compiled by default if available. (Use --disable-largefile to turn it off. That's what Autoconf gives us.) But: The zlib library uses unsigned ints and unsigned longs for ...
    Peter EisentrautPeter Eisentraut
    Aug 20, 2002 at 5:59 pm
    Aug 27, 2002 at 6:32 pm
  • Gavin SherryGavin Sherry
    Aug 6, 2002 at 12:16 pm
    Aug 18, 2002 at 10:25 pm
  • I think this belongs on gborg. Would you create a project there? --------------------------------------------------------------------------- Hans-Jürgen Schönig wrote: [ application/x-gzip is not ...
    Bruce MomjianBruce Momjian
    Aug 14, 2002 at 5:15 am
    Aug 14, 2002 at 10:56 pm
  • We have a patch for pg_dump which adds a possibility to dump a part of table, for example: dump Top.Science.Astronomy heirarchy from dmoz catalog pg_dump -d -t dmoz -w "select * from dmoz where path ...
    Oleg BartunovOleg Bartunov
    Aug 13, 2002 at 10:50 am
    Aug 14, 2002 at 5:18 am
  • With the recent talk of RULE regression failures, I thought I'd bring back up that I _always_ have a rule failure on Freebsd/alpha. The files are attached... Chris
    Christopher Kings-LynneChristopher Kings-Lynne
    Aug 30, 2002 at 2:01 am
    Sep 2, 2002 at 6:21 am
  • Okay, I'm tired of hearing about this, and I've decided I can make the problem go away with a day or so's concentrated work. Here is the plan: Create several "pseudo types" (typtype 'p' in pg_type). ...
    Tom LaneTom Lane
    Aug 20, 2002 at 6:08 pm
    Aug 21, 2002 at 3:25 pm
  • I have added SQL99's CONVERT() function. docs and regression tests also updated. Our own convert() functions can also be used. Example usage of CONVERT(): convert('PostgreSQL' using ...
    Tatsuo IshiiTatsuo Ishii
    Aug 6, 2002 at 5:55 am
    Aug 20, 2002 at 9:19 pm
  • Reading about the pgmonitor thread and mention of gborg made me wonder about replication and ready ability to uniformly monitor it. Just as pg_stat* tables exist to allow for statistic gathering and ...
    Greg CopelandGreg Copeland
    Aug 15, 2002 at 3:15 am
    Aug 16, 2002 at 2:35 pm
  • I just tried CLUSTER command at fts.postgresql.org to cluster fts index and got very visual performance win. Unfortunately I had to restore permissions and recreate other indices by hand. So, I'm ...
    Oleg BartunovOleg Bartunov
    Aug 3, 2002 at 4:47 pm
    Aug 7, 2002 at 5:24 am
  • Please correct me if I've got this wrong, but it appears from the SRF API, that a SRF cannot readily refer to the TupleDesc to which it is expected to conform (i.e. the TupleDesc derived from the ...
    John GrayJohn Gray
    Aug 30, 2002 at 11:46 am
    Aug 31, 2002 at 7:14 pm
  • Hi, I noticed this behaviour: usa=# SELECT rr.id, rr.name, rr.description FROM recipe_recipes rr WHERE rr.ftiidx ## 's'; id | name | description ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Aug 15, 2002 at 5:43 am
    Aug 23, 2002 at 11:31 am
  • I'd like to propose dropping the auto-creation of UNIQUE indexes on serial columns for the following reasons: 1. Serials with indexes are quite difficult to handle in pg_dump. It means that the ...
    Rod TaylorRod Taylor
    Aug 17, 2002 at 8:57 pm
    Aug 20, 2002 at 3:18 am
  • So far as I recall, no one's really taken up the challenge of deciding how psql's various \d commands should work in the presence of schemas. Here's a straw-man proposal: 1. A wildcardable pattern ...
    Tom LaneTom Lane
    Aug 5, 2002 at 5:27 pm
    Aug 10, 2002 at 4:49 am
  • Gavin SherryGavin Sherry
    Aug 9, 2002 at 9:20 am
    Aug 27, 2002 at 5:21 am
  • Hi all, I get the following when I attempt to build outside of the source tree. All goes well until.... make[4]: Entering directory ...
    John GrayJohn Gray
    Aug 20, 2002 at 11:07 am
    Aug 22, 2002 at 2:46 am
  • I think we are going to see more company-funded developers working on PostgreSQL. There are a handful now, but I can see lots more coming. I am going to work on getting those funding companies more ...
    Bruce MomjianBruce Momjian
    Aug 15, 2002 at 3:05 pm
    Aug 16, 2002 at 8:41 am
  • ... is once more 'normal' ... there are three modules right now setup: earthdistance libpqxx pgsql-server pgsql combines all three of the above to transparently give the equivalent of the whole ...
    Marc G. FournierMarc G. Fournier
    Aug 1, 2002 at 1:24 pm
    Aug 2, 2002 at 4:07 am
  • Hello everybody, There is an open question we need broad opinion on. Currently pgaccess stores its own data in the database it works with. Some people do not like that. To store it elsewhere invokes ...
    Iavor RaytchevIavor Raytchev
    Aug 30, 2002 at 3:45 pm
    Sep 4, 2002 at 4:25 pm
  • Would it be worth adding REINDEX ALL and CLUSTER ALL as actual SQL commands? This would be neat. Plus, it means we don't have to worry about having unix-only script in the distro once we have Win32 ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Aug 27, 2002 at 7:33 am
    Aug 27, 2002 at 8:15 pm
  • I was going to ask that too. I need to make up a list of 7.2.2 changes, and there are quite a number of them. I will get the list together today. ...
    Bruce MomjianBruce Momjian
    Aug 22, 2002 at 2:26 pm
    Aug 26, 2002 at 2:21 pm
  • Just got a note from Jeffrey on this, and he acknowledges that he is continuing to maintain DBD::Pg through CPAN, so we won't be moving it to GBorg ... Bruce, he mentions having tried to contact you ...
    Marc G. FournierMarc G. Fournier
    Aug 22, 2002 at 6:55 pm
    Aug 25, 2002 at 7:57 pm
  • Hi guys, If you apply the pg_stat_reset() function patch you get this regression failure. Is this because it's returning a bool I guess? Shall I just fix the regression test to exclude this function? ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Aug 9, 2002 at 5:49 am
    Aug 14, 2002 at 5:18 am
  • Joe Conway and I have just committed some changes in the internal representation of Postgres arrays: an element-type-OID field is added to the array header, and alignment calculations are now done ...
    Tom LaneTom Lane
    Aug 26, 2002 at 6:37 pm
    Sep 12, 2002 at 12:25 am
  • HI all, Sorry to interrupt your busy list. I was wondering if you could recomend a good source code db/indexer that could be used to search through the postgresql code? Thanks, -- Laurette Cisneros ...
    Laurette CisnerosLaurette Cisneros
    Aug 30, 2002 at 6:57 pm
    Sep 3, 2002 at 11:33 pm
  • On FreeBSD/Alpha, CVS gives: gmake[4]: Entering directory `/home/chriskl/pgsql-head/src/backend/parser' gmake[4]: Nothing to be done for `all'. gmake[4]: Leaving directory ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Aug 21, 2002 at 8:59 am
    Sep 2, 2002 at 2:36 am
  • There is so much going on, I am having trouble keeping things straight. Just thought I would let everyone know. ;-) -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 ...
    Bruce MomjianBruce Momjian
    Aug 22, 2002 at 10:07 pm
    Aug 23, 2002 at 9:45 am
  • OK - I assume from everybody else's silence that they either (a) agree with the idea, or (b) think Tom hit the idea on the head, so they feel they don't need to respond. So what I would like to do is ...
    Philip WarnerPhilip Warner
    Aug 19, 2002 at 4:17 am
    Aug 19, 2002 at 2:34 pm
  • I needed to move a PostgreSQL database to another product but I noticed that the pg_dump output contains a few artifacts that make the output nonportable. Most of these should be relatively easy to ...
    Peter EisentrautPeter Eisentraut
    Aug 14, 2002 at 5:05 pm
    Aug 15, 2002 at 8:13 pm
  • Dear all, The current implementation of views uses OIDs, not table/view names. As a consequence, when you happen to replace (drop then create) an underlying table or view, you also have to drop and ...
    Emmanuel CharpentierEmmanuel Charpentier
    Aug 13, 2002 at 11:08 pm
    Aug 14, 2002 at 3:34 am
  • Hey Peter, I notice that here: http://candle.pha.pa.us/main/writings/pgsql/sgml/ddl-alter.html You mention that you cannot remove a column. This is no longer true as of last friday. And here: ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Aug 6, 2002 at 2:27 am
    Aug 6, 2002 at 6:22 am
  • Is it ok if Florian and I submit the improvements to the fulltextindex contrib during beta? Chris
    Christopher Kings-LynneChristopher Kings-Lynne
    Aug 30, 2002 at 4:45 am
    Aug 30, 2002 at 4:06 pm
Group Navigation
period‹ prev | Aug 2002 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions260
posts2,295
users135
websitepostgresql.org...
irc#postgresql

135 users for August 2002

Bruce Momjian: 425 posts Tom Lane: 400 posts Christopher Kings-Lynne: 120 posts Marc G. Fournier: 103 posts Joe Conway: 80 posts Peter Eisentraut: 70 posts Rod Taylor: 67 posts Greg Copeland: 62 posts Hannu Krosing: 55 posts Curt Sampson: 52 posts Lamar Owen: 48 posts Tatsuo Ishii: 40 posts Gavin Sherry: 39 posts Vince Vielhaber: 37 posts Neil Conway: 35 posts Alvaro Herrera: 32 posts Oliver Elphick: 29 posts Oleg Bartunov: 28 posts Andreas Zeugswetter: 27 posts Thomas Lockhart: 25 posts
show more
Archives