Re: [BUGS] BUG #6712: PostgreSQL 9.2 beta2: alter table drop constraint does not work on inherited master table

2012-07-20 Thread Alvaro Herrera
Excerpts from Amit Kapila's message of jue jul 19 22:57:04 -0400 2012: > From: Noah Misch [mailto:n...@leadboat.com] > Sent: Thursday, July 19, 2012 5:23 PM > On Tue, Jul 17, 2012 at 08:59:50AM +, Amit kapila wrote: > >> Patch is attached with this mail. > > > Thanks. This patch is ready fo

[BUGS] Sequence id NOT incremented as expected

2012-07-20 Thread SINGHAL Harsh
FACTS : 1. Sequences are based on bigint arithmetic, so the range cannot exceed the range of an eight-byte integer (-9223372036854775808 to 9223372036854775807). On some older platforms, there may be no compiler support for eight-byte integers, in which case sequences use regular inte

Re: [BUGS] Sequence id NOT incremented as expected

2012-07-20 Thread Tom Lane
SINGHAL Harsh writes: > * In an increasing sequence whose max value is set to > 9223372036854775807 and cycle option is activated, as shown above, > from 2147483647 to 9223372036854775807 it is displaying error > "ERREUR: entier en dehors des limites" and after that it resets it >

Re: [BUGS] Re: BUG #6712: PostgreSQL 9.2 beta2: alter table drop constraint does not work on inherited master table

2012-07-20 Thread Alvaro Herrera
Excerpts from Noah Misch's message of lun jul 16 11:12:01 -0400 2012: > As a side question for the list, should we fix this differently in 9.2 to > avoid forcing an initdb for the next beta? Perhaps have > ATExecDropConstraint() only respect connoinherit for CONSTRAINT_CHECK? My answer here was

Re: [BUGS] Sequence id NOT incremented as expected

2012-07-20 Thread SINGHAL Harsh
Thanks a lot, Tom. -- Harsh Raj SINGHAL Cy-Play On 20/07/12 16:08, Tom Lane wrote: SINGHAL Harsh writes: * In an increasing sequence whose max value is set to 9223372036854775807 and cycle option is activated, as shown above, from 2147483647 to 9223372036854775807 it is displayin

[BUGS] BUG #6745: feature request

2012-07-20 Thread blastofftopluto
The following bug has been logged on the website: Bug reference: 6745 Logged by: ram Email address: blastofftopl...@gmail.com PostgreSQL version: 9.1.4 Operating system: linux mint maya Description: Please add built in feature in postgresql for setting size of individ

[BUGS] BUG #6746: feature request

2012-07-20 Thread blastofftopluto
The following bug has been logged on the website: Bug reference: 6746 Logged by: ram Email address: blastofftopl...@gmail.com PostgreSQL version: 9.1.4 Operating system: linux mint maya Description: Please add built in feature in postgresql for setting size of individ

Re: [BUGS] BUG #6745: feature request

2012-07-20 Thread Pavel Stehule
Hello 2012/7/20 : > The following bug has been logged on the website: > > Bug reference: 6745 > Logged by: ram > Email address: blastofftopl...@gmail.com > PostgreSQL version: 9.1.4 > Operating system: linux mint maya > Description: > > Please add built in feature in postgres