Radicore Forum: How To » Multi servers and PostgreSQL

Home » RADICORE » How To » Multi servers and PostgreSQL

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: Multi servers and PostgreSQL [message #7255 is a reply to message #7251]

Thu, 07 February 2019 05:02

AJM
Messages: 2347
Registered: April 2006
Location: Surrey, UK

Senior Member

PostgreSQL is peculiar in that it has the hierarchy server->database->schema->table instead of the common server->database->table. Tables are known as "database tables" and not "schema tables", so the introduction of a level between "database" and "table" is clearly non-standard and IMHO clearly wrong. I have yet to see a method of switching between one database and another in postgres within the same connection, so Radicore does not support this. This means that all the schemas which you wish to access *MUST* reside in the same database. It is possible to open multiple connections to different servers, but it is not possible for a single database transaction to span multiple connections.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

[Message index]

		Multi servers and PostgreSQL By: pdv on Wed, 06 February 2019 12:46
		Re: Multi servers and PostgreSQL By: AJM on Thu, 07 February 2019 05:02
		Re: Multi servers and PostgreSQL By: pdv on Thu, 07 February 2019 07:46
		Re: Multi servers and PostgreSQL By: AJM on Fri, 08 February 2019 05:08
		Re: Multi servers and PostgreSQL By: pdv on Sat, 09 February 2019 14:17
		Re: Multi servers and PostgreSQL By: AJM on Mon, 11 February 2019 04:45

Previous Topic:	$lock_str FOR UPDATE FOR $tablename with PostgreSQL
Next Topic:	convert_parent_id_to_child_id

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Apr 27 17:56:09 EDT 2024

Total time taken to generate the page: 0.00849 seconds