Raveen
Query execution issue with CTE in xata.sql
I am trying to exceute a query in xata.sql but it thorws an error where I try to use a CTE.
CTE as a general works but whe, for example if I try to use select * for ProductMaxDiscount ; it is working. But if I use an alias for the cte and refer them in select or try to join with other, I get table not found error.
I tried the query in other postgres env, it is working fine. Below is the query I want to execute. And below that I'll attach the ddl for quick start for testing.
```
7 replies
Unable to get file attachment url when using xata.sql
When using xata.sql, I am not able to get the image url in the returned object, I get other attributes like
enablePublicUrl: true,
id: XXX',
mediaType: 'image/webp',
name: '759662.webp',
signedUrlTimeout: 60,
size: 12844,
storageKey: 'XXX',
uploadKey: 'XXX',
uploadUrlTimeout: 86400,
version: 1
}
5 replies
Making file attachment column public by default
Hi , I have created a column for file attachment without making it as public by default, Now I want to change it to public by default, how can I achieve it ? I don't see that option in xata schema edit command
3 replies
Db server in India
Hi Team, I'm from India and I find xata a very useful product in my tech stack. Unfortunately the nearest server to India I can find is Frankfurt, which is still far away and I can see it affects the latency of data retrieval. Will there be a Server setup done in India anywhere in the near future ?
Thanks.
5 replies
