On Fri, Mar 28, 2008 at 09:39:53AM -0300, A.Burbello wrote:
> How can I get the files in a directory, but not the
> last file updated/created?
> I could get the last file updated with:
> ls -t1p | grep -v / | grep -v backup | head -1
> How can I get the inverse list, other files without
> the last
Hi,
Is the resultset returned by executing plpy.execute("myquery") implemented by
cursors, or does it require fetching all the qualifying records to the client.
Allan.
Never miss a thing. Make Yahoo
Hi all,
Am having trouble finding a way to loop through the records (one by one) of the
resultset returned by plpy.execute("myquery") statement.
Please show me a a few lines of the looping and how to terminate the loop once
no more records are found.
Allan.
___
I am trying to use the windows scheduler to kick off a vacuum. When I
run the batch file normally vacuum runs no problem. When I run the same
batch file from the scheduler it never finishes. Checked the login seems
fine - log says its running auto vacuum. Am I missing something. Checked
FAQ, an
Hello
one simple question - since which version postgresql has
pg_get_expr(text, oid) in it?
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Hello list
an interrupted vacuum full has just caused a PG instance to restart and
recover. Background:
select version();
version
--
PostgreSQL
"Mikko Partio" <[EMAIL PROTECTED]> writes:
> 2008-03-29 22:25:15 EET [26841]: [3-1] PANIC: cannot abort transaction
> 3778747509, it was already committed
Yeah, this is a well-known problem with VACUUM FULL ...
regards, tom lane
--
Sent via pgsql-admin mailing list (pgs
