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