PostgreSQL Database Forum

Obviously, there cannot be 21 postgresql groups in the comp.* hierarchy. Many of the 21 are not used that often, and would not be of much popularity to those on usenet. I did a check on news.postgresql.org to see which newsgroups are the most popular and also the ones which cover the relevant postgresql topics. Most of the postgresql...

I have a postgresql backend with an access front end and I am trying to redefine the recordset of the form to use an ADO recordset. The problem is that the CursorType always changes to AdOpenStatic, even if I choose adOpenDynamic. If anyone has any thoughts, please let me know. The form works great for viewing, but I cannot update or insert...

I would like to ask the more experienced users on Postgres database a couple of questions I have on a db I manage with a lot of data. A lot of data means something like 15.000.000 rows in a table. I will try to describe the tables and what I will have to do on them :) There is a table that has product data in the form of Table product:...

Instead of putting the same 12 columns on every table (these 12 columns contain info about who created the record and when, for example)... It may be more efficient to make a new table to hold that data. This new table would act as a universal extension table. Instead of having FKs back to any particular table, it would contain regular keys...

Dear peoples, We had an oddness today with one of of postgres servers (Dell 2 CPU box running linux) and postgres 7.4. The server was under heavy load (50+ for a 1 minutes spike; about 20 for the 15 minute average) with about 250 connections (we still don't understand the heavy load itself). Looking in the logs I see: 2004-11-13 13:30:28...

Just a heads up folks, someone has harvested emails out of this list, or one of the windows users has a virus. Be on the lookout Full header below. From info@ROSELINEKLEIN.com Sat Nov 13 13:16:34 2004 Return-Path: info@ROSELINEKLEIN.com Received: from (HELO alibi.mail) by genium.com (Stalker SMTP Server 1.8b8) with ESMTP id S.0002169980...

I have the following select: select to_char((Log_Fortrykk.SistePlate::time - OrdreNew.SistePlate::time)::interval,'HH24:MI') as diff from Log_Fortrykk I need the output to be HH:MM, e.g. 00:09... But my prb is when this diff is less than 0, it shows as 00:-9 and not -00:09 How can I fix this?

Since we have the discussion going, someone mentioned that the group name should be comp.databases.postgresql. I think this is a good name and I'd like to see what everyone thinks of it. There is also the issue of the charter. I would like to get some feed back on what the best charter could be for the revision of the RFD so it is a...

Hi. Is it possible to dump a database on a 7.4.6 server and then restore it on a 7.4.1 server? should i use the 7.4.1 pg_dump or the 7.4.6 pg_dump? should i use any switches? thanks

This morning I got bitten by the "SELECT INTO" / "CREATE TABLE AS" from tables without OIDs bug in 7.4.1. Postmaster killed all the backends and restarted - pg was down for 2 seconds. This happened two times within a few minute period. Now I am getting 'invalid page header in block 52979 of relation "pg_attribute"' errors in the...

How does one embed a sub-query lookup to one table in order to replace a foreign key id number with it's name in a SELECT on a second table? i.e.: given the following two tables, I want to replace the color_id of 1 with the color_name 'red.' (The SQL to create the two tables follows below.) test=# SELECT * from users ;

The my2pg.pl script creates custom functions that help with the MySQL "set" column type. I can't figure out how to use the functions once I have the database migrated into Postgres. Can someone please explain how to make use of them? In MySQL, the table exists: CREATE TABLE accessright ( accessright_id int(10) unsigned NOT NULL...

Hello, I think I have found a query problem when the query has an alias for a table and use alias item and table name. I ilustrate the problem with a simple table and query. prr=# create table foo (c1 int2, c2 int2); CREATE TABLE prr=# insert into foo values (1, 1);

Hello everyone; My systems admin says that he needs to have use of the Postgres user without a password. His Debian package manager requires this. He tells me that he can lock down that user on the system so that there are no security concerns. Can someone tell me if this is acceptable?

Still too new to SQL to have run across this yet ... How does one return the latest row from a table, given multiple entries of varying data? i.e.: given a table that looks like this: color | date --------+------------ red | 2004-01-19 blue | 2004-05-24

Do I get more oids on a 64 bit machine? That is, is it also an unsigned four-byte integer on a 64 bit machine? -- Until later, Geoffrey ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that...

I have a project "wyatterp.com" that was built to be an ERP development library using postgresql as a backend. We use it internally to run a 120 employee manufacturing company. And it does everything from payroll to production management. I haven't been able to do much on it for a while but now I'm getting ready to roll out a new version...

I know I've seen this message before but I'm not quite sure what it means. I think it's because I have two vacuums running over each other. Does this sound right? It's comming from 7.4.x server. ERROR: tuple concurrently updated ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your...

What does it mean when you drop a database and then recreate with the same name and all the objects are still there. I want to wipe out the db and put back from pg_restore. After I re-create the db, all the old tables are back before I run pg_restore. -- Robert ---------------------------(end of broadcast)---------------------------

Hi, We have an app which uses the latest version of perl DBI and DBD::Pg to execute a query, using placeholders. It fails to cast the float I send into a number and generates the following message "DBD::Pg::st execute failed: ERROR: invalid input syntax for integer: "2.63" at -e line 8." Here is a little test case:

Dear PostgreSQL experts, This is with version 7.4.2. My database has grown a bit recently, mostly in number of tables but also their size, and I started to see ANALYSE failing with this message: WARNING: out of shared memory ERROR: out of shared memory HINT: You may need to increase max_locks_per_transaction.

What is the relationship between the "-d" parameter to postmaster and the various "log_*" directives in the postgresql.conf? Specifically, does a certain -d level have to be specified before certain log_* directives take effect? - DAP ---------------------------------------------------------------------------------- David Parker Tazz...

Hello list, I'm a postgres-newbie with a maybe silly question. I'm working on a SuSE-Linux 9.1 with PostgreSQL 7.4.6 with PostGIS 0.9. My problem is, that I can't insert data into a table because I get the error, that there is no corresponding value in the referenced field. But when I query the referenced table with the value, I get a...

Lionel Lauer UPDATED HOME ADDRESS: 58 Gore Street Fitzroy, Victoria Australia 3065 UPDATED HOME NUMBER: (03) 9419 0533 Same mobile number: (0419) 385 307

We are starting to ramp-up testing of our application, and we started getting these messages in our log file: LOG: checkpoints are occurring too frequently (15 seconds apart) HINT: Consider increasing the configuration parameter "checkpoint_segments". LOG: recycled transaction log file "0000000000000045" LOG: recycled transaction log...