Joel Fradkin wrote:
I was using SET TRANSACTION ISOLATION LEVEL SERIALIZABLE in MSSQL.
Is there something similar in postgres to ensure its not in the middle of
being updated?
Yep - see the SQL COMMANDS reference section under SET TRANSACTION ...
You could use LOCK TABLE too.
See Chapter 12 -
I actually had the same thought (a counter table, I might be able to add
fields to the location table, but we have several applications case is just
an example). I agree that is probably the safest way and it also fixes
another issue I have been having when a user wants to transfer a case to
On Mon, May 16, 2005 at 17:36:21 -0400,
Joel Fradkin [EMAIL PROTECTED] wrote:
I was using SET TRANSACTION ISOLATION LEVEL SERIALIZABLE in MSSQL.
Is there something similar in postgres to ensure its not in the middle of
being updated?
Postgres also has SET TRANSACTION ISOLATION LEVEL
SELECT your_concat( memo_text ) FROM
(SELECT memo_id, sequence, memo_text FROM table ORDER BY memo_id,
sequence
OFFSET 0) AS foo
GROUP BY memo_id
I'm just curious - what's the 'OFFSET 0' for?
Dmitri
---(end of broadcast)---
TIP 5: Have you
You can select for update, so you ensure that the rows are locked for
your current transaction's use exclusively. If the rows in question had
been modified by another ongoing transaction, then the select will get
blocked until the other transaction is finished.
Cheers,
Ezequiel Tolnay
[EMAIL
Anybody know how to return a setof from a plpython function?
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Hi:
Oracle has a pseudo-column ROWNUM to return the sequence number in which a
row was returned when selected from a table. The first row ROWNUM is 1, the
second is 2, and so on.
Does Postgresql have a similar pseudo-column ROWNUM as Oracle? If so, we can
write the following query:
select *
Hi,
The issue is due to records in Account_message is still exists for the
records which are going to be deleted from the Message table. Please check the
sequence of deleting the records.
When I tried to delete a record using your example, the following exception is
raised.
ERROR: update
On Thu, May 12, 2005 at 01:07:00PM -0600, [EMAIL PROTECTED] wrote:
Does Postgresql have a similar pseudo-column ROWNUM as Oracle? If
so, we can write the following query:
No. What is the purpose of your query? You could use ORDER BY and
LIMIT..OFFSET to do what you want. I think.
A
--
On Thu, 2005-05-12 at 14:07, [EMAIL PROTECTED] wrote:
Hi:
Oracle has a pseudo-column ROWNUM to return the sequence number in which a
row was returned when selected from a table. The first row ROWNUM is 1, the
second is 2, and so on.
Does Postgresql have a similar pseudo-column ROWNUM as
Andrew Sullivan escreveu:
On Thu, May 12, 2005 at 01:07:00PM -0600, [EMAIL PROTECTED] wrote:
Does Postgresql have a similar pseudo-column ROWNUM as Oracle? If
so, we can write the following query:
No. What is the purpose of your query? You could use ORDER BY and
LIMIT..OFFSET to do what you
I am trying to find the best way for a database trigger to signal a
client process to take an action.
Specifically, I am working on the classic problem of creating and
modifying system accounts based on the updates to a person registry
database.
The basic model I'm working with has triggers
On Tue, 2005-05-17 at 14:48 -0300, Alain wrote:
Andrew Sullivan escreveu:
On Thu, May 12, 2005 at 01:07:00PM -0600, [EMAIL PROTECTED] wrote:
Does Postgresql have a similar pseudo-column ROWNUM as Oracle? If
so, we can write the following query:
No. What is the purpose of your
On 05/17/2005 01:07 PM, Bricklen Anderson wrote:
How about LISTEN and NOTIFY, would they work for this?
Yes, that is precisely what I need... and what I have somehow overlooked
during at least a dozen passes through the docs. Sigh.
Thanks for your help,
-jbp
--
Jay Parker - UALR Computing
Scott Marlowe wrote:
Use a bytea field and use pg_escape_bytea() to prepare the data for
insertion.
Thanks Scott, I will try it now.
J
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
On Tue, 2005-05-17 at 13:15, Postgres Admin wrote:
Hi
I'm trying to insert encrypted data into the database and I'm noticing
error dealing with quotes. Below is the error print out...
suggestions and/or at least point me in the direction to find a solution,
Thanks,
J
INSERT
No. What is the purpose of your query? You could use ORDER BY and
LIMIT..OFFSET to do what you want. I think.
The problem is probably speed. I have done a lot of tests, and when
OFFSET gets to a few thousands on a multimega-recs database, it gets
very very slow...
is there not a similar loss
On Tue, May 17, 2005 at 03:43:32PM -0300, Alain wrote:
I tried using both the name and the primary key (with a combined index),
to get faster to the record I want, but I was not sucessfull in building
a where clause.
I would appreciate any help, in fact this is my primary reason for
On Tue, 2005-05-17 at 15:43 -0300, Alain wrote:
[how to solve the get next 100 records problem]
I am assuming this is for a web like interface, in other words that
cursors are not applicable
[me]
if you are ordering by a unique key, you can use the key value
in a WHERE clause.
your subsequent selects are
select ... from tab WHERE skeyskey_last
OR (skey=skey_last AND pkeypkey_last)
ORDER BY skey,pkey
LIMIT 100 OFFSET 100;
why offset ?
you should be able to use the skey, pkey values of the last row on the
On Wed, 2005-05-18 at 00:13 +0200, PFC wrote:
your subsequent selects are
select ... from tab WHERE skeyskey_last
OR (skey=skey_last AND pkeypkey_last)
ORDER BY skey,pkey
LIMIT 100 OFFSET 100;
why offset ?
you
Ragnar Hafstað escreveu:
[how to solve the get next 100 records problem]
I tried that. It does not work in the generic case: 6 MegaRec, telephone
listing, alphabetical order.
lets say pkey is your primary key and skey is your sort key, and
there exists an index on (skey,pkey)
your first
22 matches
Mail list logo