Re: Creating a session variable in Postgres
От | Nagib Abi Fadel |
---|---|
Тема | Re: Creating a session variable in Postgres |
Дата | |
Msg-id | 001401c44939$0f0c3bc0$8a64a8c0@nagib обсуждение исходный текст |
Ответ на | Re: Creating a session variable in Postgres (Bruce Momjian <pgman@candle.pha.pa.us>) |
Ответы |
Re: Creating a session variable in Postgres
|
Список | pgsql-general |
Well i thought about that but i don't feel like it is a clean way. Actually i need to create a dynamic view depending on the user choice of a certain variable via a web application. Let's say for example the variable is called "X". The view is called "t_view" and the temporary table is called "t_temp". Each time a user connects to the web, the application will initialize the variable X and it will be inserted into the temporary table t_temp. i defined the following view: CREATE VIEW t_view as select * from SomeTable where id = (select X from t_temp); This didn't work first cause the temporary table does not exist. So i created the temporary table then created the view "t_view" and then the view was created (i kind of fooled the system). Now every time a user access the web application he will choose a value for X and the t_temp will be created and X inserted in it. I solved my problem but it does not seem like a "clean way". Any ideas ?? I have now a DYNAMIC view ----- Original Message ----- From: "Bruce Momjian" <pgman@candle.pha.pa.us> To: "Nagib Abi Fadel" <nagib.abi-fadel@usj.edu.lb> Cc: "generalpost" <pgsql-general@postgresql.org> Sent: Wednesday, June 02, 2004 04:53 PM Subject: Re: [GENERAL] Creating a session variable in Postgres > Nagib Abi Fadel wrote: > > Is it possible to create a session variable for each user in Postresql ?? > > No. The best you can do is create a temp table and put a value in > there. > > -- > Bruce Momjian | http://candle.pha.pa.us > pgman@candle.pha.pa.us | (610) 359-1001 > + If your life is a hard drive, | 13 Roberts Road > + Christ can be your backup. | Newtown Square, Pennsylvania 19073 > > ---------------------------(end of broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match
В списке pgsql-general по дате отправления: