Re: [HACKERS] Re: [PATCHES] Patch to include PAM support...

2001-08-24 Thread Tom Lane
"Dominic J. Eidson" <[EMAIL PROTECTED]> writes: >> Could we change the PAM code so that it tries to run the PAM auth cycle >> immediately on receipt of a connection request? If it gets a callback >> for a password, it abandons the PAM conversation, sends off a password >> request packet, and then

Re: [HACKERS] Re: [PATCHES] Patch to include PAM support...

2001-08-24 Thread Dominic J. Eidson
On Sat, 25 Aug 2001, Tom Lane wrote: > "Dominic J. Eidson" <[EMAIL PROTECTED]> writes: > >> Could we change the PAM code so that it tries to run the PAM auth cycle > >> immediately on receipt of a connection request? If it gets a callback > >> for a password, it abandons the PAM conversation, se

Re: [HACKERS] Does the oid column have an implicit index on it?

2001-08-24 Thread Tom Lane
Rachit Siamwalla <[EMAIL PROTECTED]> writes: > Every table has a implicit column oid. Does this column have an index on it? No, you must create an index if you want one. regards, tom lane ---(end of broadcast)--- TIP 1: sub

[HACKERS] MD5 for ODBC

2001-08-24 Thread Bruce Momjian
I am going to add MD5 authentication to ODBC. What is a good way to get backend/libpq/md5.c into odbc for compilation. I know people want the ODBC to be stand-alone. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If

[HACKERS] Does the oid column have an implicit index on it?

2001-08-24 Thread Rachit Siamwalla
This may sound like a stupid question, and i apologize if it is, but I couldn't find the answer in any documentation. Every table has a implicit column oid. Does this column have an index on it? I assume not, and I am putting an index on it anyway. The real problem is that I have a table like t

[HACKERS] Re: [PATCHES] encoding names

2001-08-24 Thread Peter Eisentraut
Tatsuo Ishii writes: > > Maybe we should not touch getdatabaseencoding() right now, given that the > > names we currently use are apparently almost correct anyway and > > considering the pain it creates to alter them, and instead implement the > > information schema views in the future? > > I tho

Re: [HACKERS] Toast, Text, blob bytea Huh?

2001-08-24 Thread Jan Wieck
Peter T Mount wrote: > Quoting Joe Conway <[EMAIL PROTECTED]>: > > > TEXT is a datatype which stores character data of unspecified length (up > > to > > the max value of a 4 byte integer in length, although I've seen > > comments > > indicating that the practical limit is closer to 1 GB -- not sur

Re: [HACKERS] Re: [JDBC] New backend functions?

2001-08-24 Thread Ned Wolpert
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Sounds like there aren't objections to my requested function, get_last_returned_oid(). I'm going to work on the function call for postgres this weekend. Purpose: Retain the last oid returned (if any) in a variable associated with the conn

Re: [OT] [HACKERS] Re: List response time...

2001-08-24 Thread David Ford
Vince Vielhaber wrote: >On Fri, 24 Aug 2001, David Ford wrote: > >>It's all in the configuration. I slam mails around dozens of machines >>in seconds using sendmail and I process a lot of mail. >> > >So have you patched for the latest of the many sendmail root exploits? > >Vince. > I keep my sy

Re: [HACKERS] PATCH proposed with new features for CREATE TABLE

2001-08-24 Thread Stephan Szabo
On Fri, 24 Aug 2001, Bruce Momjian wrote: > Can someone comment on this? I sent him some concerns I had (including the fact that we can't rename ON UPDATE since it's in the spec). I'm working through some more behavioral concerns I have, but I haven't decided whether or not they're actually pro

RE: [HACKERS] User locks code

2001-08-24 Thread Mikheev, Vadim
> So, rather than going over everone's IANAL opinons about mixing > licenses, let's just let Massimo know that it'd just be a lot > easier to PostgreSQL/BSD license the whole thing, if he doesn't > mind too much. Yes, it would be better. Vadim ---(end of broadcast)--

Re: [HACKERS] User locks code

2001-08-24 Thread Ross J. Reedstrom
Uh, guys? The last thing I can find that Massimo says about the license is this, from Sunday: On Sun, Aug 19, 2001 at 11:15:54PM +0200, Massimo Dal Zotto wrote: > > Regarding the licencing of the code, I always release my code under GPL, > which is the licence I prefer, but my code in the backen

Re: [HACKERS] User locks code

2001-08-24 Thread Oliver Elphick
Bruce Momjian wrote: ... >Yes, that is probably it. The GPL doesn't give anything to users, it >takes some control away from users and gives it to the author of the >code. Correction - it takes away from the *distributor* of binaries the right to give users fewer rights than he has. If he

RE: [OT] Re: [HACKERS] User locks code

2001-08-24 Thread Mikheev, Vadim
> Because the code we got from Berkeley was BSD licensed, we > can't change it, and because many of us like the BSD license > better because we don't want to require them to release the > source code, we just want them to use PostgreSQL. And we > think they will release the source code eventually

Re: [HACKERS] User locks code

2001-08-24 Thread Bruce Momjian
> Bruce Momjian <[EMAIL PROTECTED]> writes: > > > > Tom Lane wrote: > > > > > > > > I definitely agree with Vadim here: it's fairly silly that the > > > > contrib userlock code is GPL'd, when it consists only of a few dozen > > > > lines of wrapper for the real functionality that's in the main b

RE: [HACKERS] User locks code

2001-08-24 Thread Mikheev, Vadim
> > Besides, anyone who actually wanted to use the userlock > > code would need only to write their own wrapper functions > > to get around the GPL license. > > This is a part of copyright law that eludes me - can i write > a replacement function for something so simple that it can > essentially

Re: [HACKERS] ERP Applications on Postgresql -- ERPTool

2001-08-24 Thread Amandeep Singh
Hi Justin, Andrew, I am making doing some essential face lift on it right now, Once I am done I will send you the URL. Amandeep --- Justin Clift <[EMAIL PROTECTED]> wrote: > Hi Amandeep, > > Do you have an URL for your application? > > :-) > > Regards and best wishes, > > Justin Clift > > >

Re: [HACKERS] CURRENT OF cursor without OIDs

2001-08-24 Thread Mikheev, Vadim
> Oops I'm referring to client side cursors in our ODBC > driver. We have no cross-transaction cursors yet though > I'd like to see a backend cross-transaction cursor also. Ops, sorry. BTW, what are "visibility" rules for ODBC cross-tx cursor? No Repeatable reads, no Serializability? Do you hold s

[OT] Re: [HACKERS] User locks code

2001-08-24 Thread Serguei Mokhov
- Original Message - From: Bruce Momjian <[EMAIL PROTECTED]> Sent: Friday, August 24, 2001 10:42 AM > > I really think that mixing licences inside one program is bad, if not > > for > > any other reason then for confusing people and making them have > > discussions > > like this. > >

[OT] Re: [HACKERS] User locks code

2001-08-24 Thread Serguei Mokhov
- Original Message - From: Bruce Momjian <[EMAIL PROTECTED]> Sent: Friday, August 24, 2001 10:42 AM > > I really think that mixing licences inside one program is bad, if not > > for > > any other reason then for confusing people and making them have > > discussions > > like this. > >

Re: [HACKERS] Toast, Text, blob bytea Huh?

2001-08-24 Thread Bruce Momjian
> No, that's just a coincidence. The reason that TOAST limits fields to > 1Gb is that the high-order two bits of the varlena length word were > commandeered as TOAST state indicators. There are now only thirty bits > available to represent the length of a variable-length Datum; hence the > hard

Re: [HACKERS] PATCH proposed with new features for CREATE TABLE

2001-08-24 Thread Bruce Momjian
Can someone comment on this? > Hi people!.I developed a work for an university course, which I wish to share with >you. > > I extended the foreign key clause in the create table in order to permit insertions >and updates on a referencing table (a table with foreign key > attributes) with all

Re: [HACKERS] libpq.dll & psql.exe on Win32

2001-08-24 Thread Bruce Momjian
I have applied the attached patch that is basically your patch with Tom's suggestion to use HAVE_UNIX_SOCKETS. > Hi, > > There are two problems when compiling libpq.dll and psql.exe > on Windows. I'm not sure it is the best way to fix them > (see patch below.) Comments? > > Regards, > Mikhai

Re: [HACKERS] User locks code

2001-08-24 Thread Trond Eivind Glomsrød
Bruce Momjian <[EMAIL PROTECTED]> writes: > > Tom Lane wrote: > > > > > > I definitely agree with Vadim here: it's fairly silly that the > > > contrib userlock code is GPL'd, when it consists only of a few dozen > > > lines of wrapper for the real functionality that's in the main backend. > > >

Re: [OT] Re: [HACKERS] User locks code

2001-08-24 Thread Bruce Momjian
> > Yes, the weird part is that the BSD license is so lax (don't sue us) > > that it is the addition of the GPL that changes the affect of the > > license. If you added a BSD license to a GPL'ed piece of code, the > > effect would be near zero. > > Sorry for asking this off-topic question, but I

[HACKERS] /bin/ld -G vs /usr/ccs/bin/cc -G

2001-08-24 Thread Larry Rosenman
I noticed while testing the preceeding patch for resultmap, that we use /bin/ld -G to build the .so's. THIS DOESN'T WORK on UnixWare and OpenUNIX 8. Where can I change this to use cc -G? Larry -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812

Re: [HACKERS] User locks code

2001-08-24 Thread Hannu Krosing
Bruce Momjian wrote: > > > > > This is a part of copyright law that eludes me - can i write a > > replacement > > function for something so simple that it can essentially be done in one > > way only (like incrementing a value by one) ? > > Sure, if you don't cut and paste the code line by line,

Re: [HACKERS] A couple items on TODO

2001-08-24 Thread Bruce Momjian
> That's good information, now I have a better idea what I am looking for. I am > using Source Navigator (good recommendation I got reading this list). I am > basically just trying to find either variables that can be declared const, or > inconsistancies (as Chris mentions). > > If anyone else

Re: [HACKERS] Toast, Text, blob bytea Huh?

2001-08-24 Thread Tom Lane
Peter T Mount <[EMAIL PROTECTED]> writes: > Quoting Joe Conway <[EMAIL PROTECTED]>: >> indicating that the practical limit is closer to 1 GB -- not sure why). > It may be something to do with the 1Gb splitting of the physical files > representing a table... No, that's just a coincidence. The r

Re: [HACKERS] Changelog and 7.1.3 release

2001-08-24 Thread Peter Eisentraut
Bruce Momjian writes: > Can I ask why we are mentioning the changelog for the release and not > the list from the HISTORY file? Any why are we putting the changelog in > the tarball anyway? Seems that could easily go on a web site. The point of these changelogs was to show the changes between

Re: [HACKERS] User locks code

2001-08-24 Thread Bruce Momjian
> Tom Lane wrote: > > > > I definitely agree with Vadim here: it's fairly silly that the > > contrib userlock code is GPL'd, when it consists only of a few dozen > > lines of wrapper for the real functionality that's in the main backend. > I was incorrect in something I said to Vadim. I said s

Re: [HACKERS] A couple items on TODO

2001-08-24 Thread Peter Eisentraut
Tom Lane writes: > Yeah, people have started to use 'const' in new code, but the older > stuff doesn't use it, which means that the net effect is probably > more annoyance than help. I'm afraid that if we attack this in an > incremental way, we'll end up with code that may have a lot of const >

[HACKERS] Re: [PATCHES] encoding names

2001-08-24 Thread Bruce Momjian
> > > BTW, what's wrong with "encoding"? I don't think, for example EUC-JP > > > or utf-8, are character set names. > > > > Hmm, SQL talks of character sets, it has a CHARACTER_SETS view and such. > > It's slightly incorrect, I agree. > > > > Maybe we should not touch getdatabaseencoding() right

Re: [HACKERS] Toast, Text, blob bytea Huh?

2001-08-24 Thread Peter T Mount
Quoting Joe Conway <[EMAIL PROTECTED]>: > TEXT is a datatype which stores character data of unspecified length (up > to > the max value of a 4 byte integer in length, although I've seen > comments > indicating that the practical limit is closer to 1 GB -- not sure why). It may be something to do

[HACKERS] Fully qualified column names

2001-08-24 Thread Dave Cramer
This is from the jdbc list. Is there any way to get fully qualified column names? Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Ben Carterette Sent: August 16, 2001 11:02 AM To: Rene Pijlman Cc: [EMAIL PROTECTED] Subject: Re: [JDBC] select on mul

[HACKERS] Ignore this ...

2001-08-24 Thread Marc G. Fournier
Just a test ... ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] Re: List response time...

2001-08-24 Thread Vince Vielhaber
On Fri, 24 Aug 2001, David Ford wrote: > It's all in the configuration. I slam mails around dozens of machines > in seconds using sendmail and I process a lot of mail. So have you patched for the latest of the many sendmail root exploits? Vince. --

Re: [HACKERS] ERP Applications on Postgresql -- ERPTool

2001-08-24 Thread Justin Clift
Hi Amandeep, Do you have an URL for your application? :-) Regards and best wishes, Justin Clift Amandeep Singh wrote: > > Hi Everyone, > Just wanted to let you all know that I have been > working on development of financial applications > using,java, javascript, javabeans and of course > Po

Re: [HACKERS] Re: List response time...

2001-08-24 Thread speedboy
> It's in the configuration. I run much more than the above and have no > issues at all. Yeah, some people shouldn't have root even if they own the machine. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgres