hei Adrian,
thx for your reply,
this is an example:
"CREATE OR REPLACE VIEW feedback.get_answers_set AS
SELECT f.awb || '/' || r.dulapid as "awb",
q.qid,
q.question,
a.aid,
a.answer,
q.questionareid,
f.stamp_created
, c.first_name
, l.referinta_expeditor
FROM feedback.answers a
JOIN feedback.questions q ON a.qid = q.qid
JOIN feedback.feedback f ON f.qid = q.qid AND f.aid = a.aid
join public.livrari_details ld on ld.awb=f.awb
join public.livrari l on l.livrareid = ld.livrareid
join public.customers c on l.shipto_custkey = c.custkey
join dulap.rezervare r on r.rezid = l.rezervareid;
ALTER TABLE feedback.get_answers_set
OWNER TO postgres;"
I use PGADMIN 1.22.1
my server is remote and is replicated Master-Slave.
my team report this random delay all the time when we recreate VIEWS and
FUNCTIONS.
Best regards,
Catalin Maftei
www.plationline.eu
www.livrarionline.ro
www.c-solution.biz
Skype: catalinmaftei
Mobile: +40723 338 598
On 6/15/2016 7:36 AM, Adrian Klaver wrote:
On 06/14/2016 02:59 PM, Catalin Maftei wrote:
when I recreate a VIEW or FUNCTION with a small change I get:
What are the actual statements you are running?
What program are you running them from?
Is the server you are running the command against local or remote?
Query returned successfully with no result in 03:58 minutes.
we have pg 9.4
--
Best regards,
Catalin Maftei
www.plationline.eu
www.livrarionline.ro
www.c-solution.biz
Skype: catalinmaftei
Mobile: +40723 338 598
begin:vcard
fn:Catalin Maftei
n:Maftei;Catalin
email;internet:catalin@xxxxxxxxxxxxxx
tel;cell:+40723338598
version:2.1
end:vcard
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
