well,
the for your reply,
we have PG on linux ubuntu 14.04 distribution, but pls remember
this issue started when our DB size increase to 3-5GB, now it is
16GB.
this happend only when we use "CREATE OR REPLACE"
since I can run a query and get reply
On 06/17/2016 09:01 AM, Catalin Maftei wrote:
Please do not top post:
https://en.wikipedia.org/wiki/Posting_style
well,
the for your reply,
we have PG on linux ubuntu 14.04 distribution, but pls remember this
issue started when our DB size increase to 3-5GB, now it is 16GB.
See Merlins
On Fri, Jun 17, 2016 at 12:01 PM, Catalin Maftei
wrote:
> well,
>
> the for your reply,
>
> we have PG on linux ubuntu 14.04 distribution, but pls remember this issue
> started when our DB size increase to 3-5GB, now it is 16GB.
>
> this happend only when we use "*CREATE
On Thu, Jun 16, 2016 at 6:55 PM, Melvin Davidson wrote:
You have not provided information as to the O/S of the PostgreSQL
server or your PgAdmin remote system (I suspect Windows), but
regardless, you
> are just asking for trouble by doing development over a remote
On Tue, Jun 14, 2016 at 4:59 PM, Catalin Maftei wrote:
> when I recreate a VIEW or FUNCTION with a small change I get:
>
> Query returned successfully with no result in 03:58 minutes.
This is almost certainly due to locks. Next time this happens, query
pg_stat_activity
On Wed, Jun 15, 2016 at 12:49 AM, Catalin Maftei
wrote:
> 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,
>
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
On Wed, Jun 15, 2016 at 12: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?
On 06/14/2016 09:49 PM, Catalin Maftei wrote:
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
,
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
when I recreate a VIEW or
FUNCTION with a small change I get:
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
11 matches
Mail list logo