PostgreSQL Database Forum

I'm connected to a database and I want to verify that a username and password for some user is correct. I know I can verify a users existence by doing: select exists(select * from pg_user where usename = $1) but I would like to verify the correctness of the password as well. Is there a way to do that using SQL? Regards,

I have a large amount of data that I copy in and out of Sybase very often. Now I also want to copy this data in and out of postgres. I have an existing script that creates the entire database(s) from scratch in Sybase and then uses the Sybase bulk copy tool "bcp" to copy the data in. I already did a brute force port of this script to...

Hello, I am trying to create audit tables for all of the tables in my database. The function, table and trigger create statements are below. Apparently, I am not doing it quite right, because I get these messages when I try to run the create statements below: CREATE FUNCTION CREATE FUNCTION CREATE TABLE

I wrote a function to sum arrays. It works, but I had to cast the data pointer to int64 (because my arrays are 'int8'): int64* ptr1 = ARR_DATA_PTR(v1); What if I want to write a more general function that adds values of 2 arrays of every int type? How could I do it? Here is the function (if you find any errors tell me...):

Hi Guys! Anyone already made a importation from CTREE files ( files .dtc) to PostgreSQL ? I know that there is a "contrib" tool to import files from dbf to sql... Any tip ? --

Is there any way to remove a password, specifically from the postgres user? I installed the 8.0 Windows version via the installer, and it forces you to set a password. I'd like to reset this so that there is no password (basically, to match the setup on several other machines - and no, for a number of reasons it's not feasible to just set...

First, apologies in advance for this somewhat OT post ... I'm looking for a source of information on using the psycopg interface to postgresql. A mailing list would be ideal. I've poked at their wiki, but not found what I'm looking for. Also, new to both postrgresql & psycopg, my questions appear too basic for the doc/examples they...

Hi: Is there any way to recover data from a corrupted table? I can only run SELECTs on certain WHERE conditions. I cannot vacuum, pg_dump, I've deleted the indexes and try to reindex, always get error: ERROR: could not access status of transaction 4244329 DETAIL: could not open file "/usr/local/pgsql/data/pg_clog/0004": No

Hi all, We, Software Research Associates, Inc., have started "PostgreSQL CE" (PostgreSQL Certificated Engineer), on Oct 1st. PostgreSQL CE is an entry level PostgreSQL engineer certification program. We expect at least several hundreds of people will take the examin by April 2005. We also hope that PostgreSQL CE makes PostgreSQL more and...

I would like to unsubscribe my address from the mailing list, please advisehow to go about this? Regards Joseph

Hello I am going to do a comparison betweem PgSQL and MySQL replication system. I hear there are some replication projects available for PgSQL. Which are still active and serious, because I hear that some are not active or incomplete? Will any of these projects be merged with PgSQL soon?

On Saturday, our database machine locked up hard on us due to some faulty hardware. Since then, we have been getting messages like this: ERROR: could not access status of transaction 143934068 DETAIL: could not open file "/usr/local/pgsql/data/pg_clog/0089": No such file or directory Looking in /usr/local/pgsql/data/pg_clog, the "0089"...

Hi I'm trying to create a select statement that will return all rows that are older than 30 milleseconds. Is either of these correct? select event_id from event where (current_timestamp-timestamp)>.030 or select event_id from event where (current_timestamp-timestamp)>000000030.000000 thanks, Phil

Hi, Im looking for instructions on installing the postgresql ODBC driver on mac osx and windows. Is there any reference for that. Any help is apprecitaed. BTW, i need to compile it and install it wihtout using the windows installer. Alex

In reference to the pg_clog errors I'm having, I am still looking for tips or help. Here's the info again: "ERROR: could not access status of transaction 143934068 DETAIL: could not open file "/usr/local/pgsql/data/pg_clog/0089": No such file or directory Now, despite creating an 8k file of zeros (or a 256k file of zeros to match the...

I found on http://www.physiol.ox.ac.uk/Computing/Online_Documentation/postgresql/plpgsql-porting.html that it is not poosible to use start or end a transaction in plpgsl. I tried to create a plplsql-function on PostgreSQL 8.0 beta 3 I can comile CREATE OR REPLACE FUNCTION insert_many_commit( integer ) RETURNS void AS ' DECLARE counter...

Hi, I'm trying to come up with a relatively simple multi-master replication solution. This is for multiple databases that need to be discreet, and change relatively infrequently (10-30 updates an hour), and almost never update each others data (less than once a day). The TCL-based replication project for multi-master is

Hi: I've migrated a couple of weeks ago from 7.4.2 to 7.4.5 and I am getting this error after executing a query: Warning: pg_exec() query failed: ERROR: could not access status of transaction 4244329 in /home/wisconsin/www/_proc/bbdd/_c_bbdd.php on line 160 ERROR ACCESO BASE DE DATOSERROR: could not access status of transaction 4244329

I have a database in sql_ascii that I need to convert to Unicode. I tried using pg_dump -Fc .. but it fails on certain characters. like this one "è" How can I get the data transferred? ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend

Greetings. We're running Postgres 7.3 on an Intel linux box (Redhat Enterprise server, version 3.0). We find ourselves in an awkward position: we have a database of attributes relating to students that uses as its primary key the ID number of the student. This is awkward for the following reasons. Our university used to use...

Hello everyone, I would like to know if anyone has found or developed any monitoring software for Postgres. I would like to be able to gather statistics about the database. How often certain tables get hit, whats the current status of things etc. I couldn't find much in the lists about this. Thanks.

Dear All, Within a transaction, now() and current_timestamp are constant and give the time that the transaction started. This is normally what you want. But I have a case where I actually need the time that the transaction is committed, or something similar. Is there a way to get it? Here is the problem: The timestamps that I am...

hello everybody, i ve got two big tables with the same structure. i would like to add the second one to the first one directly without generating a sql file. (each table is about 1 Million line) Is it a way with an sql command? INSERT INTO TAB1... (select * from TAB2) ??? thanks fx

Hi I want to test PostgreSQL v8 native windows taht allows to create a table or column with 128 characters !! Where can i get it ? Thanks U for help !! Hondjack ----- Original Message ----- From: "DEHAINSALA Hondjack" <hondjack.dehainsala@ensma.fr>

Hi, how come, if you create a user with no permissions at all, having been granted nothing, he can still log into any database, list available tables, create new here, and then delete them again. Seems odd...: medusa:~% createuser odd Shall the new user be allowed to create databases? (y/n) n Shall the new user be allowed to create more...