Re: [GENERAL] Recovering from failed transaction

2014-03-11 Thread Francisco Figueiredo Jr.
transaction class. --Brian -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://gplus.to

Re: [GENERAL] Npgsql - Where can I find Npgsql.NpgsqlServices

2013-12-12 Thread Francisco Figueiredo Jr.
there. Any ideas? Mike -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://gplus.to/franciscojunior http://fxjr.blogspot.com http://twitter.com/franciscojunior

Re: [GENERAL] Npgsql - Where can I find Npgsql.NpgsqlServices

2013-12-12 Thread Francisco Figueiredo Jr.
, Francisco Figueiredo Jr. franci...@npgsql.org wrote: Hi, Mike. We are working to get EF6 properly supported and our master branch already has support for it. Unfortunately pgfoundry is down at the moment. Please, if you can compile Npgsql from source code, please get a current snapshot

Re: [GENERAL] NpgsqlCopySerializer blows up if no rows are saved

2013-12-02 Thread Francisco Figueiredo Jr.
Hi! You should post Npgsql questions to our user's forums : http://forums.npgsql.org In this case I think it is a bug in Npgsql. Please add this test program to your post when talking about this problem. Thanks in advance. Em 02/12/2013 19:29, AK alk...@gmail.com escreveu: I am not sure if

Re: [GENERAL] NpgsqlCopySerializer blows up if no rows are saved

2013-12-02 Thread Francisco Figueiredo Jr.
Whooops. Sorry for not replying. :-( I'll check the problem and reply you back. Em 02/12/2013 20:21, AK alk...@gmail.com escreveu: I did a week ago - and got no replies at all. Thank you. -- View this message in context:

Re: [GENERAL] GSSAPI server side on Linux, SSPI client side on Windows

2013-11-12 Thread Francisco Figueiredo Jr.
Em 12/11/2013 03:37, Brian Crowell br...@fluggo.com escreveu: On Mon, Nov 11, 2013 at 10:51 PM, Brian Crowell br...@fluggo.com wrote: I think I'm getting closer though. I have psql on Windows successfully authenticating, so I can't be too far off. Got it. The NpgsqlPasswordPacket class

Re: [GENERAL] GSSAPI server side on Linux, SSPI client side on Windows

2013-11-12 Thread Francisco Figueiredo Jr.
On Tue, Nov 12, 2013 at 4:17 PM, Brian Crowell br...@fluggo.com wrote: On Tue, Nov 12, 2013 at 5:45 AM, Francisco Figueiredo Jr. franci...@npgsql.org wrote: I'm looking forward your patch. Npgsql source can be found at github.com/npgsql/Npgsql I figured out the username issue, and so I've

Re: [GENERAL] GSSAPI server side on Linux, SSPI client side on Windows

2013-11-05 Thread Francisco Figueiredo Jr.
://www.postgresql.org/mailpref/pgsql-general -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://gplus.to/franciscojunior http://fxjr.blogspot.com http://twitter.com/franciscojunior

Re: [GENERAL] Git host for postgresql related projects

2013-04-14 Thread Francisco Figueiredo Jr.
Thanks for the tip, Samit. I didn't know about Assembla. On Sun, Apr 14, 2013 at 5:52 AM, Sumit Raja sumit.r...@raja-consulting.co.uk wrote: Assembla does free git repositories as well http://www.assembla.com/ On 14 April 2013 05:22, Francisco Figueiredo Jr. franci...@npgsql.orgwrote

[GENERAL] Git host for postgresql related projects

2013-04-13 Thread Francisco Figueiredo Jr.
, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://gplus.to/franciscojunior http://fxjr.blogspot.com http://twitter.com/franciscojunior

Re: [GENERAL] Git host for postgresql related projects

2013-04-13 Thread Francisco Figueiredo Jr.
, Magnus Hagander mag...@hagander.netwrote: On Sat, Apr 13, 2013 at 9:10 PM, Francisco Figueiredo Jr. franci...@npgsql.org wrote: Hi all! I was thinking about moving Npgsql from cvs to another SCM. Possibly git. I'd like to know if there is any postgresql project host which supports git

Re: [GENERAL] Problem in Set search path

2013-03-25 Thread Francisco Figueiredo Jr.
in the database? That might just take out your need to specify it in your ,NET application. I try to find out my problem by your ideas. Thanks guys. Regards Kalai -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://gplus.to/franciscojunior http://fxjr.blogspot.com

Re: [GENERAL] Npgsql

2012-11-26 Thread Francisco Figueiredo Jr.
You should check if npgsql has been correctly installed in the gac by running gac -l Npgsql. If it is it will return something. Another possibility is to add a folder called bin to the root of your web app and put npgsql.dll and mono.security. dll inside. I hope it helps. Em 26/11/2012

Re: [GENERAL] Npgsql

2012-11-26 Thread Francisco Figueiredo Jr.
2012/11/26 Francisco Figueiredo Jr. francisco.figueiredo...@gmail.com gac -l Npgsql

Re: [GENERAL] Npgsql

2012-11-26 Thread Francisco Figueiredo Jr.
. The Global Assembly Cache contains the following assemblies: mono.security, Version=2.0.0.0, Culture=neutral, PublicKeyToken=0738eb9f132ed7 56, processorArchitecture=MSIL Number of items = 1 2012/11/26 Francisco Figueiredo Jr. franci...@npgsql.org Ok, and what about mono.security? Npgsql

Re: [GENERAL] Npgsql

2012-11-26 Thread Francisco Figueiredo Jr.
? Yes 2 and 4. I've tried with both pools and get same result. Also, can you try to add a bin folder in the root of your web app and put npgsql.dll and mono.security there? You mean create a folder called bin in: C:\inetpub\wwwroot ? 2012/11/26 Francisco Figueiredo Jr. franci...@npgsql.org

Re: [GENERAL] Another question about Range types

2012-08-03 Thread Francisco Figueiredo Jr.
Thanks! Em 03/08/2012 17:25, Mike Christensen m...@kitchenpc.com escreveu: Done. Bug #1011216 On Fri, Aug 3, 2012 at 1:11 PM, Francisco Figueiredo Jr. francisco.figueiredo...@gmail.com wrote: Regarding npgsql, range types have no direct mapping so they will be treated like strings

Re: [GENERAL] Another question about Range types

2012-08-03 Thread Francisco Figueiredo Jr.
Regarding npgsql, range types have no direct mapping so they will be treated like strings. Sorry for that. I'll work to add support to it. Would you mind to fill a feature request about that on our feature requests project page? http://project.npgsql.org Thanks in advance. Em 03/08/2012 17:01,

Re: [GENERAL] 9.1 causing out of shared memory error and higher serialization conflicts

2012-03-09 Thread Francisco Figueiredo Jr.
Thanks for the heads up. I'll fix that in Npgsql so it sends the correct isolation level when running on 9.1+ Sent from my Android phone On Mar 9, 2012 3:27 PM, Randy Ficker randyfic...@gmail.com wrote: Hey Marti, I almost replied that yes, I was 100% sure, since I know my code requests the

Re: [GENERAL] 9.1 causing out of shared memory error and higher serialization conflicts

2012-03-09 Thread Francisco Figueiredo Jr.
straight back down to the 8.4 level. Awesome! ** ** Thanks for the quick replies guys! ** ** *From:* francisco.figueiredo...@gmail.com [mailto: francisco.figueiredo...@gmail.com] *On Behalf Of *Francisco Figueiredo Jr. *Sent:* Friday, March 09, 2012 10:36 AM *To:* Randy Ficker *Cc

Re: [GENERAL] 9.1 causing out of shared memory error and higher serialization conflicts

2012-03-09 Thread Francisco Figueiredo Jr.
...@gmail.com [mailto: francisco.figueiredo...@gmail.com] *On Behalf Of *Francisco Figueiredo Jr. *Sent:* Friday, March 09, 2012 12:41 PM *To:* Randy Ficker *Cc:* Marti Raudsepp; pgsql-general@postgresql.org *Subject:* RE: [GENERAL] 9.1 causing out of shared memory error and higher serialization

Re: [GENERAL] Is there a reason why Postgres doesn't have Byte or tinyint?

2012-01-11 Thread Francisco Figueiredo Jr.
, you could make the conversion manually in your client code to your enum. I hope it helps. -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://gplus.to/franciscojunior http://fxjr.blogspot.com http://twitter.com/franciscojunior -- Sent via pgsql-general

Re: [GENERAL] Is there a reason why Postgres doesn't have Byte or tinyint?

2012-01-09 Thread Francisco Figueiredo Jr.
On Sun, Jan 8, 2012 at 21:31, Mike Christensen m...@kitchenpc.com wrote: On Sun, Jan 8, 2012 at 10:12 AM, Francisco Figueiredo Jr. franci...@npgsql.org wrote: On Sun, Jan 8, 2012 at 06:54, Mike Christensen m...@kitchenpc.com wrote: According to the manuals, Postgres has smallint (2 byte

Re: [GENERAL] Is there a reason why Postgres doesn't have Byte or tinyint?

2012-01-09 Thread Francisco Figueiredo Jr.
. -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://gplus.to/franciscojunior http://fxjr.blogspot.com http://twitter.com/franciscojunior -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Is there a reason why Postgres doesn't have Byte or tinyint?

2012-01-08 Thread Francisco Figueiredo Jr.
=text/x-cvsweb-markup Check method PrepareDefaultTypesMap(). I hope it helps. -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://gplus.to/franciscojunior http://fxjr.blogspot.com http://twitter.com/franciscojunior -- Sent via pgsql-general mailing list

Re: [GENERAL] What's the best way in Postgres9 to store a bunch of arbitrary boolean values for a row?

2011-12-05 Thread Francisco Figueiredo Jr.
with hibernate I've always done it by direct native queries. -- Craig Ringer -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://gplus.to/franciscojunior http://fxjr.blogspot.com http://twitter.com/franciscojunior -- Sent via pgsql-general mailing list

Re: [GENERAL] How to add xml data to table

2011-10-08 Thread Francisco Figueiredo Jr.
/Product /ProductList /GetProductListResult /GetProductListResponse /soap12:Body /soap12:Envelope -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://gplus.to/franciscojunior http://fxjr.blogspot.com http://twitter.com/franciscojunior -- Sent via pgsql

Re: [GENERAL] How to add xml data to table

2011-10-08 Thread Francisco Figueiredo Jr.
to call stored procedure periodically after every one hour in server? In this case we can create stored procedure, client side code is not nessecary at all. Andrus. -Algsõnum- From: Francisco Figueiredo Jr. Sent: Saturday, October 08, 2011 9:38 PM To: Andrus Moor Cc: pgsql-general

Re: [GENERAL] Why PGSQL has no developments in the .NET area?

2011-10-03 Thread Francisco Figueiredo Jr.
the ODBC driver is not the right choice for ORM framework of .NET. I want to know whether there is any efficient .NET provider and is PGSQL compatible with the .NET entity framework. Regards, Rohit. -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http

Re: [GENERAL] Why PGSQL has no developments in the .NET area?

2011-10-03 Thread Francisco Figueiredo Jr.
beta last week. :) -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://gplus.to/franciscojunior http://fxjr.blogspot.com http://twitter.com/franciscojunior top.letterhead

[GENERAL] Pgfoundry problem with Npgsql bug tracker

2011-06-24 Thread Francisco Figueiredo Jr.
the status of current bugs. Thanks in advance and again, sorry for bothering you in this list. -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://fxjr.blogspot.com http://twitter.com/franciscojunior -- Sent via pgsql-general mailing list (pgsql-general

[GENERAL] Npgsql 2.0.12 beta1 released!

2011-03-24 Thread Francisco Figueiredo Jr.
know if you find any problem. -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://fxjr.blogspot.com http://twitter.com/franciscojunior -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

[GENERAL] Re: [GENERAL] Re: [GENERAL] Re: [GENERAL] Different encoding for string values and identifier strings? Or (select 'tést' as tést) returns different values for string and identifier...

2011-03-18 Thread Francisco Figueiredo Jr.
some trouble? I also have problems with psql client where the char doesn't appear at all. Andreas could see the char though... I hope it helps. Thanks in advance. -- Sent from my Android phone Francisco Figueiredo Jr. Npgsql lead developer fxjr.blogspot.com twitter.com/franciscojunior Em 18/03

[GENERAL] Re: [GENERAL] Re: [GENERAL] Re: [GENERAL] Re: [GENERAL] Different encoding for string values and identifier strings? Or (select 'tést' as tést) returns different values for string and identi

2011-03-18 Thread Francisco Figueiredo Jr.
Francisco Figueiredo Jr. Npgsql lead developer fxjr.blogspot.com twitter.com/franciscojunior Em 18/03/2011 22:01, Tom Lane t...@sss.pgh.pa.us escreveu: Francisco Figueiredo Jr. franci...@npgsql.org writes: My database has encoding set to UTF-8 although my lc_collate is pt.BR.UTF-8 this lc

[GENERAL] Re: [GENERAL] Re: [GENERAL] Different encoding for string values and identifier strings? Or (select 'tést' as tést) returns different values for string and identifier...

2011-03-17 Thread Francisco Figueiredo Jr.
Any ideas?? Would it be possible that Postgresql would be using another encoding for the identifiers when they aren't wrapped by double quotes? On Tue, Mar 15, 2011 at 23:37, Francisco Figueiredo Jr. franci...@npgsql.org wrote: Now, I'm using my dev machine. With the tests I'm doing, I can

[GENERAL] Different encoding for string values and identifier strings? Or (select 'tést' as tést) returns different values for string and identifier...

2011-03-15 Thread Francisco Figueiredo Jr.
to change to specify the encoding of the identifiers? I'm using UTF-8 for my database. Thanks in advance. -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://fxjr.blogspot.com http://twitter.com/franciscojunior -- Sent via pgsql-general mailing list (pgsql

[GENERAL] Re: [GENERAL] Different encoding for string values and identifier strings? Or (select 'tést' as tést) returns different values for string and identifier...

2011-03-15 Thread Francisco Figueiredo Jr.
identifier as the bug report isn't using it. What happens if you remove the double quotes in the column name identifier? Thanks in advance. On Tue, Mar 15, 2011 at 15:21, Andreas Kretschmer akretsch...@spamfence.net wrote: Francisco Figueiredo Jr. franci...@npgsql.org wrote: Hi all! I

[GENERAL] Re: [GENERAL] Re: [GENERAL] Different encoding for string values and identifier strings? Or (select 'tést' as tést) returns different values for string and identifier...

2011-03-15 Thread Francisco Figueiredo Jr.
change at runtime in order to have it returned correctly? Thanks in advance. On Tue, Mar 15, 2011 at 15:45, Andreas Kretschmer akretsch...@spamfence.net wrote: Francisco Figueiredo Jr. franci...@npgsql.org wrote: What happens if you remove the double quotes in the column name identifier

[GENERAL] Re: [GENERAL] Re: [GENERAL] Different encoding for string values and identifier strings? Or (select 'tést' as tést) returns different values for string and identifier...

2011-03-15 Thread Francisco Figueiredo Jr.
. [1] - http://en.wikipedia.org/wiki/UTF-8 On Tue, Mar 15, 2011 at 15:52, Francisco Figueiredo Jr. franci...@npgsql.org wrote: H, What would change the encoding of the identifiers? Because on my dev machine which unfortunately isn't with me right now I can't get the identifier

Re: [GENERAL] could not accept SSPI security context

2011-03-10 Thread Francisco Figueiredo Jr.
That's great! I'm glad to hear it. Thank you very much for providing patches for this issue. -- Sent from my Android phone Francisco Figueiredo Jr. Npgsql lead developer fxjr.blogspot.com twitter.com/franciscojunior Em 10/03/2011 09:01, Ahmed Shinwari ahmed.shinw...@gmail.com escreveu: Hi

Re: [GENERAL] unexpected EOF on client connection vs 9.0.3

2011-03-08 Thread Francisco Figueiredo Jr.
Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://fxjr.blogspot.com http://twitter.com/franciscojunior -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] could not accept SSPI security context

2011-02-06 Thread Francisco Figueiredo Jr.
of Brar's code wouldn't break cases like the one he said in his last email? Thanks for feedback. On Wed, Feb 2, 2011 at 14:11, Francisco Figueiredo Jr. franci...@npgsql.org wrote: Thank you very much for your patch! I'm going to review and apply it. As soon as it is done, I'll let you know

Re: [GENERAL] could not accept SSPI security context

2011-02-02 Thread Francisco Figueiredo Jr.
the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org

Re: [GENERAL] Read problem from Bytea column

2011-01-22 Thread Francisco Figueiredo Jr.
Francisco Figueiredo Jr Sent from my Android phone. Em 21/01/2011 13:50, orgilhp orgi...@gmail.com escreveu: Hello, Hello! I have postgresql 8.3.9 database. Now I am working on reading file from bytea data and save to filesystem. I am using Npgsql.dll on c#.net. Which version of Npgsql

Re: [GENERAL] Bytea error in PostgreSQL 9.0

2010-12-14 Thread Francisco Figueiredo Jr.
) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://fxjr.blogspot.com http://twitter.com/franciscojunior -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Access postgresql data base from .net

2010-11-05 Thread Francisco Figueiredo Jr.
comprobado este mensaje. http://www.eset.com __ Información de ESET NOD32 Antivirus, versión de la base de firmas de virus 5575 (20101029) __ ESET NOD32 Antivirus ha comprobado este mensaje. http://www.eset.com -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http

Re: [GENERAL] Windows 2008/IIS cannot connect to Postgres 9.0

2010-10-24 Thread Francisco Figueiredo Jr.
the npgsql folks primarily use forums and the tracker for user support. Yeap. That's our primary support way. But I also keep eye on general, dev and interfaces mailing list in case something about Npgsql appears. -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org

Re: [GENERAL] Npgsql Exception

2010-08-23 Thread Francisco Figueiredo Jr.
-- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://fxjr.blogspot.com http://twitter.com/franciscojunior -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [GENERAL] Npgsql Exception

2010-08-23 Thread Francisco Figueiredo Jr.
Whooops, I didn't check the message header... You can ignore my first question :) On Mon, Aug 23, 2010 at 15:56, Francisco Figueiredo Jr. franci...@npgsql.org wrote: Are you using Npgsql with NHibernate? We added an option to send this command when starting a connection. But the setting

Re: [GENERAL] Working with pages of data (LIMIT/OFFSET keyword)

2010-06-17 Thread Francisco Figueiredo Jr.
and then do something just for the case where there is no data. Or use LIMIT 31 so you always know that there is the next page with at least one record. regards Szymon Guz -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://fxjr.blogspot.com http

Re: [GENERAL] Does npgsql have a bunch of bugs with DB enums?

2010-06-08 Thread Francisco Figueiredo Jr.
and I shouldn't have to worry about that.  Thanks!! Mike -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http

Re: [GENERAL] Npgsql connection string editor?

2010-02-24 Thread Francisco Figueiredo Jr.
, npdata); dtsource = dset.Tables[npdata]; deleteCmd(); updateCmd(); insertCmd(); } How can I get ConnectionStringEditorForm? RobR -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://fxjr.blogspot.com http

Re: [GENERAL] Unexpected EOF on client connection

2009-12-01 Thread Francisco Figueiredo Jr.
connection string. Try to put a higher value of min connection pool, so they aren't closed too frequently. Also, as Richard said, check your connection usage pattern in your application. I hope it helps. -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http

Re: [GENERAL] Unexpected EOF on client connection

2009-12-01 Thread Francisco Figueiredo Jr.
correct. But there may be a bug in Npgsql code itself. That's why I asked you to try to raise minpoolvalue to check if you see less errors. I hope it helps. -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://fxjr.blogspot.com http://twitter.com/franciscojunior

Re: [GENERAL] Behavior of NpgsqlDataReader in NpgSql 1 and NpgSql 2

2009-06-12 Thread Francisco Figueiredo Jr.
to Npgsql2 I hope it helps. -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://fxjr.blogspot.com http://twitter.com/franciscojunior Sent from Brasilia, DF, Brazil -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Difference between in (...) and = any(...) queries when using arrays

2009-05-12 Thread Francisco Figueiredo Jr.
On Tue, May 12, 2009 at 05:02, Richard Huxton d...@archonet.com wrote: Francisco Figueiredo Jr. wrote: Hi all! I was playing with in (...)  and = any (...) queries and found a difference between them and I wonder: why this works: select * from table_of_integers where integer_column = any

[GENERAL] Difference between in (...) and = any(...) queries when using arrays

2009-05-11 Thread Francisco Figueiredo Jr.
]); Although documentation says: 9.20.4. ANY/SOME [...] SOME is a synonym for ANY. IN is equivalent to = ANY. [...] I thought that if IN is equivalent to = any, both queries above should work. Am I missing something? Thanks in advance. -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http

Re: [GENERAL] need information

2009-04-16 Thread Francisco Figueiredo Jr.
product design, development and delivery- www.persistentsys.com -Original Message- From: francisco.figueiredo...@gmail.com [mailto:francisco.figueiredo...@gmail.com] On Behalf Of Francisco Figueiredo Jr. Sent: Wednesday, April 15, 2009 11:40 PM To: Peeyush Cc: pgsql

Re: [GENERAL] need information

2009-04-15 Thread Francisco Figueiredo Jr.
received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Ltd. does not accept any liability for virus infected mails. -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://fxjr.blogspot.com http

Re: [GENERAL] Question about functions that return a set of records

2009-02-20 Thread Francisco Figueiredo Jr.
, Francisco Figueiredo Jr. Npgsql Lead Developer http://fxjr.blogspot.com http://www.npgsql.org -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] How to convert ByteA to Large Objects

2009-01-23 Thread Francisco Figueiredo Jr.
improvements when handling bytea values but only when the NpgsqlCommand.Prepare() method is called. I hope it helps. -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://fxjr.blogspot.com http://www.npgsql.org -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] How to convert ByteA to Large Objects

2009-01-23 Thread Francisco Figueiredo Jr.
On Fri, Jan 23, 2009 at 11:25 AM, Howard Cole howardn...@selestial.com wrote: Francisco Figueiredo Jr. wrote: About the memory issue of Npgsql, did you try to use a prepared statement for this? We have some performance improvements when handling bytea values but only when

Re: [GENERAL] Installing the Npgsql provider for .Net

2009-01-06 Thread Francisco Figueiredo Jr.
, Francisco Figueiredo Jr. Npgsql Lead Developer http://fxjr.blogspot.com http://www.npgsql.org -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Generic provider for .Net

2009-01-06 Thread Francisco Figueiredo Jr.
to make to register Npgsql as a dbproviderfactory. Also note that Npgsql supports sqlclient parameter style with the '@' prefix to easy porting sql code from sqlserver to postgresql. I hope it helps. -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://fxjr.blogspot.com http

Re: [GENERAL] postgresql and Mac OS X

2008-11-04 Thread Francisco Figueiredo Jr.
5 ld: library not found for -lcrt1.10.5.o - crt1.10.5.o I hope it helps. -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://fxjr.blogspot.com http://www.npgsql.org -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

[GENERAL] Why select 1 where current_date = 'infinity'; doesn't work?

2008-10-14 Thread Francisco Figueiredo Jr.
, Francisco Figueiredo Jr. Npgsql Lead Developer http://fxjr.blogspot.com http://www.npgsql.org -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Why select 1 where current_date = 'infinity'; doesn't work?

2008-10-14 Thread Francisco Figueiredo Jr.
On Tue, Oct 14, 2008 at 1:18 PM, Tom Lane [EMAIL PROTECTED] wrote: Francisco Figueiredo Jr. [EMAIL PROTECTED] writes: ERROR: invalid input syntax for type date: infinity I thought I could use it anywhere in my sql. No, only timestamps support infinity. We do have a TODO item to allow type

Re: [GENERAL] Some server processes stalled with aborted client sockets

2008-08-31 Thread Francisco Figueiredo Jr.
On Thu, Aug 28, 2008 at 1:42 AM, Francisco Figueiredo Jr. [EMAIL PROTECTED] wrote: Hi all! Any clues about this? Thanks in advance. I'm playing with client thread abort issues in Npgsql. And with a test sample one of our users provided us we are seeing that even after the client finishes

[GENERAL] Some server processes stalled with aborted client sockets

2008-08-27 Thread Francisco Figueiredo Jr.
for any advice about this issue. -- Regards, Francisco Figueiredo Jr. http://fxjr.blogspot.com http://www.npgsql.org -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Postres.exe Processes Hang

2008-08-18 Thread Francisco Figueiredo Jr.
to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Regards, Francisco Figueiredo Jr. http://fxjr.blogspot.com http://www.npgsql.org -- Regards, Francisco Figueiredo Jr. http://fxjr.blogspot.com http://www.npgsql.org -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] Postres.exe Processes Hang

2008-08-18 Thread Francisco Figueiredo Jr.
enabled. -- Regards, Francisco Figueiredo Jr. http://fxjr.blogspot.com http://www.npgsql.org -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] How to create a function with multiple RefCursor OUT parameters

2008-05-17 Thread Francisco Figueiredo Jr.
On Fri, May 16, 2008 at 10:06 AM, Merlin Moncure [EMAIL PROTECTED] wrote: On Fri, May 16, 2008 at 2:17 AM, Albe Laurenz [EMAIL PROTECTED] wrote: Chuck Bai wrote: Hi, Chuck! What's the Npgsql code you are using to call this function? Thanks in advance. -- Regards, Francisco Figueiredo Jr

Re: [GENERAL] select statement fails

2008-04-09 Thread Francisco Figueiredo Jr.
://pgfoundry.org/forum/message.php?msg_id=1003377 I hope it helps. -- Regards, Francisco Figueiredo Jr. fxjr.blogspot.com www.npgsql.org -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] connecting VB to postgreSQL

2008-04-09 Thread Francisco Figueiredo Jr.
, Francisco Figueiredo Jr. fxjr.blogspot.com www.npgsql.org -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] select statement fails

2008-04-09 Thread Francisco Figueiredo Jr.
On Wed, Apr 9, 2008 at 1:31 PM, Francisco Figueiredo Jr. [EMAIL PROTECTED] wrote: Ask the .npgsql mailing lists. They'll be able to tell you. There must be a way of handling non-standard types in any case. Hi all! We are already working on that. The cast problem