PostgreSQL Database Forum

Hello, I am trying to get a trigger to fire when a record is deleted that will record the deleted record in a history file. Here is the trigger code: CREATE OR REPLACE FUNCTION logPedigreesDel() RETURNS TRIGGER AS ' begin INSERT INTO PEDIGREES_hist( PedigreeID,

Hey all, First off I am new to postgres and multi-lingual development so pardon me if the answer is overly obvious. We our database is setup for UNICODE. We have a mixture of clients accessing the database through JDBC and C (libpq). My question involves the C interface to Postgres libpq. Once a query has been made (with...

i am using a regular expression in a select statement inside a function. how do i dynamically insert a variable into the regexp? eg. SELECT string ~ '\\d{X}' where X is the dynamic variable. I tried '\\d{' || X || '}' obviously it didn't work.

Due to recent action by Google concerning the comp.databases.postgresql.* hierarchy, we are going to make some changes that should satisfy just about everyone ... over the next 24hrs or so, traffic *to* comp.databases.postgresql.* from the mailing lists will cease and be re-routed to pgsql.* instead ... on our server (and we encourage others...

Hi All! I am wanting to setup/run PostgreSQL on my server (a SuSE Linux 9.2 distro) but I'm not quite sure which way to go. I have a few books on PostgreSQL but they don't seem to match the way SuSE has installed it. The books explain how to install/make/etc. and then how to setup a "cluster". The directory structure differs alot from the...

Hi, First of all I'd like to say that 8.0 is a great piece of software, and I've been looking forward to installing 8.0 for quite some time now. Does PG allow you to store XML documents as DOM documents? Is there such data type? If not, is it very hard to extend the type system to include a binary representation of an XML document? ...

hi, could someone please tell me how do I get a query to show the (*) fields in table2 only when table2.field1 exist in table1.field1 thanks in advance. jenny table 1 contains -------------------------- field1

I just installed postgresql 7.4.5 and pgadmin3 1.0.2 on FreeBSD and noticed that pgadmin allows the pgsql user to log in while ignoring the password. You can enter a wrong password or no password and still get into postgresql. I started the postmaster as a FreeBSD user named pgsql by running postmaster -i -D /usr/local/pgsql/data I changed...

I'm just learning the libpqxx library and it appears to say that it is built on top of libpq. So I'm trying to locate libpq so I'll have access to that documentation and binaries. But I can't find it on gborg. Any pointers? -- % Randy Yates % "Maybe one day I'll feel her cold embrace, %% Fuquay-Varina, NC % ...

I searched for the latest on adding the Oracle-like feature called partitioning - a nice feature for tables that grow and grow, when you still need to be able to call up data from 5 years ago - but have not found much talk about it lately. Does anyone know if this feature will be added to PostgreSQL? Maybe in version 9? Boyd

hello! does anybody know how well the pg extension in PHP for PostgreSQL supports UTF-8 character sets? functions such as pg_escape_string would be of particular concern as they go whipping through strings replacing things. are these functions tuned to the input string type, the database string type, or just hardcoded as 8859-1? ...

Hi, i'm trying to save images on a postgres db. I created a table like this: CREATE TABLE image(name text, image oid); and I inserted in it a file this way: INSERT INTO image VALUES ('myimage',lo_import('/home/myhome/images/leaf.jpg')); First of all: am I doing it right?

My company has a product in beta which uses Postgres 7.4.3. We expect to have a code freeze for our 1.0 product in March 2005. I'd really like to use Postgres 8.x in our 1.0 product. We're especially looking forward to the background writer and tablespaces. Is the 8.0 release date known? Suppose 8.0 is released in December or January. Is...

Just to let everyone who is interested in having 5 postgresql groups in the big 8, that I've posted the second RFD. Please visit news.groups to read and discuss the Postgresql RFD. This is potential very important to all those who use Postgresql, so if in doubt, do stop by news.groups and read it. Thanks.

Hi, struggling around with this for some time: How can I use a table name as a parameter in a PL/pgSQL function ?? I tried this but it didn't work... CREATE OR REPLACE FUNCTION my_row_count(text) RETURNS int4 AS '

I know there is a command to add the column. I want to back up the table before I alter it. What is the best way. It has a couple indexes and a trigger. If I am in the wrong forum please direct me to the right one. Thanks. Lewie

I guess the subject says it all, can I install the B5 release to a B4 db without starting from scratch? Jerry ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Hello, I have a table with a timestamp column and I want to set this to a value of now() - a random number of days between 0 and 45 for each row... I've tried to do this a bunch of different ways and can't figure it out... Here is my latest version: update sometable set entered_dt = now() - interval round(random()*45)||' days';

Hi all, I have three questions about 1 table CREATE TABLE public.logs ( rule_name varchar(32) NOT NULL, bytes int8 NOT NULL, pkts int8 NOT NULL,

Hi, Is it possible for the COPY command to read data from a file, but skip specific columns? Thanks Adam

I am currently creating a database with less than 20 simple tables (only SQL 92 types, simple constraints, no PostgreSQL specific stuff, no stored procedures...) Unfortunately, some of those tables will contain up to 4 Million entries, making the size of the entire database 700-1000MB. In order to maintain good query times (hopefully <1-3...

Hi ! I've just inherited the responsibility of a postgresql database of roughly 480 tables and 6460 columns, mainly without constraints, not even foreign keys. I'd like to make it a little more orthodox (lots and lots of constraints, yeah !!), but I need a tool to make a documentation about every column, at least, as some column are...

Its been almost 4 weeks since Beta4, and alot of work, involving alot of bug fixes, and documentation improvements, to the source tree, we have just released our 5th Beta of 8.0.0. All of our major Open Items have now been completed, and we're slowly entering the final stages, involving alot of testing and documentation changes. For a...

Occasionally I want to store a null value for my java.sql.Time--> Time column in Postgresql. update event set game_clock=null where event_id=1; I can retreive the record with the null value (type Time) if I select on the primary key, select game_clock from event where event_id = 1; but when I try to select on the null column value, I get...

I am trying to figure out how I can change the default operator class of the index created for my primary key field. Is it even possible since I am not able to find the syntax? Or do I need to create the primary key and then an additional index with the operator class I want. (It would be a waste of space) Thanks Sally