PostgreSQL Database Forum

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

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.

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...

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.

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...

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

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: ...

unsubscribe pgsql-general ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org

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,

Hi. I'm new to postgresql in general, and have been tasked with coming up with a replication solution for our postgresql based application. Assuming we don't bite off trying to roll our own solution, it looks like the open-source options for replication are: 1) contrib/rserv 2) erserver 3) slony 4) pgreplication

hello all, on my master-db-server i'm running postgres 7.4.1, and I have got two slave-servers running postgres 7.4.2 running the following query on the master-server (7.4.1) delivers: explain analyze select * from foo where bar like '0101%' and foobar like 'top%';

I'm attempting to use spamassassin 3.0 (beta) with an SQL backend, and have identified one performance gain so far that makes PostgreSQL a good (IMO) candidate for the backend. I need some advice though on another aspect-- instead of storing each token as text in the database, the token is being sha1()'d and then possibly pack()'d. That's...

Hi, We've got some clients that are concerned about running Postgresql 7.3.4 on a Win2k Server box, alongside MS SQL Server. I've been running pg on my XP machines for a long time now (with cygwin) and never had any sort of problem. The db is fast and stable. Does anyone have any experience that would give some weight to our client's...

The variable names in postgresql.conf have changed in the last several releases. I'm now confused about what variable(s) to set to show the query in pg_stat_activity. Hints? --elein ============================================================ elein@varlena.com Varlena, LLC www.varlena.com

What is the performance or other benefits of text search on pgSQL vs mySQL on large dbs? thanks for any comments, ..V -- Please post on Rich Internet Applications User Interface (RiA/SoA) <http://www.portalvu.com>

Hello, I am trying to select distinct dates and order them in the reverse chronological order. Although the column type is TIMESTAMP, in this case I want only YYYY, MM, and DD back. I am using the following query, but it's not returning dates back in the reverse chronological order: SELECT DISTINCT

Was wondering if anyone could help me. I have a database with some bad characters in it -- some users had entered MS Word smart quotes, em dashes, foreign characters, and they look like gibberish coming out of the database. What's the best way to replace these characters? I thought I might be able to run a simple SQL UPDATE command, but...

How do I go about ensuring that data is only added to a table through a function? I've tried granting execute persission on the function which inserts data, but can't get it to work unless the user also has insert permission on the table. I don't want the user to be able to arbitrarily insert data. ---------------------------(end of...

We upgraded from 7.2 to 7.4, it looks like everything working, but when I issue a query such as select * from tab (tab has about 2-3 million records), it causes core dump. I tuned some the parameters, it still produce the core. Thanks for any hints.

Hi, Is it possible to define "linked servers" like in MS-SQL? Or - is any work going on to implement such feature? So that using 2 postgresql DB's where one is in dmz and one in production - the last one has defined the one in dmz as a "linked server" and sql's sent to the internal DB can do joins between tables in internal DB and DB in...