Re: [HACKERS] false infinite recursion detected

2004-05-29 Thread Tom Lane
Gaetano Mendola [EMAIL PROTECTED] writes: kalman=# select * from v_v_test; ERROR: infinite recursion detected in rules for relation v_test Fixed, thanks for the report! regards, tom lane ---(end of broadcast)--- TIP 7:

Re: [HACKERS] Win32, PITR, nested transactions, tablespaces

2004-05-29 Thread Tom Lane
Greg Stark [EMAIL PROTECTED] writes: This is the only place where I see hardly any movement on major items the whole development cycle, then a rush of radical changes just before the freeze. [blink] There's been plenty of stuff done all through this development cycle (and previous ones too).

Re: [HACKERS] temp tables broken in CVS HEAD?

2004-05-29 Thread Sean Chittenden
test= create temp table t2 (i integer); ERROR: permission denied for schema pg_temp_1 The immediate problem is a simple thinko (lack of attention to a function's return convention), but I'm gonna go back and review that whole patch. It obviously wasn't tested well at all. I know what's going on

Re: [HACKERS] Extended customizing, SQL functions,

2004-05-29 Thread Shridhar Daithankar
On Saturday 29 May 2004 04:38, [EMAIL PROTECTED] wrote: Now, I could roll my own system pretty easily, and probably will do so. It won't take too much, however, it would be neat if this was in PostgreSQL. I fully expect that people would worry about this, and I don't blame them. It is a *bad*

[HACKERS] dynamic_library_path on Win32

2004-05-29 Thread Thomas Hallgren
I'm using CVS HEAD in a windows environment. I'm trying to start the postmaster using postmaster -c dynamic_library_path=C:/foo/bar. It starts just fine, then, when I ask it to load a module, an error is generating stating: ERROR: component in parameter dynamic_library_path is not an absolute

Re: [HACKERS] Extended customizing, SQL functions,

2004-05-29 Thread pgsql
On Saturday 29 May 2004 04:38, [EMAIL PROTECTED] wrote: Now, I could roll my own system pretty easily, and probably will do so. It won't take too much, however, it would be neat if this was in PostgreSQL. I fully expect that people would worry about this, and I don't blame them. It is a

Re: [HACKERS] false infinite recursion detected

2004-05-29 Thread Gaetano Mendola
Tom Lane wrote: Gaetano Mendola [EMAIL PROTECTED] writes: kalman=# select * from v_v_test; ERROR: infinite recursion detected in rules for relation v_test I think also my other message: passing a whole record is a bug that shall to be fixed. Regards Gaetano Mendola

Re: [HACKERS] Nested xacts: looking for testers and review

2004-05-29 Thread Alvaro Herrera
On Sat, May 29, 2004 at 08:25:27AM -0700, Stephan Szabo wrote: Also related, although START TRANSACTION (specifying isolation level or read onlyness as part) is currently defined to act as if set transaction was used, it seems really odd that the settings would leak to the outer translation

Re: [HACKERS] dynamic_library_path on Win32

2004-05-29 Thread Andrew Dunstan
Thomas Hallgren wrote: I'm using CVS HEAD in a windows environment. I'm trying to start the postmaster using postmaster -c dynamic_library_path=C:/foo/bar. It starts just fine, then, when I ask it to load a module, an error is generating stating: ERROR: component in parameter dynamic_library_path

Re: [HACKERS] Nested xacts: looking for testers and review

2004-05-29 Thread Stephan Szabo
On Sat, 29 May 2004, Alvaro Herrera wrote: On Sat, May 29, 2004 at 08:25:27AM -0700, Stephan Szabo wrote: Also related, although START TRANSACTION (specifying isolation level or read onlyness as part) is currently defined to act as if set transaction was used, it seems really odd that

Re: [HACKERS] Win32, PITR, nested transactions, tablespaces

2004-05-29 Thread Greg Stark
Tom Lane [EMAIL PROTECTED] writes: Greg Stark [EMAIL PROTECTED] writes: This is the only place where I see hardly any movement on major items the whole development cycle, then a rush of radical changes just before the freeze. [blink] There's been plenty of stuff done all through this

Re: [HACKERS] Extended customizing, SQL functions,

2004-05-29 Thread Greg Stark
[EMAIL PROTECTED] writes: Having internal PostgreSQL variables that are not present on disk, or maybe, variables that are mirrored on disk may be good. I don't think there's anything wrong with your idea, and there are numerous good solutions that implement it already. But what makes you

Re: [HACKERS] Extended customizing, SQL functions,

2004-05-29 Thread pgsql
On Saturday 29 May 2004 18:10, [EMAIL PROTECTED] wrote: Having internal PostgreSQL variables that are not present on disk, or maybe, variables that are mirrored on disk may be good. Yes. I agree. I can see why you proposed no transactions few posts ago. Take an example of a count variable.

Re: [HACKERS] Nested xacts: looking for testers and review

2004-05-29 Thread Stephan Szabo
On Fri, 28 May 2004, Alvaro Herrera wrote: On Fri, May 28, 2004 at 05:43:41PM -0700, Stephan Szabo wrote: On Wed, 26 May 2004, Alvaro Herrera wrote: I have tested it and it passes all regression tests (including ones I added), plus some more tests I threw at it mainly for concurrency.

Re: [HACKERS] dynamic_library_path on Win32

2004-05-29 Thread Tom Lane
Thomas Hallgren [EMAIL PROTECTED] writes: I'm using CVS HEAD in a windows environment. I'm trying to start the postmaster using postmaster -c dynamic_library_path=C:/foo/bar. It starts just fine, then, when I ask it to load a module, an error is generating stating: ERROR: component in

Re: [HACKERS] Extended customizing, SQL functions,

2004-05-29 Thread pgsql
[EMAIL PROTECTED] writes: Having internal PostgreSQL variables that are not present on disk, or maybe, variables that are mirrored on disk may be good. I don't think there's anything wrong with your idea, and there are numerous good solutions that implement it already. But what makes you

Re: [HACKERS] dynamic_library_path on Win32

2004-05-29 Thread Magnus Hagander
I'm using CVS HEAD in a windows environment. I'm trying to start the postmaster using postmaster -c dynamic_library_path=C:/foo/bar. It starts just fine, then, when I ask it to load a module, an error is generating stating: ERROR: component in parameter dynamic_library_path is not an

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] dynamic_library_path on Win32

2004-05-29 Thread Andrew Dunstan
Tom Lane wrote: Thomas Hallgren [EMAIL PROTECTED] writes: I'm using CVS HEAD in a windows environment. I'm trying to start the postmaster using postmaster -c dynamic_library_path=C:/foo/bar. It starts just fine, then, when I ask it to load a module, an error is generating stating:

Re: [HACKERS] Extended customizing, SQL functions,

2004-05-29 Thread Greg Stark
[EMAIL PROTECTED] writes: I agree completely with one caveat, when the best tool for the job lacks a feature what do you do? You're missing the point. The feature you want has nothing to do with relational databases. It has everything to do with in-memory non-transactional non-relational

Re: [HACKERS] dynamic_library_path on Win32

2004-05-29 Thread Tom Lane
Andrew Dunstan [EMAIL PROTECTED] writes: You've found a bug. Clearly we need to adjust the parsing of dynamic_library_path and probably preload_libraries for Win32. Yup. Using PATHSEP sounded reasonable to me. Any volunteer to fix this? (Don't forget to patch the docs for these variables,

[HACKERS] Geometry regression failure on OS X 10.3.4

2004-05-29 Thread Michael Glaesemann
Hello all, Just made CVS head on Mac OS X 10.3.4. On make check, I got test geometry ... FAILED This was the only test that failed. Regression diff attached. Michael Glaesemann grzm myrealbox com regression.diffs Description: Binary data ---(end of

Re: [HACKERS] dynamic_library_path on Win32

2004-05-29 Thread Bruce Momjian
I can do it but will be a few days until I get to it. --- Tom Lane wrote: Andrew Dunstan [EMAIL PROTECTED] writes: You've found a bug. Clearly we need to adjust the parsing of dynamic_library_path and probably

Re: [HACKERS] Big problem

2004-05-29 Thread Sérgio Monteiro Basto
On Mon, 2004-05-24 at 16:03, Christopher Kings-Lynne wrote: Isn't it just enough to prevent the user with userid 1 from losing the superuser status. If one want to allow it one could prevent it just when doing the ALTER USER stuff and allow it when editing pg_shadow directly. Or maybe

Re: [HACKERS] Ingres to be released as open source

2004-05-29 Thread Leandro Guimaraens Faria Corsetti Dutra
Em Tue, 25 May 2004 10:54:48 +0800, Christopher Kings-Lynne escreveu: Can we grab features from their codebase? No, and that's what's nice about copyleft. It forbids code hoarding. OTOH, it would be interesting to see some competition. Ingres could encroach in some current or

[HACKERS] Changing view column types

2004-05-29 Thread Christopher Kings-Lynne
Is there any possibility for changing view column types now in 7.5? Chris ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] Extended customizing, SQL functions,

2004-05-29 Thread pgsql
[EMAIL PROTECTED] writes: I agree completely with one caveat, when the best tool for the job lacks a feature what do you do? You're missing the point. The feature you want has nothing to do with relational databases. It has everything to do with in-memory non-transactional