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
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
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
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
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
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:
Hi there,
Is there any way to open pg_log file ?
Thanks!
Remy DufourIT ProgrammerWebNet Inc -
ISPremy.tech@webnet.qc.ca
> 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
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
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
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]
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
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
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/
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
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
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
>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]
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]{$$
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
"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
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,
>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
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
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".
> 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
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
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.
---
> >
> > 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
> >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 (
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"?
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
32 matches
Mail list logo