[HACKERS] v3 protocol & string encoding

2004-05-29 Thread Oliver Jowett
Couple of quick protocol questions: 1) What encoding is used for strings sent and received during the startup phase? I can set client_encoding to a known value as a parameter in the startup packet, but the protocol spec doesn't appear to say how the startup packet itself and the various strings

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 >

[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] 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

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

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 p

[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 broadcast)

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

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 dat

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] 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

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"

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

Re: [HACKERS] Extended customizing, SQL functions,

2004-05-29 Thread Shridhar Daithankar
On Saturday 29 May 2004 20:48, [EMAIL PROTECTED] wrote: > I was thinking that it could be done as a contrib/pgfoundary function. I > think, but am not sure, that a function can be pre-loaded into the main > postgresql backend (postmaster) prior to starting other connections. I'll > have to check th

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

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 c

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 va

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 thi

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 t

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

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_pa

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 > translatio

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] 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 >> th

[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 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 *