postgrest-docs icon indicating copy to clipboard operation
postgrest-docs copied to clipboard

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

Open drmnk opened this issue 2 years ago • 1 comments

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 avatar May 15 '22 18:05 drmnk

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

drmnk avatar May 16 '22 07:05 drmnk

Duplicate of https://github.com/PostgREST/postgrest-docs/issues/471

wolfgangwalther avatar Feb 18 '24 13:02 wolfgangwalther