Thread: Error Message: ERROR: CREATE TABLE/DEFAULT multiple values specified for 'format.format_id'

 
-- System Information --

Platform: Windows XP
Version: 5.1
Build: 2600 Service Pack 1

-- Application Information --

Name: pgAdmin II
Version: 1.6.0
Descripton:

Name: pgSchema
Version: 1.6.0
Descripton: PostgreSQL Schema Objects v1.6.0

-- Database Information --

Version: 7.3.2
Descripton: PostgreSQL 7.3.2 on i386-redhat-linux-gnu, compiled by GCC i386-redhat-linux-gcc (GCC) 3.2.2 20030213 (Red Hat Linux 8.0 3.2.2-1)

-- Driver Information --

Name: PostgreSQL
Version: 7.3.100
Descripton: PostgreSQL 7.3.2 on i386-redhat-linux-gnu, compiled by GCC i386-redhat-linux-gcc (GCC) 3.2.2 20030213 (Red Hat Linux

-- Error Information --

Description: ERROR:  CREATE TABLE/DEFAULT multiple values specified for 'format.format_id'
Number: -2147467259
Routine: pgAdmin II:frmTable.cmdOK_Click

************************************************************

Insert your comment:
It's rumoured that Jeffrey Hulten once said:
>
> -- System Information --
>
> Platform: Windows XP
> Version: 5.1
> Build: 2600 Service Pack 1
>
> -- Application Information --
>
> Name: pgAdmin II
> Version: 1.6.0
> Descripton:
>
> Name: pgSchema
> Version: 1.6.0
> Descripton: PostgreSQL Schema Objects v1.6.0
>
> -- Database Information --
>
> Version: 7.3.2
> Descripton: PostgreSQL 7.3.2 on i386-redhat-linux-gnu, compiled by GCC
> i386-redhat-linux-gcc (GCC) 3.2.2 20030213 (Red Hat Linux 8.0 3.2.2-1)
>
> -- Driver Information --
>
> Name: PostgreSQL
> Version: 7.3.100
> Descripton: PostgreSQL 7.3.2 on i386-redhat-linux-gnu, compiled by GCC
> i386-redhat-linux-gcc (GCC) 3.2.2 20030213 (Red Hat Linux
>
> -- Error Information --
>
> Description: ERROR:  CREATE TABLE/DEFAULT multiple values specified for
> 'format.format_id' Number: -2147467259
> Routine: pgAdmin II:frmTable.cmdOK_Click

Hi Jeffrey,

Does this error occur repeatedly? If so, can you please switch on logging
to SQL & Errors (under tools -> options) recreate the error and post the
logfile?
Regards, Dave.