PostgreSQL Database Forum

Is there a way to kill a session in PostrgeSQL? I ran a bad query by mistake and I don't want to shut the whole database just to quit using the whole CPU. -- ICQ: 1912453 AIM: VitalyB1984 MSN: tmdagent@hotmail.com Yahoo!: VitalyBe

Hi folks, probably this is a question you've heard so many times but I wasn't able to find a solution to it. I'm using a shell script to create a textfile for me. It looks like #!/usr/local/bin/bash psql -c "select foo from bar;" -d database1 -t psql -c "\q" -d database1 exit 0

I want to do something like this, but I can't seem to find the right syntax: select * into temp tblDest where( (select t0.* from tblSource0 t0, tblExtension1 t1 where t0.colA = 1 and t0.oid_parent = t1.oid ) union (select t2.* from tblSource2 t2, tblExtension3 t3

Hi, I am working on a project which explore postgresql to store multimedia data. In details, i am trying to work with the buffer management part of postgres source code. I had search on the web but could not find much usefull information. Is there any developer groups that working on similar things ? Where can i find more information on...

This thread was renamed. It used to be: "shared_buffers Question". The old thread kind of died out. I'm hoping to get some more direction by rephrasing the problem, along with some extra observations I've recently made. The core of the problem is that Postgres is filling up my hard drive with swap files at the rate of around 3 to 7 GB per...

Since the current stable version of postgres (7.4.x) doesn't allow cross-datatype comparisons of indexes, is it always necessary to cast my application data explicitly in order for an index to be used, even among the integer types? E.g., If I have a table with a bigint primary key and application data compared against that primary key, must...

Any views on when an 8.0 release is likely? I appreciate that it will depend on beta testing but any insight into current intentions would be helpful for a deployment decision over the next few days/weeks. Thanks Julian Scarfe

Hello, is this version ftp://ftp.postgresql.org/pub/src/7.4.5/ stable release ??? thanx.... -- hlavki@medium13.sk ]http://www.medium13.sk ]

Incidentally, am I the only one that finds the new 7.4 log messages too cluttered? In 7.3 my application printed progress messages using "raise notice" like this: 2004-08-20 11:58:16 NOTICE: Processing 6561 1/15127... 2004-08-20 11:58:19 NOTICE: Processing 6561 1/15127...Done Found 3800 2004-08-20 11:58:19 NOTICE: Processing 6794...

Hi, after some more debugging I found that my application does on average 3 inserts per second. Which is not very fast, but fast enough for now. But now and then the whole insert proces will be stalled and drop to 0.1 inserts per second. In the output of "ps aux Op" I see postgres in the state "INSERT WAITING". I have some other...

7.4.2 running on FreeBSD 5.4.2 I have a table (called "draft" ) that has a bigserial as the primary key. "check_id bigserial NOT NULL" I do NOT have an additional index on that column. I have a plpgsql function (stored procedure) that selects from that table based on the primary key field

Hello ! I have a couple of tables with the same schema that I would like to query and view as one table. I looked into CREATE VIEW and FULL JOINs but still can't figure out a good (fast) way of doing this.. Any ideas ? /Otto Blomqvist

copy swpparm from stdin using delimiters ';'; exampaper;02;1;Bahasa Melayu;M;A;2002-11-27;system;; \. why does the above command return a error message ERROR: copy: line 1, Bad date external representation ''

Hi, what does that line from my logfile mean? Adding missing FROM-clause entry for table "customer" Would pg change my SQL queries on the fly? TIA

Hi, Can I connect a JBOSS appl server to a Postgres SQL database ? I think that there should be no problem at all doing that, but I don't know from where to start. Are there some detailed instructions as how to do this ?

Hi All, in my project I need to call stored-function with parameters. The procedure I use is PQexecParams(...) where char *paramValues is used to pass arguments. To call stored-function I use "select findFile($1);" The result is that there is no value passed to the function but function executes correcly and no error messages are returned....

Hi All, in my project I need to call stored-function with parameters. The procedure I use is PQexecParams(...) where char *paramValues is used to pass arguments. To call stored-function I use "select findFile($1);" The result is that there is no value passed to the function but function executes correcly and no error messages are returned....

Hi,I am using slightly modified example posted by Doug Younger and answered by Tom Lane :)(http://archives.postgresql.org/pgsql-sql/1999-08/msg00159.php) I have the following 2 tables: Table groups: g_id int4 g_name text Table users:

Hi, I'm having intermittent problems connecting to my PostgreSQL database from PHP, using Kerberos credentials forwarded from mod_auth_kerb. - User authenticates via mod_auth_kerb, (either Basic or Negotiate HTTP authenication) - Kerberos credentials are stored in a file that lives for the lifetime of the HTTP connection.

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, is there any way to speedup queryes like select ... from where = order by desc limit ; with index on field b I get something, but pgsql afterwards resolves to sorting manually. partial indices with index on field c where field b = number works, but are

Hi I am using PostgreSQL 7.3.2 on Solaris 8 machine. I have written following procedure for Windows ( testing purpose ) and solaris ( production ). It works well on windows but gives following error on solaris. Can anyone help me to find out what is the problem ? CREATE OR REPLACE FUNCTION p_MapLicKeyToAccount(VARCHAR,VARCHAR) RETURNS...

Hi, I'm oracle man. So, how about features in postgesql which exists in oracle db (order is casual) ? 1. Sequences 2. Packages 3. Functions/procedures 4. Full-text 5. Triggers

All, I need to upload (insert) a flat file to PostgresSQL DB (on Solaris 9) using C. I wonder if I should use libpq functions or embedded SQL in C (libecpg). Any help is appreciated. If you have any sample programs, please sendalong. Thanks, Andy Truong

Coming off of 7.4.3 I've always used select count(*) from pg_stat_activity through the ODBC driver to obtain the number of connections to the db. I've found that with v8.0 Beta 1 that this at times has returned a value of 0 (when there is obviously still a connection). It's not repeatable, and occurs sporadically. Does anyone have any...