On 04/10/2014 03:29 PM, Rob Sargent wrote:
Code for db functions should be a repository. Easy edit and rerun
Well, not necessarily inside the transaction that renames the schema.
I've settled for this inside the transaction (running as a superuser):
UPDATE pg_proc
SET proconfig = '{
Code for db functions should be a repository. Easy edit and rerun
Sent from my iPhone
> On Apr 10, 2014, at 6:19 AM, Florian Weimer wrote:
>
> I would like to rename schemas without breaking the stored procedures in
> them. Currently, this does not work if the stored procedure definition
> c
I would like to rename schemas without breaking the stored procedures in
them. Currently, this does not work if the stored procedure definition
contains a schema self-reference because that does not get renamed. I
tried "SET search_path FROM CURRENT", but that seems to expand the
search path
J.V. wrote:
> I need to run a series of stored procedures, what is the best way to
> organize and run.
>
> Ideally would like something like Oracle PL/SQL where I can put all
> methods in one file and create a main() method
>
> then just : select main() to have them all run.
>
> If there is a w
On 09/30/11 12:57 AM, J.V. wrote:
I need to run a series of stored procedures, what is the best way to
organize and run.
Ideally would like something like Oracle PL/SQL where I can put all
methods in one file and create a main() method
then just : select main() to have them all run.
in fu
I need to run a series of stored procedures, what is the best way to
organize and run.
Ideally would like something like Oracle PL/SQL where I can put all
methods in one file and create a main() method
then just : select main() to have them all run.
If there is a way to do this, please let
Guys, it has nothing to do with my question :D
I don't know why Martin answer to me anything about Cobol.
I just was looking how to query database in a stored procedure in C. Some
people pointed me to SPI documentation (at chapter 41 of oficial Postgres
documentation) that is being useful.
Thanks f
On Wed, Apr 23, 2008 at 6:38 PM, Martin Gainty <[EMAIL PROTECTED]> wrote:
>
>
> Emiliano and Mike
>
> The real challenge is trying to determine what a datatype is in cobol..for
> that matter what is stack variable or heap in Cobol?
> In the end you're better off writing this mess (preferably in Jav
Bay
Cc: pgsql-general@postgresql.org
Sent: Thursday, April 24, 2008 8:44 AM
Subject: Re: [GENERAL] Stored procedures in C
Thanks a lot for the response Andrej!
One of these texts was known for me. But all of them are VERY basic. No one
explains how to do a query and manage result
Thanks a lot for the response Andrej!
One of these texts was known for me. But all of them are VERY basic. No one
explains how to do a query and manage results :(
The only one that manage querys is the source code placed at
contrib/tablefunc in the Postgres distribution. But is VERY hard to follow
On 24/04/2008, Emiliano Moscato <[EMAIL PROTECTED]> wrote:
> I have to do some stuff writing stored procedures for Postgres in C. I saw
> the oficial documentation but it was hard for me to find out how to do a
> simple function, let's call it "query()" , that receives a string and uses
> this stri
then later rewrite to Java
(That should get you at least 2 weeks worth of work..)
Buena Suerte/Good Luck
Martin
- Original Message -
From: Emiliano Moscato
To: pgsql-general@postgresql.org
Sent: Wednesday, April 23, 2008 3:32 PM
Subject: [GENERAL] Stored procedures in C
H
Hi all,
I have to do some stuff writing stored procedures for Postgres in C. I saw
the oficial documentation but it was hard for me to find out how to do a
simple function, let's call it "query()" , that receives a string and uses
this string to do a query and return the results. Has anyone some e
Pavel Stehule wrote:
> ...
bottleneck is in repeated assign s := s || ..
I will try trick:
create or replace function list(int)
returns varchar as $$
begin
return array_to_string(array(select '' || i || ''
from generate_series(1, $1) g(i)), '');
end$$ language plpgsql immutable;
test
>
> Yep, the more I read, the more I get confused.
> Java loading overhead is a common myth (I can't say if true or false),
> and what Tom writes above can find a tentative place in my mind.
> But still then I can't understand where plsql should or shouldn't be
> used.
>
> I really would enjoy to s
On Jan 22, 2008 2:24 AM, Ivan Sergio Borgonovo <[EMAIL PROTECTED]> wrote:
> > > I doubt that what you were measuring there was either procedure
> > > call overhead or java computational speed; more likely it was the
> > > cost of calling back out of java, through pl/java's JDBC
> > > emulation, dow
On Mon, 21 Jan 2008 21:31:23 -0800
johnf <[EMAIL PROTECTED]> wrote:
> On Monday 21 January 2008 04:47:40 pm Tom Lane wrote:
> > I doubt that what you were measuring there was either procedure
> > call overhead or java computational speed; more likely it was the
> > cost of calling back out of jav
Byers
Sent: Tuesday, December 04, 2007 9:59 AM
To: Richard Huxton; Ivan Sergio Borgonovo
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] stored procedures and dynamic queries
--- Richard Huxton <[EMAIL PROTECTED]> wrote:
> Ivan Sergio Borgonovo wrote:
> > On Tue, 04 Dec
On Tue, 04 Dec 2007 13:54:15 +
Richard Huxton <[EMAIL PROTECTED]> wrote:
> Always go for the cleaner design. If it turns out that isn't fast
> enough, *then* start worrying about having a bad but faster design.
mmm yeah right. I did express myself badly.
What I mean I've first to know what a
--- Richard Huxton <[EMAIL PROTECTED]> wrote:
> Ivan Sergio Borgonovo wrote:
> > On Tue, 04 Dec 2007 08:14:56 +
> > Richard Huxton <[EMAIL PROTECTED]> wrote:
> >
> >> Unless it's an obvious decision (millions of
> small identical
> >> queries vs. occasional large complex ones) then
> you'll ha
Ivan Sergio Borgonovo wrote:
On Tue, 04 Dec 2007 08:14:56 +
Richard Huxton <[EMAIL PROTECTED]> wrote:
Unless it's an obvious decision (millions of small identical
queries vs. occasional large complex ones) then you'll have to
test. That's going to be true of any decision like this on any
sy
On Tue, 04 Dec 2007 08:14:56 +
Richard Huxton <[EMAIL PROTECTED]> wrote:
> Unless it's an obvious decision (millions of small identical
> queries vs. occasional large complex ones) then you'll have to
> test. That's going to be true of any decision like this on any
> system.
:(
I'm trying to
Ivan Sergio Borgonovo wrote:
On Mon, 03 Dec 2007 19:06:29 +
Richard Huxton <[EMAIL PROTECTED]> wrote:
Ivan Sergio Borgonovo wrote:
Any general rule about dynamically generated queries in stored
procedures vs. performances?
It's the same decision as any with any prepared plan vs
plan-each-
On Mon, 03 Dec 2007 19:06:29 +
Richard Huxton <[EMAIL PROTECTED]> wrote:
> Ivan Sergio Borgonovo wrote:
> > Any general rule about dynamically generated queries in stored
> > procedures vs. performances?
>
> It's the same decision as any with any prepared plan vs
> plan-each-time trade-off.
Ivan Sergio Borgonovo wrote:
Any general rule about dynamically generated queries in stored
procedures vs. performances?
It's the same decision as any with any prepared plan vs plan-each-time
trade-off.
A query built using EXECUTE will have to be planned each time. That
costs you something
Any general rule about dynamically generated queries in stored
procedures vs. performances?
I was going to write stuff as simple as
create or replace function EditQty(int, int, int, varchar(10))
returns boolean as
'
declare
_uid alias for $1;
_aid alias for $2;
_qty alias
On Mon, Nov 26, 2007 at 11:57:37PM -0800, Alagu Madhu wrote:
> Which is the best Stored Procedures or Dynamic SQL generated by ORM ?
This is roughly similar to the question, "Is it better to travel by car,
boat, or plane?" It rather depends on what you're trying to accomplish.
A
--
Andrew Sul
On Nov 27, 2007 1:57 AM, Alagu Madhu <[EMAIL PROTECTED]> wrote:
>
> Which is the best Stored Procedures or Dynamic SQL generated by ORM ?
Depends on what you mean by best. Dynamic SQL costs more in the
planning stage because the db has to plan out each statement before
running it. However, it ca
Hi All,
Which is the best Stored Procedures or Dynamic SQL generated by ORM ?
Thanks
Madhu Alagu
---(end of broadcast)---
TIP 6: explain analyze is your friend
Harpreet Dhaliwal wrote:
> Is it true that postgres doesn't have a notion of Stored
> Procedures and functions is what it has instead?
> RDBMS like Sql Server supports both stored procedures and functions.
> So I was wondering what is the difference between a Stored
> Procedure and a function.
MySQL supports procedures and functions.
Functions can return results but cannot update the database.
Procedures can update the database but cannot return results.
However :
- a function can call a procedure that updates the database !
- a proced
Hello
Is it true that postgres doesn't have a notion of Stored Procedures and
functions is what it has instead?
RDBMS like Sql Server supports both stored procedures and functions.
So I was wondering what is the difference between a Stored Procedure and a
function.
It's true. PostgreSQL know
On Saturday 2. June 2007 16:47, Harpreet Dhaliwal wrote:
>Hi,
>
>Is it true that postgres doesn't have a notion of Stored Procedures
> and functions is what it has instead?
>RDBMS like Sql Server supports both stored procedures and functions.
>So I was wondering what is the difference between a Sto
Hi,
Is it true that postgres doesn't have a notion of Stored Procedures and
functions is what it has instead?
RDBMS like Sql Server supports both stored procedures and functions.
So I was wondering what is the difference between a Stored Procedure and a
function.
Thanks,
~Harpreet
[EMAIL PROTECTED] (Daniel Kastenholz) writes:
> Hi,
>
> is there a rule of thumb or an estimate which language provides the
> best performance for stored procedures?
>
> I'm currently using PL/Pgsql, and wondering
> - to what extent these stored procedures are actually precompiled
> and/or optimize
Hi,
is there a rule of thumb or an estimate which language provides the best
performance for stored procedures?
I'm currently using PL/Pgsql, and wondering
- to what extent these stored procedures are actually precompiled and/or
optimized
- if Java might provide better performance, or if para
On 6/30/06, Alain Roger <[EMAIL PROTECTED]> wrote:
i'm migrating some SP from MySQL to PostgreSQL 8.1.xI would like to know if it is possible to return aresult of a select request and also a simple interger...that's definitelly possible (and by the way - is was possi ble years before mysql implemen
Hi,i'm migrating some SP from MySQL to PostgreSQL 8.1.xI would like to know if it is possible to return aresult of a select request and also a simple interger...thanks a lot,Alain
Hello,
I am alagu madhu working as a Developer (postgresql).pls,send
your table design.
"Minal A. Aryamane" wrote:
> hello all,
> I desparately need help in developing stored procedure using postgresql 8.0.
> I am using pgadmin for developing the stored procs. Can anyone please he
Minal A. Aryamane wrote:
hello all,
I desparately need help in developing stored procedure using postgresql 8.0. I am using pgadmin for developing the stored procs. Can anyone please help me, The docs are really not helpful.
am trying to pass values through a jsp page wherein I am accessing
hello all,
I desparately need help in developing stored
procedure using postgresql 8.0. I am using pgadmin for developing the stored
procs. Can anyone please help me, The docs are really not helpful.
am trying to pass values through a jsp
page wherein I am accessing this stored procedure
What is everyone's opinion for exclusively using Stored Procedures
for increased security? The scenario I am thinking of means having
one user which is widely accessible (large numbers of staff/user for
example) and only has access to some stored procedures, which where
create with SECURITY
Title: stored procedures / C-Language
hi,
i'm trying to find some documentation about writing stored
procedures with C-language. i found description in
postgresql's documentation but i don't understand everything.
Aat present, i have a pl/perl stored procedure but it isn't
Title: stored procedures / C-Language
hi,
i'm trying to find some documentation about writing stored procedures with C-language.
i found description in postgresql's documentation but i don't understand everything.
Aat present, i have a pl/perl stored procedure but it isn't fast enough, so
On Tue, Sep 21, 2004 at 11:11:33AM -0700, Chris Travers wrote:
> Alvaro Herrera wrote:
>
> >There's only one transaction (whether it's an explicit transaction block
> >or an implicit one), and the query that invokes the stored procedure is
> >already running inside it. So the stored procedure alw
On Tue, Sep 21, 2004 at 07:41:31AM -0400, Kent Anderson wrote:
> We are currently switching to stored procedures for a lot of our database
> activity. The question has come up about the transactional nature of the
> stored procedures. I was wondering if stored procedures can have
> transactions in
We are currently
switching to stored procedures for a lot of our database activity. The question
has come up about the transactional nature of the stored procedures. I was
wondering if stored procedures can have transactions in them or if you must start the
transaction in your code and cal
"Andrew Hall" wrote:
We are using a number of stored procedures that are called often from our
client programs. I include one here as an example. The problem we are seeing
is that when executing some of these that deal with a large number of
records, they begin execution and never return. The proce
Oliver Elphick <[EMAIL PROTECTED]> writes:
>> We are using a number of stored procedures that are called often from our
>> client programs.
> Are you somehow setting off an infinite recursion? How is this being
> called?
I doubt it would be an infinite-recursion problem, as that would soon
lead
On Thu, 2004-08-19 at 10:53, Andrew Hall wrote:
> Hello,
>
> We are using a number of stored procedures that are called often from our
> client programs. I include one here as an example. The problem we are seeing
> is that when executing some of these that deal with a large number of
> records, t
Hello,
We are using a number of stored procedures that are called often from our
client programs. I include one here as an example. The problem we are seeing
is that when executing some of these that deal with a large number of
records, they begin execution and never return. The process handling t
Hello !
My ODBC driver in MS Visual Basic 6 refers also to
"Stored procedures" as Record source.
What are these stored procedures, I don't find
anything in the 7.4 documentation,
Where can I find documentation ?
Many thanks.
Luc
Shachar Shemesh wrote:
Hi List,
How do I define a stored procedure that has an output variable? I am
looking for a way that will not significantly change the way the
argument is called.
Can I, for example, pass a reference to variable in some way?
If I understand your question, the best way is
Hi List,
How do I define a stored procedure that has an output variable? I am
looking for a way that will not significantly change the way the
argument is called.
Can I, for example, pass a reference to variable in some way?
Shachar
--
Shachar Shemesh
Lingnu Open Source Consulting
On Tuesday 28 October 2003 16:06, Tomas Larsson wrote:
> Hi!
>
> We're trying to call a set-returning stored procedure
> from Excel (MS Query). To do this we type:
>
> select * from getStudents()
>
> (where getStudents() is the stored procedure).
> The problem is that MS Query interprets this as if
Thanks Shridhar!
Works like a charm!
/tomas, Patrik and Siv.
--- Shridhar Daithankar
<[EMAIL PROTECTED]> wrote:
> On Tuesday 28 October 2003 16:06, Tomas Larsson
> wrote:
> > Hi!
> >
> > We're trying to call a set-returning stored
> procedure
> > from Excel (MS Query).
> Create a dummy table a
Hi!
We're trying to call a set-returning stored procedure
from Excel (MS Query). To do this we type:
select * from getStudents()
(where getStudents() is the stored procedure).
The problem is that MS Query interprets this as if
getStudents was a table, and complains that there is
no table called
Hello,
Is it possible to make PL/PGSQL stored procedures with a variable number
of args ?
If yes, is it possible to have a sample ?
Thanks you in advance :-)
---
Bruno BAGUETTE - [EMAIL PROTECTED]
---(end of broadcast)--
Hi,
I am very new to PgSQL and I am just trying to figure out what for to
use stored procedures.
What I read/tested up to now is that pl/pgsql seems to be a bit
clumsy to write. Possibly needing a lot of
trial & error.
So, I am not really sure what is the benefit of writing logic inside the DB
Hello
after playing around for a while with PostgreSQL's Stored Functions
I think I understood the concept behind it a little bit. It is mighty
but quite different from all other SQL servers Stored Procedures.
Considering the fact that there is another OpenSourced SQL database
engine Interbase,
Hello friends,
many months ago I starting messing with stored procedures with PostgreSQL,
and at the time, I found out that I could only return "one" value when I
used a stored procedure.
I was wondering if this has changed or has/will/could be changed/implemented
with PostgreSQL 7.0?
It would
Could someone point me to a tutorial or HOWTO regarding stored procedures? I
know very little about them and need to learn everything I possibly can about
them as soon as possible. I looked throught the Postgres docs and couldn't
find anything that goes into them in depth.
Thank you,
-M@
On Fri, 5 Nov 1999, Jeff MacDonald wrote:
> 1: does postgres support stored procedures
Yes, quite extensively, and far beyond what SQL 7 offers. You may want
to take a look at the programmer's manual for the documentation.
> 2: say a user has a microsoft sql server 7 database
>
Greets,
Couple of questions,
1: does postgres support stored procedures
2: say a user has a microsoft sql server 7 database
with ~120 stored procedures, and alot of data, is their
a script or tool to convert that to a postgres database
or does it have to
64 matches
Mail list logo
