FAQ

PostgreSQL > pgsql-hackers > May 2003

Search Discussions

159 discussions - 802 posts

  • When we started on 7.4 development, I was hoping for three major features: o PITR (point-in-time recovery) o Win32 port o Master-slave Postgres-R Now, the last one isn't going to happen because we ...
    Bruce MomjianBruce Momjian
    May 5, 2003 at 7:23 pm
    May 15, 2003 at 3:00 am
  • Looking through the TODO list I noticed this item apparently unclaimed: * Allow CIDR format to be used in pg_hba.conf I can look at doing this, having done similar code some years ago. Internally, it ...
    Andrew DunstanAndrew Dunstan
    May 7, 2003 at 1:51 pm
    May 9, 2003 at 4:12 pm
  • pgsql-core have agreed to put out a 7.3.3 release on Wednesday (5/21), God willin' an' the creek don't rise. If anyone's got anything you've been planning to fix in the 7.3 branch, now is a real good ...
    Tom LaneTom Lane
    May 16, 2003 at 5:15 am
    May 22, 2003 at 8:31 am
  • I didn't find any documentation mentioning scheduled jobs. I assume there is no such a feature yet. I would like to implement it if someone helps me with the development process (I am brand new to ...
    Zlatko MichailovZlatko Michailov
    May 12, 2003 at 10:03 pm
    May 22, 2003 at 2:15 pm
  • [Please CC any replies to me. Thanks.] I'm going suggest a feature like what Oracle calls "partitions" and later on something with indexes. The idea is to generate some discussion to see if they are ...
    Martijn van OosterhoutMartijn van Oosterhout
    May 17, 2003 at 3:00 pm
    Jun 2, 2003 at 6:43 pm
  • Folks, I'm trying to prepare comprehensive documentation on the contents of the postgresql.conf file for 7.3.2. However, I'm running into some confusion in the docs (which is why I'm preparing the ...
    Josh BerkusJosh Berkus
    May 12, 2003 at 5:20 pm
    May 15, 2003 at 3:49 pm
  • Pgsql developers: Based on a question posed me by David Fetter of Bricolage, I realized that we have what looks to me to be a serious inconsistency in our permissions model. Please ignore me if this ...
    Josh BerkusJosh Berkus
    May 20, 2003 at 5:08 pm
    Jun 2, 2003 at 6:54 pm
  • At least in 7.3, triggered actions specified as AFTER seem to be deferred to the completion of the outer-most SQL statement. So, if two triggering statements are executed as part of a PLPGSQL ...
    Philip WarnerPhilip Warner
    May 5, 2003 at 5:31 am
    Jul 21, 2003 at 7:05 pm
  • SET CONSTRAINTS doesn't allow you to schema-qualify a constraint name. Here's an example: create schema test; create table test.foo (a int primary key); create table test.bar (b int primary key, c ...
    Peter EisentrautPeter Eisentraut
    May 11, 2003 at 4:44 pm
    Jun 4, 2003 at 9:50 pm
  • Folks, An area in which postgresql planner & indexing could be improved have occurred to me over the last week. I'd like to share this ideas with you in case it is worthy of the todo list. Please ...
    Josh BerkusJosh Berkus
    May 5, 2003 at 7:20 pm
    May 7, 2003 at 2:19 pm
  • Moved to -hackers. Well, I'm not sure about this. In fact, if the reasoning below is correct, we can get away with static Serializable- and QuerySnapshots. I don't think it makes sense to change the ...
    Alvaro HerreraAlvaro Herrera
    May 13, 2003 at 3:59 am
    May 23, 2003 at 7:34 pm
  • I'm about to start going through the backend's elog() calls to update them to ereport() style, add error code numbers, polish wording, etc. So it's time to nail down our style guide for message ...
    Tom LaneTom Lane
    May 14, 2003 at 8:58 pm
    Aug 17, 2003 at 12:14 am
  • *Way* off topic ... but I'm tired of processing through 300 messages nightly of which 10 are stuff that need to be approved for the lists, and 290 are trash ... What are ppl using / trusting out ...
    Marc G. FournierMarc G. Fournier
    May 27, 2003 at 8:41 pm
    May 30, 2003 at 7:57 pm
  • I see an obvious problem in the way pg_dump dumps serials. At the moment, we have length 64 identifiers. If someone has a 64 character table name and adds a serial to it, it will get a truncated ...
    Christopher Kings-LynneChristopher Kings-Lynne
    May 4, 2003 at 4:14 am
    May 5, 2003 at 3:50 pm
  • I remember there was some talk about removing the width=xxx part from the EXPLAIN plans. Any movement towards this? I myself would like to see this happen as it does not provide useful information ...
    Greg Sabino MullaneGreg Sabino Mullane
    May 19, 2003 at 10:17 pm
    May 22, 2003 at 7:59 am
  • We're running into problem with vacuum analyze. We first noticed that with Postgres v.7.2.1. Now with v.7.3.2 it appears again. After nightly maintenance application isn't functioning. It looks that ...
    Michael BrusserMichael Brusser
    May 23, 2003 at 3:08 pm
    May 28, 2003 at 2:17 pm
  • The discussion below has been taking place on the PATCHES list. I'm forwarding it to HACKERS to get a wider audience. We're looking for opinions on (at a minimum): 1) Which of these functions should ...
    Joe ConwayJoe Conway
    May 25, 2003 at 6:16 pm
    May 27, 2003 at 3:25 am
  • In working on an rint() for Win32, I found two --- one in port/qnx4/rint.c and another in dt_common.c. The first is very simple, using fmod, while the second is very complicated. I would like to pick ...
    Bruce MomjianBruce Momjian
    May 9, 2003 at 2:13 am
    May 10, 2003 at 11:54 am
  • Hi-- I've recently installed Slackware 9 (after using Mandrake and RedHat in the past), and I've been attempted to build both Postgres 7.3 and 7.1, and I'm not having success with either of them. The ...
    Brian janaszekBrian janaszek
    May 4, 2003 at 1:57 pm
    May 4, 2003 at 6:52 pm
  • What's the rationale for not including the trailing zero byte in the protocol representation of the text format? The output functions of data types generate one, and the client most likely wants one, ...
    Peter EisentrautPeter Eisentraut
    May 13, 2003 at 11:11 pm
    May 23, 2003 at 2:15 pm
  • Are there any plans to make index names unique to a table instead of to a schema? I was thinking similar to the way that constraints are handled. It's not really necessary, but it would be kinda nice ...
    Sean ChittendenSean Chittenden
    May 8, 2003 at 8:06 pm
    May 12, 2003 at 12:25 am
  • I've been starting to look at assigning SQLSTATE values to all the backend elog() calls, and have realized that the set of values defined by the spec is very, how you say, uneven. They have ...
    Tom LaneTom Lane
    May 30, 2003 at 1:32 pm
    May 30, 2003 at 11:03 pm
  • Dear Sir, I want to know the compilaiton and execution of my code. Suppose if i add a test printf statement in the src/backend/tcop/postgres.c and after compilation and execution i should get that ...
    Srikanth MSrikanth M
    May 28, 2003 at 7:19 am
    May 28, 2003 at 2:25 pm
  • I am seeing a compile failure in variable.c because it references timezone, but I only have struct tm on BSD/OS. --------------------------------------------------------------------------- Tom Lane ...
    Bruce MomjianBruce Momjian
    May 22, 2003 at 8:35 am
    May 22, 2003 at 9:00 pm
  • Hi, I was going thr. a oracle refresher course today. I came across this concept of system triggers which can be installed on things like database/connection startup. I think it would be a good ...
    Shridhar DaithankarShridhar Daithankar
    May 16, 2003 at 2:16 pm
    May 20, 2003 at 3:03 pm
  • Running some process on Postgres 7.3.2 I consistently end up with a crash. This happens on Linux RedHat 6.2, kernel 2.2 Here's the fragment from the database log. 2003-05-07 14:38:48 LOG: recycled ...
    Michael BrusserMichael Brusser
    May 7, 2003 at 7:30 pm
    May 9, 2003 at 3:56 pm
  • Tom, are we moving to a C locale by default for 7.4? -- 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 ...
    Bruce MomjianBruce Momjian
    May 6, 2003 at 11:08 pm
    May 8, 2003 at 2:40 am
  • Now that expressions can be used in indexes in 7.4 you can have multicolumn indexes that are ordered in different directions. However the planner doesn't seem to understand that order by -col asc is ...
    Bruno Wolff IIIBruno Wolff III
    May 30, 2003 at 3:59 pm
    May 30, 2003 at 7:54 pm
  • What capabilities do we have for removing a user's password? The only way I can see to do it is to insert a NULL into pg_shadow, but clearly that is pretty ugly. I don't see any mention in the ALTER ...
    Bruce MomjianBruce Momjian
    May 26, 2003 at 5:33 pm
    May 27, 2003 at 1:45 am
  • I would like to re-table my proposal from many moons ago to allow pattern-matching operations to use indexes under any locale. The idea is that since pattern matching works on a ...
    Peter EisentrautPeter Eisentraut
    May 12, 2003 at 5:32 pm
    May 13, 2003 at 4:47 pm
  • RH7.3 is a supported distribution for at least 6 months. Any plans to add Postgres 7.3.3 RPMs for RH7.3? Thanks
    OwOw
    May 29, 2003 at 11:26 am
    May 29, 2003 at 10:24 pm
  • My understanding (from the documentation and from a quick code check is that the PL/Python code uses Python's "rexec" ability to provide a restricted execution environment for the Python code. For ...
    Sean ReifschneiderSean Reifschneider
    May 25, 2003 at 10:48 pm
    May 28, 2003 at 2:47 am
  • Something we've discussed repeatedly is adding a log rotation program to the distribution so that we don't have to hand-wave in the part of the documentation that talks about setting up ...
    Tom LaneTom Lane
    May 23, 2003 at 7:14 pm
    May 24, 2003 at 1:22 pm
  • Hi I would like to notify a server whenever a certain table is updated. I wonder if this hasn't been solved before. I looked at contrib and Gborg with no success. Maybe it could be a function that ...
    Kaare RasmussenKaare Rasmussen
    May 20, 2003 at 9:31 am
    May 20, 2003 at 7:32 pm
  • I think that would be reasonable, yes. After all one argument for using binary mode is speed and efficiency, and not it's editability with a text editor. Andreas
    Andreas ZeugswetterAndreas Zeugswetter
    May 14, 2003 at 4:27 pm
    May 15, 2003 at 2:26 pm
  • Anyone know whats up with the postgresql cookbook website? (http://www.brasileiro.net/postgres/cookbook/) Seems like it's been down for awhile now. The site maintainers name escapes me (I thought it ...
    Robert TreatRobert Treat
    May 9, 2003 at 5:11 pm
    May 12, 2003 at 11:05 pm
  • I just noticed that there is an inconsistency between the way that PREPARE executes multiple queries (since PREPARE itself accepts only one SQL statement, any such multiple queries must have been ...
    Tom LaneTom Lane
    May 1, 2003 at 3:55 pm
    May 3, 2003 at 2:18 pm
  • I have noticed that after "/etc/init.d/postgresql restart", postmaster is no longer writes to "serverlog". (RedHat 9). Here is fixed "restart" section. restart) echo -n "Restarting PostgreSQL: " su - ...
    Darko PrenosilDarko Prenosil
    May 29, 2003 at 6:37 pm
    Jun 12, 2003 at 2:02 am
  • Hi, The following (link to a) patch is a first attempt to add updates during a \copy. This is so that one has some idea of progress. The output looks as follows: kleptog=# \copy website to /tmp/g ...
    Martijn van OosterhoutMartijn van Oosterhout
    May 19, 2003 at 10:38 pm
    Jun 6, 2003 at 7:47 pm
  • Hi! Simple test suite for current CVS: %initdb ... %createdb q %psql q q=# select * from pg_class limit 1; SELECT q=# select * from pg_class limit 2; server sent data ("D" message) without prior row ...
    Teodor SigaevTeodor Sigaev
    May 26, 2003 at 10:17 am
    May 26, 2003 at 5:54 pm
  • Would anyone object to replacing $Header$ and $Id$ with $PostgreSQL$ for a file version marker? This would some of us to work in our own repo's without losing the PostgreSQL version information -- ...
    Rod TaylorRod Taylor
    May 22, 2003 at 3:46 am
    May 23, 2003 at 5:23 pm
  • On my Red Hat 9 machine I'm getting the following error during compile when configured --with-krb5=/usr/kerberos: i386-redhat-linux-gcc -O2 -g -Wall -Wmissing-prototypes -Wmissing-declarations -fpic ...
    Joe ConwayJoe Conway
    May 16, 2003 at 4:27 am
    May 19, 2003 at 10:09 pm
  • Per the discussion earlier re: sockets and psql
    Alex avrietteAlex avriette
    May 12, 2003 at 2:55 am
    May 14, 2003 at 12:09 am
  • Hi People!  As a project manager I decided to migrate the full project from Oracle to PostgreSQL.  We bought a new Intel box to host the database, it is a dual Xeon 2.2 and I intend to use it with ...
    ListaLista
    May 8, 2003 at 3:55 pm
    May 8, 2003 at 7:57 pm
  • This is what I have seen in the SAP DB mailing list this weekend ... Maybe all of us should have some fun. SAP has finally gone completely insane. I can already see Monty on every SAP advertisment ...
    Hans-Jürgen SchönigHans-Jürgen Schönig
    May 25, 2003 at 7:35 pm
    Jun 5, 2003 at 5:49 am
  • We need to track sequence usage in things like defaults. nextval() function calls don't easily allow this to happen. The 200N spec has NEXT VALUE FOR <seqname as the equivalent to nextval(), which ...
    Rod TaylorRod Taylor
    May 25, 2003 at 3:39 am
    May 29, 2003 at 7:17 pm
  • Hi Tom and Fernando! I can see on the todo-list, that you have subscribed to the item regarding "WITH RECURSIVE" select statements. I really look forward to this feature, but can't find anything ...
    XSTXST
    May 26, 2003 at 12:38 pm
    May 29, 2003 at 4:13 pm
  • It is a common problem that a server uses a nontrivial character set encoding (e.g., Unicode) but users forget to set an appropriate client-side encoding. Then they get bogus displays for non-ASCII ...
    Peter EisentrautPeter Eisentraut
    May 28, 2003 at 9:53 pm
    May 29, 2003 at 9:09 am
  • While playing with the array stuff earlier, I noticed this (using a non-array example to be sure it wasn't related to anything unique to my development environment): regression=# create function ...
    Joe ConwayJoe Conway
    May 27, 2003 at 3:52 am
    May 28, 2003 at 6:38 pm
  • Since several hours I'm getting errors on accessing http://techdocs.postgresql.org/ Same on http://www.postgresql.org/ Did I miss something? Regards, Christoph
    Christoph HallerChristoph Haller
    May 27, 2003 at 12:40 pm
    May 27, 2003 at 2:34 pm
May 2003
1234
Group Navigation
period‹ prev | May 2003 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions159
posts802
users129
websitepostgresql.org...
irc#postgresql

129 users for May 2003

Tom Lane: 190 posts Bruce Momjian: 60 posts Peter Eisentraut: 30 posts Christopher Kings-Lynne: 26 posts Alvaro Herrera Munoz: 21 posts Bruno Wolff III: 19 posts Scott.marlowe: 19 posts Joe Conway: 17 posts Andrew Dunstan: 16 posts Larry Rosenman: 15 posts Andreas Zeugswetter: 14 posts Josh Berkus: 14 posts Philip Warner: 14 posts Rod Taylor: 13 posts Martijn van Oosterhout: 11 posts Dave Page: 10 posts Jim C. Nasby: 10 posts Michael Brusser: 10 posts Sailesh Krishnamurthy: 10 posts Andrew Sullivan: 9 posts
show more
Archives