PostgreSQL Database Forum

Hi, yes, I have been hit by the, now also known to me, foreign key locking "feature". And yes I did read that I should use "defer" to solve the problem. Question is: Do I have to recreate my schema with all foreign keys set to "initially defered deferable"? Ulrich

Hi I want the result of select query to be returned from a function. Or is there any way to return a table from a function? Regards Arundhati

I get this in the logs for every database open by pg_autovacuum: Sep 1 14:02:45 cerberus pg_autovacuum: nss_ldap: could not connect to any LDAP server as (null) - Can't contact LDAP server This is produced by the bind_to() call in libnss-ldap. This is invoked when /etc/nss_switch.conf specifies ldap; what I don't understand yet is what...

Hi, In my postgresql.conf file I've got log_destination = 'stderr' Should this option not create a postmaster.log file somewhere on my system (it's nowhere to be found)? Apologies in advance if I'm just being stupid. Thanks

Is there a way with PostgreSQL to attempt an insert, and if it fails, automatically ignore the error and try and update? On MySQL, I heard you can do this with the REPLACE statement. I suppose I can do it with a PL/pgsql stored procedure, but was wanting to know if there was more of a "generally accepted" way to do this such as with some...

No new version, no bug fixes, no beta2 ... --------------------------------------------- Thomas Wegner Cabrio Meter - The Weather Plugin for Trillian http://trillian.wegner24.de/cabriometer

Hi all, I develop an application (JAVA/JSP) on RedHat PostgreSQL 7.4.3 with PostgreSQL 7.4.2 JDBC3 with SSL (build 213). This application needs to serve pages in LATIN1 and Hebrew. For that I create 2 Databases, one DB in UNICODE encoding with client encoding LATIN1 when in the JSP the charset encoding is iso-8859-1 and it's working fine...

I'm looking for a way to build psql on OS X so that it can be copied to another computer without any external dependencies. In particular, if I build the standard distribution and then copy psql to another computer, I get an error that /mydir/.../lib/libpq.3.dylib cannot be found. This is probably basic make stuff, but I'm not sure where to...

Hello, Under mysql, we have "desc tablename" to get the detail information about a table. My question is about to get column name, and column type for a specific table under PostgreSQL through JDBC. Assume we have a table named "test". Under PSQL, we can input "\d test" to see the details about table "test" successufully. However, my...

Hiya, (me again :) ) I am using in my C function the field names of a row. The way I am currently pulling out this info is with: idfield=strdup(trigdata->tg_relation->rd_att->attrs->attname.data); (this line should just pull out the name of the 1st field in a row). I am guessing that this structure may (or may have already) changed as

Hi! During my last attempt to set postgresql working under cygwin on a win-98 OS I got the warning: cygserver: failed to create UNIX domain socket: Address family not supported by protocol What should I check? Ennio -- (°|°)

I'm pretty clueless in regard to the PostGIS situation. Will it be integrated with PostgreSQL in the future? What are the benefits of using the builtin geometry types (since they don't have R-tree indexes)? -- dave ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster

Hiya, I have written a C function for postgres. I developed and got this function working on postgres 7.3.2, however the production system was 7.4.3. On my initial dev setup it worked perfectly, however on the 7.4.3 it caused the backend to terminate abnormaly!, I upgraded my dev system to be the same version to ensure it wasn't just the...

Hello all, Recently a post on this list made me think a bit about the way in which I write my queries. I have always written queries with ordinary joins in this manner: SELECT * FROM a, b WHERE a.x=b.x; However I recently saw an laternative syntax:

Hi all, I have search high and low on this - Take for instance the statement : insert into foo (text1, text2, int1) values ('Foo', 'Bar', ''); On Pg 7.2.x, the db would happily insert the null val into the int field. HOWSOMEVER, 7.4.x will explode and error back with: "DBD::Pg::st execute failed: ERROR: invalid input syntax for...

Hey guys I have written a plpgsql function which takes anyelement as argument. If I pass a string as input It gives an error "invalid input for integer" . Cant I pass any datatype for anyelement

Hello everybody, A table T contains list of items and their common properties. Some of those items in the list also have additional properties. Let's say that there are 3 groups of items - group 'a' doesn't have any additional properties, group 'b' has 2 additional properties, and group 'c' has 3 additional properties. In order to be able...

Hi I'm trying to set a search path through a connection made by PHP and failing. It works in pgsql: clwcms=> set search_path = myname, funcs, public clwcms=> select * from fn_usr30_show_section_users(1, 1);

I've been using pg_autovacuum on a largish postgres installation successfully for several weeks, now. I know that pg_autovacuum has no facility for monitoring the system to know whether any particular time is a good one for it to do it's thing, but I'm wondering what the occasional episodes of 99.9% CPU usage (as reported by top) are. I...

Dear Sirs I'm about to write plpgsql function which will "vacuum full" all existing databases. Below is an example how to get list of databases. What should I write instead of "raise notice" ? CREATE OR REPLACE FUNCTION vacuum_all() RETURNS integer AS '

The Postgres INTERVAL literal is not compliant with the ANSI 2003 SQL Spec. Here's the Postgres way: # select INTERVAL '45 DAY'; interval ---------- 45 days (1 row) The spec. says

Beta2 of 8.0.0 doesn't find openssl. 7.4.1 on the same system does. This is RH 9 (kernel 2.4.20-8) with openssl-0.9.7b installed from the source code. I get: checking openssl/ssl.h usability... no checking openssl/ssl.h presence... no checking for openssl/ssl.h... no

PostgreSql support materialized views ??? if not, there is something similar?? Thanks Esteban kemp

Hi, I'm relatively new to postgres but I've managed to get an instance up and running and built a web site based on it. But I want to move the complete site to another host not in the same network. If I want to set the schema up on a new machine is it sufficient to simply copy the data folder (and sub folders) and then start the instance by...

Hi, I'm curious to know whether PostgreSQL works well with Fedora RedHat Linux? If there are any issues, I would like to know about them. Many thanks. Dan