Обсуждение: BUG #13855: After pg_dump, pg_restore complains that some data is too long

The following bug has been logged on the website:

Bug reference:      13855
Logged by:          Alex PB
Email address:      chozabu@gmail.com
PostgreSQL version: 9.3.0
Operating system:   Kubuntu 15.10
Description:

Using django to create DB, it looks like when data is entered into DB, the
String length is checked (unicode) but db_restore checks the byte length

On Fri, Jan 8, 2016 at 4:27 AM,  <chozabu@gmail.com> wrote:

> Using django to create DB, it looks like when data is entered
> into DB, the String length is checked (unicode) but db_restore
> checks the byte length

There is nothing in PostgreSQL called db_restore.   If you meant
the pg_restore utility, you need to provide more detail, like
copy/paste of the command line used and the result.  If you meant
something else, you are probably reporting the problem to the wrong
place.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Right - I jumped the gun on this one - seems I was creating the DB *not* as
utf-8 - but setting my client to UTF-8, but after dropping and re-creating
I was asking for UTF-8.
Furthermore - my test system had its lang/locales misconfigured!

So, no bug here, just an inexperienced user being silly! (sorry!)

-Alex "Chozabu <http://chozabu.net/blog>" P-B

On Mon, Jan 11, 2016 at 4:42 PM, Kevin Grittner <kgrittn@gmail.com> wrote:

> On Fri, Jan 8, 2016 at 4:27 AM,  <chozabu@gmail.com> wrote:
>
> > Using django to create DB, it looks like when data is entered
> > into DB, the String length is checked (unicode) but db_restore
> > checks the byte length
>
> There is nothing in PostgreSQL called db_restore.   If you meant
> the pg_restore utility, you need to provide more detail, like
> copy/paste of the command line used and the result.  If you meant
> something else, you are probably reporting the problem to the wrong
> place.
>
> --
> Kevin Grittner
> EDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>