'
and t.tgtype=21
and src.relname='objective';
Thanks.
Oleg
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Oleg Lebedev
Sent: Wednesday, November 10, 2004 10:37 AM
To: Richard Huxton
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] Modifying
rce an FK constraint to
cascade updates?
Thanks.
Oleg
-Original Message-
From: Richard Huxton [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 10, 2004 10:23 AM
To: Oleg Lebedev
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] Modifying FK constraints
Oleg Lebedev wrote:
> Greetings.
Title: Message
Greetings.
Is it possible to
modify a foreign key constraint and force it to cascade on update? If there is
no such SQL command, then is it possible to update some system tables to
accomplish this?
The problem is
that I have a bunch of tables with FK constraints and I need
Title: Message
I am trying to
upgrade from postgres 7.3.2 to 7.4.1
I use backups
created by 7.3.2 pg_dump.
When
I run pg_restore (v. 7.4.1) as a superuser and it throws
"ERROR: permission denied for language c"
Below is the installation
trace.
Thanks.
Oleg
TRACE:
[EMAIL PROTECTED] we
>>I think that is a main take-away here. You should not try to depend on
>>dblink as a robust replication solution. Perhaps if postgres had
>>two-phase commit and nested transactions, but not at the moment.
Agreed. I wonder if I should simulate local Xactions by using local
dblink calls?
What do
my problem?
Thanks.
Oleg
-Original Message-
From: John Sidney-Woollett [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 05, 2004 12:49 AM
To: Oleg Lebedev
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] dblink: rollback transaction
Oleg Lebedev said:
> Is there a way to roll
I see that it works for this simple case.
Check my previous email for a more complex example.
Thanks.
Oleg
-Original Message-
From: Bruce Momjian [mailto:[EMAIL PROTECTED]
Sent: Friday, January 09, 2004 10:45 AM
To: Joshua D. Drake
Cc: Oleg Lebedev; [EMAIL PROTECTED]
Subject: Re
second DB instance.
The query will throw an error saying that it UniqueIndex is violated
when assigning last name Doe to employee with id 1.
Thanks.
Oleg
-Original Message-
From: Joshua D. Drake [mailto:[EMAIL PROTECTED]
Sent: Friday, January 09, 2004 10:37 AM
To: Oleg Lebedev
Cc
So, does it mean that the only way to disable the index is to drop and
recreate it? What about setting indisunique to false temporarily?
-Original Message-
From: Bruce Momjian [mailto:[EMAIL PROTECTED]
Sent: Friday, January 09, 2004 10:19 AM
To: Oleg Lebedev
Cc: [EMAIL PROTECTED
Title: Message
Hi,
I need to know if
there is a way to defer or disable a unique index on a table during an
update. One way would be to set indisunique to false, perform update and then
set to true. But, this seems to be an ugly solution.
I've posted a similar message 6 months ago and at
Title: Message
Hi,
I need to know if
there is a way to defer or disable a unique index on a table during an
update. One way would be to set indisunique to false, perform update and then
set to true. But, this seems to be an ugly solution.
I've posted a similar message 6 months ago and at
Can Postgres JDBC driver encrypt a password before sending and inserting
it into the password column?
-Original Message-
From: Peter Eisentraut [mailto:[EMAIL PROTECTED]
Sent: Monday, December 01, 2003 1:32 PM
To: Oleg Lebedev
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] Storing
Hello,
I am using postgresql to store data passed from a web page. A user may
enter whatever text she wants on that web page. Do I have to prepend all
the illegal characters in the text with backslashes before storing the
text in the database? Is there any way to make postgresql prepend these
ille
13 matches
Mail list logo
