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

will implement it this way: transforming the function call into a select function_name statement. I already have some working code and I will clean it and commit it soon. Thanks all! = Regards, Francisco Figueiredo Jr

[HACKERS] Parse message problem, maybe a bug?

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)--- TIP 5

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

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 Figueiredo Jr. Membro

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

know some easy way of doing this, please let me know so I can implement in Npgsql. Thanks in advance. Regards, Francisco Figueiredo Jr. __ Converse com seus amigos em tempo real com o Yahoo! Messenger http://br.download.yahoo.com/messenger

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 that request is completely bogus

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

? 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 Founder Member http

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 and facing

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 not exist Severity: ERROR Code: 34000 I noticed

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 explicitly

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

, 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 without science is blind

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 interested. You didn't

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!! :) Thank you very much all

[HACKERS] initdb problems handling super username with spaces.

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 told me to try to be in the first group; there was less

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

(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. -- Regards, Francisco Figueiredo Jr

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: select * from table where

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

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. - Indira Gandhi ---(end

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 or the ErrorResponse. My code

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

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 are two kinds of people: those who work

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

#. 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 told me that there are two

[HACKERS] Problem when running initdb with latest cvs code

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 was less competition there. - Indira

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:2320

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

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 of people: those who

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

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 ---(end

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

(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 me that there are two kinds of people: those

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

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 competition there. - Indira Gandhi

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

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 told me to try to be in the first group; there was less competition

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

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 Figueiredo Jr. -- My grandfather once told me

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

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 who work and those who take the credit. He told

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't want any rows

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'; This works, but what I

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 will reject any pseudo-type

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 as ' begin

[HACKERS] SIg11 on suse linux

. - -- 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 - http

Res: [HACKERS] .NET driver

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 Member http

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

forums: forums.npgsql.org Thanks in advance. -- Regards, Francisco Figueiredo Jr. fxjr.blogspot.com www.npgsql.org -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

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

make some tests to see what can be happening. Thanks in advance, Ashish. -- Regards, Francisco Figueiredo Jr. http://fxjr.blogspot.com http://www.npgsql.org -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org

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

getting 404 error when trying to download the code. -- Regards, Francisco Figueiredo Jr. http://fxjr.blogspot.com http://www.npgsql.org -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

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

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 conversion if high-bit is set? Custom locale there won't make sense there anyway? -- marko -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http