On Thursday 21 July 2005 17:18, Michael Fuhr wrote:
> If you set AutoCommit to 0 then all statements are inside a
> transaction. As you've discovered, SELECT acquires certain locks
> that persist for the duration of the transaction, so you must commit
> or roll back the transaction to release tho
Hello list,
can SELECT statements throw errors except the followings:
- SQL syntax errors
- connection based errors (database is down/etc...)
- deadlocks
Did I miss an option?
--
So long... Fuzz
---(end of broadcast)---
TIP 5: don't forget to in
Hello List,
I've written an application in perl using DBI with MySQL (no transaction
support). Then we decide to migrate it to postgresql
(postgresql-8.0.1-r4).
At first we were using 'AutoCommit => 1' with the application. That
means that every statement will be commited right away.
Then I d
On Friday 01 July 2005 22:19, Andreas Kretschmer wrote:
> enable stats_command_string in your postgresql.conf
That was missing. Thanks.
--
So long... Fuzz
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http:/
On Friday 01 July 2005 18:24, Jim Buttafuoco wrote:
> did you restart postgresql and use the pg_stat_activity view instead
> (just to save some typing).
No. Is a restart necessary or will a 'reload' do also the trick?
I've done the restart:
postgres=# SELECT * from pg_stat_activity ;
datid
Hallo pgsql-sql@postgresql.org,
I'm looking for a way to display the active querys of postgres. The
mysql way is a 'show [full] processlist'.
After I've read http://pgsqld.active-venture.com/monitoring-stats.html I
set STATS_COMMAND_STRING, STATS_BLOCK_LEVEL, STATS_ROW_LEVEL and
STATS_START_CO
On Monday 01 November 2004 13:26, Ian Barwick wrote:
> Start psql with the -E switch, and it shows the SQL used to generate
> the output from psql's slash commands.
Thanks for the quick answer. I will remember this switch! B-)
--
So long... Fuzz
---(end of broadcast)---
Hi list,
how can I list the databases in a postgresish way? I know about the '-l'
switch of 'psql' but is there a DBI/SQL-query way? I don't want to call
an external program only to list the databases. I've googled about this
problem but I only found the '-l'-way to this this.
Ideas? Solutions
On Tuesday 05 October 2004 13:44, you wrote:
> If you know for sure that you are keeping resend_interval in seconds,
> then try as follows:
>
> foodb=# SELECT (59::text||' secs')::interval;
> interval
> --
> 00:00:59
> (1 row)
Thanks for this solution and the others. It's now working v
Hi List,
I got a table named foobar with two fields
last_sms is a 'timestamp without timezone'
resend_interval is a 'integer'
I choose 'integer' for resend_interval rather than a 'interval' because
the frontend can easier handle the number of seconds. But now I'm stuck
with the query t
Hello [EMAIL PROTECTED],
how can I gave a user full access (SELECT, INSERT,...) to a database
that he doesn't own? I used google to find a solution and I find a
Statement[1] that will the do the trick. But it looks very cryptical to
me. B-) What does this statement do?
> \a
> \t
> \o /tmp/gran
Hi community,
I would like to retrieve all the fieldnames of a given table. In the
perl module Tie::DBI[1] i found the following fragment:
$dbh->prepare("LISTFIELDS $table");
in the case the DB supports this (Tie::DBI thinks so for Pg) or the
alternative is:
$dbh->prepare("SELECT * FROM
12 matches
Mail list logo
