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 peop

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 cam

[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 PROTEC

[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: Class.forN

[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 in

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] 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] 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

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

[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 dup

[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 PROTECTED]

[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. Yv

[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] 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 w/

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 po

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

[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 lea

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]

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++) >{ > $taghash[$j]{$$

[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] [NOVICE] newbie problem on creating table

2000-07-10 Thread Tom Lane
"Thomas Krebs" <[EMAIL PROTECTED]> writes: It just returns "Error cannot create . 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 help

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,

RE: [GENERAL] PostgreSQL & the BSD License

2000-07-10 Thread Robert D. Nelson
>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 someone forks the code base, aren't they allowed

RE: [GENERAL] PostgreSQL & the BSD License

2000-07-10 Thread The Hermit Hacker
On Mon, 10 Jul 2000, 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 wa

[GENERAL] Backends don't die

2000-07-10 Thread Rémy Dufour
Hi there,   I'm running postgres 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] 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. E

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

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

2000-07-10 Thread Travis Bauer
Does the database you created have the same name as the user executing the query you mentioned? I believe that, as given, psql will try to connect to a database having the same name as the login name of the user executing the statement. ---

[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 . > > The owner of your database migh

[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 (

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"?

RE: [GENERAL] PostgreSQL & the BSD License

2000-07-10 Thread Philip Warner
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"? > I'll ask, but I think he'll say that the license