(I think) you'd better check the --enable-cassert option in
http://www.postgresql.org/idocs/index.php?install-procedure.html
cheers,
t.
On Wed, 30 May 2001, rui zhong wrote:
>
> Hi,
>
> I try to use SQL statement 'CREATE ASSERTIION', but it does not work, how to use it?
>Does
> PostgreSQL
Hi,
I try to use SQL statement 'CREATE ASSERTIION', but it does not work, how to use it? Does PostgreSQL support ASSERTION constraint ? Please help me out.
Thanks.
Yanchun Get your FREE download of MSN Explorer at http://explorer.msn.com
> What PG version are you using?
>
> IIRC, in pre-7.1 code, backends allocate OIDs in blocks of 32 (?? more
> or less anyway); so if a backend uses one OID and then exits, you wasted
> 31 OIDs. This does not happen anymore with 7.1, though.
>
> Another possibility is that you're creating lots of
"Steve Wolfe" <[EMAIL PROTECTED]> writes:
>Recently, our OID usage has started to jump dramatically - today, we're
> using ten thousand or more in a few minutes. We're trying to figure out
> just what is using so many, without any luck. Aside from doing a lot of
> inserts (which we don't do
> >Also, when the OID's reach the limit of an int4, if I recall
correctly,
> > they simply wrap around, and things keep working unless you depend on
> > unique OID's. Is that correct?
>
> That's correct.
>
> cheers,
> t.
>
> p.s. and rumor has it that the universe will start shrinking as soon
On Wed, 30 May 2001, Steve Wolfe wrote:
>
> I know that this topic comes up fairly often, so I tried to search the
> archives, but the search engine doesn't appear to have info on messages
> after 1999, so forgive me for repeating this topic.
>
>Recently, our OID usage has started to ju
On Tue, May 29, 2001 at 07:49:46PM -0400, Arcadio A. Sincero Jr. wrote:
> Hello list,
wrong list. try [EMAIL PROTECTED] instead.
> I'd like to set up Postgresql so that users can have "read-only" access to a
> database. Right now, I only know how to set it so a user can have all or
> nothing ac
On Wed, 30 May 2001 08:07:11 -0400, [EMAIL PROTECTED] wrote:
> DBD::Pg 1.00 won't allow me to use the following
> the code anymore
>
> --
> $s=$dbh->prepare('select * from table');
> $s->execute or die $dbh->errstr;
> while(my @a=$s->fetchrow_array())
> {
> ... do something
>
"Karen Ellrick" <[EMAIL PROTECTED]> writes:
> Yup, the key is that both those methods copy (rather than move) the
> directory. If you copy, you can use restart (I assume - I didn't try it).
Just for the benefit of the archives: copying the directory tree while
the postmaster is live is exactly w
