Re: [GENERAL] [ADMIN] [HACKERS] retrieve statement from catalogs

2003-11-10 Thread Jaime Casanova
you could put a view on every table that called a function? Maybe, but how can i retrieve the select statement _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus

Re: [GENERAL] [ADMIN] [HACKERS] retrieve statement from catalogs

2003-11-07 Thread Jaime Casanova
Hi everybody, can anyone tell me if there's a way to retrieve the select instruction executed from the catalogs, or maybe via some structure in a trigger? The reason is that i have some selects constructed on-the-fly (just part of it) and i want to save that in a table in order to know what

[HACKERS] xeon processors

2004-06-25 Thread Jaime Casanova
Hi all, Can anyone tell me if postgresql has problems with xeon processors? If so, there is any fix or project of fix it? Thanx in advance, Jaime Casanova Do You Yahoo!? Todo lo que quieres saber de Estados Unidos, América Latina y el resto del Mundo. Visíta Yahoo! Noticias.

Re: [HACKERS] xeon processors

2004-06-25 Thread Jaime Casanova
s problems with xeon processors? If so, there is any fix or project of fix it? Thanx in advance, Jaime Casanova *Do You Yahoo!?* Todo lo que quieres saber de Estados Unidos, América Latina y el resto del Mundo. Vi

[HACKERS] A wanna be

2004-07-01 Thread Jaime Casanova
Hi all, I'm a young developer with some knowledge in various programming languages including C. Nowadays, i'm not capable to contribute to any part of the postgresql project but i want seriously learn what i need in order to contribute. Can you guys tell me where can i start? Where can i find

[HACKERS] Developers page is down

2004-09-03 Thread Jaime Casanova
in advance, Jaime Casanova _ Do You Yahoo!? Información de Estados Unidos y América Latina, en Yahoo! Noticias. Visítanos en http://noticias.espanol.yahoo.com ---(end of broadcast)--- TIP 8

[HACKERS] Adding columns in the middle of tables

2004-09-04 Thread Jaime Casanova
--- Gaetano Mendola [EMAIL PROTECTED] escribió: Jaime Casanova wrote: Hi guys i was looking for the http://developer.postgresql.org/todo.php in order to view what things are you posponing for later versions but the entire developer.postgresql.org site is down. By the way

Re: [HACKERS] Adding columns in the middle of tables

2004-09-06 Thread Jaime Casanova
and is a feature that good design can do a very rare need. I will think if there is another implementation plan that can be used (but if *the core* didn't find it i hardly will). thanx a lot for the explanation, Jaime Casanova _ Do You Yahoo

[HACKERS] get_rel_* functions in lsyscache.c

2005-06-24 Thread Jaime Casanova
Hi, i have a doubt... it seems to me that the get_rel_* functions in lsyscache do the same as doing heap_open(); Calling the appropiate macro Relation* heap_close(); is there any difference between them? in wich situation is one better than the other? -- regards, Jaime Casanova (DBA

[HACKERS] #ifdef NOT_USED

2005-06-24 Thread Jaime Casanova
Hi, i have found several #ifdef NOT_USED marked code... i guess this is dead code... is safe to remove it? there is some reason you just hide it and not remove the code? -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) ---(end of broadcast

[HACKERS] lookup fail at DROP USER

2005-08-29 Thread Jaime Casanova
for tablespace 16396 i hope it helps... -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[HACKERS] TODO item: set proper permissions on non-system schemas

2005-08-31 Thread Jaime Casanova
that? -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

[HACKERS] sequences TODO items

2005-09-02 Thread Jaime Casanova
that was better to me to make it manually... -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) ---(end of broadcast)--- TIP 6: explain analyze is your friend

[HACKERS] avoid pulling up subquerys that contain volatile functions?

2005-10-08 Thread Jaime Casanova
where is_true 1; drop view vfoo_random; --- END SQL --- i thought it was just calling contain_volatile_function from is_simple_subquery() in src/backend/optimizer/prep/prepjointree.c but it doesn't work for me. what i miss? -- regards, Jaime Casanova (DBA: DataBase Aniquilator

Re: [HACKERS] avoid pulling up subquerys that contain volatile functions?

2005-10-09 Thread Jaime Casanova
On 10/8/05, Tom Lane [EMAIL PROTECTED] wrote: Jaime Casanova [EMAIL PROTECTED] writes: but this example seems to clarify (or at least i think) that we have to avoid pulling up subquerys containing volatile functions: This is exactly the same example discussed in previous threads

Re: [HACKERS] avoid pulling up subquerys that contain volatile functions?

2005-10-11 Thread Jaime Casanova
On 10/9/05, Tom Lane [EMAIL PROTECTED] wrote: Jaime Casanova [EMAIL PROTECTED] writes: On 10/8/05, Tom Lane [EMAIL PROTECTED] wrote: This is exactly the same example discussed in previous threads on this issue. Do you think it will change anyone's mind? in any case, i still think

[HACKERS] plperl error when making 8.2dev CVS

2005-11-07 Thread Jaime Casanova
Hi, i was trying to compile CVS using --with-plperl (perl installed is 5.6.1) and i get this error when make go inside plperl: make[3]: *** No rule to make target `SPI.xs', needed by `SPI.c'. Stop. make[2]: *** [all] Error 1 make[1]: *** [all] Error 2 make: *** [all] Error 2 -- regards, Jaime

Re: [HACKERS] plperl error when making 8.2dev CVS

2005-11-08 Thread Jaime Casanova
On 11/8/05, Alvaro Herrera [EMAIL PROTECTED] wrote: Jaime Casanova wrote: Hi, i was trying to compile CVS using --with-plperl (perl installed is 5.6.1) and i get this error when make go inside plperl: fixing a bad typo in the message i try --with-perl (no --with-plperl like said above

Re: [HACKERS] plperl error when making 8.2dev CVS

2005-11-08 Thread Jaime Casanova
On 11/8/05, Alvaro Herrera [EMAIL PROTECTED] wrote: Jaime Casanova wrote: On 11/8/05, Alvaro Herrera [EMAIL PROTECTED] wrote: Jaime Casanova wrote: make[3]: *** No rule to make target `SPI.xs', needed by `SPI.c'. Stop. Did you delete that file? It's part of the sources

Re: [HACKERS] plperl error when making 8.2dev CVS

2005-11-09 Thread Jaime Casanova
On 11/8/05, Alvaro Herrera [EMAIL PROTECTED] wrote: Jaime Casanova wrote: On 11/8/05, Alvaro Herrera [EMAIL PROTECTED] wrote: Jaime Casanova wrote: make[3]: *** No rule to make target `SPI.xs', needed by `SPI.c'. Stop. Did you delete that file? It's part of the sources

Re: [HACKERS] plperl error when making 8.2dev CVS

2005-11-10 Thread Jaime Casanova
On 11/9/05, Tom Lane [EMAIL PROTECTED] wrote: Alvaro Herrera [EMAIL PROTECTED] writes: Jaime Casanova wrote: ok, i execute 'make distclean' and then get the same error when making after configuring with --with-perl Is this a clean source tree? Try cvs update -C (beware it'll destroy

[HACKERS] someone working to add merge?

2005-11-11 Thread Jaime Casanova
it... comments? ideas? suggestions? -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [HACKERS] someone working to add merge?

2005-11-11 Thread Jaime Casanova
implementation, working out syntax and trigger issues, based on a full table lock and do the hard work once it was proved to be feasable. Peter? -- Josh Berkus Aglio Database Solutions San Francisco -- Atentamente, Jaime Casanova (DBA: DataBase Aniquilator ;) ---(end

Re: [HACKERS] someone working to add merge?

2005-11-11 Thread Jaime Casanova
for the columns involved in the merge condition, which is not required anywhere. -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] MERGE vs REPLACE

2005-11-11 Thread Jaime Casanova
http://developer.postgresql.org/~petere/ MERGE seems to me the better option... not just because is standard but at least i can see some use cases for it... -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) ---(end of broadcast)--- TIP 6

Re: [HACKERS] MERGE vs REPLACE

2005-11-11 Thread Jaime Casanova
On 11/11/05, Peter Eisentraut [EMAIL PROTECTED] wrote: Jaime Casanova wrote: MERGE seems to me the better option... not just because is standard but at least i can see some use cases for it... I don't think you understand my message: MERGE does not do what REPLACE does. -- Peter

Re: [HACKERS] MERGE vs REPLACE

2005-11-11 Thread Jaime Casanova
)... But even REPLACE requires predicate locking. There's no real way to get around it. --Josh why? seems that REPLACE only work if there are at least one row matching... -- Atentamente, Jaime Casanova (DBA: DataBase Aniquilator ;) ---(end of broadcast

[HACKERS] REPLACE implementation (was: Re: MERGE vs REPLACE)

2005-11-13 Thread Jaime Casanova
between ExecDelete and ExecInsert? Also, the MySQL implementation require DELETE and INSERT permission. What about triggers? run before/after delete and insert? -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) ---(end of broadcast)--- TIP 3

Re: [HACKERS] functions marked STABLE not allowed to do INSERT

2005-11-14 Thread Jaime Casanova
of thing are checked at compile time. -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] functions marked STABLE not allowed to do INSERT

2005-11-14 Thread Jaime Casanova
: think in it as a netsafe for novices, if you think you are expert enough take the net off (calling the volatile functions) -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please

Re: [HACKERS] someone working to add merge?

2005-11-15 Thread Jaime Casanova
, Consulting, Custom Development, 24x7 support And the only type of predicate locking we need for MySQL REPLACE because it needs a pk or unique index to know it has to replace otherwise it inserts the row... that's the way it works as mysql spec said... -- Atentamente, Jaime Casanova (DBA: DataBase

Re: [HACKERS] MERGE vs REPLACE

2005-11-15 Thread Jaime Casanova
... without even needing to use a pl/pgsql hack. Actually REPLACE is not INSERT or UPDATE... REPLACE means INSERT if already exists DELETE then INSERT can be used as an UPDATE if you use the SET clause but, it is optional -- regards, Jaime Casanova (DBA: DataBase Aniquilator

Re: [HACKERS] MERGE vs REPLACE

2005-11-16 Thread Jaime Casanova
, many people will shoot themselves in the foot and the culprit will be PostgreSQL because he let a ready to shoot gun in a visible place when are kids around -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) ---(end of broadcast)--- TIP 3: Have

Re: [HACKERS] MERGE vs REPLACE

2005-11-16 Thread Jaime Casanova
it internally? without user interaction? -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your

Re: [HACKERS] Optional postgres database not so optional in 8.1

2005-11-17 Thread Jaime Casanova
Tom telling that this database will be used to connect to for CREATE DATABASE porpouses: http://archives.postgresql.org/pgsql-committers/2005-06/msg00302.php -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) ---(end of broadcast)--- TIP 2

Re: [HACKERS] MERGE vs REPLACE

2005-11-21 Thread Jaime Casanova
any fan... -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] MERGE vs REPLACE

2005-11-22 Thread Jaime Casanova
On 11/22/05, Bruce Momjian pgman@candle.pha.pa.us wrote: Jaime Casanova wrote: And yes merge CAN be used to do REPLACE (oracle uses their dummy table for this, we can use the fact that FROM clause isn't required in postgres). the FROM clause is required by default (starting

[HACKERS] multi-key index

2004-12-20 Thread Jaime Casanova
just col1; also called skip-scanning. I was looking in the archives something about this but i found nothing. Where can i found the thread (i suppose should be one) about this issue? regards, Jaime Casanova _ Do You Yahoo!? Información de

Re: [HACKERS] Thoughts about updateable views

2004-12-21 Thread Jaime Casanova
In a galaxy far, far away Bernd wrote: The context: http://archives.postgresql.org/pgsql-hackers/2004-03/msg00999.php so joined views are even not updateable, too. I don't find the why of this on the specs and the threads about this issue ignore the comment. Is this right? regards, Jaime

[HACKERS] Updateable views

2004-12-25 Thread Jaime Casanova
, very* simple views. We want improve it. These of course are just general ideas, and we really want to know your opinion. regards, Jaime Casanova _ Do You Yahoo!? Información de Estados Unidos y América Latina, en Yahoo! Noticias. Visítanos en

Re: [HACKERS] Updateable views

2004-12-26 Thread Jaime Casanova
(select a.val as newval, b.b_id, b.val from a,b where a.b_id = b.b_id) SET val = newval I think Postgres's UPDATE ... FROM is a lot more clear to understand. regards, Jaime Casanova _ Do You Yahoo!? Información de Estados Unidos y América

[HACKERS] displaying contents

2004-12-27 Thread Jaime Casanova
Hi, there is way to display all the values (fields) in a tree node like this? for debug purpouses. Query *query; regards, Jaime Casanova _ Do You Yahoo!? Información de Estados Unidos y América Latina, en Yahoo! Noticias

Re: [HACKERS] displaying contents

2004-12-27 Thread Jaime Casanova
--- Tom Lane [EMAIL PROTECTED] escribió: Jaime Casanova [EMAIL PROTECTED] writes: there is way to display all the values (fields) in a tree node like this? for debug purpouses. Query *query; Look at elog_node_display(). regards, tom lane Ok

[HACKERS] rule system oddity

2005-01-04 Thread Jaime Casanova
an insert insert into vfoo values(1, 'test1'); ERROR: invalid input syntax for integer: test1 it seems like it's trying to insert into the oid column is that the intended behaviour? or is it a bug? (i think is the latter). if it's a bug? where (in the code) is the rule expanded? regards, Jaime Casanova

[HACKERS] rule system oddity

2005-01-04 Thread Jaime Casanova
Hi, i forgot to mention the version it's pgsql-8.0.0rc3. freshly installed. regards, Jaime Casanova _ Do You Yahoo!? Información de Estados Unidos y América Latina, en Yahoo! Noticias. Visítanos en http://noticias.espanol.yahoo.com

Re: [HACKERS] rule system oddity

2005-01-05 Thread Jaime Casanova
--- Michael Fuhr [EMAIL PROTECTED] escribió: On Tue, Jan 04, 2005 at 11:51:54PM -0600, Jaime Casanova wrote: create view vfoo as select oid, * from foo; ... create rule insrule as on insert to vfoo do instead insert into foo(id, name) values (new.id, new.name); ... insert

[HACKERS] subqueries in check

2005-01-07 Thread Jaime Casanova
Hi, i was looking at the unsuported features in the RC4 docs and found this: F671| Enhanced integrity management| Subqueries in CHECK| intentionally omitted Why is it *intentionally omitted*? Is it to hard? or has some side-effects? just a question! regards, Jaime Casanova

Re: [HACKERS] US Patents vs Non-US software ...

2005-01-17 Thread Jaime Casanova
. regards, Jaime Casanova _ Do You Yahoo!? Información de Estados Unidos y América Latina, en Yahoo! Noticias. Visítanos en http://noticias.espanol.yahoo.com ---(end of broadcast)--- TIP 5: Have

[HACKERS] TIP9

2005-01-21 Thread Jaime Casanova
TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match Hi, sorry for using this list, but is not time to change this TIP for something more suitable to the new PG8 capabilities? regards, Jaime Casanova

Re: [HACKERS] TIP9

2005-01-21 Thread Jaime Casanova
--- Joshua D. Drake [EMAIL PROTECTED] escribió: Jaime Casanova wrote: TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match Hi, sorry for using this list, but is not time to change this TIP for something

Re: [HACKERS] Allow GRANT/REVOKE permissions to be applied to all schema

2005-02-01 Thread Jaime Casanova
user and the objects of the user in its own schema? at least i was tought that way. regards, Jaime Casanova _ Do You Yahoo!? Información de Estados Unidos y América Latina, en Yahoo! Noticias. Visítanos en http://noticias.espanol.yahoo.com

[HACKERS] prev main developer page

2005-02-10 Thread Jaime Casanova
Hi, --- a little off topic --- I want to do something so informative like the map that was in the prev main developer page. Can anyone point me about what tool to use? and maybe some guidance on this? thanks, Jaime Casanova ---(end of broadcast

Re: [HACKERS] Data loss, vacuum, transaction wrap-around

2005-02-19 Thread Jaime Casanova
* people. (1) DBA: DataBase Administrator or DataBase Aniquilator??? regards, Jaime Casanova ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] We are not following the spec for HAVING without GROUP BY

2005-03-10 Thread Jaime Casanova
into tab values(1); insert into tab values(2); select 1 from tab having 1=0; returns no rows select 1 from tab having 1=1; returns 2 rows regards, Jaime Casanova ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index

Re: [HACKERS] Raw size

2005-03-10 Thread Jaime Casanova
, with wich i compute the size of the table is: att0: 1000 * 1 Byte + 4 = 1004 Bytes i don't know what the varchar size is in byte but i think is not 1 per character. IIRC, it varies on diferent encodings. regards, Jaime Casanova ---(end of broadcast

[HACKERS] rewriter in updateable views

2005-03-18 Thread Jaime Casanova
, this is a problem for us, so we want to improve the rewriter to see the default in the base table an add it as appropiate. Can you comment on this? Are there any issues here we have not seen yet? performance? possible? regards, Jaime Casanova ---(end of broadcast

Re: [HACKERS] rewriter in updateable views

2005-03-18 Thread Jaime Casanova
On Fri, 18 Mar 2005 23:31:26 -0500, Tom Lane [EMAIL PROTECTED] wrote: Jaime Casanova [EMAIL PROTECTED] writes: ... but if we do INSERT INTO vfoo(col2) values ('some_string) the rewriter cann resolv the value for col1. the reason is that views does not inherit the defaults of the parent

Re: [HACKERS] rewriter in updateable views

2005-03-19 Thread Jaime Casanova
On Sat, 19 Mar 2005 11:42:18 +, Simon Riggs [EMAIL PROTECTED] wrote: On Sat, 2005-03-19 at 01:10 -0500, Jaime Casanova wrote: On Fri, 18 Mar 2005 23:31:26 -0500, Tom Lane [EMAIL PROTECTED] wrote: Jaime Casanova [EMAIL PROTECTED] writes: ... but if we do INSERT INTO vfoo(col2) values

Re: [HACKERS] rewriter in updateable views

2005-03-19 Thread Jaime Casanova
On Sat, 19 Mar 2005 11:05:39 -0500, Tom Lane [EMAIL PROTECTED] wrote: Jaime Casanova [EMAIL PROTECTED] writes: On Fri, 18 Mar 2005 23:31:26 -0500, Tom Lane [EMAIL PROTECTED] wrote: Why do you not define the problem as when we decide a view is updateable and create the needed rules

Re: [HACKERS] rewriter in updateable views

2005-03-27 Thread Jaime Casanova
using something like the parse_relation.c:colNameToVar function to identify the column. there is a better way to do it? also the ParseState parameter is extensively used in the colNameToVar function but i can't find what is it. regards, Jaime Casanova ---(end of broadcast

Re: [HACKERS] when using a bound cursor, error found..

2005-03-30 Thread Jaime Casanova
you. regards, Jaime Casanova ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [HACKERS] Feature freeze date for 8.1

2005-05-01 Thread Jaime Casanova
a transaction and... Option 1) ...the client crashes then the update will rollback. Option 2) ...the server crashes the update will rollback. Actually, i can't see what's the problem. :) -- Atentamente, Jaime Casanova (DBA: DataBase Aniquilator ;) ---(end of broadcast

Re: [HACKERS] Can we get patents?

2005-05-09 Thread Jaime Casanova
? The same argument can be used (and in fact, was used) against the idea of patent software. :( -- Atentamente, Jaime Casanova (DBA: DataBase Aniquilator ;) ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate

Re: [HACKERS] Understanding Rule System

2005-05-11 Thread Jaime Casanova
it is pg_rewrite, but i can be wrong. -- Atentamente, Jaime Casanova (DBA: DataBase Aniquilator ;) ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [HACKERS] Views update ?

2005-05-22 Thread Jaime Casanova
to this task ... if you're interessed also ? Hi Bernd and i, specialy Bernd, are working on this. Any help would be appreciated. This is the patch against current HEAD. Have you talked with Bernd already? if not, i am emailing to tell him about you. -- Atentamente, Jaime Casanova (DBA: DataBase

[HACKERS] adding a function to pg_proc.h

2005-05-25 Thread Jaime Casanova
is not a problem of returning anyelement. any comments will be appreciated. -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister

Re: [HACKERS] adding a function to pg_proc.h

2005-05-25 Thread Jaime Casanova
On 5/25/05, Tom Lane [EMAIL PROTECTED] wrote: Jaime Casanova [EMAIL PROTECTED] writes: I have added a function in sources and added appropiate lines in pg_proc.h DATA(insert OID = 2560 ( get_view_column_defaultPGNSP PGUID 12 f f t f i 1 2283 25 25 21 _null_ _null_ _null_

Re: [HACKERS] adding a function to pg_proc.h

2005-05-26 Thread Jaime Casanova
On 5/25/05, Jaime Casanova [EMAIL PROTECTED] wrote: Also, defining the return type as ANYELEMENT will definitely NOT work, since none of the input arguments are polymorphic. mmm... This is a problem, there is a way to make a function that can be used for returning different datatypes

[HACKERS] thw rewriter and default values, again

2005-05-28 Thread Jaime Casanova
there is a solution to this. The only problem i have found until now is that update v_foo set col1 = DEFAULT; execute nextval twice per every record. so there will be a gasp between numbers, but AFAIK nextval has no guarantee of returning sequential numbers. Any comments on this? -- regards, Jaime Casanova

Re: [HACKERS] thw rewriter and default values, again

2005-05-28 Thread Jaime Casanova
On 5/28/05, Tom Lane [EMAIL PROTECTED] wrote: Jaime Casanova [EMAIL PROTECTED] writes: create rule ins_rule as on insert to v_foo do instead insert into foo(col1, col2) values (new.col1, new.col2); insert into v_foo(col2) values (1); this give an error like: psql:f:/views.sql:13

Re: [HACKERS] thw rewriter and default values, again

2005-05-28 Thread Jaime Casanova
On 28 May 2005 10:25:48 -0400, Greg Stark [EMAIL PROTECTED] wrote: Jaime Casanova [EMAIL PROTECTED] writes: The only problem i have found until now is that update v_foo set col1 = DEFAULT; execute nextval twice per every record. so there will be a gasp between numbers, but AFAIK nextval

Re: [HACKERS] ddl triggers

2005-06-01 Thread Jaime Casanova
, Jaime Casanova (DBA: DataBase Aniquilator ;) ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [HACKERS] thw rewriter and default values, again

2005-06-06 Thread Jaime Casanova
On 6/6/05, Richard Huxton dev@archonet.com wrote: Jaime Casanova wrote: I know you're right, but -when dealing with updateable views- doing that implies to add a lot of time altering views when base table change, and of course we maybe don't want all views get that values. Sorry

Re: [HACKERS] [GENERAL] Issue with adding ORDER BY to EXCEPT.

2005-06-07 Thread Jaime Casanova
this is because the columns in the except are the same that the ones in the main select and the order by get confused. i'm redirecting to hackers to know if this is a known bug or there is something wrong in the select? i don't see anything wrong!! -- regards, Jaime Casanova (DBA: DataBase Aniquilator

Re: [HACKERS] In RULEs, INSERT does not use DEFAULTs

2005-06-14 Thread Jaime Casanova
the lines of ALTER view ALTER col LINK DEFAULT TO othertable.col; (syntax open to argument of course) which accomplishes the same thing without having to figure a way to avoid the constraints of a specific function result type. That's sounds like a good idea too -- Atentamente, Jaime

Re: [HACKERS] Graphics in postgress using GTK

2005-12-02 Thread Jaime Casanova
** : Cannot open display Can someone suggest a method to integrate this GTK code into postgres and solve this problem. Thanks and Regards Anuj Tripathi What about to return to your application a cursor or a set of rows and while looping let your progress bar advance? -- regards, Jaime

Re: [HACKERS] generalizing the planner knobs

2005-12-08 Thread Jaime Casanova
that is a little confusing that enable_seqscan = false actually let you use a seqscan if the other plans are bad enough -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [HACKERS] Server Crash, possible security exploit, where to send security report?

2005-12-13 Thread Jaime Casanova
servers. Please, send me information to where/who I should send the details in order this can be fixed as soon as possible. http://www.postgresql.org/support/security.html -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) ---(end of broadcast

[HACKERS] second begin transaction emits a warning

2005-12-16 Thread Jaime Casanova
2 3 (3 rows) so, why BeginTransactionBlock emits just a warning and not an error? this is not the same as in the case of the one who was closing and already closed cursor? -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) ---(end of broadcast

Re: [HACKERS] [pgadmin-hackers] Client-side password encryption

2005-12-21 Thread Jaime Casanova
| http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 -- regards, Jaime Casanova (DBA: DataBase Aniquilator

Re: [HACKERS] [COMMITTERS] A question about index internals

2006-01-10 Thread Jaime Casanova
in the list you select to post ;) redirecting to pgsql-hackers@postgresql.org -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) ---(end of broadcast)--- TIP 6: explain analyze is your friend

[HACKERS] message for constraint

2006-01-13 Thread Jaime Casanova
? -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [HACKERS] message for constraint

2006-01-14 Thread Jaime Casanova
On 1/14/06, Peter Eisentraut [EMAIL PROTECTED] wrote: Jaime Casanova wrote: From time to time people ask me if there is a way to customize messages for constraints so they could be more informative to the user... What about this? = create table foo (fld int4 constraint fld must contain

Re: [HACKERS] Error working with Temporary Sequences in plpgsql in 8.1 (8.0 works fine)

2006-01-17 Thread Jaime Casanova
... -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[HACKERS] log_min_messages and debug levels

2006-01-18 Thread Jaime Casanova
... ;) C:\Archivos de programa\PostgreSQL\8.1\binpsql -U postgres pruebas psql: el servidor ha cerrado la conexión inesperadamente, probablemente porque terminó de manera anormal antes o durante el procesamiento de la petición. is this expected on windows platforms? -- regards, Jaime

Re: [HACKERS] un-vacuum?

2006-01-19 Thread Jaime Casanova
and indexes on it. is there a existing command to do so? can you explain yourself a bit better? vacuum is good, why do you think you want to undo it? why do you think that drop and create will undo vacuum? -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) ---(end

Re: [HACKERS] textToQualifiedNameList second parameter

2006-02-25 Thread Jaime Casanova
, the second parameter is back again and I get this error when I try to compile: so, your progam rely on internal functions from someone else's software? bad idea Is the second parameter back again? [1]: http://archives.postgresql.org/pgsql-patches/2005-05/msg00307.php -- regards, Jaime Casanova

Re: [HACKERS] bug in 7.3.2

2006-03-02 Thread Jaime Casanova
On 2/28/06, Suvarna [EMAIL PROTECTED] wrote: we are using postgresql 7.3.2 version. As somebody pointed out, that's not a bug... but i think you must upgrade at least to 7.3.14 even if you really found a bug nobody will fix it for 7.3.2 -- regards, Jaime Casanova What they (MySQL) lose

Re: [HACKERS] Problemas with gram.y

2006-03-03 Thread Jaime Casanova
ugly myself. regards, tom lane why? if i can ask? you didn't seem upset with that in the thread -- regards, Jaime Casanova What they (MySQL) lose in usability, they gain back in benchmarks, and that's all that matters: getting the wrong answer really fast

[HACKERS] Updateable views was:(Re: [HACKERS] Proposal for SYNONYMS)

2006-03-09 Thread Jaime Casanova
was preparing the code to send to patches for discussion... that was two months ago... the current code had problems with casts and i think with domains too... i will contact with Bernd to know if he did some more work, if not i can send to patches the latest path he sent me... -- regards, Jaime

[HACKERS] There is a problem with the download site?

2006-03-10 Thread Jaime Casanova
Hi, i am trying to download the windows version since 3 hours ago and just get an error page no matters if i try the FTP browser, ftp mirrors or bittorrent -- regards, Jaime Casanova What they (MySQL) lose in usability, they gain back in benchmarks, and that's all that matters: getting

Re: [HACKERS] There is a problem with the download site?

2006-03-10 Thread Jaime Casanova
, Jaime Casanova What they (MySQL) lose in usability, they gain back in benchmarks, and that's all that matters: getting the wrong answer really fast. Randal L. Schwartz ---(end of broadcast)--- TIP 9: In versions below 8.0

Re: [HACKERS] Function's final statement must not be a SELECT

2006-03-11 Thread Jaime Casanova
, Jaime Casanova What they (MySQL) lose in usability, they gain back in benchmarks, and that's all that matters: getting the wrong answer really fast. Randal L. Schwartz ---(end of broadcast)--- TIP 6: explain analyze is your

Re: [HACKERS] Proposal for updatable views

2006-03-13 Thread Jaime Casanova
to be flexible... i was working on that but at the time i am very busy... -- regards, Jaime Casanova What they (MySQL) lose in usability, they gain back in benchmarks, and that's all that matters: getting the wrong answer really fast. Randal L. Schwartz

[HACKERS] for statement, adding a STEP clause?

2006-04-28 Thread Jaime Casanova
PLpgSQL_expr to the stmt_fori) and pl_exec.c (the way the internal variable is incremented here makes me think that i wasn't the first one with this idea) i'm missing something? is STEP a good name for this? i will make a try tomorrow any ideas and suggestions are welcome... -- regards, Jaime Casanova

Re: [HACKERS] BEGIN inside transaction should be an error

2006-05-10 Thread Jaime Casanova
AFAIK php doesn't care about that... it just see for success or failure conditions, so if postgres said everything is ok it will continue... -- Atentamente, Jaime Casanova Programming today is a race between software engineers striving to build bigger and better idiot-proof programs and the universe

Re: [HACKERS] BEGIN inside transaction should be an error

2006-05-10 Thread Jaime Casanova
that this is required by the spec is a bit off base. regards, tom lane Well, actually informix throw an error... at least, my 4gl programs always abort when a second begin work is found inside a transaction... -- regards, Jaime Casanova Programming today is a race between

Re: [HACKERS] BEGIN inside transaction should be an error

2006-05-12 Thread Jaime Casanova
else (http://archives.postgresql.org/pgsql-hackers/2005-12/msg00813.php), but if we do it we should do it the only behavior... i don't think it's good to introduce a new GUC for that things (we will finish with GUCs to turn off every fix) -- regards, Jaime Casanova Programming today is a race

Re: [HACKERS] PL/pgSQL 'i = i + 1' Syntax

2006-05-16 Thread Jaime Casanova
), with the BY clause you can specify an increment value... it's in the unapplied patches list waiting for review... http://candle.pha.pa.us/mhonarc/patches/msg3.html -- regards, Jaime Casanova Programming today is a race between software engineers striving to build bigger and better idiot-proof programs

Re: [HACKERS] PL/pgSQL 'i = i + 1' Syntax

2006-05-16 Thread Jaime Casanova
, Jaime Casanova Programming today is a race between software engineers striving to build bigger and better idiot-proof programs and the universe trying to produce bigger and better idiots. So far, the universe is winning. Richard Cook

  1   2   3   4   5   6   7   8   9   >