On Feb 19, 2012, at 7:24 PM, Tom Lane wrote:
> Don Baccus 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&
this thread after "leakproof" was settled on and was curious as to
what "leakproof" was supposed to be as I didn't read the earlier posts. I
assumed it meant "doesn't leak memory", which seems admirable and typical and
not needful of an attribute on the funct
On Feb 18, 2012, at 1:43 PM, Christopher Browne wrote:
> On Sat, Feb 18, 2012 at 4:12 PM, Don Baccus wrote:
>>
>> On Feb 18, 2012, at 12:57 PM, Rob Wultsch wrote:
>>>
>>> Where first_name is string the queries above have very different
>>> behaviour
e rise to the defense 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
meone showed it to me without mention MySQL I'd say:
"oh, it's an error".
>
> What *does* it do 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 Ba
7;s
six-shooter to be capable of shooting Tonto's arrows.
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
ter,
Even if primary keys were forced to be generated from a sequence (a very
artificial restriction), unique constraints 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.
-
ple"not true"
> statements and suggesting 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
behavior ...
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
--
tional view approach requires 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.ph
f very limited 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.
--
ar less
spectacular 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)--
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
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 sh
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
&g
tinized, "just syntactic 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 "un
"foo"
dotlrn=#
Which doesn't exist in the view approach in PG at least (I'm unclear on
standard SQL92 and of course this says nothing about the relational
model in theory, just PG and perhaps SQL92 in practice).
--
Don Baccus
Portland, OR
http://donb.photo.net, http://bir
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 p
ble as
>>well.
>
>
> This is trivial 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://o
ACS project,
because when researching PG we compared datamodels written in this style
vs. modelling the object relationships manually with automatically
generated views. We found the datamodel written using PG's OO
extensions not only potentially more efficient, but more readable as wel
s that more and more requests to ease porting from Oracle
to Postgres are cropping up.
This says that more and more people from the "real" RDBMS world are starting to take
Postgres seriously.
- Don Baccus, Portland OR <[EMAIL PROTECTED]>
Nature photos, on-line guides, Pac
n many enterprise-level commercial environments this isn't such a big deal.
Since your (Bruce's) hopes for a wealthy future depends on GB IPO'ing which
will only come with significant penetration of the enterprise commercial environment,
I humbly suggest you don't write them off
he probability that the
disk will actually be writing a block when the power goes off. The
dice aren't quite so loaded against the server with this lowered
disk activity...
- 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.
ly, you can use RAID. Are there open-source journaling filesystems that
offer filesystem-level replication out there?
- 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.
fit into a single PG block). Users using the default will
be able to store rows of *awesome* length, efficiently.
- 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.
y medication, otherwise my demons
might disappear. I'm a regular miracle of medical science until I forget
to take them.
- 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.
to partially
abandon the open source development model for one that is (in some cases) closed
for two years and (in other cases) forever.
- 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.
rce will
be released regardless? Can the community inspect the agreement so we can judge
for ourselves whether or not this assurance is adequately backed by contract
language?
Are your agreements Open Source? :)
- Don Baccus, Portland OR <[EMAIL PROTECTED]>
Nature photos, on-line guid
dware/driver, the other side of the mirror
can faithfully reproduce them on the mirror!)
But since drives 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 wh
rresponsible"
>because 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
n source can't
provide enterprise solutions" variety. "Look, even PostgreSQL, Inc realizes
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.
have to say I'm feeling pretty silly about raising such an effort to
increase PG awareness in mindshare vs. MySQL. I mean, if PG, Inc's
efforts somehow 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.
gainst the "zero revenue business model" be proven by showing
us some real 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
crewing up PG 7.0 just before beta, without bothering
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.
o dismiss open source software out-of-hand.
Couldn't you think of something better, at least? Like ... something
original?
> The .com'ers are trying it at the moment, and there seems to be
>a few flaws... ;)
That's a horrible analogy, and I suspect you know it, bu
formation that occurs on
the database are equivalent.
Currently, PG treats NOACTION 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
bout what this
signals for their future direction.
If PG, Inc starts doing proprietary chunks, and Great Bridge remains 100%
dedicated to Open Source, I know who I'll want to succeed and prosper.
- Don Baccus, Portland OR <[EMAIL PROTECTED]>
Nature photos, on-line guides, Pac
ving us with a potential code fork? If IB gets its political problems
under control and developers rally around it, two years is going to be a
long time to just sit back and wait for 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.
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
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]>
ote site acks that
>it got the WAL" is (akin to) the familiar 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.
e most active developers
(Jan and Tom) work for Great Bridge, not PostgreSQL, Inc...
I should think Vadim should play a large role in any effort to add WAL-based
replication to Postgres.
- 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
g system thinks have been written 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.
ht. That's what's missing in PG 7.1, the existence of tools 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, P
e's not talking about using tar on a running
database. BAR tools are needed, as Vadim has pointed out here in
the past.
- 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.
and
>AOLServer's connection pooling (for lack of a better word) stuff.
Well, meanwhile I've gotten confirmation from folks in the PHP world
(via an openacs forum) that it still isn't threadsafe, though there's
an effort underway to track down the problems. I don't kn
you can't run the WAL against 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.
ainst power failure, which can
cause 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
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 ar
ndard, so is unlikely to get 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.
but it is more readable and cleaner SQL as
well. I would never write the query in its first form. I'd change the
second one slightly to "select table1.* from ...", though, since those
are apparently the only fields you want.
The optimizer should do a better job on your first
ect sysdate();
Then "select sysdate from dual", "select (any expression) from dual", etc all do what
you'd 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.
ts full transaction
semantics, archive logging and recovery from REDO logs and all that
will save him? :)
Again ... he's a troll, not even a very entertaining one.
- 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.
ng to ignore him from now on, suggest others do the same, I'm sure
he'll go away eventually.
- 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.
no longer be possible) with a CREATE/DROP INDEX
>command, and instead would be achieved with a functional ALTER TABLE
>ADD/DROP CONSTRAINT 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
ha
isn't clear (or rather
IM's so flakey one can't really explore enough to see how expensive
auto-update on a busy site would be).
- 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.
this is harder than it sounds! NULL and '' are indistinguishable
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.
x27;t be released before Christmas day. I also posted 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 phot
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]>
Na
was only lamenting the fact that the world 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.
Perdue's article on
PHP Builder implied the same when he spoke of PG 7.1 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 PROTECT
h a feature as any other key feature in
>PG.
>With the advent of unlimited file and record lengths in 7.1, this would be a good
>time to
>include it.
>
>FTI is particularly useful in the context of web content engines.
Well ... it's pretty inadequate, actually. That might
ow created.
SQL> select count(*) from fubar where some_string is null;
COUNT(*)
--
1
SQL>
- 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.
ature of Oracle, though, because porting from SQL92
to Oracle can be very difficult if the SQL92 compliant code depends on the
empty
string being different than NULL. Going to SQL92 from Oracle is easier and
you
can write the Oracle queries and inserts in an SQL92-compliant manner.
Benefits of doing so
) or rewrite his queries
to treat empty string as being the same as NULL explicitly.
>Null values are actually quite important because they tell you when you
>don't have data. An empty tring means something is there, whereas a null
>in the same place means complete absense of all data.
my machine with my forgetting to remove 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.
At 12:38 AM 11/27/00 -0700, Ron Chmara wrote:
>Don Baccus wrote:
>> At 12:07 AM 11/26/00 -0500, Alain Toussaint wrote:
>> >how about having a middle man between apache (or aolserver or any other
>> >clients...) and PosgreSQL ??
>> >that middleman could
directly related to
>PostgreSQL but only happens when I 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 Nor
r database stuff the release of AOLserver 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
the application from any such
problems altogether. The particular problem being described simply
can't occur in this environment.
- 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.
t
>you want. We recommend you set LC_COLLATE to "C" and re-initdb.
>For more information see
>
>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, Port
tty good chance it does.
- 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.
opment.
>
>If anyone has a way 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.
>);
>
>create function the_sum (test) returns integer as
>'
> begin;
> return ($1.a + $1.b);
> end;
>' language 'plpgsql';
>
>A select * won't return the_sum
create view test2 select A, B, A+B as the_sum from test;
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.
teers.
I'm not denigrating the current efforts, because PG documention's pretty
good all things considered. But some volunteers devoted 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: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 Baccu
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 :)
-
ade disk
controllers, etc :)
BAR tools will allow recovery via archives of WAL logs applied
to an archive of the database, to recreate the database in the
case where the existing database has been corrupted.
In Oracle parlance, "WAL" log == "REDO" log, and the BAR tool
builds &
from the MySQL folk.
That's good. Have the MySQL folk made any effort to reciprocate?
- 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
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 benchmark
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 Ba
ave been liars and cheaters for years, there'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.
lem 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 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.
anything but have
lots of users, scaling well under high levels of load rule.
My thinking is that intellegent caching coupled with a highly-scalable
database wins. That's the world I'm used to...
- Don Baccus, Portland OR <[EMAIL PROTECTED]>
Nature photos, on-line guid
s all this e-mail showing up 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.
uot;select for
update" where Jan felt it was necessary. Whether or not that's sufficient
is another question, but he obviously gave it *some* thought.
- 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.
isit too rarely for a system to want to cache my query
returns involved in building my home page, but I'm sure there are many
cases where caching would help).
Again, you have to balance query cache RAM consumption against the benefits
of extra RAM availability to the RDBMS (assuming you h
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. Y
.
The first clause for rule 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...
-
p,
existence_public_p, new_member_policy, multi_role_p)
select nextval(''user_group_sequence''), v_group_type, v_short_name,
v_pretty_name, v_system_user_id, ''0.0.0.0'', ''t'', ''f'', ''closed'',
v_multi_role_p
where not exists (select * from user_groups
where upper(short_name) = upper(v_short_name));
RETURN 1;
end;' language 'plpgsql';
insert into users (user_id) values(1);
insert into user_group_types
(group_type, pretty_name, pretty_plural, approval_policy)
values
('group', 'Group', 'Groups', 'open');
select user_group_add('group', 'shortname', 'prettyname', 'f');
[pgtest@gyrfalcon pgtest]$
- 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.
s would tend to bunch up flushers so 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
dea at
>all. Fixing it at 1/200 isn't so great 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).
f the SQL92 draft (the one that's circulated among this
group in
the past) at dsl-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.
uence_name')" depending on whether 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.
r Python, though there's still 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...
- Do
At 11:38 PM 11/12/00 -0500, Michael Fork wrote:
>Thought this may be of interest to some...
>
>http://www.phpbuilder.com/columns/tim20001112.php3
I just submitted it to slashdot, what the heck :)
- Don Baccus, Portland OR <[EMAIL PROTECTED]>
Nature photos, on-line guides, Pa
1 - 100 of 112 matches
Mail list logo
