e the
major difficulty here is that currently a transaction has no way of
knowing when another backend's command started to run?
Is this too difficult to do or is it a good idea that no one has enough
'round tuits for?
Regards,
Paul Tillotson
---(end of broadcast)---
TIP 6: explain analyze is your friend
pages and (b) causing the extra
complexity such as the bugs mentioned in VACUUM FULL.
So: what are the t_ctid chains good for? If this is too long or too
elementary to type, can someone point me to the source code that uses
t_ctid chains?
Regards,
Paul Tillotson
---
nge the
round_var() to a trunc_var() at the end of the function div_var().
It does not pass, but I think that is because the regression test is
expecting that division will round up. (Curiously, the regression test
for "numeric" passes, but the regression test for aggregation--sum()
2. Simple tables can be much smaller since you don't need
most of the HeapTupleHeaderData.
What you are talking about is not a "read only" table, it is a
"non-MVCC" table. This is a much greater assault on the fundamental
semantics of Postgres than it's being painted to be in this thr
Jim C. Nasby wrote:
On Wed, Apr 20, 2005 at 08:10:23PM -0400, Paul Tillotson wrote:
P. S.
The last time I thought about it, I decided that the best solution is
probably one that works just like vacuum full except that it scans the
table in reverse order. It would do something like this
could
test the idea without writing any code at all.
Regards,
Paul Tillotson
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Tom Lane wrote:
Paul Tillotson <[EMAIL PROTECTED]> writes:
Hm? Using md5 is certainly not any *more* dangerous than any of the
other possible password-based methods.
Maybe I misunderstood, but I thought that others were saying that, if
someone gets the contents of pg_shadow, then
hashes.
Perhaps for 8.1 a new authentication method, say, "securemd5," ought to
be created in which remedies this deficiency?
Regards,
Paul Tillotson
*Interesting mental exercise: if all that your SQL injection allows is
to add conditions to a WHERE clause evaluated as superuser,
Are you thinking of coding this, or just suggesting it for others? I
was thinking of coding something like this but found that I didn't
understand enough of the internals of how the vacuum command actually
works to be able to write this. I'd be willing to devote perhaps a few
hours a
omments? Am I missing some obvious way of accomplishing this goal? Is
anyone working on something like this?
Paul Tillotson
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
This is the first I have ever heard "user locks," but I have more than
once wanted a lock that would persist beyond the end of a transaction.
Do these do that?
Paul
"Merlin Moncure" <[EMAIL PROTECTED]> writes:
... is there any merit to promoting the user lock wrappers out of contrib
Dun
this be provided by the client and kept in RAM only?
Paul Tillotson
Murat,
For our research project, I need to implement an encryption support for
Postgressql. At this current phase, I need to at least support page
level encryption In other words, each page that belongs to a certain
sensitive
pport for NULLS, etc.
(2) Upon a casual read of the docs I couldn't figure out how to read any
values from the database other than what was passed into the
pl{perl|python|php} function. I.e., how do you run a select? What client
libraries do you use? Maybe the others just need better d
iming for users who had a clue quotient much lower than I, but
those attain an excellent balance between too short and simple to be
useful and too long and complicated.
Paul Tillotson
---(end of broadcast)---
TIP 1: subscribe and unsubscribe comman
Can anyone show me where to download a zipped tarball of .html files of
what exists at the following link?
http://www.postgresql.org/docs/7.4/static/index.html
Thanks.
Paul
---(end of broadcast)---
TIP 2: you can get off all lists at once with th
7;$old_table';");
exec("UPDATE pg_class SET relfilenode = $table1node WHERE relname =
'$new_table';");
You would of course need to change the relfilenode for all of the
toasted columns and indexes as well in the same atomic step, but it
seems like this might be more compatib
16 matches
Mail list logo
