Skip to content
This repository has been archived by the owner on Feb 24, 2024. It is now read-only.

Renaming columns not working when new name is longer than 63 bytes (postgres column name length) #535

Closed
drmnk opened this issue May 15, 2022 · 2 comments

Comments

@drmnk
Copy link

drmnk commented May 15, 2022

Hello!
I found strange behavior:

I name my tables and columns in non-ASCII symbols (and it works, very convenient, "trust me, I am an engineer")
And sometimes length of column is more than 63 bytes - for example, "УчитыватьИсправлениеИсходногоДокумента" (cyrillic).
In database it stores as "УчитыватьИсправлениеИсходногоДо"

and when I request for table that stores it column, it will come out from the Postgrest as:

"УчитыватьИсправлениеИсходногоДо": "blablal...."

Ok, I'm trying to rename the column at query with ":":
...select=УчитыватьИсправлениеИсходногоДокумента:УчитыватьИсправлениеИсходногоДо

But it didn't work, in the output it stills goes as 'УчитыватьИсправлениеИсходногоДо'.

What can be a source of problem?

@drmnk
Copy link
Author

drmnk commented May 16, 2022

Sorry, wrong repo, will copy to the source repo with SQL example and delete this later

@wolfgangwalther
Copy link
Member

Duplicate of #471

@wolfgangwalther wolfgangwalther marked this as a duplicate of #471 Feb 18, 2024
@wolfgangwalther wolfgangwalther closed this as not planned Won't fix, can't repro, duplicate, stale Feb 18, 2024
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Development

No branches or pull requests

2 participants