On Mon, Feb 21, 2005 at 12:50:44PM +, [EMAIL PROTECTED] wrote:
host all all 127.0.0.1/0 trust
Should that not be 127.0.0.1/32 ? or even
host all all 127.0.0.1 255.255.255.255trust
?
Patrick
---(end of broadcast)---
TIP
Tom Lane wrote:
Keith Worthington [EMAIL PROTECTED] writes:
I have just discovered that I can speed up one of my functions by a factor of
600 by changing an unqualified DELETE to a TRUNCATE. Unfortunately, the
function is run by multiple users and I get the error message
TESTDB= TRUNCATE
Dear Pg hackers,
After upgrading from 7.4.2 to 8.0.0 I get this message when trying to
load a C language function:
permission denied for language c
Even postgres and root gets this message. SQL functions work well.
Please, help.
With love, Gabor
---(end of
On Wed, Feb 23, 2005 at 04:53:34PM +0100, Berényi Gábor wrote:
After upgrading from 7.4.2 to 8.0.0 I get this message when trying to
load a C language function:
permission denied for language c
Even postgres and root gets this message. SQL functions work well.
Are you sure postgres and
Does auto_vacuum vacuum the system tables?
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005
On Feb 16, 2005, at 5:42 PM, Matthew T. O'Connor wrote:
Tom Lane wrote:
[EMAIL
Thomas F.O'Connell wrote:
Does auto_vacuum vacuum the system tables?
Yes
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
Dear Michael and others,
SELECT usename FROM pg_user WHERE usesuper IS TRUE;
Result: postgres. So the problem persist.
Does it work for you? I use x86 Linux 2.4.20.
Look forward to hear of you, Gabor
Michael Fuhr [EMAIL PROTECTED] rta:
On Wed, Feb 23, 2005 at 04:53:34PM +0100, Bernyi Gbor
Kurt Roeckx [EMAIL PROTECTED] writes:
The configure test is a little broken. It needs to quote the
$'s.
I've rewritten the test a little.
Applied, thanks.
regards, tom lane
---(end of broadcast)---
TIP 8: explain
On Wed, Feb 23, 2005 at 11:39:19PM +0100, Berényi Gábor wrote:
SELECT usename FROM pg_user WHERE usesuper IS TRUE;
Result: postgres. So the problem persist.
Please show the exact statement you're running and the exact output
(copied and pasted, not typed manually). Also the following,
On Wed, Feb 23, 2005 at 10:02:22AM +1100, Neil Conway wrote:
Kenneth Marshall wrote:
GEQO is an attempt to provide a near-optimal join order without using
an exhaustive search. An exhaustive, deterministic search of a subset
of the search space has a non-zero probability of finding only a
There is a cleanup loop that (commonly) runs every 10 minutes or so
and vacuums the tables that are used by the replication application.
If there is some long-running transaction kicking around, this will
keep that from actually cleaning things out.
Consider the scenario where the system is
I was thinking about one of the pathological cases where Slony-I
behaves badly, and had an optimization thought...
There is a cleanup loop that (commonly) runs every 10 minutes or so
and vacuums the tables that are used by the replication application.
If there is some long-running transaction
Is there a TODO here?
---
Neil Conway wrote:
Is there a way to recall the previous command in psql? Obviously, up
arrow or Ctrl-P using readline and the default readline bindings is
close, but it recalls the previous
13 matches
Mail list logo