Postgresql + Inet data type

Posts   
 
    
renesisx
User
Posts: 44
Joined: 07-Aug-2006
# 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?

bclubb
User
Posts: 934
Joined: 12-Feb-2004
# 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.

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# 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 | Lead developer LLBLGen Pro
renesisx
User
Posts: 44
Joined: 07-Aug-2006
# Posted on: 17-Feb-2007 14:12:57   

I thought it was supported by Npgsql, but now you've thrown me into doubt simple_smile

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

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# 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 | Lead developer LLBLGen Pro
renesisx
User
Posts: 44
Joined: 07-Aug-2006
# 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.

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# 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 | Lead developer LLBLGen Pro
renesisx
User
Posts: 44
Joined: 07-Aug-2006
# 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!

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# 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 | Lead developer LLBLGen Pro