--- Jaime Casanova [EMAIL PROTECTED] escribió:
--- Tom Lane [EMAIL PROTECTED] escribió:
Jaime Casanova [EMAIL PROTECTED] writes:
= select to_ascii('Jiménez');
will retrieve 'Jimenez' at least it works on
Latin1 encoding.
Why it not work on Latin9,
Probably because it hasn't got
--- Peter Eisentraut [EMAIL PROTECTED] escribió:
Jaime Casanova wrote:
188: it's an O merge with an E (sql_ascii =
'')???
189: the same but lower case(sql_ascii =
'')???
'OE' and 'oe', most likely, but someone more
familiar with French
typography might correct me
--- Tom Lane [EMAIL PROTECTED] escribió:
Jaime Casanova [EMAIL PROTECTED] writes:
Why it not work on Latin9,
Probably because it hasn't got a table for
Latin9.
Feel free to contribute one --- see
src/backend/utils/adt/ascii.c.
This page shows the differences between Latin1
Hi,
i found out that the function textToQualifiedNameList doesn't use the
second argument it receive (caller). i suppose in the past was used
and now it is useless, if that is the case here is a patch removing.
Or are any reasons to keep that argument?
--
regards,
Jaime Casanova
(DBA: DataBase
of the SELECT INTO?
at least, the first time i think the function was right until i found
that the first row of a set of rows was assigned...
i mean, when you do that code you are expecting just one row from your
query, doesn't you?
--
Atentamente,
Jaime Casanova
(DBA: DataBase Aniquilator
...
Maybe be explicit about what the '?' mark means and mark every new
item with it until there is concensus a on it
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner
On 1/6/06, Bruce Momjian pgman@candle.pha.pa.us wrote:
Jaime Casanova wrote:
On 1/6/06, Tom Lane [EMAIL PROTECTED] wrote:
Marko Kreen [EMAIL PROTECTED] writes:
But my question is rather - is there any scenario where setval() should
go with nextval()?
It seems
line 2 at SQL statement
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do
On 1/16/06, Alvaro Herrera [EMAIL PROTECTED] wrote:
Jaime Casanova wrote:
On 1/16/06, Bruce Momjian pgman@candle.pha.pa.us wrote:
what about lower the context part of the messages for plpgsql
functions? that seems debug info for me... just an idea ;)
pruebas=# select prueba();
ERROR
.
regards, tom lane
to clean code?
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining
() returns void as $$ select foo(10);
$$language sql;
regards
Pavel
i'm not clear on what the use case of this can be... of course, my
opinion is not very important :)
--
regards,
Jaime Casanova
What they (MySQL) lose in usability, they gain back in benchmarks, and that's
all that matters: getting
On 4/29/06, Andrew Dunstan [EMAIL PROTECTED] wrote:
Tom Lane wrote:
Jaime Casanova [EMAIL PROTECTED] writes:
there is a chance to add a STEP clause to the FOR statement in plpgsql?
This is not free: it'd require making STEP a reserved word (at least
within plpgsql) which is contrary
On 4/30/06, Jaime Casanova [EMAIL PROTECTED] wrote:
On 4/29/06, Andrew Dunstan [EMAIL PROTECTED] wrote:
Tom Lane wrote:
Jaime Casanova [EMAIL PROTECTED] writes:
there is a chance to add a STEP clause to the FOR statement in plpgsql?
This is not free: it'd require making STEP
On 5/30/06, Bruce Momjian pgman@candle.pha.pa.us wrote:
I went to test this patch and got the attached regression failures.
Please repair and resubmit. Thanks.
did it. sorry for the delay, i was busy this week.
--
Atentamente,
Jaime Casanova
Programming today is a race between software
a typo in this line
+ # All file locations settings change require server restart to tak effect.
--
regards,
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
dropped support for updatable views which contains indexed array
fields of tables (like SELECT foo[3], foo[2] FROM bar). These are treated
non-updatable and someone needs his own rules here.
--
regards,
Jaime Casanova
Programming today is a race between software engineers striving to
build bigger
but that catalog has a unique index on ev_class, rulename:
pg_rewrite_rel_rulename_index UNIQUE, btree (ev_class, rulename)
i guess bernd's comment is about this index giving an error if we try
to insert the new rule with the same name on the same event...
--
regards,
Jaime Casanova
Programming
,
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
--
regards,
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
to use the same
GetDefaultTablespace() function it's less intrussive and is not
directed to one particular object but all temp objects can benefit...
i will wait your patch when you think is ready for discussion...
--
regards,
Jaime Casanova
Programming today is a race between software engineers
will take a look at it now... when you
post for the first time hackers where busy releasing 8.2.0, maybe they
will pay more atention now :)
--
regards,
Jaime Casanova
Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe
('pg_tblspc/' || (SELECT oid FROM
pg_catalog.pg_tablespace WHERE spcname='testspace' )
seems is working fine... i actually looked for the files in the
tablespace directory...
have you looked my past comments?
--
regards,
Jaime Casanova
Programming today is a race between software engineers
On 1/8/07, Jaime Casanova [EMAIL PROTECTED] wrote:
maybe once this patch is applied you can think on make indexes and
[temp] sequences on temp tables use the same temp_tablespace that
table is using...
actually, the index part is easy... do you want to do it?
--
regards,
Jaime Casanova
temp tablespace... :(
i will try to fix that as well... unless you want to do it, just tell me...
--
regards,
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
,
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
On 1/11/07, Joshua D. Drake [EMAIL PROTECTED] wrote:
On Thu, 2007-01-11 at 21:05 -0500, Jaime Casanova wrote:
On 1/11/07, Albert Cervera Areny [EMAIL PROTECTED] wrote:
Please, go on with that, I hadn't seen that problem. Indeed, I read Andrew
answer to your question and I think it's a nice
Sorry, patch attached this time...
On 1/12/07, Jaime Casanova [EMAIL PROTECTED] wrote:
On 1/11/07, Joshua D. Drake [EMAIL PROTECTED] wrote:
On Thu, 2007-01-11 at 21:05 -0500, Jaime Casanova wrote:
On 1/11/07, Albert Cervera Areny [EMAIL PROTECTED] wrote:
Please, go on with that, I hadn't
,
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
Index: doc/src/sgml
On 4/2/07, Bruce Momjian [EMAIL PROTECTED] wrote:
This has been saved for the 8.4 release:
http://momjian.postgresql.org/cgi-bin/pgpatches_hold
mmm... sorry, i have been busy... how many time we have? i can send
something for friday...
--
regards,
Jaime Casanova
Programming today
On 3/17/07, Tom Lane [EMAIL PROTECTED] wrote:
Jaime Casanova [EMAIL PROTECTED] writes:
On 3/5/07, Tom Lane [EMAIL PROTECTED] wrote:
In the second place, it's a serious violation of what little modularity
and layering we have for fd.c to be calling into commands/tablespace.c
,
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
? postgresql-8.3devel
Index
On 5/5/07, Bruce Momjian [EMAIL PROTECTED] wrote:
Your patch has been added to the PostgreSQL unapplied patches list at:
This is final version of the patch (i hope), at least it fixes the
problem i had yesterday.
--
regards,
Jaime Casanova
Programming today is a race between software
On 5/8/07, Peter Eisentraut [EMAIL PROTECTED] wrote:
Am Samstag, 5. Mai 2007 16:40 schrieb Jaime Casanova:
On 5/5/07, Bruce Momjian [EMAIL PROTECTED] wrote:
Your patch has been added to the PostgreSQL unapplied patches list at:
This is final version of the patch (i hope), at least it fixes
On 5/9/07, Peter Eisentraut [EMAIL PROTECTED] wrote:
Am Mittwoch, 9. Mai 2007 02:21 schrieb Jaime Casanova:
What I have been missing all along in these patches is an explanation for
what it means to list multiple temporary tablespaces. Are they used in
order, or the first one that exists
://archives.postgresql.org/pgsql-committers/2007-04/msg00447.php
--
regards,
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
transaction is aborted, commands ignored until end of
transaction block
is this sane behavior? to accept create cursors for update on views
and then failing to update where current of and rollback the entire
transaction?
comments?
--
regards,
Jaime Casanova
Programming today is a race between software
On 5/17/07, Jaime Casanova [EMAIL PROTECTED] wrote:
On 5/17/07, FAST PostgreSQL [EMAIL PROTECTED] wrote:
No. It works with scrollable cursors. It will work for cursors/selects
which does not put the results in some store, such as WITH hold/group
by/order by etc But most
it...
--
regards,
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
On 5/17/07, Jaime Casanova [EMAIL PROTECTED] wrote:
On 5/16/07, Heikki Linnakangas [EMAIL PROTECTED] wrote:
Jim C. Nasby wrote:
What about adding the ability to ask the FSM for a page that's near a
given page? That way if you did have to go to the FSM you could at least
try and insert
On 5/17/07, Jaime Casanova [EMAIL PROTECTED] wrote:
On 5/17/07, FAST PostgreSQL [EMAIL PROTECTED] wrote:
No. It works with scrollable cursors. It will work for cursors/selects
which does not put the results in some store, such as WITH hold/group
by/order by etc But most
the server ;)
btw, I tried to send it to the same conversation but it never arrives
so i'm sending it to -patches.
--
regards,
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
for that?
--
regards,
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
On 6/16/07, Tom Lane [EMAIL PROTECTED] wrote:
Jaime Casanova [EMAIL PROTECTED] writes:
another question: if the fillfactor is 100% then is a complete waste
of time to look for a suggested block. maybe we could check for that?
No, it isn't, since the page might have been vacuumed since
http://archives.postgresql.org/pgsql-committers/2005-05/msg00318.php
--
regards,
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
to have to create those pl handlers at hand). after that the only
script that has a real use to me is initdb and pg_ctl
what makes me wonder why doesn't exist pg_ctl init
--
regards,
Jaime Casanova
Programming today is a race between software engineers striving to
build bigger and better idiot
recover, you weren't sick enough. ;-) LOL
uh! that sounds like my boss talking!
--
regards,
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
== table_oid), File:
execCurrent.c, Line: 128)
LOG: server process (PID 27599) was terminated by signal 6: Aborted
LOG: terminating any other active server processes
--
regards,
Jaime Casanova
Programming today is a race between software engineers striving to
build bigger and better idiot-proof
On 9/18/07, Zoltan Boszormenyi [EMAIL PROTECTED] wrote:
Hi,
Pavan Deolasee írta:
On 9/18/07, *Jaime Casanova* [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] wrote:
this sql scripts make current cvs + patch to crash with this message
in the logs:
Can you please check
on the TODO list and i
don't remember any discussion nor patch about this
--
regards,
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
On 9/24/07, Simon Riggs [EMAIL PROTECTED] wrote:
On Sat, 2007-09-22 at 23:49 -0500, Jaime Casanova wrote:
On 6/19/07, Simon Riggs [EMAIL PROTECTED] wrote:
related TODO items:
- add a WAIT n clause in same SQL locations as NOWAIT
- add a lock_wait_timeout (USERSET), default = 0
on this myself, but I think it is a valid TODO.
i will make a try for 8.4
--
regards,
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
Hi,
I can understand why we have relation_openrv and try_relation_open,
but relation_open_nowait can be merged with relation_open.
Or there is something i'm missing? attached is a patch that do the merge.
--
regards,
Jaime Casanova
Programming today is a race between software engineers
a simple cvs diff
--
regards,
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
= false;
#endif
- #ifdef DEBUG_BOUNDED_SORT
- booloptimize_bounded_sort = true;
- #endif
it's seems you're removing something added in 8.3
--
regards,
Jaime Casanova
Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs
On Thu, May 1, 2008 at 7:59 AM, Pavel Stehule [EMAIL PROTECTED] wrote:
Hello
2008/5/1 Jaime Casanova [EMAIL PROTECTED]:
On Sat, Apr 5, 2008 at 6:57 AM, Pavel Stehule [EMAIL PROTECTED] wrote:
Hello
I found some bugs when I used base_lexer, so I returned back own
lexer. It's only little
On Thu, May 1, 2008 at 8:11 AM, Jaime Casanova [EMAIL PROTECTED] wrote:
On Thu, May 1, 2008 at 7:59 AM, Pavel Stehule [EMAIL PROTECTED] wrote:
Hello
2008/5/1 Jaime Casanova [EMAIL PROTECTED]:
On Sat, Apr 5, 2008 at 6:57 AM, Pavel Stehule [EMAIL PROTECTED] wrote:
Hello
I found
On Thu, May 1, 2008 at 8:14 AM, Jaime Casanova [EMAIL PROTECTED] wrote:
On Thu, May 1, 2008 at 8:11 AM, Jaime Casanova [EMAIL PROTECTED] wrote:
On Thu, May 1, 2008 at 7:59 AM, Pavel Stehule [EMAIL PROTECTED] wrote:
Hello
2008/5/1 Jaime Casanova [EMAIL PROTECTED]:
On Sat, Apr 5
: warning: passing argument 7 of 'read_sql_construct' makes
pointer from integer without a cast
gram.y:1697: error: too many arguments to function 'read_sql_construct'
--
regards,
Jaime Casanova
Soporte de PostgreSQL
Guayaquil - Ecuador
Cel. (593) 087171157
--
Sent via pgsql-patches mailing list
On Thu, May 22, 2008 at 1:18 PM, Jaime Casanova [EMAIL PROTECTED] wrote:
Hi,
The idea of this patch is to avoid the need to make explicit grants on
sequences owned by tables.
I've noted that the patch i attached is an older version that doesn't
compile because of a typo...
Re-attaching right
On Sat, May 24, 2008 at 12:09 AM, Alvaro Herrera
[EMAIL PROTECTED] wrote:
Please add the patch to the commitfest page,
Ah! I forgot we have a new process now... patch added to the commitfest page...
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Guayaquil - Ecuador
Cel
On 5/29/08, Robert Treat [EMAIL PROTECTED] wrote:
On Saturday 24 May 2008 01:19:05 Jaime Casanova wrote:
On Sat, May 24, 2008 at 12:09 AM, Alvaro Herrera
[EMAIL PROTECTED] wrote:
Please add the patch to the commitfest page,
Ah! I forgot we have a new process now... patch added
Hi,
attached the patch i offer to make some internal SRF functions use
output parameters.
--
regards,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. (593) 87171157
Index: src/backend/catalog/system_views.sql
i compile manually (the uint module
tried to install in the ubuntu location while it should in the env
location)
attached a Makefile that fix that
i still have to make some more test...
--
regards,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil
On Sat, Sep 6, 2008 at 3:57 PM, Tom Lane [EMAIL PROTECTED] wrote:
Jaime Casanova [EMAIL PROTECTED] writes:
seems there is something wrong in the unlikely macro (i'm using GCC
4.2.3 in Ubuntu 4.2.3-2ubuntu7 with amd64)
postgres=# select -256::uint1;
ERROR: uint1 out of range
No, that's
On Sat, Sep 6, 2008 at 3:57 PM, Tom Lane [EMAIL PROTECTED] wrote:
Jaime Casanova [EMAIL PROTECTED] writes:
seems there is something wrong in the unlikely macro (i'm using GCC
4.2.3 in Ubuntu 4.2.3-2ubuntu7 with amd64)
postgres=# select -256::uint1;
ERROR: uint1 out of range
No, that's
::uint1 to be equivalent to
(-2)::uint1 that should be at least documented, no?
--
regards,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. (593) 87171157
--
Sent via pgsql-patches mailing list (pgsql-patches@postgresql.org)
To make
On Sat, Sep 6, 2008 at 3:41 PM, Jaime Casanova
[EMAIL PROTECTED] wrote:
i still have to make some more test...
why i need the cast in this case? even if the cast is really necesary
(the message seems realy ugly)
contrib_regression=# select * from t1 where f1 35;
ERROR: unsupported type
On Sun, Sep 7, 2008 at 2:41 AM, Tom Lane [EMAIL PROTECTED] wrote:
Jaime Casanova [EMAIL PROTECTED] writes:
contrib_regression=# select * from t1 where f1 35;
ERROR: unsupported type: 16486
That obviously isn't supposed to happen. Where's it coming from
exactly?
convert_numeric_to_scalar
happens in joins, unions, hash, etc... so you have to
look at those functions as well
PS: Jaime not Jamie :)
--
regards,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. (593) 87171157
--
Sent via pgsql-patches mailing list (pgsql-patches
,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. (593) 87171157
drop table t1_int4;
create table t1_int4 (f1 int4 primary key);
insert into t1_int4 select generate_series(1, 255);
select * from t1_int4, generate_series(1, 10) as foo where
On 9/15/08, Ryan Bradetich [EMAIL PROTECTED] wrote:
Hello Jaime,
I have the code and regression tests updated to solve the problems you
initially
discovered.
great, i will test during this week...
--
regards,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de
: cannot cast type smallint to uint4
LINE 1: select 256::int2::uint4;
otherwise seems fine
--
regards,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
--
Sent via pgsql-patches mailing list (pgsql-patches@postgresql.org
72 matches
Mail list logo