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/Jav
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 th
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 h
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
C
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
`/usr/var/local/src/gen/pgsql/CURRENT/pgsql/
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...
tes
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 repea
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 posti
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
> plpe
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
lexicog
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 t_
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 po
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:
all
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
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
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 broadcast)
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 subtran
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 understand
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 acc
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 sinc
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 er
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.
I
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 r
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 C&P 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 snapsho
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 ch
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 s
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
parame
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 betwe
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 comp.databases.postgresql.hackers
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 ordering
40 matches
Mail list logo
