Hi,
From time to time people ask me if there is a way to "customize"
messages for constraints so they could be more informative to the
user...
Imagine something like:
create table foo (fld int4 check (fld > 0));
message for constraint foo_fld_check on foo is 'fld field must contain
possitive num
Josh Berkus writes:
>> It's also worth mentioning that for datatypes that only have an "="
>> operator the performance of compute_minimal_stats is O(N^2) when values
>> are unique, so increasing sample size is a very bad idea in that case.
> Hmmm ... does ANALYZE check for UNIQUE constraints?
Ou
Simon,
> It's also worth mentioning that for datatypes that only have an "="
> operator the performance of compute_minimal_stats is O(N^2) when values
> are unique, so increasing sample size is a very bad idea in that case.
> It may be possible to re-sample the sample, so that we get only one row
You should look at something like the LOCK table command. The following areas will help:src/backend/tcop/utility.csrc/backend/commands/lockcmds.csrc/backend/nodes/*funcs.csrc/backend/parser-Jonah
On 1/13/06, Gevik babakhani <[EMAIL PROTECTED]> wrote:
Folks,
I would like to underst
Folks,
I would like to understand how the ‘simple’
backend commands work.
After reading the “How PostgreSQL
Processes a Query”, I was wondering
Which command would be the easiest to begin with? (For a newbie of
course.)
Regards,
Gevik.
Hi Josh,
On Jan 13, 2006, at 2:34 PM, Josh Berkus wrote:
I can't see a way to do this except individually, in which case the
superuser might as well load the functions. We *have* to be
restrictive
about this because a C function can do anything, including overwriting
whatever parts of the
John,
> Would it be reasonable for there to be a way for the super user to
> grant access to load "approved" modules and/or C language functions?
I can't see a way to do this except individually, in which case the
superuser might as well load the functions. We *have* to be restrictive
about t
On Thu, 2006-01-12 at 19:33 -0500, Tom Lane wrote:
> David Fetter <[EMAIL PROTECTED]> writes:
> > What do you think?
>
> I think it's not broken and doesn't need fixing. I have not seen any
> groundswell of demand for moving the contrib stuff out of the public
> schema. On the other hand, doing
On Fri, 2006-01-06 at 15:26 -0800, Josh Berkus wrote:
> Anyway, since the proof is in the pudding, Simon and I will be working on
> some demo code for different sampling methods so that we can debate
> results rather than theory.
I enclose a patch for checking out block sampling. This is not
pr
On Thu, Jan 12, 2006 at 05:00:49PM -0500, Qingqing Zhou wrote:
>
>
> On Thu, 12 Jan 2006, Jim C. Nasby wrote:
>
> >
> > It sounds like worrying about this would be much more interesting on a
> > machine that is seeing both a fairly heavy IO load (meaning checkpoint
> > will both take longer and
> > I'm looking at a way to "fix" the issues with admin privileges on
> > Win32
> > - specifically by finding a way to give up all admin stuff
> before the
> > server starts, when possible (and otherwise fail just as today).
> >
>
> So this will let an admin startup Postgres ... I got a
> ques
""Magnus Hagander"" <[EMAIL PROTECTED]> wrote
>
> I'm looking at a way to "fix" the issues with admin privileges on Win32
> - specifically by finding a way to give up all admin stuff before the
> server starts, when possible (and otherwise fail just as today).
>
So this will let an admin startup
""Bruno Almeida do Lago"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi,
>
> Today I was playing with our test environment and noticed that if I delete
> a
> PostgreSQL datafile (with cluster down) and bring up the database, It will
> simple... come up :-/
>
> I wonder if
Hi,
Today I was playing with our test environment and noticed that if I delete a
PostgreSQL datafile (with cluster down) and bring up the database, It will
simple... come up :-/
I wonder if it shouldn't complain about the missing datafile before opening
the cluster... I don't know... Maybe so
On Fri, Jan 13, 2006 at 10:04:10AM -0500, Tom Lane wrote:
> Martijn van Oosterhout writes:
> > Umm, yes. You also need to add the column to the contents of
> > pg_attribute, give the attribute a number, increase the number of
> > attributes as stored in pg_class, update the #define that gives the
"St Valentine" <[EMAIL PROTECTED]> writes:
> That module is writen in the C++ langguage, how can i connect it to
> the PostgreSQL sources?
Convert it to C ;-) Seriously, I think this would be a major pain in
the neck to do --- there are various gotchas like the system headers not
being C++-clean.
Martijn van Oosterhout writes:
> Umm, yes. You also need to add the column to the contents of
> pg_attribute, give the attribute a number, increase the number of
> attributes as stored in pg_class, update the #define that gives the
> attribute count, change the macro that gives the size of the
> p
NT4 is officially dead, IMHO no need for PostgreSQL to officially support it,
let's leave place for companies offering commercial postgresql versions to
work on it if they have enough customer requests.
BTW Win 2000 is more or less 6 years old now ...
Regards
Paolo
"Magnus Hagander" <[EMAIL PROTE
Hi!
I'm looking at a way to "fix" the issues with admin privileges on Win32
- specifically by finding a way to give up all admin stuff before the
server starts, when possible (and otherwise fail just as today).
I think I can do this. However, it is not possible to do this in a way
that's compatib
Help me, please,
i have a module, which converts the WHERE clause to a canonical form, i.e.
converting a logical clause to a conjuntional or dicjuntional clauses. For
example:
(ves > 100 or = 10) AND ( = aaa + 1 OR ( AND caa))
will be converted to dicjuntional form:
ves>100 AND bb
On Fri, Jan 13, 2006 at 03:37:32AM -0600, kevin brintnall wrote:
> Has anyone else taken a look at this? I thought I'd play around with the
> system catalog and see if I couldn't put an ACL column into pg_attribute:
>
> It ended up generating the following BKI line:
>
> insert ( 1249 attac
Has anyone else taken a look at this? I thought I'd play around with the
system catalog and see if I couldn't put an ACL column into pg_attribute:
It ended up generating the following BKI line:
insert ( 1249 attacl 1034 -1 -1 18 1 -1 -1 f x i f f f t 0 _null_ )
And the ROW certainly app
22 matches
Mail list logo
