Re: [HACKERS] tolower() identifier downcasing versus multibyte encodings

gt; >> Hm, maybe. >> >> There's still the problem of what to do in src/port/pgstrcasecmp.c, >> which won't have the infrastructure needed to do that. > > You mean client-side?  Could we have a str_tolower without xxx_l > branch that always does wide-char co

Re: [HACKERS] Protocol 3, Execute, maxrows to return, impact?

ort multiple resultsets yet. Also, I'd like to get some ideas about how to optimize throughput. You said you got a huge improvement compared to libpq. I think you may implement some nice ideas which we could use to optimize Npgsql. I'm also getting 404 error when trying to downloa

Re: [HACKERS] SQL fast in PSQL, very slow using MS.NET driver

version we are using is 2.0, PostgreSQL 8.2.4 (on RHEL4) > > Appreciate the support. > You are welcome. Please, when using forums, give us what queries you are running so we can make some tests to see what can be happening. Thanks in advance, Ashish. -- Regards, Francisco Figueiredo

Re: [HACKERS] SQL fast in PSQL, very slow using MS.NET driver

s? We have performance issues with prepared statements. If it is so, can you try without prepared statements? You can discuss this also in our forums: forums.npgsql.org Thanks in advance. -- Regards, Francisco Figueiredo Jr. fxjr.blogspot.com www.npgsql.org -- Sent via pgsql-hackers mailing

Res: [HACKERS] .NET driver

ice if you could join us to help make Npgsql better! Thanks in advance. -- Regards, Francisco Figueiredo Jr. http://fxjr.blogspot.com Npgsql Lead Developer http://npgsql.projects.postgresql.org Mono Project Contributor http://www.go-mono.com MonoBrasil Project Founder M

[HACKERS] SIg11 on suse linux

vance. - -- Regards, Francisco Figueiredo Jr. http://fxjr.blogspot.com Npgsql Lead Developer http://pgfoundry.org/projects/npgsql MonoBrasil Project Founder Member http://monobrasil.softwarelivre.org -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.4 (GNU/Linux) Comment: Using GnuPG with Mozilla -

Re: [Bulk] Re: [HACKERS] [Bug] Server Crash, possible security exploit,

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Martijn van Oosterhout wrote: > On Mon, Dec 12, 2005 at 06:26:25PM -0200, Francisco Figueiredo Jr. wrote: >> >> Hi all, Yesterday I received a reply from Tom Lane who confirmed the bug and promptly replied me with a patch!! :)

Re: [Bulk] Re: [HACKERS] [Bug] Server Crash, possible security exploit,

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Martijn van Oosterhout wrote: > On Mon, Dec 12, 2005 at 06:26:25PM -0200, Francisco Figueiredo Jr. wrote: > > Well, you're not giving any details but if you can cause the server to > dump core in a standard installation, we're

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

2147484148, limited by database "postgres" - -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.pgfoundry.org/projects/npgsql MonoBrasil Project Founder Member http://monobrasil.softwarelivre.org - - "Science without religion is lame; religion

Re: [HACKERS] Execute and PortalSuspended needs explicit transaction

Oliver Jowett wrote: Francisco Figueiredo Jr. wrote: After some testing, I could send an Execute message with 2 as the manx number of rows. After the second execute I get the following: portal "" does not exist Severity: ERROR Code: 34000 I noticed that I could only get it working if I

Re: [HACKERS] Execute and PortalSuspended needs explicit transaction

--- Oliver Jowett <[EMAIL PROTECTED]> escreveu: > Francisco Figueiredo Jr. wrote: > > > After some testing, I could send an Execute message with 2 as the manx > > number of rows. After the second execute I get the following: > > > > portal "" does

Re: [HACKERS] [JDBC] Where are we on stored procedures?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Markus Schaber wrote: | Hi, Francisco, | | Francisco Figueiredo Jr. schrieb: | | |>In fact, I think people keep requesting me support on Npgsql for that |>because MS Sql server supports it and they are porting their code to use |>Postgresql a

[HACKERS] Execute and PortalSuspended needs explicit transaction to work?

ems. Is this by design? I mean, do I need to have an explicit transaction to get multiple executes work when getting portalsuspended messages? Or am I missing something? Thanks in advance. - -- Regards, Francisco Figueiredo Jr. Membro Fundador do Projeto MonoBrasil - MonoBrasil Project Foun

Re: [HACKERS] [JDBC] Where are we on stored procedures?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tom Lane wrote: | "Francisco Figueiredo Jr." <[EMAIL PROTECTED]> writes: | |>Could I add another item? | | |>Could we have the row count of statements executed inside a |>procedure/function returned to client? | | | IMHO t

Re: [HACKERS] [JDBC] Where are we on stored procedures?

ed to change the procedure, as even this modification needs some aware of client to be able to get the result. Please, jdbc guys, if you know some easy way of doing this, please let me know so I can implement in Npgsql. Thanks in advance. Regards, Francisco Figueiredo Jr. _

Re: [HACKERS] How to make @id or $id as parameter name in plpgsql,

names starting with @. This was a feature users were requesting exactly for the porpose of helping port code from sql server to postgresql. Please, let me know of any modifications you may still need to do to get it working. I did some tests and it were working well. - -- Regards, Francisco F

[HACKERS] Parse message problem, maybe a bug?

the parse text is, for example for parameter of type text: select * from table where $1::text in (select some_field from table) Is this a bug in Postgresql or is this by design? Thanks in advance. Regards, Francisco Figueiredo Jr. ---(end of broadcast)---

Re: [HACKERS] Why select * from function doesn't work when function

Nigel J. Andrews wrote: On Thu, 24 Jul 2003, Francisco Figueiredo Jr. wrote: Nigel J. Andrews wrote: On Tue, 22 Jul 2003, Francisco Figueiredo Jr. wrote: How's this for an alternative if you really don't want any rows returned: create function fincF ( ) returns setof integer

Re: [HACKERS] Why select * from function doesn't work when function

Tom Lane wrote: "Francisco Figueiredo Jr." <[EMAIL PROTECTED]> writes: I just wanted void functions behave like others when called as select * from voidfunction So I dont have to do select voidfunction. :) It's not only void functions that fail --- I believe the code w

Re: [HACKERS] Why select * from function doesn't work when function

Nigel J. Andrews wrote: On Tue, 22 Jul 2003, Francisco Figueiredo Jr. wrote: How's this for an alternative if you really don't want any rows returned: create function fincF ( ) returns setof integer as ' begin delete from blah; return; end; ' language 'plpgsql&

Re: [HACKERS] Why select * from function doesn't work when function

Nigel J. Andrews wrote: On Tue, 22 Jul 2003, Francisco Figueiredo Jr. wrote: select * from funcF(); Yeap, it works, but you specified integer as the return type :) Yes, that's because I knew the void wouldn't work. :] :) How's this for an alternative if you really don&

Re: [HACKERS] Why select * from function doesn't work when function

p, it works, but you specified integer as the return type :) I'd like to have the return type as void and be possible to call it with select * from funcF(); Thanks Nigel. -- Regards, Francisco Figueiredo Jr. -- "My grandfather once told me that there are two kinds of people: those wh

[HACKERS] Why select * from function doesn't work when function has returntype void??

uncF(); I'd like to know if would be possible to change this behaviour to return an empty result set with a null value. This way, there would be consistency in calling all functions regardless of its return type with select * from function. Thanks in advance. -- Regards, Francisco Figu

[HACKERS] Handling protocol not supported error message when working with protocol2 and 3

more elegant solution? I know this question was alread raised some time ago, but I couldn't find it. Thanks in advance. -- Regards, Francisco Figueiredo Jr. -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He

Re: [HACKERS] Transaction handling in extended query mode and Sync

Are you still having problems with it? I hope it helps. -- Regards, Francisco Figueiredo Jr. -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less

Re: [HACKERS] Receiving data in binary format how is it encoded?

, x.sign, sizeof(int16)); pq_sendint(&buf, x.dscale, sizeof(int16)); for (i = 0; i < x.ndigits; i++) pq_sendint(&buf, x.digits[i], sizeof(NumericDigit)); Thanks. I will have a look in the types in the AST dir. -- Regards, Francisco Figueiredo Jr. -- "My grandfather once told

Re: [HACKERS] Receiving data in binary format how is it encoded?

ile are these values produced? -- Regards, Francisco Figueiredo Jr. -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there." - Indira Gandhi

[HACKERS] Receiving data in binary format how is it encoded?

tion: If I have a field which has binary type and I use the extended protocol to set all result fields to text, will this field also be sent in text, regardless its type? Thanks in advance! -- Regards, Francisco Figueiredo Jr. -- "My grandfather once told me that there are two kinds o

Re: [HACKERS] Problem when running initdb with latest cvs code

Andreas Pflug wrote: Francisco Figueiredo Jr. wrote: Hi all, I'm getting the following error when trying to do an initdb: This user must also own the server process. initializing pg_depend... ERROR: expression_tree_walker: Unexpected node type 601 IN: expression_tree_walker (clauses.c

[HACKERS] Problem when running initdb with latest cvs code

quot;super user name with spaces" problem are working very well. Thanks. -- Regards, Francisco Figueiredo Jr. -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there w

Re: [HACKERS] Getting blocked when receinving response from a Parse

100% in C#. Maybe you could give some tips, suggestions, improvements, bug fixes... :) I'm right now implementing the extended query mode and as you and Tom Lane said, the Flush message worked very well. Thanks again. -- Regards, Francisco Figueiredo Jr. -- "My grandfather once to

Re: [HACKERS] Getting blocked when receinving response from a Parse

nd now using Flush it's working quite well :) Thanks Carlos. Uhmmm, if you don't mind... are you implementing something like a data provider for Postgresql, or it is just an ad hoc program? -- Regards, Francisco Figueiredo Jr. -- "My grandfather once told me that there a

Re: [HACKERS] Getting blocked when receinving response from a Parse

Tom Lane wrote: "Francisco Figueiredo Jr." <[EMAIL PROTECTED]> writes: I'm implementing the 3.0 protocol version in Npgsql, a .Net Data provider for postgresql. I stopped in the first message: Parse :( I send the parse message but I don't receive the ParseComplete

[HACKERS] Getting blocked when receinving response from a Parse message...

ing the latest cvs code on cygwin. Thanks in advance. -- Regards, Francisco Figueiredo Jr. -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there.&q

Re: [HACKERS] Fields float4 don't return any row when selecting a

Bruno Wolff III wrote: On Tue, Jun 17, 2003 at 23:26:07 -0300, "Francisco Figueiredo Jr." <[EMAIL PROTECTED]> wrote: Hi all, I'm using the 7.4 cvs version on cygwin and I noticed that if I have a table with a field of float4 type and try to do a simple select: sele

[HACKERS] Fields float4 don't return any row when selecting a value with a.

t into tableD values (4, 3); select * from tableD where field_float4 = 3.3 ==> 0 rows returned select * from tableD where field_float8 = 4.4 --> 1 row returned. select * from tableD where field_float4 = '3.3' ==> 1 row returned. Can someone confirm that for me? Thanks in advance

[HACKERS] initdb problems handling super username with spaces.

blems as it says it can't find PQFreemem in the pq.dll But I could use the psql from the 7.3.2 release :) Again, great work guys! -- Regards, Francisco Figueiredo Jr. -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He

Re: [HACKERS] [Npgsql-general] Get function OID and function calling support

y that will happen in 7.4. Ok, as Kristis already said about how functions are being commonly called, I will implement it this way: transforming the function call into a "select " statement. I already have some working cod