Re: [BUGS] session variable

2003-09-02 Thread sad
On Monday 01 September 2003 20:57, you wrote: > sad wrote: > > Good day > > > > is it possible to define user variables in session ? > > If not then is it planned to implement ? > > or it is principially impossible in PosqtgreSQL > > psql has variables,

[BUGS] session variable

2003-09-01 Thread sad
Good day is it possible to define user variables in session ? If not then is it planned to implement ? or it is principially impossible in PosqtgreSQL ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if yo

[BUGS] DDL and transactions

2003-08-22 Thread sad
Why does a DDL command starts a transaction ?! try # set autommit=off; SET # create table a (i int); CREATE TABLE # create table b (i int); ERROR: current transaction is aborted, queries ignored until end of transaction block # commit; COMMIT # create table b (i int); CREATE TABLE # \d

[BUGS] feature request

2003-08-14 Thread sad
hi all it would be good to have RETURNING clause in INSERT,UPDATE,DELETE queries. similar to Oracle's one but more clever. Oracle's "RETURNING" is just a disguised independant SELECT wich is not wanted. i found "RETURNING" usable if it returns just inserted or just deleted record. e.g. i have som

[BUGS] what about function parameter count limit?

2003-07-29 Thread sad
good day we are suffering of the limit of parameters count in functions 16 parameters is not enough ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMA