PostgreSQL Error

 Hi

I am using the Mindscape PostgreSQL Provider when dragging a table to the model it gives the following error.

Exception while processing Server Explorer drag: System.ArgumentException: No identity type corresponds to Object

Parameter name: generatorType

at Mindscape.LightSpeed.Generator.Integration.Dsl.Differencing.Utils.ExtractionTypeUtils.GetIdentityType(ModelDataType generatorType)

at Mindscape.LightSpeed.Generator.Integration.EntityConverter.CopyIdentityType(EntityModel generatorEntity, Entity entity)

at Mindscape.LightSpeed.Generator.Integration.EntityConverter.PopulateEntities()

at Mindscape.LightSpeed.Generator.Integration.EntityBuilder.AddTablesToModel(Model model, ILightSpeedDataSource connection, IEnumerable`1 tableNames, IGenerationLog log)

at Mindscape.LightSpeed.Generator.Integration.DiagramDragDropHandler.<>c__DisplayClass4.<OnDragDrop>b__3(DragObject dragObject, IGenerationLog log)

at Mindscape.LightSpeed.Generator.Integration.ServerExplorer.IfIsServerExplorerDrag(DragEventArgs e, DragAction action)

Table SQL:

-- Table: uuid.master

-- DROP TABLE uuid.master;

CREATE TABLE uuid.master
(
  id uuid NOT NULL,
  created timestamp without time zone NOT NULL DEFAULT now(),
  parent uuid,
  payerid character(16),
  type_id smallint NOT NULL,
  CONSTRAINT master_pkey PRIMARY KEY (id),
  CONSTRAINT master_parent_fkey FOREIGN KEY (parent)
      REFERENCES uuid.master (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT master_type_id_fkey FOREIGN KEY (type_id)
      REFERENCES uuid.types (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH (
  OIDS=FALSE
);
ALTER TABLE uuid.master OWNER TO postgres;

-- Index: uuid.master_parent_idx

-- DROP INDEX uuid.master_parent_idx;

CREATE INDEX master_parent_idx
  ON uuid.master
  USING btree
  (parent);

-- Index: uuid.master_type_idx

-- DROP INDEX uuid.master_type_idx;

CREATE INDEX master_type_idx
  ON uuid.master
  USING btree
  (type_id);

Thanks for alerting us to this issue.  We had not implemented support for the PostgreSQL uuid type.

I have committed support for uuid and it will be included in nightly builds dated 14 Jan 2010 and above, available from about 1500 GMT from the downloads page (free edition) or the store (retail edition).  Please let us know if you still see problems.

Hi

I see the page (free edition) has been uploaded 14 jan but the store (retail edition) is still on 12 jan. Is there any reason for this?

Regards,

Hi,

A quick check here shows the retail nightlies for LightSpeed 3.0 to be up to date (showing the 15th now). As you're not posting in the forum with the account your software was purchased with I cannot investigate your account to see which edition you have to ensure what I'm seeing is correct.

Could you please let me know either the username the software was purchased under, or the full name of the product that is having issues with the retail nightly builds please?

Thank you,

John-Daniel Trask

Hi

I was able to download the nightly build about an hour later.

Thank you.

Hi

When querying data from a view with a id type uuid in PostgreSQL I get the following message.

Exception:

Unable to materialize field [Id] on type [MK.Repository.Web.Batch]. Check your table has an Id column and that your mappings are correct. See inner exception for details.

Inner Exception:
"Unable to cast object of type 'System.Guid' to type 'System.String'."

How is your Batch entity declared?  Is it Entity<Guid> or Entity<string>?

If the latter: you should be able to fix this by changing the identity type to Guid.  (Did the designer import the view as Entity<string>?  If so please let us know as this may be an import bug.)

If the former: could you post the entity code (from the generated C# file) and the PostgreSQL CREATE TABLE script so we can try to reproduce this please?  Thanks!