[Info-Ingres] When a modify chops a table...

#11

Martin Bowes wrote:

Quote:

Just found the documentation on this...

[NO]DUPLICATES
Allows or disallows duplicate rows in the table. This option does not
affect
a table created as heap. Heap tables always accept duplicate rows
regardless of the setting of this option. If a heap table is created and
specified with NODUPLICATES, the heap table modified to a different
table
structure, the NODUPLICATES option is enforced. (By default, all
structures accept duplicate rows.)
The DUPLICATES setting can be overridden by specifying a unique key for
a table in the MODIFY statement.

I suppose I sorta expected it to say 'by silently removing the offending
rows'.

But I'd have to say that it should generate an error along the lines of
trying to impose a unique key on non-unique data.
E_US1591 MODIFY: table could not be modified because rows contain
duplicate keys.

Whats the general feeling on this?

Marty

Marty,

I think the error should be

E_MARTY001 MODIFY: table could not be modified because rows contain duplicate keys. Marty found this.

;-)

Mikey

P.S. Do you actually do *anything* besides beat the crap out of Ingres
and drink beer with Roy down at Brown's?

#12

Quote:

I think the error should be
E_MARTY001 MODIFY: table could not be modified because rows contain
duplicate keys. Marty found this.

No. Sadly it doesn't conform to the standard error code syntax...
But E_OZ0001_MARTY_JUST_STOP_THAT would.

Quote:

P.S. Do you actually do *anything* besides beat the crap out of Ingres
and drink beer with Roy down at Brown's?
I deadlift.

I rant at strangers.
Then I deadlift some more.

If the ranting helped me get an extra rep then I go back and thank them.
It sure confuses the hell out of them!

It's a pretty hectic schedulle.

Marty

#13

Michael Leo wrote:

Quote:

P.S. Do you actually do *anything* besides beat the crap out of Ingres
and drink beer with Roy down at Brown's?

Sometimes we drink beer other places.

--
Roy

UK Ingres User Association Conference 2009 will be on Tuesday June 9, 2009
Go to http://www.iua.org.uk/join to get on the mailing list.

#14

I actually like this...

Ingres is now an open source community product now so why not expose
some of the credit where credit is due ? I'm guessing though that a lot
of new errors in 9.2 would read :

"E_MARTY001 MODIFY: table could not be modified because rows contain
duplicate keys. Marty found this."

"E_ROY0001 MODIFY: table could not be purged. Roy found this first as
always and gave the fix"

If ingres were a religion it would follow sihkism and Roy and Marty
would be a member of the guru's contributing to the "ingres book of
knowledge"

Regards
Graham Newlands
Consultant
Enterprise Application Services
Fujitsu Australia
Desk: +61 3 9924 3820
Fax: + 61 3 9924 3001
Mobile: +61 (0)404 003 104
Email: graham.newlands (AT) au (DOT) fujitsu.com
Website: www.fujitsu.com.au
Level 6, 825 Bourke Street, Docklands, 3008

Fujitsu has moved into The Gauge, the evolutionary new 6 star green
star office design certified building, recognising world leadership,
with a Green Star fit out. Fujitsu are also targeting an exceptional
NABERS Energy fit out rating, to benchmark their greenhouse performance
and energy efficiency.

P Please consider the environment before printing this email.

-----Original Message-----
From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of
Michael Leo
Sent: Friday, 12 December 2008 1:00 AM
To: Ingres and related product discussion forum
Cc: Kristoff
Subject: Re: [Info-Ingres] When a modify chops a table...

Martin Bowes wrote:

Quote:

Just found the documentation on this...

[NO]DUPLICATES
Allows or disallows duplicate rows in the table. This option does not
affect a table created as heap. Heap tables always accept duplicate
rows regardless of the setting of this option. If a heap table is
created and specified with NODUPLICATES, the heap table modified to a
different table structure, the NODUPLICATES option is enforced. (By
default, all structures accept duplicate rows.) The DUPLICATES setting

can be overridden by specifying a unique key for a table in the MODIFY

statement.

I suppose I sorta expected it to say 'by silently removing the
offending rows'.

But I'd have to say that it should generate an error along the lines
of trying to impose a unique key on non-unique data.
E_US1591 MODIFY: table could not be modified because rows contain
duplicate keys.

Whats the general feeling on this?

Marty

Marty,

I think the error should be

E_MARTY001 MODIFY: table could not be modified because rows contain
duplicate keys. Marty found this.

;-)

Mikey

P.S. Do you actually do *anything* besides beat the crap out of Ingres
and drink beer with Roy down at Brown's?
_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://www.kettleriverconsulting.com...fo/info-ingres

This is an email from Fujitsu Australia Limited, ABN 19 001 011 427. It is confidential to the ordinary user of the email address to which it was addressed and may contain copyright and/or legally privileged information. No one else may read, print, store, copy or forward all or any of it or its attachments. If you receive this email in error, please return to sender. Thank you.

If you do not wish to receive commercial email messages from Fujitsu Australia Limited, please email unsubscribe (AT) au (DOT) fujitsu.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

[Info-Ingres] When a modify chops a table...

comp.databases.ingres comp.databases.ingres

Re: [Info-Ingres] When a modify chops a table... - 12-11-2008 , 08:00 AM

Re: [Info-Ingres] When a modify chops a table... - 12-11-2008 , 08:51 AM

Re: [Info-Ingres] When a modify chops a table... - 12-11-2008 , 01:33 PM

Re: [Info-Ingres] When a modify chops a table... - 12-11-2008 , 05:46 PM