On Sat, Apr 25, 2009 at 04:21:06PM -0400, Kenneth Tilton wrote:
> But I am "inheriting" from the parent, so everything about the parent
> should be true for me unless overridden. I mean in the usual sense of
> inherit I know from OO.
This is from the current docs
(http://www.postgresql.org/doc
Joshua Tolley wrote:
On Sat, Apr 25, 2009 at 04:01:20PM -0400, Kenneth Tilton wrote:
Given constraint:
ALTER TABLE provider_input.common
ADD CONSTRAINT common_pin_file_load_sid_fkey FOREIGN KEY
(pin_file_load_sid)
REFERENCES provider_input.file_load (sid) MATCH FULL
ON UPDATE
On Sat, Apr 25, 2009 at 04:01:20PM -0400, Kenneth Tilton wrote:
> Given constraint:
>
> ALTER TABLE provider_input.common
> ADD CONSTRAINT common_pin_file_load_sid_fkey FOREIGN KEY
> (pin_file_load_sid)
> REFERENCES provider_input.file_load (sid) MATCH FULL
> ON UPDATE NO ACTION ON
My noob understanding is that deleteing one of these:
CREATE TABLE provider_input.file_load
(
sid serial NOT NULL,
file_name_full text,
file_name text,
file_creation_date text,
load_universal_time numeric,
headers text,
date timestamp without time zone DEFAULT now(),
CONSTRAINT fi
Dean Rasheed <[EMAIL PROTECTED]> writes:
>> Referential integrity actions execute as the owner of the table, so
>> anything triggered by them would execute as the owner too.
> Hmm, that opens up a very nasty gotcha, as shown by the script
> below. What user1 does looks, at first sight, fairly inno
> Referential integrity actions execute as the owner of the table, so
> anything triggered by them would execute as the owner too.
>
> regards, tom lane
Hmm, that opens up a very nasty gotcha, as shown by the script
below. What user1 does looks, at first sight, fairly innoc
Craig Ringer <[EMAIL PROTECTED]> writes:
> Is the search_path reset in some way that's not visible in
> pg_catalog.pg_settings when the ON DELETE CASCADE is issued?
No, I don't believe so. Perhaps your test case was simply fooled by
plan caching within the trigger function?
In general the soluti
Tom Lane wrote:
> Dean Rasheed <[EMAIL PROTECTED]> writes:
>> I have a table with a trigger on it, designed to run security
>> invoker. In my real code this accesses a temporary table belonging to
>> the invoker.
>
>> Then I have second table, together with a foreign key between them and
>> a dele
Dean Rasheed <[EMAIL PROTECTED]> writes:
> I have a table with a trigger on it, designed to run security
> invoker. In my real code this accesses a temporary table belonging to
> the invoker.
> Then I have second table, together with a foreign key between them and
> a delete cascade from the secon
Sorry, Opera removed all the newlines from my last post.
Trying again in Firefox...
Hi,
I'm not sure if the following is a bug. I certainly found it
surprising, but maybe more experienced users won't.
I have a table with a trigger on it, designed to run security
invoker. In my real code this ac
Hi,I'm not sure if the following is a bug. I certainly found itsurprising, but
maybe more experienced users won't.I have a table with a trigger on it,
designed to run securityinvoker. In my real code this accesses a temporary
table belonging tothe invoker.Then I have second table, together with
On Thu, Jul 06, 2006 at 02:06:46PM -0400, Brennan, Sean (IMS) wrote:
> All in the same db connection, I do the following:
> 1)create a temp table
> 2)delete rows from the main table
> 3)access the temp table in the delete trigger of the main table
> 4)access the temp table in the delete trigger of
I seem to have a problem accessing a temp table from a trigger when I
use cascading deletes.
I have 2 tables: a main table and a child table. The child table has a
foreign key reference to the main table that has DELETE CASCADE on.
I have delete triggers on both tables that are run BEFORE DELETE.
Add ON DELETE CASCADE to the references in book.
On Mon, 12 Mar 2001, Marcelo Pereira wrote:
> Hi,
>
> I am in trouble deleting rows in cascade.
>
> I have a scheme like this:
>
> create table author (author_cod integer primary key, author_name char(20));
> create table book (book_cod intege
Hi,
I am in trouble deleting rows in
cascade.
I have a scheme like this:
create table author (author_cod integer primary
key, author_name char(20));
create table book (book_cod integer primary key,
book_autor integer references author(author_cod),
book_title char(30));
I would like
15 matches
Mail list logo
