Re: Few Simple Questions - Mailing list pgsql-general

From Jonathan Bartlett
Subject Re: Few Simple Questions
Date
Msg-id Pine.GSU.4.44.0302281218350.13762-100000@eskimo.com
Whole thread Raw
In response to Re: Few Simple Questions  (Ivan <iv@psycho.pl>)
List 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
> >
>


pgsql-general by date:

Previous
From: Dmitry Tkach
Date:
Subject: Re: postgres error reporting
Next
From: Ivan
Date:
Subject: Re: Few Simple Questions