PostgreSQL Database Forum

Hello all I tried to use following rule instead of using a default value(I want to be able to put a function instead of the constant value later on). But it keeps giving me infinite recursion error. Any ideas?

Is anybody using contrib/dbmirror in a production environment? - DAP ====================================================== David Parker Tazz Networks (401) 709-5130 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's...

Dear list, i am looking for a way to check, whether an DML-statement can be performed on a current database. That means, that i want to check, if e.g. an INSERT is possible or not (due to existing constraints), without executing it. Any ideas? Hagen

I have built slony 1.0.2 with postgres 7.4.5. This needs to be deployed on a system other than the one on which is was built. Somebody on our team had earlier gotten around the problem of not being able to move a postgres install by manually updating the pg_catalog.pg_proc table. But it seems like this worked *after* the procs calling external...

I am using SuSE 8.0 Professional Linux and installing postresql 7.4 by placing the tar files in /temp and untar and unzip and followed the short install procedure. Log in as root ../ configure gmake gmake install useradd mkdir /usr/local/pgsql/data

What is the current wisdom on setting the fsm variables for 8.0? How is it different from 7.4? Or is it? I am assuming these are the values that changed with Jan's changes. If not what were those variables? (I can't seem to track down the threads on these things.) --elein ============================================================

I'm looking for software that can generate PHP scripts from PostgreSQL database that will allow for distant users to edit the data. The idea is to let selected users have EASY access to edit the data they see, I can't possibly give raw access with pgMyAdmin or anything of sorts, as it is hardly accessible for the average user. For MySQL I...

PG peeps: What's the prevailing wisdom & best-practice advice about when to let a varchar (or any) column be NULL, and when to make it NOT NULL DEFAULT '' (or '0000-00-00' or whatever) - in PostgreSQL?

How can a delete rows from a table that has foreign key constraints? Here is how I have it set up. I have 2 tables, tableA has fields and id's and tableB has fields that reference tableA's id's. I'm not able to do this BEGIN TRANSACTION; DELETE FROM tableB WHERE tableAid = 5;

Hello, I am trying to run a perl CGI program for accessing a database. The program runs fine from command prompt, producing expected output. But it gives errors while running as CGI. --------- Program ------------- use DBI; use DBD::Pg; print "Content-type: text/plain\n\n";...

I have the following SQL with explain Should I be concerned with the merge cond: Merge Cond: (("outer".masked_acct_id)::text = "inner"."?column5?")? I have no idea what column5 is or the same token the column6 shown later. explain select fed.indiv_fkey, SUM(agg.purch_dollars) as val_purch_store, SUM(agg.no_visits) as cnt_visit_store,...

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, We were performing some tests on PostgreSQL and found that it fails on the following query: SELECT 512*18014398509481984 AS result;

Dear Postgresql people, For the first time I'm trying to use pg_restore to do a partial restore. It looks as if it should be easy: pg_restore -l, filter out the required tables, then pg_restore -L. But unfortunately the listing generated by pg_resotre doesn't include the schema name! Since my database consists of lots of almost-identical...

What is "text + text" supposed to do right now? It doesn't seem very useful to me. What about making "text + text" as an equivalent for "text || text"? Most strongly-typed programming languages do this. And MS SQL Server too, I think (CMIIW). -- dave ---------------------------(end of broadcast)---------------------------

Here's an interesting problem! When a sequence clashes with data already in that table: CREATE TABLE clients ( id serial NOT NULL PRIMARY KEY UNIQUE, name varchar(64)); -- import OLD clients, with their original ID#... INSERT INTO clients VALUES (3, 'Dave');

Hi all, This is probably a silly question, but.......how do I get European- style dates with 8.0 for Win32? I'm running on XP Pro, and I've tried adding -o "-o -e" to the pg_ctl command line (as one would on Linux) - I had to edit the registry to insert it at the end of the command line. However, the service falls over with the following...

Hello ! ----------------------------------------------------------------------------- I would like to know why the database seems frozen. - psql can access to database on the database server - There are no error logs. There are only normal logs - pgadmin cannot connect to the database. - the webserver cannot execute any script - other...

I'd like to know if anyone has recommendations for which Python DB-API 2.0 interface to use with PostGreSQL-7.4.5. The database and tools to interact with it will be hosted on a MacOS 10.3.x machine. The db schema represents a small production studio environment with only a handful of users. db connection will be intermittent.

I am trying to create a PL/PGSQL function that can parse a street address into the component parts (i.e. "200 W 54th Street" into num->200 dir->W street->54th type->ST). What I would like is to be able to use regular expressions within PL/PGSQL to accomplish this using mapping tables for the different components. For example, I would have...

If I want to set up a dbase with normalized tables for inserts,and a flattened table for selects, am i going in the right direction for speeding up a busy site? Also, if some of you are also doing this, how and how often do you do the SELECT from the normalized tables to the flattened table? And, do you have to write a post trigger to get...

I'm switching to PostgreSQL from MySQL. Using the SAMs book called PostgreSQL which has been great to skim the surface of the differerences. I had never even heard of things like triggers, views, and foreign keys before. Any recommended books or websites (or exercises) that would really help someone get to know not just the basics of how...

Hello, I have a table like this with some indexes as identified: CREATE TABLE sometable ( data TEXT, data_fti TSVECTOR, category1 INTEGER, category2 INTEGER,

Dear postgres community, I would like to know what are the significant changes and new features introduced in Postgres 8.0 which warranted the major version number increment. From the postres website it is not very clear as I can only find technical changelogs for the beta releases. //Artem

I assume I'm not the first person to run in to this, however searching google didn't seem to come up with anything useful. its=> begin; delete from pay_stub_entry where pay_stub_id in (select id from pay_stub where created_date >= 1096527603 order by created_date desc); delete from pay_stub where id in (select id from pay_stub where...

Trying the following simple sql file: \set proc_date 6/30/2004 \echo Date is :proc_date select * from feeds where date = :proc_date limit 20; If I start psql with the "-a" option I see the output: \set proc_date 6/30/2004 \echo Date is :proc_date Date is 6/30/2004 select * from feeds where date = :proc_date limit 20;