On Wed, 2007-04-04 at 11:07 -0400, Tom Lane wrote:
> Damian Lubosch <[EMAIL PROTECTED]> writes:
> > My problem now is, how to continually feed the slave server with new
> > received WAL files?
>
> You need to make the restore_command script wait until the next WAL file
> is available, instead of f
Dan Harris wrote:
Hello all:
I'm in a bit of a bind here. Today is my maintenance window for
upgrading from 8.0.3 to 8.2.3. I did a pg_dumpall overnight ( resulting
in a 72GB file ) and then a pg_dump on one of my small databases this
morning to test pg_restore. When trying to reload, I'm g
We had a similar conversion conflict some time back whe upgrading and found
using a search for anything not A-Z, 0-9, etc, was useful to find offensive
data and fix it.
On 4/8/07, Dan Harris <[EMAIL PROTECTED]> wrote:
Hello all:
I'm in a bit of a bind here. Today is my maintenance window for
Hello all:
I'm in a bit of a bind here. Today is my maintenance window for upgrading from
8.0.3 to 8.2.3. I did a pg_dumpall overnight ( resulting in a 72GB file ) and
then a pg_dump on one of my small databases this morning to test pg_restore.
When trying to reload, I'm getting the followin
you could simply write
insert into table_a values (1);
if found then
dbms.output.put_line('rows inserted');
else
dbms.output.put_line('rows not inserted');
end if;
If you really need the number of records inserted (found will be true if at
least one record as affected), you c
On 4/7/07, Karthikeyan Sundaram <[EMAIL PROTECTED]> wrote:
Hi,
I am using 8.1.0 postgres and trying to write a plpgsql block. In that
I am inserting a row. I want to check to see if the row has been inserted
or not.
In oracle we can say like this
begin
insert into table_a
There is a difference between PostgreSQL and other DBMSs (like MySQL and
Oracle) that makes it difficult to to stabilize ported applications.
When an SQLException occurs, and is caught by the application logic, the
other DBMSs are processing the following SQL commands of the
transaction. This m
Hi,
I am using 8.1.0 postgres and trying to write a plpgsql block. In that I am
inserting a row. I want to check to see if the row has been inserted or not.
In oracle we can say like this
begin
insert into table_a values (1);
if sql%rowcount > 0
then
dbms.out
