Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group