cmck Comments - Answer Overflow

Topics

cmck

•Created by Triqueta Ventures on 2/21/2025 in #help

Numeric ID for transfer codes

No description

9 replies

•Created by Triqueta Ventures on 2/21/2025 in #help

Numeric ID for transfer codes

I'm afraid this is one of the limitations of a non-postgres-enabled database. Your other option is to migrate your database to a postgres-enabled database (the option can only be toggled at db creation)

9 replies

•Created by Triqueta Ventures on 2/21/2025 in #help

Numeric ID for transfer codes

Ah, I can see that your databases are not enabled for direct postgres access. Unfortuntately, running such statements is not supported on non-postgres enabled databases.

9 replies

•Created by Triqueta Ventures on 2/21/2025 in #help

Numeric ID for transfer codes

Is your database enabled for direct Postgres access? If so, does the database have the native sql table option enabled?

9 replies

•Created by Triqueta Ventures on 2/21/2025 in #help

Numeric ID for transfer codes

Hi there! You can use SERIAL to add a column that will auto increment and stay unique. I created a table called test in my own environment then ran the following query in the UI:

ALTER TABLE test ADD COLUMN id_serial SERIAL PRIMARY KEY;

ALTER TABLE test ADD COLUMN id_serial SERIAL PRIMARY KEY;

If you return to the table and add records you'll see that the id_serial column is automatically updated with a unique id. The only caveat is that you can't use the name id

9 replies

•Created by alihammad on 2/20/2025 in #general

Hi, the code and types files don't auto

If you use a fresh project folder does the issue persist?

12 replies

•Created by alihammad on 2/20/2025 in #general

Hi, the code and types files don't auto

Hmm I have a ledger and a list of migrations. What version of the CLI are you using?

12 replies

•Created by alihammad on 2/20/2025 in #general

Hi, the code and types files don't auto

ok thanks for clarifying

12 replies

•Created by alihammad on 2/20/2025 in #general

Hi, the code and types files don't auto

On a mac for example if left as src/xata.ts it will generate in your root folder.

12 replies

•Created by alihammad on 2/20/2025 in #general

Hi, the code and types files don't auto

the path for xata.ts might be somewhere other than the project folder.

12 replies

•Created by alihammad on 2/20/2025 in #general

Hi, the code and types files don't auto

So to clarify are you missing the src/xata.ts file when you run xata init ? I just tested there and everything seems to generate without issue.

12 replies

•Created by alihammad on 2/20/2025 in #general

Hi, the code and types files don't auto

That worked, thanks

12 replies

•Created by alihammad on 2/20/2025 in #general

Hi, the code and types files don't auto

Hi Ali, I see you enabled support access there. The invite seems to have expired though. Would you mind switching support access on so I can test with your workspace? If it's already on please switch it off and on again. Thanks for bearing with me

12 replies

•Created by alihammad on 2/20/2025 in #general

Hi, the code and types files don't auto

Hey alihammad, let me test this and see what's going on. 👍 let me know if you have any observations or questions in the meantime.

12 replies

•Created by azad on 2/19/2025 in #help

Pgroll support for creating index on huge table with frequent reads & writes

https://pgroll.com/docs/latest/getting-started

4 replies

•Created by azad on 2/19/2025 in #help

Pgroll support for creating index on huge table with frequent reads & writes

This should be a valid use case for pgroll which supports index creation without downtime or locks. Similarly, the tool works by creating views on tables, not by copying tables and using triggers (as some other tools do). This means you should be able to avoid memory issues as well. https://pgroll.com/docs/latest/operations/create_index

4 replies

•Created by azad on 2/19/2025 in #help

Pgroll support for creating index on huge table with frequent reads & writes

Hi Azad, thanks for reaching out, I saw your post in the community there. Let me take a look 👍

4 replies

•Created by michaeltintiuc on 2/16/2025 in #help

Identity table sequence name is ignored

Hi thanks for bringing this to our attention. I'll see if I can recreate and I'll raise the issue with our team. 👍

3 replies

•Created by mrcentigrade on 2/12/2025 in #help

@auth/xata-adapter issue.

That's great to hear, glad you were able to find a fix. Xata does not allow contributions at the moment but I will bring this to the team's attention and see if they can make a similar fix. Thanks again!

4 replies