Re: [HACKERS] Transaction is read-only in auto commit mode

2006-09-28 Thread Albe Laurenz
Chattopadhyay asked: My application based on Java servlets was running fine with version PostgreSQL 7.x, but started giving error: transaction is read-only, in version 8.0 and 8.1. I am using Suse Linux 9.3/PostgreSQL 8.0 or Suse Linux 10.1/PostgreSQL 8.1. I am using JDBC 3 drivers and

Re: [HACKERS] Can i see server SQL commands ?

2006-09-28 Thread tomas
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thu, Sep 28, 2006 at 04:27:36AM +0300, Adnan DURSUN wrote: Hi all I wanna know what is going on while a DML command works. For example ; Which commands are executed by the core when we send an UPDATE tab SET col =

Re: [OT][HACKERS] DROP FUNCTION IF EXISTS

2006-09-28 Thread Csaba Nagy
Backspace deletes character-wise, as long as you have LANG set correctly. Check LANG and the LC_* environment variables. OK, you're right: $ echo $LANG [EMAIL PROTECTED] # show client_encoding ; client_encoding - UTF8 (1 row) But then I wonder why the client encoding is

[HACKERS] casting to domain problem.

2006-09-28 Thread Gevik Babakhani
Folks, Continuing on previous discussion: http://archives.postgresql.org/pgsql-hackers/2006-09/msg01681.php I was wondering why we are stripping the domains in find_coercion_pathway(). Is it because we do not care for domains at that point? And why don't we have extra logic there in order to

Re: [HACKERS] Block B-Tree concept

2006-09-28 Thread Heikki Linnakangas
Tom Lane wrote: Heikki Linnakangas [EMAIL PROTECTED] writes: AFAICS, we could disable the optimization and use a full-blown transaction when vacuuming a table with a functional block index. No, we couldn't, or at least it's not merely a matter of reversing a recent optimization. The

[HACKERS] Install on Windows XP

2006-09-28 Thread Mike Bassett
I cannot get gmake to work for the postgresql-8.1.4 source code on Windows XP. I created MinGW with the MinGW 5.0.3.exe (both current latest) and MySyS 1.0.10. Gmake was not available so I used the included mysys make – GNU version 79. After succeeding with “./configure –without-zlib” it then

[HACKERS] Row IS NULL question

2006-09-28 Thread Teodor Sigaev
I'm playing around NULL. Docs says that A row value is considered not null if it has at least one field that is not null. and SELECT ROW(table.*) IS NULL FROM table; -- detect all-null rows So, I try: wow=# \d tst Table public.tst Column | Type | Modifiers

[HACKERS] Backup and restore through JDBC

2006-09-28 Thread Marlon Petry
Hello List I am trying to develop, a API to carry through backup and restore through JDBC. I think that the best form is to use JNI. Some Suggestion?

Re: [HACKERS] Faster StrNCpy

2006-09-28 Thread Strong, David
Mark, In the specific case of the namestrcpy () function, it will copy a maximum of 64 bytes, but the length of the source string is unknown. I would have to think that memcpy () would certainly win if you knew the source and destination sizes etc. Perhaps there are some places like that in the

Re: [HACKERS] New version of money type

2006-09-28 Thread D'Arcy J.M. Cain
On Thu, 14 Sep 2006 10:35:03 -0400 D'Arcy J.M. Cain darcy@druid.net wrote: For years I have been promising that a 64 bit version of the money type was on the way. Here it is. So far it compiles and I have done some basic testing on it and it seems to work fine. Note that the currency symbol

Re: [HACKERS] New version of money type

2006-09-28 Thread Luke Lonergan
Though this may be the kiss of death, I favor a 64 bit float version of money. It's more terse than numeric and a *lot* faster when performing numeric operations because it would use a cpu intrinsic operand. - Luke Msg is shrt cuz m on ma treo -Original Message- From: D'Arcy J.M.

Re: [HACKERS] New version of money type

2006-09-28 Thread D'Arcy J.M. Cain
On Thu, 28 Sep 2006 11:09:17 -0400 Luke Lonergan [EMAIL PROTECTED] wrote: Though this may be the kiss of death, I favor a 64 bit float version of money. It's more terse than numeric and a I assume you mean ...64 bit INT version... -- D'Arcy J.M. Cain darcy@druid.net | Democracy is

Re: [HACKERS] New version of money type

2006-09-28 Thread Luke Lonergan
Oic - so it's a floating point in an 8 byte int. That probably limits the speed benefits, no? - Luke Msg is shrt cuz m on ma treo -Original Message- From: D'Arcy J.M. Cain [mailto:[EMAIL PROTECTED] Sent: Thursday, September 28, 2006 11:14 AM Eastern Standard Time To: Luke

Re: [HACKERS] New version of money type

2006-09-28 Thread D'Arcy J.M. Cain
On Thu, 28 Sep 2006 11:25:45 -0400 Luke Lonergan [EMAIL PROTECTED] wrote: Oic - so it's a floating point in an 8 byte int. That probably limits the speed benefits, no? No, it's an int type. Floating point has nothing to do with the money type, either in the old 32 bit version or the proposed

Re: [HACKERS] New version of money type

2006-09-28 Thread Jim C. Nasby
On Thu, Sep 28, 2006 at 11:32:37AM -0400, D'Arcy J.M. Cain wrote: On Thu, 28 Sep 2006 11:25:45 -0400 Luke Lonergan [EMAIL PROTECTED] wrote: Oic - so it's a floating point in an 8 byte int. That probably limits the speed benefits, no? No, it's an int type. Floating point has nothing to

Re: [HACKERS] New version of money type

2006-09-28 Thread D'Arcy J.M. Cain
On Thu, 28 Sep 2006 10:35:01 -0500 Jim C. Nasby [EMAIL PROTECTED] wrote: Floating point math and hard-earned money are two things that don't mix well. :) Using FP to track money is a good way to stop making any. :-) -- D'Arcy J.M. Cain darcy@druid.net | Democracy is three wolves

Re: [HACKERS] Constant changes (Re-Build)

2006-09-28 Thread luis garcia
Well Thanks you both for your answers, I really appreciate your opinions on this subject. And Heikki I would really like to take a look to that book. If I have the chance to read it I will tell you how the things go Ok... Greets and Thanks one more time..2006/9/27, Heikki Linnakangas [EMAIL

Re: [HACKERS] Row IS NULL question

2006-09-28 Thread Tom Lane
Teodor Sigaev [EMAIL PROTECTED] writes: % echo 'SELECT count(*) FROM tst WHERE ROW(tst.*) IS NULL;' | psql wow SET count --- 0 (1 row) Hm, it turns out that this works: select * from int8_tbl x where row(x.q1,x.q2) is null; but not this: select * from int8_tbl x

Re: [HACKERS] Faster StrNCpy

2006-09-28 Thread Tom Lane
Strong, David [EMAIL PROTECTED] writes: Just wondering - are any of these cases where a memcpy() would work just as well? Or are you not sure that the source string is at least 64 bytes in length? In most cases, we're pretty sure that it's *not* --- it'll just be a palloc'd C string. I'm

Re: [HACKERS] Row IS NULL question

2006-09-28 Thread Gevik Babakhani
Please excuse me for jumping in like this... but just for my understanding... Does this have anything to do with ExecEvalWholeRowVar? On Thu, 2006-09-28 at 11:45 -0400, Tom Lane wrote: Teodor Sigaev [EMAIL PROTECTED] writes: % echo 'SELECT count(*) FROM tst WHERE ROW(tst.*) IS NULL;' | psql

Re: [HACKERS] New version of money type

2006-09-28 Thread Luke Lonergan
D'Arcy, On 9/28/06 8:43 AM, D'Arcy J.M. Cain darcy@druid.net wrote: On Thu, 28 Sep 2006 10:35:01 -0500 Jim C. Nasby [EMAIL PROTECTED] wrote: Floating point math and hard-earned money are two things that don't mix well. :) Using FP to track money is a good way to stop making any. :-)

Re: [HACKERS] Row IS NULL question

2006-09-28 Thread Tom Lane
Gevik Babakhani [EMAIL PROTECTED] writes: Does this have anything to do with ExecEvalWholeRowVar? Yeah, the construct Seq Scan on int8_tbl x (cost=0.00..1.05 rows=1 width=16) Filter: (x.* IS NULL) is really ExecEvalNullTest applied to the result of ExecEvalWholeRowVar. If we simply push

[HACKERS] Another idea for dealing with cmin/cmax

2006-09-28 Thread Jim C. Nasby
In addition to/instead of abstracting cmin/cmax to a phantom ID, what about allowing for two versions of the tuple header, one with cid info and one without? That would allow for cid info to be stripped out when pages were written to disk. The downside to this is that we'd have to be able to deal

Re: [HACKERS] Another idea for dealing with cmin/cmax

2006-09-28 Thread Heikki Linnakangas
Jim C. Nasby wrote: In addition to/instead of abstracting cmin/cmax to a phantom ID, what about allowing for two versions of the tuple header, one with cid info and one without? That would allow for cid info to be stripped out when pages were written to disk. How exactly would that help?

Re: [HACKERS] -HEAD planner issue wrt hash_joins on dbt3 ?

2006-09-28 Thread Stefan Kaltenbrunner
Matteo Beccati wrote: Stefan Kaltenbrunner wrote: too bad - however any idea on one of the other troubling querys (q21) I mentioned in the mail I resent to the list (after the original one got lost)? http://archives.postgresql.org/pgsql-hackers/2006-09/msg02011.php What happens if you

Re: [HACKERS] [GENERAL] 'pg_ctl -w' times out when unix_socket_directory is

2006-09-28 Thread Jeff Davis
On Thu, 2006-09-28 at 10:05 -0400, Tom Lane wrote: Jeff Davis [EMAIL PROTECTED] writes: I have attached a patch. I wrote it very quickly, but it seems to work as I expect. I don't think this is very workable as a postgresql.conf parser ... at minimum it needs to handle quoted strings

Re: [HACKERS] Another idea for dealing with cmin/cmax

2006-09-28 Thread Jim C. Nasby
On Thu, Sep 28, 2006 at 05:13:11PM +0100, Heikki Linnakangas wrote: Jim C. Nasby wrote: In addition to/instead of abstracting cmin/cmax to a phantom ID, what about allowing for two versions of the tuple header, one with cid info and one without? That would allow for cid info to be stripped out

Re: [HACKERS] New version of money type

2006-09-28 Thread Luke Lonergan
D'Arcy, On 9/28/06 9:00 AM, Luke Lonergan [EMAIL PROTECTED] wrote: Which routines implement the money arithmetic? Ok - so now having read the old documentation and the routine backend/utils/adt/cash.c and the type definition for Cash in backend/include/utils/adt/cash.h I can see that it's:

Re: [HACKERS] New version of money type

2006-09-28 Thread Stephen Frost
* Luke Lonergan ([EMAIL PROTECTED]) wrote: Though this may be the kiss of death, I favor a 64 bit float version of money. It's more terse than numeric and a *lot* faster when performing numeric operations because it would use a cpu intrinsic operand. What about just having a numeric64, or

Re: [HACKERS] Bitmap index status

2006-09-28 Thread Mark Wong
Luke Lonergan wrote: Mark, On 9/25/06 11:32 AM, Mark Wong [EMAIL PROTECTED] wrote: Yeah, basically gather as many stats as I can to accurately profile the overall system performance. I thought it would be appropriate to use a TPC-H based workload as one measuring stick to use for bitmap

Re: [HACKERS] New version of money type

2006-09-28 Thread Luke Lonergan
Stephen, On 9/28/06 9:44 AM, Stephen Frost [EMAIL PROTECTED] wrote: I'm not sure about 'money' in general but these claims of great performance improvments over numeric just don't fly so easily with me. numeric isn't all *that* much slower than regular old integer in the tests that I've

Re: [HACKERS] Row IS NULL question

2006-09-28 Thread David Fetter
On Thu, Sep 28, 2006 at 11:45:32AM -0400, Tom Lane wrote: Teodor Sigaev [EMAIL PROTECTED] writes: % echo 'SELECT count(*) FROM tst WHERE ROW(tst.*) IS NULL;' | psql wow SET count --- 0 (1 row) Hm, it turns out that this works: select * from int8_tbl x where

Re: [HACKERS] New version of money type

2006-09-28 Thread D'Arcy J.M. Cain
On Thu, 28 Sep 2006 12:44:24 -0400 Stephen Frost [EMAIL PROTECTED] wrote: I'm not sure about 'money' in general but these claims of great performance improvments over numeric just don't fly so easily with me. numeric isn't all *that* much slower than regular old integer in the tests that I've

Re: [HACKERS] Coding style for emacs

2006-09-28 Thread Bruce Momjian
Andrew Dunstan wrote: Bruce Momjian wrote: Andrew Dunstan wrote: I will try to draw all this together today or tomorrow. It's not only the FAQ that should be patched - the docs and the FAQ should agree with each other. Right. In fact, this info arguably belongs

[HACKERS] TM modificator don't work? to_char

2006-09-28 Thread Pavel Stehule
Hello, I try 8.2 features. I tested to_char from doc, but without success. postgres=# select to_char(now(), 'TMDay, DD TMMonth '); to_char - Thursday, 28 September 2006 (1 row) I expected translated names :-(. What can be wrong. lc_collate

Re: [HACKERS] Coding style for emacs

2006-09-28 Thread Bruce Momjian
Bruce Momjian wrote: Looking at this further, I am wondering if it would not be better to put sample .emacs and .vimrc files in the source (in, say, src.tools). The docs/FAQ would just say that we use BSD style with tab space 4 and refer to the sample files. Andrew, I am still

[HACKERS] JAVA Support

2006-09-28 Thread Henry B. Hotz
It appears that the JDBC client doesn't include the Kerberos support that the C clients do. So, two questions: 1) Is there an alternative JDBC client that's just a glue layer instead of a complete re-implementation? 2) If I were willing to add a GSSAPI or SASL layer as an alternative to

Re: [HACKERS] JAVA Support

2006-09-28 Thread Kris Jurka
On Thu, 28 Sep 2006, Henry B. Hotz wrote: It appears that the JDBC client doesn't include the Kerberos support that the C clients do. Java doesn't have accessible Kerberos support. It wraps Kerberos in GSSAPI which requires the server to support GSSAPI instead of plain Kerberos. So,

Re: [HACKERS] contrib uninstall scripts need some love

2006-09-28 Thread Bruce Momjian
Joshua D. Drake wrote: Guido Barosio wrote: Let me know if you need an extra pair of eyes. O.k. I do :) Writing the scripts up are easy enough, but I am unsure how the whole make file foo works... OK, are all the uninstall scripts done?

Re: [HACKERS] New version of money type

2006-09-28 Thread Stephen Frost
* D'Arcy J.M. Cain (darcy@druid.net) wrote: On Thu, 28 Sep 2006 12:44:24 -0400 Stephen Frost [EMAIL PROTECTED] wrote: I'm not sure about 'money' in general but these claims of great performance improvments over numeric just don't fly so easily with me. numeric isn't all *that* much slower

Re: [HACKERS] contrib uninstall scripts need some love

2006-09-28 Thread Joshua D. Drake
Bruce Momjian wrote: Joshua D. Drake wrote: Guido Barosio wrote: Let me know if you need an extra pair of eyes. O.k. I do :) Writing the scripts up are easy enough, but I am unsure how the whole make file foo works... OK, are all the uninstall scripts done? Crap... yes they are, at least

Re: [HACKERS] Row IS NULL question

2006-09-28 Thread Tom Lane
I wrote: Moving makeRowNullTest() doesn't seem like a big deal, but changing ExecEvalNullTest would take some added code. Do we want to tackle that during beta, or hold off till 8.3? An argument for doing it now is that we just added nulls-in-arrays in 8.2, and it'd be good if the semantics

Re: [HACKERS] New version of money type

2006-09-28 Thread Luke Lonergan
D'Arcy, On 9/28/06 10:12 AM, D'Arcy J.M. Cain darcy@druid.net wrote: Numeric has been shown to be as good or better than money in I/O operations. What exactly does that mean in the context of a Datum: I/O operations? - Luke ---(end of

Re: [HACKERS] JAVA Support

2006-09-28 Thread Henry B. Hotz
On Sep 28, 2006, at 10:52 AM, Kris Jurka wrote: On Thu, 28 Sep 2006, Henry B. Hotz wrote: It appears that the JDBC client doesn't include the Kerberos support that the C clients do. Java doesn't have accessible Kerberos support. It wraps Kerberos in GSSAPI which requires the server

[HACKERS] Paging Phil Dodderidge

2006-09-28 Thread Henry B. Hotz
There's an old post from Phil about having GSSAPI support almost working with PostgreSQL. I'd like to ask him about his work, but the email link in the archives doesn't work. The opinions expressed in this message

Re: [HACKERS] Row IS NULL question

2006-09-28 Thread Gevik Babakhani
Thank you for the explanation. On Thu, 2006-09-28 at 12:06 -0400, Tom Lane wrote: Gevik Babakhani [EMAIL PROTECTED] writes: Does this have anything to do with ExecEvalWholeRowVar? Yeah, the construct Seq Scan on int8_tbl x (cost=0.00..1.05 rows=1 width=16) Filter: (x.* IS NULL) is

Re: [HACKERS] New version of money type

2006-09-28 Thread Martijn van Oosterhout
On Thu, Sep 28, 2006 at 11:39:31AM -0700, Luke Lonergan wrote: D'Arcy, On 9/28/06 10:12 AM, D'Arcy J.M. Cain darcy@druid.net wrote: Numeric has been shown to be as good or better than money in I/O operations. What exactly does that mean in the context of a Datum: I/O operations?

[HACKERS] Numeric overflow problem + patch

2006-09-28 Thread David Fetter
Folks, Dennis Björklund and I discovered a little problem with how CVS TIP reports overflows on cast. Please find enclosed a patch which fixes it. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype:

Re: [HACKERS] New version of money type

2006-09-28 Thread Luke Lonergan
Martijn, On 9/28/06 11:53 AM, Martijn van Oosterhout kleptog@svana.org wrote: Converting to/from text format for when dealing with client applications. Numeric can convert faster than plain integers sometimes. Numeric isn't that slow really... Got it - so the performance benefits of the

Re: [HACKERS] JAVA Support

2006-09-28 Thread Kris Jurka
On Thu, 28 Sep 2006, Henry B. Hotz wrote: I take it you're not volunteering to help with my second request. ;-) I would if we could get some -hackers buy in on the idea. Adding more and more auth methods is something they're not excited about unless there's a good reason (which I think

Re: [HACKERS] New version of money type

2006-09-28 Thread Martijn van Oosterhout
On Thu, Sep 28, 2006 at 11:57:10AM -0700, Luke Lonergan wrote: Got it - so the performance benefits of the fixed point versus Numeric are: - Smaller size of fixed point (less than half) - Faster arithmetic operations These should be quantified, so that we can evaluate Money64 as a proposal

Re: [HACKERS] JAVA Support

2006-09-28 Thread Magnus Hagander
2) If I were willing to add a GSSAPI or SASL layer as an alternative to the bare Krb 5 support would anyone be willing to help with the supporting mods to the pg_hba.conf parsing, and configure? Sure, I can help out with that. I've done a bunch of work on the current kerberos stuff (tohugh

Re: [HACKERS] New version of money type

2006-09-28 Thread Luke Lonergan
Martijn, On 9/28/06 12:42 PM, Martijn van Oosterhout kleptog@svana.org wrote: - Only supports one currency (dollars) What are the manifestations of this? - Only supports one scale (yen has no decimal normally, but what if you want to track hundredths of a dollar-cent?) So, without a

Re: [HACKERS] New version of money type

2006-09-28 Thread Martijn van Oosterhout
On Thu, Sep 28, 2006 at 01:29:57PM -0700, Luke Lonergan wrote: Martijn, On 9/28/06 12:42 PM, Martijn van Oosterhout kleptog@svana.org wrote: - Only supports one currency (dollars) What are the manifestations of this? test=# select '100'::money; money - $100.00 (1 row) The

[HACKERS] Darwin stuff is getting deprecated

2006-09-28 Thread Tom Lane
With the latest Apple developers' tools, I get some warnings that weren't there before: dynloader.c: In function 'pg_dlsym': dynloader.c:44: warning: 'NSIsSymbolNameDefined' is deprecated (declared at /usr/include/mach-o/dyld.h:150) dynloader.c:46: warning: 'NSLookupAndBindSymbol' is deprecated

Re: [HACKERS] JAVA Support

2006-09-28 Thread Henry B. Hotz
On Sep 28, 2006, at 12:42 PM, Magnus Hagander wrote: 2) If I were willing to add a GSSAPI or SASL layer as an alternative to the bare Krb 5 support would anyone be willing to help with the supporting mods to the pg_hba.conf parsing, and configure? Sure, I can help out with that. I've done a

Re: [HACKERS] New version of money type

2006-09-28 Thread D'Arcy J.M. Cain
On Thu, 28 Sep 2006 11:39:31 -0700 Luke Lonergan [EMAIL PROTECTED] wrote: Numeric has been shown to be as good or better than money in I/O operations. What exactly does that mean in the context of a Datum: I/O operations? It means that numeric is better and parsing/storing/displaying than

Re: [HACKERS] JAVA Support

2006-09-28 Thread Magnus Hagander
As for the other part - will core accept this - I can't answer that. I do beleive that there is a point to it, given that Java will then support it natively, but I'm not core. I'm unsure if there is a clear view on the merits of adding more authentication options.. From the lack

Re: [HACKERS] Darwin stuff is getting deprecated

2006-09-28 Thread AgentM
The regular dlfcn family of functions are now properly implemented on Darwin (10.4+). Re: Zeroconf- Avahi is API+ABI compatible with the Apple API, so its use would be preferable on Linux (for cross-platform considerations). http://avahi.org/browser/trunk/avahi-compat-libdns_sd [Warning:

Re: [HACKERS] New version of money type

2006-09-28 Thread D'Arcy J.M. Cain
On Thu, 28 Sep 2006 22:53:34 +0200 Martijn van Oosterhout kleptog@svana.org wrote: Every new type needs to have a well-defined use-case before it can be considered for includion. Well, it is already included. The current proposal is simply to improve the existing type. I guess you are arguing

Re: [HACKERS] JAVA Support

2006-09-28 Thread Tom Lane
Magnus Hagander [EMAIL PROTECTED] writes: As for the other part - will core accept this - I can't answer that. It would depend in part on the size of the patch, and on whether there are any arguments for supporting GSSAPI besides Java can't do Kerberos. What would it buy for a libpq user?

Re: [HACKERS] JAVA Support

2006-09-28 Thread Magnus Hagander
As for the other part - will core accept this - I can't answer that. It would depend in part on the size of the patch, and on whether there are any arguments for supporting GSSAPI besides Java can't do Kerberos. What would it buy for a libpq user? I don't know, really ;-) It seems we're

Re: [HACKERS] JAVA Support

2006-09-28 Thread Josh Berkus
Kris, I would if we could get some -hackers buy in on the idea. Adding more and more auth methods is something they're not excited about unless there's a good reason (which I think this is). Actually, I've been trying to get some of the Sun engineers to contribute patches for Solaris

Re: [HACKERS] JAVA Support

2006-09-28 Thread Josh Berkus
Tom, It would depend in part on the size of the patch, and on whether there are any arguments for supporting GSSAPI besides Java can't do Kerberos. What would it buy for a libpq user? According to the Solaris Security engineers, GSSAPI is more secure than using the Kerberos headers. Also,

[HACKERS] Patch: Tie stats options to autovacuum in postgresql.conf

2006-09-28 Thread David Wheeler
PostgreSQLers, I just ran into an issue where a client thought that autovacuum was running but it wasn't. This is because it's not fatal when autovacuum is on but stats_start_collector and/or stats_row_level is off. I suspect that there's a reason that it's not fatal, so I thought that

Re: [HACKERS] Row IS NULL question

2006-09-28 Thread Gevik Babakhani
I wrote: Moving makeRowNullTest() doesn't seem like a big deal, but changing ExecEvalNullTest would take some added code. Do we want to tackle that during beta, or hold off till 8.3? An argument for doing it now is that we just added nulls-in-arrays in 8.2, and it'd be good if the

Re: [HACKERS] JAVA Support

2006-09-28 Thread Henry B. Hotz
On Sep 28, 2006, at 2:24 PM, Tom Lane wrote: Magnus Hagander [EMAIL PROTECTED] writes: As for the other part - will core accept this - I can't answer that. It would depend in part on the size of the patch, and on whether there are any arguments for supporting GSSAPI besides Java can't do

Re: [HACKERS] JAVA Support

2006-09-28 Thread Henry B. Hotz
I cc'ed Tom Lockhart because he *used* to be core, and I know where he works. No response expected. On Sep 28, 2006, at 2:11 PM, Magnus Hagander wrote: f) SASL support is available in current Java as well as C. SASL libraries are included (or at least loadable) on MacOS, Solaris 10+, and

Re: [HACKERS] JAVA Support

2006-09-28 Thread Henry B. Hotz
On Sep 28, 2006, at 3:03 PM, Josh Berkus wrote: Tom, It would depend in part on the size of the patch, and on whether there are any arguments for supporting GSSAPI besides Java can't do Kerberos. What would it buy for a libpq user? According to the Solaris Security engineers, GSSAPI is

Re: [HACKERS] Numeric overflow problem + patch

2006-09-28 Thread Tom Lane
David Fetter [EMAIL PROTECTED] writes: ! DETAIL: A field with precision 4, scale 4 must have an absolute value less than 1. [ becomes ] ! DETAIL: A field with precision 4, scale 4 must have an absolute value less than 1 - 5 * 10^-5. This strikes me as overly pedantic. The message needs

Re: [HACKERS] Numeric overflow problem + patch

2006-09-28 Thread Martijn van Oosterhout
On Thu, Sep 28, 2006 at 05:11:43PM -0400, Tom Lane wrote: David Fetter [EMAIL PROTECTED] writes: ! DETAIL: A field with precision 4, scale 4 must have an absolute value less than 1. [ becomes ] ! DETAIL: A field with precision 4, scale 4 must have an absolute value less than 1 - 5 *

Re: [HACKERS] Numeric overflow problem + patch

2006-09-28 Thread David Fetter
On Thu, Sep 28, 2006 at 05:11:43PM -0400, Tom Lane wrote: David Fetter [EMAIL PROTECTED] writes: ! DETAIL: A field with precision 4, scale 4 must have an absolute value less than 1. [ becomes ] ! DETAIL: A field with precision 4, scale 4 must have an absolute value less than 1 - 5 *

Re: [HACKERS] Numeric overflow problem + patch

2006-09-28 Thread David Fetter
On Thu, Sep 28, 2006 at 11:16:56PM +0200, Martijn van Oosterhout wrote: On Thu, Sep 28, 2006 at 05:11:43PM -0400, Tom Lane wrote: David Fetter [EMAIL PROTECTED] writes: ! DETAIL: A field with precision 4, scale 4 must have an absolute value less than 1. [ becomes ] ! DETAIL: A

Re: [HACKERS] New version of money type

2006-09-28 Thread Jim C. Nasby
On Thu, Sep 28, 2006 at 05:19:47PM -0400, D'Arcy J.M. Cain wrote: On Thu, 28 Sep 2006 22:53:34 +0200 Martijn van Oosterhout kleptog@svana.org wrote: Every new type needs to have a well-defined use-case before it can be considered for includion. Well, it is already included. The current

Re: [HACKERS] Patch: Tie stats options to autovacuum in postgresql.conf

2006-09-28 Thread Jim C. Nasby
On Thu, Sep 28, 2006 at 03:07:39PM -0700, David Wheeler wrote: PostgreSQLers, I just ran into an issue where a client thought that autovacuum was running but it wasn't. This is because it's not fatal when autovacuum is on but stats_start_collector and/or stats_row_level is off. I

Re: [HACKERS] Patch: Tie stats options to autovacuum in postgresql.conf

2006-09-28 Thread David E. Wheeler
On Sep 28, 2006, at 16:39, Jim C. Nasby wrote: +1. I was just at a client today that had run into this problem. Actually, I'm in favor of refusing to start if autovac is on but the proper stats settings aren't. I'd rather that then people ending up with bloated databases and crappy

Re: [HACKERS] JAVA Support

2006-09-28 Thread Josh Berkus
Henry, Sun demonstrated that you could build the existing Kerberos support with the current Solaris 11 beta's. They opened the native MIT Kerberos API for outside use. Yes, and this will be available via the supported version in Solaris 10 Update 4. However, that doesn't change that some

Re: [HACKERS] JAVA Support

2006-09-28 Thread Henry B. Hotz
On Sep 28, 2006, at 3:01 PM, Josh Berkus wrote: Kris, I would if we could get some -hackers buy in on the idea. Adding more and more auth methods is something they're not excited about unless there's a good reason (which I think this is). Actually, I've been trying to get some of the Sun

Re: [HACKERS] Patch: Tie stats options to autovacuum in postgresql.conf

2006-09-28 Thread Florian G. Pflug
Jim C. Nasby wrote: On Thu, Sep 28, 2006 at 03:07:39PM -0700, David Wheeler wrote: PostgreSQLers, I just ran into an issue where a client thought that autovacuum was running but it wasn't. This is because it's not fatal when autovacuum is on but stats_start_collector and/or stats_row_level

Re: [HACKERS] New version of money type

2006-09-28 Thread Tom Lane
Jim C. Nasby [EMAIL PROTECTED] writes: On Thu, Sep 28, 2006 at 05:19:47PM -0400, D'Arcy J.M. Cain wrote: Well, it is already included. The current proposal is simply to improve the existing type. I guess you are arguing a different proposal altogether - to remove the existing type. The

Re: [HACKERS] JAVA Support

2006-09-28 Thread Tom Lane
Josh Berkus josh@agliodbs.com writes: However, that doesn't change that some people would like us to support GSSAPI, and there may be some benefit (additional applications, better network authentication, etc.) for doing so. If we can get additional programmers to code the support (i.e. Sun,

Re: [HACKERS] New version of money type

2006-09-28 Thread Jim C. Nasby
On Thu, Sep 28, 2006 at 11:23:30PM -0400, Tom Lane wrote: Jim C. Nasby [EMAIL PROTECTED] writes: On Thu, Sep 28, 2006 at 05:19:47PM -0400, D'Arcy J.M. Cain wrote: Well, it is already included. The current proposal is simply to improve the existing type. I guess you are arguing a different

Re: [HACKERS] New version of money type

2006-09-28 Thread Tom Lane
Jim C. Nasby [EMAIL PROTECTED] writes: I think it's also important to protect for the possibility of a more complete (and probably incompatible) type in the future, such as one that stores what currency a value is in. Well, such a type could be called currency, cash, forex or several other

Re: [HACKERS] Another idea for dealing with cmin/cmax

2006-09-28 Thread ITAGAKI Takahiro
Jim C. Nasby [EMAIL PROTECTED] wrote: The reason I thought of this is because once the transaction commits, we have no use for the cid info. So we could do something like have bgwriter look for tuples that belong to committed transactions before it writes a page, and strip the cid out of

Re: [HACKERS] JAVA Support

2006-09-28 Thread Joshua D. Drake
Josh Berkus wrote: Henry, Sun demonstrated that you could build the existing Kerberos support with the current Solaris 11 beta's. They opened the native MIT Kerberos API for outside use. Yes, and this will be available via the supported version in Solaris 10 Update 4. However,

Re: [HACKERS] JAVA Support

2006-09-28 Thread Tom Lane
Joshua D. Drake [EMAIL PROTECTED] writes: Is there any reason why we haven't built a generic authentication API? Something like PAM, except cross platform? We're database geeks, not security/crypto/authentication geeks. What makes you think we have any particular competence to do the above?

Re: [HACKERS] JAVA Support

2006-09-28 Thread Joshua D. Drake
Tom Lane wrote: Joshua D. Drake [EMAIL PROTECTED] writes: Is there any reason why we haven't built a generic authentication API? Something like PAM, except cross platform? We're database geeks, not security/crypto/authentication geeks. What makes you think we have any particular competence