Skip to content

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

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Open
gruporec opened this issue Apr 20, 2025 · 4 comments
Open

Comments

@gruporec
Copy link

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 gruporec changed the title Outerbase Studio shows Null for "interval" type field in postgressql Outerbase Studio shows Null for "interval" type field in postgresql Apr 20, 2025
@invisal
Copy link
Collaborator

invisal commented Apr 21, 2025

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

@g4nd4lf
Copy link

g4nd4lf commented Apr 21, 2025

Yes, desktop version in MacOs

@roth-dev
Copy link
Collaborator

I'll take a look into your case.

@roth-dev
Copy link
Collaborator

roth-dev commented Apr 23, 2025

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants