PostgreSQL Database Forum

subscribe end i am getting this error org.apache.jasper.JasperException: ERROR: current transaction is aborted, queries ignored until end of transaction block Please help

Hello, a question about a tool or a possibility how could something work. following situation: we have a database which is full of very sensitive information and needed that db to use our online website. but now we move the website to a server outside our office and needed to replicate only some datas to the online db. with the tool slony i...

Regardi I recently compile Postgresql 7.4.3 with gcc 3.4.0 on RH 7.3 . Regression tests work well All passed, but Some binaries report a relocation error: :pg_dumpall undefined symbol get_progname . This error occures in most of the binaries. What is wrong ?

Hi, I have a set of libraries and C/C++ programs with embedded access to a PG database. I'm using ecpg. I'm working on a Linux RedHat9 platform. Until now I was in PG 7.4.2 : $ ecpg --version ecpg (PostgreSQL 7.4.2) 3.1.1 $ g++ --version g++ (GCC) 3.2.2 20030222 (Red Hat Linux 3.2.2-5)

I have an embedded system running FreeBSD (5.1) that does not have any local (rotating) storage (i.e disk drives). PostgreSQL also runs on this box and (at this point) has two tables. It is an extremely simple PostgreSQL configuration with the tables having less than 20 fields each, and no relations between the tables. However, because...

Hi, I am new to Unix systems. I am getting the following error when trying to access the database through psql: $ psaql mydatabase $ psql: can't load library 'libpq.so.3.0' The psql was working fine until restarted the postmaster after setting the configurations for tcp/ip to true in the postgreSQL.conf

Tom Lane, This problem was solved with the suggested permission. GRANT USAGE ON SCHEMA wlog_data TO wlog_uni; There is the possibility of us to consult the permission above in the database? Thanks very much,

Hi, I think when search terms have "."s in them they become case sensitive in tsearch searches. How can we make them insensitive? Regds Mallah.

Hi, we are using Postgres with a J2EE application (JBoss) and get intermittent "out of memory" errors on the Postgres database. We are running on a fairly large Linux server (Dual 3GHz, 2GB Ram) with the following parameters: shared_buffers = 8192 sort_mem = 8192 effective_cache_size = 234881024

hello, is there a way to do backup and restore just with the use of jdbc? greetings hans ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?

I am moving my database from a machine running 7.4 to a machine running 7.2. My sequences are not out of wack, is there a way to set the current value of a sequence? I though ALTER SEQUENCE would work but it does not exist in version 7.2. Thanks, ~S

Greetings! Just trying some tests out, and wanted to know about some optimizations. If I do a CHECK constraint on a table, is this used to optimize a SELECT or does Postgresql rely mostly on normal index search? For example, I want to create some tables to manage different data in a kind of <object, relationship, object2> manner, but...

Hi, I am just wondering if bytea functions (byteaeq, byteage,byteagt,...) will be included in the offical document and assumed to be supported in future release. For now, I could only find them in release 7.2 note. Your confirmation reply is appreciated. Thanks! Eric

Hi, i use Access as a frontend via ODBC to an Linux-based postgresql. I have a problem in a form where I use a lot of subforms. In some cases ( i couldn't detect when - but I really try to) the form and Access hangs. The only way to close the form is to close Access via "cross" (upper right corner). If I try then to view once again the...

I'm doing a bunch of data mining against a postgres database and have run into an interesting problem with deadlocks. The problem is, postgres is detecting them and then wacking the offending process, and I can't figure out what's causing them. I have a ton of select queries (but none for update), and then a single query to insert into a...

Hi, I've been playing about with array's, and found the concat operator '||' quite useful, apart from the fact that prepending an element places it in a lower subscript. Is there a way of either: a) prepending an element, but shifting existing elements up a subscript, so that the lower bound remains the same? eg: 1 ||> ARRAY -- new...

I have created a web app that stores and displays all the messages from my database maintenance jobs that run each night. The web app uses Java servlets and has PostgreSQL 7.0 as the back end. When the user requests the first page, he gets a list of all the servers with maintenance records in the database, and a drop down list of all...

I have the need to output intervals (ages in this case). PostgreSQL takes great care to handle months correctly (eg take into account varying months lengths). This is only possible if either end point or start point of an interval are known. For post processing some of the ambiguity of what "2 mons" means would be removed if "61 days" was...

Hi, I just see that Mysql will propose at the end of the month a full synchronous replication system with auto-recovery. http://www.mysql.com/products/cluster/ We need to see when stable version would be released..... I use PostgreSQL and I would appreciate to have the same features in PostgreSQL.

Hi There is question. I have column name_my varchar (not array) in table1, and column name_my_ref varchar (array) in other table2. I want set Foreign Key on name_my_ref and every element in the same row of array must match any element in name_my. How can I do this? ---------------------------(end of...

Hi There is question. Does postgres 7.4 support now such expressions with array and regex? select * from my_table where '%Petrov%' ~ any ("surname"); or select * from my_table where '%Petrov%' = any ("surname"); --where column surname is varchar . ---------------------------(end of broadcast)--------------------------- TIP 5: Have you...

Greetings, I've got an annoying problem. I'm currently running PostgreSQL-7.3.4 on Linux (x86). This problem started with 7.3.3. I've got a database that is on the larger side (about 3GB dump). I run "vacuumdb -z -a -f" religiously via a cronjob three times a day. All of a sudden last month (after about 3 years) I started getting this...

Hello, I've a strange problem with inheritance on PostgreSQL 7.4.1. It seems like tables don't inherits the primary key of the 'mother' table. Here's a little sample to show my problem : CREATE TABLE foo_a ( pk_idmyfoo INT2 PRIMARY KEY NOT NULL, myfoo_name VARCHAR(10)

Hello all, Is it possible that we setup the password in the pg_dump command line instead of let users input it through prompt command. E.g., pg_dump test -c -d --host=localhost -U testUser1 --file='a.dmp' --no-privileges Thanks a lot! Ly

Hi @ all, I'v noticed if you kill -9 the Postmaster Temporary Tables (Shemas) will stay in the DB also a VACUUM FULL will not remove them after restart. Daniel. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?