Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
--
Thanks & Regards,Ashesh VashiEnterpriseDB INDIA: Enterprise PostgreSQL Company
http://www.linkedin.com/in/asheshvashi
Hi!I got a problem when I create a table of type by table creation interface of pgadmin.Because OF TYPE without SCHEMA specified, the table creation failed.I think the type should have schema specified when its schema being not ‘public’, please check.A example as follow First step:CREATE TYPE test.person AS( id integer, name character varying COLLATE pg_catalog."POSIX"); Second step: type has no schema specified : Then I click button OK, it got error as follow: At last, I add schema to type, then successfully: CREATE TABLE test.testOF test.personWITH ( OIDS = FALSE); Best regard!Yours,Jasmine
Hi!
I got a problem when I create a table of type by table creation interface of pgadmin.
Because OF TYPE without SCHEMA specified, the table creation failed.
I think the type should have schema specified when its schema being not ‘public’, please check.
A example as follow
First step:
CREATE TYPE test.person AS
(
id integer,
name character varying COLLATE pg_catalog."POSIX"
);
Second step:
type has no schema specified :
Then I click button OK, it got error as follow:
At last, I add schema to type, then successfully:
CREATE TABLE test.test
OF test.person
WITH (
OIDS = FALSE
Best regard!
Yours,
Jasmine
В списке pgsql-admin по дате отправления: