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: | Raw Message | Whole Thread | 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 |