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