in the s_lock() wait loop, and use test before
test-and-set in TAS() macro to avoid unnecessary bus traffic.
Patch from Manfred Spraul, reworked a bit by Tom.
Not sure if this made the 7.4.3 release ...
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
You knock on that door or the sun
.
Looks like your server doesn't have schema support at all ... what does
select version() give you?
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
www.google.com: interfaz de línea de comando para la web.
---(end of broadcast)---
TIP 5: Have you
... at least this is not the 7.4.2 you just installed.
On Tue, Jun 29, 2004 at 12:07:30PM -0700, Cason, Kenny wrote:
I'm having trouble accessing specific schemas and wonder if maybe I
haven't installed something properly in 7.4.2. Here is what is
happening:
--
Alvaro Herrera (alvherre
On Tue, Jun 29, 2004 at 06:59:20PM -0400, Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
As with the bufmgr.c original patch, I don't really know how to test
that this actually works. [...]
I forgot to mention to you that that code didn't work at all, btw.
Bad news, I guess
?
Seriously, you can check the version() string. If it's got mingw init,
it's win32 native.
So it can't be compiled by other compiler? Say Digital Mars or some
Microsoft or Borland compiler?
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
El día que dejes de cambiar dejarás de vivir
239.15 262.35
220.17 249.42
Min 194.72 225.57
Max 241.37 272.14
Avg 223.12 247.76
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Por suerte hoy explotó el califont porque si no me habría muerto
de aburrido (Papelucho)
---(end of broadcast
and of course a lot of bugs are gone.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
You knock on that door or the sun will be shining on places inside you
that the sun doesn't usually shine (en Death: The High Cost of Living)
---(end of broadcast
to figure out why).
And I think you sent me one other patch recently that didn't make it
into this commit, either.
Yes, it was the password file management. But it was untested; let me
do that first (we need some docs on that file).
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Para tener más
On Thu, Jul 01, 2004 at 09:07:11AM -0400, Alvaro Herrera wrote:
Were your numbers also taken with --enable-cassert? It might be
instructive to compare numbers taken without.
Ah, yes, it was with asserts enabled. I'll try again.
With asserts disabled the situations seems reverted
the whole
transaction tree.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Oh, oh, las chicas galacianas, lo harán por las perlas,
¡Y las de Arrakis por el agua! Pero si buscas damas
Que se consuman como llamas, ¡Prueba una hija de Caladan! (Gurney Halleck)
---(end
for columns that are part of an index, rather than using the datatype.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Porque Kim no hacia nada, pero, eso sí,
con extraordinario éxito (Kim, Kipling)
---(end of broadcast)---
TIP 6: Have you searched our list
On Thu, Jul 01, 2004 at 04:47:09PM -0700, Mike Benoit wrote:
On Thu, 2004-07-01 at 18:38 -0400, Alvaro Herrera wrote:
On Thu, Jul 01, 2004 at 02:01:37PM -0500, Thomas Swan wrote:
If we change the syntax, say by using SUBCOMMIT/SUBABORT for
subtransactions, then using a simple ABORT would
.)
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Always assume the user will do much worse than the stupidest thing
you can imagine.(Julien PUYDT)
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
in SPI -- not sure exactly what, but the effect
would be that the function can't issue BEGIN at all and can only issue
SUBBEGIN.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
A male gynecologist is like an auto mechanic who never owned a car.
(Carrie Snow)
---(end
On Fri, Jul 02, 2004 at 01:09:56PM -0400, Alvaro Herrera wrote:
Sorry:
When the status is SUBCOMMITTED, the bytemask will have 11 for those two
should be bitmask
bytes; therefore, when OR-ing a 10 or 01 mask (committed or aborted),
^ should
On Fri, Jul 02, 2004 at 01:37:46PM -0500, Thomas Swan wrote:
Alvaro Herrera wrote:
Then again, since a statement is always transactionally wrapped, would
it be required to always issue SUBBEGIN if issued from within a
function? This would address my concern.
Isn't this counterintuitive
On Fri, Jul 02, 2004 at 03:32:12PM -0500, Thomas Swan wrote:
Alvaro Herrera wrote:
Please note that I'm using the term transaction block and not
transaction. The distinction is important because everything is
always inside a transaction, though it may be an implicit one. A
transaction
On Fri, Jul 02, 2004 at 11:51:01PM +0200, Jeroen T. Vermeulen wrote:
On Fri, Jul 02, 2004 at 05:30:49PM -0400, Alvaro Herrera wrote:
You can't have subtransactions inside an implicit transaction block, so
Haven't been following this thread closely, but just my 2 cents...
If you collate
On Fri, Jul 02, 2004 at 07:43:47PM -0400, Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
You can't have subtransactions inside an implicit transaction block,
It would be folly to design on that assumption. We *will* have that
situation just as soon as plpgsql allows creating
there is no way to use Parse with libpq calls ... I think this
limits it's applicability as a lot of people uses libpq
(unsurprisingly).
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Sallah, I said NO camels! That's FIVE camels; can't you count?
(Indiana Jones)
---(end of broadcast
2
rollback;
fetch 1 from c; -- returns tuple 1 again
This is mightly ugly but I think it's the most usable of the options
seen so far. I'm not sure how hard is to do that -- maybe it's just a
matter of running PortalStart() again for the cursor?
What do you think?
--
Alvaro
we skip
sinval search too...)
Can we use a cutoff like RecentGlobalXmin here?
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
No reniegues de lo que alguna vez creíste
---(end of broadcast)---
TIP 6: Have you searched our list archives
instructing him on how to pronounce the
thing ... it was rather embarrasing anyway.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
En las profundidades de nuestro inconsciente hay una obsesiva necesidad
de un universo lógico y coherente. Pero el universo real se halla siempre
un paso más allá de la lógica
ignoring unrecognized
states probably wasn't a good idea for the JDBC code...)
What about using the command tag of SUBBEGIN c ?
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Hi! I'm a .signature virus!
cp me into your .signature file to help me spread!
---(end of broadcast
[NESTED] [TRANSACTION|WORK] [transactionname],
ROLLBACK [NESTED] [TRANSACTION|WORK] [transactionname] etc?
Not sure. I already implemented SUBBEGIN. How does that work for
everyone? I don't see much value in overloading BEGIN/ROLLBACK.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
El día que
. At AbortTransaction() and AbortSubTransaction() we would save
the Xid there, using a round-robin scheme.
What do you think?
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
No single strategy is always right (Unless the boss says so)
(Larry Wall)
---(end of broadcast
limitation to using palloc outside
the backend itself? I ask because I have considered using it outside
Postgres several times (a consideration that has never materialized
yet), and I wonder if it needs something special to work.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Dios hizo a Adán, pero
On Mon, Jul 05, 2004 at 05:13:23PM -0400, Bruce Momjian wrote:
Alvaro Herrera wrote:
On Sun, May 02, 2004 at 07:50:46PM -0400, Tom Lane wrote:
It's entirely likely that ecpg's derivative of the backend's datetime
modules contains lots and lots of memory leaks, since AFAIK the palloc
this is the only major problem with the functionality, so
it would be a pity to throw away all work only for this.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
I call it GNU/Linux. Except the GNU/ is silent. (Ben Reiter)
---(end of broadcast)---
TIP
On Sat, Jul 03, 2004 at 02:32:44AM -0500, Thomas Swan wrote:
Alvaro Herrera wrote:
What I'd like to do is start the transaction block before the function
is called if we are not in a transaction block. This would mean that
when the function calls BEGIN it won't be the first one
On Tue, Jul 06, 2004 at 11:37:18AM -0400, Bruce Momjian wrote:
Alvaro Herrera wrote:
On Sat, Jul 03, 2004 at 02:32:44AM -0500, Thomas Swan wrote:
Alvaro Herrera wrote:
What I'd like to do is start the transaction block before the function
is called if we are not in a transaction
On Tue, Jul 06, 2004 at 08:15:14AM +0200, Dennis Bjorklund wrote:
On Mon, 5 Jul 2004, Alvaro Herrera wrote:
begin/end because they are already in an explicit/implicit transaction
by default... How is the user/programmer to know when this is the case?
I'm not sure I understand you
On Tue, Jul 06, 2004 at 12:49:46PM -0400, Stephen Frost wrote:
* Alvaro Herrera ([EMAIL PROTECTED]) wrote:
We could use BEGIN NESTED for starting a subtransaction, roll it back
with ROLLBACK NESTED or some such, and commit with COMMIT NESTED. But I
like SUBBEGIN etc best, and no one had
a directory if it's not
already there. It would mean creating a spurious directory with an
empty file if the data is corrupted and a wrong RelFileNode is in memory
for whatever reason.
The correct solution would be to emit a XLog record for CREATE
DATABASE ...
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl
On Thu, Jul 08, 2004 at 06:33:56PM +0100, Simon Riggs wrote:
On Thu, 2004-07-08 at 16:19, Alvaro Herrera wrote:
On Thu, Jul 08, 2004 at 02:58:01PM +0100, Simon Riggs wrote:
The correct solution would be to emit a XLog record for CREATE
DATABASE ...
I'd prefer a formal approach, hence
tested it using functions in the targetlist (modifying
ExecEvalFunc) and as rangevars (ExecInitFunctionScan and
ExecEndFunctionScan). Maybe ExecEvalOper needs to do the same, if an
operator can be defined as dependant on a function which uses subxacts.
Comments, opinions please?
--
Alvaro
will undoubtly be, when I found this
out :-(
Some sort of modification will be needed to the error processing
mechanism, but this is beyond me at this point ... I don't have any
idea how could this be.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Licensee shall have no right to use the Licensed
. Below if some information on the implementation.
At exactly what time is the quota enforced? Does the enforcement
somehow serialize that operation?
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Thou shalt study thy libraries and strive not to reinvent them without
cause, that thy code may
is executed,
nested transactions created after the SAVEPOINT will be closed.)
So this is another reason why we should use COMMIT to close a nested
transaction: it may refer to a transaction that is already closed
because the user got confused.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
I can't go
has no space, why not just disable the account and/or make
them read-only?
We don't have the functionality for read-only, unless you REVOKE all his
privileges except select.
Anyway I think that you can't really enforce with such granularity, so
this is moot.
--
Alvaro Herrera (alvherre
.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Pensar que el espectro que vemos es ilusorio no lo despoja de espanto,
sólo le suma el nuevo terror de la locura (Perelandra, CSLewis)
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Fri, Jul 09, 2004 at 09:07:58PM +0200, Dennis Bjorklund wrote:
On Fri, 9 Jul 2004, Alvaro Herrera wrote:
Clearly savepoints do not allow for a snapshot to be released; nested
xacts do.
Why not?
What is it?
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Pensar que el espectro que
On Fri, Jul 09, 2004 at 03:34:47PM -0400, Bruce Momjian wrote:
Alvaro Herrera wrote:
On Fri, Jul 09, 2004 at 09:07:58PM +0200, Dennis Bjorklund wrote:
On Fri, 9 Jul 2004, Alvaro Herrera wrote:
Clearly savepoints do not allow for a snapshot to be released; nested
xacts do
On Fri, Jul 09, 2004 at 11:28:23PM +0200, Dennis Bjorklund wrote:
On Fri, 9 Jul 2004, Alvaro Herrera wrote:
Yes, we free some things. Granted it's not a lot, but we have stacks
for several things that will be always be growing with savepoints,
They will not always be growing
On Sat, Jul 10, 2004 at 09:46:56AM +1200, Oliver Jowett wrote:
Alvaro Herrera wrote:
We can't actually release anything (commit the subtransactions), because
they may be savepoints established after that point, and they are
logically inside the previously established ones. At RELEASE we
.
That's why it's absurd. Why allow an operation which isn't really an
operation?
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
God is real, unless declared as int
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index
On Fri, Jul 09, 2004 at 08:03:36PM +0100, Simon Riggs wrote:
On Fri, 2004-07-09 at 16:47, Alvaro Herrera wrote:
So this is another reason why we should use COMMIT to close a nested
transaction: it may refer to a transaction that is already closed
because the user got confused.
Sorry! I
.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
La fuerza no está en los medios físicos
sino que reside en una voluntad indomable (Gandhi)
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
simpler with this.
Opinions please?
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Siempre hay que alimentar a los dioses, aunque la tierra esté seca (Orual)
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan
return one tuple per call, but PL/pgSQL uses only the other
mode, materializing the whole set before return.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
El conflicto es el camino real hacia la unión
---(end of broadcast)---
TIP 9: the planner
subtransaction.
And I'm not planning to do anonymous savepoint. Do these buy us
anything?
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Find a bug in a program, and fix it, and the program will work today.
Show the program how to find and fix a bug, and the program
will work forever (Oliver
and so on.
Stuff that still needs examination:
localbuf refcounts (decide if we are changing bufmgr behavior, first)
EOXact callbacks API needs extension
namespace (temp namespace cleanup)
files
password file
SetReindexProcessing
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Schwern It does
On Tue, Jul 13, 2004 at 10:34:08AM +1200, Oliver Jowett wrote:
Alvaro Herrera wrote:
Fix issues with cursors. Need to mess with open portals at subxact abort.
One quick question here -- how does subtransaction commit interact with
WITHOUT HOLD cursors? I'm hoping they stay open..
That's
the idea that v3 Bind portals
should behave nontransactionally, while DECLARE portals should behave
transactionally. Maybe we could make that a property of the portal, or
even a user-selectable property (where we would define a reasonable
default behavior).
--
Alvaro Herrera (alvherre
On Wed, Jul 14, 2004 at 03:11:54PM -0400, Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
On Tue, Jul 13, 2004 at 04:57:06PM -0400, Tom Lane wrote:
I've been thinking about what to do with cursors in subtransactions.
So within this proposal, a query executed by normal means
, it should be obvious.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Para tener más hay que desear menos
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED
dubious to me.
No, it's not pgStatPipe[1], it's select(2)'s first argument; max fd in
the sets plus one. Probably your code works because
pgStatPipe[1] == pgStatPipe[0] + 1.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Por suerte hoy explotó el califont porque si no me habría muerto
de aburrido
. It goes on to say that BSD and SysV
behaviors differ on this aspect.
(This is on linux BTW)
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
La experiencia nos dice que el hombre peló millones de veces las patatas,
pero era forzoso admitir la posibilidad de que en un caso entre millones,
las patatas
on PopTransaction() and
PushTransaction()? Differences should be treated as FATAL errors, I
presume. Or throw a warning and return doing nothing else.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Tiene valor aquel que admite que es un cobarde (Fernandel)
---(end of broadcast
by signal 6
LOG: aborting startup due to startup process failure
this is 7.3.3 (PGDG rpm's) on red hat 7.2
Get 7.3.6 and try again. IIRC this is a known bug that was repaired in
7.3.4.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Al principio era UNIX, y UNIX habló y dijo: Hello world\n
with this situation
correctly.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Este mail se entrega garantizadamente 100% libre de sarcasmo.
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send
On Fri, Jul 16, 2004 at 01:55:13AM -0400, lists wrote:
thank you for replying.
Alvaro Herrera wrote:
LOG: ReadRecord: unexpected pageaddr 0/33A4000 in log file 0, segment
5, offset 3817472
LOG: redo is not required
PANIC: XLogWrite: write request 0/53A4000 is past end of log 0/53A4000
for savepoint levels, but it doesn't do
anything (yet).
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Hay dos momentos en la vida de un hombre en los que no debería
especular: cuando puede permitírselo y cuando no puede (Mark Twain)
---(end of broadcast
, including why it
happens. Try begin; select test(); commit.
The submitted savepoint patch prevents this from happening, and some
other misbehaviors as well.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
I personally became interested in Linux while I was dating an English major
who wouldn't know
;
~ DEAD LOCK DETECTED
~ abort;
STILL BLOCKED
This is what you expected, wasn't it? When you ABORTed the
subtransaction, the parent did not abort, so it held it locks. So
session 1 does not have the lock it needs.
--
Alvaro
hour or so, because the code has drifted.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Ellos andaban todos desnudos como su madre los parió, y también las mujeres,
aunque no vi más que una, harto moza, y todos los que yo vi eran todos
mancebos, que ninguno vi de edad de más de XXX años (Cristóbal
On Sun, Jul 18, 2004 at 01:16:17AM -0400, Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
First of all, let me point that the behavior on deadlock has been agreed
to change. Instead of only aborting the innermost transaction, it will
abort the whole transaction tree.
Who agreed
, and now I'm
pretty sure of it ...
FYI, this is no longer the case with the savepoints patch I just posted.
It's too late here to check if this solves Gaetano concerns.
Gaetano, please apply the latest savepoints patch (savepoint-5.patch)
and let me know how it goes ...
--
Alvaro Herrera
On Sun, Jul 18, 2004 at 11:00:25AM +0200, Gaetano Mendola wrote:
Alvaro Herrera wrote:
If I abort only the innermost transaction on session 2, the application
writer can have a retry loop on it, so it will issue the begin again
and the same update. Since session 1 is still locked, session 2
On Sun, Jul 18, 2004 at 11:06:19AM +0200, Gaetano Mendola wrote:
Alvaro Herrera wrote:
Gaetano, please apply the latest savepoints patch (savepoint-5.patch)
and let me know how it goes ...
where is it ?
I just sent it by private mail to you (11kb). I don't see it in the
archives
, the code tries to UnlockRelation(pg_largeobject), and
use the main transaction Xid (instead of the subtransaction Xid that it
used to LockRelation()).
So I have changed it to use GetTopTransactionId() instead. Is that OK
with everybody?
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Maybe there's lots
with that.
Cool. Thank you very much.
One thing I noticed is that there are several ways to call a function --
as a rangevar, through SPI, and as normal functions in the executor.
Most likely all of them need some kind of handling.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
No deja de ser
On Fri, Jul 23, 2004 at 09:49:05AM -0400, Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
I just figured that if we let LockRelation use GetCurrentTransactionId()
then the wrong thing happens if we let large objects survive
subtransaction commit/abort.
So I have changed
the actual version number of the file (shown
with cvs log). Can this be a local config error or something strange is
happenning?
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Los románticos son seres que mueren de deseos de vida
---(end of broadcast
feature. Did you try inserting anything into the
tables? How about using rowtypes as function parameters?
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
If you have nothing to say, maybe you need just the right tool to help you
not say it. (New York Times, about Microsoft PowerPoint
, the $PostgreSQL$ header is not honored.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Saca el libro que tu religión considere como el indicado para encontrar la
oración que traiga paz a tu alma. Luego rebootea el computador
y ve si funciona (Carlos Duclós)
---(end
)
http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/access/transam/clog.c.diff?r1=texttr1=1.22r2=texttr2=1.21
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
There was no reply (Kernel Traffic)
---(end of broadcast)---
TIP 1: subscribe
was down, according to a poster ;-)
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
¿Qué importan los años? Lo que realmente importa es comprobar que
a fin de cuentas la mejor edad de la vida es estar vivo (Mafalda)
---(end of broadcast)---
TIP 3
jump.
Oh yes, we have very clear criteria: For patch releases, we increase the
third number, for feature releases we increase the second number and
set the third number to zero. Clear enough?
What was the rule for increasing the first number after just before 7.0?
--
Alvaro Herrera ([EMAIL
the large object work).
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Por suerte hoy explotó el califont porque si no me habría muerto
de aburrido (Papelucho)
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
On Sat, Aug 07, 2004 at 01:34:20AM +0200, Gaetano Mendola wrote:
Alvaro Herrera wrote:
Yeah. I included your tab-complete patch in the patch I sent to
pgsql-patches, which later Tom reworked and applied. His CVS comment
didn't mention the tab completion change. This isn't surprising
On Sat, Aug 07, 2004 at 12:38:10PM +0200, Gaetano Mendola wrote:
Alvaro Herrera wrote:
Subversion and arch have been mentioned, but so far there is no
compelling reason to change. It'd take convincing at least a couple
of core hackers to get the ball rolling ...
Well, I think having seen
for permanent changes.
Also, make sure that when a backend crashes, the final state should be
the same as when the backend exits normally.
I'm not sure the Oracle behavior is the one we want to imitate here ...
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Jude: I wish humans laid eggs
Ringlord
want UNDO to be implemented.
Don't waste your time ...
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
A wizard is never late, Frodo Baggins, nor is he early.
He arrives precisely when he means to. (Gandalf, en LoTR FoTR)
---(end of broadcast
to whitespace; trailing whitespace is now ignored as well as leading
whitespace (which has always been ignored).
/para
/listitem
Whitespace where?
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
No hay ausente sin culpa ni presente sin disculpa (Prov. francés)
---(end
whatever_parameter 'value';
VACUUM ...;
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Licensee shall have no right to use the Licensed Software
for productive or commercial use. (Licencia de StarOffice 6.0 beta)
---(end of broadcast)---
TIP 3
! OK, removed.
How about a TODO for allowing comments for global objects, if there isn't
one already?
--
Alvaro Herrera ([EMAIL PROTECTED])
The West won the world not by the superiority of its ideas or values
or religion but rather by its superiority in applying organized violence.
Westerners
in 8.1.
If we force an initdb for some other reason during beta, we can remove
to_char(interval) at that point too ...
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Siempre hay que alimentar a los dioses, aunque la tierra esté seca (Orual)
---(end of broadcast
On Tue, Aug 17, 2004 at 08:21:13PM -0300, Haroldo Stenger wrote:
Hola,
On Tue, 17 Aug 2004 16:58:56 -0400, Alvaro Herrera Munoz
[EMAIL PROTECTED] wrote:
Establishing a savepoint is a non-trivial operation (cost-wise). Several
internal server structures have to be prepared for it. It's
() traffic which should be cached at the kernel level.
Of course, we should really measure it to be sure ...
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
La web junta la gente porque no importa que clase de mutante sexual seas,
tienes millones de posibles parejas. Pon buscar gente que tengan sexo con
` != '8.0' ]
Isn't there a way to generate this automatically? Why isn't the .spec
file (and the debian directory, for that matter) part of the source
tree?
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
I think my standards have lowered enough that now I think 'good design'
is when the page doesn't
to tiff format or something so we can modify it laster
if we need to, or perhaps gimp format?
It would be even better if some vector format could be produced that
some open source tool could process to generate a bitmap.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
In Europe they call me Niklaus
items list
for 8.0.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
El miedo atento y previsor es la madre de la seguridad (E. Burke)
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
TABLESPACE would be convenent in general.
The problem with ALTER TABLE is that it can be hugely expensive, I think.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Thou shalt check the array bounds of all strings (indeed, all arrays), for
surely where thou typest foo someone someday shall type
if we see the parent in aborted
state too.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Las cosas son buenas o malas segun las hace nuestra opinión (Lisias)
---(end of broadcast)---
TIP 8: explain analyze is your friend
On Fri, Aug 20, 2004 at 01:36:39PM -0400, Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
On Tue, Aug 10, 2004 at 12:24:06PM -0400, Tom Lane wrote:
It may be that we do not care because pg_subtrans doesn't have to be
valid after a crash, but I haven't seen any proof of that theory
/home/alvherre/CVS/pgsql/source/00orig/src/bin/pg_dump/pg_backup_db.c:874: warning:
comparison is always false due to limited range of data type
(yes, both lines), which is kind of strange.
This is
gcc (GCC) 3.4.1 (Mandrakelinux (Alpha 3.4.1-3mdk)
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
La
?)
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
La felicidad no es mañana. La felicidad es ahora
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
no need to restore them, because it is
only used if the system happenned to crash while there was a write in
progress. Supposedly this cannot happen on your hot-spare system.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
La persona que no quería pecar / estaba obligada a sentarse
en duras y empinadas
is a four-dimension integer array:
pg_database oid
pg_classoid
BlockNumber
OffsetNumber
The value would keep how many share-lockers there are.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Cómo ponemos nuestros dedos en la arcilla del otro. Eso es la
301 - 400 of 9686 matches
Mail list logo