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
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
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
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
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
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:
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...
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 ...
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
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
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
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
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
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)".
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
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:
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
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
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
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
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
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
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
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
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
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.
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
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
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
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
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
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
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
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
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
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
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
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
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
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
40 matches
Mail list logo