Re: [HACKERS] another error perhaps to be enhanced

2013-06-14 Thread Joshua D. Drake
On 06/14/2013 11:01 AM, Peter Geoghegan wrote: On Fri, Jun 14, 2013 at 10:54 AM, Joshua D. Drake wrote: Now, with the error previously shown, which one_idx needs to be reindexed? Well, you didn't show an actual error message. ERROR: index "foo_idx" Is not an error message? Granted I d

Re: [HACKERS] another error perhaps to be enhanced

2013-06-14 Thread Peter Geoghegan
On Fri, Jun 14, 2013 at 10:54 AM, Joshua D. Drake wrote: > Now, with the error previously shown, which one_idx needs to be reindexed? Well, you didn't show an actual error message. But if you "\set VERBOSITY verbose" within psql while connected to a 9.3 server, you'll get fully qualified details

Re: [HACKERS] another error perhaps to be enhanced

2013-06-14 Thread Joshua D. Drake
On 06/14/2013 10:47 AM, Peter Geoghegan wrote: I think you'll need to better describe what you mean here. postgres=# create schema foo; CREATE SCHEMA postgres=# create schema bar; CREATE SCHEMA postgres=# create table foo.foo(id serial); NOTICE: CREATE TABLE will create implicit sequence "f

Re: [HACKERS] another error perhaps to be enhanced

2013-06-14 Thread Peter Geoghegan
I think you'll need to better describe what you mean here. -- Peter Geoghegan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] another error perhaps to be enhanced

2013-06-14 Thread Michael Glaesemann
On Jun 14, 2013, at 13:38, "Joshua D. Drake" wrote: > > ERROR: index "foo_idx" > > We should probably add the schema. I've noticed similar issues with functions. I'd like to see those schema-qualified as well. > > JD > -- > Command Prompt, Inc. - http://www.commandprompt.com/ 509-416-

[HACKERS] another error perhaps to be enhanced

2013-06-14 Thread Joshua D. Drake
ERROR: index "foo_idx" We should probably add the schema. JD -- Command Prompt, Inc. - http://www.commandprompt.com/ 509-416-6579 PostgreSQL Support, Training, Professional Services and Development High Availability, Oracle Conversion, Postgres-XC, @cmdpromptinc For my dreams of your image th