Hi,
i mailed to the postgresql-general list in order to clearify, why there
is no full alter table/alter column command yet. One cannot change the
column-type of a column with one command. You need to create a new
column, copy data, delete the old one, recreate all constraints, indexes
etc.
T
Title: Message
-Original Message-From: Marcel de Vries
[mailto:[EMAIL PROTECTED] Sent: 16 June 2003 12:51To:
[EMAIL PROTECTED]Subject: [pgadmin-support] Error
MessageDescription: Object requiredNumber: 424Routine:
pgAdmin
II:frmIndex.cmdOK_Click
It's alright - I'm just testing a fix for this.
Regards, Dave.
> -Original Message-
> From: frank_lupo [mailto:[EMAIL PROTECTED]
> Sent: 16 June 2003 13:10
> To: marcel
> Cc: pgadmin-support
> Subject: Re: [pgadmin-support] Error Message
>
>
> >-- Error Information --
>
> >
>
> >Desc
>-- Error Information --
>
>Description: Object required
>Number: 424
>Routine: pgAdmin II:frmIndex.cmdOK_Click
> While trying to create (second within a minute) a index
Can you send some full debug logs from pgAdmin please?
Log settings are under Tools -> Options.
Bye !!
Frank Lupo (Wolf) !!
-- System Information --Platform: Windows XPVersion:
5.1Build: 2600 Service Pack 1-- 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:
PostgreSQ
Title: Message
Wow,
that is odd. It seems to be running the 7.2 query on your 7.3 database (this is
7.3.x isn't it?). What comes out of psql on the server if you
run:
SELECT
version();
(exactly, don't change any dot's of commas or
anything)
Regards, Dave.
-Original Message--
Title: Message
Hi Dave,
The log includes the
following entries:
2003-06-16 12:20:03 - SQL
(template1): SELECT oid, *, pg_encoding_to_char(encoding) AS encodingname, pg_get_userbyid(datdba)
AS datowner FROM pg_database ORDER BY datname
2003-06-16 12:20:03 - SQL (mb):
SELECT objo
Title: Message
Hi
Christian,
That's
an odd one - can you please send me a Full Debug logfile showing the error
occuring? Log settings are under Tools -> Options.
Thanks, Dave.
-Original Message-From: Christian Brosig
[mailto:[EMAIL PROTECTED] Sent: 16 June 2003
10:35To
Hi,
I use postgres now for about 1 Year and i am really
happy with postgres (7.2).
I use Linux as database server and pgAdmin as frontent.
Last week I set up a new server. Included in the new linux
distribution is also a newer version of postgres (7.3.2)
I used pg_dump to export a
