Re: [GENERAL] Recovering from failed transaction

2014-03-11 Thread Francisco Figueiredo Jr.
of my ROLLBACK. Apparently I need to do > transactions with Npgsql's 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 >

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

2013-12-12 Thread Francisco Figueiredo Jr.
> > > > On Thu, Dec 12, 2013 at 8:34 AM, 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 pgf

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

2013-12-12 Thread Francisco Figueiredo Jr.
rom: > > > http://pgfoundry.org/frs/download.php/3494/Npgsql2.0.13.91-bin-ms.net4.5Ef6.zip > > No luck 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] 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" escreveu: > I did a week ago - and got no replies at all. Thank you. > > > > -- > View this message in context: > http://postgresql.1045698.n5.nabble.com/NpgsqlCopySerializer-blows-up-if-n

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" escreveu: > I am not sure if this is the cor

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 wrote: > On Tue, Nov 12, 2013 at 5:45 AM, Francisco Figueiredo Jr. > wrote: > > I'm looking forward your patch. > > Npgsql source can be found at github.com/npgsql/Npgsql > > I figured out the username issue, an

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" escreveu: > > On Mon, Nov 11, 2013 at 10:51 PM, Brian Crowell 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 has a bug: a utility f

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

2013-11-05 Thread Francisco Figueiredo Jr.
oblem. I hope it helps. > -- > Christian > > > > > > > -- > 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/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. wr

Re: [GENERAL] Git host for postgresql related projects

2013-04-13 Thread Francisco Figueiredo Jr.
2013 at 4:12 PM, Magnus Hagander wrote: > On Sat, Apr 13, 2013 at 9:10 PM, Francisco Figueiredo Jr. > wrote: > > > > Hi all! > > > > > > I was thinking about moving Npgsql from cvs to another SCM. Possibly git. > > > > I'd like to know if there is

[GENERAL] Git host for postgresql related projects

2013-04-13 Thread Francisco Figueiredo Jr.
for your help and advice. -- 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] Problem in "Set search path"

2013-03-25 Thread Francisco Figueiredo Jr.
(role) objects and on > database objects 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

Re: [GENERAL] Npgsql

2012-11-26 Thread Francisco Figueiredo Jr.
ion? > 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/2

Re: [GENERAL] Npgsql

2012-11-26 Thread Francisco Figueiredo Jr.
All rights reserved. > > 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 J

Re: [GENERAL] Npgsql

2012-11-26 Thread Francisco Figueiredo Jr.
orArchitecture=MSIL > > Number of items = 1 > > > 2012/11/26 Francisco Figueiredo Jr. > >> gac -l Npgsql > > >

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/201

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, "M

Re: [GENERAL] Another question about Range types

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

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

2012-03-09 Thread Francisco Figueiredo Jr.
; > *From:* francisco.figueiredo...@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 &q

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

2012-03-09 Thread Francisco Figueiredo Jr.
raight 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, Marc

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" wrote: > Hey Marti, > > I almost replied that yes, I was 100% sure, since I know my code requests > the REPEATABLE READ

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

2012-01-11 Thread Francisco Figueiredo Jr.
ing datatype which >> maps to postgresql bit fields which could give you the information you >> want. But I don't know if it would be too much overkill for your >> rating system. >> BitString datatype already have a lot of helpers methods though >> including one

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

2012-01-09 Thread Francisco Figueiredo Jr.
ter varying, OUT recipecount integer, out ingredientcount > integer) >  RETURNS SETOF record AS >  $BODY$ >  BEGIN >    -- All sorts of stuff way too mind-blowing for this email >  END; > > Then I call it as so: > > IDbCommand cmd = session.Connection.Cr

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 wrote: > On Sun, Jan 8, 2012 at 10:12 AM, Francisco Figueiredo Jr. > wrote: >> On Sun, Jan 8, 2012 at 06:54, Mike Christensen wrote: >>>>>>>> According to the manuals, Postgres has smallint (2 byte), integer (4

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

2012-01-08 Thread Francisco Figueiredo Jr.
d since a byte type isn't required by >> the SQL spec, it would take some effort to get a standard one included >> in the core. > > That makes sense. > > I guess my question is more of a NpgSql question then.  Is there a way > to create a custom PG type, and have npgs

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.
elational > features like hstore through a layer that tries to be db-independent and > purely relational. I don't have any experience with Castle ActiveRecord. > When I've used hstore with hibernate I've always done it by direct native > queries. > > -- > Craig Ri

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

2011-10-08 Thread Francisco Figueiredo Jr.
1], '.') as weight > from product_list > > Looks simpler than using XmlReader, isn't it? > How to invoke asmx web service call (= http POST request) from > PostgreSql server  which reads http response to xml_import  table ? > > How to call stored proce

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

2011-10-08 Thread Francisco Figueiredo Jr.
> 6500 > 6501 > 65010200 > 10001125 > AM > Acme API Specification v 1.0 > 13 > ADA3000AXBOX > AMD Athlon64 3000+ (2000MHz/1600MHz/L2 Cache 512KB) Socket 754, > BOX > 36 > 296.0 > 0 > 3.6000 > 1999-01-01T00:00:00 > false > > > >

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

2011-10-03 Thread Francisco Figueiredo Jr.
you. Sorry for that. On the good side, we released a new 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 <>

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

2011-10-03 Thread Francisco Figueiredo Jr.
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:/

[GENERAL] Pgfoundry problem with Npgsql bug tracker

2011-06-24 Thread Francisco Figueiredo Jr.
w bug reports and checking 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-gener

[GENERAL] Npgsql 2.0.12 beta1 released!

2011-03-24 Thread Francisco Figueiredo Jr.
ive it a try and feel free to let us 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 chang

[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.
phone Francisco Figueiredo Jr. Npgsql lead developer fxjr.blogspot.com twitter.com/franciscojunior Em 18/03/2011 22:01, "Tom Lane" escreveu: > "Francisco Figueiredo Jr." writes: >> My database has encoding set to UTF-8 although my lc_collate is pt.BR.UTF-8 >> th

[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.
ting my have cause 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/f

[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. wrote: > Now, I'm using my dev machine. > > With the tests I'm doing,

[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.
compiled postgresql 9.0.1 from source code. Thanks in advance. [1] - http://en.wikipedia.org/wiki/UTF-8 On Tue, Mar 15, 2011 at 15:52, Francisco Figueiredo Jr. wrote: > H, > > What would change the encoding of the identifiers? > > Because on my dev machine which unfor

[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.
ere any config I can change at runtime in order to have it returned correctly? Thanks in advance. On Tue, Mar 15, 2011 at 15:45, Andreas Kretschmer wrote: > Francisco Figueiredo Jr. wrote: > >> >> What happens if you remove the double quotes in the column name identifier? > >

[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.
7;t test putting double quotes in the column name 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 wrote: > Francisco Figueiredo Jr. wrote: >

[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.
ion I need 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 mail

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" escreveu: > Hi

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

2011-03-08 Thread Francisco Figueiredo Jr.
ards, > Radek > > -- > 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://fx

Re: [GENERAL] "could not accept SSPI security context"

2011-02-06 Thread Francisco Figueiredo Jr.
instead 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. wrote: > Thank you very much for your patch! > > I'm going to review and apply it. > > As soon as it is done

Re: [GENERAL] "could not accept SSPI security context"

2011-02-02 Thread Francisco Figueiredo Jr.
tml > Sent from 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 Fi

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" 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. > Whi

Re: [GENERAL] Bytea error in PostgreSQL 9.0

2010-12-14 Thread Francisco Figueiredo Jr.
      # hex, escape >> >> into postgresql.conf. >> >> >> >> -- >> Sent via pgsql-general mailing list (pgsql-general@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general > > -- Regards,

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

2010-11-05 Thread Francisco Figueiredo Jr.
la base de firmas > de virus 5575 (20101029) ______ > > ESET NOD32 Antivirus ha 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 A

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

2010-10-24 Thread Francisco Figueiredo Jr.
ums linked to off that page. It looks like 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, Francis

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. wrote: > Are you using Npgsql with NHibernate? > > We added an option to send this command when starting a connection. > > But the set

Re: [GENERAL] Npgsql Exception

2010-08-23 Thread Francisco Figueiredo Jr.
l@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://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] Working with pages of data (LIMIT/OFFSET keyword)

2010-06-17 Thread Francisco Figueiredo Jr.
ll use this if there's no other way. >> > > Just run them in one transaction. > You can also just show the Next/Prev buttons 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 &g

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

2010-06-08 Thread Francisco Figueiredo Jr.
y cast to either a string or an int 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://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] Npgsql connection string editor?

2010-02-24 Thread Francisco Figueiredo Jr.
pAdapter = new NpgsqlDataAdapter(); > NpAdapter.SelectCommand = new NpgsqlCommand(query, conn); > NpAdapter.Fill(dset, "npdata"); > dtsource = dset.Tables["npdata"]; > > deleteCmd(); > updateCmd(); > insertCmd(); > } > &

Re: [GENERAL] Unexpected EOF on client connection

2009-12-01 Thread Francisco Figueiredo Jr.
is error if I use Npgsql? >> That's 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

Re: [GENERAL] Unexpected EOF on client connection

2009-12-01 Thread Francisco Figueiredo Jr.
ool values in your 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:

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

2009-06-12 Thread Francisco Figueiredo Jr.
ented methods. It is strongly advised that current users update from Npgsql1 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 v

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

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

2009-05-11 Thread Francisco Figueiredo Jr.
eger_column in (array[5,6]); 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

Re: [GENERAL] need information

2009-04-16 Thread Francisco Figueiredo Jr.
t; > Thanks & regards, > > Peeyush Jain | Software Engineer –Netezza Dev | Persistent Systems Ltd > > peeyush_j...@persistent.co.in  | Cell: +91 9373069475 | Tel: +91 (20) 3023 > 6762 > > Innovation in software product design, development and delivery- > www.persiste

Re: [GENERAL] need information

2009-04-15 Thread Francisco Figueiredo Jr.
ed recipient, you are not authorized to read, retain, > copy, print, distribute or use this message. If you have received this > communication in error, please notify the sender and delete all copies of > this message. Persistent Systems Ltd. does not accept any liability fo

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

2009-02-20 Thread Francisco Figueiredo Jr.
support for returning setof refcursor. You can check examples about how to do that in our user manual: http://manual.npgsql.org 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 subscription: http://www.postgresql.org/mailpref/pgsql-general

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 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 the Npg

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

2009-01-23 Thread Francisco Figueiredo Jr.
have some performance 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-ge

Re: [GENERAL] Generic provider for .Net

2009-01-06 Thread Francisco Figueiredo Jr.
gister 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://www.npgsql.o

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

2009-01-06 Thread Francisco Figueiredo Jr.
e file Mono.Security.dll into the GAC as Npgsql.dll depends on it. This file is also found in the downloaded file. Maybe you got one for Mono which already contains the Mono.Security.dll assembly. If you read the manual and still have doubts, please let us know. I hope it helps. -- Regards, Francisco Figu

Re: [GENERAL] postgresql and Mac OS X

2008-11-04 Thread Francisco Figueiredo Jr.
me path/dir variable? > I think you need to install the developer tools. I compile postgresql from sources with no problem on osx 10.5.4 but I installed developer tools before. The library which is missing is the following: > configure:2246: checking for C compiler default output file name >

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

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 12:58 PM, Francisco Figueiredo Jr. <[EMAIL PROTECTED]> wrote: > It gives me the following error: > > ERROR: invalid input syntax for type date: "infinity" > > I thought I could use it anywhere in my sql. > > I have to add a cast to t

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

2008-10-14 Thread Francisco Figueiredo Jr.
. -- 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 subscription: http://www.postgresql.org/mailpref/pgsql-general

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

[GENERAL] Some server processes stalled with aborted client sockets

2008-08-27 Thread Francisco Figueiredo Jr.
using Postgresql 8.3.3 on OSX 10.5.4 Thanks in advance 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.
es slower than with the pool 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] Postres.exe Processes Hang

2008-08-18 Thread Francisco Figueiredo Jr.
d by default. > > //Magnus > > -- > 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. http://fxjr.blogspot.com http://www.np

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

2008-05-16 Thread Francisco Figueiredo Jr.
-- 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] 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

Re: [GENERAL] connecting VB to postgreSQL

2008-04-09 Thread Francisco Figueiredo Jr.
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] select statement fails

2008-04-09 Thread Francisco Figueiredo Jr.
e fix for it. Check it out here: http://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