Truncate a table?

Support
1

I’m getting a “permission denied” error when I try to truncate a table. Is truncating a table supported? Or do I need to just delete from TABLE?

Thanks

2

Did you try removing the table using the SQL Editor UI in https://console.neon.tech, or did you use use a standard psql connection using a client application?

Both session types (currently) use different user roles, and creating tables with either means the table will have a different owner than the other session’s, limiting their access to that table.

So, switching the connection method might allow you to truncate the table without issue.

1 Like
3

Ah good catch. I created in the console and then was using a psql client.