Re: [HACKERS] SAPDB Open Souce

2001-04-28 Thread Horst Herb
> I downloaded it. The directories are two characters in length, the > files are numbers, and it is a mixture of C++, Python, and Pascal. Need > I say more. :-) 1.) What is wrong with a mixture of C++, Python and Pascal? Nothing IMHO. 2.) The directory structure is probably the consequence of

[HACKERS] Re: SAP-DB

2001-04-28 Thread Matthew N. Dodd
On Sat, 28 Apr 2001, Don Baccus wrote: > I humbly suggest you don't write them off quite so quickly. > > SAP is, after all, a very successful company. So is Microsoft. I got the between the lines part of Bruce's post and agree with him. -- | Matthew N. Dodd | '78 Datsun 280Z | '75 Volvo 164E

[HACKERS] Building Fault Tolerant/Failover PGSQL Systems

2001-04-28 Thread special agent
Hi, I'm new to postgresql...but so far i love it...after working with companies that have spent millions of dollars on the big "O" i must say pgsql is a breath of fresh air...nice work to all who contributed. I'm looking at building a fault tolerant/failover database [hot standby] system usin

[HACKERS] SAP-DB

2001-04-28 Thread Don Baccus
Hi guys, > > I've used the open source SAPDB and the performance is pretty damned > impressive. However, 'open source' in application to it is somewhat > deceptive, since you have to make it with SAP's proprietary build > tools/environment. > > In my opinion, however, it would be worth closely au

Re: [HACKERS] SAPDB Open Souce

2001-04-28 Thread Bruce Momjian
> Hi guys, > > I've used the open source SAPDB and the performance is pretty damned > impressive. However, 'open source' in application to it is somewhat > deceptive, since you have to make it with SAP's proprietary build > tools/environment. > > In my opinion, however, it would be worth closely

Re: [HACKERS] SAPDB Open Souce

2001-04-28 Thread Gavin Sherry
Hi guys, I've used the open source SAPDB and the performance is pretty damned impressive. However, 'open source' in application to it is somewhat deceptive, since you have to make it with SAP's proprietary build tools/environment. In my opinion, however, it would be worth closely auditing SAP DB

[HACKERS] Re: Struggling with c functions

2001-04-28 Thread mlw
You actually almost have it right. You are passing VARDATA(user) to crypt, this is wrong. You must do something like this: int ulen = VARSIZE(user)-VARHDRSZ; char utmp[ulen+]; // This works in newer GCC, cool. memcpy(utmp,VARDATA(user), len); utmp[ulen]=0; crypted=crypt(utmp,salt); Strings are

Re: [PATCHES] Re: [HACKERS] Support for %TYPE in CREATE FUNCTION

2001-04-28 Thread Bruce Momjian
> > Using %TYPE makes it easier to write a function which is independent > > of the definition of a table. That is, minor changes to the types > > used in the table may not require changes to the function. > > Wow! This would be _very_ useful! It's something I wish PostgreSQL > had and I

Re: [HACKERS] Re: v7.1.1 branched and released on Tuesday ...

2001-04-28 Thread Peter Eisentraut
Thomas Lockhart writes: > Nothing serious, but I would like to apply a patch to allow IDENT > strings (e.g. 'hour') to be accepted by the SQL92 EXTRACT() function. We > accept those for date_part(), which is what EXTRACT() is translated to > by the parser, and it seems to be a reasonable to the s

[HACKERS] PQftype()

2001-04-28 Thread Magnus Naeslund\(f\)
Where do get a listing of what PQftype() can return to me? (that is what type the field/col has, need a list of Oid's i believe) Magnus -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Programmer/Networker [|] Magnus Naeslund PGP Key: http://www.genline.nu/mag_pgp.txt -=-=-=-=-=-=-=-=-=-=-=

[HACKERS] Struggling with c functions

2001-04-28 Thread Olivier PRENANT
Hi all, I'm rewriting my OLD crypt (Thanks to Henrique) C_fonction to version 0 forms : I have this C file compiled OK to a shared library: /* * * Henrique Pantarotto ([EMAIL PROTECTED]) * Funcao para encriptar senhas (Function to encrypt passwords) * September 1999 * * PS: Note that all cr

[HACKERS] after changing login password (local), CPU always 100% !!

2001-04-28 Thread ÆøÇò
1) I login as administrator (local) at our SQL 2000 server. 2) change password for administrator 3) reboot server 4) login in as administrator (local) with new password 5) receive message "SQL Agent cannot start" because "login failure" 6) change password for administrator again back to previous o

[HACKERS] Re: WAL feature

2001-04-28 Thread Sergey E. Volkov
What about incremental backup ? "Bruce Momjian" <[EMAIL PROTECTED]> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > WAL was a difficult feature to add to 7.1. Currently, it is only used > as a performance benefit, but I expect it will be used in the futur

Re: [HACKERS] While we're on the subject of searches...

2001-04-28 Thread Brook Milligan
Over the past few months there've been a number of requests for an interactive type documentation setup like the folks at php.net have. Great to add to the documentation, but I hope the PostgreSQL project doesn't take it so far as to make the primary documentation interactive. A well-thoug

[HACKERS] RE:PAM Authentication for PostgreSQL...

2001-04-28 Thread Ryan M. Hager
Dominic, I like your idea. One of the benefits SQLServer 2000 is that I can assign a role in the database to a NT group. At that point, all I have to do is add a user to the group to be able to access that database. Would you solution include this scenario? This lets me assign all the resourc

[HACKERS] SAPDB Open Souce

2001-04-28 Thread Matthew
Slashdot just announced that SAP has released the souce for SAP DB under GPL. Not sure what this mean, or what people think, but I thought the hackers list might want to know. http://slashdot.org/developers/01/04/28/016220.shtml http://www.sap.com/solutions/technology/sapdb/develop/dev_sources.

Re: [HACKERS] Support for %TYPE in CREATE FUNCTION

2001-04-28 Thread Roberto Mello
On Fri, Apr 27, 2001 at 08:45:25PM -0700, Ian Lance Taylor wrote: > This patch adds support for %TYPE in CREATE FUNCTION argument and > return types. > > %TYPE is already supported by PL/pgSQL when declaring variables. > However, that does not help with the argument and return types in > CREATE F

[HACKERS] WAL performance with wal_sync_method = open_sync

2001-04-28 Thread Tatsuo Ishii
Hi, I'm playing with wal parameters and found that wal_sync_method = open_sync enormously enhance the performance on my machine. Without it (using default fsync) I got only 90 tps at the best using pgbench (-s 2). However if I set wal_sync_method = open_sync, I get ~200 tps. I have checked Postgr