-Original Message-
From: Matthew T. O'Connor [mailto:[EMAIL PROTECTED]
Sent: 13 May 2004 21:40
To: Dave Page
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [HACKERS] pg_autovacuum Win32 service patch #2
Anyway, not having looked at this at all, how will this be
Tom Lane wrote:
Gaetano Mendola [EMAIL PROTECTED] writes:
which library I have to link in order to have the symbol pg_begintypsend ?
I think you want pq_begintypsend.
Consider paying more attention to unknown-function warnings from your
compiler.
I had no warning at all, I think I have to
BTW, what are your plans for state saving/reversion for the lock manager
and buffer manager? The lock state, in particular, makes these other
problems look trivial by comparison.
Why can't we keep all locks until main tx end ? Locks are not self conflicting
are they ? So the only reason to
Greg Stark wrote:
Jan Wieck [EMAIL PROTECTED] writes:
The whole sync() vs. fsync() discussion is in my opinion nonsense at
this
point. Without the ability to limit the amount of files to a reasonable
number,
by employing tablespaces in the form of larger container files, the
risk of
Zeugswetter Andreas SB SD [EMAIL PROTECTED] writes:
Why can't we keep all locks until main tx end ?
For committed subtransactions we have to do that, yes, but for aborted
subtransactions we must release. Otherwise you can't implement a retry
loop around a potentially-deadlocking operation.
(I
Guess this means I have to tweak my ACL parser in phpPgAdmin. If you
could do something to make that less of a NIGHTMARE, i'd be all ears :P
1. Make it easy to convert an array to a rowset
2. Fabien's accessor functions? Would they help?
Sure. I needed these functions to convert acl array
I all,
I'm tryng to declare my email type.
I think I have to do it in this way:
create type email ( INPUT = email_in,
OUTPUT = email_out,
RECEIVE = email_recv,
SEND = email_send,
INTERNALLENGTH = VARIABLE,
I wrote:
I've been thinking more about this, and realizing that there are more
implications than I first thought. Specifically, we have to consider
how any hacking we do here will affect recursive_revoke().
After further consideration I think that at least part of the problem
here is that
Gaetano Mendola [EMAIL PROTECTED] writes:
create type email ( INPUT = email_in,
OUTPUT = email_out,
RECEIVE = email_recv,
SEND = email_send,
INTERNALLENGTH = VARIABLE,
PASSEDBYVALUE = f,
Gaetano Mendola [EMAIL PROTECTED] writes:
create type email ( INPUT = email_in,
OUTPUT = email_out,
RECEIVE = email_recv,
SEND = email_send,
INTERNALLENGTH = VARIABLE,
PASSEDBYVALUE = f,
Basically our whole API of communicating ACL information to the user is
poor. Look at psql \z:
test= create table test(x int);
CREATE TABLE
test= grant all on test to public;
GRANT
test= \z test
Access privileges for database
Bruce Momjian [EMAIL PROTECTED] writes:
Basically our whole API of communicating ACL information to the user is
poor. Look at psql \z:
Well, if you don't like that, there's always the spec's way:
regression= select * from information_schema.table_privileges where table_name =
'mytable';
On Fri, 2004-05-14 at 02:00, Tom Lane wrote:
Michael Brusser [EMAIL PROTECTED] writes:
It looks that No such file or directory followed by the abort signal
resulted from manually removing logs. pg_resetxlog took care of this,
but other problems persisted.
pg_dump: ERROR: XLogFlush:
We have a feature freeze scheduled for either June 1 or whenever a major
feature is completed, whichever is last.
For Win32, we have open:
fsync (Tom)
relative installs (Bruce)
timezone (Magnus)
There is a company that wants to fund some PostgreSQL features but I
told
Hi all,
what is the purpose of two function send and receive
when a new type is defined ? When these two functions
are called ?
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
On Thu, May 13, 2004 at 09:43:42AM -0400, Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
I'm stuck trying to figure out how to decrease reference counting for
relcache entries at subtransaction abort.
Initially I thought I could just drop them all to zero,
Nope, you can't.
Lamar Owen wrote:
Anyway, Syslog is not an option for us. We need flat files.
Ok, riddle me this:
If I have PostgreSQL set to log to syslog facility LOCAL0, and a local0.none
on /var/log/messages and local0.* to /var/log/pgsql (assuming only one
postmaster, unfortunately) then you get a flat
Alvaro Herrera wrote:
PS: Either the list server is getting very slow or it has started to
lose mail. I asked yesterday whether it was OK to copy the hash but
apparently the mail didn't make it to the list. Is there something
happening?
Not sure. I can confirm I never saw that email.
--
-Original Message-
From: [EMAIL PROTECTED]
pg_dump: ERROR: XLogFlush: request 0/A971020 is not satisfied ---
flushed only to 0/550 ... lost synchronization with
server, resetting
connection
Okay, you have a page with an LSN of A971020 which is past end of XLOG
, 13.05.2004, 04:42, Tom Lane :
But if you have a platform that has mbstowcs and
friends, please try it and let me know about any portability gotchas
you see.
I can't test it because with a clean 7.4.2 with the patch applied I get
[EMAIL PROTECTED] postgresql-7.4.2]$ LANG=C make install
Just to give some more incentive to work at June 1st ... Native Win32
would be *really* nice to showcase at OSCON in July, if we could pull off
a relatively clean/strong beta period ...
On Fri, 14 May 2004, Bruce Momjian wrote:
We have a feature freeze scheduled for either June 1 or whenever a
Marc G. Fournier wrote:
Just to give some more incentive to work at June 1st ... Native Win32
would be *really* nice to showcase at OSCON in July, if we could pull off
a relatively clean/strong beta period ...
Especially if we have the service code and a spiffy installer ...
On Fri, 14 May 2004,
Hackers,
In looking at the CatCache code it's clear to me that there's no point
in copying the whole structure like I did to the Relcache; it's much
bigger, and there's not much that can change inside a subtransaction:
CatCacheRemoveCTup can't be called, because ReleaseCatCache will not be
called
Alvaro Herrera [EMAIL PROTECTED] writes:
Ok, I created a function to copy a hash table (from dynahash). So now
at subtransaction start the RelationIdCache and RelationSysNameCache
hash tables are copied, and if the subtransaction aborts the previous
hash tables are restored.
I don't think
Simon Riggs [EMAIL PROTECTED] writes:
On Fri, 2004-05-14 at 02:00, Tom Lane wrote:
Okay, you have a page with an LSN of A971020 which is past end of XLOG
(550). You may have created this problem for yourself by doing
pg_resetxlog with poorly chosen parameters.
Is there a way to know
On Fri, May 14, 2004 at 11:21:42PM -0400, Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
Ok, I created a function to copy a hash table (from dynahash). So now
at subtransaction start the RelationIdCache and RelationSysNameCache
hash tables are copied, and if the subtransaction
Gaetano Mendola [EMAIL PROTECTED] writes:
what is the purpose of two function send and receive
when a new type is defined ?
Binary I/O handling. I'm quite sure this is in the docs...
regards, tom lane
---(end of
Hello,
new version of contrib/pg_trgm (former trgm) is available for
download from http://www.sai.msu.su/~megera/postgres/gist/pg_trgm
One bug was fixed, upgrade is simple, no index rebuilding is required.
contrib/pg_trgm module provides fuzzy search with GiST index support
based on trigram
Hello,
Andrew Kopciuch has submit new version of his Introduction to tsearch2,
which is available from
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/tsearch-V2-intro.html
He added explanation of how to backup and restore databases that
features tsearch2.
Regards,
On Tuesday 11 May 2004 09:44 am, Bruce Momjian wrote:
[snip]
Bruce Momjian kirjutas E, 10.05.2004 kell 06:58:
Added to TODO:
* Add MERGE command that does UPDATE, or on failure, INSERT
[snip]
Hello all.
I have been lurking here for a bit and the MERGE topic (on
30 matches
Mail list logo
