Kris Jurka wrote:
Thomas Hallgren wrote:
Kris Jurka wrote:
3) By value: pljava does not correctly handle passed by value types
correctly, allowing access to random memory.
This is simply not true. There's no way a Java developer can access
random memory through PL/Java.
No, the point
Kris Jurka wrote:
3) By value: pljava does not correctly handle passed by value types
correctly, allowing access to random memory.
This is simply not true. There's no way a Java developer can access
random memory through PL/Java.
- thomas
--
Sent via pgsql-hackers mailing list
Tom Lane wrote:
This is a non-issue in PL/Java. An integer parameter is never passed by
reference and there's no way the PL/Java user can get direct access to
backend memory.
So what exactly does happen when the user deliberately specifies wrong
typlen/typbyval/typalign info when
Tom Lane wrote:
Thomas Hallgren [EMAIL PROTECTED] writes:
Tom, could you please elaborate where you see a security hole?
The problem that we've seen in the past shows up when the user lies in
the CREATE TYPE command, specifying type representation properties that
are different from
It seems perfectly safe to me too for the reason that Kris mentions.
Tom, could you please elaborate where you see a security hole?
Regards,
Thomas Hallgren
Tom Lane wrote:
Kris Jurka [EMAIL PROTECTED] writes:
On Wed, 30 Jul 2008, Alvaro Herrera wrote:
I do agree that creating base
.
An implementation could be made to prevent clock-sequence collisions on the same machine and
thereby avoid this altogether.
Kind Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http
[EMAIL PROTECTED] wrote:
... I *like* sorting by time, as it allows
the UUID to be used similar to sequence, leaving older, lesser accessed
UUIDs in the past.
and don't forget, an automatic timestamp of when a record is created might be useful for
other purposes.
Regards,
Thomas Hallgren
and (NOT) IS NULL
4. GUID type must have the ability to be indexed, grouped, ordered,
DISTINCT... but not MAX(), MIN() or SUM()
Where do you see a need for LIKE on a GUID?
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 1: if posting/reading
no
sense to me.
Regards,
Thomas Hallgren
On Mon, 2006-09-18 at 10:06 +0200, Thomas Hallgren wrote:
Gevik Babakhani wrote:
To my opinion GUIDs type need to provide the following in the database.
1. GUID type must accept the correct string format(s), with of without
extra '-'
2. GUID type
. Although the magnitudes as such makes little sense, the ability to order will
make it possible to compare results from different queries etc. Very difficult to do with
random order.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 6: explain
of the
UUID's that the two that Gevik wants to support. Please note that UUID
is a very well known concept and not an arbitrary 128 bit storage.
http://en.wikipedia.org/wiki/UUID is a good source of information. The
appointed RFC actually contains source code.
Kind Regards,
Thomas Hallgren
' == 'milli') in GUC, it might be
good to use consistent units everywhere.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 6: explain analyze is your friend
in core or into one of its subsidiaries.
Kind Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
Andrew Dunstan wrote:
The topic here is NOT what features are missing from postgres.
Of course it is ;-)
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 6: explain analyze is your friend
in the impedance mismatch caused by concerns
that one must consider when using RPC (limit the number of calls) compared to the current
design (avoid copying and streaming).
Kind regards,
Thomas Hallgren
---(end of broadcast)---
TIP 5: don't forget
In essence the PostgreSQL SDK.
If I read what Thomas wrote (late) last night correctly.
You did.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan
we move the project files to pgfoundry
for hosting and set the project's home page as the wiki?
Yes, that sounds reasonable. I'll look into that. What I really would
like is to move the whole project (aside from the Wiki) from gborg to
pgfoundry.
Kind regards,
Thomas Hallgren
the
years ...
How would I go about taking advantage of that? And who did the 1.2.0
upload? I certainly didn't.
Kind Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org
it was not mirrored. And yes, I agree wholeheartedly, a wiki
is not the most intuitive place for downloads. Per Jonahs suggestion
I've just uploaded everything to pgfoundry too.
Thanks for uploading the 1.3.0 to the ftp.
Regards,
Thomas Hallgren
---(end of broadcast
to remove them. The Files section on
pgfoundry looks a lot better :-)
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
, make sure pg_ctl is in your path and type 'make
USE_GCJ=1 release'
Alternatively, set JAVA_HOME to appoint some other JRE and just type 'make
release'
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 5: don't forget to increase your free
don't have access to a FreeBSD machine so I can't try it.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
be
considered in the same light as PL/Java. Then again, I'm fairly biased ;-)
Regards,
Thomas Hallgren
Dave Cramer wrote:
Absolutely PL/J should be considered in the same light as PL/Java.
Consider this a request for PL/J to be included in the core.
Dave
On 11-Jul-06, at 12:50 PM, Josh Berkus
for various reasons, the number of hackers in the community will grow
as well. PL/Java for instance, does not come without resources :-)
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire
place to start. I.e. divide
headers into the ones available for external modules and the ones for
internal backend use only.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http
have happened that
would be interesting to look at.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
statement is completely false.
Dave,
What JVM requirements does PL/J currently have? What license implications are imposed by the
components that it depends upon?
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 4: Have you searched our list
there are other more subtle ways to get the message through.
I'm trying to be honest and up-front. IMO, that should count for something.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http
Tom Lane wrote:
Thomas Hallgren [EMAIL PROTECTED] writes:
Why to you persist talking about licensing issues with PL/Java? There are none. PL/Java
builds and runs just fine with gcj and the above statement is completely false.
Um ... if you use it with gcj, there may or may not be any
. It would take me
30 minutes or so to create a substitute BSD licensed dummy JNI library
with associated headers that would allow PL/Java to be built without any
external modules at all. It's then completely up to the user what he/she
wants to slot in as a replacement.
Regards,
Thomas Hallgren
of the issues.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
choose a JVM from IBM, Sun, BEA, or
other (like GCJ) to run. That's the essence of having a standardized
API. What can possibly be 'grey' about that?
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
must either support GCJ 4.0 or higher or have a Java
Runtime Environment 1.4.2 or higher installed.
Regards,
Thomas Hallgren
Bruce Momjian wrote:
There are roughly three weeks left until the feature freeze on August 1.
If people are working on items, they should be announced before August
1
at a time.
...
(from the top of my head, there are probably more reasons)
IMHO, this is yet another reason to actually include it in core. I'm not
an expert on the other PL's but my guess is that PL/Java is far more
sensitive to API changes in the backend core.
Regards,
Thomas Hallgren
. The good news in my opinion is that if PL/Java would make it to
the core it could make a good reference implementation for other equally
advanced language mappings.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 9: In versions below 8.0
in pgfoundry/contrib.
I second that.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
,
Thomas Hallgren
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
.
One requirement would be that it runs on Windows. Is that something you have
tested?
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
out of the box.
The actual type would be extremely generic, lightweight, and easy to implement. No
portability issues whatsoever. The only difficulty that I see is naming it :-).
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 4: Have you
indexes, all foreign keys, etc. In a normalized database some tables
may consist of UUID columns only.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan
Martijn van Oosterhout wrote:
On Thu, Jun 29, 2006 at 03:54:36PM +0200, Thomas Hallgren wrote:
I have to concur with this. Assume you use a bytea for a UUID that in
turn is used as a primary key. The extra overhead will be reflected in
all indexes, all foreign keys, etc. In a normalized
Martijn van Oosterhout wrote:
On Wed, Jun 28, 2006 at 01:56:47PM +0200, Thomas Hallgren wrote:
A user that is trusted with installing a C-function in the backend is
free to scan the process memory anyway so in what way did that increase
the security? IMHO, the only relevant security
should I look for when trying
to find the cause of such warnings?
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
behavior?
Regards,
Thomas Hallgren
Original Message
Subject: Re: [Pljava-dev] char with trailing space,
PreparedStatement.setObject SetString
Date: Tue, 27 Jun 2006 12:07:19 -0400
From: JEAN-PIERRE PELLETIER [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
CC: [EMAIL
Sorry, wrong list... I reposted this on pgsql-jdbc instead.
---(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
this once and for all?
Another related question. What happens when I use --without-zlib? Does
it have any effect on besides disabling compression for the dump/restore
utilities? Is there anyway to make it affect the backend only?
Kind Regards,
Thomas Hallgren
---(end
That's good news. Any chance of getting this fix backported to 8.1? Or
at least, the libz part of it?
Regards,
Thomas Hallgren
Martijn van Oosterhout wrote:
On Fri, Jun 23, 2006 at 10:45:29AM +0200, Thomas Hallgren wrote:
There was a discussion some time back concerning the linking
help. I didn't think it would since I am able to
create a database in this directory if I'm using version 8.1.4.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
... ok
creating template1 database in data/base/1 ... ok
initializing pg_authid ... child process was terminated by signal 5
initdb: removing contents of data directory data
Thomas Hallgren wrote:
I just compiled a fresh copy from CVS head. I then tried to do an initdb
as user 'postgres' (non
Never mind. I scrubbed my folders and obtained a new fresh copy from CVS. Now
it works.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 6: explain analyze is your friend
?
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Tom Lane wrote:
No, each major release (8.2, 8.3, etc). There are hardly ever any major
releases where you wouldn't need a new compilation anyway ...
True. I'm all in favor of a magic used this way. It will save me some grief.
Regards,
Thomas Hallgren
---(end
could agree on a GUC flag (or flags) that would control debugging
for all PL's. At present, all PL implementors must use their own (module specific) flags.
Kind regards,
Thomas Hallgren
---(end of broadcast)---
TIP 5: don't forget to increase your
and hooking into the executor sounds really interesting and something that
would really be worth the effort. I doubt there's a gain mixing that with debugging of pl's
in general. Having multiple debugger clients, one for each language, and one for SQL, might
be a good thing.
Regards,
Thomas Hallgren
was designed to take a significant performance hit when that happens. Especially if a viable
alternative exists.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 6: explain analyze is your friend
, Python, and PHP all have a similar solution and thus have no
benefit from additions to the FE/BE protocol. IMO, debugging should be language specific and
take place in a separate channel. There's no gain whatsoever mixing it with the FE/BE protocol.
Regards,
Thomas Hallgren
Tom Lane wrote:
Thomas Hallgren [EMAIL PROTECTED] writes:
I think this is a bad idea. PL/Java will use either shared memory or a
socket to attach and as you already mentioned, when using C, a gdb
will attach directly using the pid. I wouldn't be too surprised if
Perl, Python, and PHP all have
stable
during patch releases.
Having said that, I've been in the game long enough to know that Utopia
doesn't exist. You probably had a very good reason to break the
compatibility.
Kind Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 5
two
real Portal instances, the PL/Java implementation would take minutes.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 6: explain analyze is your friend
, they will.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
}'::varchar[])::varchar;
ERROR: cannot cast type cstring to character varying
ISTM, the implementation of such casts should be fairly simple and
straight forward and sometimes even useful. Every data type comes with
string coercion routines anyway right?
Regards,
Thomas Hallgren
Martijn van Oosterhout wrote:
On Thu, May 18, 2006 at 05:41:14PM +0200, Thomas Hallgren wrote:
Just out of curiosity (and most likely, ignorance). Why can't I cast an
array of strings into a string? I.e.
thhal=# select ('{a,b}'::varchar[])::varchar;
ERROR: cannot cast type character
they would become completely invisible. No one could even
tell that the date was invalid to start with.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail
Lukas Smith wrote:
.. but spouting outdated FUD is really making you two look foolish.
Wow. On a scale from 1 to 10 measuring seriousness, I'd put my posting on -4. I'd advice you
to take a step back and get some distance if you consider it outdated FUD.
Regards,
Thomas Hallgren
the non standard
MySQL specific expressions. The objective being to at some point skip the MySQL syntax layer
altogether.
Regards,
Thomas Hallgren
(dead serious this time)
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ
not the most efficient way of doing it but it works.
Regards,
Thomas Hallgren
Gurjeet Singh wrote:
Do we have any plans of introducing 'AUTONOMOUS TRANSACTION' like
feature?
Again, it might not be a part of the standard but it is very
helpful in situations like these!!! You can run
,
because it'd fundamentally break the lexical structure of the language.
+1
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
I just discovered that it is now possible to create a SHELL type using
the 'CREATE TYPE type name' syntax using cvs head. Will this come in
8.2 only or will it also be included in 8.1.4?
Kind Regards,
Thomas Hallgren
---(end of broadcast
(i.e. SELECT FROM instead of SELECT FROM ONLY).
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
with it is more a 'type' thing then a 'table' thing in my
world. A view is then used to _map_ the types to persistent storage, i.e. the 'tables'.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 6: explain analyze is your friend
'
and 'anyelement'? The only thing I can think of is if 'anyelement' was
restricted to non-arrays, but apparently it isn't. I've tried and
there's nothing stopping me from passing an 'int[]' to a function that
takes an 'anyelement'.
Regards,
Thomas Hallgren
---(end of broadcast
Tom Lane wrote:
Thomas Hallgren [EMAIL PROTECTED] writes:
- Why does PostgreSQL declare three different generic types? Isn't one
enough? ISTM it would be far simpler to use constructs like 'any' and
'any[]' but neither of them are permitted.
any isn't the same as anyelement, because
]
(1 row)
IMO, there is something seriously wrong here. Clearly the number of
dimensions is a property of the type. Any array with a different number
of dimensions should yield an error or at least be coerced into the
right number of dimensions.
Kind Regards,
Thomas Hallgren
in the arrays. Perhaps now is the time to improve the type semantics as
well?
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
Tom Lane wrote:
Thomas Hallgren [EMAIL PROTECTED] writes:
Would it be hard to enforce a real check? The implementation could use
GUC settings like 'enforce_array_dimensions' and 'enforce_array_lengths'
that could be set to false for the legacy implementations that rely on
the current
Martijn van Oosterhout wrote:
On Mon, May 08, 2006 at 07:31:14PM +0200, Thomas Hallgren wrote:
Would it be hard to enforce a real check? The implementation could use
GUC settings like 'enforce_array_dimensions' and 'enforce_array_lengths'
that could be set to false for the legacy
that what you and others are trying to accomplish is very valuable. If not
for me (since I'm mixing Java and C and work on multiple platforms) then certainly for many
others. Personally, I'd rather see a Visual Studio port than one for VC++6.0. I wish you the
best of luck.
Regards,
Thomas
David Fetter wrote:
On Thu, May 04, 2006 at 09:02:02PM +0200, Thomas Hallgren wrote:
Tom Lane wrote:
Why can PLs not handle pseudo-types?
No one's done the work to figure out which ones are sensible to
support and then add the logic needed to support them.
PL/Java
to invalidate the associated
structure of all java functions due to reload of jar files. Is there any
way that I can list all functions for a specific language and get hold
of their current setting of the fn_extra?
Regards,
Thomas Hallgren
---(end of broadcast
this helps,
Yes, the intarray stuff was very helpful but also somewhat confusing.
Why are there two ways of representing some of the array types? I mean,
why is there an _int4 when you could just as well write int4[]? I'm
probably missing the point altogether.
Regards,
Thomas Hallgren
to be easy, but I am sure with this great
community suppport, we sure can achieve it.
Seems some people has done a lot of work to get things working with VC++ already. Search for
the word MSVC on this list.
Regards,
Thomas Hallgren
---(end of broadcast
for PL/Java and it would be easy to add support for more pseudo
types too. But what others would make sense?
Kind Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe
.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 1: 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
to the current setting of search_path in case the name is
unqualified)?
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
Martijn van Oosterhout wrote:
On Sun, Apr 30, 2006 at 12:50:23PM +0200, Thomas Hallgren wrote:
I'm writing a UDT that takes a varchar argument that represents the name
of a type. The caller may optionally qualify with a namespace, i.e.
pg_catalog.varchar, or public.address. Is there a c
I'm having problems with crashes whenever I attempt to write something
on stdout or stderr from a UDT whenever the postmaster is running as a
windows service. Not sure what I'm doing wrong. Is this a known problem?
Regards,
Thomas Hallgren
---(end of broadcast
easier if you have access to an XML viewer.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
non trustworthy people get so far as to
create their own SQL statements, you're in big trouble. Plpgsql or not. I fail to see what
the real issue is here. Your argument is analog to saying don't install bash on a Linux
system by default. People might do bad things with it.
Regards,
Thomas
Jim C. Nasby wrote:
On Sat, Apr 01, 2006 at 05:42:34PM +0200, Thomas Hallgren wrote:
Why not simply a fixed number of bytes, i.e. byte(16) or octet(16)?
Hexadecimal is just a convenient human-readable representation.
Well, hex is much easier to deal with in many regards than raw bytes
into the Java domain
in order to make the changes in the respective PL minimal.
Opinions? Suggestions?
Kind Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
number of bytes, i.e. byte(16) or octet(16)? Hexadecimal is just a
convenient human-readable representation.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail
Andrew Dunstan wrote:
and a happy April 1 to you too, btw.
;-)
- thomas
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
into the database instead of keeping
it in the middle tier is often done to get rid of the last hurdle, the overhead of IPC.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http
Tom Lane wrote:
Thomas Hallgren [EMAIL PROTECTED] writes:
This FENCED/NOT FENCED terminology would be a good way to
differentiate between the two approaches. Any chance of that syntax
making it into the PostgreSQL grammar, should the need arise?
Of what value would it be to have
to Windows. Lazslo filed a JIRA bug on that but
since then (August last year) I've seen no activity in the project. Is
it still alive? Is anyone using it?
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 4: Have you searched our list archives
. If the same thing happens
using an in-process JVM, the problem is isolated to that one session.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL
thinks
about this.
Kind Regards,
Thomas Hallgren
Martijn van Oosterhout wrote:
On Fri, Mar 24, 2006 at 11:51:30AM +0100, Thomas Hallgren wrote:
Hi,
I'm currently investigating the feasibility of an alternative PL/Java
implementation that would use shared memory to communicate between a JVM
Martijn van Oosterhout wrote:
On Mon, Mar 27, 2006 at 10:57:21AM +0200, Thomas Hallgren wrote:
Martijn,
I tried a Socket approach. Using the new IO stuff that arrived with Java
1.4 (SocketChannel etc.), the performance is really good. Especially on
Linux where an SMP machine show a 1 to 1.5
advantages at all. Paying for nothing with a 440% increase in
calling time (at best) seems expensive :-)
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan
Tom Lane wrote:
Thomas Hallgren [EMAIL PROTECTED] writes:
Tom Lane wrote:
It's only that much difference? Given all the other advantages of
separating the JVM from the backends, I'd say you should gladly pay
that price.
If I'm right, and the most common scenario is clients
1 - 100 of 437 matches
Mail list logo
