This might be helpful..
--- Begin Message ---
> Can someone clue me in as to proper syntax for adding a not null
> check constraint? I've fumbled around a bit without much luck
> and I don't see this covered in the alter table section of the
> interactive docs.
>
> My pseudo code is:
> ALTER T
David Stanaway <[EMAIL PROTECTED]> wrote:
> In this case the row is ID (Case sensitive) so whenever
> you refer to it you must refer to it as "ID"
> ...
>
> > proba=# alter table tabla1 drop constraint ID not null;
>
> Here you refer to it as ID which is case folded to id and
> does not refer
On Tue, 2002-05-14 at 11:24, MG wrote:
>
> On 03-May-2002 Nick Fankhauser wrote:
> > alter table drop constraint ID unique;
> > alter table drop constraint ID not null;
> >
> > alter table add constraint ID references table2 ;
> >
>
> Hi!
>
> It not works. :(
> I try it:
> proba=# create t
Hi, all,
pgsql7.1.2 is running on Sun solaris. When I start pgsql
server, I got start-up failed, error below:
IpcMemoryCreate: shmget(key=5432001, size=1777664, 03600)
failed: Invalid argument
please help me to figure it out. thanks
tony
---(end of broadcast)
On 03-May-2002 Nick Fankhauser wrote:
> alter table drop constraint ID unique;
> alter table drop constraint ID not null;
>
> alter table add constraint ID references table2 ;
>
Hi!
It not works. :(
I try it:
proba=# create table "tabla1" ("ID" int8 NOT NULL UNIQUE, "nev" varchar(20) );
NO
Brian McCane <[EMAIL PROTECTED]> writes:
> Well I never heard back from anyone about how to debug this thing,
> so I did a pg_ctl stop/start cycle this morning. Then I tried to re-run
> the "VACUUM FULL". No dice, it still gets the same error. Any ideas now?
> It sounds like this is the p
Hello,
Well I never heard back from anyone about how to debug this thing,
so I did a pg_ctl stop/start cycle this morning. Then I tried to re-run
the "VACUUM FULL". No dice, it still gets the same error. Any ideas now?
It sounds like this is the perfect test case for someone to debug
