[HACKERS] pljava revisited

2003-12-10 Thread Thomas Hallgren
connection. Some things will be limited (begin/commit etc. will not be possible to do here for instance). Current status is that my first calls from Postgres to Java has been made. Lot's of work remain. What are your thoughts and ideas? Thomas Hallgren ---(end of broadcast

Re: [HACKERS] pljava revisited

2003-12-10 Thread Thomas Hallgren
The JVM will be started on-demand. Although I realize that one JVM per connection will consume a fair amount of resources, I still think it is the best solution. The description of this system must of course make it very clear that this is what happens and ultimately provide the means of tuning

Re: [HACKERS] pljava revisited

2003-12-10 Thread Thomas Hallgren
Two comments. Context switches are of course much cheaper then loading a JVM. No argument there. The point is that the JVM is loaded once for each connection (when the connection makes the first call to a java function). Millions of calls may follow that reuses the same JVM. Each of those calls

Re: [HACKERS] PostgreSQL port to pure Java?

2003-12-11 Thread Thomas Hallgren
My 2 cents... The C++ language is a horrible language from an OO perspective. Operator overloading, copy-constructors, templates, etc. can produce quite horrendous and inefficient results if used incorrectly. Having said that I must defend it some too. Using C++, you get inheritance,

Re: [HACKERS] pljava revisited

2003-12-12 Thread Thomas Hallgren
Eisentraut [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Andrew Dunstan wrote: Peter Eisentraut wrote: Thomas Hallgren wrote: What are your thoughts and ideas? Instead of making up your own stuff, there's a whole SQL standard that tells you how Java embedded in an SQL

[HACKERS] Need a good .

2003-12-17 Thread Thomas Hallgren
100 entries and performance will be an issue. I'm sure something like this exists in postgres but I haven't been able to find it. Please point me in the right direction. Thanks, Thomas Hallgren ---(end of broadcast)--- TIP 6: Have you searched

Re: [HACKERS] PostgreSQL port to pure Java?

2003-12-26 Thread Thomas Hallgren
hard to write and maintain using plain C. A language with built-in support for OO semantics can be of great help. IMO it's better to keep an open mind regarding the future and the potential languages that might be used than to make remarks like the one Mr. Poure just made. Thomas Hallgren Jean

Re: [HACKERS] PL/Java issues

2004-01-04 Thread Thomas Hallgren
I'm working on a pl/java project and have come quite far with it. Triggers and Functions are both callable, there's support for complex types etc. I have a project on GBorg (pljava) where I'll post all source in a CVS repository in a matter of days (the code is ready but my ISP have a router

Re: [HACKERS] [JDBC] PL/Java issues

2004-01-04 Thread Thomas Hallgren
I think much of the issues should be resolved using JDBC and java.sql.ResultSet and a couple of interfaces that can be used when mapping specific types to specific Java objects (SQLData, SQLReader/SQLWriter). A PL/Java needs a hook where a connection is initialized for JDBC access in the backend.

[HACKERS] First release of Pl/Java now on Gborg

2004-01-07 Thread Thomas Hallgren
I just posted my initial release of the Pl/Java stuff on Gborg. The pljava project is under Postgres tools - Drivers/Interfaces. Read the org.postgresql.pljava/readme.htm (you find it using the CVS view) for more info. ---(end of broadcast)--- TIP

[HACKERS] Request for additional SPI functions.

2004-01-12 Thread Thomas Hallgren
; } return ((_SPI_plan*)plan)-argtypes[argIndex]; } Regards, Thomas Hallgren ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[HACKERS] Question regarding pfree and thread safety.

2004-01-16 Thread Thomas Hallgren
Is it safe to call pfree() from multiple threads? My Java backend will need to utilize finalizers. Objects like a saved execution plan that has been forgotten must be released when the wrapping Java object is finalized to avoid memory leaks. The finalizer is called from the garbage collector

Re: [HACKERS] Question regarding pfree and thread safety.

2004-01-16 Thread Thomas Hallgren
appreciate any comments on it very much. Regards, - thomas Tom Lane [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Thomas Hallgren [EMAIL PROTECTED] writes: Is it safe to call pfree() from multiple threads? There are no multiple threads in the backend, and no provision whatever

[HACKERS] SPI_prepare and error recovery

2004-01-19 Thread Thomas Hallgren
to be? Regards, Thomas Hallgren ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [HACKERS] SPI_prepare and error recovery

2004-01-19 Thread Thomas Hallgren
. IMO, that should be doable without nested transactions. Regards, Thomas Hallgren Tom Lane [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Thomas Hallgren [EMAIL PROTECTED] writes: My question is, at the point of /* Handle error here */, how do I get hold of the error information

[HACKERS] Dynamic modules and standard naming practice

2004-01-22 Thread Thomas Hallgren
system. Consequently, I have to use libpljava to reference the module in SQL while I use pljava for the same module in Java. It would be very nice if PostgreSQL could make an attempt to first prepend the lib and if that doesn't work, try without the prefix on a Unix system. Regards, Thomas Hallgren

[HACKERS] Functions returning complex types.

2004-01-26 Thread Thomas Hallgren
I'm trying to use a function that returns a complex type. I have no problem creating the function but when I try to use it I get the message: ERROR: function in FROM has unsupported return type Apparently, this message stems from the parser. Changing the function so that it returns a SETOF the

Re: [HACKERS] Functions returning complex types.

2004-01-26 Thread Thomas Hallgren
call). AFAICS, the way I do it is by the book. What am I doing wrong? Regards, Thomas Hallgren Tom Lane [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Thomas Hallgren [EMAIL PROTECTED] writes: I'm trying to use a function that returns a complex type. I have no problem creating

Re: [HACKERS] Functions returning complex types.

2004-01-26 Thread Thomas Hallgren
to TypeGetTupleDesc, then everything works just fine. I still suspect that something is broken with the calling mechanism. At least for languages that do not compile the stuff into permanent structures prior to evaluating. Regards, Thomas Hallgren Tom Lane [EMAIL PROTECTED] wrote in message news:[EMAIL

[HACKERS] Pl/Java 1.0.0.b now avaiable on Linux 386 and Cygwin

2004-01-27 Thread Thomas Hallgren
a look at the readme file and the user guide. http://gborg.postgresql.org/project/pljava/genpage.php?readme http://gborg.postgresql.org/project/pljava/genpage.php?userguide Regards, Thomas Hallgren ---(end of broadcast)--- TIP 1: subscribe

[HACKERS] Transaction callback

2004-01-31 Thread Thomas Hallgren
established. Is that possible today? If so, how do I register the function to be called? Regards, Thomas Hallgren ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [HACKERS] Transaction callback

2004-01-31 Thread Thomas Hallgren
things that it's not supposed to (like changing things). That's part of my original question really, how hard is it to implement?. Regards, Thomas Hallgren David Helgason [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On 31. jan 2004, at 18:53, Tom Lane wrote: Thomas Hallgren [EMAIL

Re: [HACKERS] Transaction callback

2004-01-31 Thread Thomas Hallgren
I don't want to kludge up a 2-phase commit support. Any attempt to provide that must be extremely well thought through :-) But I would like to know more about PostgreSQL capabilities in the area. What kind of XA-support is there? Can I read about this somewhere? (I'm working on an Open Source

[HACKERS] Advice regarding configuration parameters

2004-02-06 Thread Thomas Hallgren
to starting the JVM) 4. Some other place that is obvious but not currently known to me Thanks, 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

Re: [HACKERS] session persistent data for plperl

2004-02-08 Thread Thomas Hallgren
What about transactions? Let's say the first call was in a transaction that's been rolled back. Semantically, that means the call never happened. If you maintain the session data in a table, everything is fine of course. But if it's in memory the solution has some rather nasty implications to it.

Re: [HACKERS] session persistent data for plperl

2004-02-08 Thread Thomas Hallgren
Lane [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Thomas Hallgren [EMAIL PROTECTED] writes: Andrew Dunstan [EMAIL PROTECTED] wrote: The attached tiny patch (not intended for application yet) provides a space for plperl functions to create and share session persistent data, What

Re: [HACKERS] Request for additional SPI functions.

2004-02-12 Thread Thomas Hallgren
) { Query* queryTree = (Query*)lfirst((List*)lfirst(qtlist)); if(queryTree-commandType == CMD_SELECT queryTree-into == NULL) return true; } return false; } Regards, Thomas Hallgren - Original Message - From: Bruce Momjian [EMAIL PROTECTED] To: Thomas Hallgren [EMAIL PROTECTED] Cc

Re: [HACKERS] Advice regarding configuration parameters

2004-02-19 Thread Thomas Hallgren
No, this was not related to triggers at all. The original discussion concerned GUC functionality to handle configuration settings for pllang extensions. - thomas - Original Message - From: Bruce Momjian [EMAIL PROTECTED] To: Joe Conway [EMAIL PROTECTED] Cc: Thomas Hallgren [EMAIL

[HACKERS] Pl/Java - next step?

2004-02-21 Thread Thomas Hallgren
steps? Setting up benchmarking and test performance perhaps? Should not be done my me, nor by the people behind the Pl/Java_remote, but rather by someone who is truly objective. Kind regards Thomas Hallgren ---(end of broadcast)--- TIP 8: explain

Re: [HACKERS] Pl/Java - next step?

2004-02-21 Thread Thomas Hallgren
, that's great. If we can collaborate around one of the solutions, that's perhaps even better, at least from a developer resource perspective. Regards, Thomas Hallgren ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister

Re: [HACKERS] Pl/Java - next step?

2004-02-22 Thread Thomas Hallgren
), or not communicate at all (calculations, etc.). Regards, Thomas Hallgren ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [HACKERS] Pl/Java - next step?

2004-02-22 Thread Thomas Hallgren
there that can be used, with little or no effort, is enough to motivate my statement. Regards, Thomas Hallgren ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [HACKERS] Pl/Java - next step?

2004-02-23 Thread Thomas Hallgren
should be able to use. It comes with JNI (and what they claim a much faster alternative). I'm currently looking into what's needed in order to use GCJ for Pl/Java_JNI. Regards, Thomas Hallgren ---(end of broadcast)--- TIP 7: don't forget

Re: [HACKERS] Pl/Java - next step?

2004-02-23 Thread Thomas Hallgren
for both designs. We have different objectives. You strive to minimize the number of RPC calls. I strive to minimize call overhead and resource consumption. You probably have more ideas so please add to this. Please confirm the time and tell me where we meet (what IRC). Regards, Thomas Hallgren

Re: [HACKERS] Pl/Java - next step?

2004-02-23 Thread Thomas Hallgren
it comes to all Java code used to administer each solution, but not in C-code. Regards, Thomas Hallgren ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] Server Side PL support

2004-03-01 Thread Thomas Hallgren
will expect the standard name. Regards, Thomas Hallgren Andrew Dunstan [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Yes. I am looking at a few of these things (preloading, intra-perl calling, array and tuple return), and I understand that CommandPrompt is doing some plperl work too

[HACKERS] Minutes from Pl/Java - next step IRC

2004-03-04 Thread Thomas Hallgren
Participants Dave Cramer Thomas Hallgren Laszlo Hornyak Throughout this document, the solutions are called Pl/J (using remote calls and one JVM) and Pl/Java (using one JVM per connection). 1. Common interfaces. Laszlo provided Thomas with an URL so that he could download their solution. We

[HACKERS] GUC variable set, TODO

2004-04-19 Thread Thomas Hallgren
) Implement and submit a patch Any advice is greatly appreciated. Especially the ones that might speed up step #1. Comments, suggestions? Regards, Thomas Hallgren ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] GUC variable set, TODO

2004-04-19 Thread Thomas Hallgren
://archives.postgresql.org/pgsql-hackers/2004-02/msg00229.php Kind 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

[HACKERS] Pl/Java and GCJ

2004-04-21 Thread Thomas Hallgren
://gborg.postgresql.org/project/pljava Kind Regards, Thomas Hallgren ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [HACKERS] GUC variable set, TODO

2004-04-22 Thread Thomas Hallgren
. At that time, no placeholders should remain for the class that the module uses. Comments or suggestions so far? Kind regards, Thomas Hallgren Tom Lane [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Fabien COELHO [EMAIL PROTECTED] writes: Ok. I understand that you suggest to Thomas

[HACKERS] GUC custom variables

2004-04-24 Thread Thomas Hallgren
to assert that no 'stray' variables persists after the definition. Where to I put the documentation? A comment for each method, sure, but shouldn't there be some sgml for this somewhere? Kind regards, Thomas Hallgren ---(end of broadcast)--- TIP

Re: [HACKERS] Module dependency on PostgeSQL version

2004-05-11 Thread Thomas Hallgren
Tom Lane wrote: Thomas Hallgren [EMAIL PROTECTED] writes: The PGSQL_MAJOR_VER and PGSQL_MINOR_VER does not exist today. Ideally, I'd like to find them in src/Makefile.global. Only thing present seems to be the VERSION. I'd like to see something like: PGSQL_MAJOR_VER := 7 PGSQL_MINOR_VER := 5

Re: [HACKERS] Module dependency on PostgeSQL version

2004-05-12 Thread Thomas Hallgren
a while back (concerning loss of MemoryContext between function ivocations). My workaround was really ugly (using the parent MemoryContext) and could potentially waste a lot of memory so it was imperative to actually get rid of it as soon as the patch was released. regards, Thomas Hallgren

Re: [HACKERS] Module dependency on PostgeSQL version

2004-05-12 Thread Thomas Hallgren
. I'll try and use that to overcome differences in patch levels. Thanks, Thomas Hallgren ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [HACKERS] Advice regarding configuration parameters

2004-05-11 Thread Thomas Hallgren
once the module loads. Since a warning mechanism is in place already I felt that such an implementation would be overkill. Kind regards, Thomas Hallgren ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[HACKERS] Module dependency on PostgeSQL version

2004-05-11 Thread Thomas Hallgren
) is to invent something ugly to split the current VERSION variable. Considering ease of extension of PostgreSQL, I wanted to suggest this first. Kind regards, Thomas Hallgren ---(end of broadcast)--- TIP 9: the planner will ignore your desire

[HACKERS] SPI_fnumber is case sensitive

2004-05-06 Thread Thomas Hallgren
. Which one is better? Regards, Thomas Hallgren ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] SPI_fnumber is case sensitive

2004-05-06 Thread Thomas Hallgren
Didn't think you'd ever get such a result. Using JDBC (wich has similar functionality), you don't need to worry about case on identifiers. regards, Thomas Hallgren - Original Message - From: Tom Lane [EMAIL PROTECTED] To: Thomas Hallgren [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent

[HACKERS] Makefile.shlib functionality on win32

2004-05-06 Thread Thomas Hallgren
that could be accepted? 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

Re: [HACKERS] 7.5 features

2004-04-30 Thread Thomas Hallgren
course. A patch fixing those problems have already been submitted by Claudio Natoli. Perhaps you already knew that. Kind regards, Thomas Hallgren ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate

Re: [HACKERS] add server include files to default installation?

2004-05-16 Thread Thomas Hallgren
installation you must also include the src/Makefile.global and the src/Makefile.shlib. Cygwin ports are dependent on the presence of src/utils/dllinit.c also (perhaps true for win32 too). A dllinit.o would be sufficient of course. Kind regards, Thomas Hallgren ---(end

Re: [HACKERS] Usability, MySQL, Postgresql.org, gborg, contrib, etc.

2004-04-26 Thread Thomas Hallgren
of such semantics, I dare say that the installation is pretty slick anyway. Read this and comment http://gborg.postgresql.org/project/pljava/genpage.php?readme. Kind Regards, Thomas Hallgren ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ

Re: [HACKERS] Usability, MySQL, Postgresql.org, gborg, contrib, etc.

2004-04-26 Thread Thomas Hallgren
community, I'm pretty sure the platform independent parts of it would see the light of day pretty quickly. Kind regards, Thomas Hallgren ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail

Re: [HACKERS] Usability, MySQL, Postgresql.org, gborg, contrib, etc.

2004-04-27 Thread Thomas Hallgren
additions to) a common architecture if it would help PostgreSQL to get a wider acceptance. In short, You have a great leverage. It's just a matter of using it the right way. Kind regards, Thomas Hallgren Peter Eisentraut [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] [EMAIL PROTECTED

Re: [HACKERS] Pl/Java and GCJ

2004-04-27 Thread Thomas Hallgren
Bruce Momjian [EMAIL PROTECTED] wrote in message It seems this would be handled just like we handle C functions today, that is you create a shared object file, it sits in the file system, and you LOAD the object into your backend, or you record it via CREATE FUNCTION and specify the pathname.

Re: [HACKERS] Usability, MySQL, Postgresql.org, gborg, contrib, etc.

2004-04-27 Thread Thomas Hallgren
running. Kind regards, Thomas Hallgren scott.marlowe [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On Tue, 27 Apr 2004, Jochem van Dieten wrote: [EMAIL PROTECTED] wrote: (5) Programming languages. We need to make a programming language standard in PostgreSQL. plpgsql is good

Re: [HACKERS] Advice regarding configuration parameters

2004-04-28 Thread Thomas Hallgren
Patch posted on the patches list :-) Let me know what you think. - thomas Joe Conway [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Thomas Hallgren wrote: Some very good suggestions where made here. What happens next? Will this end up in a TODO list where someone can claim

Re: [HACKERS] Table Spaces

2004-05-17 Thread Thomas Hallgren
be found here http://www.sysinternals.com/ntw2k/source/misc.shtml#junction I use this tool myself. Works like a charm. Kind regards, Thomas Hallgren ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] add server include files to default installation?

2004-05-18 Thread Thomas Hallgren
is missing in the contract between the backend and the extension module and should be rectified there. The contract, the way I see it, is constituted by the two files. Just trying to give you a bit more freedom to place your files :-) Kind regards, Thomas Hallgren ---(end

Re: [HACKERS] add server include files to default installation?

2004-05-19 Thread Thomas Hallgren
the build API. If they don't use it, any incompatibility is their responsability. Your suggestion to rewrite the Makefile.global etc. is a good first step. Kind regards, Thomas Hallgren ---(end of broadcast)--- TIP 7: don't forget to increase your free

[HACKERS] dynamic_library_path on Win32

2004-05-29 Thread Thomas Hallgren
path I added a trace to find out what it thinks the path is. It prints C. Obviously it treats ':' as a path separator somewhere. Is that the intended behavior on win32? Kind regards, Thomas Hallgren ---(end of broadcast)--- TIP 4: Don't 'kill -9

Re: [HACKERS] dynamic_library_path on Win32

2004-05-29 Thread Thomas Hallgren
Yes, on windows, you use a semicolon as path separator. regards, - thomas - Original Message - From: Tom Lane [EMAIL PROTECTED] To: Thomas Hallgren [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, May 29, 2004 17:20 Subject: Re: [HACKERS] dynamic_library_path on Win32 Thomas

Re: [HACKERS] Advice regarding configuration parameters

2004-06-05 Thread Thomas Hallgren
Some very good suggestions where made here. What happens next? Will this end up in a TODO list where someone can claim the task (I'm trying to learn how the process works) ? Kind regards, Thomas Hallgren - Original Message - From: Tom Lane [EMAIL PROTECTED] To: Joe Conway [EMAIL

Re: [HACKERS] I/O support for composite types

2004-06-05 Thread Thomas Hallgren
, Thomas Hallgren ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] I/O support for composite types

2004-06-05 Thread Thomas Hallgren
Tom Lane wrote: Thomas Hallgren [EMAIL PROTECTED] writes: Why not use standard C semantics for the textual representation with your addition that empty items are NULL? This isn't C, it's SQL; and I think the array I/O representation is a closer precedent for us than the C standard. In any case

Re: [HACKERS] I/O support for composite types

2004-06-05 Thread Thomas Hallgren
care one way or the other about parens versus braces; anyone else have an opinion on that? My vote would be on parens. It's more coherent. Do you use braces anywhere else? Kind regards, Thomas Hallgren ---(end of broadcast)--- TIP 3: if posting/reading

[HACKERS] MinGW, psql, and readline

2004-06-08 Thread Thomas Hallgren
the latest sources for readline-4.3. Apparently readline uses termio and termio is not part of MinGW. I need help. I bet someone has solved this in a good way (i.e. without using the cygwin dll's). Thanks, Thomas Hallgren ---(end of broadcast)--- TIP

[HACKERS] Question regarding dynamic_library_path

2004-06-08 Thread Thomas Hallgren
code to do the actual path merging (i.e omitting duplicates etc.). Kind regards, Thomas Hallgren ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] Question regarding dynamic_library_path

2004-06-08 Thread Thomas Hallgren
Thomas Hallgren [EMAIL PROTECTED] writes: Why does postgres maintain a loader logic of its own? I can understand that the dynamic_library_path is necessary in order to configure everything in one single place. But why not just merge it with the LD_LIBRARY_PATH (or PATH on Windows

Re: [HACKERS] Question regarding dynamic_library_path

2004-06-08 Thread Thomas Hallgren
cases. regards, Thomas Hallgren ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [HACKERS] Question regarding dynamic_library_path

2004-06-08 Thread Thomas Hallgren
this with a better implementation. I do *not* want to expose LD_LIBRARY_PATH nor force anyone to use it. I simply want the dynamic_library_path propagated to the loader in a correct fasion. regards, Thomas Hallgren ---(end of broadcast)--- TIP 7: don't

Re: [HACKERS] Question regarding dynamic_library_path

2004-06-08 Thread Thomas Hallgren
always a workaround for the problem and this is what I do today. My suggestion is based on the assumption that it would be nice if the dynamic_library_path actually worked for libraries loading libraries. The discussion is pointless if that assumption is incorrect. Kind regards, Thomas Hallgren

Re: [HACKERS] Question regarding dynamic_library_path

2004-06-09 Thread Thomas Hallgren
compatibility to keep everyone happy. Kind regards, Thomas Hallgren - Original Message - From: Tom Lane [EMAIL PROTECTED] To: Thomas Hallgren [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, June 09, 2004 7:24 AM Subject: Re: [HACKERS] Question regarding dynamic_library_path Thomas

Re: [HACKERS] Question regarding dynamic_library_path

2004-06-09 Thread Thomas Hallgren
:-). The part concerning the security-leak is important though. Kind 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

Re: [HACKERS] Question regarding dynamic_library_path

2004-06-09 Thread Thomas Hallgren
And only the super user can use directory components in a module name? regards, Thomas Hallgren Andrew Dunstan [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Thomas Hallgren wrote: Isn't the fact that dynamic_library_path can be changed at any time by a user a serious security

Re: [HACKERS] Question regarding dynamic_library_path

2004-06-09 Thread Thomas Hallgren
I agree. I wasn't aware of that restriction. regards, Thomas Hallgren - Original Message - From: Tom Lane [EMAIL PROTECTED] To: Thomas Hallgren [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, June 09, 2004 15:56 Subject: Re: [HACKERS] Question regarding dynamic_library_path

Re: [HACKERS] I just got it: PostgreSQL Application Server -- a new project.

2004-06-12 Thread Thomas Hallgren
really need some other umbrella name for this. Kind regards, Thomas Hallgren Carl E. McMillin [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Jumping on that bandwagon with all 6 feet! Carl |};-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf

Re: [HACKERS] I just got it: PostgreSQL Application Server -- a new project.

2004-06-12 Thread Thomas Hallgren
. It will not however, make PosgreSQL an app-server in itself. I really think that [EMAIL PROTECTED] has great ideas (B.T.W. it would be nice to know your name) and I'd be happy to help out if this project takes off. But some other name for it would be preferable. Kind regards, Thomas Hallgren

Re: [HACKERS] I just got it: PostgreSQL Application Server -- a new project.

2004-06-12 Thread Thomas Hallgren
, Thomas Hallgren ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] I just got it: PostgreSQL Application Server -- a new project.

2004-06-13 Thread Thomas Hallgren
too, I imagine. It's there already. Pl/Java comes with a JDBC driver implemented on top of SPI. And using it, you are of course running in the same transaction as the origin of the call to Java. Kind regards, Thomas Hallgren ---(end of broadcast

Re: [HACKERS] placeholder syntax

2004-06-21 Thread Thomas Hallgren
, a parameter placeholder in SQL for most people. So even if '?' shouldn't be emulated at this time, perhaps it would be a good idea to abandon it as a valid operator? Kind regards, Thomas Hallgren Greg Stark [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Tom Lane [EMAIL PROTECTED] writes

Re: [HACKERS] warning missing

2004-06-23 Thread Thomas Hallgren
) cannot be hidden. Kind regards, Thomas Hallgren ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] warning missing

2004-06-23 Thread Thomas Hallgren
Gaetano Mendola wrote: Thomas Hallgren wrote: Speaking in generic OO terms, using inheritance, you cannot remove attributes that are present in the generalisation. If B inherits A, an instance of B is per definition also an instance of A. Thus, you must alwasy be able to cast a B

Re: [HACKERS] warning missing

2004-06-23 Thread Thomas Hallgren
Greg Stark [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Thomas Hallgren [EMAIL PROTECTED] writes: Try to use a similar construct in a more elaborate OO-language (like Java, C#, etc.) and you will get an error like: Just as a point of reference, Java and C# are not more

Re: [HACKERS] bug in GUC

2004-06-24 Thread Thomas Hallgren
I'll look into that. Thanks for pointing it out. Kind regards, Thomas Hallgren Alvaro Herrera [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hackers, I think there a bug in the GUC mechanism. The custom variables patch added several malloc() and a strdup() call

Re: [HACKERS] bug in GUC

2004-06-24 Thread Thomas Hallgren
a different thing altogether since it doesn't use ereport. I'm sure I missed something somewhere but if not, perhaps the above functions would make sense? If so, what's the best name for them and where should they reside? Kind regards, Thomas Hallgren Alvaro Herrera [EMAIL PROTECTED] wrote

Re: [HACKERS] warning missing

2004-06-24 Thread Thomas Hallgren
Greg Stark [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Thomas Hallgren [EMAIL PROTECTED] writes: From an OO semantics point of view, I still regard Java and C# much more elaborate than both C++ and Common Lisp. The latter lacks interfaces and different levels of protection

Re: [HACKERS] bug in GUC

2004-06-24 Thread Thomas Hallgren
will guarantee correct behavior on out of memory? Kind regards, Thomas Hallgren Tom Lane [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Thomas Hallgren [EMAIL PROTECTED] writes: Rather than clutter the code with the same ereport over and over again (I count 12 malloc's in guc.c alone

Re: [HACKERS] warning missing

2004-06-24 Thread Thomas Hallgren
not. Let's just respect eachothers standpoint and end the discussion here. Kind regards, Thomas Hallgren ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] warning missing

2004-06-26 Thread Thomas Hallgren
plain C (which I did) to get maximum acceptance. Kind regards, Thomas Hallgren ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [HACKERS] transactions within functions

2004-07-02 Thread Thomas Hallgren
batch. Each call followed by a commit. This approach will give you full control, both with respect to transactions and logging/debugging. Kind regards, Thomas Hallgren ---(end of broadcast)--- TIP 2: you can get off all lists at once

Re: [HACKERS] Binary Cursors, and the COPY command

2004-07-27 Thread Thomas Hallgren
means that Java clients have the opposite problem -- it's a lot of work to try to use the 7.3-style binary formats. The commonly used java.io.DataInput will always use network order but it's easy enough to read/write little endian using the java.nio and java.nio.channel packages. Regards, Thomas

Re: [HACKERS] Binary Cursors, and the COPY command

2004-07-27 Thread Thomas Hallgren
, Thomas Hallgren ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [HACKERS] Binary Cursors, and the COPY command

2004-07-27 Thread Thomas Hallgren
and can be changed using the order method. This is the mechanism you'd use to implement I/O that can handle either endian type. Regards, Thomas Hallgren ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] Sketch of extending error handling for subtransactions in functions

2004-07-29 Thread Thomas Hallgren
to a supported version of the macros. 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

Re: [HACKERS] try/catch macros for Postgres backend

2004-07-30 Thread Thomas Hallgren
/Java makes heavy use (almost all calls) of TRY/CATCH macros today so any performance increase, even a small one, might be significant. And the ability to catch an error and actually handle it, hear, hear! Kind regards, Thomas Hallgren ---(end of broadcast

[HACKERS] The new try/catch macros

2004-08-08 Thread Thomas Hallgren
the PG_TRY_BREAK/PG_TRY_CONTINUE Thoughts? Regards, Thomas Hallgren ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [HACKERS] The new try/catch macros

2004-08-08 Thread Thomas Hallgren
that if such a patch would be well received. Regards, Thomas Hallgren ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [HACKERS] The new try/catch macros

2004-08-08 Thread Thomas Hallgren
Tom Lane wrote: Perhaps, but what about everyone's editors' autoindent logic? I'd have preferred not to have the (); decoration too, but it is really not worth the pain. I guess you have a point. Ok, I'll live with it. Regards, Thomas Hallgren ---(end of broadcast

  1   2   3   4   5   >