• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Migrations: A result was returned when none was expected.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Migrations: A result was returned when none was expected.


  • Subject: Re: Migrations: A result was returned when none was expected.
  • From: Chuck Hill <email@hidden>
  • Date: Fri, 07 Sep 2012 10:20:13 -0700

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@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden

--
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@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden

  • Follow-Ups:
    • Re: Migrations: A result was returned when none was expected.
      • From: Miguel Torres <email@hidden>
References: 
 >Migrations: A result was returned when none was expected. (From: Miguel Torres <email@hidden>)

  • Prev by Date: Re: classes.include.patternset and difference between Eclipse and Jenkins
  • Next by Date: Re: Migrations: A result was returned when none was expected.
  • Previous by thread: Migrations: A result was returned when none was expected.
  • Next by thread: Re: Migrations: A result was returned when none was expected.
  • Index(es):
    • Date
    • Thread