PostgreSQL Database Forum

Dear list, many thanks to all of you who've replied in such a helpful way -- your support is much appreciated! Have a nice weekend, Bernd ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Im trying to connect locally to a database on a running postgres cluster. If i connect with psql, everything is fine and i can transact. I i try and connect in my own app, i get this error: Could not connect to server: permission denied. Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432" I...

Postgresql 7.4.5 The following VACUUMs were run within a couple of minutes of each other completing. This table concerned is a table that has not been changed in a long time. (a month) There were open transactions at the time the vacuum was run. These were created by having PHP running with postgresql. At least that is what I have managed...

I installed Postgres 8 beta 3 on an XP box, with Postgres running as a service. TaskManager tells me that postgres and postmaster are both running. Using pgAdmin III, I can connect to the server and create users, databases, tables, etc. But at the command line, on the same machine where the service is running, executing createdb mydb

Hi, I upgraded recently DB and found that some columns with type "timestamp" changed default values from now() to: receipt_date | timestamp with time zone | not null default '2004-09-29 09:58:03.010678+10'::timestamp with time zone ,where time is a time when psql -U postgres template1 < db_backup.sql was executed.

-------------------------------------------------------------- Software Tree Revs Up JDX OR-Mapper With Innovative And High-Performance Features -------------------------------------------------------------- Software Tree has announced JDX 4.5, the versatile and patented Object-Relational Mapping (OR-Mapping) software that significantly...

Hello all, Is it possible that we setup the password in the pg_dump command line instead of let users input it through prompt command. E.g., pg_dump test -c -d --host=localhost -U testUser1 --file='a.dmp' --no-privileges Thanks a lot! Ly

I'm just moved my Postgres client project from Mac 10.2.8 to 10.3.5. It's an Objective-C program that links to libpq.a (the header file is libpq-fe.h). However, when I try to compile now I get the following linking error: ld: Undefined symbols: _poll Does this sound familiar to anyone? My guess is that _poll is referenced somewhere in...

Howdy! I'd like to set up a database (mostly a bibliography), which I'd like to connect to a webpage such that simple queries to the database can be made by visitors of my homepage. I seem to remember that FileMaker allows for this, but I'd prefer a UNIX-based solution (under MacOS X). Hence my question (before I start digging): Can...

Hi everybody, I'm doing the following query: select * from messages order by random() limit 1; in the table messages I have more than 200 messages and a lot of times, the message retrieved is the same. Anybody knows how I could do a more "random" random?

HI, I'm using pgadmin III 1.2.0 Post Beta 1 (Sept 17 2004). I used it to execute a SQL script that creates tables and inserts data. At the end, I get a message saying that everything went through correctly. However, when I try to view the data in the pgadmin window, nothing shows up. My backend is PG 8.0 Beta 2 on Windows 2000. Any...

This is the Problem: I'm building a Large DataMart with a big table and I want to improve the performace using aggregates I mean a set of table that store some specific aggregacion of the main table, like materialized views, I know that this feature is not implemented yet in postgres, And I see a interesting article to implementing this using a...

Hello folks, I am having a hard time installing PgSQL on WinXP - when installing from source it tells me I have an incompatible time zone - PgSQL does not support leap seconds (Europe - Bratislava, Budapest, Berlin, etc.), when installing via installer dev2 and/or dev3 freezes. ver says: 5.1.2600, WinXP SK, SP2 installed. Any...

hi! Everybody. I have written a code to connec to postgre sql databse.But i am geting some error. import java.sql.*; import java.util.*; import java.lang.*;

Hello, Could someone help tell the commands of the following operation under postgreSQL please? .. List all functions have been defined (e.g., defined through pg/sql) within a database .. Display all process/connections (similar to show processlist under MySQL) Thanks in advance,

Hi, I'm writing some simple triggers and functions for a postgres database, andI'm wondering how to go about to debug a pl/pgSQL-script. Is there a way to echo variable-content to screen, or to file? Or is there other, more advanced ways of debugging such scripts? regards Jonas:)) ---------------------------(end of...

I am attempting to install postgresql7.4.5 on OSX 10.3.5 and have questions about readline. For use with Python, I have readline.so installed in /Library/Python/2.3/. - Is this "manifestation" of readline sufficient/appropriate for postgres?

suscribe hola! Yo soy Claudia Mª Restrepo P. Me encuentro realizando mi practica empresarial (estudiante de ingenieria de sistemas)y ya monte en un servidor proliant, procesador pentium 3 DIM 128M, disco duro IDE 20GB. En el cual instale Linux Suse 9.1, estoy trabjando en la base de datos Postgres obviamente he investigado mucho tanto via...

Çäðàâñòâéóòå. Send please examples of the use lo_export, lo_import, lo_open, lo_read, lo_write.... for Delphi. It is necessary to save the files in the base and afterwards read them from the base.

This may be mostly a documention issue: I have a function with two parameters that returns an array: text. I want to access just the first element of that array within my SQL statement. This doesn't work: select myfunc(1,2);

Hello all, Is it possible that we setup the password in the pg_dump command line instead of let users input it through prompt command. E.g., pg_dump test -c -d --host=localhost -U testUser1 --file='a.dmp' --no-privileges Thanks a lot! Ly

I keep getting this error. DETAIL: Failed system call was shmget(key=5432001, size=34037760, 03600). HINT: This error usually means that PostgreSQL's request for a shared memory segment exceeded your kernel's SHMMAX parameter. You can either reduce the request size or reconfigure the kernel with larger SHMMAX. To reduce the request size...

Is there a way to do COPY FROM STDIN from sql? So, remotely I could run the copy command and somehow push the info over instead of having it on the server. -Josh ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org

still doing my switch from MySQL to PgSQL, and can't figure out what the comparable function would be for this: In MySQL, to store a big secret (like a credit card number) in the database that I didn't want anyone to be able to see without knowing the salt/password value, I would do this into a blob-type field: INSERT INTO clients(ccnum)...

postgres 7.4 on linux, glibc 2.2.4-6 I've a table containing unicode-data and the lower()-function does not work proper. While it lowers standard letters like A->a,B->b ... it fails on special letters like german umlauts (Ä , Ö ...) that are simply keeped untouched. Everything else (sorting etc.) is working fine and LC_COLLATE, LC_CTYPE...