studio icon indicating copy to clipboard operation
studio copied to clipboard

Outerbase Studio shows Null for "interval" type field in postgresql

Open gruporec opened this issue 9 months ago • 4 comments

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;

gruporec avatar Apr 20 '25 16:04 gruporec

Are you using desktop version? @roth-dev can you check interval type for PostgreSQL?

invisal avatar Apr 21 '25 01:04 invisal

Yes, desktop version in MacOs

g4nd4lf avatar Apr 21 '25 05:04 g4nd4lf

I'll take a look into your case.

roth-dev avatar Apr 21 '25 06:04 roth-dev

Should be fix by this PR: outerbase/sdk-transform#5

roth-dev avatar Apr 23 '25 16:04 roth-dev