Hello,
the Beta2 downloads on
http://www.enterprisedb.com/products-services-training/pgdownload
http://www.enterprisedb.com/products-services-training/pgbindownload
still lead to Beta1 for the Windows 64bit builds.
All others properly link to beta1
Thomas
--
Sent via pgsql-general
Hello,
We happen to have in our schema the following domain.
CREATE DOMAIN public.name varchar(50) NOT NULL;
This was done before me. We assumed this was used in many tables in our
app. Then I wrote a function with a return clause like the following:
RETURNS (
id INT,
name name,
other_names
On Fri, 24 Jun 2016, 6:23 a.m. Jeff Janes, wrote:
> On Thu, Jun 23, 2016 at 10:54 AM, Sameer Kumar
> wrote:
> >
> >
> > On Fri, 24 Jun 2016, 1:47 a.m. Jeff Janes, wrote:
> >>
> >> On Thu, Jun 23, 2016 at 8:14 AM, Sameer Kumar
On Fri, Jun 24, 2016 at 4:13 AM, Dusan Milanov wrote:
> Hi,
>
> A question about transactions: does postgres report serialization errors
> before a transaction is committed? Obviously, it does on commit, but how
> about previous statements? Can there be an
On Thu, Jun 23, 2016 at 10:54 AM, Sameer Kumar wrote:
>
>
> On Fri, 24 Jun 2016, 1:47 a.m. Jeff Janes, wrote:
>>
>> On Thu, Jun 23, 2016 at 8:14 AM, Sameer Kumar
>> wrote:
>> >
>> > Hi,
>> >
>> > I just wanted to understand
Hi,
A question about transactions: does postgres report serialization errors
before a transaction is committed? Obviously, it does on commit, but how
about previous statements? Can there be an
ERRCODE_T_R_SERIALIZATION_FAILURE error as a response to anything else but
the commit?
Best regards,
On Fri, 24 Jun 2016, 1:54 a.m. Sameer Kumar,
wrote:
>
>
> On Fri, 24 Jun 2016, 1:47 a.m. Jeff Janes, wrote:
>
>> On Thu, Jun 23, 2016 at 8:14 AM, Sameer Kumar
>> wrote:
>> >
>> > Hi,
>> >
>> > I just wanted to understand
On Fri, 24 Jun 2016, 1:47 a.m. Jeff Janes, wrote:
> On Thu, Jun 23, 2016 at 8:14 AM, Sameer Kumar
> wrote:
> >
> > Hi,
> >
> > I just wanted to understand what are the commands which will acquire
> Access
> > Exclusive Lock on a table? In my
On Thu, Jun 23, 2016 at 8:14 AM, Sameer Kumar wrote:
>
> Hi,
>
> I just wanted to understand what are the commands which will acquire Access
> Exclusive Lock on a table? In my knowledge below operations will acquire
> access exclusive lock:-
>
> 1. VACUUM FULL
> 2. ALTER
On Thu, Jun 23, 2016 at 11:57 PM Adrian Klaver
wrote:
> On 06/23/2016 08:14 AM, Sameer Kumar wrote:
> >
> > Hi,
> >
> > I just wanted to understand what are the commands which will acquire
> > Access Exclusive Lock on a table? In my knowledge below operations will
> >
On 06/23/2016 08:14 AM, Sameer Kumar wrote:
Hi,
I just wanted to understand what are the commands which will acquire
Access Exclusive Lock on a table? In my knowledge below operations will
acquire access exclusive lock:-
1. VACUUM FULL
2. ALTER TABLE
3. DROP TABLE
4. TRUNCATE
5. REINDEX
6.
Hi,
I just wanted to understand what are the commands which will acquire Access
Exclusive Lock on a table? In my knowledge below operations will acquire
access exclusive lock:-
1. VACUUM FULL
2. ALTER TABLE
3. DROP TABLE
4. TRUNCATE
5. REINDEX
6. LOCK command with Access Exclusive Mode (or no
Jason Dusek writes:
> I notice that INFO is not included in the list of settable levels for
> client_min_messages:
> This seems to be true several versions back so I wonder: what is the
> rationale? Is it like the reverse of LOG?
INFO is used for cases where the user
Thank u.
The problem is because of the commented line. I forgot about that.
Now, I uncommented it. It working fine.
Thank u very much.
-Sudalai
-
sudalai
--
View this message in context:
On Thu, Jun 23, 2016 at 4:55 PM, sudalai wrote:
> Thanks for : https://github.com/michaelpq/pg_plugins/tree/master/decoder_raw
> I will upgrade my servers to PostgreSQL 9.5.3, but i want to find the
> problem.
> Please help me.
> I don't have SQL sequence.
> Does anything i
Thanks for : https://github.com/michaelpq/pg_plugins/tree/master/decoder_raw
I will upgrade my servers to PostgreSQL 9.5.3, but i want to find the
problem.
Please help me.
I don't have SQL sequence.
Does anything i can get from server, that will help us to debug the problem?
Here is
Hi john,
PostgreSQL 9.5.0 has bug !!!, Does 9.5.0 remove unconsumed toast rows
need for slot??
It is fixed in latest!!!.
-Sudalai
-
sudalai
--
View this message in context:
On Thu, Jun 23, 2016 at 3:38 PM, sudalai wrote:
>
> I am using PostgresSQL 9.5.0.
> I have customized :
> https://github.com/michaelpq/pg_plugins/tree/master/decoder_raw to get
> result as json. It works fine. suddenly i getting below exception while
> consuming or peeking
On 6/22/2016 11:38 PM, sudalai wrote:
I am using PostgresSQL 9.5.0.
while this likely has no bearing on your problem, you really should
upgrade to 9.5.latest, 9.5.3 is out now.sub version upgrades like
9.5.0 to 9.5.3 are painless, just upgrade and restart the server with
the new code.
Hi List,
I notice that INFO is not included in the list of settable levels for
client_min_messages:
https://www.postgresql.org/docs/9.5/static/runtime-config-logging.html#GUC-CLIENT-MIN-MESSAGES
This seems to be true several versions back so I wonder: what is the
rationale? Is it like the
I am using PostgresSQL 9.5.0.
I have customized :
https://github.com/michaelpq/pg_plugins/tree/master/decoder_raw to get
result as json. It works fine. suddenly i getting below exception while
consuming or peeking changes through that logical slot.
Does postgres removed the rows needed for
21 matches
Mail list logo