ver.x86_64 9.2.13-1
PGDG.rhel6 @/postgresql92-server-9.2.
13-1PGDG.rhel6.x86_64
Regards
Marek
-- Původní zpráva --
Od: Tom Lane
Komu: Marek Petr
Datum: 27. 9. 2016 14:55:44
Předmět: Re: [GENERAL] lost synchroniz
Hello,
>From time to time we receive following event from application (Adobe
Campaign - former Neolane):
PostgreSQL error: lost synchronization with server: got message type "Z",
length 0\n (iRc=-2006)
Last time underlying sql statement was an update.
At the backend side there is
Sorry.
I have re-read my previous message.
It looks unclean.
For sequential calls in same transaction `now()` and `current_timestamp`
will produce the same output.
```
begin; -- start a transaction
select
now() immutable_now,
current_timestamp immutable_current_ts,
clock_timestamp() mutabl
2016-04-12 13:50 GMT+03:00 Alex Ignatov :
> Hello!
> Is there any method to freeze localtimestamp and other time function value.
> Say after freezing on some value sequential calls to these functions give
> you the same value over and over again.
> This is useful primarily for testing.
>
Hello!
>
> This doesn't work because it can't cast JSONB to 'bytea'. I tried casting
> to 'text', still no luck. Could anyone please help me?
>
You can use check-constraint like this:
# create table t (
jb jsonb
);
# alter table t add constraint jb_length_check CHECK (length(jb::text) <
16); -- 16 i
Hi Tomasi,
sorry for replying so late, but I haven't noticed your email..
>On 16.2.2015 11:44, Novák, Petr wrote:
>> Hello,
>>
>> sorry for posting to second list, but as I've received no reply
>> there, I'm trying my luck here.
>>
>>
postgres
instances (clusters) all running under a single postgres user on different
ports on the same machine?
> But then what is the best way to handle connecting to an individual
cluster (local only for admin purposes) with psql? Doesn't look like I
could go by the cluster nam
Hi Adrian,
On Wed, Feb 18, 2015 at 10:25 PM, Adrian Klaver
wrote:
> On 02/16/2015 02:44 AM, Novák, Petr wrote:
>>
>> Hello,
>>
>> sorry for posting to second list, but as I've received no reply
>> there, I'm trying my luck here.
>>
>&g
Hi Dinesh
On Wed, Feb 18, 2015 at 11:01 PM, dinesh kumar wrote:
> Hi,
>
> On Mon, Feb 16, 2015 at 2:44 AM, Novák, Petr wrote:
>>
>> Hello,
>>
>> sorry for posting to second list, but as I've received no reply
>> there, I'm trying my luck here.
&
Hello,
sorry for posting to second list, but as I've received no reply
there, I'm trying my luck here.
Thanks
Petr
-- Forwarded message --
From: Novák, Petr
Date: Tue, Feb 10, 2015 at 12:49 PM
Subject: Data corruption after restarting replica
To: pgsql-b...@post
would be still
missing..
P
On Jan 23, 2015 5:42 PM, "Adrian Klaver" wrote:
> On 01/23/2015 08:36 AM, Petr Novak wrote:
>
>> Just the config files for the replica, all other dirs were removed.
>>
>
> Alright, lets look at the other end. You are using -x which is
Just the config files for the replica, all other dirs were removed.
P
On Jan 23, 2015 5:30 PM, "Adrian Klaver" wrote:
> On 01/23/2015 08:21 AM, Petr Novak wrote:
>
>> Hi Adrian,
>>
>> sure the command is as follows:
>>
>> pg_basebackup -h -p -D /
f the same HW config and the prerequisites are on
all servers set by puppet.
P
2015-01-23 16:57 GMT+01:00 Adrian Klaver :
> On 01/23/2015 06:31 AM, Petr Novak wrote:
>
>> Hi all,
>>
>> I'd like to ask for help clarifying an issue I'm having.
>>
>> I
tion safe for the database (I suppose so, but I'd rather
have it confirmed :) )
I'm puzzled as I haven't found this issue discussed at all so far and it
happened to me three times in one day on three different servers..
Thanks for any help.
Cheers.
Petr
n Postgres.
Moreover I can't know the check interval of the listening procedures in
an external application (can be anything from millis to days). I was so
desperate that I was thinking about own logging function.
Many thanks, Petr
--
Sent via pgsql-general mailing list (pgsql-general@postgres
Hi allI'am facing strang problem while using pgAdmin III to browse DB running on the same machine (localhost) - it is very very slow. Coonect is quite quict, but listing all schemas takes tens of seconds, listing tables in schema takes other tens of seconds, refresing table details takes other seoc
t on customer's machine,
then i have many errors, because any views are not in his database, and
script trying to drop it. When i'm set to don't make drop functions (in
export), then i have other errors, with existing views (view allready
exists).
Petr
--
Hi.
Is any way how to detach complete database, and attach it into other Postgre
server (like MSSQL, Interbase etc. databases movability) ?
Moving database via SQL export is crazy way for me (and for my customers).
Thanks and forgive me for my poor english.
Petr
I have found that when I use the RETURN NEXT command in recursive function,
not all records are returned. The only records I can obtain from function
are records from the highest level of recursion. Does exist some
work-around?
Thanks
Petr Bravenec
example:
create table foo (
uid int4
when
traversing across different tables connected by id. The DS and SELECTing
just gets too complex to handle. And too inefficient, maybe. Does
somebody have any experience with this? I'm thinking of it for too long
now and i'm getting a little desperate.
Thank You,
Petr.
**
Database, function definition and triger creating along README and fti.c.
~sourcetree/contrib/fulltextindex/
***
equal problem with using linux working correctly.
Please help mee.
Sorry my language
Ing. Petr Vanicek
__
21 matches
Mail list logo
