rder to obtain 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?
http://www.postgresql.org/docs/faq
;s known to run well 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 th
. 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
messa
here is really that we keep finding reasons to, if not
flat-out change the interface to PLs, at least expand their
responsibilities. Not to push it too hard, but we still have only
one PL with a validator procedure, which IIRC was your own addition
to that API. How come they don't all have vali
compliant 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)
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 Hal
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
write 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
---(e
Ahh, 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)---
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
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)---
TIP 9: the planner will ignore your desire to choose an index scan if your
sense (to me at least) 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 use
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
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
7;s a lot of work 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 cont
e 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
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
ecome 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
e problem as Philip.
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 cleanly
iable settable in a session? If so, that would be good for the
purpose you mention.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
ed, errors might be
hidden (you get the notification that not everyone will pay attention
to, or even see). 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.
Regard
s than 2 tuples in it.
As I said before, I don't object to the presence of this "option" so
that people that really knows _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.
d.
Why confuse people with yet another syntax?
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
s of
PostgreSQL. That in turn 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
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 of
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 of
s and other optimizations.
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)---
d so
that it doesn't affect SELECT. And yes, this extension looks good.
Perhaps consider changing the second FROM to USING (mimicking MySQL
instead of MS SQL server). I think 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/FAQ.html
y
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
-
to a halt much faster than you can 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
e.
Ok now I do follow. 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
L over MySQL
because MySQL lacks some 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)---
switching time (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
-
with other processes and their threads.
A kernel scheduler might 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
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
;. One had a CC to the gmane
newsgroup. That one showed up. The other two had a CC 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 follow
l warnings which are much more handy to see...
Right. Useful "warnings"! Seems you agree that this should be a warning,
not a notice.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
; is disabled or changed so
that it doesn't affect SELECT. And yes, this extension looks good.
Perhaps consider changing the second FROM to USING (mimicking MySQL
instead of MS SQL server). I think it would lessen the risk of
introducing ambiguities in the parser (and it looks bett
state 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,
Thoma
PostgreSQL uses MVCC which brings the concurrent lock problem down to
a minimum, even for queries that are not read-only.
- Giving big queries a lot of resources is not the desired behavior in
many cases.
- Your scheduler is confined to one CPU and cannot react to the system
as a whole
ler 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)---
TIP 3: if p
that has no value, hence the
different syntax.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
ed with the minimum of 1 digit. It looks
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".
ng "wget " 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
-
id funcOid = fcinfo->flinfo->fn_oid;
...
}
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
unctions will always
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.
Rega
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 pl
Alvaro Herrera wrote:
On Sun, Feb 06, 2005 at 03:28:31PM +0100, Thomas Hallgren wrote:
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?
See src/ba
out
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
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
ch the data 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?
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 c
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 Hal
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.
Rega
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 impleme
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)-
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).
R
or 10) for Java on the desktop.
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
ound triggers"
doesn't make any sense. Triggers 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
uot;.
And what if fork-1) returns 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) re
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
TE, EXECUTE, or DECLARE statement". 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
ementation 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)--
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 v
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 th
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_rec
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
ere 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
ter the
(complete) process of committing or rolling back, and the ability to
track attempts to make a change to the database. 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 th
Management Group (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 appropriat
since that would break backward compatibility. If that's the case,
do you see a problem in introducing a more 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
tors like myself must be
given the opportunity to get things "verified" and checked in as
"supported". 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 dri
still
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 Hal
se, the
distribution should be kept at a reasonable size. That's why I'd like 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
with this. My 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
's
more people out there that would like to help? If not for any other
cause, then maybe 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
configurations.
My Concerns:
Who is behind PGFoundry? 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?
ical postgresql.tar.gz file that is
the core server 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 o
ay to do that using SQL?
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
82 matches
Mail list logo
