memory, which seems admirable and typical and
not needful of an attribute on the function declaration.
pure is definitely less confusing IMO, if it's congruent with the weaker
sense of pure that's found in some languages/implementations.
Don Baccus
http://donb.photo.net
http://birdnotes.net
http
On Feb 19, 2012, at 7:24 PM, Tom Lane wrote:
Don Baccus dhog...@pacifier.com writes:
On Feb 19, 2012, at 5:42 PM, Tom Lane wrote:
Hmm, pure doesn't sound bad to me. Nice and short.
Technically, pure is stronger than has no side effects:
http://en.wikipedia.org/wiki/Pure_function
Result
of *this* behavior!
Don Baccus
http://donb.photo.net
http://birdnotes.net
http://openacs.org
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On Feb 18, 2012, at 1:43 PM, Christopher Browne wrote:
On Sat, Feb 18, 2012 at 4:12 PM, Don Baccus dhog...@pacifier.com wrote:
On Feb 18, 2012, at 12:57 PM, Rob Wultsch wrote:
Where first_name is string the queries above have very different
behaviour in MySQL. The first does a full table
.
Don Baccus
http://donb.photo.net
http://birdnotes.net
http://openacs.org
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
in MySQL?
And knowing it's MySQL … oh, probably *not* an error, but like you … I'd be
mystified.
Should 01 like '0%' match?
Don Baccus
http://donb.photo.net
http://birdnotes.net
http://openacs.org
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes
people to read heavy books with the claim that
the truth is somewhere in there ;)
and that's what's I mean when I say he's been arguing from authority.
--
Don Baccus
Portland, OR
http://donb.photo.net, http://birdnotes.net, http://openacs.org
---(end of broadcast
are also implemented by
index. And people also join on columns other than their primary key so
will want indexes on these columns to span tables, also.
--
Don Baccus
Portland, OR
http://donb.photo.net, http://birdnotes.net, http://openacs.org
---(end of broadcast
unnecessary joins, and there's no
getting around it.
And yes I know he's not reading my mail and no, don't bother repeating
this to him, he'll just continue to ignore the point.
--
Don Baccus
Portland, OR
http://donb.photo.net, http://birdnotes.net, http://openacs.org
---(end
...
Here's a lengthier and polite description - he's trying to impress us
with his brilliance which several of us are just too dense to recognize
on our own.
--
Don Baccus
Portland, OR
http://donb.photo.net, http://birdnotes.net, http://openacs.org
---(end of broadcast
Curt Sampson wrote:
On Sun, 11 Aug 2002, Don Baccus wrote:
Oh? Ok, please translate the following into equivalant SQL that
does not use a view:
...
Granulize GRANT to the table column level.
Can you please show me the code for that? After all, I showed you
all of my code when doing
Tom Lane wrote:
Curt Sampson [EMAIL PROTECTED] writes:
On Sun, 11 Aug 2002, Don Baccus wrote:
Granulize GRANT to the table column level.
Can you please show me the code for that?
It's required by the SQL spec. PG hasn't got it, but the spec is
perfectly clear about how it should
than the Oracle bug I mention here.
Overall I rate PG and Oracle as being about equivalent in terms of bugs.
--
Don Baccus
Portland, OR
http://donb.photo.net, http://birdnotes.net, http://openacs.org
---(end of broadcast)---
TIP 5: Have you
utility. As
I mention this is exactly why we choose not to use it at OpenACS.
On the other hand at least we took the time to understand how it
actually does work before criticizing it.
It's a pity, as I pointed out the reduction in joins alone would really
be great.
--
Don Baccus
Portland
the relational
model in theory, just PG and perhaps SQL92 in practice).
--
Don Baccus
Portland, OR
http://donb.photo.net, http://birdnotes.net, http://openacs.org
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http
sugar ...
--
Don Baccus
Portland, OR
http://donb.photo.net, http://birdnotes.net, http://openacs.org
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere
Curt Sampson wrote:
On Sun, 11 Aug 2002, Don Baccus wrote:
I've been wanting to point out that SQL views are really, when
scrutinized, just syntactic sugar ...
Oh? Ok, please translate the following into equivalant SQL that
does not use a view:
CREATE TABLE t1 (key serial
to do with a view.
And views of this sort are trivial to do using PG's OO extensions.
I think I see a trend in this thread. Why not give it up, dude?
--
Don Baccus
Portland, OR
http://donb.photo.net, http://birdnotes.net, http://openacs.org
---(end of broadcast
Curt Sampson wrote:
On Thu, 8 Aug 2002, Don Baccus wrote:
And views of this sort are trivial to do using PG's OO extensions.
So long as you don't mind them being broken, yeah. But hell, when someone
asks for a unique constraint, they probably don't really mean it, do they?
Good grief
as whether or not there's a significant maintenance cost
associated with keeping the existing OO stuff in PG, Tom Lane's voice is
authorative while, when it comes to PG internals, Curt Sampson doesn't
know squat.
--
Don Baccus
Portland, OR
http://donb.photo.net, http://birdnotes.net, http://openacs.org
alizes
that you must follow a close sourced model in order to provide tools for
the corporate world."
- Don Baccus, Portland OR [EMAIL PROTECTED]
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
use they want to get paid for their work and don't choose to give away
their code.
However, I do have the right to make such statements, just as you have the
right to disagree. It's called the first amendment in my country.
- Don Baccus, Portland OR [EMAIL PROTECTED]
Nature photos, on-line guide
es contain bearings and such that are much more likely
to fail than electronics (good electronics and good designs, at least),
mechanical failure's more likely and will be known to whatever is driving
the drive. And you're OK then...
- Don Baccus, Portland OR [EMAIL PROTECTED]
Nature photo
At 05:42 PM 12/2/00 +0100, Peter Eisentraut wrote:
Don Baccus writes:
Exactly what is PostgreSQL, Inc doing in this area?
Good question... See http://www.erserver.com/.
"Advanced Replication and Distributed Information capabilities are also under
development to meet specific
bus
or PG, Inc to release eRServer.
These developments are a major annoyance.
- Don Baccus, Portland OR [EMAIL PROTECTED]
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
OACTION and RESTRICT as being the same, they're
separated in the code with a comment to that effect, i.e. the code for
NOACTION is duplicated for RESTRICT (in part to make it clear that
in the future we might want to implement RESTRICT more efficiently if
anyone figures out how).
- Don Baccus
eal numbers.
Just what was PG, Inc's net revenue last year, and just how does their mixed
revenue model stack up against the OSS world?
(NOT the .com world, which is in a different business, no matter what Thomas
wants to claim).
- Don Baccus, Portland OR [EMAIL PROTECTED]
Nature photos, on-
ng
to test your code, and leaving on vacation.
You were irresponsible then, and you're being irresponsible now.
- Don Baccus, Portland OR [EMAIL PROTECTED]
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
delineate the hopes and goals of the PG community, I'm
fairly disgusted.
- Don Baccus, Portland OR [EMAIL PROTECTED]
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
ls to
make such backups.
Probably the best answer to the "what does WAL get us, if it doesn't
get us full recoverability" questions is to simply say "it's a prerequisite
to getting full recoverability, PG 7.1 sets the foundation and later
work will get us there".
- Don Baccus
will in actuality be written
before the disk subsystem powers itself down.
- Don Baccus, Portland OR [EMAIL PROTECTED]
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
At 11:02 AM 12/1/00 -0800, Nathan Myers wrote:
On Fri, Dec 01, 2000 at 06:39:57AM -0800, Don Baccus wrote:
Probably the best answer to the "what does WAL get us, if it doesn't
get us full recoverability" questions is to simply say "it's a
prerequisite to getting full recover
two-phase commit.
Right.
- Don Baccus, Portland OR [EMAIL PROTECTED]
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
At 03:05 PM 12/1/00 -0800, Alfred Perlstein wrote:
How about adding COPY XML?
(kidding of course about the XML, but it would make postgresql more
buzzword compliant :) )
Hey, we could add a parser and call the module MyXML ...
- Don Baccus, Portland OR [EMAIL PROTECTED]
Nature photos
quot;select table1.* from ...", though, since those
are apparently the only fields you want.
The optimizer should do a better job on your first query, sure, but why
don't you like writing joins?
- Don Baccus, Portland OR [EMAIL PROTECTED]
Nature photos, on-line guides, Pacific North
much
attention from developers.
The insert, at least, can be written in standard SQL anyway...
- Don Baccus, Portland OR [EMAIL PROTECTED]
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
At 10:52 AM 11/30/00 -0500, Tom Lane wrote:
Don Baccus [EMAIL PROTECTED] writes:
The optimizer should do a better job on your first query, sure, but why
don't you like writing joins?
The join wouldn't give quite the same answers. If there are multiple
rows in table2 matching a particular
bad data to be written to both mirrors if both are actively
writing when the plug is pulled.
Power failures are evil, face it! :)
- Don Baccus, Portland OR [EMAIL PROTECTED]
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
it.
If you and I are wrong I'd love to be surprised!
- Don Baccus, Portland OR [EMAIL PROTECTED]
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
a fairly long answer
to a question Tim's posted at phpbuilder.com regarding recoverability and this guy's
undoubtably read it, too.
Have I forgotten anything, xuyifeng?
- Don Baccus, Portland OR [EMAIL PROTECTED]
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service
in queries, so how do you treat them differently? Has to be in the
application code, I guess.
- Don Baccus, Portland OR [EMAIL PROTECTED]
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
ONSTRAINT statement.
This is essentially the case in Oracle, though I suspect you could dig
around, find the name of the unannounced unique index, and drop it by
hand if you wanted.
- Don Baccus, Portland OR [EMAIL PROTECTED]
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
pg_hackers from the distribution
list. I'll try to be more diligent if the discussion continues.
- Don Baccus, Portland OR [EMAIL PROTECTED]
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
ring means something is there, whereas a null
in the same place means complete absense of all data.
Absolutely right, and Oracle's misimplementation truly sucks.
- Don Baccus, Portland OR [EMAIL PROTECTED]
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and oth
removing the limit.
Again, PG 7.1 removes the issue entirely, but it is ironic that so many
people had heard that PG suffered from a hard-wired 8KB limit on tuple
length...
- Don Baccus, Portland OR [EMAIL PROTECTED]
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service
seems to have the impression
that it's not a default, but rather a hard-wired limit.
- Don Baccus, Portland OR [EMAIL PROTECTED]
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
At 11:06 PM 11/27/00 -0400, The Hermit Hacker wrote:
On Mon, 27 Nov 2000, Bruce Momjian wrote:
OK, can someone collect suggestions, add the code, and integrate it for
7.1?
too late in cycle ...
Yes...
- Don Baccus, Portland OR [EMAIL PROTECTED]
Nature photos, on-line guides, Pacific
r as first Free Beer,
and now Free Speech software has caused me to abandon Apache and suggestions
like the above just make me cringe.
It shouldn't be that hard, folks.
- Don Baccus, Portland OR [EMAIL PROTECTED]
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and oth
use persistent connections..
I've heard rumors that PHP isn't thoroughly threadsafe, could this be a
source of your problems?
- Don Baccus, Portland OR [EMAIL PROTECTED]
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
LC_COLLATE to "C" and re-initdb.
For more information see appropriate place in admin guide
Thoughts?
Are you SURE you want to use en_US collation? [no]
(ask the question, default to no?)
Yes, a question in initdb is ugly, this whole thing is ugly.
- Don Baccus, Portland OR [EMAIL
);
end;
' language 'plpgsql';
A select * won't return the_sum
create view test2 select A, B, A+B as the_sum from test;
will, though.
See, lots of ways to do it!
- Don Baccus, Portland OR [EMAIL PROTECTED]
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service
of bolting on any of these to 7.0, I'd be keen to hear
from
you.
Create a trigger on insert/update for this case...
- Don Baccus, Portland OR [EMAIL PROTECTED]
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
After Tom's bug fix, I can now load the data model with no
problem.
Very cool, I'm pumped!
- Don Baccus, Portland OR [EMAIL PROTECTED]
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
At 12:18 AM 11/21/00 -0500, Tom Lane wrote:
Don Baccus [EMAIL PROTECTED] writes:
If this problem is attacked, should one stop at constraints or make certain
that other elements like views are dumped properly, too? (or were views
fixed for 7.1, I admit to a certain amount of "ignoring
here the existing database has been corrupted.
In Oracle parlance, "WAL" log == "REDO" log, and the BAR tool
builds "Archive" logs.
Uhhh...I think, anyway.
- Don Baccus, Portland OR [EMAIL PROTECTED]
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
At 09:14 AM 11/22/00 +0800, Christopher Kings-Lynne wrote:
Is there any particular reason the spelling and punctuation in the code
snippet below is so bad?
Vadim's Russian. This impacts his english but not his ability to implement
complex features like MVCC and WAL :)
- Don Baccus, Portland
At 10:46 AM 11/22/00 +0800, xuyifeng wrote:
Hi,
it's obviously there is a query plan optimizer bug, if int2 type used in
fields,
the plan generator just use sequence scan, it's stupid
Have you checked this with real data after doing a VACUUM ANALYZE?
- Don Baccus, Portland OR [EMAIL
to improving
the docs could accomplish a lot.
- Don Baccus, Portland OR [EMAIL PROTECTED]
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
At 10:19 AM 11/21/00 +, Pete Forman wrote:
Don Baccus writes:
I also hope that the PG crew, and Great Bridge, never stoop so low
as to ship benchmarks wired to "prove" PG's superiority.
I thought that Great Bridge's August benchmarks were rather skewed.
They only used one parti
ule CreatedbStmt references a sixth item that
doesn't exist in the definition.
I've cleaned these up locally (though I just removed the $6 mentioned
last because I have no idea what was intended) so I can compile. Someone
should clean up the CVS sources...
- Don Baccus, Portland OR [EMAIL PR
At 07:20 PM 11/20/00 -0500, Tom Lane wrote:
Don Baccus [EMAIL PROTECTED] writes:
All went well except for a handful of occurances of the following error:
ERROR: SS_finalize_plan: plan shouldn't reference subplan's variable
Fixed, I believe. Your test case now gives
regression=# select
quot;ignoring pgsql-hackers over
the last few months")
- Don Baccus, Portland OR [EMAIL PROTECTED]
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
At 12:03 AM 11/21/00 -0500, Tom Lane wrote:
Peter has remarked that the SQL spec offers a set of system views
intended to provide exactly this info. That should be looked at;
if there's a workable standard for this stuff, we oughta follow it.
This and a BUNCH else.
- Don Baccus, Portland
so late?
(I'm curious because there have been complaints about the mail server here,
and the article is old hat).
- Don Baccus, Portland OR [EMAIL PROTECTED]
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
ere's no reason to
put any faith into their benchmark efforts.
>>>>
- Don Baccus, Portland OR [EMAIL PROTECTED]>
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
At 07:05 PM 11/19/00 +0100, [EMAIL PROTECTED] wrote:
Cam I ask what BAR is ?
Backup and recovery, presumably...
- Don Baccus, Portland OR [EMAIL PROTECTED]
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
-dhogaza.pacifier.net. Just use anonymous ftp, it's in the
pub
directory with an obvious name (sql1992.txt???)
- Don Baccus, Portland OR [EMAIL PROTECTED]
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
they flush only once,
while not delaying cases where only one backend is running.
This sounds like an interesting approach, yes.
- Don Baccus, Portland OR [EMAIL PROTECTED]
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
because people not wrapping
large amounts of inserts/updates with transaction blocks will
suffer.
I think the default should probably be no delay, and the documentation
on enabling this needs to be clear and obvious (i.e. hard to miss).
- Don Baccus, Portland OR [EMAIL PROTECTED]
Nature
ether the code's running
under Oracle or Postgres. That helps us minimize differences in the source.
- Don Baccus, Portland OR [EMAIL PROTECTED]
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
a lot of
work to be done to support the full AOLserver API (same's true of ns_java,
actually).
If you use ADP pages, your use of Tcl is typically restricted to snippets of
code anyway, so I've never really understood the complaints about Tcl...
- Don Baccus, Portland OR [EMAIL PROTECTED
a query generation technique separate from the database server,
generating and executing SQL queries on a set of tables in order to satisfy
some goal.
Has nothing to do with the RDBMS itself.
- Don Baccus, Portland OR [EMAIL PROTECTED]
Nature photos, on-line guides, Pacific Northwest
Rare Bird
something like
"default ''" in your table definition rather than use null. Then you'll be
using
the empty string for concatenation. 'abc' || NULL = NULL. 'abc' || '' =
'abc'
which appears to be what you want.
This is standard SQL92 behavior...
- Don Baccus, Portland OR [EMAIL PROTEC
ything has happened (other than
the thread issuing the query that hosed the backend that died in execution, of
course).
- Don Baccus, Portland OR [EMAIL PROTECTED]
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
expect.
- Don Baccus, Portland OR [EMAIL PROTECTED]
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
. We all will benefit by your working on PG full
time while being paid enough so you can eat, drink, and be merry, too.
- Don Baccus, Portland OR [EMAIL PROTECTED]
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
can always do what they do now - not drop columns.
- Don Baccus, Portland OR [EMAIL PROTECTED]
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
77 matches
Mail list logo