| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Tom Allison <tallison(at)tacocat(dot)net> |
| Cc: | Philip Hallstrom <postgresql(at)philip(dot)pjkh(dot)com>, pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: uh-oh |
| Date: | 2006-06-12 13:54:52 |
| Message-ID: | 9270.1150120492@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Tom Allison <tallison(at)tacocat(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Verena Ruff | 2006-06-12 14:28:31 | Re: Transactions and unique constraint |
| Previous Message | Verena Ruff | 2006-06-12 13:04:46 | Transactions and unique constraint |