Stephan Szabo
[EMAIL PROTECTED]
On Wed, 21 Mar 2001, Brent R. Matzelle wrote:
> 3/20/2001 6:18:23 AM, Stephan Szabo <[EMAIL PROTECTED]> wrote:
> >> The problem is that the syntax
> >>
> >> create table SomeTable (
> >> SomeColumn int4 references OtherTable ( SomeColumn ),
> >> . . .
3/20/2001 6:18:23 AM, Stephan Szabo <[EMAIL PROTECTED]> wrote:
>> The problem is that the syntax
>>
>> create table SomeTable (
>> SomeColumn int4 references OtherTable ( SomeColumn ),
>> . . .
>>
>> creates an trigger which you can't drop with drop trigger
>> because it doesn't hav
On Tue, Mar 20, 2001 at 02:18:23PM -0800, Stephan Szabo wrote:
>
> > The problem is that the syntax
> >
> > create table SomeTable (
> > SomeColumn int4 references OtherTable ( SomeColumn ),
> > . . .
> >
> > creates an trigger which you can't drop with drop trigger
> > because it doesn
> The problem is that the syntax
>
> create table SomeTable (
> SomeColumnint4 references OtherTable ( SomeColumn ),
> . . .
>
> creates an trigger which you can't drop with drop trigger
> because it doesn't have a name. What you suggest does work for me, i.e.
> deleting from pg_
On Tue, Mar 20, 2001 at 01:41:22PM -0800, Stephan Szabo wrote:
> On Tue, 20 Mar 2001, chris markiewicz wrote:
>
> > okay, i screwed up. i dropped some triggers from a table. now that table
> > is not accessible to me.
> >
> > can't drop it...can't select...can't pg_dump.
> >
> > message is er
"chris markiewicz" <[EMAIL PROTECTED]> writes:
> message is error: RelationBuildTriggers: 2 record(s) not found for rel
> accessor_group
Set reltriggers to 4 (instead of 6) in the pg_class entry for that
table.
regards, tom lane
---(end of broadca
okay, i screwed up. i dropped some triggers from a table. now that table
is not accessible to me.
can't drop it...can't select...can't pg_dump.
message is error: RelationBuildTriggers: 2 record(s) not found for rel
accessor_group
or a pg_dump results in: getTables(): relation 'accessor_group'
On Tue, 20 Mar 2001, chris markiewicz wrote:
> okay, i screwed up. i dropped some triggers from a table. now that table
> is not accessible to me.
>
> can't drop it...can't select...can't pg_dump.
>
> message is error: RelationBuildTriggers: 2 record(s) not found for rel
> accessor_group
>
>
