Re: [HACKERS] Error handling in plperl and pltcl

2004-11-20 Thread Thomas Hallgren
Tom Lane wrote: Thomas Hallgren [EMAIL PROTECTED] writes: My approach with PL/Java is a bit different. While each SPI call is using a try/catch they are not using a subtransaction. The catch will however set a flag that will ensure two things: 1. No more calls can be made from PL/Java

Re: [HACKERS] Beta5 Scheduale

2004-11-20 Thread Reini Urban
Marc G. Fournier schrieb: Just a quick note, since we obviously passed the previous date we were aiming for ... we're aiming for Sunday evening to roll Beta5 ... all the major stuff that we felt were outstanding have been committed, and a *large* # of the smaller patches, but Bruce is working

Re: [Testperf-general] Re: [HACKERS] ExclusiveLock

2004-11-20 Thread Simon Riggs
On Thu, 2004-11-18 at 22:55, Tom Lane wrote: Josh Berkus [EMAIL PROTECTED] writes: The main problem on INSERTs is that it is usually the same few pages: the lead data block and the lead index block. There are ways of spreading the load out across an index, but I'm not sure what happens on

Re: [HACKERS] [JDBC] Strange server error with current 8.0beta driver

2004-11-20 Thread Oliver Jowett
Barry Lind wrote: Environment #1: WinXP 8.0beta4 server, 8.0jdbc client 2004-11-19 12:19:06 ERROR: unrecognized node type: 25344832 Environment #2: Sun Solaris 7.4.3 server, 8.0jdbc client ERROR: no value found for parameter 1 From memory the 7.4.3 behaviour you see can happen if you DECLARE

[HACKERS] New compile warnings

2004-11-20 Thread Bruce Momjian
I am seeing the following compile warnings in CVS. I am using for perl: Summary of my perl5 (5.0 patchlevel 5 subversion 3) configuration: --- gmake[2]: Leaving directory

[HACKERS] Interesting parsing problem ...

2004-11-20 Thread Hans-Jürgen Schönig
I am willing to add NOWAIT to a couple of commands and I have tried to resolve a bison problem for quite some time now: As a first step I wanted to add NOWAIT to DELETE: DELETE FROM ... WHERE ... NOWAIT; Therefore I used:

[HACKERS] Fwd: SELECT MAX with char = BUG?

2004-11-20 Thread Rodrigo Carvalhaes
Hi ! I am quite confused of the results on a SELECT max... My environment: Conectiva Linux 10, PostgreSQL 7.4.6 (compiled from the sources) My problem is the select max(id) FROM test the result is 20 but the right is 1020. Is this a BUG or I am crazy ?? Cheers, Rodrigo Carvalhaes The SQL...

Re: [Testperf-general] Re: [HACKERS] ExclusiveLock

2004-11-20 Thread Tom Lane
Simon Riggs [EMAIL PROTECTED] writes: On Thu, 2004-11-18 at 22:55, Tom Lane wrote: If it is a problem, the LockBuffer calls in RelationGetBufferForTuple would be the places showing contention delays. You say this as if we can easily check that. I think this can be done with oprofile ...

Re: [HACKERS] Trouble with plpgsql on 7.4.6

2004-11-20 Thread Tom Lane
D'Arcy J.M. Cain [EMAIL PROTECTED] writes: I thought that this would have sent everything to both the log and the screen but I found that the syslog has much more detail. I have attached that output. We still need to look at the stderr output. All this says is that you're getting repeated

Re: [HACKERS] Fwd: SELECT MAX with char = BUG?

2004-11-20 Thread Richard Huxton
Rodrigo Carvalhaes wrote: Hi ! I am quite confused of the results on a SELECT max... My environment: Conectiva Linux 10, PostgreSQL 7.4.6 (compiled from the sources) My problem is the select max(id) FROM test the result is 20 but the right is 1020. Is this a BUG or I am crazy ?? Crazy. And

Re: [HACKERS] New compile warnings

2004-11-20 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: I am seeing the following compile warnings in CVS. I am using for perl: Summary of my perl5 (5.0 patchlevel 5 subversion 3) configuration: I believe these two: plperl.c:948: warning: `ret_hv' might be used uninitialized in this function

Re: [HACKERS] Fwd: SELECT MAX with char = BUG?

2004-11-20 Thread Tom Lane
Rodrigo Carvalhaes [EMAIL PROTECTED] writes: My problem is the select max(id) FROM test the result is 20 but the right is 1020. Is this a BUG or I am crazy ?? You seem to be confused about the difference between numbers and character strings. max() on a char(n) column returns the

Re: [HACKERS] Relation does not exist

2004-11-20 Thread Brusser, Michael
Title: RE: [HACKERS] Relation does not exist Brusser, Michael [EMAIL PROTECTED] writes: Our customer reported a problem with Postgres v.7.3.2 server on Solaris 8 I asked them to run a quick query and it looks like the database is corrupted: select count (1) from

[HACKERS] SRF related and other questions

2004-11-20 Thread Katsaros Kwn/nos
Hi, First, I have the following question on Set Returning Functions: Regarding the return type, there are two ways of defining it: Either set it to: "setof _some_predifined_type" or set it to: "setof records" and then define the expected results with "as(attr1 type, ..., attr_n type)".

Re: [HACKERS] SRF related and other questions

2004-11-20 Thread Joe Conway
Katsaros Kwn/nos wrote: Either set it to: setof _some_predifined_type or set it to: setof records and then define the expected results with as(attr1 type, ..., attr_n type). Right? Correct. Except it should be setof record, not setof records. If these are indeed the only ways, is it possible to

Re: [HACKERS] pgxs regression

2004-11-20 Thread Joe Conway
Thomas Hallgren wrote: Joe Conway wrote: The problem is related specifically to Makefiles using MODULE_big. I tested a few contribs that use MODULES and they seem to work fine under pgxs. Seems you have the same issue that I have with PL/Java. I had to explicitly change my target from:

Re: [HACKERS] Error handling in plperl and pltcl

2004-11-20 Thread Tom Lane
Thomas Hallgren [EMAIL PROTECTED] writes: Tom Lane wrote: That's what pltcl has always done, and IMHO it pretty well sucks :-( it's neither intuitive nor useful. Given that most SPI actions that you do doesn't elog (most of them are typically read-only), it's far more useful than imposing

Re: [HACKERS] pgxs regression

2004-11-20 Thread Tom Lane
Joe Conway [EMAIL PROTECTED] writes: I'll go take a look at the thread (haven't yet) but as of the moment this is not fixed in cvs. Here are two examples from contrib (in each case I inserted USE_PGXS = 1 into the Makefile): # cd contrib/dblink/ # vi Makefile # make make: *** No rule to

[HACKERS] cvs web errors

2004-11-20 Thread Joe Conway
Anyone else seeing problems with cvs web? For at least the past week, I'm seeing: Error: pgsql/pgsql/src/Makefile.shlib.diff: no such file or directory whenever I try to do Diff to previous. It is also gawdawful slow in arriving at that error. Joe ---(end of

Re: [HACKERS] Error handling in plperl and pltcl

2004-11-20 Thread Greg Stark
Tom Lane [EMAIL PROTECTED] writes: (I'm sure we can do more to speed up subtransaction entry/exit than we have so far.) Is there anything that can be done to short circuit the _first_ layer of subtransaction? I'm thinking there will be many cases like this where there's one implicit

Re: [HACKERS] pgxs regression

2004-11-20 Thread Joe Conway
Tom Lane wrote: My inclination is to get rid of the dependency of the Makefile.shlib targets on pg_config_paths.h; Bruce has never satisfactorily explained why he added that. There may be a need for a dependency on pg_config_paths.h someplace, but surely this is the wrong place. I don't

Re: [HACKERS] Error handling in plperl and pltcl

2004-11-20 Thread Tom Lane
I wrote: I get about 6900 vs 12800 msec, so for a simple pre-planned query it's not quite a 50% overhead. However, that was yesterday ;-). I did some profiling and found some easy-to-knock-off hotspots. Today I'm measuring about 25% overhead for a simple SELECT, which I think is entirely

Re: [HACKERS] pgxs regression

2004-11-20 Thread Tom Lane
Joe Conway [EMAIL PROTECTED] writes: Indeed, backing out Bruce's commit ( http://archives.postgresql.org/pgsql-committers/2004-10/msg00158.php ) makes my problems go away. I have no idea how to fix the win32 stuff though :( Looking more closely, those dependencies were wrong anyway since

Re: [HACKERS] Error handling in plperl and pltcl

2004-11-20 Thread James William Pye
On Fri, 2004-11-19 at 16:58 -0500, Tom Lane wrote: What I think we ought to do is change both PL languages so that every SPI call is executed as a subtransaction. If the call elogs, we can clean up by aborting the subtransaction, and then we can report the error message as a Perl or Tcl error

Re: [HACKERS] cvs web errors

2004-11-20 Thread Tom Lane
Joe Conway [EMAIL PROTECTED] writes: Anyone else seeing problems with cvs web? For at least the past week, I'm seeing: Error: pgsql/pgsql/src/Makefile.shlib.diff: no such file or directory whenever I try to do Diff to previous. It is also gawdawful slow in arriving at that error. It works

Re: [HACKERS] Error handling in plperl and pltcl

2004-11-20 Thread Tom Lane
James William Pye [EMAIL PROTECTED] writes: I have been playing with RollbackToSavepoint and ReleaseSavepoint, but per Neil's comments on IRC and the fact that I have to annoyingly construct a List containing the savepoint name. I get the feeling that I am not meant to use them. You're right.

Re: [HACKERS] cvs web errors

2004-11-20 Thread Joe Conway
Tom Lane wrote: Did you repoint your bookmark to http://developer.postgresql.org/cvsweb.cgi/pgsql/ instead of pgsql-server? Doooh! That was it -- thanks! Joe ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] New compile warnings

2004-11-20 Thread Andrew Dunstan
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: I am seeing the following compile warnings in CVS. I am using for perl: Summary of my perl5 (5.0 patchlevel 5 subversion 3) configuration: I believe these two: plperl.c:948: warning: `ret_hv' might be used uninitialized in this

Re: [HACKERS] New compile warnings

2004-11-20 Thread Andrew Dunstan
Andrew Dunstan wrote: This message can actually be fixed with the addition of the following 2 lines to SPI.xs: *BOOT*: *items* = 0; /* avoid '*unused **variable*' warning */ Argghh!! Mozilla mailer CP strikes again. BOOT: items = 0; /* avoid 'unused variable' warning */ cheers

Re: [HACKERS] Minor problem with Makefile.shlib

2004-11-20 Thread Thomas Hallgren
Fabien COELHO wrote: I guess the magic is explained because you installed *over* the previous test install you did to check my patch? So the header files were there from this previous install. Nope. I removed my previous installation. It's easy enough to check if CVS have some way to check out

Re: [HACKERS] Minor problem with Makefile.shlib

2004-11-20 Thread Thomas Hallgren
Fabien COELHO wrote: Dear Thomas, Something that Fabien Coelho fixed recently broke tonight. I can no longer compile PL/Java on win32 using pgxs since the directory pgxs/src/include/port/win32/* is missing (again). AFAICS, the patch is in the queue waiting for a review. Well, the CVS HEAD

Re: [HACKERS] Minor problem with Makefile.shlib

2004-11-20 Thread Fabien COELHO
I guess the magic is explained because you installed *over* the previous test install you did to check my patch? So the header files were there from this previous install. Nope. I removed my previous installation. It's easy enough to check if CVS have some way to check out a snapshot based

Re: [HACKERS] Minor problem with Makefile.shlib

2004-11-20 Thread Tom Lane
Thomas Hallgren [EMAIL PROTECTED] writes: Nope. I removed my previous installation. It's easy enough to check if CVS have some way to check out a snapshot based on a timestamp. Does it? Yes, -D I think. See the manual. (Note this is sticky, so you probably want to do it in a scratch

Re: [HACKERS] Minor problem with Makefile.shlib

2004-11-20 Thread Thomas Hallgren
Tom, Yes, -D I think. See the manual. (Note this is sticky, so you probably want to do it in a scratch checkout rather than overwriting your regular tree.) Something lingered allright, but not in the PostgreSQL installation that I removed. Sigh... Anyway, the patch that was applied tonight

[HACKERS] bug/issue tracking system?

2004-11-20 Thread Arman Bostani
I was wondering if there's a bug/issue tracking system for pgsql? (e.g. something like http://www.bugzilla.org) Is the TODO list all that there is? Best Regards, -arman ---(end of broadcast)--- TIP 7: don't forget to increase your free space map

[HACKERS] no snapshot has been set error

2004-11-20 Thread Ruey-Lung Hsiao
Hi all, I encountered a problem when I'm implementing my user-defined type. My user-defined type is defined as CREATE TYPE X ( INTERNALLENGTH = 10 INPUT = X_in, OUTPUT = X_out ); In my X_in() function, I want to access other table to do some bookkeeping stuff. this table keeps track

[HACKERS] How to check the postgresql version

2004-11-20 Thread Ruey-Lung Hsiao
Hi, Sorry if this problem seems stupid but I would appreciate it if someone helps. I've been implementing several user-defined types and their corresponding GiST index in postgresql 7.4.3. They worked well. However, I have noticed there are several changes in SPI functions and their

[HACKERS] How to make lo_import and lo_export to use file on client local machine?

2004-11-20 Thread Premsun Choltanwanich
I try to use lo_import and lo_export for manage large object on PostgreSQL. I found that all files must be process on server with these commands. Could I make lo_import and lo_export to use file on client local machine? And How? Or Is it has other ways to manage large object that process is

[HACKERS] Usenet Discussion Proposal

2004-11-20 Thread Harry Smith
This was posted in news.groups, but it was not posted to the list. REQUEST FOR DISCUSSION (RFD) unmoderated group comp.databases.postgresql.admin unmoderated group comp.databases.postgresql.general unmoderated group

[HACKERS] How to deal with order by, group by, distinct for user-defined types

2004-11-20 Thread Ruey-Lung Hsiao
Hi, I implemented a user-defined type, say X, and when I want to do the following queries, Postgresql will complain CREATE TABLE Table1 ( id integer, object X ); SELECT X, count(*) from Table1 GROUP BY X; ERROR: could not identify an ordering operator for type X HINT: Use an explicit