PREPARE in bash scripts
| От | A.j. Langereis |
|---|---|
| Тема | PREPARE in bash scripts |
| Дата | |
| Msg-id | 001201c5f011$9a4cc580$3e01a8c0@aarjan2 обсуждение исходный текст |
| Ответ на | Logging prepared statements in 8.1? (Bjørn T Johansen <btj@havleik.no>) |
| Ответы |
Re: PREPARE in bash scripts
|
| Список | pgsql-general |
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 по дате отправления: