RE: [GENERAL] PostgreSQL the BSD License

2000-07-10 Thread The Hermit Hacker
On Mon, 10 Jul 2000, Philip Warner wrote: At 08:24 10/07/00 -0400, Robert D. Nelson wrote: Stupid question time: BSD allows forking of the code base, perhaps to proprietary. If going proprietary, I would imagine you could change the license. So why can't we have a "license fork"?

[GENERAL] [NOVICE] newbie problem on creating table

2000-07-10 Thread Thomas Krebs
I am trying to get a start with Postgres 6.4 on Suse Linux 6.4. I did that just 2 weeks ago. and it works? I created a superuser who is allowed to create databases.I created a user and a database, but I didn't manage so far to create a table. like : $ psql -c "create table test ( a int,

[GENERAL] newbie problem on creating table

2000-07-10 Thread Thomas Krebs
I am trying to get a start with Postgres 6.4 on Suse Linux 6.4. I created a superuser who is allowed to create databases. I created a user and a database, but I didn't manage so far to create a table. It just returns "Error cannot create tablename. The owner of your database might

Re: [GENERAL] Problems installing pltcl

2000-07-10 Thread Peter Keller
Peter Eisentraut wrote: I tried to install PostgreSQL 7.0.2. Everything looked fine but the file 'pltcl.so' was not installed. But this is needed for creating functions in TCL! What did I make wrong? We need more information than that, in particular the make output. OK, here are more

Re: [GENERAL] Slashdot discussion

2000-07-10 Thread Bruce Momjian
P.S. My tolerance is negligible for anything that goes "beep" the way mysql insists on doing when giving error messages. Like anyone needs that when they're trying to figure out SQL syntax! Having to figure out SQL syntax is pennance enough, surely ... MySQL beeps at you on an error. Ewe.

[GENERAL] Backends don't die

2000-07-10 Thread Rémy Dufour
Hi there, I'm runningpostgres 6.5 under Linux RedHat 6.2. I've got a NT logging via ODBC on my Pg database and it seems that backends connections dont die... I have set MAX_BACKENDS up to 1000 ! but after a while, i got an error message indicating "Maximum number of connections exeeded".

RE: [GENERAL] PostgreSQL the BSD License

2000-07-10 Thread Philip Warner
At 10:36 10/07/00 -0400, Robert D. Nelson wrote: I'll ask, but I think he'll say that the license applies to the source; if a commercial fork was made, then they are free to hide the source. But if they ever release the source, then it has to go under the BSD again. What I was asking was, if

Re: [GENERAL] [NOVICE] newbie problem on creating table

2000-07-10 Thread Tom Lane
"Thomas Krebs" [EMAIL PROTECTED] writes: It just returns "Error cannot create tablename. I believe this error indicates that the kernel rejected Postgres' attempt to create a file for the new table. Unfortunately we can't see the exact kernel error message (that's fixed for 7.1, but it won't

[GENERAL] moving from mySQL to pgsql, need a bit of help (perl)

2000-07-10 Thread Matt Housh
Hello, I'm trying to move from mySQL to PostgreSQL, and I've got to port a web app over that's written in perl. It uses the DBD/DBI stuff, and works great so far with mySQL. I've got a very specific question relating to pulling data out of a database, I hope this is the correct forum for

Re: [GENERAL] moving from mySQL to pgsql, need a bit of help (perl)

2000-07-10 Thread Ed Loehr
Matt Housh wrote: In my current code (perl/mySQL), I execute the following query: "SELECT * from table_name" - then use the following code to put it in a hash: $j = 0; while (@row = $sth-fetchrow_array) { for ($i = 0; $i $fields; $i++) {

RE: [GENERAL] PostgreSQL the BSD License

2000-07-10 Thread Robert D. Nelson
no they can't ... they can add to the current license, but they can't remove it ... Okay, well that is what's wanted, correct? Or am I reading the mail wrong? Rob Nelson [EMAIL PROTECTED]

[GENERAL] Re: Slashdot discussion

2000-07-10 Thread Philip Hallstrom
In article [EMAIL PROTECTED], Chris Bitmead [EMAIL PROTECTED] wrote: Graeme Merrall wrote: Without wanting to starta thread war I think postgres is great, but for many people the learning curve is too great and thus MySQL is a good introduction. In what way is mysql easier to learn? I think

RE: [GENERAL] PostgreSQL the BSD License

2000-07-10 Thread The Hermit Hacker
On Mon, 10 Jul 2000, Robert D. Nelson wrote: no they can't ... they can add to the current license, but they can't remove it ... Okay, well that is what's wanted, correct? Or am I reading the mail wrong? I've contacted the University of California "licensing director" about upgrading our

Re: [GENERAL] ODBC drivers for linux

2000-07-10 Thread Matt Goodall
Trond Eivind Glomsrød wrote: Kevin Heflin [EMAIL PROTECTED] writes: I've used postgresql for a few years, running on Linux.. using PHP with apache to connect to postgresql.. after finding an ODBC drivers for use on windowsNT, I also use PHP and tango with IIS to connect to postgresql

[GENERAL] Re: PostgreSQL and Windows NT

2000-07-10 Thread nsrona
Should work under NT. Check out postgresql.org for instructions. For NT, the server-side port of Postgres uses RedHat/Cygnus Cygwin toolset. For Windows 9x, only a client odbc connection can be made. Never done odbc calls to an NT postgres server, but I have made odbc request to a Linux Box

[GENERAL] [Help] INSTALLing 7.02

2000-07-10 Thread D Herssein
Hi, If anyone out there would be so kind as to point out what may be the problem I would appreciate it immensely. (PS - I tried without the --with-CC and got the same error at the same place) ./configure --with-CC=/usr/opt/SUNWmd/sbin/cc loading cache ./config.cache checking host system

[GENERAL] images

2000-07-10 Thread Yves Dorfsman
Is it possible to save images in postgreSQL ?? If yes, and in the case of a web site using both postgrSQL and mod_perl, is it preferable (faster) to save images in the database, or to simply save a reference to the images in the database, but load the image from the filesystem ??? Yves.

[GENERAL] raw devices

2000-07-10 Thread Yves Dorfsman
Is there any way to use raw devices within postgreSQL, or does it support file system only ?? Is there any reason for not supporting raw device, or is it just a question of not having the time to write a driver ? Yves. Yves Dorfsman[EMAIL

[GENERAL] Another mySQL to PostgreSQL move question

2000-07-10 Thread Matt Housh
Does PostgreSQL support something like mySQL's auto_increment tag? For example, my entering "create table test (userid int default 0 not null auto_increment);" in mySQL creates a table with one field that automatically increments its value if none is specified. I have not been able to

Re: [GENERAL] Another mySQL to PostgreSQL move question

2000-07-10 Thread Ed Loehr
Matt Housh wrote: Does PostgreSQL support something like mySQL's auto_increment tag? See question 4.16.1 of http://www.postgresql.org/docs/faq-english.html Regards, Ed Loehr

Re: [GENERAL] Another mySQL to PostgreSQL move question

2000-07-10 Thread Matt Housh
See question 4.16.1 of http://www.postgresql.org/docs/faq-english.html Regards, Ed Loehr Once again, thanks Ed :) That's exactly what I needed. :) Matt

[GENERAL] Log files

2000-07-10 Thread Rémy Dufour
Hi there, Is there any way to open pg_log file ? Thanks! Remy DufourIT ProgrammerWebNet Inc - ISPremy.tech@webnet.qc.ca

Re: [GENERAL] raw devices

2000-07-10 Thread Joseph Shraibman
This seems to be coming up so often perhaps somebody should put it in the FAQ. The reason it doesn't support raw devices, according to a moderately long discussion not too long ago, is that with modern operating systems it is better to let the OS handle the low level stuff. Yves Dorfsman wrote:

[GENERAL] Hints about how to debug pg_dump problem?

2000-07-10 Thread Andrew Sullivan
Hi, I'm trying to move a database from a development machine onto a production machine. I seem to get good output from my pg_dump command, but when I read the resulting files, I can't get them to import everything. (FWIW, I'm moving from a Debian potato/woody combo onto a fresh Debian potato

[GENERAL] Using the JDBC Driver in version 7.02

2000-07-10 Thread Justin Jaynes
Hello. I am using Postgres 7.02 on my redhat linux box. I have installed the JDK and a JSP engine. I have also copied the JDBC level 4 Drivers that came with postgresql 7.02 onto my hard drive. When I try to interface with it in java, even after loading the driver with the line:

[GENERAL] dump files

2000-07-10 Thread Andrew Sullivan
Ok, so I really am even stupider than I look. I had a third look at the output from my attempted read, and finally noticed the permissions error early on which made everything fail. Sorry to be a bother. A -- Andrew Sullivan Computer Services [EMAIL

Re: [GENERAL] Using the JDBC Driver in version 7.02

2000-07-10 Thread Joseph Shraibman
You have to format your url properly so the java runtime can figure out what driver to use for the connection. Justin Jaynes wrote: Hello. I am using Postgres 7.02 on my redhat linux box. I have installed the JDK and a JSP engine. I have also copied the JDBC level 4 Drivers that came

Re: [GENERAL] Slashdot discussion

2000-07-10 Thread Peter Eisentraut
Bruce Momjian writes: OK, thanks to the www.phpbuilder.com PostgreSQL/MySQL comparison, there is another PostgreSQL/MySQL thread on shashdot.org. Looks interesting, and of course, we are looking good too. Is anyone else noticing this: Everytime this sort of thing comes up a number of people