On Tuesday 02 July 2002 06:03 pm, Bruce Momjian wrote:
> Let me tell you what would be really interesting. If we didn't report
> the pid of the notifying process and we didn't allow arbitrary strings
> for notify (just pg_class relation names), we could just add a counter
> to pg_class that is up
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > I don't see a huge value to using shared memory. Once we get
> > auto-vacuum, pg_listener will be fine,
>
> No it won't. The performance of notify is *always* going to suck
> as long as it depends on going through a table. This i
On Tuesday 02 July 2002 03:14 pm, Jan Wieck wrote:
> Lamar Owen wrote:
> > [...]
> > Martin O has come up with a 'pg_fsck' utility that, IMHO, holds a great
> > deal of promise for seamless binary 'in place' upgrading. He has been
> > able to write code to read multiple versions' database structu
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Why can't we do efficient indexing, or clear out the table? I don't
> > remember.
>
> I don't recall either, but I do recall that we tried to index it and
> backed out the changes. In any case, a table on disk is just plain
> not t
OK, I have added this to our CVS under interfaces/libpqxx. I have not
migrated over the CVS history. If we have questions about the code, we
know who to ask. ;-)
Libpqxx still needs to be integrated:
The 'configure' tests need to be merged into our main configure
The
Hi,
I know ORACLE has distributed database management features: such as
replication. Can postgreSQL do this? Is any software available for this
purpose for postgreSQL?
Thanks,
Liping
---(end of broadcast)---
TIP 2: you can get off all lists
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Lamar Owen wrote:
> [...]
>
> And if having a working, usable, Win32 native port gets the subject of good
> upgrading higher up the priority list, BY ALL MEANS LET'S SUPPORT WIN32
> NATIVELY! :-) (and I despise Win32)
Hehehe :-)
> [...]
> Martin O has come up with a 'pg_fsck' utility that,
> One problem I see is that pg_constraint entries can *only* be associated
> with relations; so the table has no way to represent constraints
> associated with domains --- not to mention assertions, which aren't
It's ugly, but one could make the relid 0, and add a typeid which is
non-zero to repr
I just submitted a patch to fix various elog() issues. I have two
additional proposals.
First, I think ERROR/DEBUG/NOTICE/FATAL, etc are too generic and cause
compile problems/warnings, especially with Perl. I suggest renaming all
elog levels to PG*, so it would be PGERROR and PGINFO. We could
On Tuesday 02 July 2002 09:52 am, Jan Wieck wrote:
> Christopher Kings-Lynne wrote:
> > > > It would all work out of the box and would do wonderful things for
> > > > the Postgres community.
> > > I like this idea, but let me just bring one little issue to note: are
> > > you going to handle upgr
Jeff Davis wrote:
> A while ago, I started a small discussion about passing arguments to a NOTIFY
> so that the listening backend could get more information about the event.
>
> There wasn't exactly a consensus from what I understand, but the last thing I
> remember is that someone intended to
> The question is not how to replace some .EXE and .DLL files or modify
> something in the registry. The question is what to do with the existing
> databases in the case of a catalog version change. You have to dump and
> restore.
pg_upgrade?
Otherwise: no upgrades persay, but you can intall th
Bruce Momjian <[EMAIL PROTECTED]> writes:
>> I use cvs update -d -P myself, and I do *not* see it creating the
>> results directory.
> The problem is that if the results directory exists, the update fails
> because there is no /CVS directory in there.
Ah. I always do a 'make distclean' before I
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> >> Does anyone know when this problem was added. I don't see any
> >> significant changes in GNUmakefile.
>
> AFAICT, the results directory hasn't been touched in 21 months.
> Are you sure you haven't changed your own CVS setup or arg
On Tue, Jul 02, 2002 at 02:37:19AM -0700, Jeff Davis wrote:
> A while ago, I started a small discussion about passing arguments to a NOTIFY
> so that the listening backend could get more information about the event.
Funny, I was just about to post to -hackers about this.
> There wasn't exactly
...
> I am backing out my GNUmakefile change. I am still unclear why this has
> started happening all of a sudden.
?
The results/ directory should not be a part of CVS (since it is assumed
to not exist by the regression tests). But it has been in CVS since 1997
during a period of time when a Ma
Christopher Kings-Lynne wrote:
>
> > > It would all work out of the box and would do wonderful things for the
> > > Postgres community.
> >
> > I like this idea, but let me just bring one little issue to note: are you
> > going to handle upgrades, and if so, how? How are you going to
> > do a ma
Bruce Momjian <[EMAIL PROTECTED]> writes:
>> Does anyone know when this problem was added. I don't see any
>> significant changes in GNUmakefile.
AFAICT, the results directory hasn't been touched in 21 months.
Are you sure you haven't changed your own CVS setup or arguments?
> The -d brings in
A while ago, I started a small discussion about passing arguments to a NOTIFY
so that the listening backend could get more information about the event.
There wasn't exactly a consensus from what I understand, but the last thing I
remember is that someone intended to speed up the notification pr
> The nice thing about this implementation approach is that most of the
> backend need not be aware of deleted columns. There are a few places in
> the parser (probably few enough to count on one hand) that will have to
> explicitly check for and reject references to dropped columns, and
> you're
On Tue, 2002-07-02 at 03:25, David M. Kaplan wrote:
> Hi,
>
> Has anyone considered creating an aggregate function that returns an
> array of all matching rows?
check contrib/intagg for a function that does it for integers.
---
Hannu
---(end of broadcast)---
22 matches
Mail list logo
