I am trying to migrate an Access 97 database to PostgreSQL 7.3 using
pgAdmin 1.4.12 and the Migration Wizard 1.4.12. I want to keep using
the Access 97 front end connected to the PostgreSQL backend.
The default type mapping didn't work for me but I discovered that
mapping
Boolean -> int2 (in
> -Original Message-
> From: Matej Rizman [mailto:[EMAIL PROTECTED]
> Sent: 12 July 2003 21:09
> To: [EMAIL PROTECTED]
> Subject: [pgadmin-support] BUG: pgAdmin III - Vacuuming
> executes incorrect statement
>
>
> Version: pgAdmin III, version 0.8.0 Devel (Jul 10 2003).
>
> Steps to
Version: pgAdmin III, version 0.8.0 Devel (Jul 10 2003).
Steps to reproduce error:
1) connect to database
2) select arbitrary table
3) Tools->Reorganize
4) Select Vacuum (or Analyze, this causes similar error) in dialog box
5) Press Ok.
pgAdmin III executes the following statement to PostgreSQL:
Title: Message
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 11 July 2003 10:11To:
[EMAIL PROTECTED]Subject: [pgadmin-support] Error
Message
-- Error Information
--Description: ERROR: parser: parse error at or near "(" at
character
> -Original Message-
> From: George T. Gibson [mailto:[EMAIL PROTECTED]
> Sent: 10 July 2003 20:33
> To: [EMAIL PROTECTED]
> Subject: [pgadmin-support] pgadminIII bug
>
>
> When trying to alter a sequence value, the below SQL is issued...
>
> SELECT setval(public.part_part_id_key, 347
It's rumoured that Marcos Tadeu P Vargens once said:
>
> Description: Control array element '1' doesn't exist
> Number: 340
> Routine: pgAdmin II:frmSQLOutput.cmdDelete_Click
Hi,
Can you recreate this error with logging set to Full Debug and send the
resulting logfile
It's rumoured that ±è°æ¼ö once said:>
> Description: ERROR: must be called under standalone postgres with -O
> -P options
Number: -2147467259
> Routine: pgAdmin II:basActions.Reindex
Hi,
What table were you trying to reindex when this error occured?
Regards, Dave
---
-- System Information --Platform: Windows 2000Version:
5.0Build: 2195 Service Pack 3-- Application Information
--Name: pgAdmin IIVersion: 1.5.60Descripton: Name:
pgSchemaVersion: 1.5.60Descripton: PostgreSQL Schema Objects
v1.5.60-- Database Information --Version: 7.3.3Descripton:
Postgre
-- System Information --
Platform: Windows 2000
Version:5.0
Build: 2195 Service Pack 3
-- Application Information --
Name: pgAdmin II
Version:1.5.60
Descripton:
Name: pgSchema
Version:1.5.60
Descript
-- System Information --Platform: Windows
2000Version: 5.0Build: 2195 Service Pack 4-- Application
Information --Name: pgAdmin IIVersion: 1.5.60Descripton:
Name: pgSchemaVersion: 1.5.60Descripton: PostgreSQL Schema
Objects v1.5.60-- Database Information --Version:
7.3.2Descripton:
"Dave Page" <[EMAIL PROTECTED]> writes:
> Well I always thought you could overload functions in this way, however
> with your example below, although it creates it OK, PostgreSQL (not
> pgAdmin) gives the error 'ERROR: There is more than one function named
> textcat'.
I see no such error here ...
-- System Information --Platform: Windows
2000Version: 5.0Build: 2195 Service Pack 3-- Application
Information --Name: pgAdmin IIVersion: 1.5.60Descripton:
Name: pgSchemaVersion: 1.5.60Descripton: PostgreSQL Schema
Objects v1.5.60-- Database Information --Version:
0.0.0Descripton: -- Drive
12 matches
Mail list logo