[GENERAL] dblink & 4 master operation

2009-09-12 Thread Mohsen Pahlevanzadeh
Dear all, My boss requested me that i use dblink even for a sample INSERT, now i have a INSERT query, But i don't know how to invoke insert query without select query. I have search for doc in this topic, But i just saw API ref in postgresql.org. Can u help me? Yours, Mohsen -- Sent via pgsql-

Re: [GENERAL] dblink & 4 master operation

2009-09-12 Thread Mohsen Pahlevanzadeh
/ I need to insert into ipmap table with ip & username columns.Please help me... On Sat, 2009-09-12 at 16:10 +0430, Mohsen Pahlevanzadeh wrote: > Dear all, > > My boss requested me that i use dblink even for a sample INSERT, now i > have a INSER

[GENERAL] libpq & its header files

2005-02-21 Thread Mohsen Pahlevanzadeh
Dears,I have started to working with libpq.But i don't know name of its header files.Please guide me. Yours,Mohsen. ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[GENERAL] tables & retrieving their names

2005-02-21 Thread Mohsen Pahlevanzadeh
Dears,I'm newbie in pgsql. I have a few question: 1.I need to use command of MySQL in pgsql. 2.How i see name of my tables in shell? 3.How i see name of my DBs in shell? 4.How i retrieve tables's name in C? 5.How i retrieve DBs's name in C? Yours,Mohsen. ---(end of broadca

[GENERAL] PQsetdb

2005-02-23 Thread Mohsen Pahlevanzadeh
Dears,I have added following constructor to my class: class CPgsql : public CCore { public: char *pghost, *pgport, *pgoptions, *pgtty; char *dbName; PGconn *connection2db; const char * conninfo;

Re: [GENERAL] PQsetdb

2005-02-23 Thread Mohsen Pahlevanzadeh
My program is using both MySQL & PostgreSQL.I don't have problem with Mysql.But i have problem with pgsql. > Mohsen Pahlevanzadeh wrote: >> I recieve following error: >> [EMAIL PROTECTED] sql2sql]# make >> g++ -c -I/usr/include/mys

Re: [GENERAL] PQsetdb

2005-02-23 Thread Mohsen Pahlevanzadeh
If you see my orginal email,I mentioned to link to inc & lib for pgsql.Even when i use PQsetdb,I didn't recieve error message for using PQsetdb. Yours,Mohsen > > On Wed, 23 Feb 2005, Mohsen Pahlevanzadeh wrote: > >> My program is using both MySQL & PostgreSQL.I don'

Re: [GENERAL] PQsetdb

2005-02-23 Thread Mohsen Pahlevanzadeh
: sql2sql.cpp $(CXX) -c $(mysql_INCS) $(pgsql_INCS) sql2sql.cpp; clean : rm -rf sql2sql.o rm -rf sql2sql ~ > [EMAIL PROTECTED] > > On Wed, 23 Feb 2005, Mohsen Pahlevanzadeh wrote: > >> If you see my orginal email,I mentioned to link to inc & lib for &g

[GENERAL] library files

2005-02-23 Thread Mohsen Pahlevanzadeh
Dears,Now i can't link any library to my executable file,Please guide me that i can use mysql along with pgsql.(mysql needs to add library to executable file) Yours,Mohsen ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose

[GENERAL] Reading from Mysql & writting in PGsql

2005-02-28 Thread Mohsen Pahlevanzadeh
Dears,I need to read 1 field with select command from mysql.Then Write it to pgsql. Please guide me. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMA

[GENERAL] PGconn

2005-02-28 Thread Mohsen Pahlevanzadeh
Dears,I need to connect to the PostgreSQL without choosing database in C. Please guide me.. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTEC

[GENERAL]

2005-02-28 Thread Mohsen Pahlevanzadeh
Dears,I need to create an pgsql user in C. Please guide me Yours,Mohsen. ---(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

[GENERAL]

2005-03-14 Thread Mohsen Pahlevanzadeh
Dears, When i wanna insert to my following code,I receive following error: Insert into c(t) values('ccc'); --> It's my qurey. Insert command failed!So i can't continue to insert in your table! ERROR: pg_atoi: error in "ccc": can't parse "ccc" my code : pres = PQexec(pobj->connect

[GENERAL] I'm newbie

2005-02-18 Thread Mohsen Pahlevanzadeh
Dears, I'm writting a package which is pgsql-base under RH9. I need to a small Makefile for compiling my package. Please guide me ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/f

Re: [GENERAL] I'm newbie

2005-02-18 Thread Mohsen Pahlevanzadeh
I know about Makefile,But i need to write a Makefile that i can communicate with pgsql & its library & header file from C++. > Mohsen Pahlevanzadeh wrote: >> Dears, >> I'm writting a package which is pgsql-base under RH9. >> I need to a small Makefile for compil

Re: [GENERAL] I'm newbie

2005-02-18 Thread Mohsen Pahlevanzadeh
Dear Richard: 1.Thank you for reply 2.Dear Richard,I must write a Makefile for my client packge.But i don't know on pgsql's library & path of its include-files. Please guide me on writting a Makefile for a client packege with pgsql. Yours,Mohsen > Mohsen Pahlevanzadeh wrote

Re: [GENERAL] I'm newbie

2005-02-19 Thread Mohsen Pahlevanzadeh
> Mohsen Pahlevanzadeh wrote: >> Dear Richard: >> 1.Thank you for reply >> 2.Dear Richard,I must write a Makefile for my client packge.But i don't >> know on pgsql's library & path of its include-files. > > Depends on how you installed PostgreSQL. If