Postgres Pro
Downloads
Home   >   mailing lists

RE: CREATE TYPE error in PostgreSQL database!!!!!! - Mailing list pgsql-admin

From ldh@laurent-hasson.com
Subject RE: CREATE TYPE error in PostgreSQL database!!!!!!
Date
Msg-id MN2PR15MB25603D7EC31C4B129CE6D96385499@MN2PR15MB2560.namprd15.prod.outlook.com
Whole thread Raw
In response to CREATE TYPE error in PostgreSQL database!!!!!!  (Ashok Kumar Mani <ashokkumar.mani@dnata.com>)
List pgsql-admin
Tree view

 

 

From: Ashok Kumar Mani <ashokkumar.mani@dnata.com>
Sent: Monday, January 03, 2022 02:40
To: pgsql-admin@postgresql.org
Subject: CREATE TYPE error in PostgreSQL database!!!!!!

 

Hi Team

While creating function I have encountered the below error in PostgreSQL database.

 

I need to know how to use the array declaration in Type datatype in postgreSQL database. Could you please help or share some exmple to use it?

 

  1. Need to create type
  2. Declare array variable in type datatype.

 

ERROR: syntax error at or near "c_db_fieldvalues" LINE 113: ... fetch usage_cursor into c_db_fieldvalues c_db_field... ^ SQL state: 42601 Character: 9447

 

Thanks & Best Wishes,

Ashok

 

 

 

 

[Laurent Hasson]

Can you post your code that’s erroring out?

pgsql-admin by date:

Previous
From: Holger Jakobs
Date:
Subject: Re: CREATE TYPE error in PostgreSQL database!!!!!!
Next
From: Wells Oliver
Date:
Subject: pg_restore with --use-list and --jobs and depdendencies