Hi list,
I posted the following mail on the SkyTools mailing list
([EMAIL PROTECTED]), and it has been asked for me to post again on
pgsql-admin. So here we go:
As I'm going to use londiste here at work, and find the documentation sparse,
I've written this howto:
http://pgsql.tapoueh.org/lon
On Thu, Jul 19, 2007 at 02:53:50PM +0300, Abraham, Danny wrote:
> Fails on: Cannot run inside a transaction block.
PostgreSQL functions run in the context of a transaction so they
can't execute statements that aren't allowed inside a transaction
block. A workaround is to have the function connect
Dear experts,
I' ve been trying to mirror the harddisk of my old mac via firewire
on my new computer (Intel Core Duo, OS 10.4.10) which resulted fairly
well expect that my postgreSQL got screwed up. I then tried to
install it once more, but this failed. I guess I did not remove all
the re
Achilleas Mantzios wrote:
Στις Πέμπτη 19 Ιούλιος 2007 12:29, ο/η Abraham, Danny έγραψε:
Thanks
As a first measure, stop posting HTML attachments, and then see how it goes :)
In other words, send your posts as "plain text", not HTML. You should never
use HTML or attachments for Usenet post
I have a huge table that has a char(80) name column (indexed).
The name pattern is like
A_B_C-D.123.456.pdf
A_B_C-D.123.333.doc.2
When I select name from table where name like 'A_B%', it was doing a table scan;
I guess the underscore "_" was treated like a special character, instead of a
char
Hi listers,
I have a table that is accessed by only one transaction. It has 1500 rows
each time that it processes
This transaction. As soon as this transaction ends, it waits 10 seconds and
starts again.
It has another maximum 1500 rows loaded. .
My question is this: I believe a RowE
On 7/20/07, Mark Steben <[EMAIL PROTECTED]> wrote:
Hi listers,
I have a table that is accessed by only one transaction. It has 1500 rows
each time that it processes
This transaction. As soon as this transaction ends, it waits 10 seconds and
starts again.
It has another maximum 1500 rows loa
If I have a column with a value like "abc2457", "efg1234",
how do I select col from table where col like 'a[a-z]c24[0-9]7"?
How do I handle the range bracket in the query?
Thanks.
-
Boardwalk for $500? In 2007? Ha!
Play Monopoly Here and Now (it's update
Jessica Richard <[EMAIL PROTECTED]> writes:
> how do I select col from table where col like 'a[a-z]c24[0-9]7"?
> How do I handle the range bracket in the query?
Using LIKE, you don't. However there are two other types of
pattern-matching operators that do understand character classes:
http://www
Jessica Richard wrote:
If I have a column with a value like "abc2457", "efg1234",
how do I select col from table where col like 'a[a-z]c24[0-9]7"?
How do I handle the range bracket in the query?
You can use the regular expression operator(s), like so:
select *
from table
where co
On Mittwoch, 18. Juli 2007 Alvaro Herrera wrote:
> Postgres does not split entries. They are split by infelicities in
> the underlying facilities used (pipes). There's ongoing work to fix
> this problem. In the meantime, I think you could work around it by
> using syslog instead of redirect_stde
On 7/20/07, Christoph Heibl <[EMAIL PROTECTED]> wrote:
Dear experts,
I' ve been trying to mirror the harddisk of my old mac via firewire on my
new computer (Intel Core Duo, OS 10.4.10) which resulted fairly well expect
that my postgreSQL got screwed up. I then tried to install it once more, but
On Jul 20, 2007, at 8:19 AM, Christoph Heibl wrote:
I' ve been trying to mirror the harddisk of my old mac via firewire
on my new computer (Intel Core Duo, OS 10.4.10) which resulted
fairly well expect that my postgreSQL got screwed up. I then tried
to install it once more, but this failed
13 matches
Mail list logo
