Re: [SQL] Postgres DB

2004-06-08 Thread Sumita Biswas
Hi Tom, I have read that template1 is the default DB that gets installed with Postgres. But when I type the command "psql" and don't specify a DB name, it says that: psql: FATAL: Database "postgres" does not exist in the system catalog. This is the reason why I guessed that it expects the postg

[SQL] Postgres DB

2004-04-26 Thread Sumita Biswas
Hi All, Our application is using the Postgres 7.3.4-RH database that is packaged with the AS3.0 for CCM. There is a variable type called refcursor that is being used by CAR Functions in Postgres database. This variable works fine when we execute the postgres Function from the database i.e through

Re: [SQL] Postgres DB

2004-02-29 Thread Michael Chaney
On Mon, Feb 23, 2004 at 02:24:32PM +0530, Sumita Biswas wrote: > The following Query string , when executed does not give an Error, even > though the table Tbl_Billing_Data is not present. > > QueryToPopulateTemp := ''INSERT INTO Tmp_Conference(ConferenceType, > CallManagerId, ClusterId, DestConve

Re: [SQL] Postgres DB

2004-02-28 Thread Sumita Biswas
The following Query string , when executed does not give an Error, even though the table Tbl_Billing_Data is not present. QueryToPopulateTemp := ''INSERT INTO Tmp_Conference(ConferenceType, CallManagerId, ClusterId, DestConversationId, ConnectDate, FinalDestination)''+'' SELECT 2, Global_CallId_Ca

Re: [SQL] Postgres DB

2004-02-22 Thread Tom Lane
"Sumita Biswas" <[EMAIL PROTECTED]> writes: > But when I type the command "psql" and don't specify a DB name, it says > that: > psql: FATAL: Database "postgres" does not exist in the system catalog. Yes, because psql's default behavior is to try to connect to the DB with the same name as your use

Re: [SQL] postgres DB temporary on NT

2001-03-19 Thread Ross J. Reedstrom
On Mon, Mar 19, 2001 at 11:23:45AM +0100, [EMAIL PROTECTED] wrote: > Hi there > > For testing, I have a Microsoft Windows NT Server with IIS 4.0 running in > my DMZ. Currently it is not possible to migrate this server to LinuX. Is > there a way to move an existing postgreSQL 7.0.3 db (with views/

[SQL] postgres DB temporary on NT

2001-03-19 Thread juerg . rietmann
Hi there For testing, I have a Microsoft Windows NT Server with IIS 4.0 running in my DMZ. Currently it is not possible to migrate this server to LinuX. Is there a way to move an existing postgreSQL 7.0.3 db (with views/sequences) from a Linux Server to this NT Web server. I have coldfusion on NT