[GENERAL] Question of postgresql

) -- There is no connection to the backend.' in line 194       Is there any way to configure the connection to keep a long times?    or Is there any way to resolve it?     Thanks!   kent 2000/09/11   end

[GENERAL] import plpy

dinary interpreter." I've been unable to locate such a thing. Suggestions? Thanks, Kent -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] what could be blocking an insertion?

the serializable isolation level. A day or so later the problem was gone. Any idea? I need to prevent it from happening again. Thanks! - -- Kent Tong Wicket tutorials freely available at http://www.agileskills2.org/EWDW -- View this message in context: http://www.nabble.com/what-could-be

[GENERAL] Accessing a db with pgAdmin

Background - I am having a problem accessing a remote postgreSQL db from my laptop using an ssh tunnel and pgAdmin. I had postgreSQL loaded on my computer for use as a test db, but removed it. Including deleting the postgeSQL, and pgadmin directories after using the windows applications removal too

[GENERAL] logging of transaction related events

Hi, Is it possible to log events related to transactions, in particular, about blocking? For example: INFO: transaction 123 is blocked waiting for locked held by transaction 456. Thanks! - -- Kent Tong Wicket tutorials freely available at http://www.agileskills2.org/EWDW -- View this

[GENERAL] shared data for different applications

Hi, Let's say that there is some data that should be logically shared by many applications in the company, such as some core information about its customers (name, address, contact info). In principle, such data should be stored in a DB for sharing. But then if a certain application needs to acc

[GENERAL] shared data for different applications

Hi, Let's say that there is some data that should be logically shared by many applications in the company, such as some core information about its customers (name, address, contact info). In principle, such data should be stored in a DB for sharing. But then if a certain application needs to acc

Re: [GENERAL] shared data for different applications

Hi Alban, Thanks a lot for your useful info! > I think most companies have ended up at that point just by the progress > of time. They have several different databases (often from different > vendors even) that they need to aggregate their information from. So, is this the result of lack of cent

[GENERAL] do the files in pg_xlog differ in master and slave?

pg_xlog files are copied, would it cause the "timeline xx of the primary does not match recovery target timeline yy" error? Why? Thanks! -- Kent Tong IT author and consultant, child educator

[GENERAL] postgresql's MVCC implementation

l. Any idea? Thanks in advance! - -- Kent Tong Wicket tutorials freely available at http://www.agileskills2.org/EWDW Axis2 tutorials freely available at http://www.agileskills2.org/DWSAA -- View this message in context: http://www.nabble.com/postgresql%27s-MVCC-implementation-tp18302020p1830

Re: [GENERAL] postgresql's MVCC implementation

as if they were when the transaction started. If it is the case, why? Is MVCC not well defined? Could say Oracle or MS SQL implement it differently? - -- Kent Tong Wicket tutorials freely available at http://www.agileskills2.org/EWDW Axis2 tutorials freely available at http://www.agileskills2.

Re: [GENERAL] postgresql's MVCC implementation

SQL. I've read http://www.postgresql.org/docs/8.3/interactive/transaction-iso.html and wondering if there is any more detailed description. Thanks! - -- Kent Tong Wicket tutorials freely available at http://www.agileskills2.org/EWDW Axis2 tutorials freely available at http://www.agileskills2.org/DWSAA

[GENERAL] how to specify the locale that psql uses

ot; but it doesn't seem to work on the Windows port of PostgreSQL. Thanks for any help! - -- Kent Tong Wicket tutorials freely available at http://www.agileskills2.org/EWDW Axis2 tutorials freely available at http://www.agileskills2.org/DWSAA -- View this message in context: http://www

Re: [GENERAL] how to specify the locale that psql uses

Reg Me Please wrote: > > psql --help ? > which option you're referring to? I tried --locale but it had no effect. - -- Kent Tong Wicket tutorials freely available at http://www.agileskills2.org/EWDW Axis2 tutorials freely available at http://www.agileskills2.org/DWSAA

Re: [GENERAL] how to specify the locale that psql uses

ing to the locale on the client that determines the text prompts it outputs. - -- Kent Tong Wicket tutorials freely available at http://www.agileskills2.org/EWDW Axis2 tutorials freely available at http://www.agileskills2.org/DWSAA -- View this message in context: http://www.nabble.com/how-

Re: [GENERAL] how to specify the locale that psql uses

I've read the chapter you quoted before posting for help and it didn't apply to the issue. - -- Kent Tong Wicket tutorials freely available at http://www.agileskills2.org/EWDW Axis2 tutorials freely available at http://www.agileskills2.org/DWSAA -- View this message in context:

[GENERAL] changing the locale of the DB cluster

Hi, I know that it is impossible to change the locale. But can I pg_dump all the databases, run initdb again using the desired locale, and then pg_restore? - -- Kent Tong Wicket tutorials freely available at http://www.agileskills2.org/EWDW Axis2 tutorials freely available at http

[GENERAL] Stored Procedures

call the stored procedure from there to get the safety of a transaction?   Thanks Kent Anderson EZYield.com 407-629-0900 www.ezyield.com   This electronic message transmission contains information from the Company that may be proprietary, confidential and/or

[GENERAL] time out in blocking

to get this time out effect? Thanks in advance! -- Kent Tong, M.Sc., MCSE, MCP+I FREE advice to enhance your business with IT FREE catalogue of IT products in the Macau market Go to http://www.cpttm.org.mo/itob NOW!