[GENERAL] Re: [GENERAL] Forcefully adding a CHECK constrained

Hello. Now I understand why I was not clear. From what I understood, NOT VALID feature will not allow for the CHECK to be used in queries. So, for partitioning, my goal, is critical that the CHECK condition to be used. I hope I make myself clear now: I want a possibility to add a CHECK that wi

Re: [GENERAL] Attempting to do a rolling move to 9.2Beta (as a slave) fails

On 5/27/2012 11:08 PM, Jan Nielsen wrote: > Hi Karl, > > On Sun, May 27, 2012 at 9:18 PM, Karl Denninger > wrote: > > Here's what I'm trying to do in testing 9.2Beta1. > > The current configuration is a master and a hot standby at a > diverse location for bot

Re: [GENERAL] Attempting to do a rolling move to 9.2Beta (as a slave) fails

Hi Karl, On Sun, May 27, 2012 at 9:18 PM, Karl Denninger wrote: > Here's what I'm trying to do in testing 9.2Beta1. > > The current configuration is a master and a hot standby at a diverse > location for both hot swap and "online" backup. Both are archived > regularly so if something goes sout

[GENERAL] Attempting to do a rolling move to 9.2Beta (as a slave) fails

Here's what I'm trying to do in testing 9.2Beta1. The current configuration is a master and a hot standby at a diverse location for both hot swap and "online" backup. Both are archived regularly so if something goes south I can recover (to either as a master.) I am attempting to validate the pat

[GENERAL] Re: [GENERAL] Forcefully adding a CHECK constrained

Hello. Thanks for the answer. I really want to avoid reading the whole table. It is too expensive, and with the proposed feature will be not needed. I think is much faster to forcefully add the check if you know the range of data. What do you think? -- Catalin(ux) M. BOIE http://kernel.embedr

Re: [GENERAL] PG vs MSSQL language comparison ?

On Sat, May 26, 2012 at 7:04 AM, Andreas wrote: > I'd like to find ressources to look up how one can do X in MSSQL when one > knows how it is done in PG's SQL and the other way around. Here's another resource, going into more detail: http://troels.arvin.dk/db/rdbms/ Regards, Marti -- Sent via

Re: [GENERAL] Forcefully adding a CHECK constrained

On Sat, 2012-05-26 at 22:06 +0300, Catalin(ux) M. Boie wrote: > Hello. > Thanks for the answer. > > I really want to avoid reading the whole table. It is too expensive, > and with the proposed feature will be not needed. I think is much > faster to forcefully add the check if you know the range o

Re: [GENERAL] PG vs MSSQL language comparison ?

Le 26/05/2012 06:36, Grant Allen a écrit : On 26/05/2012 00:04, Andreas wrote: Hi, I'm not into comparing which DBMS is better as we all know ... kind of ... well ... I'd like to find ressources to look up how one can do X in MSSQL when one knows how it is done in PG's SQL and the other way