Re: [GENERAL] drop view with out cascading the dependents

That's true . it wont work if we add remove the columns. I wanted to add column to view and change the data type to existing column -Original Message- From: Grzegorz Jaśkiewicz [mailto:gryz...@gmail.com] Sent: Tuesday, October 19, 2010 7:50 PM To: Tom Lane Cc: Ravi Katkar;

[GENERAL] drop view with out cascading the dependents

cascading its dependents, after that I created the view it should have its dependents as to that of older one. Thanks in advance. Thanks, Ravi Katkar

Re: [GENERAL] [ODBC] resultset metadata libpq

Hi, I had referred below link I could not able to locate or identify api to retrieve information like precision, scale, nullability. Thanks, Ravi Katkar -Original Message- From: willfurn...@googlemail.com [mailto:willfurn...@googlemail.com] On Behalf Of William Furnass Sent

Re: [GENERAL] resultset metadata libpq

From: Ravi Katkar Sent: Tuesday, July 27, 2010 5:45 PM To: 'pgsql-general@postgresql.org'; 'pgsql-o...@postgresql.org' Subject: resultset metadata libpq Hi List, I am using libpq c api to connect postgresql server. I wanted to retriev

[GENERAL] resultset metadata libpq

Hi List, I am using libpq c api to connect postgresql server. I wanted to retrieve the below metadata information for a column from resultset. Column name, ( PQfname ) type, (PQftype ) precision, ( ?) scale, (?) nullability(?) Thanks in advance Regards, Ravi Katkar

[GENERAL] ODBC and configure

tried with SERVER=localhost and xhost+localhost, again Severname=localhost and xhost+localhost nothing is working after re-compiling and running the .c file. Thanks, Ravi Katkar

[GENERAL] Unable to create a Postgre Datasource from windows With Database installed in RHEL 5.3

From: Ravi Katkar Sent: Thursday, July 15, 2010 2:45 PM Hi List , I have installed PostgreSQL server in RHEL 5.3. I can able to start the database and also able to work on the DB by creating tables etc. When I am trying to connect thru ODBC from windows

[GENERAL] Global temporary table - schema

schema I wish. Any ideas? Thanks in advance. -- Ravi Katkar

[GENERAL] disable password prompt - command line

me of the options avail with PSQL. Thanks, Ravi Katkar

[GENERAL] disable password prompt - command line

of the options avail with PSQL. Thanks, Ravi Katkar

[GENERAL] Do ODBC - Posgresql supports refcursor?

guide or document on ODBC guide which can help. Thanks, Ravi Katkar

[GENERAL] handling out parameter

N --vvar := 10; vout := 10; perform adf(vout) ; RETURN; END; $BODY$ LANGUAGE 'plpgsql'; I have a couple of questions on above function 1) Why the return type is record after compiling? 2) How to catch the return value of out parameter for above case value of vVar. Thanks, Ravi Katkar

Re: [GENERAL] Transaction with in function

: pgsql-general@postgresql.org Subject: Re: [GENERAL] Transaction with in function In response to Ravi Katkar : > > > I looking for solution for commit, rollback with in function. You can't use transactions within functions, use savepoints instead. http://www.postgresql.org/docs/

[GENERAL] Transaction with in function

pgsql'; Thanks in advance . Regards Ravi Katkar

[GENERAL] returning ref cursor

t; is null SQL state: 22004 Context: PL/pgSQL function "test_call" line 7 at FETCH Thanks, Ravi Katkar