On Tue, Aug 26, 2008 at 9:59 AM, Dave Cramer [EMAIL PROTECTED] wrote:
On Tue, Aug 26, 2008 at 9:37 AM, Alvaro Herrera
[EMAIL PROTECTED] wrote:
Dave Cramer wrote:
Ok, here are the logs from last night
2008-08-26 04:00:02 EDT [25407] LOG: received SIGHUP, reloading
configuration
On Tue, Aug 26, 2008 at 10:56 AM, Alvaro Herrera [EMAIL PROTECTED]
wrote:
Dave Cramer wrote:
On Tue, Aug 26, 2008 at 9:59 AM, Dave Cramer [EMAIL PROTECTED] wrote:
On Tue, Aug 26, 2008 at 9:37 AM, Alvaro Herrera
[EMAIL PROTECTED] wrote:
Certainly not, and that's not what I see
On Tue, Aug 26, 2008 at 11:41 AM, Alvaro Herrera [EMAIL PROTECTED]
wrote:
Dave Cramer wrote:
On Tue, Aug 26, 2008 at 10:56 AM, Alvaro Herrera
[EMAIL PROTECTED]
The only possible explanation for this behavior is that somebody is
signalling the postmaster due to Xid wraparound issues
On Tue, Aug 26, 2008 at 11:51 AM, Dave Cramer [EMAIL PROTECTED] wrote:
On Tue, Aug 26, 2008 at 11:41 AM, Alvaro Herrera
[EMAIL PROTECTED] wrote:
Dave Cramer wrote:
On Tue, Aug 26, 2008 at 10:56 AM, Alvaro Herrera
[EMAIL PROTECTED]
The only possible explanation for this behavior
On Tue, Aug 26, 2008 at 12:10 PM, Alvaro Herrera [EMAIL PROTECTED]
wrote:
Dave Cramer wrote:
AutoVacuumShmem-av_signal[AutoVacForkFailed] = false;
pg_usleep(10L); /* 100ms
*/
SendPostmasterSignal(PMSIGNAL_START_AUTOVAC_WORKER
On Tue, Aug 26, 2008 at 12:21 PM, Alvaro Herrera [EMAIL PROTECTED]
wrote:
Dave Cramer wrote:
Ok, back to why
turns out template0 is the culprit, why is autovac not vacuuming this ?
Hmm ... template0 is not supposed to need vacuuming, because it is
frozen ... is it marked
On Tue, Aug 26, 2008 at 12:50 PM, Alvaro Herrera [EMAIL PROTECTED]
wrote:
Dave Cramer wrote:
Yes
select * from pg_database where datname='template0';
datname | datdba | encoding | datistemplate | datallowconn |
datconnlimit
| datlastsysoid | datfrozenxid | dattablespace
On Tue, Aug 26, 2008 at 1:33 PM, Tom Lane [EMAIL PROTECTED] wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
Dave Cramer wrote:
Well, I'm willing to help debug this, however this is a busy production
database and I need to be able to turn it off for a few hours a day.
Would
changing
On Tue, Aug 26, 2008 at 1:45 PM, Alvaro Herrera
[EMAIL PROTECTED]wrote:
Dave Cramer wrote:
On Tue, Aug 26, 2008 at 1:33 PM, Tom Lane [EMAIL PROTECTED] wrote:
Could we first see a cycle of autovac log output with
log_autovacuum_min_duration = 0?
Otherwise we're not going to get closer
On 24-Aug-08, at 10:12 PM, Tom Lane wrote:
Dave Cramer [EMAIL PROTECTED] writes:
I'd like to stop autovac by changing the conf file then sending the
server a HUP
Uh ... why should that stop an autovac already in progress? I'd
only expect it to affect future launches.
Well, I go
On 24-Aug-08, at 10:17 PM, Alvaro Herrera wrote:
Hi Dave,
Dave Cramer wrote:
I'd like to stop autovac by changing the conf file then sending the
server a HUP
This appears to work, the logs show autovac terminated by
administrative command. Then a few minutes later I see a vacuum
process
On 25-Aug-08, at 10:43 AM, Alvaro Herrera wrote:
Dave Cramer wrote:
Well, I go the extra mile and kill any remaing autovac procs
Here are the logs
2008-08-25 04:00:01 EDT [32276] LOG: autovacuum launcher shutting
down
2008-08-25 04:00:01 EDT [20526] LOG: autovacuum launcher started
I'd like to stop autovac by changing the conf file then sending the
server a HUP
This appears to work, the logs show autovac terminated by
administrative command. Then a few minutes later I see a vacuum
process spawned.
Is it possible that there are timers that aren't being properly
On 27-Jul-08, at 3:00 PM, Stephen R. van den Berg wrote:
Stephen R. van den Berg wrote:
My Pike drivers now support multiple simultaneous portals and
automatic streaming by presending overlapping Execute statements with
a dynamically adapted fetchlimit calculated per select as the query
On 28-Jul-08, at 12:45 PM, Stephen R. van den Berg wrote:
Dave Cramer wrote:
On 27-Jul-08, at 3:00 PM, Stephen R. van den Berg wrote:
Stephen R. van den Berg wrote:
The driver beats libpq in speed by about 62%.
Anyone interested in taking a peek at the (GPL copyright) driver, I
On 21-Jul-08, at 4:28 PM, Andrew Sullivan wrote:
On Mon, Jul 21, 2008 at 01:17:39PM -0700, David E. Wheeler wrote:
pgFoundry ain't the CPAN, alas.
Maybe that's the problem that really needs solving?
One of the big Postgres features is its extensibility. I agree that
the extensions can
On 23-May-08, at 9:20 AM, Tom Lane wrote:
Dave Cramer [EMAIL PROTECTED] writes:
Any word on 8.3.2 ?
Obviously, nothing is happening during PGCon ;-)
There was some discussion a week or so back about scheduling a set of
releases in early June, but it's not formally decided.
Now
Tom,
I believe this is pretty much a show stopper for anyone using jdbc to
upgrade to 8.3.x.
Any word on 8.3.2 ?
Dave
On 31-Mar-08, at 7:26 PM, Tom Lane wrote:
While testing the changes I was making to Pavel's EXECUTE USING patch
to ensure that parameter values were being provided to the
It's pretty easy to test.
prepare the query
and
run explain analyze on the prepared statement.
Dave
On 10-Apr-08, at 5:47 AM, Thomas Burdairon wrote:
Is there any patch available for this one?
I'm encountering troubles with some JDBC queries and I'd like to
test it before asking some help
On 1-Apr-08, at 6:25 AM, Michael Paesold wrote:
Am 01.04.2008 um 01:26 schrieb Tom Lane:
While testing the changes I was making to Pavel's EXECUTE USING patch
to ensure that parameter values were being provided to the planner,
it became painfully obvious that the planner wasn't actually
be changed. The driver does this all the time.
Dave
On 1-Apr-08, at 10:06 AM, Tom Lane wrote:
Dave Cramer [EMAIL PROTECTED] writes:
Was the driver ever changed to take advantage of the above strategy?
Well, it's automatic as long as you use the unnamed statement. About
all that might need
Guillaume,
I for one would be very interested in the JDBCBench code.
Dave
On 1-Apr-08, at 8:35 PM, Guillaume Smet wrote:
On Wed, Apr 2, 2008 at 2:05 AM, Greg Smith [EMAIL PROTECTED]
wrote:
I'm not sure if all of those changes are net positive for PostgreSQL
though, they weren't last time I
Tom,
I believe you were the one to object to this proposal pre 8.3 ?
To me it seems innocuous. Most high level db abstractions allow access
to the underlying connection.
Dave
On 17-Mar-08, at 7:26 AM, Mike Aubury wrote:
Request Overview
Add a function to return the
On 8-Mar-08, at 11:06 AM, Suresh wrote:
Hello all,
I have a custom code written inside postgres in an application we use.
The snippet is as below :
Here inner plan is an index scan.
scandesc = ((IndexScanState *)innerPlan)-iss_ScanDesc;
flag=index_getmulti(scandesc, tidelm-tid, 1,
This is a postgresql 8.2.5 backend. connected to a jdbc client.
2008-02-21 06:12:30 EST [18880] 10.21.0.21 ERROR: insufficient data
left in message
2008-02-21 06:12:30 EST [18880] 10.21.0.21 STATEMENT: select * from
user_profile,user_profile_access where user_profile.uid=user_profile_a
]
user=mocospace_user,db=jnj FATAL: invalid frontend message type 105
Is this all the same error, just logged twice or is this two
connections instances ?
Dave
On 21-Feb-08, at 10:39 AM, Tom Lane wrote:
Dave Cramer [EMAIL PROTECTED] writes:
This is a postgresql 8.2.5 backend. connected
On 12-Nov-07, at 10:10 AM, Simon Riggs wrote:
On Mon, 2007-11-12 at 14:35 +, Tom Dunstan wrote:
Nice try :), but as I read the javadoc for DialectFactory it seems to
suggest that hibernate gets the major number from our JDBC driver,
which dutifully reports it as 8.
We can extend that so
On 12-Nov-07, at 11:33 AM, Tom Dunstan wrote:
On Nov 12, 2007 4:08 PM, Alvaro Herrera [EMAIL PROTECTED]
wrote:
What should the driver report then ? I believe the backend code
considers 8
to be the major version, and 0123 to be the minor versions ?
No, 8.1 is the major version. In 8.2.5,
I think C is how the JDBC driver is written. We name the statements
if they have been used more than prepareThreshold times.
So we have a mechanism by which to allow statements to be cached, or
not.
Dave
On 6-Mar-07, at 1:14 PM, Tom Lane wrote:
Gregory Stark [EMAIL PROTECTED] writes:
On 13-Jan-07, at 7:24 PM, Tom Lane wrote:
Jignesh Shah [EMAIL PROTECTED] writes:
The appserver is basically using bunch of prepared statements that
the
server should be executing directly without doing the parsing again.
Better have another look at that theory, because you're clearly
Currently says
Number of disk-page buffers allocated in shared memory for WAL data.
The default is 8. The setting need only be large enough to hold the
amount of WAL data generated by one typical transaction, since the
data is written out to disk at every transaction commit. This
On 11-Jan-07, at 12:49 PM, Tom Lane wrote:
Dave Cramer [EMAIL PROTECTED] writes:
the point is that the documentation suggests that the default is 8
not 8MB, but 8, when in fact the defaults are now given in memory
units not pages
Oh, I thought you were complaining that the value
On 31-Oct-06, at 11:51 PM, Tom Lane wrote:
Dave Cramer [EMAIL PROTECTED] writes:
These are logs from Beta 2.
With what logging settings? log_duration has rather different
behavior
from what it used to do.
to be honest I don't know, and looking at the logs I suspect that
this is just
On 1-Nov-06, at 6:18 AM, Simon Riggs wrote:
On Tue, 2006-10-31 at 23:51 -0500, Tom Lane wrote:
Dave Cramer [EMAIL PROTECTED] writes:
These are logs from Beta 2.
With what logging settings? log_duration has rather different
behavior
from what it used to do.
I think it would be useful
These are logs from Beta 2.
Did I miss a discussion where we removed the name of the portal
during parse, and bind ?
5715%2006-11-01 01:02:26.631 PST%454862a0.1653%SELECT LOG: execute
S_2: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state,
t0.c_zip, t0.c_phone, t0.c_credit,
This belongs on the jdbc driver list
On 27-Oct-06, at 6:29 AM, lasitha weerasinghe wrote:
Hi,
I'm using postgresql 8.1-407 jdbc driver with postgresql 7.4.13
database and it seems like there is an issue when the driver is
used in jdbc transactions. I'm using this version of the jdbc
This is a server bug, I will post to hackers for you, it has little
to do with JDBC, however the ? can't be a column in a prepared statement
DAVE
On 24-Oct-06, at 4:45 PM, JEAN-PIERRE PELLETIER wrote:
Hi,
I have a query that throws org.postgresql.util.PSQLException: An I/
O error occured
On 25-Sep-06, at 4:31 AM, Markus Schaber wrote:
Hi,
I just read the docs about DELETE RETURNING in 8.2, and a small
idea arised:
INSERT INTO logtable DELETE * FROM lifetable WHERE date'2006-01-01'
RETURNING *;
Will this work as expected?
What is your expected result here ? It would
On 22-Sep-06, at 3:58 AM, Markus Schaber wrote:
Hi, Alvaro,
Alvaro Herrera wrote:
I am aware that more recent versions 8.x have fixed this
problem, I
checked the 7.4 release notes but can't see if any of the fixes
made it
into 7.4.
Usually, only critical data loss and security fixes
I am aware that more recent versions 8.x have fixed this problem, I
checked the 7.4 release notes but can't see if any of the fixes made
it into 7.4.
Did they ?
Dave
---(end of broadcast)---
TIP 6: explain analyze is your friend
I realize this isn't the forum for this, but it's the closest thing
to it.
In order to move to pgfoundry I need the CVS repository. I can get it
myself if I can login to gborg, or can someone tar it up and put it
somewhere ?
Dave
---(end of
Dave,
On 7-Sep-06, at 10:32 AM, Dave Page wrote:
-Original Message-
From: Dave Cramer [EMAIL PROTECTED]
To: PostgreSQL-development pgsql-hackers@postgresql.org
Sent: 07/09/06 12:48
Subject: [HACKERS] getting access to gborg, specifically the jdbc
CVS files
In order to move
On 6-Sep-06, at 3:27 AM, Magnus Hagander wrote:
Yes they are using a connection pool. A java based one.
Since java has it's own protocol implementation, this is
totally
unrelated to any libpq error messages.
Another important point that we've not been given information
on:
when
On 6-Sep-06, at 6:01 PM, Tom Lane wrote:
I happened to notice that the recently added code to log Bind-message
parameters was printing garbage into my log. On investigation it
turned
out to be trying to print an already-pfree'd string. That's fixable,
but having looked at the code
On 6-Sep-06, at 6:17 PM, Tom Lane wrote:
Dave Cramer [EMAIL PROTECTED] writes:
On 6-Sep-06, at 6:01 PM, Tom Lane wrote:
* It doesn't log the values of parameters sent in binary mode, which
is something that at least JDBC needs.
AFAIK, we don't need binary mode right away, currently we
On 5-Sep-06, at 6:05 PM, Joshua D. Drake wrote:
Alvaro Herrera wrote:
Tom Lane wrote:
Joshua D. Drake [EMAIL PROTECTED] writes:
Fail in what way. Hang, not connect, or get an error msg?
Just verified with customer. Once the problem occurs the first
time, the customer will continually get
On 5-Sep-06, at 7:00 PM, Joshua D. Drake wrote:
Tom Lane wrote:
Dave Cramer [EMAIL PROTECTED] writes:
On 5-Sep-06, at 6:05 PM, Joshua D. Drake wrote:
Yes they are using a connection pool. A java based one.
Since java has it's own protocol implementation, this is totally
unrelated to any
On 31-Aug-06, at 2:58 PM, Tom Lane wrote:
Peter Eisentraut [EMAIL PROTECTED] writes:
Gregory Stark wrote:
Driver interfaces expose very clearly to the user an explicit
interface to prepare and execute a query separately.
The JDBC documentation merely contains statements of the sort A SQL
On 31-Aug-06, at 6:01 PM, Tom Lane wrote:
Joshua D. Drake [EMAIL PROTECTED] writes:
Tom Lane wrote:
BTW, are you sure this is coming from JDBC? I see the exact same
message text in libpq:
libpq_gettext(server sent data (\D\ message) without prior row
description (\T\ message)\n));
Maybe
On 17-Jul-06, at 6:37 PM, Marc G. Fournier wrote:
On Tue, 18 Jul 2006, Hannu Krosing wrote:
Ühel kenal päeval, E, 2006-07-17 kell 22:01, kirjutas Martijn van
Oosterhout:
On Mon, Jul 17, 2006 at 12:18:46PM -0400, Andrew Dunstan wrote:
Well, I am not making any promises right now about when
Andrew,
Josh did something like this and I wrote some java to do some of it.
It's in a project called pgconfigurator (I think)
dave
On 12-Jul-06, at 2:46 PM, Andrew Hammond wrote:
Is there any interest in a basic perl script that would read through a
postgresql.conf file and calculate
maintaining it on a
regular basis.
Dave Cramer acquainted me with some of the difficulties of doing a
Java
PL today, and I understand why it needs to be that large. However,
38,000 lines of code -- much of it in a non-C language -- presents a
possible debugging/maintenance major headache, especially
On 13-Jul-06, at 9:29 AM, Jonah H. Harris wrote:
On 7/12/06, Tom Lane [EMAIL PROTECTED] wrote:
I don't really think anyone would want to run both, but
that's just my opinion.
On what grounds do you not think that?
Too much Java overhead on one database and PL/J isn't that stable.
I've
On 13-Jul-06, at 1:02 PM, Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
I also cannot maintain Java, but we could do something like we do
with
WIN32, where outside folks submit patches to fix problems.
However, a win32 failure breaks only the win32 buildfarm members ...
Absolutely PL/J should be considered in the same light as PL/Java.
Consider this a request for PL/J to be included in the core.
Dave
On 11-Jul-06, at 12:50 PM, Josh Berkus wrote:
David,
It's good to integrate things with the core as needed. What plans do
we have to integrate PL/J?
None,
On 12-Jul-06, at 10:44 PM, Tom Lane wrote:
Jonah H. Harris [EMAIL PROTECTED] writes:
On 7/12/06, David Fetter [EMAIL PROTECTED] wrote:
Are they mutually exclusive? I can imagine, at least for
development
purposes, that someone might want to install both.
I believe both can be installed
Is it possible to use a binary copy of the cluster on a 64 bit build
of pg 7.4.x that was created on a 32bit bild of 7.4.x
assuming x is the same and integer-date-times are not enabled ?
Dave
---(end of broadcast)---
TIP 1: if posting/reading
On 23-May-06, at 10:24 AM, Richard Huxton wrote:
Dhanaraj M wrote:
I have the following doubts.
1. Does postgres create an index on every primary key? Usually,
queries are performed against a table on the primary key, so, an
index on it will be very useful.
Yes, a unique index is used
I've sent 3 previous messages to the list, and none of them have
arrived, or been bounced.
Dave
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so
Hi,
You have to start a background process, then attach to it. If this is
possible in eclipse then it should work.
Typically everyone uses gdb.
Dave
On 9-Apr-06, at 10:55 PM, 李峰 wrote:
pgsql-hackers！
Hi , I want to use eclipse to compiler the postgresql source code
and debug them on
On 28-Mar-06, at 10:48 AM, Thomas Hallgren wrote:
Hi Simon,
Thanks for your input. All good points. I actually did some work
using Java stored procedures on DB2 a while back but I had managed
to forget (or repress :-) ) all about the FENCED/NOT FENCED stuff.
The current discussion
On 28-Mar-06, at 12:11 PM, Thomas Hallgren wrote:
Tom Lane wrote:
Thomas Hallgren [EMAIL PROTECTED] writes:
This FENCED/NOT FENCED terminology would be a good way to
differentiate between the two approaches. Any chance of that syntax
making it into the PostgreSQL grammar, should the need
The last time I talked to him Laszlo said he is working on it again.
Dave
On 28-Mar-06, at 2:21 PM, Thomas Hallgren wrote:
Dave Cramer wrote:
What exactly is a FENCED solution ? If it is simply a remote
connection to a single JVM then pl-j already does that.
Last time I tried to use pl-j
Has anyone built postgresql on this platform ?
Does it work ?
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
I am confused, I thought that there were only supposed to be links to
the actual data in pg_tblspc ?
I have a db defined in a tablspace, but in pg_tblspc there is 1.2G of
data corrresponding to it?
Dave
---(end of broadcast)---
TIP 5: don't
Tom,
Thanks, this was driver error
Dave
On 13-Feb-06, at 9:26 AM, Tom Lane wrote:
Dave Cramer [EMAIL PROTECTED] writes:
I am confused, I thought that there were only supposed to be links to
the actual data in pg_tblspc ?
I have a db defined in a tablspace, but in pg_tblspc
Is it possible to just not replicate the internal tsearch tables ?
Dave
On 21-Dec-05, at 4:37 PM, Dave Cramer wrote:
Thanks, that might be easier than first thought.
Dave
On 21-Dec-05, at 2:04 PM, Tom Lane wrote:
Dave Cramer [EMAIL PROTECTED] writes:
Is it possible to add the old
I am getting the following error(s) when replicating tsearch2 from v 7.4.x to v 8.1.0remoteWorkerThread_1: copy from stdin on local node - PGRES_FATAL_ERROR ERROR: function "spell_init(text)" does not [EMAIL PROTECTED] CONTEXT: COPY pg_ts_dict, line 1, column dict_init: "spell_init(text)"the
Thanks, that might be easier than first thought.
Dave
On 21-Dec-05, at 2:04 PM, Tom Lane wrote:
Dave Cramer [EMAIL PROTECTED] writes:
Is it possible to add the old signatures back for backward
compatibility ? Something like a tsearch2-compat lib ?
The old signatures were security holes. We
Other than backing up $PGDATA
and running pg_resetxlog
Is there any advice ?
Dave
Nov 16 18:03:30 dx1-ptr postgres[22337]: [6-2] '2005-11-16 17:47:31'
Nov 16 18:03:32 dx1-ptr postgres[29335]: [2-1] LOG: received fast
shutdown request
Nov 16 18:03:32 dx1-ptr postgres[29335]: [3-1] LOG:
Apparently the machine hung in between those two times.
I don't have any specific information, I am debugging remotely over
the phone.
Dave
On 16-Nov-05, at 5:21 PM, Tom Lane wrote:
Dave Cramer [EMAIL PROTECTED] writes:
Nov 16 18:03:32 dx1-ptr postgres[23410]: [4-1] LOG: shutting down
this would seem to complicate things quite a bit.
Dave
On 14-Nov-05, at 12:12 AM, Tom Lane wrote:
Dave Cramer [EMAIL PROTECTED] writes:
I was thinking that it may be necessary to issue a describe before
the execute, but I'm thinking now that the driver can only handle
specific types, so anything outside
Is there a way to force select * from foo to use binary values ?
Dave
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
it would help.
Thx,
Dave
On 13-Nov-05, at 10:21 PM, Tom Lane wrote:
Dave Cramer [EMAIL PROTECTED] writes:
Is there a way to force select * from foo to use binary values ?
In what context?
There is a provision for that in the V3 extended-query protocol.
regards, tom lane
Tuna is running
Dave-Cramers-Computer:~ davec$ uname -a
Darwin Dave-Cramers-Computer.local 8.2.0 Darwin Kernel Version 8.2.0:
Fri Jun 24 17:46:54 PDT 2005; root:xnu-792.2.4.obj~3/RELEASE_PPC
Power Macintosh powerpc
gcc --version
powerpc-apple-darwin8-gcc-4.0.0 (GCC) 4.0.0 20041026 (Apple
I fail to see how this solves the problem of getting auto generated
keys.
AFAIKS, the protocol needs to be tweaked to return at a minimum the
currval for the first serial in the row, but more correctly all of
the modified currval's for an insert
if we had that then we could correctly
On 17-Oct-05, at 12:43 PM, Tom Lane wrote:
Martijn van Oosterhout kleptog@svana.org writes:
On Mon, Oct 17, 2005 at 09:12:35AM -0400, Dave Cramer wrote:
AFAIKS, the protocol needs to be tweaked to return at a minimum the
currval for the first serial in the row, but more correctly all
On 17-Oct-05, at 1:43 PM, Martijn van Oosterhout wrote:
On Mon, Oct 17, 2005 at 01:32:22PM -0400, Dave Cramer wrote:
The JDBC problem at hand is there is a method which allows one to
retrieve the
autogenerated keys from an insert. I can understand Tom's argument
here. It should
be possible
Actually, I think there is a case where 24:00 is a proper time. Isn't
it used for adding leap seconds ?
Dave
On 26-Sep-05, at 3:39 AM, Dennis Bjorklund wrote:
On Sun, 25 Sep 2005, Tom Lane wrote:
Alternatively: why are we forbidding the value 24:00:00 anyway? Is
there a reason not to
I'm not even sure that the new output does tell me the same thing.
I certainly prefer the previous output. I think this will be very
confusing to users
who aren't familiar with the internals of postgres.
Dave
On 13-Sep-05, at 11:44 PM, Joshua D. Drake wrote:
Hello,
It seems the new VACUUM
On 8-Sep-05, at 2:18 AM, Thomas Hallgren wrote:
Peter Eisentraut wrote:
Thomas Hallgren wrote:
Well, yes. But use the word environment in singular please :-) To my
knowledge the security is full-proof with all other VM's since they
all use the standard runtime libraries.
It's not
On 8-Sep-05, at 2:18 AM, Thomas Hallgren wrote:
Peter Eisentraut wrote:
Thomas Hallgren wrote:
Well, yes. But use the word environment in singular please :-) To my
knowledge the security is full-proof with all other VM's since they
all use the standard runtime libraries.
It's not
Well don't forget sablevm, and jamvm. there's quite a few around.
Dave
On 8-Sep-05, at 9:48 AM, Thomas Hallgren wrote:
Dave Cramer wrote:
Actually the apache guys are doing another one (Harmony), and
there is Kaffe. Hardly relevant to the conversation, just added
for completion
I
On 8-Sep-05, at 3:45 PM, Thomas Hallgren wrote:
Tom Lane wrote:
Actually, I've just been discussing this with Red Hat's gcj people in
connection with a different project. What they say is that the Java
security manager is completely implemented now, but what is still
missing is that it's
On 6-Sep-05, at 11:37 AM, Mark Wong wrote:
On Fri, 2 Sep 2005 15:50:25 -0400
Dave Cramer [EMAIL PROTECTED] wrote:
On 2-Sep-05, at 3:38 PM, Mark Wong wrote:
Hi Dave,
Oops, EJB's are distasteful? My experience in this area is quite
lacking.
Well, I said personally distasteful
Mark,
I'd like to help out, let me know what you need help doing.
Personally, doing this with EJB's is distasteful, but I'll help where
I can.
Dave
On 2-Sep-05, at 12:53 PM, Mark Wong wrote:
Hi everyone,
I've starting putting together a kit based on the TPC-App, which is a
This is from my Powerbook
in /etc/rc
sysctl -w kern.sysv.shmmax=512 kern.sysv.shmmin=1
kern.sysv.shmmni=32 kern.sysv.shmseg=8 kern.sysv.shmall=1024
I also had to up maxprocperuid to 200 to get buildfarm to run
I'm pretty sure shmall had to be increased to allow shmmax to be
As there are two java procedural languages which are available for
postgreSQL Josh asked for an explanation as to their differences.
They are quite similar in that both of them run the function in a
java vm, and are pre-compiled. Neither attempt to compile the code.
The biggest difference
On 17-Aug-05, at 12:40 PM, Thomas Hallgren wrote:
Andrew Dunstan wrote:
Dave Cramer wrote:
As there are two java procedural languages which are available
for postgreSQL Josh asked for an explanation as to their
differences.
They are quite similar in that both of them run the function
On 15-Aug-05, at 1:30 PM, Joshua D. Drake wrote:
Hello,
I have negotiated with the author of pl/Ruby to release plRuby
under the PostgreSQL license. The reason I did this is the following:
1. I felt we needed a truly OO language in core.
Why ? Are you truly going to write huge OO
Well, if we are going to consider pljava for the main distribution,
then we should consider pl-j for inclusion as well.
Dave
On 16-Aug-05, at 11:53 AM, Josh Berkus wrote:
Folks,
I think you should take a closer look at PL/Java for the following
reasons:
Hmmm, this brings up a good
I think the point Denis is trying to make is that postgresql will get
much more exposure if SugarCRM works with
it out of the box.
Not taking away from any of these other great projects, but to get
mindshare postgresql needs to work with existing projects.
Dave
On 9-Aug-05, at 7:55 AM,
://archives.postgresql.org
---(end of
broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Dave Cramer
[EMAIL PROTECTED]
www.postgresintl.com
ICQ #14675561
jabber [EMAIL PROTECTED
Jamie,
That's strange, I have 8.03 building fine on 10.4 ? Did you simply do
a make without a make clean and run configure again ?
Dave
On 20-Jul-05, at 3:37 AM, Jamie Deppeler wrote:
Hi, i have just installed 10.4 on one of our machines and cannot
get past this error during make
gcc
It appears to be getting the wrong address for tsearch()
Program received signal EXC_BAD_ACCESS, Could not access memory.
Reason: KERN_PROTECTION_FAILURE at address: 0x011b
0x9009a7c8 in tsearch ()
However if I set a break point for tsearch, I get
br tsearch
Breakpoint 5 at 0xe08c64: file
Do the transaction id's used in 2PC need to be unique across all
sessions?
Do we provide a mechanism for this ?
If not shouldn't we provide a way to create a unique transaction id ?
Dave Cramer
[EMAIL PROTECTED]
www.postgresintl.com
ICQ #14675561
jabber [EMAIL PROTECTED]
ph (519 939 0336
In reality all it takes is a sequence, however if it were system
generated it would be simpler
Dave
On 30-Jun-05, at 6:46 PM, Alvaro Herrera wrote:
On Thu, Jun 30, 2005 at 06:39:43PM -0400, Dave Cramer wrote:
Do the transaction id's used in 2PC need to be unique across all
sessions?
Yes
I'm thinking of the situation where one transaction occurs on more
than one backend, and there is
more than one transaction manager.
Dave
On 30-Jun-05, at 7:37 PM, Oliver Jowett wrote:
Dave Cramer wrote:
Do the transaction id's used in 2PC need to be unique across all
sessions
On 30-Jun-05, at 8:00 PM, Oliver Jowett wrote:
Dave Cramer wrote:
I'm thinking of the situation where one transaction occurs on
more than
one backend, and there is
more than one transaction manager.
XA XIDs are *global* IDs, i.e. they are unique even with more than one
TM involved
This is an interesting suggestion, particularly the addition of
additional connections for management
However it does require all clients rewrite (yet again ) their
connection code.
My reasoning for suggesting a separate port for debugging are:
1) no changes to existing clients ( this
101 - 200 of 365 matches
Mail list logo
