I have been having some trouble with a particular table view. An UPDATE
command is not only changing the applicable record it is also creating a
new record as well.
wholesale=# select * from accounts_supplier;
id | name | contact | addr| addr2 | town |
postcode |
So you installed psqlodbc 8 on the client machine with Delphi installed,
correct? What problems did you have with cursors? Any other suggestions?
Thanks a lot for the help!
J
Din Adrian wrote:
we are using postgresql8 +psqlodbc8+ delphi7 ... the only problem is
the server side cursor =
I have the following function to determine wether or not a user is
member of a group, however I have a small problem with it:
a group without members results in groupres being NULL (I have checked
this), however
IF groupres = NULL
THEN
...
END IF;
is not trapped... I have tried to use
Yes, the client must have the psqlodbc driver and mdac at least 2.6.
(Mdac2.5 is verry buggy - attention win2000 and win9x must be upgraded if
you need mdac for your app).
When using server side cursors for a dataset the update and delete
functions act 'strange' as not refreshing corect
-Original Message-
From: [EMAIL PROTECTED]
Sent: Thu, 16 Jun 2005 14:26:39 +0200
To: pgsql-sql@postgresql.org
Subject: [SQL] Function does not return, but gives error..
I have the following function to determine wether or not a user is
member of a group, however I have a small
Gnanavel Shanmugam wrote:
-Original Message-
From: [EMAIL PROTECTED]
Sent: Thu, 16 Jun 2005 14:26:39 +0200
To: pgsql-sql@postgresql.org
Subject: [SQL] Function does not return, but gives error..
I have the following function to determine wether or not a user is
member of a group,
On Thu, Jun 16, 2005 at 02:26:39PM +0200, M.D.G. Lange wrote:
IF groupres = NULL
THEN
...
END IF;
is not trapped...
Be sure to understand how NULL works in comparisons:
http://www.postgresql.org/docs/8.0/static/functions-comparison.html
SELECT NULL = NULL;
?column?
--
(1 row)
my bad: please forget my previous mail, I tested it with a filled group,
which is of course not empty...
the solution was correct, thanks!
Gnanavel Shanmugam wrote:
-Original Message-
From: [EMAIL PROTECTED]
Sent: Thu, 16 Jun 2005 14:26:39 +0200
To: pgsql-sql@postgresql.org
Subject:
Hi J!
We use here vitavoom from Steve Howe (www.vitavoom.com). It's a very
good and native alternative.
It's paid but not expensive and you will have a very good and qualified
technical supporte.
Regards,
Rodrigo Carvalhaes
Postgres Admin wrote:
I have a client who wants to use Delphi as
Hi !
This is not possible because the query will have a time interval and the
subtotal will change due the intervals passed to the query...
To get the subtotal I already know how to do it (see below) but the
problem is get the correct output, ordering by the bigger totals
agrouped by product
We tested also (pgExpress Driver) - is faster then psqlodbc but we have a
problem with it:
it does requery (or refresh? - I don't remember exactly) after every post
in database.(for us this is a problem - if you have more then 10.000 in
current dataset loaded when you add a new record and
This might work,
select * from (SELECT * FROM product_sales()) t order by t.code
desc,t.subtotal;
with regards,
S.Gnanavel
-Original Message-
From: [EMAIL PROTECTED]
Sent: Thu, 16 Jun 2005 10:07:15 -0300
To: [EMAIL PROTECTED], pgsql-sql@postgresql.org
Subject: Re: [SQL] SELECT with
Hi Adrian,
You're right. What we did was include one refresh button and inserted
one configuration that after x seconds the component refresh the screen
(query).
If you find a better solution, please inform me.
Regards,
Rodrigo
Din Adrian wrote:
We tested also (pgExpress Driver) - is
I am sorry - I don't understand (or my english is bad or I don't know
what you mean).
What we did was include one refresh button and inserted one
configuration that after x seconds the component refresh the screen
(query).
So:
When the user push the 'post' button the driver
On Wed, 2005-06-15 at 17:08, Thomas Kellerer wrote:
PFC wrote on 15.06.2005 22:04:
It's not the program or Java. The same program takes about 20 seconds
with Firebird and the exactly same data.
Hm, that's still very slow (it should do it in a couple seconds like
my PC
works fine for me. Do you have any triggers on the tables or other rules? Can
you provide a complete SQL script that
starts from an empty database.
Jim
-- Original Message ---
From: Neil Dugan [EMAIL PROTECTED]
To: pgsql-sql@postgresql.org
Sent: Thu, 16 Jun 2005 13:38:58
On 16.06.2005 16:00 Scott Marlowe wrote:
There's got to be more happening than what this is showing us. A
select, and looping through it, should involve no writes, and therefore
no real performance difference from autocommit versus not. Is there
some underlying trigger on the view or
On Wed, Jun 15, 2005 at 06:45:56PM -0400, Vsevolod (Simon) Ilyushchenko wrote:
While those that fail look like this:
Request select * from material_pkg.ListCautions_fcn($1,$2) as result B
Response result unnamed portal 1C SELECT
Note that the successful ones contain strings S_1 and BEGIN,
Hi Adrian!
Yes, the user have to wait until the refresh finishes... That's a
problem but we didn't found any other solution...
Regards,
Rodrigo Carvalhaes
Din Adrian wrote:
I am sorry - I don't understand (or my english is bad or I don't
know what you mean).
What we did was include
Hi Gnanavel,
Thanks for your promptly answer. Yes, your solution solves this problem
BUT the point is that I don't wanna a solution that works only if the
codes are in desc order.
For example, if the codes are on the order above:
INSERT INTO test (code, description, quant, price, total)
If autocommit is on (or fetch size is zero) then the driver will build
the whole
result set before returning to the caller.
Sure, but that is not your problem : even building the whole result set
should not take longer than a few seconds (I gave you test timings in a
previous
On 16.06.2005 17:29 PFC wrote:
If autocommit is on (or fetch size is zero) then the driver will
build the whole
result set before returning to the caller.
Sure, but that is not your problem : even building the whole result
set should not take longer than a few seconds (I gave you
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I need an subtotal for all the products with the same group and that the
query be ordered by the bigger subtotal.
(please proofread: the subtotals in your example output did not add up)
By same group I presume you mean the same code, as you
Reading through the docs, both the CREATE VIEW and CREATE RULE pages refer
to how you can use a RULE to 'simulate' an updateable VIEW ... but I can't
seem to find any examples of this ...
Does anyone know of an online example of doing this that I can read
through?
Thanks ...
Marc G.
There is a write up on these at:
http://www.varlena.com/GeneralBits/82.php
--elein
[EMAIL PROTECTED]Varlena, LLCwww.varlena.com
PostgreSQL Consulting, Support Training
PostgreSQL General Bits
Here's one I did a while ago; the tables are trivial in this case (and
the whole thing is definitely overkill) so it should make it easier to
digest.
This becomes useful if you use some sort of ORM layer (Class::DBI in my
case) that can be made to recognize the 'type' column and behave
On Thu, Jun 16, 2005 at 06:05:03PM -0300, Marc G. Fournier wrote:
Reading through the docs, both the CREATE VIEW and CREATE RULE pages refer
to how you can use a RULE to 'simulate' an updateable VIEW ... but I can't
seem to find any examples of this ...
Are you looking for Cooperation with
The autoreplies mentioned in these threads are still happening:
http://archives.postgresql.org/pgsql-sql/2005-06/msg00102.php
http://archives.postgresql.org/pgsql-sql/2005-06/msg00097.php
I can tweak my filters to drop the autoreplies, but shouldn't this
person either fix their mail
I'll just second that this is, in fact, extremely annoying.
Dmitri
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Michael Fuhr
Sent: Thursday, June 16, 2005 11:16 PM
To: pgsql-sql@postgresql.org
Subject: [SQL] Still getting autoreplies from list member
On Friday 17 Jun 2005 8:46 am, Michael Fuhr wrote:
The autoreplies mentioned in these threads are still happening:
http://archives.postgresql.org/pgsql-sql/2005-06/msg00102.php
http://archives.postgresql.org/pgsql-sql/2005-06/msg00097.php
I can tweak my filters to drop the autoreplies, but
Does that make sense? Would it ever get used? I can't see it, but
figured I'd ask ...
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664
---(end of
Marc G. Fournier [EMAIL PROTECTED] writes:
Does that make sense? Would it ever get used?
It could get used if one of the two values is far less frequent than the
other. Personally I'd think about a partial index instead ...
regards, tom lane
how about an very large table with a processed type flag?
uru
-Dave
Marc G. Fournier wrote:
Does that make sense? Would it ever get used? I can't see it, but
figured I'd ask ...
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [EMAIL PROTECTED]
On Fri, 17 Jun 2005, Tom Lane wrote:
Marc G. Fournier [EMAIL PROTECTED] writes:
Does that make sense? Would it ever get used?
It could get used if one of the two values is far less frequent than the
other. Personally I'd think about a partial index instead ...
Hr, hadn't thought of
On 6/17/05, Marc G. Fournier [EMAIL PROTECTED] wrote:
On Fri, 17 Jun 2005, Tom Lane wrote:
Marc G. Fournier [EMAIL PROTECTED] writes:
Does that make sense? Would it ever get used?
It could get used if one of the two values is far less frequent than the
other. Personally I'd think
35 matches
Mail list logo
