[SQL] Cross-database references

Title: AIP - Assessoria Informática e Proteção LTDA Someone knows how is going the implementation of cross database references in pgsql ? Would have some future release with this great functionality ?   Thanks,   Pedro Igor

[SQL] PostgreSQL + SSL

I´m trying to config PG with SSL, but i got a error. I create the key and the certificate and put both in $PGDATA directory. I also enabled the ssl option in postgresql.conf. But when i run postmaster i got a error saying that server.key has wrong permissions.   Thanks,   Pedro Igor

[SQL] Function unkown

How is this function ? plpgsql_call_handler() RETURNS language_handler AS 'plpgsql_call_handler' LANGUAGE 'c' VOLATILE; ---Outgoing mail is certified Virus Free.Checked by AVG anti-virus system (http://www.grisoft.com).Version: 6.0.443 / Virus Database: 248 - Release Date: 1/10/2003

[SQL] Data between different databases

I would like to know in how can i reference a table in a database A from a database B. In resume, i want to separate the data in my database in two others databases and make references for them.   Thanks,   Pedro Igor   ---Outgoing mail is certified Virus Free.Checked by AVG anti-virus

[SQL] Query

    I have tried : check (select count(b.id) from B b where b.id = id) <> 0) but doesn´t work ..     I can use trigger here, but i don´t know if is the best solution .      Thanks,           Pedro Igor   

[SQL] PostgreSQL X Resin EE

Have someone used Resin EE with PostgreSQL or actually use both for building applications ? About PostgreSQL i know that is one of the best options for back-end, but what about Resin EE ?   Thanks ...   Pedro Igor 

[SQL] Accent-insensitive

Does have PostgreSQL some option to allow me execute selects accent-insensitive ? I can´t find any reference, including the manual   Pedro Igor

[SQL] Case-insensitive

Someone knows how config the postgresql for case-insensitive mode ?   Pedro Igor

[SQL] SQL QUERY

bles and not only to tbale teste. Someone know how ???   Pedro Igor  

[SQL] System´s database table

I´m looking for the name of the table that contains all databases in my system. I already see this in the postgre manual, but i´m forgot where   Tanks ...   Pedro Igor