On Wed, Apr 4, 2012 at 8:00 AM, Tom Lane t...@sss.pgh.pa.us wrote:
umi.tan...@gmail.com writes:
http://www.postgresql.org/docs/9.1/static/spi-spi-execute.html
===
SPI_execute(INSERT INTO foo SELECT * FROM bar, false, 5);
will allow at most 5 rows to be inserted into the table.
===
This
Hi
I have a Postgresql 9.1.2 installed on a Windows 7 machine and noticed
the following thing:
- I start the postgresql by windows service ( on default port )
- when I run pg_ctl -D on the same data directory the response is no
server running even the server is in fact running already
- if I try
Dropping the BEGIN has cleared up the issue. Thank you.
On 4/3/2012 9:50 AM, John R Pierce wrote:
On 04/03/12 9:40 AM, Tom Lane wrote:
Alex Matzingeramatzin...@experts-exchange.com writes:
The connection that is executing the SELECT 1 are generally open
for 1-5
hours before they are
system=fedora15
software env=all software in DVD are completely installed(include pgsql psql)
and some thing like pppoe
postgresql are install with fedora by default option,
/etc/passwd/: postgres PostgreSQL Server:/var/lib/pgsql:/bin/bash
operations:
su - postgres
initdb -D
You've used : su - root
Before this, you possibly need populate some environment variables from your
postgre user.
--
--
iihero(Xiong He) http://www.sql9.com
--
When you install PG as a service, the default service account is postgres.
But when you run cmd line: pg_ctl status
It's running under your current user account other than postgres.
Could you run:
runas /user:postgres cmd
Then in the new command window: pg_ctl status
--
On Thu, Apr 5, 2012 at 8:14 AM, Terrance Chen naturalc...@yahoo.com wrote:
system=fedora15
software env=all software in DVD are completely installed(include pgsql
psql) and some thing like pppoe
postgresql are install with fedora by default option,
/etc/passwd/:postgres
According to what I can see from this defect that it is not confirmed
whether the Postgre server is started or not properly.
You can try on confirming about the following 2 points:
1. How many postgres processes you are able to see in your task manager.
This can give hint whether appropriate
Hi
I've already tried yesterday to switch the service from the postgres
acount to the local acount but the result was the same. I'll check
again also your solution and get back.
Lucian
On Fri, Apr 6, 2012 at 2:21 AM, iihero iih...@qq.com wrote:
When you install PG as a service, the default