Re: [ADMIN] dblink question about duplicate connection

2011-08-02 Thread Joe Conway
On 08/02/2011 05:36 AM, francescobocca...@libero.it wrote: > Somentimes happend that an error accours in insert data and when i try to run > new insert posgresql return and error like duplicate connection. > I would like to change my functions in this way: > If 'conn_test' exist PERFORM dbl

Re: [ADMIN] migration wizard faild

2011-08-02 Thread Kevin Grittner
Gustav Redin wrote: > EnterpriseDB - MySQL to PostgreSQL Migration Wizard > system:windows > db:MySQL ver 4.0 > connection ok > 4. Source schema "No schema/tables in this view" > Not support MySQL ver 4.0 ? > or is it some other problems? If you don't get a useful response

[ADMIN] migration wizard faild

2011-08-02 Thread Gustav Redin
EnterpriseDB - MySQL to PostgreSQL Migration Wizard system:windows db:MySQL ver 4.0 I try... connection ok 4. Source schema "No schema/tables in this view" Not support MySQL ver 4.0 ? or is it some other problems? best regards Gustav -- Sent via pgsql-admin mailing lis

[ADMIN] dblink question about duplicate connection

2011-08-02 Thread francescobocca...@libero.it
Dear all, i have a question about dblink connection.I use it in a trigger function : CREATE OR REPLACE FUNCTION setuser() RETURNS trigger AS $BODY$ DECLARE BEGIN IF (TG_OP = 'INSERT') THEN PERFORM dblink_connect('conn_test', 'dbname=database_test'); PERFORM dblink_exec(

Re: [ADMIN] Gbtreekey16 type

2011-08-02 Thread Lukasz Brodziak
Got it thanks a lot. 2011/8/2 Jerry Sievers > Lukasz Brodziak writes: > > > Hello, > > > > I have a question regarding type gbtreekey16. What it exactly is used > for?? > > Read up on the following contrib package which defines it... > > btree_gist - >Support for emulating BTREE indexin

Re: [ADMIN] Gbtreekey16 type

2011-08-02 Thread Jerry Sievers
Lukasz Brodziak writes: > Hello, > > I have a question regarding type gbtreekey16. What it exactly is used for?? Read up on the following contrib package which defines it... btree_gist - Support for emulating BTREE indexing in GiST > > -- > ???ukasz Brodziak > "Do you bury me when I'm

[ADMIN] Gbtreekey16 type

2011-08-02 Thread Lukasz Brodziak
Hello, I have a question regarding type gbtreekey16. What it exactly is used for? -- Ɓukasz Brodziak "Do you bury me when I'm gone Do you teach me while I'm here Just as soon I belong Then it's time I disappear"