From: | Andreas Seltenreich <seltenreich(at)gmx(dot)de> |
---|---|
To: | Vinicius Segalin <vinisegalin(at)gmail(dot)com> |
Cc: | Julien Rouhaud <julien(dot)rouhaud(at)dalibo(dot)com>, pgsql general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Query generator |
Date: | 2016-10-16 10:54:49 |
Message-ID: | 87lgxoy35y.fsf@credativ.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Vinicius Segalin <vinisegalin(at)gmail(dot)com> writes:
> 2016-09-29 16:32 GMT-03:00 Julien Rouhaud <julien(dot)rouhaud(at)dalibo(dot)com>:
>
> > You should try sqlsmith (https://github.com/anse1/sqlsmith) which works
> > very well.
>
> I had found this one before, but all I could get was queries using
> "standard" tables, like the ones from pg_catalog and
> information_schema. It didn't generate queries from the tables I've
> created. Was I doing something wrong?
It should pick your relations with the same likelihood it picks the
catalog tables. You could verify this for with, e.g.,
sqlsmith --dry-run | grep your_table_name
Thanks to Julien, sqlsmith's master branch now has an option
--exclude-catalog that inhibits use of catalog relations. If you are
building from github, you might want to give it another chance with this
option. I'll probably do a proper release in next two weeks.
Feedback welcome :-)
regards,
Andreas
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2016-10-16 13:49:46 | Re: could not connect to server |
Previous Message | Yvonne Murphy | 2016-10-16 10:32:19 | Re: postgres MultiXact 9.3 corruption resolved but advice needed |