Home
Help
Register
Log in

Search

 
   Active Threads  

You are here: Home > LLBLGen Pro > Designer> Postgresql + Inet data type
 

Pages: 1
Designer
Postgresql + Inet data type
Page:1/1 

  Print all messages in this thread  
Poster Message
renesisx
User



Location:

Joined on:
07-Aug-2006 12:12:59
Posted:
44 posts
# Posted on: 17-Feb-2007 00:40:01.  
Does LLBLGen support the Postgresql / Npgsql Inet data type?

I just converted a field in a table to this type from varchar, and when I do a Refresh nothing changes and it is still listed under "DB Type" as "varchar".

Any clues?
  Top
bclubb
User



Location:
Norman, Oklahoma
Joined on:
12-Feb-2004 22:18:04
Posted:
934 posts
# Posted on: 17-Feb-2007 03:28:00.  
It's not supported by default, but you could add it to the PostgreSqlDQE project and recompile the LLBLGen database driver. I believe you would just need to add the functionality to the CreateParameter method in PostgreSqlSpecificCreator.cs

Let us know if this is an option or if you have any problems.


  Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
37803 posts
# Posted on: 17-Feb-2007 10:10:51.  
We only support the npgsql provider's types. INet isn't one of these. However, isn't inet a synonym for another type? (I'm not that familiar with every type in postgresql, there are a lot)
Frans Bouma
LLBLGen Pro / ORM Profiler Lead Developer | Blog | Twitter
 
Top
renesisx
User



Location:

Joined on:
07-Aug-2006 12:12:59
Posted:
44 posts
# Posted on: 17-Feb-2007 14:12:57.  
I thought it was supported by Npgsql, but now you've thrown me into doubt Regular Smiley

I found this reference in the release notes for Npgsql 1.0 RC2:

"Added support for Inet data type. Use NpgsqlDbType.Inet when adding parameters. Native types supported are NpgsqlInet and IPAddress. Thanks Magnus Hagander ( mha at sollentuna dot net ) for patch."


  Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
37803 posts
# Posted on: 17-Feb-2007 18:44:34.  
aha! Ok, I missed that one, as I wrote the postgresql code when it was before the RC release, so I didnt know that type was supported as well. I'll see if I can add that type to the postgresql driver for v2.1.
Frans Bouma
LLBLGen Pro / ORM Profiler Lead Developer | Blog | Twitter
 
Top
renesisx
User



Location:

Joined on:
07-Aug-2006 12:12:59
Posted:
44 posts
# Posted on: 18-Feb-2007 02:10:43.  
Thanks Frans.

I've bodged it for now back to a varchar but hopefully v2.1 will be out before my development is finished in a couple of months so I can put it straight.


  Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
37803 posts
# Posted on: 19-Feb-2007 10:55:51.  
renesisx wrote:
Thanks Frans.

I've bodged it for now back to a varchar but hopefully v2.1 will be out before my development is finished in a couple of months so I can put it straight.

It's planned to go beta at the end of march. I think we'll slip over that date with a couple of weeks but not that much.
Frans Bouma
LLBLGen Pro / ORM Profiler Lead Developer | Blog | Twitter
 
Top
renesisx
User



Location:

Joined on:
07-Aug-2006 12:12:59
Posted:
44 posts
# Posted on: 13-Apr-2007 17:22:03.  
Hey Frans,

Will support for the Inet datatype on Postgres definitely be in the v2.1 release?

Thanks!


  Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
37803 posts
# Posted on: 13-Apr-2007 19:23:27.  
renesisx wrote:
Hey Frans,

Will support for the Inet datatype on Postgres definitely be in the v2.1 release?

Thanks!

It's a couple of lines of code I think. So yes, it's still on the list of things to add to v2.1
Frans Bouma
LLBLGen Pro / ORM Profiler Lead Developer | Blog | Twitter
 
Top
Pages: 1  


Powered by HnD ©2002-2007 Solutions Design
HnD uses LLBLGen Pro

Version: 2.1.12172008 Final.