On Fri, Nov 30, 2012 at 7:28 PM, hartrc rha...@mt.gov wrote:
Hi,
PostgreSQL 9.1.6
Linux (SLES 11)
i have a pg_basebackup job that is executed within a script.
My command is:
/postgresql/v91/bin/pg_basebackup -h 127.0.0.1 -D
/postgresql/pg_backup/backupdir -Ft -Z 5
The result of this
2012/11/30 Igor Neyman iney...@perceptron.com
-Original Message-
From: Greg Sabino Mullane [mailto:g...@turnstep.com]
Sent: Thursday, November 29, 2012 11:34 PM
To: pgsql-general@postgresql.org
Subject: Re: pg_listening_channels()
On the contrary, it was very well
How can I achieve this?
EXECUTE '
if 1=1 then
raise notice ''%'', ''notice has been raised...'';
end if;
';
On 01/12/2012 19:11, Peter Kroon wrote:
How can I achieve this?
EXECUTE '
if 1=1 then
raise notice ''%'', ''notice has been raised...'';
end if;
';
I think EXECUTE used like this is available only in a function:
create or replace function my_function()
returns void
as
$$
M...
How do I execute dynamic sql that starts with an if statement.
I'm converting mssql code to pgsql.
2012/12/1 Raymond O'Donnell r...@iol.ie
On 01/12/2012 19:11, Peter Kroon wrote:
How can I achieve this?
EXECUTE '
if 1=1 then
raise notice ''%'', ''notice has been
To give a better idea:
DO $$
DECLARE v_string text = 'raise notice ''%'', ''this could be sql with if
statement...'';';
BEGIN
if 1=1 then
raise notice '%', ' first notice has been raised...';
end if;
EXECUTE v_string;--this fails
END;
$$
LANGUAGE plpgsql;
I do not wish to create a function for
On 01/12/2012 19:44, Peter Kroon wrote:
M...
How do I execute dynamic sql that starts with an if statement.
I'm converting mssql code to pgsql.
Without trying it, I'd guess that you need to have the IF outside the
dynamic code, something like this:
if then
execute
Em 23/11/2012 19:18, Guillaume Lelarge escreveu:
On Fri, 2012-11-09 at 09:19 -0200, Edson Richter wrote:
I've a bunch of databases that cannot be dropped in any case.
I was wondering if it is possible to revoke drop database permission
for all users, in order that even superuser, if he wishes
On Sun, Dec 2, 2012 at 10:20 AM, Edson Richter edsonrich...@hotmail.com wrote:
I've put both files in ~/deny_drop folder, and executed make:
# LANG=C make
Makefile:13: ../../src/Makefile.global: No such file or directory
Makefile:14: /contrib/contrib-global.mk: No such file or directory
Em 01/12/2012 22:22, Chris Angelico escreveu:
On Sun, Dec 2, 2012 at 10:20 AM, Edson Richter edsonrich...@hotmail.com wrote:
I've put both files in ~/deny_drop folder, and executed make:
# LANG=C make
Makefile:13: ../../src/Makefile.global: No such file or directory
Makefile:14:
On Sun, Dec 2, 2012 at 7:53 AM, Edson Richter edsonrich...@hotmail.comwrote:
Em 01/12/2012 22:22, Chris Angelico escreveu:
On Sun, Dec 2, 2012 at 10:20 AM, Edson Richter edsonrich...@hotmail.com
wrote:
I've put both files in ~/deny_drop folder, and executed make:
# LANG=C make
On Fri, Nov 30, 2012 at 12:22 PM, Henry Drexler alonup...@gmail.com wrote:
On Fri, Nov 30, 2012 at 1:42 PM, Jeff Janes jeff.ja...@gmail.com wrote:
Can you report the EXPLAIN (ANALYZE, BUFFERS) instead?
Thanks, here they are:
for the approx 65 million row approx 50 min version:
EXPLAIN
12 matches
Mail list logo