Alvaro Herrera <[EMAIL PROTECTED]> writes:
> On Tue, Jun 07, 2005 at 04:16:49PM -0700, Josh Berkus wrote:
>> When you call pg_ctl --stop, the WAL is still writing out to the database
>> and postmaster won't shut down until it's done, which can take a couple
>> minutes.
> Is there any way for pg_
On Tue, Jun 07, 2005 at 04:16:49PM -0700, Josh Berkus wrote:
> Folks:
>
> Issue: pg_ctl seems to be prematurely timing out.
> Version: 8.0.3
> Severity: Annoying
> Description:
> 1. Do an immense load on a database, like 2.5gb.
> 2. Right after the COPY finishes, send a pg_ctl -m fast stop to the
Folks:
Issue: pg_ctl seems to be prematurely timing out.
Version: 8.0.3
Severity: Annoying
Description:
1. Do an immense load on a database, like 2.5gb.
2. Right after the COPY finishes, send a pg_ctl -m fast stop to the server.
3. You will get:
pg_ctl: postmaster does not shut down
What
Ouch,
SS> You've analyzed the situation incorrectly I believe.
SS> In this query in the subselect the id column is an outer reference to
SS> the id column generated from full_sequence.
TL> This is not a bug, it is user error.
TL> The actual problem here is that "id" is a perfectly valid outer re
Frank van Vugt <[EMAIL PROTECTED]> writes:
> Looking forward to your analysis of the following bug:
This is not a bug, it is user error.
> CREATE TYPE full_sequence_type AS (id int);
> CREATE OR REPLACE FUNCTION full_sequence(integer, integer)
> RETURNS SETOF full_sequence_type
> ...
> cr
On Tue, 7 Jun 2005, Frank van Vugt wrote:
> Looking forward to your analysis of the following bug:
You've analyzed the situation incorrectly I believe.
> -- however, the following query will happily run AND return a wrong result
> -- based on the regular table instead of the temporary one
> sel
L.S.
Looking forward to your analysis of the following bug:
database=# select version();
version
PostgreSQL 8.0.3 on i586-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3
(1 row)
ST
"Boris Makovecki" <[EMAIL PROTECTED]> writes:
> I'm trying to migrate postgre DB from 7.4 to 8.0. When I start pg_dumpall
> (8.0) and connect it to 7.4 it fails with error:
> pg_dump: SQL command failed
> pg_dump: Error message from server: ERROR: cannot cast type "unknown" to
> text
I believe w
