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 poi
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 (pgsql-hack
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 creati
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 dif
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 cr
of 100 nanosec.
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?
. 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
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.
, LIKE 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 posti
[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 Hal
. I've never seen any other representation 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 actuall
though I don't expect to see bit-rates or fractions ('m' == '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
third-party modules and serving as an
incubator for modules that aim to be included 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
s). I
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 PROTECTE
source tarball, 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:
g there.
Unfortunately, there's no way 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
ss
that's why 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
-
over 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?
but could 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 rega
QL headers
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
lenge lays 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: do
r may 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
d also resolve a some of the issues.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
FSF indeed did remove the exception. 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
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
I'm sure 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?
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
must 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
be a good 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?
we don't, really.
As the project grows 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
hen you say PL/J could 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-Ju
even then I have some
doubts. 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)-
end is never
exposed to more then one thread 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
latforms where PL/Java is ported 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
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
e. just add a 16 byte data type and forget all
about UUID's for now.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
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
in
all 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
ava clients).
Some PL's will also enable such packages 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 o
ndry, and at some point give it up for inclusion into
PostgreSQL.
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
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 in that
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
rrect 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]
here. What 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
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 o
ed to
fix 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
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
figuration files ... 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
parent directory so that user 'postgres' has full
control. It doesn't 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
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
determined?
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
very useful. KISS principle.
It would be great if we 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)
n the toes of the existing stats process...
SQL debugging 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,
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 P
be too surprised if Perl, 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 proto
s 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
two
real Portal instances, the PL/Java implementation would take minutes.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 6: explain analyze is your friend
le. API's should remain 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
-
ther way. Once it becomes "just as imporant", they will.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
that PostgreSQL is lacking.
3. A good user guide that helps the user to, over time, move away from 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)
---
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".
Rega
? That way 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
subscr
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;
.e.
thhal=# select array_out('{"a","b"}'::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
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
psql,
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 joinin
Josh,
I'm the lead architect of the Eclipse Buckminster project
(www.eclipse.org/buckminster). I'd be happy to help the guys from data
tools with PostgreSQL if there's anything I can do. Not sure what that
would be though. Which Mike is it you're referring to?
Rega
that changes (i.e. SELECT FROM instead of SELECT FROM ONLY).
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
I just discovered that it is now possible to create a SHELL type using
the 'CREATE TYPE ' 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)---
ink that is a better solution.
Inheritance and all that comes 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
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.
&quo
never I try
to use it. If I could use it, what would be the difference between 'any'
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 pa
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
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
Tom added the ability to have NULL values
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
ray_dims
-
[1:2][1:2][1:3]
(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 o
s not by
any means "left alone".
I really think 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
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 Hal
when I need 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
---(e
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
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 broa
tation 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
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.ad
ame
(with respect 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
cated.
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
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
Why not go all the way. Here's the above using Satoshi's suggestion:
Easy to copy/paste and whitespace doesn't matter. Easy to read (well, to some at least) and
can be even easier if you have access to an XML viewer.
Regards,
Thomas Hallgren
--
say that if let 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 thin
Hear hear ;-)
Regards,
Thomas Hallgren
Andrew Dunstan wrote:
Jonah H. Harris wrote:
On 4/6/06, Qingqing Zhou <[EMAIL PROTECTED]> wrote:
I have written some experimental code of doing master-slave seqscan in
PostgreSQL. During the work, I feel we had enough infrastructure to
s
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
Andrew Dunstan wrote:
and a happy April 1 to you too, btw.
;-)
- thomas
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
y not simply a fixed 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
s used by say,
PL/Perl could probably be implemented as callbacks 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
w scheduling prio. 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
7;t ported 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 ou
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 h
etwork overhead
between the middle tier and the backend. Moving logic 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)--
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 commo
at you don't get any 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
1 - 100 of 446 matches
Mail list logo
