Search Discussions

152 discussions - 1,012 posts

  • Several people have asked if we are losing momentum. Specifically, they are concerned about Red Hat dropping their Red Hat Database and instead distributing PostgreSQL as part of Red Hat Enterprise ...
    Bruce MomjianBruce Momjian
    Apr 14, 2003 at 10:37 pm
    Apr 24, 2003 at 11:14 pm
  • Since now is the time for contrib/ flamewars, this seemed a good time to suggest this. My colleague, Sorin Iszlai, wrote us a little program for rotating our Postgres logs. It reads stdout and ...
    Andrew SullivanAndrew Sullivan
    Apr 3, 2003 at 3:21 pm
    May 24, 2003 at 2:45 am
  • ...and if so, what are the current efforts focusing on?
    Ron PeacetreeRon Peacetree
    Apr 5, 2003 at 4:38 pm
    Apr 14, 2003 at 8:56 pm
  • I know nothing in contrib should be GPL, I have no problem with that. The question is the requirement of a GPL library to build a contrib project. My SOAP/XML function will probably require my LGPL ...
    Mark L. WoodwardMark L. Woodward
    Apr 1, 2003 at 9:21 pm
    Apr 7, 2003 at 8:59 am
  • I recall someone floating a proposal that initdb should by default initialize the database in C locale, not whatever-it-finds-in-the- environment. To get a non-C locale you'd have to give an explicit ...
    Tom LaneTom Lane
    Apr 18, 2003 at 2:48 pm
    Jun 10, 2003 at 6:17 am
  • Hello all In earlier threads on the Hackers mailing list there were discussions of a few things that I would like to comment on. Sorry in advance for the length of this post. First, PostgreSQL needs ...
    Rob ButlerRob Butler
    Apr 16, 2003 at 3:33 pm
    Apr 19, 2003 at 3:33 pm
  • Having just used bit strings for the first time, I am now aware of some features I consider a little odd, and was wondering if (a) they are actively being worked on, (b) if they are not considered ...
    Philip WarnerPhilip Warner
    Apr 22, 2003 at 11:48 am
    Apr 24, 2003 at 1:37 am
  • I've just been having an informative off-list conversation with Mike Sykes. As he pointed out in a message that Marc forwarded to the list ...
    Tom LaneTom Lane
    Apr 15, 2003 at 2:35 pm
    Apr 17, 2003 at 9:15 pm
  • Hi Ben http://www.pgadmin.org/ It looks more like SQL Server's Enterprise Manager but does most if not all of what I expect you need. The tarball includes the complete documentation in HTML format, ...
    Dave PageDave Page
    Apr 17, 2003 at 10:01 am
    Apr 23, 2003 at 8:37 am
  • I just updated to cvs tip, did `make clean`, `configure`, and `make all` and got this: i386-redhat-linux-gcc -O2 -g -Wall -Wmissing-prototypes -Wmissing-declarations -I../../../src/include ...
    Joe ConwayJoe Conway
    Apr 25, 2003 at 3:06 am
    Aug 17, 2003 at 6:36 pm
  • On one machine (installed as 7.3.1, upgraded to 7.3.2): usa=# select version(); version --------------------------------------------------------------------- PostgreSQL 7.3.2 on ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Apr 22, 2003 at 2:23 am
    Apr 22, 2003 at 9:31 am
  • Folks, Please pardon the cross-posting. A small group of us on the Performance list were discussing the first steps toward constructing a comprehensive Postgresql installation benchmarking tool, ...
    Josh BerkusJosh Berkus
    Apr 3, 2003 at 5:55 pm
    Apr 4, 2003 at 8:17 pm
  • Hi all, A week or 2 back I reported a problem with 7.3.2 failing to open pg_clog files ([HACKERS] pg_clog woes with 7.3.2). Tom Lane was kind enough to login and do some debugging on a couple of ...
    Dave PageDave Page
    Apr 16, 2003 at 2:20 pm
    Nov 4, 2003 at 3:17 pm
  • Hi, I'm looking for information on the scalabality of the LISTEN/NOTIFY mechanism. How well does it scale with respect to: - hundreds of clients registered for LISTENs I guess this translates to ...
    Apr 29, 2003 at 1:04 am
    May 15, 2003 at 4:05 am
  • I'm using 7.3.2 on Linux, with a decent amount of muscle behind it (1.5 GHz PPro CPU, 1G mem, 20M/sec disks, xlog on different disk than data). I've got a database that has several foreign keys, and ...
    Kevin BrownKevin Brown
    Apr 18, 2003 at 5:11 am
    Apr 25, 2003 at 7:53 pm
  • I've been thinking some more about the FE/BE protocol redesign, specifically the desire to ensure that we can recover from error conditions without losing synchronization. The fact that the existing ...
    Tom LaneTom Lane
    Apr 9, 2003 at 10:30 pm
    Apr 15, 2003 at 8:43 pm
  • I just derived the following rather interesting numbers concerning the cost of SSL-encryption in CVS tip. The test case is to COPY about 40MB of data to or from a server running on the same machine ...
    Tom LaneTom Lane
    Apr 10, 2003 at 10:50 pm
    Apr 22, 2003 at 1:21 am
  • I noticed today (while trying to answer a question) that the following doesn't seem to use the index on reasonably recent sources whereas it seems to have at 7.3.1. create table b1(a int, b text); ...
    Stephan SzaboStephan Szabo
    Apr 9, 2003 at 2:48 pm
    Jun 11, 2003 at 8:57 pm
  • Well, we could drop the support for postfix operators in aliasing clauses that omit the AS. In fact, I got the following to work with no further changes: target_el: a_expr AS ColLabel If we wanted ...
    Peter EisentrautPeter Eisentraut
    Apr 14, 2003 at 4:38 pm
    May 15, 2003 at 8:51 pm
  • Looking at libpq, you can see Win32 requires closesocket() while Unix uses just uses close(). I have to add this type of change to the backend for Win32, so I am inclined to make all the socket close ...
    Bruce MomjianBruce Momjian
    Apr 24, 2003 at 6:35 pm
    Apr 25, 2003 at 4:43 pm
  • Followup-To: pgsql-hackers@postgresql.org The changes I committed to address most of the FK deadlock problems reported can easily be applied to the 7.3 and 7.2 source trees as well. Except for a ...
    Jan WieckJan Wieck
    Apr 7, 2003 at 8:52 pm
    Apr 15, 2003 at 5:59 pm
  • It seems current does not handle PGCLIENTENCODING environment variable correctly. $ PGCLIENTENCODING=SJIS psql test Welcome to psql 7.4devel, the PostgreSQL interactive terminal. Type: \copyright for ...
    Tatsuo IshiiTatsuo Ishii
    Apr 27, 2003 at 2:48 am
    Apr 30, 2003 at 2:00 pm
  • Hi Everyone - this is my first post (but I have been lurking on and off for a couple of years). Congratulations on a steadily improving product! This is not a question, just some observations on ...
    Robert DyasRobert Dyas
    Apr 23, 2003 at 6:06 pm
    Apr 25, 2003 at 12:30 am
  • I have committed a first-draft revision of the FE/BE protocol document; you can read it at http://candle.pha.pa.us/main/writings/pgsql/sgml/protocol.html or in a few hours at ...
    Tom LaneTom Lane
    Apr 15, 2003 at 11:08 pm
    Apr 24, 2003 at 5:29 pm
  • The IPv6 patch seems to still be a few bricks shy of a load. Grepping for places that handle AF_INET but not AF_INET6 revealed these unimplemented features: 1. IDENT authorization. Fails if either ...
    Tom LaneTom Lane
    Apr 3, 2003 at 9:47 pm
    Mar 9, 2004 at 11:50 pm
  • I have been thinking about this for a while. Now that we have a practical methodology for returning full rows from functions, we could make this sort of thing pretty "easily." How should it look? How ...
    Mark L. WoodwardMark L. Woodward
    Apr 15, 2003 at 11:07 pm
    May 3, 2003 at 3:19 pm
  • I'm in the process of creating some patches to fix the Cygwin specific build issues mentioned in the following post: http://archives.postgresql.org/pgsql-cygwin/2003-04/msg00053.php I was able to ...
    Jason TishlerJason Tishler
    Apr 29, 2003 at 6:15 pm
    Apr 30, 2003 at 3:18 pm
  • Hi all, When using pg_get_viewdef(oid), the view definition is returned in a reconstructed form (I assume) with all formatting removed. This is a pain for apps like pgAdmin, that allow the user to ...
    Dave PageDave Page
    Apr 1, 2003 at 12:34 pm
    Apr 2, 2003 at 9:56 am
  • I always had been doubious about the "must" in the error message "Attribute must be GROUPed or used in an aggregate function". I certainly agree that there are many situations in which having an ...
    Daniele OrlandiDaniele Orlandi
    Apr 30, 2003 at 9:21 pm
    May 7, 2003 at 1:29 am
  • Howdy. It looks as though the checks that allow for access to schemas doesn't check the correct permissions of the running user in that if a function is being run as the security definer, the schema ...
    Sean ChittendenSean Chittenden
    Apr 26, 2003 at 8:48 pm
    Apr 27, 2003 at 8:35 am
  • There was some talk in the context of the new protocol to do some enhancements in the area of the "binary" format to make it useful across different architectures etc. The SQL standard defines a ...
    Peter EisentrautPeter Eisentraut
    Apr 29, 2003 at 5:57 pm
    May 6, 2003 at 2:21 am
  • Hi there, this is actually a repost from the BUGS-list where I got no answer. I'm using 7.3.2 and encounter the problem that a SELECT query that uses a function with a constant argument is quite ...
    Joachim WielandJoachim Wieland
    Apr 25, 2003 at 9:51 am
    Apr 28, 2003 at 7:51 am
  • Hello all, I took a look at the docs for Postgres views & rules. I also took a look at dblink. I think there is a very plausible way to get "cross-db" queries in postgres 1) Support for 2PC added. 2) ...
    Rob ButlerRob Butler
    Apr 16, 2003 at 2:10 pm
    Apr 16, 2003 at 5:35 pm
  • I'm trying to execute a postgresql function from perl. The function inserts data into two different tables. I prefer this a sopposed to using two insert statements. Can anyone point me to any ...
    Stu KroneStu Krone
    Apr 9, 2003 at 5:30 am
    Apr 16, 2003 at 7:45 am
  • The U.S. Census provides a database of street polygons and other data about landmarks, elevation, etc. This was discussed in a separate thread. The main URL is here: ...
    Mark L. WoodwardMark L. Woodward
    Apr 8, 2003 at 12:40 pm
    Apr 8, 2003 at 10:28 pm
  • Hi, I was just going thr. dblink code and noticed that dblink cursors are wrapped in their own transaction. If an application instantiates a transaction to do 10 things, one of which is to fetch a ...
    Shridhar DaithankarShridhar Daithankar
    Apr 16, 2003 at 1:01 pm
    Apr 17, 2003 at 8:00 am
  • I'm not exactly sure what the problem is, or how it happened. I have a database where I deleted all records from all tables. I run a vacuum full and am left with about 1 GB of data. What I think is ...
    Kurt RoeckxKurt Roeckx
    Apr 15, 2003 at 10:36 pm
    Apr 16, 2003 at 7:42 pm
  • I have been testing the postgresql Peer Direct port. I've used both the released binary and my own compiled version and get the same behavior. Please not that this is for testing purposes and I am ...
    Merlin MoncureMerlin Moncure
    Apr 1, 2003 at 3:37 pm
    Apr 3, 2003 at 9:02 am
  • Patch for contrib/intarray and contrib/ltree modules. Download from: http://www.sai.msu.su/~megera/postgres/gist/patches/intarray_ltree.patch.gz Changes: 1 intarray: bugfix for int[]-int[] operation ...
    Teodor SigaevTeodor Sigaev
    Apr 28, 2003 at 3:48 pm
    Jun 11, 2003 at 7:31 pm
  • Hi all, There are various places in the backend, such as FreeFile(), where the return value of fclose() is not tested. Whilst we would often notice any problems with writing to data files due to ...
    Gavin SherryGavin Sherry
    Apr 16, 2003 at 5:02 am
    Jun 6, 2003 at 3:55 pm
  • Now that CVS tip is rid of the need for libpq to do a "select pg_client_encoding()", I am wondering if we shouldn't make an effort to get rid of psql's "SELECT usesuper FROM pg_catalog.pg_user ..." ...
    Tom LaneTom Lane
    Apr 25, 2003 at 10:35 pm
    Jun 1, 2003 at 4:14 am
  • Hi, After reading an article about pgfs: http://www.linuxjournal.com/article.php?sid=1383 I can't find pgfs, and it seems the author had not maintain it for a long time. Would anyone know any other ...
    Kevin LoKevin Lo
    Apr 24, 2003 at 10:17 am
    Apr 25, 2003 at 2:00 am
  • Items that have names after them in the TODO-list, do these names indicate that the persons are working on it now? The item i'm extra curious about is * Add SQL99 WITH clause to SELECT (Tom, ...
    Dennis BjörklundDennis Björklund
    Apr 21, 2003 at 5:17 am
    Apr 22, 2003 at 2:31 pm
  • Hi, I know I should have clubbed in last post but did not notice. 1. Why is that dblink allows only one persistent connection? It should allow more than one persistent connections to same or ...
    Shridhar DaithankarShridhar Daithankar
    Apr 16, 2003 at 1:14 pm
    Apr 17, 2003 at 8:02 am
  • OK, here's my proposal for a more economical use of parentheses. - implicit casted variables are not put in parentheses (myVar)::integer - myVar::integer, no chance to misinterpret this - explicit ...
    Andreas PflugAndreas Pflug
    Apr 8, 2003 at 1:17 pm
    Apr 9, 2003 at 3:42 pm
  • Assuming that following queries are executed on PostgreSQL 7.3. create table c1 (i integer); create table c2 (i integer); insert into c1 values (1 .. 100000); insert into c2 values (1 .. 100000); (A) ...
    Kenji SugitaKenji Sugita
    Apr 7, 2003 at 8:35 am
    Apr 7, 2003 at 8:00 pm
  • PG Folks, Could we have a .conf option to turn OFF the "Adding Missing From Clause for Table ... "? I'd far rather have a fatal query error than have Postgres automatically insert the tables it ...
    Josh BerkusJosh Berkus
    Apr 29, 2003 at 9:37 pm
    Jun 1, 2003 at 4:51 am
  • The type "name" can be subscripted like an array to access the individual "char" elements. But since a character stored in a "name" value isn't necessarily one byte, this is incorrect. Does anything ...
    Peter EisentrautPeter Eisentraut
    Apr 26, 2003 at 9:05 pm
    Apr 27, 2003 at 8:11 pm
  • I know this is a bit off-topic, but I was hoping someone can point me in the right direction. I've been spinning my wheels on this for a while now. I'm having trouble with PL/R giving me a SIGSEGV ...
    Joe ConwayJoe Conway
    Apr 25, 2003 at 10:46 pm
    Apr 27, 2003 at 1:10 am
  • HI, We are working on a project where we want to create a single linked list that holds information of all the locks taken or being waited for by transactions in Postgresql. Since main in ...
    S -S -
    Apr 24, 2003 at 7:34 am
    Apr 26, 2003 at 1:37 am
Group Navigation
period‹ prev | Apr 2003 | next ›
Group Overview
grouppgsql-hackers @

138 users for April 2003

Tom Lane: 209 posts Bruce Momjian: 43 posts Mark L. Woodward: 33 posts Peter Eisentraut: 31 posts Kevin Brown: 30 posts Joe Conway: 27 posts Scott.marlowe: 25 posts Dave Page: 23 posts Jan Wieck: 23 posts Sean Chittenden: 23 posts Christopher Browne: 22 posts Hannu Krosing: 20 posts Ron Peacetree: 20 posts Shridhar Daithankar: 20 posts Andrew Sullivan: 19 posts Christopher Kings-Lynne: 19 posts Dann Corbit: 17 posts Stephan Szabo: 17 posts Neil Conway: 15 posts Tatsuo Ishii: 15 posts
show more