[HACKERS] [patch] jdbc build fix when ./configure is run in separate dir

2004-01-19 Thread tim
When ./configure is run outside the source directory (to keep the build files separate from the source files), make fails for the jdbc target because ant is not informed of the configure/build directory location. This patch fixes this, but could you please review it for portability, etc. For

Re: [HACKERS] What's planned for 7.5?

2004-01-19 Thread Jan Wieck
Christopher Browne wrote: 2. Jan Wieck's work on SLONY-1 Many are keen to see the code, but it's not out yet. And it is not self-evident that it will necessarily be ready to release in conjunction with 7.5 (Not to say it _can't_ happen, but just that we'll see the code

[HACKERS] Getting the results columns before execution

2004-01-19 Thread Shachar Shemesh
Hi all, From the OLE DB manual: The consumer can also get information about the columns of the rowset by calling IColumnsInfo::GetColumnInfo, which all providers must support, or IColumnsRowset::GetColumnsRowset, which providers may support, on the command. Before calling GetColumnInfo or

Re: [HACKERS] VACUUM delay (was Re: What's planned for 7.5?)

2004-01-19 Thread Jan Wieck
Stephen wrote: The vacuum delay patch is not the ideal solution but it worked like a charm on my servers. I really need the vacuum delay patch or a better solution in 7.5. I'm getting millions of requests a month and running VACUUM without the patch makes PostgreSQL useless for many consecutive

Re: [HACKERS] Getting the results columns before execution

2004-01-19 Thread Darko Prenosil
On Monday 19 January 2004 15:13, Shachar Shemesh wrote: Hi all, From the OLE DB manual: The consumer can also get information about the columns of the rowset by calling IColumnsInfo::GetColumnInfo, which all providers must support, or IColumnsRowset::GetColumnsRowset, which providers may

Re: [HACKERS] Getting the results columns before execution

2004-01-19 Thread Tom Lane
Shachar Shemesh [EMAIL PROTECTED] writes: ... This is a problem, as merely preparing a command is not enough to get the returned rows information. Sure it is, if you are using the V3 protocol (new in 7.4). See the Describe message types. regards, tom lane

Re: [HACKERS] Getting the results columns before execution

2004-01-19 Thread Shachar Shemesh
Tom Lane wrote: Shachar Shemesh [EMAIL PROTECTED] writes: ... This is a problem, as merely preparing a command is not enough to get the returned rows information. Sure it is, if you are using the V3 protocol (new in 7.4). See the Describe message types. regards, tom lane Are those

[HACKERS] logging enhancement recap

2004-01-19 Thread Andrew Dunstan
Fellow hackers, Back in August I submitted a patch that essentially did 2 things: . explicitly logged the end of a client connection, including the connection's elapsed time, enabled by a config variable called log_session_end, and . provided for tagging all of a sessions log lines using a

Re: [HACKERS] Getting the results columns before execution

2004-01-19 Thread Tom Lane
Shachar Shemesh [EMAIL PROTECTED] writes: Tom Lane wrote: Sure it is, if you are using the V3 protocol (new in 7.4). See the Describe message types. Are those exposed through the libpq interface? No, because libpq doesn't really have any concept of prepared statements. It would probably make

Re: Incremental Backup (Was: [HACKERS] And ppl complain about *our*

2004-01-19 Thread Jan Wieck
Martin Marques wrote: Mensaje citado por David Garamond [EMAIL PROTECTED]: Marc G. Fournier wrote: From the Firebird FAQ: The first beta was released on January 29, 2003. We are hoping to be close to a full release some time around Easter 2003. They are at RC8 right now ... running a

Re: [HACKERS] Strange COPY from problem (resent)

2004-01-19 Thread Robert Treat
It's not ideal, but can you dump those tables using INSERT commands and load them into your database? Robert Treat On Wednesday 14 January 2004 13:53, [EMAIL PROTECTED] wrote: Hi all, I resend this mail because I didn't have any answer; I still did'nt find any solution, the same line is

Re: [HACKERS] Strange COPY from problem (resent)

2004-01-19 Thread ohp
The problem has been solved by Tom Lane et was NOT a postgresql problem... I'm ashamed to say so :à) Regards On Mon, 19 Jan 2004, Robert Treat wrote: Date: Mon, 19 Jan 2004 13:29:19 -0500 From: Robert Treat [EMAIL PROTECTED] To: [EMAIL PROTECTED], pgsql-hackers list [EMAIL PROTECTED]

Re: [HACKERS] What's planned for 7.5?

2004-01-19 Thread Andrew Sullivan
On Mon, Jan 19, 2004 at 08:12:28AM -0500, Jan Wieck wrote: and cons, none is the one size that fits all magic solution. To select Does anyone realy believe that there can be a one size fits all solution? Heck, even Oracle and IBM offer a couple of different systems, depending on what you need.

Re: [HACKERS] set search_path and pg_dumpall

2004-01-19 Thread Tom Lane
Robert Treat [EMAIL PROTECTED] writes: I can't be the only one forsee frustration from users who typo the set search_path statement and then can't figure out why their tables aren't showing up... can we emit a warning that not all of the schemas in the search path were found? Since no one

[HACKERS] Old binary packages.

2004-01-19 Thread Lamar Owen
I am looking at the possibility of cleaning up the binary tree on the ftp site, and was wondering what the group thought about purging old binaries. What I was thinking would be to remove all but the last minor release of each major version. Thus, I would remove 7.4, but leave 7.4.1. The

[HACKERS] [7.4] permissions problem with pl/pgsql function

2004-01-19 Thread Marc G. Fournier
Just had a client point this out to me, and am wondering if its supposed to happen: 420_test= select dropgeometrycolumn('420_test','lroadline61','roads61_geom'); ERROR: permission denied for relation pg_attribute CONTEXT: PL/pgSQL function dropgeometrycolumn line 19 at execute statement the

Re: [HACKERS] Old binary packages.

2004-01-19 Thread Joshua D. Drake
Lamar Owen wrote: I am looking at the possibility of cleaning up the binary tree on the ftp site, and was wondering what the group thought about purging old binaries. What I was thinking would be to remove all but the last minor release of each major version. Thus, I would remove 7.4, but

Re: [HACKERS] [7.4] permissions problem with pl/pgsql function

2004-01-19 Thread Tom Lane
Marc G. Fournier [EMAIL PROTECTED] writes: Just had a client point this out to me, and am wondering if its supposed to happen: 420_test= select dropgeometrycolumn('420_test','lroadline61','roads61_geom'); ERROR: permission denied for relation pg_attribute CONTEXT: PL/pgSQL function

Re: [HACKERS] Old binary packages.

2004-01-19 Thread Tom Lane
Lamar Owen [EMAIL PROTECTED] writes: I am looking at the possibility of cleaning up the binary tree on the ftp site, and was wondering what the group thought about purging old binaries. What I was thinking would be to remove all but the last minor release of each major version. Thus, I

[HACKERS] SPI_prepare and error recovery

2004-01-19 Thread Thomas Hallgren
I'm using SPI_prepare to do some dynamic SQL stuff in the backend. Some errors result in a call to the elog routines with ERROR level, which in turn causes log printout and a longjmp. Since I want to trap those errors and try an alternative I tried the following: sigjmp_buf saveRestart;

Re: [HACKERS] SPI_prepare and error recovery

2004-01-19 Thread Tom Lane
Thomas Hallgren [EMAIL PROTECTED] writes: My question is, at the point of /* Handle error here */, how do I get hold of the error information? You don't. The above coding technique is entirely unsafe anyway, because it relies on the assumption that the system is still in a good state to

Re: [HACKERS] [7.4] permissions problem with pl/pgsql function

2004-01-19 Thread Christopher Kings-Lynne
420_test= select dropgeometrycolumn('420_test','lroadline61','roads61_geom'); ERROR: permission denied for relation pg_attribute CONTEXT: PL/pgSQL function dropgeometrycolumn line 19 at execute statement the database was created as: CREATE DATABASE db WITH OWNER = owner and I'm connected to

Re: [HACKERS] Old binary packages.

2004-01-19 Thread Peter Eisentraut
Lamar Owen wrote: I am looking at the possibility of cleaning up the binary tree on the ftp site, and was wondering what the group thought about purging old binaries. What I was thinking would be to remove all but the last minor release of each major version. Thus, I would remove 7.4, but

Re: [HACKERS] SPI_prepare and error recovery

2004-01-19 Thread Thomas Hallgren
As you already know, I'm working on a backend Java mapping. I'm using the SPI routines to implement java.sql interfaces such as Connection, PreparedStatement, and ResultSet, that will utilize the current transaction. Using them, you will work with a try/catch/finally metaphor and all exceptions,

Re: [HACKERS] VACUUM delay (was Re: What's planned for 7.5?)

2004-01-19 Thread Josh Berkus
People, I don't have the time to make enough different attempts to find the one that pleases all. My argument still is that all this IO throttling and IO optimizing is mainly needed for dedicated servers, because I think that if you still run multiple services on one box you're not really

Re: [HACKERS] VACUUM delay (was Re: What's planned for 7.5?)

2004-01-19 Thread Matthew T. O'Connor
On Mon, 2004-01-19 at 08:37, Jan Wieck wrote: but I will not waste my time with making patches nobody even gives a try. I downloaded and tested your patches. I just didn't get results get results that were put together well enough to present to the group. I hope this doesn't fall by the

Re: [HACKERS] What's planned for 7.5?

2004-01-19 Thread David Garamond
Andrew Sullivan wrote: On Mon, Jan 19, 2004 at 08:12:28AM -0500, Jan Wieck wrote: and cons, none is the one size that fits all magic solution. To select Does anyone realy believe that there can be a one size fits all solution? Heck, even Oracle and IBM offer a couple of different systems,

[HACKERS] [Fwd: plpgsql and booleans?]

2004-01-19 Thread Christopher Kings-Lynne
Hi guys, When writing a PL/pgSQL trigger function how do you handle the case : EXECUTE ''UPDATE test_table SET test_col '' || quote_literal(NEW.test_col2) || '';''; where test_col and test_col2 are boolean fields? The case above gives : ERROR: function quote_literal(boolean) does not exist

[HACKERS] Allow backend to output result sets in XML

2004-01-19 Thread Brian Moore
hello, i would like to begin work on the TODO item Allow backend to output result sets in XML i would like to know if anyone has already begun work on this item. if someone has already started work, i would love to help! thanks much in advance, b __ Do you