inet column type in Postgres
24 February, 2014
Hi,
In the view/report, a Postgresql field of type 'inet' will cause Yellowfin to incorrectly try to display it as a "Link to URL".
It's wrong, as the inet type is '7 or 19 bytes IPv4 and IPv6 hosts and networks', see http://www.postgresql.org/docs/9.1/static/datatype-net-types.html.
There no mention of URL in the Postgresql docs.
As a result, YF by default displays 'null' as it cannot figure out how to represent 10.10.10.10 as (for example) 'http://www.somewebsite.com'.
Changing the display format of the column to 'raw formatter' fixes it.
Is this how it works?
Regards,
Nick
In the view/report, a Postgresql field of type 'inet' will cause Yellowfin to incorrectly try to display it as a "Link to URL".
It's wrong, as the inet type is '7 or 19 bytes IPv4 and IPv6 hosts and networks', see http://www.postgresql.org/docs/9.1/static/datatype-net-types.html.
There no mention of URL in the Postgresql docs.
As a result, YF by default displays 'null' as it cannot figure out how to represent 10.10.10.10 as (for example) 'http://www.somewebsite.com'.
Changing the display format of the column to 'raw formatter' fixes it.
Is this how it works?
Regards,
Nick
Hi Nick,
Java does not have a way of knowing that this is an IP address, the data is just sent as binary. This is because it's a special data type, that is specific to Postgres (there are a few special data types, which Java just doens't know about).
So when using a JDBC driver, you're always going to get this result.
In Yellowfin, when we detect binary, we default to give the user the option to 'link to file' or 'download link' . This is because binary is usually data stored in the DB, which cannot be viewed by looking at the raw data (e.g. It's an image/video).
However, I have raised an enhancement request (TASK ID = 156240), so that YF can detect the data type somehow, and then default the format view to RAW, so you don't have to manually change it.
Sorry for the inconvenience, you're just going to have to change the column format manually, until the enhancement has been implemented.
Regards,
David
Java does not have a way of knowing that this is an IP address, the data is just sent as binary. This is because it's a special data type, that is specific to Postgres (there are a few special data types, which Java just doens't know about).
So when using a JDBC driver, you're always going to get this result.
In Yellowfin, when we detect binary, we default to give the user the option to 'link to file' or 'download link' . This is because binary is usually data stored in the DB, which cannot be viewed by looking at the raw data (e.g. It's an image/video).
However, I have raised an enhancement request (TASK ID = 156240), so that YF can detect the data type somehow, and then default the format view to RAW, so you don't have to manually change it.
Sorry for the inconvenience, you're just going to have to change the column format manually, until the enhancement has been implemented.
Regards,
David
Hi Dave,
Thanks for the feedback.
Regards,
Nick
Thanks for the feedback.
Regards,
Nick