I can not reproduce!
For me it works successfully.
1. create schema vk1
2. CREATE TABLE vk1.t1 (c1 bigint);
3. create schema vk2
4. copy schema tables vk1
5. paste into vk2 -- OK
6. paste into vk1 -- OK
Vladimir Kokovic, DP senior, Belgrade, Serbia
On 7/19/11, Guillaume Lelarge <guillaume(at)lelarge(dot)info> wrote:
> On Sun, 2011-07-17 at 23:17 +0200, Vladimir Kokovic wrote:
>> > Now that we can copy on the same schema, it shouldn't ask for an
>> > extension, but for the complete name.
>> I do not know how to do when the table has objects that each has a name!
>> CREATE TABLE gk_vrsta_naloga_vk --NAME1
>> id bigint NOT NULL DEFAULT
>> nextval('"''id_gk_vrsta_naloga''"'::regclass), --NAME2
>> sifra character varying NOT NULL DEFAULT ''::character varying,
>> CONSTRAINT gk_vrsta_naloga_vk_pkey PRIMARY KEY (id), --NAME3
>> CONSTRAINT unique_gk_vrsta_naloga_vk1 UNIQUE (sifra, id), --NAME4
>> CONSTRAINT unique_gk_vrsta_naloga_vk2 UNIQUE (id, sifra), --NAME5
>> ... --NAMEn
>> WITH (
>> Suffix is much better solution ...
> Good point.
> I tried a few other things and it seems pretty solid. One of my tests
> got a segfault: I copy all tables (4) in a schema, create a schema,
> paste the tables in the schema. Segfault directly.
> So I tried with a really small schema: only one object, a table,
> declared this way: "CREATE TABLE t1 (c1 bigint);". With the previous
> steps, I got a crash.
> The threading is a great idea but it makes things a lot harder.
In response to
pgadmin-hackers by date
|Next:||From: Guillaume Lelarge||Date: 2011-07-20 06:27:15|
|Subject: Re: Copy/Paste table(s) functions - git context
|Previous:||From: Guillaume Lelarge||Date: 2011-07-19 21:36:46|
|Subject: Re: pgAdmin III commit: Database Designer
(milestone 1 of GSoC 2011)|