[SQL] schema proxying virtual database
[ sorry if it is a repost, i am not sure if i am subscribed in -general ] Dear List, There are many opensource applications that support postgresql (eg , gforge , bricolage , dspam ..) but does not use schemas(namespaces) as a result of which you are forced to use/create a new database and loose the advantage of linking the application data with your existing database. as no-cross database queries can be done in PG. my question is , is it a feasible idea to have some special kind of database in the postgresql cluster that mimics a schema of an existsing database. say rt3 is a special database that links to existing maindb databases' rt3 namespace then any DDL / DML done to public schema of rt3 database is redirected to rt3 namespace of the existing database maindb's rt3 schema. regds mallah.
[SQL] Serious problems with non-primary foreign keys
I'm having some serious problems using PostgreSQL with symfony and Doctrine. Here is the error that I've been fighting with for the last couple of days: SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block. Failing Query: CREATE INDEX company_id ON sf_guard_user_profile (company_id) It seems to affect every single non-primary foreign key. Turning the key to primary foreign fixes the problem but I don't want it to be primary. I can't think of any logical reason why this error would happen. Generally there's nothing wrong with using a non-primary (not null) foreign key. But Postgre seems to think there is. I know PostgreSQL creates an index for every primary key. Since turning the key also into primary seems to fix it, should I just define an index for it? I've tried it but nothing changes. Here's the relevant SQL: CREATE TABLE sf_guard_user_profile (id BIGINT, company_id BIGINT NOT NULL, PRIMARY KEY(id)); CREATE TABLE company (company_id INT, PRIMARY KEY(company_id)); Any ideas on how to fix this? Thank you, janneaa
Re: [SQL] Talend : Talend Integration Suite vs Talend Open Studio
Hi. Here is what I have to say about the comparison between both programs. Is using Talend Integration Suite really better compared to using Talend Open Studio? There are advanced features in the open studio: group work, joblets, automatic documentation, advanced wizards... For Integration Suite: line command, monitoring console, scheduler. Support is included with Talend Integration Suite (it is a guaranteed support, compared to the community help on the forum-already of a very good level). On what kind of project can you not use Talend Open Studio and would be best to use Talend Integration Suite? As soon as you start working with several people on the same project or you would like to use the editor's support, that's when Talend Inegration Suite is the right solution. Is Talend Open Studio as performant as Talend Integration Suite? Yes, Talend Open Studio is a full version of Talend Integration Suite comparing performance between both tools. On same jobs, you will find the exact same results with either tool. Go look at the comparison matrix between both tools: http://www.talend.com/products-data-integration/matrix.php Rstat wrote: > > > Hi all, > > I have been working with Talend Open Studio for a few weeks now and would > like to have your opinion. > > Is using Talend Integration Suite really better compared to using Talend > Open Studio? On what kind of project can you not use Talend Open Studio > and would be best to use Talend Integration Suite? > > Thanks a lot for your answers. > Have a good day! > -- View this message in context: http://www.nabble.com/Talend-%3A-Talend-Integration-Suite-vs-Talend-Open-Studio-tp25382800p25398102.html Sent from the PostgreSQL - sql mailing list archive at Nabble.com. -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
Re: [SQL] Serious problems with non-primary foreign keys
On Friday 11 September 2009 6:26:13 am Janne wrote: > I'm having some serious problems using PostgreSQL with symfony and > Doctrine. Here is the error that I've been fighting with for the last > couple of days: SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: > current transaction is aborted, commands ignored until end of transaction > block. Failing Query: CREATE INDEX company_id ON sf_guard_user_profile > (company_id) It seems to affect every single non-primary foreign key. > Turning the key to primary foreign fixes the problem but I don't want it to > be primary. I can't think of any logical reason why this error would > happen. Generally there's nothing wrong with using a non-primary (not null) > foreign key. But Postgre seems to think there is. I know PostgreSQL creates > an index for every primary key. Since turning the key also into primary > seems to fix it, should I just define an index for it? I've tried it but > nothing changes. Here's the relevant SQL: CREATE TABLE > sf_guard_user_profile (id BIGINT, company_id BIGINT NOT NULL, PRIMARY > KEY(id)); CREATE TABLE company (company_id INT, PRIMARY KEY(company_id)); > Any ideas on how to fix this? Thank you, > janneaa I think more information is required. First the complete transaction. Second the complete error message, especially the part that explains what is causing the CREATE INDEX command to fail. Third I do not see a FOREIGN KEY reference in the SQL you posted. -- Adrian Klaver [email protected] -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
