committers to the PL/Java project?
Regards,
Thomas Hallgren
Marek Lewczuk wrote:
Guy Rouillier pisze:
Nothing productive will come of a language debate; let's just say
there are things you can do with a complete programming language at
your disposal that you can't do with PL/pgsql. I use Java
David Potts wrote:
Is it possible to invoke a computer language other than postgres sql as
the result of a trigger firing, eg something like Java.
Dave.
http://wiki.tada.se/wiki/display/pljava/Home
Regards,
Thomas Hallgren
---(end of broadcast
for OpenCRX spreading FUD about PostgreSQL? Does
anyone know?
Kind Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
using Oracle mapped the UUID to a RAW(16) but PostgreSQL
doesn't have that and the BYTEA adds extra overhead.
What would be the best (as in most efficient) mapping for a 128 bit
primary key?
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 9
Martijn van Oosterhout wrote:
On Wed, Jun 28, 2006 at 09:01:49AM +0200, Thomas Hallgren wrote:
I'm building an app where I have several entities that are identified
using a UUID (i.e. a 128 bit quantity). My current implementation uses a
composite primary key consisting of two int8 values
Martijn van Oosterhout wrote:
On Wed, Jun 28, 2006 at 10:22:45AM +0200, Thomas Hallgren wrote:
Thanks. That would of course work but at the same time it increases the
complexity of my app. Yet another component to install and keep track
of. It's also a bit of an overkill since the only thing I
Martijn van Oosterhout wrote:
On Wed, Jun 28, 2006 at 12:03:40PM +0200, Thomas Hallgren wrote:
OK. I thought you always had a type descriptor handy when reading the
binary representation. I've noticed that the typmod is expected in some
receive functions (bpcharrecv and numeric_recv
. I don't see
CREATE (or any other ddl statement) in that list.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
John,
Thanks for the referral. The link is a bit outdated since all web content has moved to a
wiki. Please use: http://wiki.tada.se/display/pljava/Home instead.
Kind regards,
Thomas Hallgren
John Sidney-Woollett wrote:
I would think the answer is yes.
pljava allows you to create java
execute (and complete) within a transaction and the work
they perform should be rolled back if the transaction is rolled back.
Kind regards,
Thomas Hallgren
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire
to the main, attempts the COMMIT but instead and rolls back due
to a violated constraint? Where does that leave fork-2?
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Rafal Pietrak wrote:
On Thu, 2006-05-25 at 10:33 +0200, Thomas Hallgren wrote:
Rafal Pietrak wrote:
I'd like to propose a 'syntax/semantics' of such trigger:
Triggers normally execute inside of a transaction.
A COMMIT within a trigger could mean: do a fork: fork-1) return to the
main
Joshua D. Drake wrote:
BTW who was the EXPERT that slammed java performance?
No clue, but java sucks on the desktop :)
No it doesn't (unless you mean when tilting your coffee mug. Hmm, no, then you would need
something that actually sucks java).
Regards,
Thomas Hallgren
.
I will not spend time on a war that cannot be fought in this forum. Just wanted to air my
opinion this once :-)
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http
TJ O'Donnell wrote:
Slashdot had this today.
http://searchopensource.techtarget.com/originalContent/0,289142,sid39_gci1172668,00.html
Interesting. JDBC is now a 'language'.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 2: Don't
If you're using JDBC, the C-JDBC (http://c-jdbc.objectweb.org/) might be a good
option.
Regards,
Thomas Hallgren
Devrim GUNDUZ wrote:
Hi,
On Tue, 14 Mar 2006, Jojo Paderes wrote:
Is it possible to cluster PostgreSQL? If yes where can I find the
resource information on how to implement
for ultimate suckiness of the installer ;) I love to
install all X11, Java and stuff on a server to be able to install
a package with about 1/10 the size ;)
How about postponing choice of implementation language until it's clear what it is that
should be implemented ;-)
Regards,
Thomas Hallgren
my 2 cents :)
Bundling Java is a pain, so we'd better stay away from that.
There's always gcj. It's pretty mature by now. I'm not sure about availability compared to
Python though, but I find it hard to believe it would be more painful.
Regards,
Thomas Hallgren
For what it's worth, the next release of PL/Java has support for both RECORD parameters and
SETOF RECORD return types. The adventurous can try out the current CVS HEAD.
Regards,
Thomas Hallgren
Tom Lane wrote:
Yl Zhou [EMAIL PROTECTED] writes:
I want to implement a UDF that can accept
and that it has been deleted if
it's no longer found.
Anyway, my opinion on this, in detail, will be on the ITToolBox blog. You can
argue with me there.
That will be interesting reading. I didn't find it (yet). Can you please post
an URL here?
Regards,
Thomas Hallgren
Thank you for all good suggestions. Clay will probably be my choice for this project since
it indeed is an Eclipse plugin that is developed.
Thanks again,
Thomas Hallgren
---(end of broadcast)---
TIP 5: don't forget to increase your free space
there? Are there any open source alternatives?
Kind regards,
Thomas Hallgren
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
the
integration you ask for is not in anyway possible unless you are content
with one single database connection.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 8: explain analyze is your friend
to make it
happen and I'm not sure you'd gain anything. My advice would be to
consider a multi-threaded server that uses a connection pool and perhaps
include some shared caching of data that is more static in nature in the
middle tier. That could really save some context switches.
Regards,
Thomas
more blah;
END IF:
Why not have the callers call the callee with a boolean parameter?
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
) to use a function
returning SETOF RECORD.
Wouldn't it make sense to be able to define a record in the projection
part of a query, similar to what I was attempting with my SELECT? Has
this been discussed or is it just considered as not very useful?
Regards,
Thomas Hallgren
that
query? I.e. where do specify my RECORD definition? Is it possible at
all? Ideally I'd like to write something like this:
SELECT xyz(a, b) AS (x int, y int, z timestamptz) FROM abc;
but that yields a syntax error.
Regards,
Thomas Hallgren
---(end of broadcast
, thanks for the tip. I guess I'll just stick with
timeofday()::timestamp...its more concise anyways...
Why use timeofday() at all? Why not now(). It will return a timestamptz
without casts.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 1
Scott Marlowe wrote:
I think you missed the first part of the conversation...
I sure did. Sorry...
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
this:
SELECT xyz(a, b) AS (x int, y int, z timestamptz) FROM abc;
but that yields a syntax error.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's
Marc G. Fournier wrote:
And, for Bittorrent Users, David has put up the tar packages at:
http://bt.postgresql.org
The windows installer torrent doesn't work.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 6: Have you searched our list
with Java 1.4. As with GNU GCJ, it uses GNU Classpath and is a
couple of years behind mainstream Java, both from a functionality and
performance standpoint. Still, IKVM is a very interesting project.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 1
Pavel Stehule wrote:
Hello
maybe
http://gborg.postgresql.org/project/plmono/projdisplay.php
but I am not know more
Judging from the CVS, that project hasn't had any activity at all the
last 14 months or so. Is it still active? Has it been moved?
Regards,
Thomas Hallgren
one PL with a validator procedure, which IIRC was your own addition
to that API. How come they don't all have validators?
For PL/Java, the answer is that we just haven't had the time to
implement it. It should be done of course.
Regards,
Thomas Hallgren
---(end
. The above article doesn't mention
this at all.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get
with
PostgreSQL.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list
an
InputStream for a resource stored in a jar file. The class in question
should be in the same package as the resource (i.e. your properties file).
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ
Hi,
From code inside a C-function, given the AclId of a user and the Oid of
a Schema, what's the most efficient way to find out if the user has been
granted CREATE on the schema?
Thanks,
Thomas Hallgren
---(end of broadcast)---
TIP 9: the planner
run within the transaction that was in effect when the call was issued
so your Sybase stored procedures involving several hours of execution
must probably be rewritten so that you move the transaction demarcation
to a client that issues several more short-lived calls.
Regards,
Thomas Hallgren
= fcinfo-flinfo-fn_oid;
...
}
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
and start them locally on my machine
without problems.
This might of course be something in my own setup but I don't have this
problem with any other torrents on the net.
Anyone else experiencing similar problems?
Regards,
Thomas Hallgren
---(end of broadcast
ahead and finds your '.*'. That in turn consumes all but the last character.
Perhaps what you want is '[^0-9]+([0-9]{1,5})[^0-9]+'
Translates to at least one non digit followed by 1-5 digits and then at
least 1 non digit.
Regards,
Thomas Hallgren
---(end of broadcast
no value, hence the
different syntax.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
that instead of threads,
you want it to be completely event driven. In essence that would mean
serving one event per CPU from start to end at any given time. What is
an event in this case? Where did it come from? How will this system
serve concurrent users?
Regards,
Thomas Hallgren
behavior in
many cases.
- Your scheduler is confined to one CPU and cannot react to the system
as a whole.
I think it is more important that the scheduler can balance _all_
sessions among _all_ available resources on the machine.
Regards,
Thomas Hallgren
---(end of broadcast
that the scheduler can balance _all_
sessions among _all_ available resources on the machine.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL
be a warning,
not a notice.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
it would lessen the risk of
introducing ambiguities in the parser (and it looks better than repeated
FROM's).
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs
similar
experiences? What am I doing wrong?
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
to the
pgsql-general list. You got at least one of them (since you replied),
but the list didn't.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Marc G. Fournier wrote:
I'm seeing all of your notes, and am not in the CC either ...
You see the posts that doesn't show up in the archives or on the
newsgroups ?!
If you do, you will see exactly 3 posts on the subject Reasoning behind
process instead of thread based that are addressed to Marco.
Hmm, I'm using another SMTP server now that actually informs me when it
is unable to deliver. Apparently it bounces intermittently with this
message:
Your message of Fri, 29 Oct 2004 17:08:35 +0200 entitled:
Re: [GENERAL] Question regarding the mailing list.
could not be delivered to the
. With respect to my last comment about speed, I guess
it's long overdue to kill this thread now. Let's hope the forum stays
intact :-)
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http
of the features that I feel are essential,
because it does some things dead wrong, and because it is dual licensed.
Hope that cleared up some of the confusion.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 3: if posting/reading through Usenet
(which
is not that significant).
not that significant all depends on how often you need to switch. On
most OS'es, a process switch is significantly slower than switching
between threads (again, Linux may be an exception to the rule).
Regards,
Thomas Hallgren
---(end
be slightly heavier but it does a much better job.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
will have some negative implications for data
exchange.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
.
With respect to the IMO very helpful reply you got from Jeff Davis on
this topic yesterday, what is it you expect from this list? We won't
write an essay for you you know.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 2: you can get off all
overflow
and out of memory, but it can be done. So to state that multi-threaded
environments in general kills all threads when one thread chrashes is
not true. Having said that, I have no clue as to how advanced MySQL is
in this respect.
Regards,
Thomas Hallgren
---(end
.
6. And lastly, my favorite; a multi-threaded system can be easily
integrated with, and make full use of, a multi-threaded virtual
execution environment such as a Java VM.
...
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 6: Have you searched
of
introducing ambiguities in the parser (and it looks better than repeated
FROM's).
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
with the robustness of multiple processes...
So do I. I've learned to really like PostgreSQL and the way it's built,
and as I said in my previous mail, I'm not advocating a switch. I just
react to the unfair bashing of multi-threaded systems.
Regards,
Thomas Hallgren
---(end
kill a number of external
processes. Killing the multithreaded process is more like pulling the plug.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's
_why_ they enable it can do so, but I
strongly object to having this option enabled by default. I suggest that:
1. Have this option disabled by default.
2. Print WARNING's rather than notifications when tables are added.
Regards,
Thomas Hallgren
---(end of broadcast
with yet another syntax?
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
magically patched up by the dbms?
Ok, so some older installations might break when this is changed but the
option is still there. Let applications that depend on this somewhat
magical behavior enable it rather than have everyone else potentially
run into the same problem as Philip.
Regards,
Thomas
). I consider that a very *bad* thing.
It's perhaps OK that the option exists so that old legacy system can
keep on running, but to have it enabled by default is not good at all.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 4: Don't 'kill
to do that using SQL?
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
? Is performance ok now :-)
This project might be perceived as a thirdparty add-on and thus, fail
its purpose. The steering committee must stand behind this officially.
Will you? What's your opinion about the suggestion?
Any ideas what the project should be named?
Regards,
Thomas Hallgren
distribution? No ...
The core server distribution is left untouched by all this.
It would be really nice if this project could publish packages using
your BitTorrent and ftp mirrors though.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 9
current employment however has no connection to PostgreSQL.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
to promote their own product. In so, we need to be
coordinated. Preferably by someone from within.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
supported with Cygwin on Windows).
On Linux, PL/Java 1.0.0.b4 includes binary distributions compiled using
GCJ (the GNU Java) to take full advantage of Postgres capability of
using preloaded modules.
Please visit http://gborg.postgresql.org/project/pljava for more info.
Regards,
Thomas Hallgren
a
better solution to replace the inferior one and to limit the number of
overlaps.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
. It would do PostgreSQL an awful lot of good if there where
supported configurations including replication, server side language
support (Perl, Tcl, Java, etc.), JDBC and ODCB drivers, and other things
that you'd normally find in commercial enterprise solutions.
Regards,
Thomas Hallgren
harmless callback mechanism
that can be called with a state enum denoting PreCommit, PostCommit,
PostAbort?
Kind regards,
Thomas Hallgren
---(end of broadcast)---
TIP 8: explain analyze is your friend
. The latter of course to
log the fact that a change has occured (for Commit issued) or to
prevent it from happening (all other handlers). I'm sure this
functionality is there already. I'd be happy to write a patch if someone
could point out where I find it.
Kind regards,
Thomas Hallgren
(OMG) would be smiling too if they read your
post. I wonder if they ever considered the more divine translation :-)
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe
. Is
there a proper way to test when the postmaster is ready to receive commands?
Kind regards,
Thomas Hallgren
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Hi,
I have not been able to connect to news.postgresql.org over the last couple
of days. I've tried from several locations/computers. Is anyone else having
the same problem?
Kind regards,
Thomas Hallgren
---(end of broadcast)---
TIP 9
80 matches
Mail list logo