Re: [HACKERS] Transaction is read-only in auto commit mode

Chattopadhyay asked: > My application based on Java servlets was running fine with > version PostgreSQL 7.x, but started giving error: > "transaction is read-only", in version 8.0 and 8.1. I am > using Suse Linux 9.3/PostgreSQL 8.0 or Suse Linux > 10.1/PostgreSQL 8.1. I am using JDBC 3 drivers

Re: [HACKERS] String Similarity

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tue, Sep 26, 2006 at 09:09:33AM +0800, Pang Zaihu wrote: > Hello! > Would you like to give me a simple introduction of Levenshtein distence > function? Better than I could explain: > Thank yo

[HACKERS] Can i see server SQL commands ?

Hi all I wanna know what is going on while a DML command works. For example ; Which commands are executed by the core when we send an "UPDATE tab SET col = val1..." in case there is a foreing key or an unique constraint on table "tab". How can i see that ?

Re: [HACKERS] Faster StrNCpy

On Wed, Sep 27, 2006 at 07:08:05AM -0700, Strong, David wrote: > We sometimes see TupleDescInitEntry () taking high CPU times via > OProfile. This does include, amongst a lot of other code, a call to > namestrcpy () which in turn calls StrNCpy (). Perhaps this is not a > good candidate right now as

Re: [HACKERS] -HEAD planner issue wrt hash_joins on dbt3 ?

Stefan Kaltenbrunner wrote: too bad - however any idea on one of the other troubling querys (q21) I mentioned in the mail I resent to the list (after the original one got lost)? http://archives.postgresql.org/pgsql-hackers/2006-09/msg02011.php What happens if you increase statistics for l_orde

Re: [HACKERS] [GENERAL] Restart after power outage: createdb

On Wed, Sep 27, 2006 at 04:52:51PM -0400, Tom Lane wrote: > "Jim C. Nasby" <[EMAIL PROTECTED]> writes: > > Then again, if we're doing that, we could probably just nuke 'em... > > This has been considered and rejected before, on the grounds that > removing files you don't know the source of is a go

Re: [HACKERS] PostgreSQL HA questions

[EMAIL PROTECTED] (Andrew Sullivan) writes: > It isn't clear to me why you think you need to do this: vacuum > doesn't block your queries anyway. If the idea is that you have a > table that you'd rather TRUNCATE and not have to vacuum, however, > that makes sense. There are several strategies for

Re: [HACKERS] [GENERAL] Restart after power outage: createdb

"Jim C. Nasby" <[EMAIL PROTECTED]> writes: > Then again, if we're doing that, we could probably just nuke 'em... This has been considered and rejected before, on the grounds that removing files you don't know the source of is a good way to lose data. Come to think of it, that argument bears on th

Re: [HACKERS] [GENERAL] Restart after power outage: createdb

On Wed, Sep 27, 2006 at 04:13:34PM -0400, Tom Lane wrote: > Jon Lapham <[EMAIL PROTECTED]> writes in pgsql-general: > > If I run... > > sleep 3; echo starting; createdb bar > > ...and power off the VM while the "createdb bar" is running. > > > Upon restart, about 50% of the time I can reproduce th

Re: [Pgbuildfarm-members] [HACKERS] Buildfarm alarms

Jim C. Nasby wrote: Another possibility is just having the client report "no CVS changes detected" to the server, as a form of a ping. I am not going to re-architect the buildfarm client and server for this. I think what I have done will be quite sufficient. I suspect most people will onl

Re: [HACKERS] [GENERAL] Restart after power outage: createdb

Jon Lapham <[EMAIL PROTECTED]> writes in pgsql-general: > If I run... > sleep 3; echo starting; createdb bar > ...and power off the VM while the "createdb bar" is running. > Upon restart, about 50% of the time I can reproduce the following error > message: > [EMAIL PROTECTED] ~]$ psql bar > psql

Re: [Pgbuildfarm-members] [HACKERS] Buildfarm alarms

On Wed, Sep 27, 2006 at 01:55:21PM -0400, Andrew Dunstan wrote: > Kris Jurka wrote: > > > > > > On Wed, 27 Sep 2006, Andrew Dunstan wrote: > > > >> The settings are in hours, so this says that if we haven't seen a > >> HEAD build in 1 day or a stable branch build in 1 week, alert the > >> owner

Re: [HACKERS] [PATCHES] Patch for UUID datatype (beta)

[EMAIL PROTECTED] wrote: On Tue, Sep 19, 2006 at 11:21:51PM -0400, Alvaro Herrera wrote: [EMAIL PROTECTED] wrote: On Tue, Sep 19, 2006 at 08:20:13AM -0500, Jim C. Nasby wrote: On Mon, Sep 18, 2006 at 07:45:07PM -0400, [EMAIL PROTECTED] wrote: I would not use a 100% random number generator for

Re: [HACKERS] Buildfarm & cvsignore files

Rocco Altier wrote: I noticed that the build farm is only looking for the cvs-ignore'd files for a vpath build. Attached is a patch that will stop at the CVS stage if there are any cvs-ignore'd files in the clean repository. Its not triggered by a from-source build, only what should have been a

Re: [HACKERS] [ADMIN] pg_hba.conf: 'trust' vs. 'md5' Issues

This brings up something that I may have asked before, but I may also have just thought I should: Should/could we have the error message somehow reflect if the connection used pgpass.conf to pick up the password? //Magnus > -Original Message- > From: [EMAIL PROTECTED] [mailto:pgsql-hacke

Re: [HACKERS] PostgreSQL HA questions

First, I'm moving this to -general, because this is way off topic for -hackers as near as I can tell. On Tue, Sep 26, 2006 at 10:39:18PM +0200, Dragan Zubac wrote: > 1. Is it possible for multiply PostgreSQL instances (engines,cores) to use > same DATA space? No. In fact, this is a very good w

Re: [HACKERS] horo(r)logy test fail on solaris (again and solved)

On Wed, Sep 27, 2006 at 04:09:18PM +0200, Zdenek Kotala wrote: > Tom Lane napsal(a): > >Zdenek Kotala <[EMAIL PROTECTED]> writes: > >>The problem was generated, because -fast option was set only for the > >>compiler and not for the linker. Linker takes wrong version of > >>libraries. If -fast i

Re: [HACKERS] DROP FUNCTION IF EXISTS

> "CN" == Csaba Nagy <[EMAIL PROTECTED]> writes: CN> The full story is that I typed 'ü' (u-umlaut if it won't render CN> correctly) and backspace before the '1'. I guess the backspace CN> will delete byte-wise and will so fail to delete properly CN> multi-byte characters. Backspace deletes ch

[HACKERS] PostgreSQL HA questions

Hello We're looking for HA PostgreSQL solution,so have a couple of questions: 1. Is it possible for multiply PostgreSQL instances (engines,cores) to use same DATA space? For example,to have two PostgreSQL processes which will use same data directory,same files,and same data ? So,if You update som

[HACKERS] Transaction is read-only in auto commit mode

Hi,   My application based on Java servlets was running fine with version PostgreSQL 7.x, but started giving error: "transaction is read-only", in version 8.0 and 8.1. I am using Suse Linux 9.3/PostgreSQL 8.0 or Suse Linux 10.1/PostgreSQL 8.1. I am using JDBC 3 drivers and all connections are in

Re: [PATCHES] [HACKERS] large object regression tests

On Mon, 25 Sep 2006, Tom Lane wrote: > Jeremy Drake <[EMAIL PROTECTED]> writes: > > I just tried using the \lo_import command in a regression test, and I > > think I figured out why this will not work: > > ... > > Yes, that's the large object OID in the output there, and it is different > > each r

Re: [HACKERS] String Similarity

Hello! Would you like to give me a simple introduction of Levenshtein distence function? Thank you!    On 2006-05-19 19:54, Martijn van Oosterhout wrote: >  On Fri, May 19, 2006 at 04:00:48PM -0400, Mark Woodward wrote: >  >  (3) Is there also a desire for a Levenshtein distence function fo

Re: [PATCHES] [HACKERS] large object regression tests

On Sun, 24 Sep 2006, Jeremy Drake wrote: > On Thu, 21 Sep 2006, Tom Lane wrote: > > > I suggest that instead of testing the server-side lo_import/lo_export > > functions, perhaps you could test the psql equivalents and write and > > read a file in psql's working directory. > In the mean time, I w

Re: [HACKERS] Buildfarm alarms

Kris Jurka wrote: On Wed, 27 Sep 2006, Andrew Dunstan wrote: The settings are in hours, so this says that if we haven't seen a HEAD build in 1 day or a stable branch build in 1 week, alert the owner by email, and keep repeating the alert in each case every 2 days. How does this know if

Re: [HACKERS] psql service parameter

On Wed, Sep 27, 2006 at 10:23:13AM -0400, Andrew Dunstan wrote: > > I have just noticed that there does not seem to be a psql command > line switch to specify a pg_service.conf name to connect to. I know > we can use a PGSERVICE environment setting instead, but I think we > should have a command l

[HACKERS] Buildfarm & cvsignore files

I noticed that the build farm is only looking for the cvs-ignore'd files for a vpath build. Attached is a patch that will stop at the CVS stage if there are any cvs-ignore'd files in the clean repository. Its not triggered by a from-source build, only what should have been a clean check out. Tha

Re: [HACKERS] Cross-table statistics idea

On Wed, Sep 27, 2006 at 12:30:43PM +0100, Simon Riggs wrote: > On Tue, 2006-09-26 at 21:27 -0500, Jim C. Nasby wrote: > > Since I don't recall any ideas ever having been thrown out on how to do > > this... > > > > ISTM that we could gain additional insight on how many rows would likely > > result

Re: [HACKERS] Buildfarm alarms

On Wed, 27 Sep 2006, Andrew Dunstan wrote: The settings are in hours, so this says that if we haven't seen a HEAD build in 1 day or a stable branch build in 1 week, alert the owner by email, and keep repeating the alert in each case every 2 days. How does this know if there wasn't a buil

Re: [HACKERS] Block B-Tree concept

On Wed, Sep 27, 2006 at 05:38:38AM -0400, Bruce Momjian wrote: > Heikki Linnakangas wrote: > > Jim C. Nasby wrote: > > > Couldn't vacuum just eliminate tuples marked dead? Heck, don't we do > > > that anyway right now? > > > > You mean _index_ tuples marked dead? Sure, no problem there. > > > > >

Re: [HACKERS] psql service parameter

On Wed, Sep 27, 2006 at 04:54:35PM +0200, Albe Laurenz wrote: > I think that both would be nice. Indeed, I wanted to suggest > a switch for PGSERVICE myself. It some point I was wondering about using the @ symbol. If you have a service entry called "testserver", you could do: psql @testserver Bu

Re: [HACKERS] psql service parameter

Tom Lane wrote: > Andrew Dunstan <[EMAIL PROTECTED]> writes: >> I have just noticed that there does not seem to be a psql >> command line switch to specify a pg_service.conf name >> to connect to. I know we can use a PGSERVICE environment >> setting instead, but I think we should have >> a comman

Re: [HACKERS] Block B-Tree concept

> > I think you build a whole new index named something like ".temp-reindex" and > > then as the last step of the second transaction delete the old idnex and > > rename the new index. > > That would require getting exclusive lock on the table. Just out of curiosity, creating a new index concurren

Re: [HACKERS] psql service parameter

Andrew Dunstan <[EMAIL PROTECTED]> writes: > I have just noticed that there does not seem to be a psql command line > switch to specify a pg_service.conf name to connect to. I know we can > use a PGSERVICE environment setting instead, but I think we should have > a command line switch too. Small

Re: [HACKERS] Block B-Tree concept

Gregory Stark <[EMAIL PROTECTED]> writes: > Tom Lane <[EMAIL PROTECTED]> writes: >> That's probably more easily said than done --- in particular, I don't >> understand what the committed state after the first transaction would >> look like. > I think you build a whole new index named something lik

Re: [HACKERS] Block B-Tree concept

Tom Lane <[EMAIL PROTECTED]> writes: > Heikki Linnakangas <[EMAIL PROTECTED]> writes: >> Also, now that we have concurrent CREATE INDEX, we could implement >> concurrent REINDEX as well, I believe. > > That's probably more easily said than done --- in particular, I don't > understand what the com

[HACKERS] psql service parameter

I have just noticed that there does not seem to be a psql command line switch to specify a pg_service.conf name to connect to. I know we can use a PGSERVICE environment setting instead, but I think we should have a command line switch too. Small 8.3 TODO item? cheers andrew ---

Re: [HACKERS] horo(r)logy test fail on solaris (again and solved)

Tom Lane napsal(a): Zdenek Kotala <[EMAIL PROTECTED]> writes: The problem was generated, because -fast option was set only for the compiler and not for the linker. Linker takes wrong version of libraries. If -fast is set for both then horology test is OK, but question was if float optimaliza

Re: [HACKERS] Buildfarm alarms

> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Andrew Dunstan > Sent: 27 September 2006 14:56 > To: [EMAIL PROTECTED] > Cc: pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] Buildfarm alarms > > If some intrepid buildfarm owner wants to t

Re: [HACKERS] Block B-Tree concept

Heikki Linnakangas <[EMAIL PROTECTED]> writes: > AFAICS, we could disable the optimization and use a full-blown > transaction when vacuuming a table with a functional block index. No, we couldn't, or at least it's not merely a matter of reversing a recent optimization. The fundamental issue wit

Re: [HACKERS] Faster StrNCpy

We sometimes see TupleDescInitEntry () taking high CPU times via OProfile. This does include, amongst a lot of other code, a call to namestrcpy () which in turn calls StrNCpy (). Perhaps this is not a good candidate right now as a name string is only 64 bytes. David __

Re: [HACKERS] Buildfarm alarms

I wrote: Tom Lane wrote: "Andrew Dunstan" <[EMAIL PROTECTED]> writes: It could certainly be done. In general, I have generally taken the view that owners have the responsibility for monitoring their own machines. Sure, but providing them tools to do that seems within buildfarm's

Re: [HACKERS] horo(r)logy test fail on solaris (again and solved)

Zdenek Kotala <[EMAIL PROTECTED]> writes: > The problem was generated, because -fast option was set only for the > compiler and not for the linker. Linker takes wrong version of > libraries. If -fast is set for both then horology test is OK, but > question was if float optimalization should ge

Re: [HACKERS] Faster StrNCpy

Andrew Dunstan <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> What I'd like to do immediately is put in strlcpy() and hit the two or >> three places I think are performance-relevant. > What are the other hotspots? The ones I can think of offhand are set_ps_display and use of strncpy as a HashCo

Re: [HACKERS] horo(r)logy test fail on solaris (again and solved)

Andrew Dunstan napsal(a): Tom Lane wrote: Zdenek Kotala <[EMAIL PROTECTED]> writes: But the question is if the "-fast" flag is good for postgres. The -fast flag sets "brutal" floating point optimization and some operation should have less precision. Is possible verify that floating point

Re: [HACKERS] Faster StrNCpy

Tom Lane wrote: Josh Berkus writes: What I'd like to do immediately is put in strlcpy() and hit the two or three places I think are performance-relevant. Immediately? Presumably you mean for 8.3? No, I mean now. This is a performance bug and it's still open season on bu

Re: [HACKERS] Please to technical check of upcoming release

> http://pgfoundry.org/docman/view.php/147/233/release82.zip > is a zip file of a draft of the PostgreSQL 8.2 release and accompanying > press kit. Please check if the technical details are correct, and get > back to me with any corrections by Thursday. Hi :) I still see "Theo Scholossena

Re: [HACKERS] Faster StrNCpy

Tom, Let us know when you've added strlcpy () and we'll be happy to run some tests on the new code. David From: [EMAIL PROTECTED] on behalf of Tom Lane Sent: Tue 9/26/2006 7:25 PM To: josh@agliodbs.com Cc: pgsql-hackers@postgresql.org; Neil Conway; Martijn va

Re: [HACKERS] Cross-table statistics idea

On Tue, 2006-09-26 at 21:27 -0500, Jim C. Nasby wrote: > Since I don't recall any ideas ever having been thrown out on how to do > this... > > ISTM that we could gain additional insight on how many rows would likely > result from a join One thing we can do is to use cross-column relationships to

Re: [HACKERS] Block B-Tree concept

Bruce Momjian wrote: Heikki Linnakangas wrote: Jim C. Nasby wrote: Granted, you'd want to periodically ensure that you scan the entire index, but that shouldn't be horribly hard to set up. Well, it seems to be. A vacuum can't evaluate index expressions because it's not in a real transaction.

Re: [HACKERS] Block B-Tree concept

Heikki Linnakangas wrote: > Jim C. Nasby wrote: > > Couldn't vacuum just eliminate tuples marked dead? Heck, don't we do > > that anyway right now? > > You mean _index_ tuples marked dead? Sure, no problem there. > > > Granted, you'd want to periodically ensure that you scan the entire > > index,

Ignore that mail (was: [HACKERS] jar in repository)

Hi, Markus Schaber wrote: [something about a postgis.jar] Please ignore that mail, it got to the wrong list. Thanks, Markus -- Markus Schaber | Logical Tracking&Tracing International AG Dipl. Inf. | Software Development GIS Fight against software patents in Europe! www.ffii.org www.nosof

Re: [HACKERS] [PATCHES] Bad bug in fopen() wrapper code

Magnus Hagander writes: > Now, I still twist my head around the lines: > if ((fd = _open_osfhandle((long) h, fileFlags & O_APPEND)) < 0 > || > (fileFlags & (O_TEXT | O_BINARY) && (_setmode(fd, > fileFlags & (O_TEXT | O_BINARY)) < 0))) > > > With the _setmode() call deep in th

Re: [HACKERS] Developer's Wiki

> > I have now moved the wiki installation to: > > > > http://developer.postgresql.org/ > > BTW: I am wondering if there is an RSS feed of the changes? There is. http://developer.postgresql.org/index.php?title=Special:Recentchanges&fe ed=rss //Magnus ---(end of broadca

Re: [HACKERS] Developer's Wiki

On Wed, 27 Sep 2006, Lukas Kahwe Smith wrote: > Dave Page wrote: > > I have now moved the wiki installation to: > > > > http://developer.postgresql.org/ > > BTW: I am wondering if there is an RSS feed of the changes? > > On my wiki I have an RSS feed for every page, subwiki (aka area) and the > en

Re: [HACKERS] Developer's Wiki

Dave Page wrote: I have now moved the wiki installation to: http://developer.postgresql.org/ BTW: I am wondering if there is an RSS feed of the changes? On my wiki I have an RSS feed for every page, subwiki (aka area) and the entire wiki people can subscribe to: http://oss.backendmedia.com/

Re: [HACKERS] jar in repository

Hi, Strk, strk wrote: > Markus, I noticed we have a .jar file in the repository. > Why is that ? Can't we build it from sources with free software tools ? It was a mistake when chekcing in the EJB3 code. It's just a copy of the normal postgis.jar that's needed to compile the EJB3 code, it was pa

Re: [HACKERS] Constant changes (Re-Build)

luis garcia wrote: Hi I'm a student from Valencia-Venezuela and I'm working with some other friends to make PostgreSQL allows the definition of Temporal Databases and their respective Selection, Insertion and some other functions needed to treat this paradigm (all based in TSQL2 Query Language).

Re: [HACKERS] Block B-Tree concept

Jim C. Nasby wrote: Couldn't vacuum just eliminate tuples marked dead? Heck, don't we do that anyway right now? You mean _index_ tuples marked dead? Sure, no problem there. Granted, you'd want to periodically ensure that you scan the entire index, but that shouldn't be horribly hard to set up

Re: [HACKERS] Block B-Tree concept

Jim C. Nasby wrote: Do I understand that to mean that you can no longer lazy vacuum a functional index? With the normal B-trees we have now, there's no problem vacuuming a functional index. But it would be a problem with the Block B-tree, because the proposed way of vacuuming a Block B-tree i

Re: [HACKERS] [PATCHES] Bad bug in fopen() wrapper code

> > What's bugging me is that 0 and O_EXCL give the same answer, and > > O_TRUNC and O_TRUNC | O_EXCL give the same answer, > > This is ok, as (iirc) O_EXCL only has effect in the presence > of O_CREAT. Thanks, Claudio! After looking at the code some more, and actually reading up on the spec

Re: [HACKERS] horo(r)logy test fail on solaris (again and solved)

Josh Berkus napsal(a): Zdenek, Hmmm ... we're not using the -fast option for the standard PostgreSQL packages. Where did you start using it? Yes, I know. The -fast option generates architecture depending code and it is not possible use in common packages. I found out this option when I a