> how can i implement transactions inside my plpgsql functions
I would guess that this is not possible since postgres don't support
nested transactions(?).
--
/Nils Höglund, Naqua KB
E-mail: [EMAIL PROTECTED]
Web:http://www.naqua.se/
Home Phone: +46 (0)18 30 09 19
C
Le Jeudi 27 Juin 2002 13:50, q u a d r a a écrit :
> What's the best open source GUI for DB administration? (postgres)
Why ? Mine of course !
Noway for this stupid answer !
Well, I would say that you have at least two choices amongst those I know :
phpPgAdmin, which works as it's name says with p
Joe,
> how can i implement transactions inside my plpgsql functions
You can't.
Each PL/pgSQL function is automatically treated as a single transaction
by Postgres. As such, the entire function either succeeds or fails.
To manage a transaction *inside* the PL/pgSQL function, Postgres would
h
how can i implement transactions inside my plpgsql functions
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Keith Gray <[EMAIL PROTECTED]> writes:
> ...but is it true that if you place the filter clause first,
> the join will not have to complete the whole table?
PG's planner does not pay attention to the ordering of WHERE clauses;
it will do what it thinks best with them in any case.
I have a query that returns
?column?
-
6 days 01:56:14
(1 row)
How can I get it as total number of hours?
Instead of days and hours, I need hours only (all in all, so 24hours * 6
days + 01:56:14)
Can you help me please? Thanks
---(end of bro
> The problem isn't in the select.
>
> I realize that my database is growing and growing.
>
> I've two tables that have, lets say, 120.000 records each, and:
> - delete about 30.000 records a day from each table
> - insert about 30.000 records a day on each table
> - update each record at least
Masaru Sugawara wrote:
>
> You are right. And this type of optimising are not yet implemented.
> Tom said it in the prior discussions.
>
...but is it true that if you place the filter clause first,
the join will not have to complete the whole table?
eg.
SELECT item.description, stock.avai
Can someone please tell me how to unsubscribe from all the pgsql lists?
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Perhaps this was covered in the 7.2.x release notes, but it's mystifying us:
select to_char(time_link,'999.99') from stat_fetch
where time_link is not null
order by 1 desc limit 10;
(time_link is a double-precision column.) Under 7.1.3, this returns results like:
to_char
-
9.99
On Thu, Jun 27, 2002 at 04:24:04PM +0100, Marcos Garcia wrote:
> On Mon, 2002-06-24 at 22:43, Stephan Szabo wrote:
> > On 24 Jun 2002, Marcos Garcia wrote:
> >
> > Hmm, that should only happen if you're doing alot of updates or deletes
> > I would guess (updates would cause it to slow down as wel
On Thu, Jun 27, 2002 at 07:50:09PM +0800, q u a d r a wrote:
>
> What's the best open source GUI for DB administration? (postgres)
Emacs. ;)
--
Ron Peterson -o)
87 Taylor Street /\\
Granby, MA 01033 _\_v
https://www.yellowbank.com/
-
On 27 Jun 2002, Marcos Garcia wrote:
> On Mon, 2002-06-24 at 22:43, Stephan Szabo wrote:
> > On 24 Jun 2002, Marcos Garcia wrote:
> >
> > Hmm, that should only happen if you're doing alot of updates or deletes
> > I would guess (updates would cause it to slow down as well since it's
> > similar t
On Wed, 26 Jun 2002 22:18:07 +0200
Dennis Kaarsemaker <[EMAIL PROTECTED]> wrote:
> From a copy of the CDDB-database i want to select the artist & album that
> has on average the longest tracks.
>
> But in the tracks table there is no such field as length, so i have to
> calculate it. But when i
On Mon, 2002-06-24 at 22:43, Stephan Szabo wrote:
> On 24 Jun 2002, Marcos Garcia wrote:
>
> Hmm, that should only happen if you're doing alot of updates or deletes
> I would guess (updates would cause it to slow down as well since it's
> similar to a delete and insert under MVCC). And frequent
On Thursday 27 Jun 2002 10:52 am, Jörg Holetschek wrote:
> Hi folks,
>
> I have a problem with a CHECK clause that doesn't seem to work properly.
> WHEN ((focus <> NULL) AND (epilepsy_class = 'f')) THEN
> WHEN ((focus <> NULL) AND (epilepsy_class IN ('g',
Tom Lane wrote:
> It won't happen. See the many, many prior discussions of this point in
> the archives.
Hmm, I searched the archives both in my local mailbox and on Google,
could you give me some pointer to a relevant thread? I certainly
want to learn from past discussions.
So, it's that MVC
On Wed, 26 Jun 2002 17:34:47 +0200
Alvar Freude <[EMAIL PROTECTED]> wrote:
> Hi,
>
> -- Eric <[EMAIL PROTECTED]> wrote:
>
> > If I perform the following 2 selects, the first one is EXTREMELY slow
> > where the 2nd one is very fast.
>
> [...]
>
> > Why would 2 be so much faster? I have ran
On Thu, Jun 27, 2002 at 11:52:54AM +0200, J?rg Holetschek wrote:
> Hi folks,
>
> I have a problem with a CHECK clause that doesn't seem to work properly. The
> CASE
> WHEN ((focus <> NULL) AND (epilepsy_class = 'f')) THEN
> TRUE
> WHEN
"Jörg Holetschek" <[EMAIL PROTECTED]> writes:
> CASE
> WHEN ((focus <> NULL) AND (epilepsy_class = 'f')) THEN
> TRUE
Try "focus IS NOT NULL".
regards, tom lane
---(end of broadcast)-
Hi folks,
I have a problem with a CHECK clause that doesn't seem to work properly. The
CREATE TABLE statement looks like this:
CREATE TABLE epilepsy_information (
[...]
epilepsy_class Char
CHECK (epilepsy_class IN ('f', 'g', 'n')),
focusInteg
I'm having trouble figuring out how to select something.
This is the problem:
>From a copy of the CDDB-database i want to select the artist & album that
has on average the longest tracks.
But in the tracks table there is no such field as length, so i have to
calculate it. But when i try to do so
What's the best open source GUI for DB administration? (postgres)
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
23 matches
Mail list logo
