Re: pg_dump/restore syntax checking bug?

On 03/22/2013 10:13 PM, Josh Kupershmidt wrote:
>
> On Fri, Mar 22, 2013 at 9:35 PM, Joshua D. Drake <jd(at)commandprompt(dot)com> wrote:
>
>> postgres(at)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
>
>