responsability. You can do any amount of
testing you want to make sure it's good enough for you. And you are
welcome to report how it did behave.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Investigación es lo que hago cuando no sé lo que estoy haciendo
(Wernher von Braun)
---(end
together.
Certainly; see the www.debian.org for an example. They have
multilingual capabilities across the whole site.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Cómo ponemos nuestros dedos en la arcilla del otro. Eso es la amistad; jugar
al alfarero y ver qué formas se pueden sacar del otro
unique within a schema ...
(But what happens to the constraint name when the table is renamed?)
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
No renuncies a nada. No te aferres a nada.
---(end of broadcast)---
TIP 9: the planner will ignore your desire
On Fri, Nov 07, 2003 at 10:24:04AM -0500, Bruce Momjian wrote:
Maybe a developer of the month feature. :-)
It would be quite cool if, say, General Bits could ocassionaly carry an
interview with a Postgres developer.
(Now that would be a mess to translate)
--
Alvaro Herrera (alvherre
really thinks
that developer things _have_ to be apart?
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
No hay hombre que no aspire a la plenitud, es decir,
la suma de experiencias de que un hombre es capaz
---(end of broadcast)---
TIP 8: explain
qualified
person to do it.
I don't know much about articles, but if you can put some work on
updating your book it would be really cool.
I don't have an opinion on the Win32 issue.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
No renuncies a nada. No te aferres a nada.
---(end
with the idea of unifying www, advocacy, and
developer. Techdocs and Gborg will stay seperate becuase they're based on
different technology.
Cool. I thought I had understand otherwise on a mail from Robert Treat.
Sorry for the confusion.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
La rebeldía es la
anything else.
err... so, how does MagicPoint use Postgres? I suppose it's only
because some of us use it to give Postgres talks and such ;-)
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
On the other flipper, one wrong move and we're Fatal Exceptions
(T.U.X.: Term Unit X - http
that is set at least on my
sources (TOAST_INDEX_HACK).
So, there you are: the compression used is the same lousy fast LZ
algorithm used elsewhere in the TOAST code (toast_compress_datum()).
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
FOO MANE PADME HUM
---(end of broadcast
. This
is not guaranteed to work. It is recommended to upgrade the server, or
downgrade the tool.
Try
SELECT version();
and psql --version
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Just treat us the way you want to be treated + some extra allowance
for ignorance.(Michael
1068792370.0
5 1068793317.53 1068793317.6
6 1068794369.38 1068794369.47
[too slow]
Ok, so inserting 6 rows seems to take 0.09 seconds, and inserting
5000 takes only 0.01. And your problem is exactly what?
--
Alvaro Herrera
story.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
You liked Linux a lot when he was just the gawky kid from down the block
mowing your lawn or shoveling the snow. But now that he wants to date
your daughter, you're not so sure he measures up. (Larry Greenemeier)
---(end
the
unplug-the-server game. In theory you could rewrite the block
subsystem to fail, simulating a real disk failure and possible a
system shutdown. I don't have time to do it myself right now however ...
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Find a bug in a program, and fix
, to allow using
multiple indexes simultaneously ...
--
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
cycle.
Well, I think one of the simplest is to do a topological sort of objects
in pg_dump (between object classes that need it), AND regression
testing for pg_dump :)
One of the most complex would be to avoid the need of pg_dump for
upgrades ...
--
Alvaro Herrera ([EMAIL PROTECTED])
I call
management == table partitioning?
It was just an example. Another example could be a B-Tree sorted heap
(like an index, but with the whole tuple at the leaf pages instead of a
pointer to the heap). There was a thread about this some time ago.
It seemed a good idea ...
--
Alvaro Herrera (alvherre
files now?
Looks fine in CVSup. But in src/port I now see a file named x that
appears to be the old dirmod.c,v ...
BTW, I can see a whole lot of files with the executable bit:
find pgsql-server/ -type f -perm +0333 -ls
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Those who use electric razors
of the other optional
packages that PostgreSQL supports.
Both default directories are wrong according to my installation. In
fact, both libraries are just in /usr/lib. Certainly it will be a mess
trying to compile with a different LDFLAGS if things are added randomly.
--
Alvaro Herrera
for this
node in the query tree.
Maybe it could only be done for SeqScan and IndexScan nodes, which are
probably the most common source of bad estimates related to poor
statistics.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
At least to kernel hackers, who really are human, despite occasional
rumors
?
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Just treat us the way you want to be treated + some extra allowance
for ignorance.(Michael Brusser)
---(end of broadcast)---
TIP 2: you can get off all lists at once
be doing lots of translation work too, or maybe enable
someone else to do it ...)
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Dios hizo a Adán, pero fue Eva quien lo hizo hombre.
---(end of broadcast)---
TIP 6: Have you searched our list archives
On Wed, Nov 26, 2003 at 10:11:20PM -0800, ow wrote:
--- Alvaro Herrera [EMAIL PROTECTED] wrote:
On Thu, Nov 27, 2003 at 12:40:28AM +0100, Andreas Pflug wrote:
A common mistake, can't count how often I created this one... And not
easy to find, because EXPLAIN won't explain triggers
On Thu, Nov 27, 2003 at 06:30:54PM +0100, Peter Eisentraut wrote:
Alvaro Herrera writes:
(I will probably be doing lots of translation work too, or maybe enable
someone else to do it ...)
I think in 7.5 we'll be able to get everything fully translat{ed|able}.
We already have initdb
an implicit mechanism would be better. Because otherwise you will
have an SQL command in there which is off standard - putting a switch
into the application seems to be a fairly ugly solution.
That's why you delegate the job to something else, like pg_autovacuum or
cron ...
--
Alvaro Herrera
with
zero_damaged_pages enabled. Rather than expecting DBAs to think of that
under the stress of a crashed-database situation, I propose that we do
it for them:
Sounds like a good idea to me.
Yes, but is the error message going to stay verbatim? Maybe the
category could be decreased ...
--
Alvaro
it
reference the bychar in pg_type table.
So, where is the Char() length information store ??
atttypmod is the maximum length + 4.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
El destino baraja y nosotros jugamos (A. Schopenhauer)
---(end of broadcast
concurrent
operation and it's far more tested.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
No reniegues de lo que alguna vez creíste
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
.
It does not appear to be that difficult to add the functionality needed
to extract random atoms, but there's some hacking involved.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Cuando no hay humildad las personas se degradan (A. Christie)
---(end of broadcast
already got that one right. Now you
need to go after the encoding.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
El destino baraja y nosotros jugamos (A. Schopenhauer)
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ
.
pg_block_size ?
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
God is real, unless declared as int
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
guesses. If one could use
parametrized views instead of functions the whole mess would probably be
more optimal.
Maybe there's a TODO here?
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Ninguna manada de bestias tiene una voz tan horrible como la humana (Orual)
---(end
?
Maybe it would be better to avoid using system commands
altogether and copy the whole thing using syscalls ...
--
Alvaro Herrera ([EMAIL PROTECTED])
Use it up, wear it out, make it do, or do without
---(end of broadcast)---
TIP 5: Have you checked
were storing OIDs of tables or functions or views
in user tables, this procedure would break the references. But that
would be true of a dump/reload under current procedures as well. I'm
willing to say that that's unsupported.
Large objects included?
--
Alvaro Herrera (alvherre
qualify for an early place on the
'gotchas' page (cf. http://sql-info.de/mysql/gotchas.html) if
PostgreSQL had one.
BTW, what happened to the $QUOTE$ quoting idea? Was it applied, or
even developed?
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
The problem with the future is that it keeps
CLUSTER does, and how can i use it?
Everything You Always Wanted To Know About CLUSTER
http://www.postgresql.org/docs/7.4/static/sql-cluster.html
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
El que vive para el futuro es un iluso, y el que vive para el pasado,
un imbécil (Luis Adler, Los
implementation in this development cycles?
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
A male gynecologist is like an auto mechanic who never owned a car.
(Carrie Snow)
---(end of broadcast)---
TIP 7: don't forget to increase your free space map
into the new database. Now my queries are running faster. Try it.
All the very best.
You could instead apply CLUSTER to the affected tables. (I'm assuming you
already apply VACUUM periodically and REINDEX as appropiate)
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Everybody understands Mickey
, and INSTALL too.
What about having them generated from some Make target, so the curious
user could generate it on his own, and is also built by Marc's
ficticious package-prep target?
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
El sabio habla porque tiene algo que decir;
el tonto, porque tiene que
page and maybe other
nonstandard things (such as telling the root split operation what root
page are you going to split), but you will get recovery and concurrency
(at least to a point) for free.
Hope this helps,
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
La espina, desde que nace, ya pincha
, the project is to adapt Postgres as a Xapian backend ... I think
it is much more straightforward to use the BTrees that Xapian already
uses, than to use GiST. Plus, GiST already has an interface for
fulltext indexing, doesn't it?
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
La victoria es para quien
and that is enough for me, but for Tom's and other people's
patches.
IIRC somebody offered to do this not long ago ...
--
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 irritate the living f*ck out of me. (JWZ
enough motivation to track it down...
It displays perfectly in Windows :)
I see it OK on Mandrake Linux too, FWIW.
rxvt -fn -*-fixed-medium-r-normal-*-*-140-75-75-*-*-iso8859-15
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
La grandeza es una experiencia transitoria. Nunca es consistente
similar episode some time ago, and Elein summed it up
nicely in General Bits:
http://www.varlena.com/GeneralBits/45.php
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
El sentido de las cosas no viene de las cosas, sino de
las inteligencias que las aplican a sus problemas diarios
en busca del progreso
On Sat, Jan 24, 2004 at 02:46:06PM -0500, Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
I am currently building outside the source tree so that I don't have
these problems. It works fine, except that some files are created in
the source tree anyway. I think it's mostly output
of vegetal
living form anyway). I suppose Cape Kennedy was filled with those
plants and that's what the name comes from.
I dunno if Chris' machine's name derives from that or not; Merriam
Webster does not list any other meaning for that word.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
The Gord
to put the per-page entries into page number order
before you scan 'em. You might come out ahead anyway, not sure.
Is there a reason sort the pages before scanning them? The result won't
come out sorted one way or the other.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Para tener más hay que
On Fri, Jan 30, 2004 at 07:43:06AM -0800, Edwin S. Ramirez wrote:
Is is possible to change the transaction behaviour not to abort when a
syntax error occurs.
Not currently.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
And as an added bonus, now my computer goes to the toilet for me, leaving
) 3.3.1 (Mandrake
Linux 9.2 3.3.1-2mdk)
(1 fila)
(This is CVS tip as of a couple weeks ago)
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
El destino baraja y nosotros jugamos (A. Schopenhauer)
---(end of broadcast)---
TIP 1: subscribe and unsubscribe
On Wed, Feb 04, 2004 at 11:06:29AM -0800, Joe Conway wrote:
Alvaro Herrera wrote:
I think this is most surprising behavior -- shouldn't the UPDATE raise
an error?
Surprising, but not new (probably has been there back to the Berkley
code), and has come up before on one of the lists (I think
experience what you want to know about such errors is the actual
disk filename, which RelFileNode tells you and relation name doesn't.
I agree it's best to have the filename in the error message, but IMHO
the relation name should also be presented to the user for clarity.
--
Alvaro Herrera (alvherre
On Thu, Feb 05, 2004 at 04:55:44PM -0500, Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
Another way to do it would be keeping the list of files to delete along
with the deleting Xid, but that would also require keeping a list of
which xacts aborted and which ones didn't
, umlsim.sourceforge.net
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
El destino baraja y nosotros jugamos (A. Schopenhauer)
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command
.
--
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
ciervos incendiánse, y el computador dirá especifique el tipo de ciervo
(Jason Alexander
where I am heading. Maybe then
we can have the opinion from the devel community about both things,
whether they should be applied or not.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
El miedo atento y previsor es la madre de la seguridad (E. Burke)
---(end of broadcast
, aren't you?
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
We take risks not to escape from life, but to prevent life escaping from us.
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining
Hackers,
I'm (again) trying to get my hands dirty on the nested transaction
thingie. Hopefully I will have a lot more commitment this time ...
I'm currently looking at whatever is missing in the description below.
If you see anything that isn't being considered please let me know.
--
Alvaro
to it.
Or do you diff two versions of a patch to see if the author only changed
what he says he changed? Wow, a diff of a diff, _that_ should be
difficult to read.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Use it up, wear it out, make it do, or do without
---(end
, at http://sources.redhat.com/rhdb/
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Use it up, wear it out, make it do, or do without
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail
the transaction mechanism.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
The eagle never lost so much time, as
when he submitted to learn of the crow. (William Blake)
---(end of broadcast)---
TIP 2: you can get off all lists at once
and
DBMirror.
I wonder what would you use DBMirror for once Slony-I is complete?
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
El destino baraja y nosotros jugamos (A. Schopenhauer)
---(end of broadcast)---
TIP 8: explain analyze is your friend
, which this is not ...
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
El hombre nunca sabe de lo que es capaz hasta que lo intenta (C. Dickens)
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
from working properly.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
La gente vulgar solo piensa en pasar el tiempo;
el que tiene talento, en aprovecharlo
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan
relation should be local to the database, shouldn't it?
If this is so, why does it matter that he has open transaction on a
different database?
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
www.google.com: interfaz de línea de comando para la web.
---(end of broadcast
used.
Maybe an easier way is to examine the output of cpp src/include/c.h.
--
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
then allows me to rollback the transaction.
Why is a portal kept active after a utility statement fails? I've been
reading tcop/postgres.c but I can't find what's different between
utility and non-utility.
Any clues?
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
People get annoyed when you try
package would be
enough.
If not, maybe pg_config could provide all the necessary info ...
--
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)---
TIP 7
replication
solution, none of them should be considered 'part of the backend' ...
You are thinking of dbmirror, while Joe talks about dblink. It's
orthogonal functionality ...
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Cuando miro a alguien, más me atrae cómo cambia que quién es (J. Binoche
foo); the system then allows me to rollback the transaction.
Obviously I have to drop the unnamed portal in some kind of
AtSubAbort_Portals ... this means I will have to bite the bullet and get
a new transaction ID, which I was kind of postponing ... sorry for the noise.
--
Alvaro Herrera (alvherre
Reading symbols from /usr/lib/gconv/ISO8859-1.so...done.
Loaded symbols for /usr/lib/gconv/ISO8859-1.so
0x in ?? ()
(gdb) bt
#0 0x in ?? ()
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
The only difference is that Saddam would kill you on private, where the
Americans will kill you
in a special way?
Or maybe it is a compilation switch. What issues would arise?
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Before you were born your parents weren't as boring as they are now. They
got that way paying your bills, cleaning up your room and listening to you
tell them how idealistic you
line 2391, using strdup.
What else?
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Syntax error: function hell() needs an argument.
Please choose what hell you want to involve.
---(end of broadcast)---
TIP 9: the planner will ignore your desire
On Fri, Apr 23, 2004 at 10:31:46PM -0400, Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
In current (as of a couple hours ago) clean CVS tip sources, without any
of my local changes, I'm getting a postmaster segfault when trying to
connect to a non existant database.
Hmm, works
as supplied at creation.
Why do you want two names? Just keep the original casing, and a boolean
saying if it's quoted or not.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
No deja de ser humillante para una persona de ingenio saber
que no hay tonto que no le pueda enseñar algo. (Jean B. Say
On Tue, May 11, 2004 at 09:25:37PM +0100, Simon Riggs wrote:
On Tue, 2004-05-11 at 16:33, Bruce Momjian wrote:
Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
Hmm ... I think it should be forbidden to quote a subtrans Xid as
rollforward point. Not sure if that can be done
On Tue, May 11, 2004 at 11:07:47PM +0100, Simon Riggs wrote:
On Tue, 2004-05-11 at 22:26, Alvaro Herrera wrote:
Right. What I was saying is that we don't need pg_subtrans info,
because that's only needed while the subtransaction is marked as
subcommitted but it's parent hasn't committed
transaction abort. Same for catcache entries. Does anyone
think this is incorrect?
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
No hay cielo posible sin hundir nuestras raíces
en la profundidad de la tierra(Malucha Pinto)
---(end of broadcast
, but do not include this
one. Does that make sense? Does everything we have support that?
Hmm ... I think it should be forbidden to quote a subtrans Xid as
rollforward point. Not sure if that can be done though, or how to do
it.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
La gente vulgar solo
On Tue, May 11, 2004 at 10:37:49AM -0400, Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
Hmm ... I think it should be forbidden to quote a subtrans Xid as
rollforward point. Not sure if that can be done though, or how to do
it.
Seems like a nonissue, unless the XLOG trace
= mainTransactionXid, which would carry the committed
subtransactions.
Does this make any sense? Ideas, comments?
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
No reniegues de lo que alguna vez creíste
---(end of broadcast)---
TIP 1: subscribe
...
commit
...
commit
You'll get a warning in the second begin saying that you already are in
a transaction, and nothing will happen. The first commit will commit,
and the second one will get another warning saying that you are not on a
transaction and there's nothing to commit.
--
Alvaro Herrera
is something to raise an exception, apparently)
(I wonder why they don't use BNF syntax anymore ...)
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Cuando mañana llegue pelearemos segun lo que mañana exija (Mowgli)
---(end of broadcast)---
TIP 4: Don't
On Fri, May 07, 2004 at 03:09:58PM +0200, Gaetano Mendola wrote:
Alvaro Herrera wrote:
On Fri, May 07, 2004 at 12:31:51AM +0200, Umberto Zappi wrote:
Thanks to everybody has reply to my email.
Stop immediatly my work in progress.
Some days ago I've downloaded version 7.4.3 of postgresql
should really get the CVS code if you want to hack on Postgres ...
there are a lot of changes since 7.4.3.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Jason Tesser: You might not have understood me or I am not understanding you.
Paul Thomas: It feels like we're 2 people divided by a common language
transaction to insert the key (which I
understand should fail?). I guess there's a different locking mechanism
needed; I believe nested transactions will not be enough.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
The first of April is the day we remember what we are
the other 364 days of the year (Mark
believe nested transactions will not be enough.
Except you can keep trying and trying without the outermost transaction
failing.
But that won't provide the necessary next key locking you mentioned in
your first email, will it?
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
No necesitamos
On Thu, May 13, 2004 at 09:43:42AM -0400, Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
I'm stuck trying to figure out how to decrease reference counting for
relcache entries at subtransaction abort.
Initially I thought I could just drop them all to zero,
Nope, you can't
On Tue, May 04, 2004 at 12:03:16AM -0400, Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
Right. But note that Tom wants to distinguish between statements
created via PREPARE (which would rollback) from those created via a
Prepare message (which wouldn't).
Actually, no, I'd
that 90% of the developers are not on _this_ half of the
world though ;-) My point is that not necessarily development will stop
at that time. Moreover, if there is nobody to test the beta, what good
does to have a feature freeze?
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Just treat us the way you
, etc.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
If it wasn't for my companion, I believe I'd be having
the time of my life (John Dunbar)
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http
On Tue, May 04, 2004 at 03:06:53PM -0400, Robert Treat wrote:
On Tuesday 27 April 2004 15:12, Alvaro Herrera wrote:
You know, that's kind of the point of all things related to MySQL.
It's better than nothing. PostgreSQL doesn't do things because it's
better than nothing. snip
(Same
backends.
Does anyone have a better idea? This is crucial.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Voy a acabar con todos los humanos / con los humanos yo acabaré
voy a acabar con todos / con todos los humanos acabaré (Bender)
---(end of broadcast
On Tue, May 04, 2004 at 11:21:18PM -0400, Bruce Momjian wrote:
Alvaro Herrera wrote:
I've whacked the subtrans patch enough so that the simple tests (i.e.
non concurrent) for tuple visibility work. I can create a table and
populate it in subtransactions, rollback or commit them
On Fri, Apr 30, 2004 at 12:52:10AM -0400, Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
In current (as of a couple hours ago) clean CVS tip sources, without any
of my local changes, I'm getting a postmaster segfault when trying to
connect to a non existant database.
Alvaro
Hackers,
Is this expected? If so, why? I'd expect the prepared stmt to be
deallocated.
alvherre=# begin;
BEGIN
alvherre=# prepare tres as select 3;
PREPARE
alvherre=# rollback;
ROLLBACK
alvherre=# execute tres;
?column?
--
3
(1 fila)
--
Alvaro Herrera (alvherre
On Fri, Apr 30, 2004 at 11:36:36PM -0400, Tom Lane wrote:
Alvaro Herrera Munoz [EMAIL PROTECTED] writes:
strace'ing the postmaster suggested me that the dbname string in
utils/init/postinit.c, the InitPostgres function, is the culprit.
In fact, if I apply the following patch to tcop
On Fri, Apr 30, 2004 at 09:44:52PM -0400, Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
Is this expected? If so, why? I'd expect the prepared stmt to be
deallocated.
prepare.c probably should have provisions for rolling back its state to
the start of a failed transaction
index. However
when you are unsetting the bit it doesn't matter how is the index named.
I'm not sure what side does this argument favor. I'd say ALTER
TABLE/WITHOUT CLUSTER shouldn't recurse but I don't feel strongly about
it.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Everybody understands
backend? Surely this can be
done somehow. I've heard that on linux-2.6 they are implementing POSIX
message queues (not sure what those are anyway); maybe we can do that
on platforms that support it, for performance.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
In a specialized industrial society
could just have
the PREPARE command statements be discarded at rollback, but the Prepare
message's statements should be kept.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Now I have my system running, not a byte was off the shelf;
It rarely breaks and when it does I fix the code myself.
It's stable
for the rest of the session.
--
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
Thou shalt not follow the NULL pointer, for chaos and madness await
thee at its end. (2nd Commandment for C programmers)
---(end of broadcast)---
TIP 1: subscribe and unsubscribe
1 - 100 of 9690 matches
Mail list logo
