Repository navigation
Outerbase Studio shows Null for "interval" type field in postgresql #428
Description
I am testing Outerbase Studio with a Postgresql database created in django. When I read it with Outerbase Studio the fields of type "interval" are showed as NULL. In Django I can read the right values. Is this a limitation of Outerbase Studio or am I doing something wrong?
If I manually perform the query like this, the data is properly showed:
SELECT "timeIrrigation"::TEXT AS time_str
FROM farms_historictimeirrigation
ORDER BY "id" DESC
LIMIT 1;
but it shows null if I use:
SELECT *
FROM farms_historictimeirrigation
ORDER BY "id" DESC
LIMIT 1;
Activity
[-]Outerbase Studio shows Null for "interval" type field in postgressql[/-][+]Outerbase Studio shows Null for "interval" type field in postgresql[/+]invisal commentedon Apr 21, 2025
Are you using desktop version? @Roth-dev can you check interval type for PostgreSQL?
g4nd4lf commentedon Apr 21, 2025
Yes, desktop version in MacOs
rothxz commentedon Apr 21, 2025
I'll take a look into your case.
rothxz commentedon Apr 23, 2025
Should be fix by this PR: outerbase/sdk-transform#5