PostgreSQL

PHP configuration modification: In the php. ini file ; Extension = php_pdo_pgsql.dll ; Extension = php_pgsql.dll The semicolon above is logged out. Check whether the path of extension_dir = "./EXT/" is correct (the path is used to load the.

Original article address: Use PostgreSQL stored procedures and views in openerp   The steps for openerp to use PostgreSQL stored procedures and attempts are as follows: Step 1: Define the stored procedure in the module's init Function DefInit

In the standard of SQL, the transaction isolation level is divided into the following four types:1. Read uncommitted)2. Read committed)3. Repeatable read)4. serializable)However, PostgreSQL versions earlier than 9.1 only implement two of them: Read

I. Basic concepts: SQL functions can contain any number of queries, but the function returns only the results of the last query (which must be select. In simple cases, the first row of the last query result is returned. If no row is returned for

The default maximum number of connections in PostgreSQL is 200. If the number of connections exceeds 200, so many clients alreay will be reported. Of course, you can view the current maximum number of connections through show max_connections;  

Sometimes, when installing PostgreSQL windows, it will fail to create a Windows service. After you cancel the "Install as service" option, how can you manually install it as a service? 1. first, check the user, that is, the user who starts the

After a new user is added, if the user is allowed to access the database? 1. Add the configuration in HBA. config. If there is a general configuration, it does not need to be processed. For example, if the user item is "all" 2. The new user is not

There is an article on searchopensource.com ArticleThe title is five reasons why you should not use PostgreSQL. Of course, the author is clarifying why PostgreSQL, although many comments are far more technical than MySQL, has not seen a large

Detailed analysis of postgresql yesterday today and tomorrow http://database.51cto.com/art/200708/53762.htm Evaluate the advantages and disadvantages of MySQL and PostgreSQL http://database.51cto.com/art/200612/36844.htm PostgreSQL installation

Original article link PostgreSQL 8.1 Chinese Document Connect to the database. The default user and database are ipvs.Psql-u user-D dbname \ C dbname: equivalent to MySQL's use dbname \ L lists databases, which is equivalent to MySQL's show

① To The http://www.postgresql.org/download the no installer version of postgresql for win. The latest version is 8.2.5-1. Directly decompress the package. For example:C: \ PostgreSQL② Set Environment VariablesC:> set pghome = c: \ PostgreSQLC:> set

I have been using Oracle and PostgreSQL for several years and have been trying to use many advanced features in Oracle in PostgreSQL. Therefore, I have been paying attention to this issue. Below I will first sort out three points, it will be

The Installation Process of postgresql in Windows is complicated (this article specifically refers to versions earlier than 8.0.3). PostgreSQL is officially used as an MSI package by pginstaller. It is not difficult to install it separately, but

PostgreSQL manages database access permissions through roles. we can regard a role as a database user or a group of database users. Roles can have database objects, such as tables and indexes, or grant permissions on these objects to other roles to

PostgreSQL's pitr Technology (point-in-time-recovery) -- Seamus Dean (at PostgreSQL-8.0.2 release) Why write this?Article?I have read that all the PostgreSQL tutorials in China have not introduced this function in detail. On the contrary, the

Iv. PostgreSQL/PostgisInstall Some figures have not been cut down. I have already downloaded them in FreeBSD. In fact, read the installation instructions of the software, which is very simple. Log on to the http://www.postgresql.org and download the

Document directory PostgreSQL cluster replication Solution About pgq and londiste tools Install Configuration Start replication daemon Add a replica set Test conclusion Exploration of application scenarios PostgreSQL cluster replication

I installed PostgreSQL 8.0.0 Beta 4 today. It seems to be good. PostgreSql 7.x requires a simulator to be installed to run on Windows. In MySQL 8.0, it supports Windows directly. : Http://www.postgresql.org/news/235.html The JDBC driver can be

PostgreSQL version8.0 Operating system: Microsoft Windows 2003 ¤ Short description: Pg_get_serial_sequence can not find a table that existing. ¤ Details:I created one table via SQL command like this:Create table tTestTable {FId bigint not null

When running an integration test, the following PSQLException error occurs: The corresponding model hasStringType fields are marked@ Lob, Hibernate converts itCLob. HoweverCLobEDB'sGetClobMethod calledGetLongAnd then tryCLobConvertLong. No edb