Re: [ANNOUNCE] Re: [HACKERS] proposed improvements to PostgreSQL license

2000-07-03 Thread Jeroen Ruigrok/Asmodai
-On [2704 08:00], Thomas Lockhart ([EMAIL PROTECTED]) wrote: >> I think this is a bad idea for the following reasons: >> 1) It is trying to be a GPL in what it is trying to achieve without >> actually being well thought out. Any person who "submits" modifications >> must do so under the same l

Re: [GENERAL] psql dumps core

2000-07-03 Thread Tom Lane
"K. Ari Krupnikov" <[EMAIL PROTECTED]> writes: > psql on the clent machime aborts with this message: > psql:recreate-dbdom-db.pgsql:4: \connect: pqReadData() -- backend closed > the channel unexpectedly. > This probably means the backend terminated abnormally > before or while pro

Re: [GENERAL] Installing DBD::Pg

2000-07-03 Thread Philip Warner
At 15:17 4/07/00 +1000, Sean Carmody wrote: >perl -MCPAN -eshell. This failed and I got the message "please set >the environment variables POSTGRES_INCLUDE and POSTGRES_LIB!". I'm >not sure what to set these to, or even if this approach will work >given that I intalled via rpm rather than having t

[GENERAL] Installing DBD::Pg

2000-07-03 Thread Sean Carmody
Forgive any blatant ignorance, but maybe someone can help here. I've installed PostgreSQL 7.0 using the rpm on a Redhat 6.2 setup and was hoping to do a quick install of the Perl DBD::Pg module using perl -MCPAN -eshell. This failed and I got the message "please set the environment variables POS

[GENERAL] psql dumps core

2000-07-03 Thread K. Ari Krupnikov
Server Pstgres 7.0.2-2 Server RedHat 6.1 Client RedHat 6.2 I'm developing a database schema that changes frequently. I have a script that drops the database, then recreates it and creates tables and functions. I've been running this sscript for some time, but lately, psql on the clent machim

[GENERAL] Re: [HACKERS] proposed improvements to PostgreSQL license

2000-07-03 Thread Peter Eisentraut
Ned Lilly writes: > What we'd like to propose is a general tightening up of what the > existing license is *supposed* to be doing in the first place - In order to tighten up the license you'd need to get every developer past, present, and future to sign paperwork that they agree to this change.

[GENERAL] Can't Compile F_OIDEC

2000-07-03 Thread John Huttley
Hello I have RH6.2 with pg 6.5, which I wish to upgrade to 7.02 I installed the RPMS but then psql would not work. I gave a weird linker error. Then I tried to compile the SRPM. This fails with an Undefined symbol F_OIDEC in istrat.c line 494. Does anyone have a solution for this? Regards

Re: [GENERAL] Publishing my book

2000-07-03 Thread Bruce Momjian
> On 29 Jun 00, at 0:57, Bruce Momjian <[EMAIL PROTECTED]> wrote: > > > http://www.postgresql.org/docs/awbook.html > > Just curious.will the book always be available here, or will it > be taken down once the printed version appears? Good question. I think the book will always be here, bu

[GENERAL] proposed improvements to PostgreSQL license

2000-07-03 Thread Ned Lilly
Greetings all, I'm sending this to -announce, -hackers, and -general; apologies for the cross-post. Replies should automatically go to -general, which is the best forum for this discussion. But I wanted to make sure the largest possible audience of PostgreSQL users had a chance to comment... S

[GENERAL] ODBC and Connection staying open

2000-07-03 Thread Joseph
How can I tell Windows to close an ODBC connection? It seems like the 'idle' connections live forever and i have to manually kill the sessions. I am using NT/Foxpro with ODBC 6.5 for client and Linux with PostgreSQL 7.02 for server. Joseph

Re: [GENERAL] Large Tables(>1 Gb)

2000-07-03 Thread Stephan Szabo
You should probably be looking into cursors if you're attempting to grab a 1Gb result set, otherwise the system is going to try to pass the entire result set to the front end in one big lump, which is what you're probably seeing. I haven't played with them really, but probably something like...

[GENERAL] problems with transactions in C++Builder

2000-07-03 Thread igor
Greatings! Help me please to resolve my problem. As appeared, postgesql server doesn't rollback transaction in C++ Builder environment. May be sombody have an idea, how to make it work? The test source in the bottom of the letter. I will be very greatefull for any help. Igor.

Re: [GENERAL] trigger question

2000-07-03 Thread Anatoly K. Lasareff
> "m" == mikeo <[EMAIL PROTECTED]> writes: m> At 11:27 AM 6/27/00 -0400, Tom Lane wrote: >> mikeo <[EMAIL PROTECTED]> writes: >>> in oracle, the triggers were smart enough to know not to reference >>> an old value on insert in an "insert or update" trigger procedure, >>> apparently. >>