| |
thread by: Thomas Hallgren |
last post Nov 23 '05 by: Steven Klassen
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,
|
thread by: David Rysdam |
last post Nov 23 '05 by: Michael Fuhr
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...
|
thread by: Scott Cain |
last post Nov 23 '05 by: Scott Cain
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
|
thread by: Leonardo Francalanci |
last post Nov 23 '05 by: Leonardo Francalanci
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...):
|
thread by: Rodrigo Carvalhaes |
last post Nov 23 '05 by: Rodrigo Carvalhaes
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 ?
--
|
thread by: Neil Berkman |
last post Nov 23 '05 by: Tom Lane
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...
|
thread by: Scott Frankel |
last post Nov 23 '05 by: Pierre-Frédéric Caillaud
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...
|
| |
thread by: ruben20 |
last post Nov 23 '05 by: Gaetano Mendola
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
|
thread by: Tatsuo Ishii |
last post Nov 23 '05 by: Bruce Momjian
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...
|
thread by: Keow Yeong Huat Joseph |
last post Nov 23 '05 by: Keow Yeong Huat Joseph
I would like to unsubscribe my address from the mailing list, please advisehow to go about this?
Regards
Joseph
|
thread by: nd02tsk |
last post Nov 23 '05 by: Christopher Browne
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?
|
thread by: Steve Wolfe |
last post Nov 23 '05 by: Tom Lane
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"...
|
thread by: phil campaigne |
last post Nov 23 '05 by: phil campaigne
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
|
thread by: Alexander Cohen |
last post Nov 23 '05 by: Robby Russell
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
|
thread by: Steve Wolfe |
last post Nov 23 '05 by: Steve Wolfe
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...
|
| |
thread by: Michael Kleiser |
last post Nov 23 '05 by: Tino Wildenhain
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...
|
thread by: Ted Shab |
last post Nov 23 '05 by: Ted Shab
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
|
thread by: ruben20 |
last post Nov 23 '05 by: Tom Lane
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
|
thread by: Jason Tesser |
last post Nov 23 '05 by: Jason Tesser
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
|
thread by: Michael Hannon |
last post Nov 23 '05 by: John
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...
|
thread by: Bob Powell |
last post Nov 23 '05 by: Frank Kurzawa
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.
|
thread by: Phil Endecott |
last post Nov 23 '05 by: Richard Huxton
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...
|
thread by: fx gamoy |
last post Nov 23 '05 by: DEHAINSALA Hondjack
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
|
| |
thread by: DEHAINSALA Hondjack |
last post Nov 23 '05 by: DEHAINSALA Hondjack
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>
|
thread by: Henriksen, Jonas F |
last post Nov 23 '05 by: Richard Huxton
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...
|