[GENERAL] Postgresql installation with ssh connection.

dear Sirs, is there on the web a simple guide (for idiots) to install postgresql on CentOS 5.2 using only a ssh connection? (no web browser, no graphical capability). My first problem is to download using ftp instead a web browser. The default installation (#yum install opstresql)suggest

[GENERAL] Thank you

Thank you very much to all people!!! I reached the goal using lynx to dowload the rpms and then the An Almost Idiots's Guide To PostgreSQL YUM from Postgres OnLine Journal Domenico -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

[GENERAL] How to configure PostgreSQl for low-profile users

Dear Sirs, I would like to rent a my application to a number of customer, each with a dedicated database (and perhaps a dedicated username). The database will be installed on 'public IP' machine and will be accessed by internet on standard port 5432 and using ODBC driver from several clients

[GENERAL] How to get the real postgreql error from visual basic

Dear Sirs, when I execute a function that returns an error, visual basic shows always the same error code ( -214767259) but I would like to know the real postgres code of the error. The visual basic code that I use is the following: Dim Cmd As new ADODB.Command Cmd.CommandText = delete from

[GENERAL] Returns cursor?

Hi Guru, can a function returns a cursor? Thank you! Domenico -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Recovery from another installation

Dear Sirs, my question if it is possible to recovery a set of databases from a directory 'data' of a different machine. I have a machine with Postegres 2.5 and Windows 2000 crashed (OS does not start) but with filesystem OK, and another machine (with XP PRO and Postgres also 2.5). Can I copy the

[GENERAL] Connect to postgres from a dynamic IP

Dear Sirs, it is possible to connect to PostgreSQL server from a client with a dynamic IP (or from an unknown IP)? How I have to configure pg_hba.conf (and/or eventually my router, where the server is located)? I have no possibility to change the settings of clients (my customers) Thank you.

Re: [GENERAL] Connect to postgres from a dynamic IP

I apologize for my confuse exposition. My server has a static, well known IP. The problem is that I don't know the IP of my customers (client side) and then I cannot insert those addresses in pg_hba.conf file. The question il: Is there a method to avoid to insert the addesses of the clients in

[GENERAL] how to add array of objects to a record

Hi list, Can I add an array of object to a record? For example if I have a class (or type) phone_number: create type phone_number as( name char(20), caption char(50), ph_num char(25)); and I would like associate several (unknown number, a priori) phone numbers to a record persons can I create

R: [GENERAL] how to add array of objects to a record

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of dfx Sent: Sunday, 3 February 2008 10:38 To: pgsql-general@postgresql.org Subject: [GENERAL] how to add array of objects to a record Hi list, Can I add an array of object to a record? For example if I have a class

[GENERAL] Increase the number of concurrent connection

Dear sirs, how I have to modify postgresql.conf to increase the number of concurrent connection over the value 100 setted by by default? I tryied to modify this value but the server get an error and not start. My version is 8.2.5 on Linux Fedora 8. The PC has 2 GB ram and Celeron 2.8 processor.

[GENERAL] How to install Postgresql on MS Vista?

I tryied it but get errors on create user postgres. Is there some workaround? Thank you Domenico ---(end of broadcast)--- TIP 6: explain analyze is your friend

[GENERAL] Check the existance of temporary table

Dear Sirs, how I can check the existance of temporary table? I.e. wich query I have to use to know if MY_TEMP_TABLE exists? IF EXISTS(??? query ???) THEN Thank you in advance Domenico ---(end of broadcast)--- TIP 1: if posting/reading through

[GENERAL] Keyword OWNED not recognized in pg v. 8.1

Thank you Tom, I tryied in any way to upgrade to 8.2 but I get only v. 8.1.8 (with yum). I tryied also with .rpm downloaded from postgres official site but I get a lot of unresolved dependencies. So I ask if it exist a document that explain step by step the process to upgrade v. 8.1 to v. 8.2

[GENERAL] Keyword OWNED not recognized in pg v. 8.1

Dear Sirs, I am trying to create a database in postgres v. 8.1 (Fedora core 6) using a sql script created from pg version 8.2 (Windows) (using backup.text of PgAdminIII) but I get an error with the keyword OWNED. (tables uses serial type). The fields with serial type are declared differently in

[GENERAL] How to preserve characters with accent?

Dear sirs, I have some fiel name with character with accent (à, ò...) but when I make a plain backup of schema (file.sql) that characters are converted to strange sequence of two (or more?) characters. How I can avoid this? Thank you in advance. Domenico ---(end of

[GENERAL] How to set UTF8 to query browser of PgAdmin III

Dear Sirs, I am workink on Windows 2000 with PgAdmin III v. 1.6.2 If I open an sql file created with UTF8 encoding the characters with accent are not reproduced correctly. If I open the same file with MS Word or JEdit or also PgAdmin III on Fedora Core 5 it is all ok. Note, the file was created

[GENERAL] How I can read-back a serial value just inserted?

Dear Sirs, my question is very simple: when I insert a row whith a serial field, a value is automatically generated; how can I know this value, strictly of my row, without the risk of to read the value of another subsequent insertion? Thank you. Domenico ---(end of

[GENERAL] automatic build of return type

Hi all I am coverting a database with several stored procedures from MS SQL Server to PostgreSQL 8.2 and I have the following doubt: With MS Sql a stored procedure containing the statement SELECT * FROM TABLE_A INNER JOIN TABLE_B automatically creates and return a recordset with all the fields of

[GENERAL] Cannot connect to Fedora Core 5 server from the network

Dear Sirs, I have some trouble to connect to PostgreSQL .8.0 running on Fedora Core 5 server with PgAdmin III v. 1.4.2 running on Windows 2000 Server on the same (local) network. The database server is accessible from PgAdmin ||| running on the same server (Linux) and itseems OK but is

[GENERAL] How to get recordset with CallableStatemente

Dear sirs, I am trying to get recordset from PostgreSQL database (8.1.3) with java but I am some problem. The operation that I would like to do is SELECT * FROM "Congressi" (the table has the first letter in uppercase) (i.e. rs = st.executeQuery("select * from \"Congressi\""); It works

[GENERAL] parameter passing from java program

Dear Sirs, I am spending about 10 hours on little problem: to pass a parameter (text) to a PostgreSQL(v. 8.1 on Win2000). The relevant code is: java side: private CallableStatement cs; cs = conn.prepareCall(INSERT_CONGRESSO); cs.setString(1, itemCongresso.getCongresso()); //return a

[GENERAL] Case sensitivity?

Dear Sirs, I have a little problem: - Contest: Server side: Linux Fedora core 4 with PostgreSQL v. 8.0 Client side: both Linux Fedora core 4 with pgAdmin III v. 1.4 and/or Windows 2000 server vith pgAdmin III v. 1.4 - I Made a table: CREATE TABLE "Accoglienza"( "IdAccoglienza" int4

[GENERAL] R: Case sensitivity? - I understood...

Postgres? (it exist some parameter to adjust?) Best regards. D. Formenton -Messaggio originale-Da: dfx [mailto:[EMAIL PROTECTED]Inviato: martedì 27 dicembre 2005 15:55A: 'pgsql-general@postgresql.org'Oggetto: Case sensitivity? Dear Sirs, I have a little proble

[GENERAL] Migration tool from MS SQL server 7.0

Dear Sirs, it exist some tool to convert a SQL script generated from MS SQL 7 to the syntax compatible with Postgresql v. 8.x.x? Best regards. Domenico