Re: [HACKERS] 7.4RC1 tag'd, branched and bundled ...

2003-11-04 Thread Alvaro Herrera
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

Re: [pgsql-www] [HACKERS] Changes to Contributor List

2003-11-06 Thread Alvaro Herrera
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

Re: [HACKERS] Information Schema and constraint names not unique

2003-11-06 Thread Alvaro Herrera
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

Re: [HACKERS] [pgsql-advocacy] Changes to Contributor List

2003-11-07 Thread Alvaro Herrera
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

Re: [HACKERS] [pgsql-advocacy] Changes to Contributor List

2003-11-07 Thread Alvaro Herrera
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

Re: [HACKERS] What do you want me to do?

2003-11-07 Thread Alvaro Herrera
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

Re: [HACKERS] [pgsql-advocacy] Changes to Contributor List

2003-11-07 Thread Alvaro Herrera
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

Re: [HACKERS] bugzilla (Was: What do you want me to do?)

2003-11-09 Thread Alvaro Herrera
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

Re: [HACKERS] BTree index

2003-11-09 Thread Alvaro Herrera
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

Re: [HACKERS] Need help.

2003-11-14 Thread Alvaro Herrera
. 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

Re: [HACKERS] INSERT extremely slow with large data sets

2003-11-14 Thread Alvaro Herrera
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

Re: [HACKERS] Release cycle length

2003-11-18 Thread 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

Re: [pgsql-www] [HACKERS] Release cycle length

2003-11-18 Thread Alvaro Herrera
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

Re: [HACKERS] Is there going to be a port to Solaris 9 x86 in the

2003-11-18 Thread Alvaro Herrera
, 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

Re: [HACKERS] Release cycle length

2003-11-21 Thread Alvaro Herrera
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

Re: [HACKERS] Sponsoring enterprise features

2003-11-22 Thread Alvaro Herrera
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

Re: [HACKERS] Executable files in CVS

2003-11-23 Thread Alvaro Herrera
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

Re: [HACKERS] Considerations for lib64

2003-11-25 Thread Alvaro Herrera
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

Re: [HACKERS] detecting poor query plans

2003-11-26 Thread 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

Re: [HACKERS] pg_restore and create FK without verification check

2003-11-26 Thread Alvaro Herrera
? -- 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

Re: [HACKERS] 7.5 Plans

2003-11-26 Thread Alvaro Herrera
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

Re: [HACKERS] pg_restore and create FK without verification check

2003-11-27 Thread Alvaro Herrera
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

Re: [HACKERS] 7.5 Plans

2003-11-27 Thread Alvaro Herrera
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

Re: [HACKERS] statistics about tamp tables ...

2003-11-28 Thread Alvaro Herrera
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

Re: [HACKERS] Automatically force zero_damaged_pages while InRecovery?

2003-11-29 Thread 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

Re: [HACKERS] Where does catalog store CHAR length ?

2003-12-01 Thread Alvaro Herrera
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

Re: [HACKERS] default operator class: btree or hash

2003-12-01 Thread Alvaro Herrera
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

Re: [HACKERS] Inside the Regex Engine

2003-12-02 Thread Alvaro Herrera
. 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

Re: [HACKERS] Encoding problem with 7.4

2003-12-03 Thread Alvaro Herrera
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

Re: [HACKERS] request for feedback - read-only GUC variables, pg_settings

2003-12-04 Thread Alvaro Herrera
. 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

Re: [HACKERS] [GENERAL] Was: Triggers, Stored Procedures, PHP

2003-11-30 Thread Alvaro Herrera
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

Re: [HACKERS] Use of 'cp -r' in CREATE DATABASE

2003-12-11 Thread Alvaro Herrera
? 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

Re: [HACKERS] Archives

2003-12-14 Thread Alvaro Herrera
On Fri, Jul 18, 2003 at 10:28:40PM -0300, The Hermit Hacker wrote: On Wed, 16 Jul 2003, Alvaro Herrera wrote: On Wed, Jul 16, 2003 at 01:57:41PM -0500, Thomas Swan wrote: Does anyone have recent archives of the pgsql-hackers list in mbx or flat file format? I really miss this too

Re: [HACKERS] Resurrecting pg_upgrade

2003-12-14 Thread Alvaro Herrera
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

Re: [HACKERS] [PATCHES] Double Backslash example patch

2003-12-16 Thread Alvaro Herrera
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

Re: [GENERAL][ADMIN][HACKERS]data fragmentation

2003-12-16 Thread Alvaro Herrera
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

Re: [HACKERS] Limiting per user and per db accesse (was TODO list)

2003-12-17 Thread Alvaro Herrera
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

Re: [GENERAL][ADMIN][HACKERS]data fragmentation

2003-12-16 Thread Alvaro Herrera
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

Re: [HACKERS] [COMMITTERS] pgsql-server/doc/src/sgml Tag: REL7_4_STABLE

2003-12-22 Thread Alvaro Herrera
, 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

Re: Postgres + Xapian (was Re: [HACKERS] fulltext searching via a custom index type )

2004-01-02 Thread Alvaro Herrera
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

Re: Postgres + Xapian (was Re: [HACKERS] fulltext searching via a custom index type )

2004-01-03 Thread Alvaro Herrera
, 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

Re: [HACKERS] [PATCHES] remove 'noversion' from standalone backend

2004-01-06 Thread Alvaro Herrera
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

Re: [HACKERS] [COMMITTERS] pgsql-server/ oc/src/sgml/catalogs.sgml

2004-01-07 Thread Alvaro Herrera
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

Re: [HACKERS] Disaster!

2004-01-23 Thread Alvaro Herrera
for each transaction whether it committed or aborted. A WAL replay is the operation of bringing the data files (tables, indexes, etc) up to date by reading the Write-ahead log (WAL). Tom's answer will be undoubtly better ... -- Alvaro Herrera (alvherre[a]dcc.uchile.cl) ¿Que diferencia tiene para

Re: [HACKERS] Disaster!

2004-01-23 Thread Alvaro Herrera
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

Re: vpath build (was Re: [HACKERS] cvsignore)

2004-01-24 Thread Alvaro Herrera
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

Re: [HACKERS] Disaster!

2004-01-26 Thread Alvaro Herrera
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

Re: [HACKERS] index scan with functional indexes

2004-01-27 Thread Alvaro Herrera
if you have a % in front of the string. -- Alvaro Herrera (alvherre[a]dcc.uchile.cl) Hay quien adquiere la mala costumbre de ser infeliz (M. A. Evans) ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan

Re: [HACKERS] Question about indexes

2004-01-30 Thread Alvaro Herrera
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

Re: [HACKERS] Transaction aborts on syntax error.

2004-01-31 Thread Alvaro Herrera
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

[HACKERS] array surprising behavior

2004-02-04 Thread Alvaro Herrera
) 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

Beta freeze? (was Re: [HACKERS] array surprising behavior)

2004-02-04 Thread Alvaro Herrera
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

Re: [HACKERS] It's past time to redo the smgr API

2004-02-05 Thread Alvaro Herrera
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

Re: [HACKERS] It's past time to redo the smgr API

2004-02-05 Thread Alvaro Herrera
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

Re: [HACKERS] PITR Dead horse?

2004-02-11 Thread Alvaro Herrera
, 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

Re: [HACKERS] Pl/Java - next step?

2004-03-01 Thread Alvaro Herrera
. -- 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

Re: [HACKERS] Two-phase commit

2004-03-23 Thread Alvaro Herrera
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

Re: [HACKERS] linked list rewrite

2004-03-23 Thread Alvaro Herrera
, 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] Nested transaction proposal - take N (N 2)

2004-03-23 Thread Alvaro Herrera
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

Re: subversion vs cvs (Was: Re: [HACKERS] linked list rewrite)

2004-03-25 Thread Alvaro Herrera
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

Re: [HACKERS] hacking data directories

2004-03-29 Thread Alvaro Herrera
, 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

Re: [HACKERS] Transaction question

2004-03-30 Thread Alvaro Herrera
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

Re: [HACKERS] PITR for replication?

2004-04-02 Thread Alvaro Herrera
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

Re: [HACKERS] Problems Vacuum'ing

2004-04-02 Thread Alvaro Herrera
, 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

Re: [HACKERS] Problems Vacuum'ing

2004-04-02 Thread Alvaro Herrera
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

Re: [HACKERS] Problems Vacuum'ing

2004-04-02 Thread Alvaro Herrera
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

Re: [HACKERS] signal 11 on AIX: 7.4.2

2004-04-19 Thread Alvaro Herrera
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

[HACKERS] cannot drop active portal

2004-04-21 Thread Alvaro Herrera
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

Re: [HACKERS] contrib vs. gborg/pgfoundry for replication solutions

2004-04-21 Thread Alvaro Herrera
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

Re: [HACKERS] contrib vs. gborg/pgfoundry for replication solutions

2004-04-22 Thread Alvaro Herrera
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

Re: [HACKERS] cannot drop active portal

2004-04-22 Thread Alvaro Herrera
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

[HACKERS] Current CVS tip segfaulting

2004-04-23 Thread Alvaro Herrera
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

Re: [pgsql-advocacy] [HACKERS] What can we learn from MySQL?

2004-04-24 Thread Alvaro Herrera
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

Re: [HACKERS] Current CVS tip segfaulting

2004-04-24 Thread Alvaro Herrera
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

Re: [HACKERS] Current CVS tip segfaulting

2004-04-24 Thread Alvaro Herrera
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

Re: [HACKERS] Bringing PostgreSQL torwards the standard regarding

2004-04-25 Thread Alvaro Herrera
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

Re: [HACKERS] XLog: how to log?

2004-05-11 Thread Alvaro Herrera
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

Re: [HACKERS] XLog: how to log?

2004-05-11 Thread Alvaro Herrera
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

[HACKERS] relcache refcount

2004-05-12 Thread Alvaro Herrera
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

Re: [HACKERS] XLog: how to log?

2004-05-11 Thread Alvaro Herrera
, 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

Re: [HACKERS] XLog: how to log?

2004-05-11 Thread Alvaro Herrera
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

[HACKERS] XLog: how to log?

2004-05-10 Thread Alvaro Herrera
= 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

Re: [HACKERS] Nested transactions

2004-05-09 Thread Alvaro Herrera
... 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

Re: [HACKERS] Adding MERGE to the TODO list (resend with subject)

2004-05-09 Thread 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

Re: [HACKERS] COPY command - CSV files

2004-05-07 Thread Alvaro Herrera
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

Re: [HACKERS] COPY command - CSV files

2004-05-06 Thread Alvaro Herrera
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

Re: [HACKERS] Adding MERGE to the TODO list (resend with subject)

2004-05-08 Thread Alvaro Herrera
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

Re: [HACKERS] Adding MERGE to the TODO list (resend with subject)

2004-05-08 Thread Alvaro Herrera
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

Re: [HACKERS] relcache refcount

2004-05-14 Thread Alvaro Herrera
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

Re: [HACKERS] Weird prepared stmt behavior

2004-05-04 Thread Alvaro Herrera
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

Re: [HACKERS] Call for 7.5 feature completion

2004-05-04 Thread Alvaro Herrera
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

Re: [HACKERS] Hacking postgres backend process

2004-05-04 Thread Alvaro Herrera
, 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

Re: [pgsql-advocacy] [HACKERS] What can we learn from MySQL?

2004-05-04 Thread Alvaro Herrera
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

[HACKERS] Multiple Xids in PGPROC?

2004-05-04 Thread Alvaro Herrera
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

Re: [HACKERS] Multiple Xids in PGPROC?

2004-05-05 Thread Alvaro Herrera
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

Re: [HACKERS] Current CVS tip segfaulting

2004-04-30 Thread Alvaro Herrera
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] Weird prepared stmt behavior

2004-04-30 Thread Alvaro Herrera
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

Re: [HACKERS] Current CVS tip segfaulting

2004-05-01 Thread Alvaro Herrera
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

Re: [HACKERS] Weird prepared stmt behavior

2004-05-01 Thread Alvaro Herrera
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

Re: [HACKERS] SET WITHOUT CLUSTER patch

2004-05-02 Thread Alvaro Herrera
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

  1   2   3   4   5   6   7   8   9   10   >