Luke Koops wrote:
> The following bug has been logged online:
>
> Bug reference: 5038
> Logged by: Luke Koops
> Email address: luke.ko...@entrust.com
> PostgreSQL version: 8.3.7
> Operating system: Windows 2003 Server Enterprise Edition
> Description:WAL file is pendin
>>> Alvaro Herrera 9/4/2009 7:23 PM >>>
tkar...@ultimo.pl wrote:
> Without casting function executes much slower:
>
> CREATE OR REPLACE FUNCTION table_exists(tblname text) RETURNS boolean AS '
> DECLARE
> exists boolean;
> BEGIN
> SELECT 1 INTO exists FROM pg_class WHERE relname = name($1)
Hello
2009/9/7 Tomasz Karlik :
>
>
Alvaro Herrera 9/4/2009 7:23 PM >>>
> tkar...@ultimo.pl wrote:
>
>> Without casting function executes much slower:
>>
>> CREATE OR REPLACE FUNCTION table_exists(tblname text) RETURNS boolean AS '
>> DECLARE
>> exists boolean;
>> BEGIN
>> SELECT 1 INTO e
2009/9/7 Pavel Stehule :
> Hello
>
> 2009/9/7 Tomasz Karlik :
>>
>>
> Alvaro Herrera 9/4/2009 7:23 PM >>>
>> tkar...@ultimo.pl wrote:
>>
>>> Without casting function executes much slower:
>>>
>>> CREATE OR REPLACE FUNCTION table_exists(tblname text) RETURNS boolean AS '
>>> DECLARE
>>> exists
Heikki Linnakangas writes:
> Perhaps we should try to close the old WAL file sooner.
There is zero hope of making that work. What we probably need to do
is fix the code that scans pg_xlog so that it ignores files that are
pending deletion. (I assume there's some way to find that out on
Windows.
> -Original Message-
> From: Tom Lane [mailto:t...@sss.pgh.pa.us]
> Sent: Monday, September 07, 2009 1:17 PM
> To: Heikki Linnakangas
> Cc: Luke Koops; pgsql-bugs@postgresql.org
> Subject: Re: [BUGS] BUG #5038: WAL file is pending deletion
> in pg_xlog folder, this interferes with WAL archi
