PostgreSQL Database Forum

All, I need to upload (insert) a flat file to PostgresSQL DB (on Solaris 9) using C. I wonder if I should use libpq functions or embedded SQL in C (libecpg). Any help is appreciated. If you have any sample programs, please sendalong. Thanks, Andy Truong

Hi, If during a transaction a number of deferred triggers are fired, what will be their execution order upon the commit? Will they be executed in order of firing or alfabetically or something entirely different? The docs only mention regular triggers being executed alfabetically.

Greetings, Our postgres system crashed and upon restarting it our database had the following errors. The error log was 4.5 gigs which is much larger than usual. We looked online for information about lost left siblings and how to fix the data and not lose the 400 million records we have. Anyone have an idea what's the matter and what the fix...

Hi, last night I tried to reindex my database with some really ugly results. I can no longer use the database. backend> REINDEX DATABASE "CLIX1" NOTICE: relation 16416 was reindexed NOTICE: relation 1255 was reindexed NOTICE: relation 16410 was reindexed NOTICE: relation 1247 was reindexed

select *, lower(name) from student; gives error: could not find block containing chunk 0x8483530 what does this error mean & what may be the cause? template1=# \d student Table "public.student" Column | Type | Modifiers --------+---------+-----------

I posted this to Announce, but somehow it doesn't make it through. Since it would be important for people who want to replicate their 8.0.0 BETA test databases, I repeat this here. Jan -------- Original Message -------- Subject: Slony-I release 1.0.2 includes PostgreSQL 8.0 support Date: Sun, 15 Aug 2004 15:01:29 -0400

Hi, I am using postgresql 8.0beta in a freebsd jail environment. My inittdb gives me a message like: --- creating template1 database in /home/..../db/base/1 ... FATAL: could not create shared memory segment: Function not implemented DETAIL: Failed system call was shmget(key=1, size=1187840, 03600). child process exited with exit code 1...

First things first: Postgresql 8.4.2 on Fedora Core 2 X86. Something seems to have happened to my pg_xlog and pg_clog directories after (I believe) a power outage. In the course of trying to figure out why the server wouldn't start, I cleaned out pg_clog and pg_xlog, in an obviously vain attempt to reset things. I was under the impression...

Is there any practical limit on the number of parallel connections that a PostgreSQL server can service? We're in the process of setting up a system that will require up to 10000 connections open in parallel. The query load is not the problem, but we're wondering about the number of connections. Does anyone have experience with these kinds...

I have a database in which there is a user and their search path is set to: dbmirror, public, pg_catalog pg_dumpall includes this line in the dump: ALTER USER dbmirror SET search_path TO 'dbmirror, public, pg_catalog'; This isn't correct though, because when it is run through psql to load the user, I get the following:

Hi, I'm observing the following: If I commit the following records 1,2,3,4,5,6,7,8,9,10 to the database and the server hangs, I could lose records 5,6,7,8,9 but record 10 is there. How is this possible and do anyone know how Postgresql physically writes the records? Thanks, thomas.

query like: select distinct name from student; uses equal operator ('=') or not? If not, then how it identifies distinct element. -- Vinay Jain Dissertation Project Trainee DAKE Division C-DAC Mumbai

How can I implement C-Language functions in a Win32 environment?

Hi all, I 'm testing postgres 8.0 beta 1 an i have the following problem. I have a field with value ÃéÜííçò. If i execute the following query it does not returns any rows. select * from test where descr ilike '%ãéáííçò%' if i change the query to

Is there a call redirector available that redirects the calls to the PHP MySql API (mysql_connect etc.) to a Postgre database? This would be very usefull since a lot of PHP Scripts are coded for MySQL. I think for most PHP scripts this would work out since the SQL syntax from PostgreSQL and MySQL are very similar.

Hi all, I've been hunting around the techdocs site looking for a comprehensive listof error codes for certain errors. The only thing I can find is a list ofa few (textual) errors - nothing that includes codes/numbers, and nothing comprehensive. This is making it hard to catch specific errors ... can anyone point me to a list somewhere (or...

Hello, I am migrating from MySQL to PostgreSQL and ran into a limitation of PostgreSQL. I ran into this because of a technique I use for displaying results of a SELECT query. In some cases I like to have the heading of some columns in the table be clickable, usually to sort output by that column. I have common a function I use that...

Hi group, I've installed the win32 binary version of the 8.0beta1 using the PGInstaller (http://pgfoundry.org/projects/pginstaller). I've also downloaded the source to compile on our linux boxes and that is fine. The problem I've got now is building binaries of the contrib folder for win32 - specifically the fuzzystrmatch and tsearch2 bits...

L.S. Either the docs or I are missing something.... While using libpq I noticed that listen/notify calls were being converted to lowercase. A further look showed that the listen/notify calls seem to be totally case insensitive: free4testing=# select version(); version

Hiya, Not had much experience with tiggers under postgres but am liking them so far. My problem is this. I am writing an updates system, postgres holds the master copy of the database, any changes made to this are logged in an updates table which is monitored by a daemon, which if any updates are spotted propigates them to the remote...

Hi all. I've managed to get 8.0.0 up and running. Now I'm compiling some contributed software and I hit a show stopper. Contrib - DBSize Papa-Legba:/home/r/root/5.1/postgresql-8.0.0beta1/contrib/dbsize# gmake ; gmake install sed 's,MODULE_PATHNAME,$libdir/dbsize,g' dbsize.sql.in >dbsize.sql cc -std -ieee -pthread -O3 -c99 -I....

Hi! I am a developer working for a company which typically deploys apps on Oracle. We would like to move to postgres for obvious reasons. However, most of *our legacy apps use the exception handling support provided by PL/SQL. Instead of porting each of these procedures by hand, we would like to add exception handling support to pgSQL if...

Hi! I was looking into the postgres error handling mechanism, and the documentation states that the present mechanism is primitive. I quote "whenever the parser, planner/optimizer or executor decide that a statement cannot be processed any longer, the whole transaction gets aborted and the system jumps back into the main loop to get the...

'ps axu' shows: postgres 1249 0.0 0.7 20200 7296 ? S 11:50 0:00 postgres: user1 database1 127.0.0.1 idle postgres 1251 0.0 0.6 20196 7036 ? S 11:50 0:00 postgres: user1 database1 127.0.0.1 idle postgres 1264 0.0 0.3 19936 3200 ? S 11:50 0:00 postgres: user1 database1 127.0.0.1 idle postgres 1267 0.0 ...

Hi folks, The thread on injection attacks was very instructive, but seemed to run out of steam at an interesting point. Now you guys have kindly educated me about the real nature of the issues, can I ask again what effective escaping really means? Are the standard escaping functions found in the PHP, Tcl etc APIs to Postgres bombproof?...