PostgreSQL Database Forum

Hey guys, I have a need to install the DBD::Pg Perl module on many shared web servers, which do not have PostgreSQL installed. Then the DBD::Pg module will just connect to a remote PostgreSQL database, hosted elsewhere. I'm having some problems doing this. First off, I modified the Makefile.PL, and added the three following links just...

Hello everyone, I am a new user of postgresql... I have to create a table named person like: create table person ( personname varchar(40), telefonnumber varchar(20)

How do I connect to a postgres sever across a network using DBI? I can not find an example of it anywhere in any docs. Thanks. Also what do I type after man to get the Pg dbi man file? ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings

Currently I'm running PostgreSQL 7.2.3 and having a problem sorting. I've got two colums of data, one Int4 one Varchar. When I sort ASC on the varchar I get some strange results. Here a section of data cut after running a sort. It starts with RM- then does RMT- Then goes back for more RM-. I've checked for spaces or tabs or anything else...

How do I connect to a postgres sever across a network using DBI? I can not find an example of it anywhere in any docs. Thanks. Also what do I type after man to get the Pg dbi man file? ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Hello, I have maybe a strange question: Is it possible to configure a main password for a hole? For a better understand: Only my program knows this mainpassword and if my program can connect and is connected, the user can connect to database (with his own account). The user is only allowed to connect, if he is connecting with my program.

On Wed, Aug 06, 2003 at 12:55:52PM -0400, Joel Burton wrote: Reposting, with some clarification to my request. Thanks to the several responses I received originally. Yes, I know that a perfectly vaild PGSQL SQL file could contain only ANSI SQL and therefore not be recognized as PG-related. In that case, though, it would be recognized by...

Hi, v7.3.3 http://www.postgresql.org/docs/7.3/static/sql-createtable.html Is "INITIALLY DEFERRED" a modifier of "NOT DEFERRABLE"? If so, what does it do, since they seem contradictory. Thanks --

Hi there, I wonder if anyone can shed some light on a very frustrating problem. I'm running a debian linux 3.0 "woody" server, nothing special, with the latest version of postres that apt-get will allow me, which I *think* it;s 7.1 something, I don't know how to figure out the postgres version. Anywho - I'm trying to backup my databases,...

Hi all I wrote a script in PHP with mysql (hum ... to be honnest, I wrote this script under PostGreSQL but we recently migrated to mysql, so I had to adapt my code to mysql ... sorry about that ... anyway, it is the same kind of query, with subqueries !) but this is a very very long script ... I was wondering if there is a way to...

I have two tables in two databases (Pg 7.2.1 - yes I need to upgrade but there are several other dependencies I have to resolve first) and I need to update one database's tables so they can be merged into the other database's table. I know I can drop the constraints and update the tables (primary key, and foreign key) but was hoping I'd not...

Hi all, I would like to know if its possible to have the SAME TABLE into two different databases (but in the same server). Or to create a view of a table of database X at the database Y. I try to find it in Postgres docs, with no success. Thanks to all,

Is it possible to write functions for PL/C that have variable argument lists? I.E. UPPER( arg ) UPPER( arg, encoding_list ) LOWER( arg ) LOWER( arg, encoding_list ) SUBSTR( arg, arg, arg )

Hi: I must have missed something, but how is it possible that a join on tables A and B is faster (a lot faster) than a query to one of the tables with the same conditions? The problem seems to be with the query plan, in the case os a query to table_a only, the planner executes a "Seq Scan", in the case of a join, an "Index Scan". table_a...

how could I fix this problem: ERROR: unexpected chunk number 8 (expected 0) for toast value 6935693 It appear to be simple: update chunk_seq from 8 to 0. how to do it? in the stand alone postgres, could I copy a entire table? how to do it?

Hi, I'm looking for best practices for building a multilingual database. It is for an multilingual application that will use a persistence layer. I would like to know what are the different ways to design the database and what are the differencies between the different possibilities.

I've been charged with investigating postGIS as a replacement for our current Informix runtime (9.3), which uses the Spatial blade. Currently we use two Sun Sparc/Ultra 80 boxes with 3 CPUS dedicated to Informix. We use our database to calculate the image files we have within a given area (ST_Union, Intersect and the like). Originally this...

How does one concat string literals in pgsql ? The compiler complains about the concat operator in the following code fragment: RAISE EXCEPTION ''SELECT DISTINCT "t1"."usesysid" '' || ''INTO userID '' || ''FROM "pg_user" AS "t1" '' || ''WHERE "t1"."usename" = current_user '' ||

I'm receiving the following error during startup: Aug 10 14:11:27 thunder postgres: LOG: failed to create socket: Address family not supported by protocol Aug 10 14:11:27 thunder postgres: LOG: database system was shut down at 2003-08-10 14:11:11 MDT Aug 10 14:11:27 thunder postgres: LOG: checkpoint record is at 4/E28389B4

Dear peoples, I'm setting up a database in postgres which will have light traffic writing to a few tables (and somewhat heavier traffic reading them). We'd like to mirror that databse using dbmirror to two others. Let's assume that we're humming along and the master goes down. We switch traffic to read from one of the two slaves. What...

in log: IDENT authentication failed for user "band" ? pg_hba.conf local all ident sameuser host all 127.0.0.1 255.255.255.255 ident sameuser

Hello, all! I have a good question for PostgreSQL FAQ. How to use string functions (like UPPER()/LOWER()) for non-latin strings? Why UPPER() function doesn't work with my UNICODE PostgreSQL database whichcontains non-latin characters (like cyrillic)? How to make case insensetive search by text field which contains non-latin characters? ...

Dear all, for some reason I just cannot get my brain wrapped around the required syntax for the following. I think I need to either use a join or subselect(s): Situation: ---------- I have two tables (simplified here) for an international medical office application (www.gnumed.org):

I need to store some sensitive data and I want to use public keys so anyone can encrypt the data but can only be decrupted by certain users. Anyhow, are there any loadable modules that do public key encryption for Postgresql ? I'd like to access these functions in plpgsql. It's probably not that hard, just don't want to re-invent the...

Utilizing Postgres 7.3.3 on RH80. Unable to nest groups; attempting the following: ALTER GROUP "<group1>}" ADD USER "<group2>"; ALTER GROUP "<group1>}" ADD GROUP "<group2>"; ALTER GROUP "<group1>}" ADD "<existing group2>"; Any work-around or something I am missing?