PostgreSQL Database Forum

I have a perl test program which has about 80 test cases, each of which creates its own schema so I can remove them with DROP SCHEMA xxx CASCADE. Normally each test case creates and drops the same schema, but it can run a mode to preserve each schema and all the disk files for each test. I recently changed my cleanup code to run psql with...

Hi! I am trying to retrieve the column names that comprise primary key of a table. According to manual, pg_index.indkey is an array of indnatts whose usage I am unaware of. CREATE TABLE table1 ( PRIMARY KEY (c1,c2), c1 SMALLINT,

Hello All, I installed postgresql 7.3.4 on HPUX PA in /usr/local/pgsql and put the libraries in /usr/local/pgsql/lib/LIB_new. During the initialization( initdb), it loads libraries (language) from /usr/local/pgsql/lib. In postgresql version 7.3.1, libraries are not loaded and no such problem during initdb. I had the following problem: ...

Greetings, Does anyone know what the effect of sending an INT signal (kill -2) to each of: - pg backend - psql running an insert or select into - Perl script with DBI connection to pg, running insert or select into - vacuumdb

We're implementing our first PostgreSQL database, and enjoying it very much. However, we have a table that will store binary image files (pie charts, etc.) for later display on a dynamic webpage. While we're putting together our prototype application, I've been asked by the programmers (I'm the DBA) to "put the images in the database." I can...

Hello everyone, I try to see if i can make a recursive function with a trigger set on INSERT and doing an insert under my trigger function. So i wrote a test function : CREATE OR REPLACE FUNCTION testfunc() RETURNS SETOF RECORD AS ' DECLARE

Is there a feature similar to this currently in Postgres, or will there be? Sometimes (like in a shared hosting environment), we cannot have the luxury of hot-swapped RAID or expensive SAN, and it's nice to be able to have a synchronous backup so that in case a disk fails, we can recover to the last moment just before failure. Will PITR...

Synopsis CREATE { TEMPORARY | TEMP } ] TABLE /table_name/ ( { /column_name/ /data_type/ ] | /table_constraint/ } ) ) ] so this means that every column's constrain should be separated by a comma.

About 3 weeks ago, I started receiving double messages from all the postgresql lists. This generated quite a bit of extra email and was very annoying. I decided to prune down the number of lists that I subscribed to, so I started by removing myself from psql-general (by sending the correct command with my password to the list server). I...

Hi, I'm trying to work out how to make sure things are read from a table in a consistent order. The table represents a queue of items and also the history of those items. Even with "serializable" transaction isolation I can begin two transactions, insert a record in each, commit the second transaction first. This second record is now...

I have plperl installed my PostgreSQL 7.4.2 server, but from what I understand in chapter 39.3 of the docs, you cannot access the databases without DBD::PgSPI. According to the readme for that module, it will only run on the untrusted plperlu. Is this the only way to run queries (SELECT, INSERT, UPDATE) using plperl? What are the...

I have to implement a structure of rights. I'm intrested if postgresql can restrict these operations(insert, update, select, delete) for a specified postgresql user. If this is possible, please tell me were could I find some documentation about this subject. Thank you.

Hellou, when I use pg_dump database > dump.dat on database with tsearch2 and then psql database < dump.dat - this command fails, because in dump.dat is declaration of tsearch2 procedures and types after main schema, which is using tsearch2. is this patch for this??

How can I implement C-Language functions in a Win32 environment?

Is it possible to to the following I have tables which are updated via webpage (perl) with fields of type int and date (all nullable). If the values are blank the entire insert fails, with a wrong type error. Is there any way to stop this behaviour so that the valid information is allowed,but the blank values get ignored. ...

Hi, I have a field in which I save the follow: {{8,0.58},{9,972420},{10,239544},{6,0.49},{7,0.63}} The first field is a reference to an id in another table and the second field is a value. Can these values be used somehow in a select query to join the other table?

Hi, I want to administer files with postgres. When I "import" a file to postgres I also submit certain atributes the file has. Such as filetype or specific properties I know about the file (not the standard stuff like the OS knows about the file as date,and size) I want that postgres then copies the file to a save place and write and read...

Hi, Below is my VB6 code that writes data from an Access 2000 table to a PG table. The " & "" " on the right of each line should prevent nulls from being passed to PG. For some reason I still get nulls in any field without data. Even the secondary part number which is set to "".

(Sorry if it arrives twice.) > > Hi All, > I'd like to write an SRF but I'm block a strange error message > > WARNING: plpgsql: ERROR during compile of check_close2 near line 11 > ERROR: return type mismatch in function returning tuple at > or near ";" >

How can i get a list of all types that dont have the "_"before them. I only want a list of the types that a user might need to create tables. thanks! -- Alexander Cohen http://www.toomuchspace.com (819) 348-9237 (819) 432-3443

Hello, I'm building a small web app (written in JSP) and using PostgreSQL 8.0 Beta 2 as the backend running on Windows XP (installed with pgInstaller). Ocassionally, I get this SQLException message in my web page: "SMgrRelation hashtable corrupted"

I have a question about locks. I have a stats table that get updated when some other table changes. Sometimes that other table is updated a 2nd time before the first stats update is finished which causes an error. I've tried using 'SET TRANSACTION ISOLATION LEVEL SERIALIZABLE' but get 'could not serialize access due to concurrent update' ...

Hello, I have a question about "date" & "timestamp" types in PostgreSQL. I want to setup the default value '0000-00-00' and "0000-00-00 00:00:00" for them. However, it seems that PostgreSQL does not support it. Could someone helps me please? The example table: T1 (col1 varchar(7) not null,

Dear Friends As Subject How to resolve, since i use with out problem on postgresql 7.3 Regards Luiz

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi there, which operator class can I use in order to search points by distance like in: SELECT p FROM tbl WHERE (p <-> point(0,0)) < 10; - From what I've seen, there is none - which surprises me ...