Обсуждение: Data insert & column name problems

Поиск
Список
Период
Сортировка

Data insert & column name problems

От
"Michal Unzeitig"
Дата:
PgAdmin 1.2.0 beta on Win32

-- I'm unable to add new records in empty table in data view;
after I use manual INSERT INTO for first row, than I works (* row appears)

-- when creating table/adding column of varchar type, the "varchar" is
quoted which causes error



Re: Data insert & column name problems

От
"Dave Page"
Дата:

> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of
> Michal Unzeitig
> Sent: 16 September 2004 13:47
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Data insert & column name problems
>
> PgAdmin 1.2.0 beta on Win32
>
> -- I'm unable to add new records in empty table in data view;
> after I use manual INSERT INTO for first row, than I works (*
> row appears)

I'm unable to recreate this - does it happen for all tables? Can you
supply the SQL used to create the table and any associated indexes etc
please?

> -- when creating table/adding column of varchar type, the
> "varchar" is quoted which causes error

There is a known quoting bug that will have caused this - it's fixed in
cvs and should be in the latest snapshot at
http://pgadmin.postgresql.org/snapshots/win32/

Regards, Dave.