Re: uh-oh - Mailing list pgsql-novice

From Tom Lane
Subject Re: uh-oh
Date
Msg-id 9270.1150120492@sss.pgh.pa.us
Whole thread Raw
In response to Re: uh-oh  (Tom Allison <tallison@tacocat.net>)
List pgsql-novice
Tom Allison <tallison@tacocat.net> writes:
> I'll get back to it later.  I've had to learn how to dump/restore really quick
> because somewhere the indexes were built with some "illegal" names and I
> couldn't drop them.  The names where "public.email_address" instead of
> "email_address" for a table in the public schema.  pgaccess is not my friend
> anymore.

Think you need to learn the rules for double-quoted identifiers:
http://www.postgresql.org/docs/8.1/static/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS

            regards, tom lane

pgsql-novice by date:

Previous
From: Verena Ruff
Date:
Subject: Transactions and unique constraint
Next
From: Verena Ruff
Date:
Subject: Re: Transactions and unique constraint