PostgreSQL Database Forum

Hi, I'm trying to call the array_to_string function like this : SELECT array_to_string(array, '~^~') --> it comes directly from the doc. I get this error msg : ERROR: parser: parse error at or near ", text) does not exist Unable to identify a function that satisfies the given argument types

Referential Integrity on one of our production tables seems to have been lost. I am running Postgres 7.1.3 embedded within Red Hat kernel-2.4.9-e.49. Within that I have a table with referential integrity constraints which no longer work. I do not know how to disable referential integrity on a column in a table. I do not know how to...

Hi, pgpool seems to be very nice. I will use it in production environment as soon as possible, but have a question regarding pgpool: I have four different databases/user combinations which should have different numbers of possible connection. let my db have 80 concurrent connections and i want to divide them like this: admin@db1 10

Hi: After upgrading 7.4.2 to 7.4.5 quite smoothly in a Red Hat 8.0 box, we are having intermitent issues with certain online PHP transactions, returning this error: "Warning: pg_exec() query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block" Half the times we run the query we get the error,...

Is there any on the site? Or I shall find in the tar file? Mage -- http://mage.hu ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate

I am trying to implement cursors using JDBC connector version 7.1b5 (postgresql-7.1b5.jar), but can't get it to work. Could anybody suggest the proper way to do it, or even some source code? I am stuck with this version and can't change it.

I have Postgres 8.0-beta2 set up on two machines (one Windows 2000 Server, the other Windows XP Pro); I have Postgres up and running as a service on both machines, no problem. I'm even able to go into psql and putz around. However, I am not able to log on remotely using pgAdmin III. Whenever I attempt to add a server, I get the following...

Hello, When I attempt to run 'createlang plpgsql template1' I get the following error: Error at or near "createlang" at character 1

Hello! I have 24/7 production server under high load. I need to perform vacuum full on several tables to recover disk space / memory usage frequently ( the server must be online during vacuum time ) The one trick that i see is to try to vacuum duplicate of production database ( or just some tables ). But there are some pitfalls:...

Hi, tonight my database got corruppted. before it worked fine. since two days i do the following tasks every night psql -c 'CLUSTER;' $DBNAME psql -c 'VACUUM FULL ANALYZE;' $DBNAME before these opertaions i stop all web access. The last months i only did a

What would be the recommended server specs to use for a postgresql database server that needs to be able to support upto 800 active connections at one time, searching a table that in theory could be over 2G in size? We have attempted this with a supermicro superserver dualproc Xeon 2.8G with 6G of Ram, with a fiber array for database storage...

Hi, I know we will be using at our own risk, I have read the "experimental" warnings, but still PostgreSQL is a very attractive RDBMS for the Windows application we are developing. Most customers will want a simple single-machine version, where the program will be storing its data in a local database without the user knowing much about it....

Hi, I've made up 2 plpgsql calls, the table and function schema is available at http://www.bignose.ca/help/pg.txt I call them like this select ad_hits(33760); select ad_inquiries(33760);

Hello all, i have a view defined as a simple select of a table. This table is inherited by a couple of others. All entries belong to the child-tables. I also have an unconditional update rule on the view. If i do an update to the view, the update is rewritten to update the father-table.

I have a couple users trying to install Postgres on OS X. To the best of my knowledge, both of them are using 7.4.5/10.3.5, and got identical errors while trying to init the database: Reducing the shared buffers didn't help. Any thoughts would be appreciated. Jeffrey Melloy jmelloy@visualdistortion.org

Am I correct to assume that SERIAL does not guarantee that a sequence won't skip (e.g. one successful INSERT gets 32 and the next might be 34)? Sometimes a business requirement is that a serial sequence never skips, e.g. when generating invoice/ticket/formal letter numbers. Would an INSERT INTO t (id, ...) VALUES (SELECT MAX(col)+1 FROM t,...

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 This is a PGP-signed copy of the checksums for following PostgreSQL versions: 7.4.5 7.4.4 7.3.7

I'm running PostgreSQL 8.0 beta 1. I'm using the earthdistance to find the distance between two different latitude and logitude locations. Unfortunately, the result seems to be wrong. Here is what I'm doing: select earth_distance(ll_to_earth('122.55688','45.513746'),ll_to_earth('122.396357','47.648845')); The result I get is this:

So I am renaming a table, and the last stumbling block that I've met is the associated sequence. I tried the commands suggested @ http://mailman.fastxs.net/pipermail/dbmail-dev/2004-August/004307.html ie: CREATE SEQUENCE $newseq SELECT setval('$newseq', max($column)) FROM $table

Hello, I have 3 tables which are joined that I need to create a summation for and I just cannot get this to work. Here's an example: CREATE table1 ( id1 INTEGER, title1 VARCHAR

Hi everybody, I'm doing the following query: select * from messages order by random() limit 1; in the table messages I have more than 200 messages and a lot of times, the message retrieved is the same. Anybody knows how I could do a more "random" random?

Hello everyone, Sorry if this is a FAQ, but I've groups.googled the subject and can't find a definite answer (if such a thing exists). I'm working on a db in postgresql on a debian stable server, ext3 filesystem. The db will contain files, not too many (I expect somewehere between 10 and 100 files max to be inserted daily), and not too big...

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

Please accept my apologies if this is answered elsewhere in the archives or docs but I have searched without luck. I've always assumed that default ordering of selects are based on a first in first out principle and that this remains true at the row level despite edits to columns. However I'm dealing with a case where this doesn't seem to...

I would like to subscribe to you mail list. I'm not highly technical, but am extremely interested in learning as much as I can. Thank-you very much. Phil Bolton ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org