Re: [GENERAL] Complex database infrastructure - how to?

Em 30/06/2012 22:02, Misa Simic escreveu: Hi Edson, Maybe the best option is what Jack has already suggested, to have all in 1 DB in separate schemas (if tables are not already organised in separated schemas...)... But I am not sure I understand well problems: 2012/6/30 Edson Richter

[GENERAL] ARD update warning (Mac stuff)

If you install the latest ARD update (which does not require a reboot), it apparently does something similar to: sudo killall postmaster Oops. Thanks, Apple. -- Scott Ribe scott_r...@elevated-dev.com http://www.elevated-dev.com/ (303) 722-0567 voice -- Sent via pgsql-general mailing list

Re: [GENERAL] Complex database infrastructure - how to?

Hi Edson, Maybe the best option is what Jack has already suggested, to have all in 1 DB in separate schemas (if tables are not already organised in separated schemas...)... But I am not sure I understand well problems: 2012/6/30 Edson Richter > 1) Copy tables from Administrative to Application:

Re: [GENERAL] Complex database infrastructure - how to?

Em 30/06/2012 12:38, Jack Christensen escreveu: On 6/30/2012 9:25 AM, Edson Richter wrote: I've a plan that will need a complex database infra-structure using PostgreSQL 9.1. I've seen similar setups using MS SQL Server and other databases, but all of them support cross database queries (also e

Re: [GENERAL] how to return results from code block

Hi Andrus, What is the main goal? Actually what is the reason that you need to execute, and get result in ADO.NET from code block? How I see code block feature, it is more to make easier dev & test of an procedural language function inside code block... Then when we are happy with result, actually

Re: [GENERAL] how to return results from code block

On 06/30/2012 07:37 AM, David Johnston wrote: On Jun 30, 2012, at 10:18, Adrian Klaver mailto:adrian.kla...@gmail.com>> wrote: Besides what Pavel said about not returning a result there is another issue with the above. It did not specify a language. I cleaned the function up a bit: The lack

Re: [GENERAL] Complex database infrastructure - how to?

On 6/30/2012 9:25 AM, Edson Richter wrote: I've a plan that will need a complex database infra-structure using PostgreSQL 9.1. I've seen similar setups using MS SQL Server and other databases, but all of them support cross database queries (also easy to implement with materialized views). - A

Re: [GENERAL] how to return results from code block

On Jun 30, 2012, at 10:18, Adrian Klaver wrote: > > Besides what Pavel said about not returning a result there is another issue > with the above. It did not specify a language. I cleaned the function up a > bit: > The lack of a language is not a problem since the command definition makes it

[GENERAL] Complex database infrastructure - how to?

I've a plan that will need a complex database infra-structure using PostgreSQL 9.1. I've seen similar setups using MS SQL Server and other databases, but all of them support cross database queries (also easy to implement with materialized views). - Administrative database: have few tables, use

Re: [GENERAL] how to return results from code block

On 06/30/2012 03:17 AM, Andrus wrote: How to return single row or results from code block executed using ADO.NET ExecuteQuery() method. I tried DO $$ declare i integer :=0; begin select i+1 as res1, i+2 as res2; END$$; but got error: ERROR: query has no destination for result data How to retur

Re: [GENERAL] how to return results from code block

On 06/30/2012 03:17 AM, Andrus wrote: How to return single row or results from code block executed using ADO.NET ExecuteQuery() method. I tried DO $$ declare i integer :=0; begin select i+1 as res1, i+2 as res2; END$$; but got error: ERROR: query has no destination for result data How to retur

[GENERAL] How to insert record only if primary key does not exist

Table is defined as CREATE TABLE firma1.klient ( kood character(12) NOT NULL DEFAULT nextval('firma1.klient_kood_seq'::regclass), ); How to insert record to this table only if primary key does not exist ? I tried code below but got strange error as shown in log file. Why this error occurs

Re: [GENERAL] how to return results from code block

Hello 2012/6/30 Andrus : > How to return single row or results from code block executed using ADO.NET > ExecuteQuery() method. > I tried > > DO $$ > declare >   i integer :=0; > > begin > select i+1 as res1, i+2 as res2; > END$$; > > but got error: > > ERROR:  query has no destination for result d

[GENERAL] how to return results from code block

How to return single row or results from code block executed using ADO.NET ExecuteQuery() method. I tried DO $$ declare i integer :=0; begin select i+1 as res1, i+2 as res2; END$$; but got error: ERROR: query has no destination for result data How to return single row result from code pg

Re: [GENERAL] Postgresql 9.0.6 alway run VACUUM ANALYZE pg_catalog.pg_attribute

Thanks for your help I don't create and drop alot of tables.7 Here is my config "version";"PostgreSQL 9.0.6, compiled by Visual C++ build 1500, 64-bit" "autovacuum_analyze_threshold";"250" "autovacuum_vacuum_threshold";"1000" "bytea_output";"escape" "checkpoint_segments";"64" "client_encoding";"UN