| From: | Sachin Srivastava <ssr(dot)teleatlas(at)gmail(dot)com> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org> |
| Subject: | ERROR for '@' for function |
| Date: | 2016-01-20 11:42:35 |
| Message-ID: | CAFzqEhKHxLnSYuGjk-q9mqN0kqBE_MUtpM2z8W8m=8=4SnH0Hg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)REPOS(dot)BIRCHSTREET(dot)NET
^
********** Error **********
ERROR: syntax error at or near "@"
SQL state: 42601
Character: 3274
------------------------
BEGIN
select NEXT_NUMBER into STRICT id from
AUTONUMBERSETTING(at)REPOS(dot)BIRCHSTREET(dot)NET
--pbeach_repos8.AUTONUMBERSETTING
where subscriber_id=subscriber and AUTO_NUMBER_ID=348 and company_id=
buyer;
exception
when no_data_found then
insert into
smerror_log(error_log_id,subscriber_id,company_id,error_message,system_message,
method_name,creation_date,creation_user,update_date,update_user)
values (nextval('smerror_log_sequence'),subscriber,buyer,'Auto Number
not found',null,
'PunchoutProfile' ,LOCALTIMESTAMP,'Admin',LOCALTIMESTAMP,'Admin');
commit;
return;
end;
-------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Kellerer | 2016-01-20 11:48:12 | Re: ERROR for '@' for function |
| Previous Message | Steve Rogerson | 2016-01-20 11:10:53 | Postgres and timezones |