[SQL] how can i drop a constraint

[rute solipa]

hello,

i've got some tables where constraints don't have an explicit name, how can 
i drop them.

best regards,

rute

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

[SQL] disable constraints

[rute solipa]

hello,

does anyone nows how can i disable/enable table or column constraints?

in oracle it's possible to disable constraints like this:

alter table tb_1
disable primary key;
best regards,
rute
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

Re: [SQL] disable constraints

[rute solipa]

i whant avoid to dropping constraint, i whant to disable the constraints, 
because i need to insert a large amont of data.
is there a way?

best regards,
rute


At 03:47 PM 2/26/2003 +0100, you wrote:
Hi!

use "alter table ??? drop constraint ???"

example:

create table asdf (userid text, foreign key (userid) references 
person(userid) on delete cascade);

\d asdf
Table "public.asdf"
 Column | Type | Modifiers
+--+---
 userid | text |
Foreign Key constraints: $1 FOREIGN KEY (userid) REFERENCES person(userid) 
ON UPDATE NO ACTION ON DELETE CASCADE

alter table asdf drop constraint "$1";

Regards,
Patrik Kudo
rute solipa wrote:
hello,
does anyone nows how can i disable/enable table or column constraints?
in oracle it's possible to disable constraints like this:
alter table tb_1
disable primary key;
best regards,
rute
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly



---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org

[SQL] Unsubscribe

[rute solipa]

Unsubscribe

[SQL] unsubscribe

[Rute Solipa]

 
- Original Message - 
From: rute solipa 
To: [EMAIL PROTECTED] 
Sent: Thursday, July 31, 2003 9:35 AM
Subject: [SQL] Unsubscribe

Unsubscribe

[SQL] Unsubscribe

[Rute Solipa]

please remove my email from your database 
contacts.
 
best regards,
 
etur

Re: [SQL] About pg_dump

[Rute Solipa]

hi,

i had to restore a database from a pg_dump and i'm having problems with the
encoding.
it seems that the pg_dump command doesn't keep the encoding information.
does anybody can help me resolve this problem.

thanks

rute



- Original Message -
From: "Daniel Henrique Alves Lima" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 10, 2004 11:00 PM
Subject: [SQL] About pg_dump


> Hi, everybody !
>
> I don't know if this is the best list to ask this question but if it
> doesn't, please forgive me (should i try pgsl-general, maybe ?)...
> We have a postgresql database in production and i've 2 questions
> about pg_dumpall boring me. We "dump" both ddl and data as SQL commands,
> so :
>
> 1. Does the created sql script respect the database encoding (will
> chars be writen as utf-8 chars or iso-8859-1 char or ...) ?
> 2. We've a bytea in one table. What exactly happens with the dumped
> data ? Is there any trouble with it ?
>
> I believe that we must to worry now (earlier). I don't want to
> expect until we must to restore database backup to descover that dumping
> data is corrupted :-)
>
>
>  Thanks in advance 
>
>
> ---(end of broadcast)---
> TIP 7: don't forget to increase your free space map settings
>
>



---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])