On Thu, 21 Aug 2003, Anagha Joshi wrote:
> Hi all,
> I'm using PG - 7.2.4 on Solaries.
> I'm using "libpq++" library as client implementation is coded in "C++".
>
> I'm doing the following :
> 1.Making the connection to database by creating new object of
> "PgDatabase" i.e.
> data = new PgDat
Hi all,
I’m using PG – 7.2.4 on Solaries.
I’m using “libpq++”
library as client implementation is coded in “C++”.
I’m doing the following :
Making
the connection to database by creating new object of “PgDatabase”
i.e.
data = new PgDatabase( “ CONNECTION INFO “);
T
George McQuade wrote:
Interesting, my C is gone a long time ago. Would the
table function be fairly complex for someone who's
never done one?
I'm tempted by the java option, but initial jdbc speed
tests don't look very promising (the avg file has
1/2 million records).
Well this is a fairly complex
As declared, your function returns TEXT, i.e. unlimited characters.
>> CREATE FUNCTION UpdateOrder(INTEGER) RETURNS TEXT
AS
Since your variable
>> r_SKUPrice RECORD;
contains a number of columns
>> SELECT SKU, Price INTO r_SKUPrice
you could create a composite TYPE that matches those columns
a
--- Joe Conway <[EMAIL PROTECTED]> wrote:
> George McQuade wrote:
> > date tran glamt
> > 08/20/03 1001 3010 -30.00
> > 08/20/03 1001 1030 -300.00
> > 08/20/03 1001 1060 +330.00
> > 08/20/03 1002 ...next transaction
> > ...
> > and I need to convert to:
> >
> > date glcr gldb am
On Wed, 20 Aug 2003, Rod Taylor wrote:
> On Wed, 2003-08-20 at 17:41, Stephan Szabo wrote:
> > On Wed, 20 Aug 2003, Rod Taylor wrote:
> >
> > > > Thanks, Stephan. I was really hoping that the IN(valuelist) was going to
> > > > be changed at the same time, because it really is unusable for anythi
Matthias,
> I don't understand why this function ist refused by postgresql with an parse
error at the first $1 as ist every
> other method I tryed to get postgres making an "alter group" with a
variable. I'd be very happy if someone
> could help...
You can't substitute variables for objec
Send the config.log file.
On Wed, 20 Aug 2003 23:18:15 +0200 (CEST)
Peter Eisentraut <[EMAIL PROTECTED]> wrote:
> Chidananda writes:
>
> > We are trying to install on solaris ver 9.0 we are getting the following
> > error so kindly tell us how to over come this problem.
> >
> > configur
Hello,
is ist possible to write a function that alters the group of a given user like the
following should do in my
opinion (I'd like to use it in a rule):
CREATE FUNCTION set_group (text, integer) RETURNS text AS '
ALTER GROUP userlevel1 DROP USER $1; ALTER GROUP userlevel2 DROP U
"Matthias Nagl" <[EMAIL PROTECTED]> schrieb am 20.08.03 23:09:03:
Hello,
is ist possible to write a function that alters the group of a given user like the
following should do in my
opinion (I'd like to use it in a rule):
CREATE FUNCTION set_group (text, integer) RETURNS text AS '
Chidananda writes:
> We are trying to install on solaris ver 9.0 we are getting the following
> error so kindly tell us how to over come this problem.
>
> configure: error:
> *** Could not execute a simple test program. This may be a problem
> *** related to locating shared libraries. Ch
"Aasmund Midttun Godal" <[EMAIL PROTECTED]> writes:
> Thank you for your quick reply!
> I understand your point of view, however the fact remains that you want the
> action to be done as though it was the DEFINER user that did it, and that
> has not changed even thoug the function itself has fin
Hello,
I have noticed that the link toward pgsql-sql is missing on the left
menu at http://archives.postgresql.org/.
Is that normal?
--
***
Richard NAGY
Nameshield
46, rue Jean BODIN
F-49000 Angers
Tél : +33 2 41 18 28 28
***
---
Hi,
We are trying to install on solaris ver 9.0 we are
getting the following error so kindly tell us how to over come this
problem.
configure: error:*** Could not execute a simple
test program. This may be a problem*** related to locating shared
libraries. Check the file 'con
On Wed, Aug 20, 2003 at 03:15:23PM +0530, Jomon Skariah wrote:
>
> we are facing a few problems with PL/SQL Code..
>
>
> 1)In Oracle sqlplus we can run sql script files as @script_name;
> How do we do the same in PostGres.
psql takes \i. See psql's \?
See the "Porting From Oracle PL
On Wed, 2003-08-20 at 17:41, Stephan Szabo wrote:
> On Wed, 20 Aug 2003, Rod Taylor wrote:
>
> > > Thanks, Stephan. I was really hoping that the IN(valuelist) was going to
> > > be changed at the same time, because it really is unusable for anything
> > > over a couple of thousand values.
> >
> >
Thank you for your quick reply!
I understand your point of view, however the fact remains that you want the
action to be done as though it was the DEFINER user that did it, and that
has not changed even thoug the function itself has finished?
regards,
aasmund.
Tom Lane writes:
"Aasmund
Mike Winter <[EMAIL PROTECTED]> writes:
> MySQL does queries of this type orders of magnitudes faster than Postgres
> on large value lists, although I have no specific algorithmic solutions to
> offer for how to make it faster.
How large is "large", and what plan type are you getting (seq scan or
George McQuade wrote:
date tran glamt
08/20/03 1001 3010 -30.00
08/20/03 1001 1030 -300.00
08/20/03 1001 1060 +330.00
08/20/03 1002 ...next transaction
...
and I need to convert to:
date glcr gldb amt
08/20/03 1060 3010 30.00
08/20/03 1060 1030 300.00
in other words, the negative
Many thanks... got it now.
Example...
sox=# select * from regexpatt;
pattern |description
-+
^b | starts with a B
^a | starts with an A
^c.*l$ | starts with a C and ends with an L
(3 rows)
sox=# select description from regex
"Aasmund Midttun Godal" <[EMAIL PROTECTED]> writes:
> When an operation is done throug a SECURITY DEFINER style function and
> causes a trigger the current_user depends on whether it is executed BEFORE
> or AFTER. I currently run 7.3.2. I believe the BEFORE behavior is correct
> while the AFTER
Hi All,
We are in the process of migrating of our application from Oracle to
PostGreSQL.
we are facing a few problems with PL/SQL Code..
1) In Oracle sqlplus we can run sql script files as @script_name;
How do we do the same in PostGres.
Also is there any replacement for
Hello everyone,
I have a table that looks like:
date tran glamt
08/20/03 1001 3010 -30.00
08/20/03 1001 1030 -300.00
08/20/03 1001 1060 +330.00
08/20/03 1002 ...next transaction
...
and I need to convert to:
date glcr gldb amt
08/20/03 1060 3010 30.00
08/20/03 1060 1030 300.0
Josh Berkus <[EMAIL PROTECTED]> wrote:
> Vernon,
>
>> What is the best solution for this DB scheme problem?
>
> Have you considered not using inheritance? As a relational-SQL geek myself,
> I'm not keen on inheritance -- I feel it mucks up the relational model. Not
> everyone agrees with me,
I have upgraded to 7.3.4 and the problem persists.
Aasmund Midttun Godal writes:
When an operation is done throug a SECURITY DEFINER style function and
causes a trigger the current_user depends on whether it is executed BEFORE
or AFTER. I currently run 7.3.2. I believe the BEFORE behavior is
Mike Winter wrote:
On Wed, 20 Aug 2003, Rod Taylor wrote:
Ensure your IN list is unique. You might find better times by through
an indexed temp table.
That is what I ended up doing, but it's not a very elegant solution.
MySQL does queries of this type orders of magnitudes faster than Postgres
on
On Wed, 20 Aug 2003, Rod Taylor wrote:
> Ensure your IN list is unique. You might find better times by through
> an indexed temp table.
That is what I ended up doing, but it's not a very elegant solution.
MySQL does queries of this type orders of magnitudes faster than Postgres
on large value li
On Wed, 20 Aug 2003, Rod Taylor wrote:
> > Thanks, Stephan. I was really hoping that the IN(valuelist) was going to
> > be changed at the same time, because it really is unusable for anything
> > over a couple of thousand values.
>
> Changed to do what?
One possibility might be to act as if the
When an operation is done throug a SECURITY DEFINER style function and
causes a trigger the current_user depends on whether it is executed BEFORE
or AFTER. I currently run 7.3.2. I believe the BEFORE behavior is correct
while the AFTER behavior is wrong. A bug? already fixed?
regards,
Aasmun
Ensure your IN list is unique. You might find better times by through
an indexed temp table.
On Wed, 2003-08-20 at 16:32, Mike Winter wrote:
> I'm sure many on this list are sick of hearing about this problem, but it
> was on the fix list for 7.4, but doesn't appear to have been changed.
>
> You
> Thanks, Stephan. I was really hoping that the IN(valuelist) was going to
> be changed at the same time, because it really is unusable for anything
> over a couple of thousand values.
Changed to do what?
I suppose that the ability to combine several index scans via a bitmap
would help to linear
On Wed, 20 Aug 2003, Stephan Szabo wrote:
>
> On Wed, 20 Aug 2003, Mike Winter wrote:
>
> > I'm sure many on this list are sick of hearing about this problem, but it
> > was on the fix list for 7.4, but doesn't appear to have been changed.
>
> IN (subselect) was changed for 7.4 (although I'm not s
On Wed, 20 Aug 2003, Mike Winter wrote:
> I'm sure many on this list are sick of hearing about this problem, but it
> was on the fix list for 7.4, but doesn't appear to have been changed.
IN (subselect) was changed for 7.4 (although I'm not sure of the list
mentions the difference). I don't know
I'm sure many on this list are sick of hearing about this problem, but it
was on the fix list for 7.4, but doesn't appear to have been changed.
You can see one of the many threads on the problem at:
http://archives.postgresql.org/pgsql-sql/2003-05/msg00352.php
Basically, queries of the form SELEC
Please see the attached file for details.
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list
See the attached file for details
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
36 matches
Mail list logo
