pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedDrop Not Null
5+ messages / 4 participants
[nested] [flat]
* Drop Not Null
@ 2007-10-18 06:01 yogesh <yogesh.arora.daffodil@gmail.com>
2007-10-18 14:01 ` Re: Drop Not Null Kevin Grittner <Kevin.Grittner@wicourts.gov>
2007-10-18 23:20 ` Re: Drop Not Null Alex Kloss <alexkloss@att.net>
2007-10-19 05:09 ` Re: Drop Not Null Ashish Karalkar <ashish.karalkar@info-spectrum.com>
0 siblings, 3 replies; 5+ messages in thread
From: yogesh @ 2007-10-18 06:01 UTC (permalink / raw)
To: pgsql-admin
Hello Frnds,
What is the Command to drop the Not Null Constraint from a Column
of the Table.....Please reply asap.............
Regards,
Yogesh Arora.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Drop Not Null
2007-10-18 06:01 Drop Not Null yogesh <yogesh.arora.daffodil@gmail.com>
@ 2007-10-18 14:01 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2 siblings, 0 replies; 5+ messages in thread
From: Kevin Grittner @ 2007-10-18 14:01 UTC (permalink / raw)
To: yogesh <yogesh.arora.daffodil@gmail.com>; pgsql-admin
>>> On Thu, Oct 18, 2007 at 1:01 AM, in message
<1192687310.749557.227290@q5g2000prf.googlegroups.com>, yogesh
<yogesh.arora.daffodil@gmail.com> wrote:
> What is the Command to drop the Not Null Constraint from a Column
http://www.postgresql.org/docs/8.2/interactive/sql-altertable.html
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Drop Not Null
2007-10-18 06:01 Drop Not Null yogesh <yogesh.arora.daffodil@gmail.com>
@ 2007-10-18 23:20 ` Alex Kloss <alexkloss@att.net>
2007-10-19 05:39 ` Re: Drop Not Null yogesh <yogesh.arora.daffodil@gmail.com>
2 siblings, 1 reply; 5+ messages in thread
From: Alex Kloss @ 2007-10-18 23:20 UTC (permalink / raw)
To: yogesh <yogesh.arora.daffodil@gmail.com>; pgsql-admin
yogesh wrote:
> Hello Frnds,
> What is the Command to drop the Not Null Constraint from a Column
> of the Table.....Please reply asap.............
>
> Regards,
> Yogesh Arora.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
>
ALTER TABLE table ALTER COLUMN column DROP NOT NULL
See http://www.postgresql.org/docs/8.2/interactive/ddl-alter.html#AEN2311
for more information about dropping constraints.
Alex Kloss
Attachments:
signature.asc (application/pgp-signature, 188B) download
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Drop Not Null
2007-10-18 06:01 Drop Not Null yogesh <yogesh.arora.daffodil@gmail.com>
2007-10-18 23:20 ` Re: Drop Not Null Alex Kloss <alexkloss@att.net>
@ 2007-10-19 05:39 ` yogesh <yogesh.arora.daffodil@gmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: yogesh @ 2007-10-19 05:39 UTC (permalink / raw)
To: pgsql-admin
On Oct 19, 4:20 am, alexkl...@att.net (Alex Kloss) wrote:
> yogesh wrote:
> > Hello Frnds,
> > What is the Command to drop the Not Null Constraint from a Column
> > of the Table.....Please reply asap.............
>
> > Regards,
> > Yogesh Arora.
>
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: Don't 'kill -9' the postmaster
>
> ALTER TABLE table ALTER COLUMN column DROP NOT NULL
>
> Seehttp://www.postgresql.org/docs/8.2/interactive/ddl-alter.html#AEN2311
> for more information about dropping constraints.
>
> Alex Kloss
>
> signature.asc
> 1KDownload
Thx for your Support
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Drop Not Null
2007-10-18 06:01 Drop Not Null yogesh <yogesh.arora.daffodil@gmail.com>
@ 2007-10-19 05:09 ` Ashish Karalkar <ashish.karalkar@info-spectrum.com>
2 siblings, 0 replies; 5+ messages in thread
From: Ashish Karalkar @ 2007-10-19 05:09 UTC (permalink / raw)
To: yogesh <yogesh.arora.daffodil@gmail.com>; pgsql-admin
alter table table_name alter column column_name drop not null;
----- Original Message -----
From: "yogesh" <yogesh.arora.daffodil@gmail.com>
To: <pgsql-admin@postgresql.org>
Sent: Thursday, October 18, 2007 11:31 AM
Subject: [ADMIN] Drop Not Null
> Hello Frnds,
> What is the Command to drop the Not Null Constraint from a Column
> of the Table.....Please reply asap.............
>
> Regards,
> Yogesh Arora.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2007-10-19 05:39 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-10-18 06:01 Drop Not Null yogesh <yogesh.arora.daffodil@gmail.com>
2007-10-18 14:01 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2007-10-18 23:20 ` Alex Kloss <alexkloss@att.net>
2007-10-19 05:39 ` yogesh <yogesh.arora.daffodil@gmail.com>
2007-10-19 05:09 ` Ashish Karalkar <ashish.karalkar@info-spectrum.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox