On Thu, 28 Sep 2006 11:09:17 -0400
Luke Lonergan [EMAIL PROTECTED] wrote:
Though this may be the kiss of death, I favor a 64 bit float version of
money. It's more terse than numeric and a
I assume you mean ...64 bit INT version...
--
D'Arcy J.M. Cain darcy@druid.net | Democracy
64 bit version.
It does display in a DECIMAL format but just because there is a decimal
point in the output does not make it floating point. All internal
calculations are done as integer arithmetic.
--
D'Arcy J.M. Cain darcy@druid.net | Democracy is three wolves
http://www.druid.net
On Thu, 28 Sep 2006 10:35:01 -0500
Jim C. Nasby [EMAIL PROTECTED] wrote:
Floating point math and hard-earned money are two things that don't mix
well. :)
Using FP to track money is a good way to stop making any. :-)
--
D'Arcy J.M. Cain darcy@druid.net | Democracy is three wolves
done.
Numeric has been shown to be as good or better than money in I/O
operations. Where money shines is in internal calculations.
--
D'Arcy J.M. Cain darcy@druid.net | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting on
+1 416 425 1212 (DoD
money.
--
D'Arcy J.M. Cain darcy@druid.net | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting on
+1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner.
---(end of broadcast)---
TIP 5
but I have received complaints about that. It should probably go back
just because it is outside of the scope of the primary change. That
can be dealt with later.
--
D'Arcy J.M. Cain darcy@druid.net | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep
is
measured in multiples, not in percentages.)
I/O for money seems at least as compareable to numeric if not slightly
better. Other than that it has all the speed advantages as bigint for
basically the same reasons. It's basically bigint with modified input
and output functions.
--
D'Arcy J.M. Cain
banker's rounding. I think that those special rules would
have to be handled in code. In that environment you would probably
want to do that for auditing (code and otherwise) purposes.
--
D'Arcy J.M. Cain darcy@druid.net | Democracy is three wolves
http://www.druid.net/darcy
On Fri, 15 Sep 2006 15:14:10 -
Andrew - Supernews [EMAIL PROTECTED] wrote:
On 2006-09-15, D'Arcy J.M. Cain darcy@druid.net wrote:
On Fri, 15 Sep 2006 10:17:55 -
Andrew - Supernews [EMAIL PROTECTED] wrote:
Presumably the same speed as bigint, which is to say that while it is
faster
) - 0.67us/call
numeric_out(10) - 0.42us/call
Is this really int4out, or is it int8out?
int4out. int8out is slower.
int8out is probably a better comparison since it is the same range.
--
D'Arcy J.M. Cain darcy@druid.net | Democracy is three wolves
http://www.druid.net/darcy
On Fri, 15 Sep 2006 16:15:04 -
Andrew - Supernews [EMAIL PROTECTED] wrote:
On 2006-09-15, D'Arcy J.M. Cain darcy@druid.net wrote:
Seems? Have you benchmarked it?
Not rigourously but a few ANALYZE EXPLAIN statements bear out this
observation.
The overhead of EXPLAIN ANALYZE is so
revision 1.68
diff -u -p -u -r1.68 cash.c
--- src/backend/utils/adt/cash.c14 Jul 2006 14:52:23
- 1.68 +++ src/backend/utils/adt/cash.c 14 Sep 2006
14:28:30 - @@ -1,13 +1,17 @@
/*
* cash.c
* Written by D'Arcy J.M. Cain
+ * darcy@druid.net
+ * http://www.druid.net/darcy
On Thu, 14 Sep 2006 07:59:07 -0700
Joshua D. Drake [EMAIL PROTECTED] wrote:
D'Arcy J.M. Cain wrote:
For years I have been promising that a 64 bit version of the money type
was on the way. Here it is. So far it compiles and I have done some
basic testing on it and it seems to work fine
the output. Would
removing the commas also make sense? These are the sorts of things
that can be added by applications.
--
D'Arcy J.M. Cain darcy@druid.net | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting on
+1 416 425 1212 (DoD#0082)(eNTP
*any* presentation beyond the
actual representation of the data. What if it is not US dollars? :)
That's what locale is for. It looks at that to determine that sort of
stuff including currency symbol before I removed it.
--
D'Arcy J.M. Cain darcy@druid.net | Democracy is three wolves
?
For this scenario you are far better off with partitioning than
replication.
That is if your data is partitionable. But geographically distributed
data often is.
I agree but in this case it wasn't.
--
D'Arcy J.M. Cain darcy@druid.net | Democracy is three wolves
http://www.druid.net/darcy
almost no one.
My experience is that any replication needs to be based on your business
rules which will vary widely.
--
D'Arcy J.M. Cain darcy@druid.net | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting on
+1 416 425 1212 (DoD#0082
solutions are on/off for
In fact this is exactly what I did for my app. Some tables were
multi-master and some were required to be modified from a single master.
--
D'Arcy J.M. Cain darcy@druid.net | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep
be some kid in his
parent's basement and may be the problem. RIPE says that hosteurope.de
is responsible for that IP. You have to take them at their word.
--
D'Arcy J.M. Cain darcy@druid.net | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting
that be the job of the platform providers? Certainly I would
expect NetBSD to make it available as a package, both source and
binary, on every platform they support as they do for the thousands of
other packages they deal with.
--
D'Arcy J.M. Cain darcy@druid.net | Democracy is three
pkgsrc tree. We have a build farm for
packages so I can confirm it for all the platforms we run on.
--
D'Arcy J.M. Cain darcy@druid.net | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting on
+1 416 425 1212 (DoD#0082)(eNTP) | what's
in the framework of the business rules.
--
D'Arcy J.M. Cain darcy@druid.net | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting on
+1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner.
---(end of broadcast
On Fri, 31 Mar 2006 09:35:31 -0600
Jim C. Nasby [EMAIL PROTECTED] wrote:
On Thu, Mar 30, 2006 at 10:15:21AM -0500, D'Arcy J.M. Cain wrote:
I had to do multi-master replication for a major project and we wound
up writing our own replication system. The problem is that this sort of
thing
, that was the conclusion we came to.
--
D'Arcy J.M. Cain darcy@druid.net | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting on
+1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner.
---(end of broadcast
that are likely needed to be done,
and will be available to do so, I eagerly solicit your help. Please
contact me off list in that case.
What type of things will you be needing? I can probably spare some time.
--
D'Arcy J.M. Cain darcy@druid.net | Democracy is three wolves
http
On Thu, 9 Mar 2006 16:18:43 -0500
D'Arcy J.M. Cain darcy@druid.net wrote:
What type of things will you be needing? I can probably spare some time.
Doh! Sorry about that. I did reply instead of reply all thinking it would
only go to Andrew. I didn't meant to send to the list.
--
D'Arcy J.M
possibilities.
--
D'Arcy J.M. Cain darcy@druid.net | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting on
+1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner.
---(end of broadcast)---
TIP 4
On Mon, 2 Jan 2006 16:27:48 -0600 (CST)
Andrew Dunstan [EMAIL PROTECTED] wrote:
Our BSD license is recognised as a GPL-compatible license.
Recognized by who? The only two entities that I can think of that
matter would be GNU itself or the courts.
--
D'Arcy J.M. Cain darcy@druid.net
and you get seven, one more than the first.
Check these out.
test=# SELECT POW(2,-2) AS REALLY_BIG_LABEL;
really_big_label
--
0.25
(1 row)
test=# SELECT POWER(2,-2) AS X;
x
--
0.25
(1 row)
--
D'Arcy J.M. Cain darcy@druid.net | Democracy is three wolves
that can be fixed?
--
D'Arcy J.M. Cain darcy@druid.net | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting on
+1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner.
---(end of broadcast)---
TIP 2
things. I think that in any organization the people get stuff
done regardless of what structure is in place. It depends more on the
people than the structure.
--
D'Arcy J.M. Cain darcy@druid.net | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting
that it solves a
different problem than all those other tools.
--
D'Arcy J.M. Cain darcy@druid.net | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting on
+1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner.
---(end
of modified rows as a parameter?
I don't believe that such a facility exists but before dismissing it you
should test it out. I think that you will find that disk buffering (the
system's as well as PostgreSQL's) will effectively handle this for you
anyway.
--
D'Arcy J.M. Cain darcy@druid.net
and it doesn't sound like we are going backwards.
2. From a marketing standpoint it is easier to sell our bosses/clients
that 8.0.1 is exactly the same as they have running and tested but
without a legal constraint than 8.1 which sounds more like a new
version.
--
D'Arcy J.M. Cain darcy
is guaranteed to
be complex and still not handle everyone's requirements.
--
D'Arcy J.M. Cain darcy@druid.net | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting on
+1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner
On Tue, 23 Nov 2004 07:25:17 -0500
D'Arcy J.M. Cain [EMAIL PROTECTED] wrote:
#0 0x483cafeb in kill () from /usr/lib/libc.so.12
#1 0x483cd0af in __libc_mutex_catchall_stub (m=1212478892)
at /usr/src/lib/libc/thread-stub/thread-stub.c:112
#2 0x4843f0f7 in free (ptr=incomplete type
On Sat, 20 Nov 2004 11:17:48 -0500
Tom Lane [EMAIL PROTECTED] wrote:
D'Arcy J.M. Cain [EMAIL PROTECTED] writes:
I thought that this would have sent everything to both the log and
the screen but I found that the syslog has much more detail. I have
attached that output.
We still need
panther cert198[1332]: [60-1] LOG: 0: database
system is ready
Nov 18 11:49:21 panther cert198[1332]: [60-2] LOCATION: StartupXLOG,
xlog.c:2946
--
D'Arcy J.M. Cain [EMAIL PROTECTED] | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting on
+1 416 425
On Thu, 18 Nov 2004 14:25:41 -0500
Tom Lane [EMAIL PROTECTED] wrote:
D'Arcy J.M. Cain [EMAIL PROTECTED] writes:
Has anyone else had any problem installing plpgsql into a 7.4.6
database? When I try (on NetBSD 2.0RC5) I get the following
message:
createlang: language installation failed
can grab the lock.
Right now I am modifying my lock class (It's in Python) to add a 1
second sleep before trying to grab an existing session. That seems to
work but I hope I can do better.
--
D'Arcy J.M. Cain [EMAIL PROTECTED] | Democracy is three wolves
http://www.druid.net/darcy
On Mon, 08 Nov 2004 12:56:57 -0500
Jan Wieck [EMAIL PROTECTED] wrote:
Hi Jan.
On 11/8/2004 12:03 PM, D'Arcy J.M. Cain wrote:
I checked the FAQ and docs but haven't found anything definitive.
This is my SQL test script:
SELECT pg_backend_pid();
SELECT * FROM pg_stat_activity order
On Mon, 08 Nov 2004 13:07:34 -0500
Tom Lane [EMAIL PROTECTED] wrote:
D'Arcy J.M. Cain [EMAIL PROTECTED] writes:
I checked the FAQ and docs but haven't found anything definitive.
This is my SQL test script:
SELECT pg_backend_pid();
SELECT * FROM pg_stat_activity order by procpid
is this. Is this strategy likely to improve my
transaction processing?
--
D'Arcy J.M. Cain [EMAIL PROTECTED] | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting on
+1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner
--
D'Arcy J.M. Cain [EMAIL PROTECTED] | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting on
+1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner.
---(end of broadcast)---
TIP 3
and
it did not get better with pg_autovacuum help.
Is there any way to find out what's going on?
--
D'Arcy J.M. Cain [EMAIL PROTECTED] | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting on
+1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner
On Tue, 21 Sep 2004 11:00:33 -0400
Tom Lane [EMAIL PROTECTED] wrote:
D'Arcy J.M. Cain [EMAIL PROTECTED] writes:
I had previously mentioned that queries run much different depending
on whether a VACUUM ANALYZE is done or just a plain ANALYZE.
The problem appears to be that it's picking
though.
--
D'Arcy J.M. Cain [EMAIL PROTECTED] | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting on
+1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner.
---(end of broadcast)---
TIP 9
. Perhaps I should submit it as a patch to the existing
money type instead. I have fixed up a few other issues while I was at
it.
--
D'Arcy J.M. Cain [EMAIL PROTECTED] | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting on
+1 416 425 1212 (DoD#0082
of pg_autovacuum would be to run 24/7 so
that there is never big hit on the system. Perhaps it could be designed
to throttle itself based on current system usage though.
--
D'Arcy J.M. Cain [EMAIL PROTECTED]|vex}.net | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep
On Fri, 23 Apr 2004 13:08:30 -0400 (EDT)
Bruce Momjian [EMAIL PROTECTED] wrote:
D'Arcy J.M. Cain wrote:
It seems to me that the point of pg_autovacuum would be to run 24/7
so that there is never big hit on the system. Perhaps it could be
designed to throttle itself based on current system
On December 9, 2003 12:15 pm, Neil Conway wrote:
P.S. While we're contemplating pies-in-the-sky, I'd personally love to
rewrite PostgreSQL in Objective Caml.
I vote for InterCal. :-)
--
D'Arcy J.M. Cain [EMAIL PROTECTED]|vex}.net | Democracy is three wolves
http://www.druid.net/darcy
trigger documentation.
--
D'Arcy J.M. Cain [EMAIL PROTECTED]|vex}.net | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting on
+1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner.
---(end of broadcast
could add more
people with access.
If there are any known updates since the move you can send them directly to me
or to the mailing list at [EMAIL PROTECTED]
--
D'Arcy J.M. Cain
PyGreSQL Development Group
http://www.PyGreSQL.org
---(end of broadcast
and explode just sound
unprofessional to me. Minor point but it's just preference, right?
--
D'Arcy J.M. Cain [EMAIL PROTECTED]|vex}.net | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting on
+1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner
that?
[...]
From an ease of use perspective, it would be one less step.
Why not have pg_dump emit a friendly reminder?
--
D'Arcy J.M. Cain [EMAIL PROTECTED]|vex}.net | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting on
+1 416 425 1212 (DoD#0082)(eNTP
ought to start a transaction block.
Sure but doesn't it also commit it? There's still no transaction open coming
out of the SELECT.
--
D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting on
+1 416 425 1212 (DoD
On Wednesday 05 February 2003 10:12, Tom Lane wrote:
D'Arcy J.M. Cain [EMAIL PROTECTED] writes:
Well, it does appear to be working but it never finishes. Here are two
backtraces. One was taken while it was running and the other after a
kill -9. The primary key file should have had
On Wednesday 05 February 2003 11:49, Tom Lane wrote:
D'Arcy J.M. Cain [EMAIL PROTECTED] writes:
Hmm. This time it passed that point but this happened:
COPY certificate FROM stdin;
NOTICE: copy: line 253677, bt_insertonpg[certificate_pkey]: parent page
unfound - fixing branch
ERROR
interface in the machine which was on a
completely different network than the one I am on now.
What is the implication of smaller read and write size? Will I necessarily
take a performance hit?
--
D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves
http://www.druid.net/darcy
/lwlock.c and
backend/storage/lmgr/spin.c myself and can't find any place that it can get
into an infinite loop without making a system call within the loop. It's
very odd. Also odd, why would running over NFS have any bearing on it if we
could find such a place?
--
D'Arcy J.M. Cain darcy
On Sunday 02 February 2003 12:26, Tom Lane wrote:
D'Arcy J.M. Cain [EMAIL PROTECTED] writes:
Also odd, why would running over NFS have any bearing on it if we
could find such a place?
Yup, 'tis the question. The only theory I have been able to come up
with is that there's something flaky
for the
certificate database which is the 8 million record table that I am trying to
load.
--
D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting on
+1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner
, nothing was logged after the COPY command.
It's possible that the file was corrupted. I will do a new test from scratch
now that I am not switching speeds.
--
D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting
On Saturday 01 February 2003 14:43, Tom Lane wrote:
D'Arcy J.M. Cain [EMAIL PROTECTED] writes:
Here's the log. As you can see, nothing was logged after the COPY
command.
What else was going on? As far as I can see, the code never does a
semop unless it's waiting for some other backend
On Thursday 30 January 2003 18:32, Simon J. Gerraty wrote:
Is postgreSQL trying to lock a file perhaps? Would seem a sensible thing
for it to be doing...
Is that a problem? FWIW I am running statd and lockd on the NetBSD box.
--
D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three
On Thursday 30 January 2003 12:07, Tom Lane wrote:
D'Arcy J.M. Cain [EMAIL PROTECTED] writes:
I have posted before about this but I am now posting to both NetBSD and
PostgreSQL since it seems to be some sort of interaction between the two.
I have a NetAPP filer on which I am putting
please. I think I remember someone else saying that they
use PostgreSQL over NFS so hopefully this is not the situation.
--
D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting on
+1 416 425 1212 (DoD#0082
On Thursday 30 January 2003 14:02, mlw wrote:
Forgive my stupidity, are you running PostgreSQL with the data on an NFS
share?
Yes, sorry. PostgreSQL is running from the local disk but the data is on the
mounted drive.
--
D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves
have and may even suggest fixes if necessary. I have
Bcc'd the engineer on this message and will send anything I get to them.
--
D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting on
+1 416 425 1212 (DoD#0082
the number of decimal places
on output but I am not sure if that would affect the primary benefit of using
it, speed.
--
D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting on
+1 416 425 1212 (DoD#0082)(eNTP
make sense for me. Have it so that OIDs are created by
default if there is no primary key defined and not if there is.
--
D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting on
+1 416 425 1212 (DoD#0082
. It doesn't matter how fast we are, faster is always better.
Other items are of the nature have or not have a feature and people may
disagree whether we need the feature or not but who will ever say that more
speed is not wanted?
--
D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves
On Thursday 16 January 2003 12:23, Neil Conway wrote:
On Thu, 2003-01-16 at 11:42, D'Arcy J.M. Cain wrote:
Is [Oracle RAC] really as simple as it sounds or would we just be
giving up the other two for a new set of problems.
That's a question you should be asking to an authority on Oracle
On Thursday 16 January 2003 20:54, Christopher Kings-Lynne wrote:
toss PostgreSQL in favour of Oracle with Remote Access Cluster (RAC)
software.
You mean Real Application Clusters?
Oops, yes.
--
D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves
http://www.druid.net
On Thursday 16 January 2003 11:59, Adrian 'Dagurashibanipal' von Bidder wrote:
On Thu, 2003-01-16 at 17:42, D'Arcy J.M. Cain wrote:
We are also looking at hardware solutions, multi-CPU PCs with tons (24GB)
of memory. I know that memory will improve access if it prevents
swapping but how
hardware but we are concerned about not having
access to that nice, cheap, generic hardware for when we need to grow again
or for redundant backup.
Thanks for any tips and suggestions.
--
D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves
http://www.druid.net/darcy
was just going to add a pointer to the PyGreSQL page but leave the
code where it was. If we move it won't it make it harder to add it with just
a config option like we do now?
--
D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves
http://www.druid.net/darcy
that I need to be logged in to create a new project.
--
D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting on
+1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner.
---(end
On Friday 03 January 2003 15:24, Tom Lane wrote:
D'Arcy J.M. Cain [EMAIL PROTECTED] writes:
I would love to add PyGreSQL to gborg but no matter how often I log in it
tells me that I need to be logged in to create a new project.
Weird. Maybe you're blocking cookies, or something like
couldn't find anything in the docs or web specifically about this. Does
anyone have any ideas?
Adding hackers as this may be an internal issue.
--
D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting on
+1 416 425
. They run whatever they want - we have people using NetBSD, Linux and
Windows - but they work on one database which is tuned for the purpose. They
can even create their own databases on that system if they want for local
testing.
--
D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three
On August 28, 2002 11:07 pm, Tom Lane wrote:
D'Arcy J.M. Cain [EMAIL PROTECTED] writes:
Hmm. I did give it a harder look and look what jumped out. Both
chkpass_out and chkpass_rout return PG_RETURN_CSTRING but chkpass_out
builds a standard c string while chkpass_rout builds a variable
On August 29, 2002 09:45 am, Tom Lane wrote:
D'Arcy J.M. Cain [EMAIL PROTECTED] writes:
YES! Well, sort of. I didn't have any other operators but while I
thought that both were the same (after all, I contributed it) someone
must have fixed the one in CVS before adding it. The one I
On August 29, 2002 03:37 pm, Tom Lane wrote:
D'Arcy J.M. Cain [EMAIL PROTECTED] writes:
One thing I do see though is that there is a completion issue.
Well, (a) the shell type can't be used for anything till you turn it
into a real type, and (b) the completion issue already exists, and has
.
No difference. It seems that PostgreSQL is too good at catching the problem
before the assert macros see it.
--
D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting on
+1 416 425 1212 (DoD#0082)(eNTP
On August 28, 2002 12:48 pm, D'Arcy J.M. Cain wrote:
On August 28, 2002 09:23 am, Tom Lane wrote:
The behavior looks a lot like a memory clobber, so perhaps the key
variable is some difference in malloc's allocation strategy, causing
two items to be adjacent in NetBSD where
a text type
for both?
Still doesn't explain why no one else sees this though.
Oh, one more datapoint - the error only happens on vacuum analyze, not just
vacuum. Not sure what that means exactly.
--
D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves
http://www.druid.net
On August 27, 2002 02:01 am, Tom Lane wrote:
D'Arcy J.M. Cain [EMAIL PROTECTED] writes:
I have been getting the subject message ever since upgrading to 7.2.1. I
tried 7.2.2 with the same thing. It seems to be related to my chkpass
type (see contrib) as it only happens on tables
On August 27, 2002 09:13 am, Tom Lane wrote:
D'Arcy J.M. Cain [EMAIL PROTECTED] writes:
On August 27, 2002 02:01 am, Tom Lane wrote:
FWIW, I couldn't see any problem in CVS tip. Could you provide an exact
sequence-to-reproduce?
Surely. Create a database (chkpass_test) and, after
that it is an indexable
type and that doesn't seem to have any problem. It is constructed the same
way otherwise. The palloc calls appear to be correct. Can anyone see why
this would suddenly be a problem?
--
D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves
http
arithmetic though. I know that I do a lot of calculations (mostly sums) on
money and going to numeric is going to be a hit. No matter how efficient it
is it can't be as efficient as a cpu register addition.
But maybe I'm wrong and the hit will be negligible.
--
D'Arcy J.M. Cain darcy@{druid
granted to them independent of the underlying tables.
It a nice , distinguishing feature. What other database allows you
to grant one person access to a subset of the colums of a table as
well as a subset of the rows?
--
D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves
http
to come up with anything.
I think one of the values of it is that it is something that no one else
has. It distinguishes us.
--
D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting on
+1 416 425 1212 (DoD#0082
and indexes do not propagate through the roll forward recovery mechanism
properly.
I can live with that. Schemas shouldn't change so often that you can't just
dup any changes to the backup(s).
--
D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves
http://www.druid.net/darcy
the top of my head,
would be pgAccess, pgAdmin and phpPgAdmin ... but I would guess that any
'administratively oriented' interface would face similar problems, no?
PyGreSQL pokes into the catalogues a bit.
--
D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves
http
of the COPY look like?
--
D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting on
+1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner.
---(end of broadcast
* Tom Lane [EMAIL PROTECTED] [020523 10:24]:
D'Arcy J.M. Cain [EMAIL PROTECTED] writes:
Do you mean issue COPY commands with fields or COPY out the fields in a
specific order by using the extension in pg_dump?
I intended that the dump scripts would say something like
COPY mytab
.
--
D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting on
+1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner.
---(end of broadcast)---
TIP 1: subscribe
of the type I naturally have some bias but I still
think that it is a good type for all the reasons we thought it was a good
idea before. There is a definite advantage to being able to do integer
arithmetic right on the CPU in large financial applications.
--
D'Arcy J.M. Cain darcy@{druid|vex
are done, just plug the number into your configuration and get
the plans that you are looking for.
--
D'Arcy J.M. Cain darcy@{druid|vex}.net | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting on
+1 416 425 1212 (DoD#0082)(eNTP) | what's
101 - 200 of 225 matches
Mail list logo