On Wed, 27 Jun 2001, Justin Clift wrote:
> Hi Matt,
>
> I'm looking for a way to change an existing sequence's "increment" value on
> the fly (after it's being created).
>
> Can't seem to find a function which does this either. Being able to change
> the increment every now and again would provi
On Fri, 22 Jun 2001, Justin Clift wrote:
> i.e. CREATE SEQUENCE newseq INCREMENT trunc(random() * 10);
Didn't you ask this like 2 weeks ago?
I said it once, I'll say it again. Stop being lazy, and write a trigger.
The Postgres developers are *not* going to alter the core functionality of
their
So does this impact Postgresql's performance on Windows as well? I think Apache
had to rewrite their Windows port to use threads instead of processes before
they got decent performance on that platform. Any chance of Postgresql doing
that sort of thing? Not that I'm asking for the change; I'd
i've always had to add the column first and then do:
update pg_attribute set attnotnull = 't' where attname = 'fieldname' and
attrelid = (select oid from pg_class where relname = 'tablename');
but i'm using version 7.0.2, maybe the alter column to set not null works in
later versions?
tamsin
-
On Wed, 27 Jun 2001, Bruce Momjian wrote:
> pg_hba.conf option on Debian called "peer" recently. We don't have such
> an option and it was never submitted to us a a patch.
>From 7usr/share/doc/postgresql/README.Debian.gz:
6. Unix socket authentication is provided (authentication type "peer").