I just happened to try to compile 7.4beta4 on a two-month-old NetBSD-current
system, and I get the following:
In file included from timestamp.c:14:
../../../../src/interfaces/ecpg/include/datetime.h:7: conflicting types for `dtime_t'
/usr/include/sys/types.h:186: previous declaration of `dtime_t'
So it seems I got bitten today by this to-do list item:
Have AFTER triggers execute after the appropriate SQL statement in a
function, not at the end of the function
Under normal circumstances, delaying this stuff until the end of the
function doesn't bother me; in fact I've even used
I was wondering whether we need to keep WAL online for 2PC,
or whether only something like clog is sufficient.
What if:
1. phase 1 commit must pass the slave xid that will be used for 2nd phase
(it needs to return some sort of identification anyway)
2. the coordinator
There's a new version available at
http://www.dunslane.net/~andrew/Initdb_In_C.html - I think it takes care of
all of Peter's comments. I removed initdb-scripts.h - the smaller scripts
were moved into initdb.c with SQL comments turned into C comments, and the
large script to set up system views
Andrew,
On Fri, Oct 10, 2003 at 12:25:01AM -0400, Andrew Dunstan wrote:
WinXP/cygwin/gcc version 3.3.1 (cygming special)
XP Home or Pro? What version of Cygwin?
gives these
tablecmds.c:3528: warning: dereferencing type-punned pointer will break
strict-aliasing rules
[snip]
FWIW, I saw
Forwarding to -hackers as per README
- -
From: Markus Bertheau [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [BUGS] pg_autovacuum segv
Date: 09 Oct 2003 17:30:48 +0200
(gdb) run
Starting program: /root/src/postgresql-7.4beta4/contrib/pg_autovacuum/pg_autovacuum
[2003-10-09 05:28:13
Jason Tishler wrote:
Andrew,
On Fri, Oct 10, 2003 at 12:25:01AM -0400, Andrew Dunstan wrote:
WinXP/cygwin/gcc version 3.3.1 (cygming special)
XP Home or Pro? What version of Cygwin?
XP-HE. I ran a cygwin upgrade last night (to pick up the latest bison
and get cygutils - it picked up
Andrew,
On Fri, Oct 10, 2003 at 08:56:51AM -0400, Andrew Dunstan wrote:
Jason Tishler wrote:
Are you getting hangs or connection refused errors. The Cygwin
PostgreSQL README documents the following issue:
[snip]
hangs - I have to kill the psql process to continue.
This could mean it will
On Fri, Oct 10, 2003 at 16:36:56 +0900,
Curt Sampson [EMAIL PROTECTED] wrote:
I just happened to try to compile 7.4beta4 on a two-month-old NetBSD-current
system, and I get the following:
In file included from timestamp.c:14:
../../../../src/interfaces/ecpg/include/datetime.h:7:
On Thu, 2003-10-09 at 19:54, Bruce Momjian wrote:
I signed up for an account, and it has already been helpful. I wish I
had known about this years ago. I will probably put together a little
sourceforge project so I can get access to their Solaris and OS X
machines so I will have even
In the last exciting episode, [EMAIL PROTECTED] (Markus Bertheau) wrote:
Forwarding to -hackers as per README
-Пересланное сообщение-
From: Markus Bertheau [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [BUGS] pg_autovacuum segv
Date: 09 Oct 2003 17:30:48 +0200
(gdb) run
What's the last beta version that required initdb?
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
Neil Conway wrote:
On Mon, 2003-10-06 at 16:21, Joshua D. Drake wrote:
postgres=# create user with encrypted password '98wq7912a';
CREATE USER
postgres=# create user with encrypted password '98wq7912a';
ERROR: CREATE USER: user name with already exists
So, what are we doing about
Robert Treat writes:
What's the last beta version that required initdb?
According to this
http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/include/catalog/catversion.h
it was the transition from beta1 to beta2.
--
Peter Eisentraut [EMAIL PROTECTED]
Alvaro Herrera wrote:
On Thu, Oct 09, 2003 at 11:51:09PM -0400, Bruce Momjian wrote:
Alvaro Herrera wrote:
I'm seeing this compile warning on today's CVS tip:
$ make src/backend/commands/tablecmds.o
gcc -O2 -g -Wall -Wmissing-prototypes -Wmissing-declarations -I./src/include
Hi all,
I'm importing on Postgres 7.3.4 a dump and after one hour
the process is still there to perform a COPY of a table with about
~1.5M rows.
I did an strace on it and I had a lot of rt_sigprocmask
comparing to read and write operations.
What is going on?
# strace -p 6370
read(33,
On Fri, Oct 10, 2003 at 09:46:35AM +0900, Tatsuo Ishii wrote:
Satoshi, the only guy who made a trial implementation of 2PC for
PostgreSQL, has already showed that 2PC is not that slow.
If someone has a fast implementation, so much the better. I'm not
opposed to fast implementations!
A
--
On Thu, Oct 09, 2003 at 11:53:46PM -0400, Christopher Browne wrote:
If 2PC gets implemented, that simply means that there will be another
module that some will be interested in, and which many people won't
bother using. Which shouldn't seem to be a particularly big deal.
I think the reason
Bruce Momjian wrote:
This seems to be a bug in gcc-3.3.1. -fstrict-aliasing is enabled by
-O2 or higher optimization in gcc 3.3.1.
Now that I think of it, they might be talking about an optimization
called register aliasing, where they are taking the structure and
mapping it to a CPU register
Andrew Sullivan [EMAIL PROTECTED] wrote:
On Fri, Oct 10, 2003 at 09:46:35AM +0900, Tatsuo Ishii wrote:
Satoshi, the only guy who made a trial implementation of 2PC for
PostgreSQL, has already showed that 2PC is not that slow.
If someone has a fast implementation, so much the better. I'm
OK, I committed a fix so it will not segfault on root starting it.
---
Christopher Browne wrote:
In the last exciting episode, [EMAIL PROTECTED] (Markus Bertheau) wrote:
Forwarding to -hackers as per README
Andrew Dunstan wrote:
Bruce Momjian wrote:
This seems to be a bug in gcc-3.3.1. -fstrict-aliasing is enabled by
-O2 or higher optimization in gcc 3.3.1.
According to the C standard, it's illegal to access a data with a
pointer of the wrong type. The only exception is char *.
This can be used
May have posted this earlier...
It would seem that caching the plans for foreign keys has some unwanted
side effects.
test=# select version();
version
PostgreSQL 7.4beta4 on
Env: Postgres 7.3.4 on Unix
I have a script to create a new database user and update pg_hba.conf.
I was wondering whether I need to restart server, or simply run pg_ctl
reload.
The question is what happens to all active clients when all backends get the
signal.
I ran such client process which
Martha Stewart called it a Good Thing [EMAIL PROTECTED] (Dann Corbit)wrote:
I can't see a grave overhead from this comparison.
2PC is absolutely essential when you have to have both parts of the
transaction complete for a logical unit of work. For a project that
needs it, if you don't have
Why not apply the effort to something already done and compatibly
licensed?
This:
http://dog.intalio.com/ots.html
Appears to be a Berkeley style licensed:
http://dog.intalio.com/license.html
Transaction monitor.
Overview
The OpenORB Transaction Service is a very scalable transaction monitor
Here is a sourceforge version of the same thing
http://openorb.sourceforge.net/
-Original Message-
From: Dann Corbit
Sent: Friday, October 10, 2003 9:38 PM
To: Christopher Browne; [EMAIL PROTECTED]
Subject: Re: [HACKERS] 2-phase commit
Why not apply the effort to something
27 matches
Mail list logo