public class DInAdminEOModel17 implements IERXMigration {
public NSArray<ERXModelVersion> modelDependencies() {
return null;
}
public void upgrade(EOEditingContext editingContext,
EOAdaptorChannel channel, EOModel model) throws
Throwable {
ERXJDBCUtilities.executeUpdateScriptFromResourceNamed(channel,
"Migrations/DInAdminEOModel17_Upgrade.sql", null);
}
public void downgrade(EOEditingContext editingContext,
EOAdaptorChannel channel, EOModel model) throws
Throwable {
// whatever it takes to invert those
}
}
On 07/09/2012, at 12:20, Chuck Hill <[email protected]> wrote:
> How are you running this in Java?
>
>
> On 2012-09-07, at 7:37 AM, Miguel Torres wrote:
>
>> Hi List,
>>
>> I am getting this error:
>>
>> A result was returned when none was expected.
>>
>> I am executing a migration that creates a new table and a new procedure to
>> insert some records to that table, because it has a reference to a table
>> that already exists and may have some records. At the end of the migration,
>> the procedure is dropped.
>>
>> I am calling the procedure using a SELECT statement (Postgresql).
>>
>> This is the content of my migration:
>>
>> CREATE TABLE empresa_pacs (
>> tf_habilitar character varying(5) NOT NULL,
>> tf_modo character varying,
>> tf_certificado character varying,
>> tf_vencimiento_certificado date,
>> tf_contrasena character varying,
>> empresa_id integer PRIMARY KEY REFERENCES empresa ON DELETE CASCADE
>> );
>>
>>
>> CREATE FUNCTION inserta_empresa_pacs() RETURNS VOID
>> AS 'DECLARE empresa_temp empresa%ROWTYPE;
>> BEGIN FOR empresa_temp IN SELECT * FROM empresa LOOP INSERT
>> INTO empresa_pacs(empresa_id, tf_habilitar) VALUES(empresa_temp.empresa_id,
>> ''false'');
>> END LOOP;
>> END;'
>> LANGUAGE plpgsql;
>>
>> SELECT inserta_empresa_pacs() ;
>>
>> DROP FUNCTION inserta_empresa_pacs();
>>
>> I understand the error's meaning, I am asking if there are any other way to
>> execute the migration to avoid the error.
>>
>> Thanks in advance.
>>
>> Miguel Torres.
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> Do not post admin requests to the list. They will be ignored.
>> Webobjects-dev mailing list ([email protected])
>> Help/Unsubscribe/Update your Subscription:
>> https://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net
>>
>> This email sent to [email protected]
>
> --
> Chuck Hill Senior Consultant / VP Development
>
> Practical WebObjects - for developers who want to increase their overall
> knowledge of WebObjects or who are trying to solve specific problems.
> http://www.global-village.net/gvc/practical_webobjects
>
>
>
>
>
>
>
>
>
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
