[HACKERS] Back from Japan

I am back from Japan, and have caught up on email in a single 18 hour day (100 emails/hour average). I will return to process emails needing special attention in the next few days, and start applying more patches soon. -- Bruce Momjian http://candle.pha.pa.us SRA OSS, Inc. http://www.sra

Re: [HACKERS] Remove ora2pg from contrib

Great, please remove it. Also, please mention the new URL so I can put it in the release notes. Thanks. --- Peter Eisentraut wrote: > Apparently, the development of ora2pg is going on at >

Re: [HACKERS] Pl/Python -- current maintainer?

I see neilc has hacked on it very recently to reduce memory leaks. I take that as both good and bad signs. We're a [ small ] python shop, and would be most interested in being able to simplify our life through doing some things in plpython instead of pl/pgsql where appropriate. Keeping our

Re: [HACKERS] Pl/Python -- current maintainer?

James Robinson wrote: I'm interested in poking though and taking a shot at getting my feet wet with pl/python. I see the file is copyright Andrew Bosma -- is he still around perhance? Is anyone currently the 'owner' ? To my knowledge there is no current maintainer of plPython and it definitely

[HACKERS] Pl/Python -- current maintainer?

I'm interested in poking though and taking a shot at getting my feet wet with pl/python. I see the file is copyright Andrew Bosma -- is he still around perhance? Is anyone currently the 'owner' ? James Robinson Socialserve.com ---(end of broadcast)--

Re: [HACKERS] pg_config, pg_service.conf, postgresql.conf ....

Mark Woodward wrote: > > If you require a policy, then YOU are free to choose the policy that > > YOU need. You're not forced to accept other peoples' policies that > > may conflict with things in your environment. > > The problem is that there is no mechanism through which one can implement > po

Re: [HACKERS] Resurrecting some old patches

Aren't they in the 8.2 hold queue that I have not processed yet: http://momjian.postgresql.org/cgi-bin/pgpatches_hold --- Martijn van Oosterhout wrote: -- Start of PGP signed section. > Hi, > > Late last year I pos

Re: [HACKERS] AC_REPLACE_FUNCS([getaddrinfo]) in 8.1.3

Tom Lane wrote: > Albert Chin <[EMAIL PROTECTED]> writes: > > On Sun, Feb 19, 2006 at 09:56:20PM -0500, Tom Lane wrote: > >> Hmm, where is it then? > > > getaddrinfo is a macro in : > > Yes, we know that. The question was where does the macro point. > > > The solution is to either revert to the

Re: [HACKERS] pg_service.conf

Mark Woodward wrote: > > It turns out what you like actually exists, lookup the "service" > > parameter in the connectdb string. It will read the values for the > > server, port, etc from a pg_service.conf file. > > > > There is an example in the tree but it looks something like the following: > >

Re: [HACKERS] constraints and sql92 information_schema compliance

On Fri, Feb 24, 2006 at 04:23:19PM -0800, Josh Berkus wrote: | Correct. Our uniqueness on constraints is: | schema_name | table_name | constraint_name | | We're aware that it's a violation of SQL92, but there's no way for us to | change it now without making it very hard for people to upgrade.

Re: [HACKERS] constraints and sql92 information_schema compliance

Clark, > So it would seem that naming rules for constraints in PostgreSQL > isn't exactly compliant with SQL92. I'm curious what sorts of > constraints are enforced... Correct. Our uniqueness on constraints is: schema_name | table_name | constraint_name We're aware that it's a violation of SQL

[HACKERS] constraints and sql92 information_schema compliance

Hello all. I've got a question with regard to the INFORMATION_SCHEMA of PostgreSQL, specificially related to constraints. In the SQL92 specification, the DEFINITION_SCHEMA.DOMAIN_CONSTRAINTS (the "imaginary" base for INFORMATION_SCHEMA.DOMAIN_CONSTRAINTS), has a primary key: CONSTRAINT_CATALOG,

Re: [HACKERS] Remove ora2pg from contrib

On Friday 24 February 2006 18:37, Tom Lane wrote: > Josh Berkus writes: > >> Please kill it already. This has been discussed and agreed upon a number > >> of times before, the last of which I even sent a quasi-patch to remove > >> this particular entry. > > > > Actually, there are 4-6 more project

Re: [HACKERS] Remove ora2pg from contrib

Josh Berkus writes: >> Please kill it already. This has been discussed and agreed upon a number >> of times before, the last of which I even sent a quasi-patch to remove >> this particular entry. > Actually, there are 4-6 more projects slated to get removed from contrib > per decision on this li

Re: [HACKERS] fsutil ideas

>>> On Fri, Feb 24, 2006 at 5:25 pm, in message <[EMAIL PROTECTED]>, Alvaro Herrera <[EMAIL PROTECTED]> wrote: > > Having it build with PGXS would be a definite plus for ease of > installation. It does. ---(end of broadcast)--- TIP 1: if posti

Re: [HACKERS] fsutil ideas

Kevin Grittner wrote: > I've not dealt with pgfoundry before, so I don't know how much > modification, if any, is needed to set that up. It's working for us now > by building in standard contrib fashion (from contrib/fsutil). The > files: Having it build with PGXS would be a definite plus for e

Re: [HACKERS] fsutil ideas

>>> On Fri, Feb 24, 2006 at 5:00 pm, in message <[EMAIL PROTECTED]>, "Jim C. Nasby" <[EMAIL PROTECTED]> wrote: > Oh, so does it actually involve any server modifications? Or can it just > go into pgfoundry? No server modifications. I've got it bundled up as though it were going to be under cont

Re: [HACKERS] fsutil ideas

Oh, so does it actually involve any server modifications? Or can it just go into pgfoundry? On Fri, Feb 24, 2006 at 08:25:03AM -0600, Peter Brant wrote: > The code in question is written as C extension functions. I think we > were thinking it might be something for contrib (although perhaps that >

Re: [HACKERS] Remove ora2pg from contrib

Robert, > Please kill it already. This has been discussed and agreed upon a number > of times before, the last of which I even sent a quasi-patch to remove > this particular entry. Actually, there are 4-6 more projects slated to get removed from contrib per decision on this list; they're waiting

Re: [HACKERS] Remove ora2pg from contrib

On Friday 24 February 2006 11:31, Peter Eisentraut wrote: > Apparently, the development of ora2pg is going on at > , and quite actively so, rather than in > contrib, so I see no point in keeping it at the latter location except to > confuse people. License uniformi

Re: [HACKERS] Blog post on EnterpriseDB...maybe off topic

Folks, > What they don't say is whether that is a 50% speed up from the > default settings or a 50% increase from a carefully hand tunes file. AFAIT, most of their performance speed-up comes from two sources: 1) a carefully hand-tuned compile of Postgres using ICC, and 2) Improving on the default

Re: [HACKERS] how solve diff of API counstruct_md_array between

On Fri, Feb 24, 2006 at 02:57:19PM -0500, Bruce Momjian wrote: > Yea, that is probably the best you can do currently, but it is pretty > ugly. We have PQserverVersion() in libpq for use by clients, which > does: > > conn->sversion = (100 * vmaj + vmin) * 100 + vrev; > > Perhaps we sh

Re: [HACKERS] fsutil ideas

Ühel kenal päeval, R, 2006-02-24 kell 19:20, kirjutas Csaba Nagy: > On Fri, 2006-02-24 at 19:12, Rod Taylor wrote: > > On Fri, 2006-02-24 at 12:48 -0500, Tom Lane wrote: > > > Rod Taylor <[EMAIL PROTECTED]> writes: > > > > I watch for table bloat but I haven't figured out a nice way of tracking > >

Re: [HACKERS] how solve diff of API counstruct_md_array between

Joe Conway wrote: > Martijn van Oosterhout wrote: > > On Thu, Feb 16, 2006 at 08:36:34PM +0100, Pavel Stehule wrote: > >>I use counstruct_md_array function in my Orafunc module. CVS version has > >>diff def now. I am findig way for simple solution of maintaince source code > >>for both version. I

Re: [HACKERS] fsutil ideas

On Fri, 2006-02-24 at 19:20 +0100, Csaba Nagy wrote: > On Fri, 2006-02-24 at 19:12, Rod Taylor wrote: > > On Fri, 2006-02-24 at 12:48 -0500, Tom Lane wrote: > > > Rod Taylor <[EMAIL PROTECTED]> writes: > > > > I watch for table bloat but I haven't figured out a nice way of tracking > > > > down the

Re: [HACKERS] fsutil ideas

On Fri, 2006-02-24 at 19:12, Rod Taylor wrote: > On Fri, 2006-02-24 at 12:48 -0500, Tom Lane wrote: > > Rod Taylor <[EMAIL PROTECTED]> writes: > > > I watch for table bloat but I haven't figured out a nice way of tracking > > > down the postgresql process with the oldest transaction running short o

Re: [HACKERS] fsutil ideas

On Fri, 2006-02-24 at 12:48 -0500, Tom Lane wrote: > Rod Taylor <[EMAIL PROTECTED]> writes: > > I watch for table bloat but I haven't figured out a nice way of tracking > > down the postgresql process with the oldest transaction running short of > > patching PostgreSQL to report the XID for a conne

Re: [HACKERS] fsutil ideas

Rod Taylor <[EMAIL PROTECTED]> writes: > I watch for table bloat but I haven't figured out a nice way of tracking > down the postgresql process with the oldest transaction running short of > patching PostgreSQL to report the XID for a connection in > pg_stat_activity. I don't think you need a patc

Re: [HACKERS] fsutil ideas

> > I'm curious as to how you monitor for total transaction time length > to > > ensure that vacuum is able to do its thing, particularly when the > > transaction is active (not IDLE). > > We run a database vacuum nightly and review it the next day. Ahh.. different issues again I guess. I have

Re: [HACKERS] fsutil ideas

"Kevin Grittner" <[EMAIL PROTECTED]> writes: > We haven't used tablespace features yet, as 3 of the 4 databases > running PostgreSQL so far are on Windows. We have run out of space a > couple times, and it seems like it handles it well in terms of not > corrupting the database, and resuming OK onc

Re: [HACKERS] fsutil ideas

>>> On Fri, Feb 24, 2006 at 10:57 am, in message <[EMAIL PROTECTED]>, Rod Taylor <[EMAIL PROTECTED]> wrote: > > PostgreSQL seems to deal with out of diskspace situations pretty well > when it impacts a tablespace (global stuff like WAL or subtransactions > have issues -- but they grow slowly) as

Re: [HACKERS] fsutil ideas

On Fri, 2006-02-24 at 09:48 -0600, Kevin Grittner wrote: > >>> On Fri, Feb 24, 2006 at 9:34 am, in message > <[EMAIL PROTECTED]>, > Rod Taylor <[EMAIL PROTECTED]> wrote: > > > > You don't need to know the free diskspace in real time. A 2 minute > old > > value is probably just as good. > > Not

Re: [HACKERS] memory context for tuplesort return values

Simon Riggs <[EMAIL PROTECTED]> writes: > On Thu, 2006-02-23 at 16:10 -0500, Tom Lane wrote: >> I don't want to give up the idea of keeping sort-local data in a >> private >> context --- it just seems cleaner, as well as faster, than letting it >> be >> mixed into the caller's stuff. I can see two

Re: [HACKERS] Remove ora2pg from contrib

I think we should kill the contrib... I haven't personally seen anyone use it in a long time.  I've found that more and more people are using the Java ETL tools (which is kinda sad because ora2pg is pretty good). On 2/24/06, Peter Eisentraut <[EMAIL PROTECTED]> wrote: Apparently, the development of

[HACKERS] Remove ora2pg from contrib

Apparently, the development of ora2pg is going on at , and quite actively so, rather than in contrib, so I see no point in keeping it at the latter location except to confuse people. License uniformity is an extra argument for removal. So please speak up or I'

Re: [HACKERS] fsutil ideas

>>> On Fri, Feb 24, 2006 at 9:34 am, in message <[EMAIL PROTECTED]>, Rod Taylor <[EMAIL PROTECTED]> wrote: > > You don't need to know the free diskspace in real time. A 2 minute old > value is probably just as good. Not really, this sort of monitoring has kept us from crashing under our old dat

Re: [HACKERS] User privileges-verification required

"Nauman Naeem" <[EMAIL PROTECTED]> writes: > I tried the single-user mode option and it worked, thanks! but, don't > you people think that we should provide this privilege in multi-user > mode as well.In accordence to my second point. No. Restricting what a superuser can do is pointless --- he ca

Re: [HACKERS] textToQualifiedNameList second parameter

Rafael Martinez Guerrero <[EMAIL PROTECTED]> writes: > Some months ago, the second parameter was removed [1] so I had to modify > my program to work after this change. Now with 8.0.7, the second > parameter is back again I think you're confused. The second parameter was removed in 8.1. It's prese

Re: [HACKERS] fsutil ideas

Kevin Grittner wrote: Since we have what we need to get our work done, and the community at large doesn't seem interested, I'll shelve the idea of submitting anything. I think you have misinterpreted. By all means share the code. Put it on your website or start a pgfoundry project. Even i

Re: [HACKERS] fsutil ideas

> > This seems an area where providing consistent cross- platform > behavior > > might be difficult. Do we actually need this functionality inside the > > > DBMS in the first place? > > It sounds like we should probably just shelve the idea of sharing this > code. It is very useful to us, since

Re: [HACKERS] fsutil ideas

>>> On Thu, Feb 23, 2006 at 8:43 pm, in message <[EMAIL PROTECTED]>, Neil Conway <[EMAIL PROTECTED]> wrote: > Kevin Grittner wrote: >> Peter Brant, a consultant working with us, has written code which is >> working for this under both Linux and Windows. [...] For Linux, he >> used statvfs. > >

Re: [HACKERS] fsutil ideas

The code in question is written as C extension functions. I think we were thinking it might be something for contrib (although perhaps that would be too much of an official blessing too?) Pete >>> "Jim C. Nasby" <[EMAIL PROTECTED]> 02/24/06 8:04 am >>> Isn't this something that could be accompli

Re: [HACKERS] User privileges-verification required

I tried the single-user mode option and it worked, thanks! but, don't you people think that we should provide this privilege in multi-user mode as well.In accordence to my second point. On 2/24/06, Peter Eisentraut <[EMAIL PROTECTED]> wrote: > Am Freitag, 24. Februar 2006 14:25 schrieb Nauman Naee

Re: [HACKERS] User privileges-verification required

Am Freitag, 24. Februar 2006 14:25 schrieb Nauman Naeem: > In case I have only one user in my database who is also the DBSystem > (who carries out initdb), user then if that user takes away his > "createuser" privileges, he is unable to grant himself that privilege > again or grant that privilege t

[HACKERS] User privileges-verification required

Hello all, While playing around with database users, I noticed one odd thing regarding user privileges. In case I have only one user in my database who is also the DBSystem (who carries out initdb), user then if that user takes away his "createuser" privileges, he is unable to grant himself that

Re: [HACKERS] AC_REPLACE_FUNCS([getaddrinfo]) in 8.1.3

Tom Lane wrote: Albert Chin <[EMAIL PROTECTED]> writes: On Sun, Feb 19, 2006 at 11:32:53PM -0500, Tom Lane wrote: Would you try the patch proposed at http://archives.postgresql.org/pgsql-patches/2006-01/msg00299.php Works fine on Tru64 UNIX 4.0D and 5.1. OK, appli

[HACKERS] textToQualifiedNameList second parameter

Hello In version 7.4.x, the function textToQualifiedNameList was defined with two parameters. Some months ago, the second parameter was removed [1] so I had to modify my program to work after this change. Now with 8.0.7, the second parameter is back again and I get this error when I try to comp

Re: [HACKERS] memory context for tuplesort return values

On Thu, 2006-02-23 at 16:10 -0500, Tom Lane wrote: > I don't want to give up the idea of keeping sort-local data in a > private > context --- it just seems cleaner, as well as faster, than letting it > be > mixed into the caller's stuff. I can see two alternatives: Would that be a single context