[ADMIN] JDBC problem

I want to use JDBC with postgresql. I installed postgresql, and I tried a Java program from postgresql JDBC examples (called basic.java), but I get the error: Exception caught : java.lang.ClassNotFoundException: org.postgresql.Driver ,etc My CLASSPATH is ok I think. $ echo $CLASSPATH /usr/loc

[ADMIN] Starting postmaster problem

Hello, I installed Postgresql 7.0.2 on a Redhat Linux 6.1 and I want now to run it, but it seems I have a problem. I connected as root on my server. After that I do : $ su postgres $nohup /usr/local/pgsql/data \ >server.log 2>>1 & After the second command I get bash : server.log: Permission denied

[ADMIN] JDBC make problem

Hello, I tried to build the JDBC2 driver from Postgresql 7.0.2 distribution (/src/interfaces/jdbc), but I got errors : $ make jdbc2 jar (echo "package org.postgresql;" ;\ echo "public class DriverClass {" ;\ echo "public static String connectClass=\"org.postgresql.jdbc2.Connection\";" ;\ echo

Re: [ADMIN] readline support

Remove the config.cache and after that runn configure! Marcin Mazurek wrote: > Hi, > simple/stupid question, but can't figureout it myself: > Why can't it find radline headers files if they really are there? > pg7.0.2, Linux Debian 2.2 > mtldb:/usr/local/src/postgresql-7.0.2/src# ./configure >

[ADMIN] Text files question

Hi, How can I store text files in a Postgresql db? Is there a limit of chars? Thanx, Bogdan

[ADMIN] Storing data question

Hi all, I wonder if I can store the contents of a file ? For exmple I have a file named myfile.txt and I want to store everything that is in it in a table in a field of type text. Is this possible? Is there any SQL statement to perform that or some utility? Thanx, Bogdan

[ADMIN] Symbol problem

Hello , I made a tool with Java servlets and Postgresql. This tool inputs html text into a db. My problem is that everytime I input text that contains ' (apostrophe) I get an SQL exception. This Postgresql can't see by itself what is the difference ? I don't want to check every character, this

[ADMIN] Tuple problem

Hello folks, I have a web-tool that inputs text in a Postgresql table. This text is in a form. The problem is when I have a big text, I get this error : ERROR: Tuple is too big: size 13924, max size 8140 Can you help me? Thanx, Bogdan, >