Hi,
While trying to run pg_ctl.exe with valid parameters, using command prompt
in windows XP sp2 machine, it's not getting executed.
In event viewer we are getting following events,
How did you install PostgreSQL on your system?
Microsoft Visual Studio redistribution binaries are missing on your system.
Download it from the following link and install it.
http://www.microsoft.com/downloads/details.aspx?familyid=200b2fd9-ae1a-4a14-984d-389c36f85647displaylang=en
After
On Wed, Jan 7, 2009 at 9:15 AM, Shahbaz A. Tyagi
shahbaz.ty...@sphere.ae wrote:
Hi,
While trying to run pg_ctl.exe with valid parameters, using command prompt
in windows XP sp2 machine, it's not getting executed.
For more information, see Help and Support Center at
We have not installed the Postgre but we are trying to use the binaries
directly.
Thanks,
Shahbaz
_
From: Ashesh Vashi [mailto:ashesh.va...@enterprisedb.com]
Sent: Wednesday, January 07, 2009 1:38 PM
To: Shahbaz A. Tyagi
Cc:
Yeah, thanks guys, we were able to run it in one machine but not in our main
server, hence the confusion came. Than we installed other version of
runtimes but now we installed the correct one as suggested, hence worked.
Thanks,
Shahbaz A. Tyagi
Sphere Networks
-Original Message-
On Wed, Jan 7, 2009 at 9:40 AM, Shahbaz A. Tyagi
shahbaz.ty...@sphere.ae wrote:
We have not installed the Postgre but we are trying to use the binaries
directly.
Did you read the README?
postgresql-8.3.5-1-binaries-no-installer.zip is a zip of the PostgreSQL
installation directory. It does not
Hi,
All I want to do is 'include' a stored procedure (contained in another
script file) into my main PostgreSQL database creation script file so that
it can get defined/declared before I define my triggers to call it. It seems
such a simple thing but I don't seem to be able to find any examples or
An .sql file is just a list of sql you can just as well enter when running
psql.If you had the psql prompt open, what would you type to execute the
commands in an .sql file, limited to 'true' sql and not psql specific
commands
If you know that you know which lines to add to the .sql file
Hope
In response to Donna Rudd :
Hi,
All I want to do is 'include' a stored procedure (contained in another
script file) into my main PostgreSQL database creation script file so that
it can get defined/declared before I define my triggers to call it. It seems
such a simple thing but I don't seem
Hi All,
I am having multiple postgresql 7.3(pretty old version now) on rhel4
servers.
I am getting the error MemoryContextAlloc: invalid request size on many of
these servers from time to time.
On crawling through net, I have found that its because of some bad word
value in a variable length
yogvinder wrote:
Hi All,
I am having multiple postgresql 7.3(pretty old version now) on rhel4
servers.
Which 7.3? Are you aware the community doesn't even officially support
them now?
I am getting the error MemoryContextAlloc: invalid request size on many of
these servers from time to
On Wed, Jan 07, 2009 at 06:07:02AM -0800, yogvinder wrote:
Hi All,
I am having multiple postgresql 7.3(pretty old version now) on rhel4
servers.
Not just pretty old, but past any community support. You'll need to
build and implement an upgrade strategy along with doing your upgrade.
I
Es 1.213ms un valor correcto para realizar un insert en una tabla
obtenido por explain analyze.
Gustavo
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Wed, Jan 07, 2009 at 01:30:54PM -0300, Gustavo Rosso wrote:
Es 1.213ms un valor correcto para realizar un insert en una tabla
obtenido por explain analyze.
trochę długo, ale to zależy od sprzętu. dodatkowo - może masz tam
triggery? klucze obce? ciężko powiedzieć. pokaż schemat tabeli i
2009/1/7 Gustavo Rosso gro...@sadaic.org.ar:
Es 1.213ms un valor correcto para realizar un insert en una tabla obtenido
por explain analyze.
eso es un poco mas de un milisegundo, no parece mucho... en todo caso
el tiempo que demore un INSERT dependera en parte de la cantidad de
indices, FK y
On Wed, Jan 7, 2009 at 10:53 AM, hubert depesz lubaczewski
dep...@depesz.com wrote:
p.s. as you can clearly see from another mails from this list - the list
uses english language. please use it, or if you'd like to use spanish
(i'm not sure if your language if spanish, i don't know it) - you
http://www.postgresql.org/docs/8.3/interactive/textsearch-limitations.html
The length of a tsvector (lexemes + positions) must be less than 1 megabyte
What does this mean ? Is that per column and row or for the whole index ?
I'm no closer to a solution, but here are some additional data points
- all taken on Fedora Core 6.
Postgres 8.1 built from source. Auto vacuum disabled.
Create Empty Database.
Run our load on the system for 2 hours to populate and exercise the database.
Run Vacuum. Takes more than a minute.
On Wed, Jan 7, 2009 at 10:26 AM, Dan Armbrust
daniel.armbrust.l...@gmail.com wrote:
I'm no closer to a solution, but here are some additional data points
- all taken on Fedora Core 6.
So, what does vmstat 10 say when you're running the long vacuum on
each system?
--
Sent via pgsql-general
Mohamed mohamed5432154...@gmail.com writes:
http://www.postgresql.org/docs/8.3/interactive/textsearch-limitations.html
The length of a tsvector (lexemes + positions) must be less than 1 megabyte
What does this mean ? Is that per column and row or for the whole index ?
It's for a single
I'm running PostgreSQL 8.3.5 on a FreeBSD 7.1/amd64 system with 8GB of
RAM and two quad-core Xeon CPUs. The data filesystem is on a battery-
backed RAID-10 system. This is a dedicated server so I want to commit
all resources to PostgreSQL alone. The database will get hit with a
lot of
Kirk Strauser k...@strauser.com writes:
First, shmget is asking for a lot less than shmmax - why is it failing?
Check to see if things work as expected when you have shmmax and shmall
set to a shade less than 2GB and fail when they are a shade more. If
so, it would seem there's a
Hello,
I have a query like this:
SELECT * FROM table WHERE has_permission('permission_name');
and the function
CREATE FUNCTION has_permission(IN pname text, OUT is_ok boolean) RETURNING
boolean AS
$BODY$
BEGIN
SELECT has_perm INTO is_ok FROM permission WHERE title = pname;
RAISE INFO
On Jan 7, 2009, at 12:30 PM, Tom Lane wrote:
Kirk Strauser k...@strauser.com writes:
First, shmget is asking for a lot less than shmmax - why is it
failing?
Check to see if things work as expected when you have shmmax and
shmall
set to a shade less than 2GB and fail when they are a shade
Hi, I am wondering whether or not there exists any built in function for
making sure a query/textinput is not harmful or one that escapes them. If
not, what kind of things should I watch out for ?
As of now, I get errors on the quote ( ' ) if it is entered in an input and
in to_tsquery also on
Bruce, et al,
given the thread partially quoted below would this warrant a
TODO item improve communication of encoding between client
and server regarding early startup messages ?
A very usable band-aid for 8.4 - short of a proper fix -
would be the minimal-invasive sending of messages in 7-bit
I isolated my problem a little bit:
CREATE FUNCTION get_array() RETURNS integer[] AS
$BODY$
BEGIN
RAISE INFO 'get_array';
RETURN ARRAY[1, 2];
END
$BODY$ LANGUAGE 'plpgsql' STABLE;
And now
SELECT * FROM generate_series(1,3) a(b) where array[b] @ core.get_array();
gives me:
INFO: get_array
On Jan 7, 2009, at 12:30 PM, Tom Lane wrote:
Kirk Strauser k...@strauser.com writes:
First, shmget is asking for a lot less than shmmax - why is it
failing?
Check to see if things work as expected when you have shmmax and
shmall
set to a shade less than 2GB and fail when they are a shade
Hello,
stable, volatile, immutable flag doesn't necessary means caching or
not caching.
if you need really only one call, use srf function
postgres=# create table foo(a int);
CREATE TABLE
postgres=# insert into foo values(10),(20);
INSERT 0 2
postgres=# create function foof(bool) returns setof
I wrote:
=?ISO-8859-1?Q?Christian_Schr=F6der?= c...@deriva.de writes:
When I try to call the function I get the following error message:
test=# select * from testfunc();
ERROR: error from Perl function: SPI_connect failed: SPI_ERROR_CONNECT
at line 2.
Hmph ... looks like plperl is shy a
Gerhard Heift ml-postgresql-20081012-3...@gheift.de writes:
The function is called for every row in the table if it is stable or
volatile and only once if it is immutable?
Yes, possibly.
I thought it had to be called only once, if it is stable.
No. Stable means that it is *okay* to call it
Hi all,I have a table accgroups and many others. I have written a test
function as follows.
CREATE OR REPLACE FUNCTION uf_testfunction()
RETURNS SETOF associates AS
$BODY$
begin
return query select * from associates;
return;
end;
$BODY$
LANGUAGE 'plpgsql' VOLATILE;
This works fine for above
Does anyone know if this utility can generate a log file of records that for
some reason do not load to a PostgreSQL database? I’m looking for something
like Oracle’s SQLLDR where an error is generated when a record fails to load.
If not pg_bulkload, perhaps there is some other like utility.
On Wednesday 07 January 2009 4:10:34 pm John Randall wrote:
Does anyone know if this utility can generate a log file of records that
for some reason do not load to a PostgreSQL database? I’m looking for
something like Oracle’s SQLLDR where an error is generated when a record
fails to load. If
On Mon, 2009-01-05 at 13:05 +0900, Craig Ringer wrote:
alvar...@alvarezp.ods.org wrote:
On user account creation, the schema gets created and the interface
tries to do a CREATE TABLE my_relation () INHERITS
(_skel.my_relation); as the new role, but PostgreSQL returns the error
must be
On Sun, Jan 4, 2009 at 9:05 PM, Craig Ringer
cr...@postnewspapers.com.au wrote:
alvar...@alvarezp.ods.org wrote:
(2) per-user schemas
with CREATE TABLE (LIKE parent_table), as getting the data from all
users at once would also be difficult and modifying the column
definition on the user
Scott Marlowe wrote:
Is there a way to let PostgreSQL to allow inherited tables to be owned
by different roles?
Not that I know of, and given the security implications I'd be a bit nervous
about it unless it was done via an explicitly GRANTed right.
I hope here you're meaning to have tables
On Wed, Jan 7, 2009 at 11:39 PM, Craig Ringer
cr...@postnewspapers.com.au wrote:
Scott Marlowe wrote:
Is there a way to let PostgreSQL to allow inherited tables to be owned
by different roles?
Not that I know of, and given the security implications I'd be a bit
nervous
about it unless it
On Wed, Jan 7, 2009 at 11:39 PM, Craig Ringer
cr...@postnewspapers.com.au wrote:
Scott Marlowe wrote:
Is there a way to let PostgreSQL to allow inherited tables to be owned
by different roles?
Not that I know of, and given the security implications I'd be a bit
nervous
about it unless it
Hi there,
We are trying to build the PostGIS (1.3.5) extension to PostgreSQL (8.3) on
Solaris 10 Update 5 on an amd64 platform (Sun Fire X4100).
We are unable to build the geos (3.0.3) library on the same using Sun Studio
12 compiler. We have included the patches as mentioned in
Hello,
I am working with 8.1.4 pgsql as my database backend. I have a function
written in plpgsql language, that queries a particular table as below,
select host from table_host where ip_address = ip_array[i] and port =
port_array[i];
The query is running in a for loop. I see ip_array and
In response to c k :
Hi all,
I have a table accgroups and many others. I have written a test function as
follows.
CREATE OR REPLACE FUNCTION uf_testfunction()
RETURNS SETOF associates AS
$BODY$
begin
return query select * from associates;
return;
end;
$BODY$
LANGUAGE 'plpgsql'
IS there any name clash with a function argument?
--
Fahrbahn ist ein graues Band
weisse Streifen, grüner Rand
On Thursday 08 January 2009 08:30:07 Mayuresh Nirhali wrote:
Hello,
I am working with 8.1.4 pgsql as my database backend. I have a function
written in plpgsql language, that queries
43 matches
Mail list logo
