Mike G. [EMAIL PROTECTED] writes
If 1663/17269/1677179: Permission denied refers to a file under the data
directory (I have found a folder 17269 that contains similiar names to
1677179) then it would seem postgres is trying to write data to a file that
does not exist.
I don't think it is
Alvaro Herrera [EMAIL PROTECTED] writes
Because we can't reuse MultiXactIds at system crash (else we risk taking
an Id which is already stored in some tuple), we need to XLog it. Not
at the locking operation, because we don't want to log that one (too
expensive.) We can log the current
Hi,
I have found comments in backend/catalog/index.c, that
index_build closes the passed rels ( heapRelation and indexRelation ).
But in backend/access/nbtree/nbtree.c I see something like this:
if (IsNormalProcessingMode())
{
heap_close(heap, NoLock);
--On torsdag, april 07, 2005 14.34.22 +1200 Oliver Jowett
[EMAIL PROTECTED] wrote:
Greg Stark wrote:
Palle Girgensohn [EMAIL PROTECTED] writes:
When setting log_statement = all, and using JDBC PreparedStatements, I
get $n in the log where the real arguments used to be in previous
versions of
Why is there so different Total runtime for ('now'::text)::date) and
'2005-04-06'::date ?
I think both is constant during execution.
CREATE TABLE test (
_time timestamp with time zone,
_platform character(5),
_tld character(5)
) WITHOUT OIDS;
explain analyze SELECT
On Thu, Apr 07, 2005 at 02:34:03PM +0800, Qingqing Zhou wrote:
Alvaro Herrera [EMAIL PROTECTED] writes
Because we can't reuse MultiXactIds at system crash (else we risk taking
an Id which is already stored in some tuple), we need to XLog it. Not
at the locking operation, because we don't
On Wed, Apr 06, 2005 at 18:09:37 -0400,
Tom Lane [EMAIL PROTECTED] wrote:
Can anyone suggest a more general rule? Do we need for example to
consider whether the relation membership is the same in two clauses
that might be opposite sides of a range restriction? It seems like
a.x
Alexey Slynko [EMAIL PROTECTED] writes:
I have found comments in backend/catalog/index.c, that
index_build closes the passed rels ( heapRelation and indexRelation ).
Bootstrap mode does it differently. I've never really felt motivated to
understand why in any detail. Presumably it was once
Karel Zak [EMAIL PROTECTED] writes:
Why is there so different Total runtime for ('now'::text)::date) and
'2005-04-06'::date ?
I think both is constant during execution.
Not at all. text_date() is not immutable so it has to be applied during
execution. The other one is just a constant.
Bruno Wolff III [EMAIL PROTECTED] writes:
Tom Lane [EMAIL PROTECTED] wrote:
Can anyone suggest a more general rule?
I think it makes sense to guess that a smaller fraction of the rows will
be returned when a column value is bounded above and below than if it
is only bounded on one side,
On Wed, Apr 06, 2005 at 06:35:10PM -0400, Tom Lane wrote:
Jim C. Nasby [EMAIL PROTECTED] writes:
On Wed, Apr 06, 2005 at 06:09:37PM -0400, Tom Lane wrote:
Can anyone suggest a more general rule? Do we need for example to
consider whether the relation membership is the same in two clauses
On Wed, 2005-04-06 at 15:01 +0200, Palle Girgensohn wrote:
I really need to know the *real* arguments...
Why do you need to log the arguments as well?
Thanks,
Best Regards, Simon Riggs
---(end of broadcast)---
TIP 3: if posting/reading through
--On torsdag, april 07, 2005 23.31.52 +0100 Simon Riggs
[EMAIL PROTECTED] wrote:
On Wed, 2005-04-06 at 15:01 +0200, Palle Girgensohn wrote:
I really need to know the *real* arguments...
Why do you need to log the arguments as well?
Debugging purposes. If I fealize there are queries hogging the
--On Dienstag, April 05, 2005 16:19:54 -0400 Tom Lane [EMAIL PROTECTED]
wrote:
I've gotten a bee in my bonnet again about Resdom being wasteful.
There is no case where Resdom appears without TargetEntry, nor vice
versa, so we ought to fold them into a single node type. Is anyone
out there
On Fri, Apr 08, 2005 at 02:27:46AM +0200, Bernd Helmle wrote:
--On Dienstag, April 05, 2005 16:19:54 -0400 Tom Lane [EMAIL PROTECTED]
wrote:
I've gotten a bee in my bonnet again about Resdom being wasteful.
There is no case where Resdom appears without TargetEntry, nor vice
versa, so we
Neil Conway wrote:
I'd like to make add_missing_from=false the default for 8.1. Any
objections?
FYI, I've applied a patch that makes this change to CVS HEAD.
-Neil
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL
Will be on the main ftp site within the next 30 minutes ...
tar sizes look right compared to 8.0.1 ... please check her over to make
sure there are no problems ...
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [EMAIL PROTECTED] Yahoo!: yscrappy
Hi,
1. Fire up psql.
2. Press Ctrl-4
3. Crash, core dump...
Chris
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
1. Fire up psql.
2. Press Ctrl-4
3. Crash, core dump...
SIGQUIT is supposed to do that.
regards, tom lane
---(end of broadcast)---
TIP 3: if posting/reading through
1. Fire up psql.
2. Press Ctrl-4
3. Crash, core dump...
SIGQUIT is supposed to do that.
Seems to be a libreadline thing:
#0 0x2827fd60 in sigprocmask () from /usr/lib/libc.so.4
#1 0x281f5adb in _rl_savestring () from /usr/lib/libreadline.so.4
#2 0xbfbfffac in ?? ()
#3 0x281f2254 in
Marc G. Fournier [EMAIL PROTECTED] writes:
tar sizes look right compared to 8.0.1 ... please check her over to make
sure there are no problems ...
Looks good from here.
regards, tom lane
---(end of broadcast)---
TIP 1:
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
SIGQUIT is supposed to do that.
Seems to be a libreadline thing:
No, it's a built-in thing. See man stty, man tty(4), man termio
or related topics depending on your platform. The point is that the
kernel terminal driver takes that as a
22 matches
Mail list logo