Postgres Pro
Downloads
Home   >   mailing lists

PREPARE in bash scripts - Mailing list pgsql-general

From A.j. Langereis
Subject PREPARE in bash scripts
Date
Msg-id 00e801c5ec5b$45b78000$3e01a8c0@aarjan2
Whole thread Raw
List pgsql-general
Tree view
Dear all,
 
I've written a bash script that looks like the one below:
 
#!/bin/bash
 
DBuser='root'
DBname='test'
 
psql -q --username=$DBuser --dbname=$DBname -c "prepare test_statement (integer) as insert into tbl_test (col_test) values (\\$1)";
 
tail -f /root/testfile | while read a;
    do
        psql -q --username=$DBuser --dbname=$DBname -c "execute test_statement ($a)";
    done;
 
psql -q --username=$DBuser --dbname=$DBname -c "deallocate test_statement";
 
Note that this is very stripped version of the real script, but it gives the same errors:
 
ERROR:  prepared statement "test_statement" does not exist
 
I persume that this is caused because of the individual statements, each using their own session. But is there a way to avoid this?
In reality the statement that is prepared is much more complex, and the files that are processed are rather big. I hoped to gain more performance by preparing the statement.
 
Your sincerely,
 
Aarjan Langereis
 
Ps. The bash script is ran on an Fedora Core 3 machine using PostgreSQL 8.1.0

pgsql-general by date:

Previous
From: Michelle Konzack
Date:
Subject: Re: 3 x PostgreSQL in cluster/redunant
Next
From: Assad Jarrahian
Date:
Subject: Upgrading from 8.0 to 8.1 on Debian