Re: ERROR for '@' for function
| От | Sachin Srivastava |
|---|---|
| Тема | Re: ERROR for '@' for function |
| Дата | |
| Msg-id | CAFzqEhKNq+N3K8X+6TRWpwuA8T9-qwOcyYnUcuYwE53+MO_7NA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: ERROR for '@' for function (Thomas Kellerer <spam_eater@gmx.net>) |
| Список | pgsql-general |
Thanks Thomas !!!
Now, it's working fine.
On Wed, Jan 20, 2016 at 5:18 PM, Thomas Kellerer <spam_eater@gmx.net> wrote:
Sachin Srivastava schrieb am 20.01.2016 um 12:42:
> How to handle this below situation, I am getting error for function, my Postgres version is 9.4
> is
>
> ERROR: syntax error at or near "@"
> LINE 67: AUTONUMBERSETTING@REPOS.BIRCHSTREET.NET <mailto:AUTONUMBERSETTING@REPOS.BIRCHSTREET.NET>
> ^
> ********** Error **********
> ERROR: syntax error at or near "@"
> SQL state: 42601
> Character: 3274
>
Well, AUTONUMBERSETTING@REPOS.BIRCHSTREET.NET is an invalid identifier.
A "@" is not allowed as part of a table name.
You need to enclose that in double quotes:
SELECT ...
FROM "AUTONUMBERSETTING@REPOS.BIRCHSTREET.NET"
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
В списке pgsql-general по дате отправления: