PostgreSQL Database Forum

I'm having a wierd problem with pg 7.3.3 PostgreSQL 7.3.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2 20020903 (Red Hat Linux 8.0 3.2-7) I have a bunch of inserts being done by JDBC. One of them if causing a problem. LOG: query: INSERT INTO mailtextlog (mlid,tlog,cdate) VALUES(99999933,'Sent via localhost','2003-08-27...

Hi ... I'm trying to convince my boss to use posgresql (I need RI, transactions and views), but he keeps comparing the project to mysql. Until now, I found the answers to he's questions on the www.postgresql.org page, but now I'm lost :-) Where do I find a list of bugs both found and solved, or will I need to ask on the pgsql-bugs list...

Please, disregard my last message. I've discovered that in "password" file it was mentioned a path '/var/lib/psql' where Mandrake distro installed postres previously. I've solved it. But I still have another problem: A later step in Postgres installation instructions says: "/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data >logfile...

Perhaps a subject line would help ... -----Original Message----- From: Gregory S. Williamson Sent: Monday, August 25, 2003 2:28 PM To: 'pgsql-general@postgresql.org' Subject:

Hi. I'm having some trouble on the use of indexes. The querys below are exactly the same but refer to different months. One case uses indexes, the other doesn't. Is there anything I can do? Increasing index mem size? Query 2 hash 9105 entries matching the given conditions Query 2 hash 9248 entries matching the given conditions

Need to export an existing M$ Access 97 database to Postgres. Tuples must be filtered as I am using sequences and other constraints. Help from anyone that has experience with this or know of 3rd party automation tools would be greatly appreciated. Raymond ---------------------------(end of broadcast)---------------------------

Could someone provide me with some information in regards to the performance implications of applying constraints on a table? Are there any safe guards? The basic scenario is that there is a table that has 80% updates and inserts and 20% selects. I would like to restrict duplicate inserts from user double clicking or other user behavior...

Hi, What is the problem with the following table declaration? CREATE TABLE persons ( id SERIAL PRIMARY KEY, name TEXT NOT NULL, bdate DATE, address INTEGER REFERENCES addresses, phonepriv INTEGER REFERENCES phones,

I am running 7.2.4 I have 2 functions: get_deficiency_days_old() and get_deficiency_days_old_sub() The former basically is just a wrapper for the latter. The problem is that when I restored from a pg_dump script, the former was

Hello, I want to convert an existing database with SQL_ASCII encoding to UNICODE encoding. (postgresql ver 7.3.2) I thought that it might be as easy as: pg_dump mydatabase > dump.sql createdb --encoding=unicode newdatabase psql newdatabase < dump.sql

following is taken from postgresql-7.3.2/src/backend/storage/lmgr/readme: "If we are setting a table level lock both the blockId and tupleId (in an item pointer this is called the position) are set to invalid, if it is a page level lock the blockId is valid, while the tupleId is still invalid. Finally if this is a tuple level lock (we...

Hi, A small question ... and your opinions are well done ... I have tested one thing today ... I have a script in charge to insert a lot of files inside one of my db. I have a perl script where I read the files ... check if some similar data are in the db ... then delete them ... and insert the contains of the file. I do this file by...

to the point: I heard that postgresql has support for object oriented query (SQL3). Since what version(s) would that be? thx 4 the information. regards, rifki ++++++++++++++++++++++++++ + open mind, open heart, act ! + ++++++++++++++++++++++++++

I've found the pg_depend table, but it doesn't appear to include this info. (Or am I missing it?) I'm looking to get all view names that I need to drop to allow a particular table to DROP RESTRICT. Alternately, I would be happy with a way to get the names of objects that are dropped when DROP CASCADE is used.

From time to time I'm getting this error message: WARNING: Error occurred while executing PL/pgSQL function atualizabusca WARNING: line 25 at for over select rows ERROR: unknown cmdtype 136748160 in exec_stmt It's a 7.3.3 running on a FreeBSD 4.8 When I recreate the function it works well for some time, but after using the database for...

following is taken from postgresql-7.3.2/src/backend/storage/lmgr/readme: "If we are setting a table level lock both the blockId and tupleId (in an item pointer this is called the position) are set to invalid, if it is a page level lock the blockId is valid, while the tupleId is still invalid. Finally if this is a tuple level lock (we...

What would be the best way to "flatten" a set of records into one column with a query? example: You have a table called tbletters id letters 1 a 2 b 3 c

See the attached file for details ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly

I have found an pgsql-mode.el file which I want to install in my xemacs but sorry, I am lost as to how install it. Or is there a better solution to pgsql programming in xemacs? I am using Redhat 9 Alfred ---------------------------(end of broadcast)---------------------------

The osdl-dbt3 test starts with building and vacuuming the database. The execution plans were taken after the vacuuming. I did two tests with the same database parameters: 1. run two osdl-dbt3 runs on one box without rebooting the stystem. Though the execution plans are the same, the costs are different. The system status are different for...

I need to get two fields from two tables and append them into one field with CR/LF in between, how is this done using a select? Regards, BTJ -- -----------------------------------------------------------------------------------------------

Howdy: Running PostgreSQL 7.2.1 on RedHat Linux 7.2. How can I convert data in a table that has been created with the INTERVAL data type into a numeric format? Say, I have a table with this type of data:

Hi all; Up to date. I've used Microsoft Access as a WindowsXP Client for Postgres. But I want to know if pgAdmin can do the job. I've downloaded pgAdminII Version 1.6.0 for Windows. My current Postgres version is 7.2 And I can acces it from Microsoft Access2000 .. When I try to connect the server from pgAdminI, I receive the message: ...

I have a lot of tables of the same structure that represent weekly states of a certain system. I'd like to write a function that would take field name, number of weeks and return history of that field values as a single row. I imagine something like this: SELECT * FROM history('temperature', 10); This should give me 11-column row, with...

I'm wondering how hard will it be to implement POSIX strftime function and what's the best way to go about it? I hooked up similar functions to MySQL in the past and all it took was little modification to example C code, compiling it as a shared library and issuing one SQL statement. What's the PostgreSQL's way to do it? Best regards, Egor...