Re: pg_dump/restore syntax checking bug?

Joshua D. Drake <jd@commandprompt.com>

From: "Joshua D. Drake" <jd@commandprompt.com>
To: Josh Kupershmidt <schmiddy@gmail.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2013-03-23T13:57:17Z
Lists: pgsql-hackers
On 03/22/2013 10:13 PM, Josh Kupershmidt wrote:
>
> On Fri, Mar 22, 2013 at 9:35 PM, Joshua D. Drake <jd@commandprompt.com> wrote:
>
>> postgres@jd-laptop:~$ pg_restore -d test -P 'by(),hello()' foo.sqlc
>
> Note, the pg_restore doc makes no mention of trying to squeeze
> multiple function prototypes in a single argument you've done here, or
> of using multiple -P flags.
>
>> It appears we need better syntax checking.
>
> Can't really argue with this. But if you think these pg_restore
> examples are bad, try this gem:
>    reindexdb --table='foo; ALTER ROLE limited WITH superuser'

That is HORRIBLE! Looks like our base utilities need some attention.

jD

>
> Josh
>
>