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 quer
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 'p
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 p
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
http://trac.osgeo
On Wed, Jan 7, 2009 at 11:39 PM, Craig Ringer
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 was don
On Wed, Jan 7, 2009 at 11:39 PM, Craig Ringer
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 was don
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 t
On Sun, Jan 4, 2009 at 9:05 PM, Craig Ringer
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 tables would be pret
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
>
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.
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. Tha
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 tab
Gerhard Heift 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 only once per query,
not that that
I wrote:
> =?ISO-8859-1?Q?Christian_Schr=F6der?= 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 few S
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
On Jan 7, 2009, at 12:30 PM, Tom Lane wrote:
Kirk Strauser 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
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
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
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 spac
On Jan 7, 2009, at 12:30 PM, Tom Lane wrote:
Kirk Strauser 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
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 'fun
Kirk Strauser 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 signed-integer-overflow bug som
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 sma
Mohamed 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 tsvector value, which means
On Wed, Jan 7, 2009 at 10:26 AM, Dan Armbrust
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 mailing list (pgsql-general@po
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.
R
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 ?
On Wed, Jan 7, 2009 at 10:53 AM, hubert depesz lubaczewski
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 can
> use list
2009/1/7 Gustavo Rosso :
> 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 triggers que tenga un
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 te
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 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.
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 t
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 fi
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 se
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 thi
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
On Wed, Jan 7, 2009 at 9:40 AM, Shahbaz A. Tyagi
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 include any of the bu
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-
From
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: pgsql-general@postgres
On Wed, Jan 7, 2009 at 9:15 AM, Shahbaz A. Tyagi
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
> http://go.microsoft.com/fwlink/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-389c36f85647&displaylang=en
After instal
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,
__
43 matches
Mail list logo
