Smalltalk › Cincom › VisualWorks

Glorp colom renaming

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

3 messages Options

Maarten Mostert-2

Glorp colom renaming

Hi,

When I rename colums in Glorp wit the following code:

oldField := (aGlorpSession system allTables
      detect: [:each | each name = 'MMT_BINARYFILES']) fields
      detect: [:each | each name = 'binf_attachementdate'].
   aGlorpSession accessor
    renameField: oldField
    to: 'attachementdate'
    ifError: [].

It produces something like:

ALTER TABLE MMT_BINARYFILES RENAME binf_attachementdate TO attachementdate

This works fine in Postgres, but under Oracle it gives the following error (if executed through AdHoc).

ORA-14155: absence du mot-clé PARTITION ou SUBPARTITION

Regards,

@+Maarten,

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

Alan Knight-3

Re: Glorp colom renaming

That's a bug. It ought to be rename column, not just rename. Not the clearest error message, though.

At 11:21 PM 2010-02-08, Maarten MOSTERT wrote:

Hi,

When I rename colums in Glorp wit the following code:

oldField := (aGlorpSession system allTables
      detect: [:each | each name = 'MMT_BINARYFILES']) fields
      detect: [:each | each name = 'binf_attachementdate'].
   aGlorpSession accessor
    renameField: oldField
    to: 'attachementdate'
    ifError: [].

It produces something like:

ALTER TABLE MMT_BINARYFILES RENAME binf_attachementdate TO attachementdate

This works fine in Postgres, but under Oracle it gives the following error (if executed through AdHoc).

ORA-14155: absence du mot-clé PARTITION ou SUBPARTITION
Regards,

@+Maarten,

--
You received this message because you are subscribed to the Google Groups "glorp-group" group.
To post to this group, send email to [hidden email].
To unsubscribe from this group, send email to [hidden email].
For more options, visit this group at http://groups.google.com/group/glorp-group?hl=en.

Alan Knight [|], Engineering Manager, Cincom Smalltalk

[hidden email]

http://www.cincom.com/smalltalk

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

Maarten Mostert-2

Re: Glorp colom renaming

Yes Oracle speaks french or sort of.

In english it must be:

ORA-14155: missing PARTITION or SUBPARTITION keyword

----- Original Message -----

From: [hidden email]

To: [hidden email] ; [hidden email] ; [hidden email]

Sent: Wednesday, February 10, 2010 12:28 AM

Subject: Re: [vwnc] Glorp colom renaming

That's a bug. It ought to be rename column, not just rename. Not the clearest error message, though.

At 11:21 PM 2010-02-08, Maarten MOSTERT wrote:

Hi,

When I rename colums in Glorp wit the following code:

oldField := (aGlorpSession system allTables
      detect: [:each | each name = 'MMT_BINARYFILES']) fields
      detect: [:each | each name = 'binf_attachementdate'].
   aGlorpSession accessor
    renameField: oldField
    to: 'attachementdate'
    ifError: [].

It produces something like:

ALTER TABLE MMT_BINARYFILES RENAME binf_attachementdate TO attachementdate

This works fine in Postgres, but under Oracle it gives the following error (if executed through AdHoc).

ORA-14155: absence du mot-clé PARTITION ou SUBPARTITION
Regards,

@+Maarten,

--
You received this message because you are subscribed to the Google Groups "glorp-group" group.
To post to this group, send email to [hidden email].
To unsubscribe from this group, send email to [hidden email].
For more options, visit this group at http://groups.google.com/group/glorp-group?hl=en.

--

Alan Knight [|], Engineering Manager, Cincom Smalltalk

[hidden email]

[hidden email]

http://www.cincom.com/smalltalk

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc