Re: Few Simple Questions

From: Jonathan Bartlett <johnnyb(at)eskimo(dot)com>
To: Ivan <iv(at)psycho(dot)pl>
Cc: Richard Huxton <dev(at)archonet(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Few Simple Questions
Date: 2003-02-28 20:19:54
Message-ID: Pine.GSU.4.44.0302281218350.13762-100000@eskimo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> tru, bat its not very good idea, because there can be duplicate keys,

Create the temporary table with a primary key.

> or what with broken transmision ???

How is that different than a normal session variable?

> better will be something like SET .. ???

How would it be any different?

You could wrap it with functions. create_session() set_variable('name',
'value') get_variable('name')

Jon
>
> > > > how can declare and define my own variables in each connect to db, and
> > > > read it / or change it in plpgsql function ?
> >
> > You can do this, I believe, by creating a temporary table holding
> > key/value pairs.
> >
> > Jon
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
> >
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2003-02-28 20:22:58 Re: phpBB2 slow on postgres vs mysql ?
Previous Message Ivan 2003-02-28 20:15:09 Re: Few Simple Questions