[GENERAL] Newbee to databases (ODBC)

Hi all, I'm sorry to bother you with this question, I know it is a C++ ODBC question. But I'm a bit desperate. Perhaps I'll be lucky. I have a table with 2 columns no_char and blobdata were no_char is number of characters in blobdata. I would like to handle each row from the result set. I have g

[GENERAL] postgreSQL-devel 8.3.8

Hi, I need to download postgreSQL develope package for ver. 8.3.8, but I can not find the ...i386.rpm anywhere. Please, could someone guide me to the right place? Kind regards, Paul -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http:

[GENERAL] restore a server backup

Hi, I've used PgAdmin III to store a server backup. But I'm not able to restore it. Please, could any one tell me how to do it? Im using version 1.10 /Paul

[GENERAL] new databases using a template.

Hi, I'm trying to create a new database by using a template database. But it is not possible. The error code is that some one is using the template, but no one is using it. I'm using PgAdmin III ver 1.1.0. Has some one seen something like this? /Paul From: pgsql

[GENERAL] Setting up tablepace

Hi all, I have a problem with setting up tablespace on a ramdisk. the ramdisk shall be used temporary for storing unprotected map data, that is normaly protected. I'm working in Linux. I have an ordirnary Linux user called normaluser, a user called chartuser (the ramdisk owner, the password is n

[GENERAL] changing from postgreSQL 8.3 to 9.0

Hi, I have a database created on ver 8.3 an have restored the database in a new database in PostgreSQL 9.0. In the database i'm using a column storing "bytea". When trying to read the database with my java application, I have problems reading from the bytea-stream. Integers read is not correct.

[GENERAL] creating a table based on a table in stored in another database

Hi list, in a database I have different kind of tables. I would like to take the meta data from one of those tables and create the same type of table (but empty) in another database. Can anyone, please, tell me how to do this? Kind regards, Paul -- Sent via pgsql-general mailing list (pgsql-

Re: [GENERAL] creating a table based on a table in stored in another database

en 18 maj 2010 10:16 To: pgsql-general@postgresql.org Subject: Re: [GENERAL] creating a table based on a table in stored in another database In response to Malm Paul : > Hi list, > in a database I have different kind of tables. I would like to take the meta > data from one of those tables

[GENERAL] metadata on a table

Hi, I'm trying to read the metadata from table to create the same sort of table in another database, using java. This is how I do it today quwstion = "SELECT * FROM table" stmnt = dbConnection.prepareStatement(question); rs = stmnt.executeQuery(); ResultSetMetaData rsMetaData = rs.getMetaData

Re: [GENERAL] metadata on a table

Ahhh. boolean isAutoIncerment = rsMetaData.isAutoIncrement(1); if int4 and autoIncremented = serial Sorry!! From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Malm Paul Sent: den 19 maj 2010 08:44 To: pgsql

[GENERAL] uppdate from postgersql 8.3.7 to 8.4.4

Hi, I'm trying to update postgresql ver 8.7.3 to 8.4.4 At the end of the installation when trying to styart the database server I get the following error meassage: "Problem running post-install step. Installation may not complete correctly. Failed to start the database server" And when I try

[GENERAL] dumping parts of a database

Hi List, I have a database with two tables header and idata, they are connected with an conn_ID. I would like to dump header and the connected idata tables with a certain conn_ID. This I would like to import to the same type of database on another PostgreSQL server. I would be gratefull if some

[GENERAL] import warnings ?

Hi list, I'm using FWTOOLS ogr2gr to import a s57 chart. Im getting a warning when I'm importing in Linux but not in Windows XP, see below. Could anyone tell me why and what the difference is in the result (I can't see it because the lnam_refs is empty), will I miss anything? ogr2ogr -f "Postgr