Comments (5)
Sorry to hear that, I am afraid debugging further is hard! I cannot reproduce this on hosted or self-hosted. Potentially someone else might have other ideas!
from supabase.
This could be due to the changes. As this is a database setting, often you need to either reload the config or reload the connection.
Does the following work?
ALTER DATABASE postgres SET timezone TO 'Asia/Qyzylorda';
SHOW timezone;
(should output to original timezone)- Disconnect and reconnect to the database
SHOW timezone;
(should show 'Asia/Qyzylorda')
If this works then it is expected behaviour. If it does not, let us know what is different!
from supabase.
Output from SHOW timezone;
changes after ALTER DATABASE postgres SET timezone TO 'Asia/Qyzylorda';
instantly without reconnect or the config reload
from supabase.
You will need to start a new session for the config to take place. This is not a bug I am afraid
from supabase.
Starting a new session didn't solve the problem, DB still return time by the old timezone.
from supabase.
Related Issues (20)
- CSV Import in studio fails to assign authenticated user id HOT 2
- Supabase CLI starts the containers but then does Stopping containers... resulting in broken: malformed HTTP response HOT 3
- Two different clock times in the same column HOT 3
- error in guidance on setting up email template URL's for Next.js project HOT 1
- [Supabase.com ONLY] Duplicate key value violates unique constraint updating non-unique column
- Cannot delete an organization HOT 10
- TS type generation does not give output in terminal, has remains in output file after running the script HOT 1
- Getting error `operator does not exist: text &@~ text` after updating supabase CLI HOT 5
- Self-hosted Supabase does not take into account changed base path, always serves on root path HOT 1
- Supabase IDE does not let me update the field from the relationship (double clic), but it does accept the change when editing the row manually. HOT 1
- apikey Query Parameter Causes Parsing Error in Local Supabase API, Works Fine in Cloud Version HOT 13
- unable to see edge functions in local development studio + when doing supabase login it only goes to supabase url and not to self hosted version HOT 2
- SvelteKit: Connect to your project guide HOT 2
- possible bug in dashboard view of database metadata HOT 1
- Local API: GET projects relation does not exist HOT 2
- cron schema not available in seed.sql (pg_cron) HOT 2
- Handle prompt when generating types HOT 7
- Supabase Studio self-hosted messed up table style
- The file in html format is loaded. The type is incorrect. HOT 1
- Extension tables showing in Public view (Local Dev)
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from supabase.