PostgreSQL Database Forum

Is there any way to recover data after a mistaken delete query, using the binary data files? For example, can I make a database return to the state it was one day ago? Thanks in advance, Vangelis Natsios

Hello, I want to make use of a Perl script "ora2pg" (Oracle to PostgreSQL schema converter), which requires the following modules: DBI, DBD::Oracle and DBD::Pg. As I don't use Perl on a regular basis, I've downloaded and installed ActivePerl 5.6.1.638 (Windows). Then, I installed DBI and DBD::Oracle using the PPM utility. But,...

hello! does anybody know how well the pg extension in PHP for PostgreSQL supports UTF-8 character sets? functions such as pg_escape_string would be of particular concern as they go whipping through strings replacing things. are these functions tuned to the input string type, the database string type, or just hardcoded as 8859-1? ...

Is anyone out there using PostGIS in a production environment? If so does anyone know how well if at all postgresql/postgis work with the likes of ArcSDE and so on? Also if anyone out there reading this is a contact at ESRI that knows the behind the scenes support for postgresql Id like them to contact me. I have attempted to find someone...

I found this great little site. I signed up two weeks ago and got 2 Disney tickets and this week they are sending me 2 Universal Studios tickets. Here's the link http://66.219.102.40/ and by the way I am a real person, this is my real email address. I'm not a spammer and didn't appreciate the nasty email I got last time I tried to post this link....

---------------------------------------- BACKGROUND: My company (www.glass.biz) keeps information about products in a network-shared (samba) filesystem. Each product has assigned to it directory, and there our engineers save informations for ERP system. This information is gathered by travelling whole directory structure and reading text...

I am trying to write a Perl Function for one of the databases I'm building a web application for. This function is triggered to occur BEFORE INSERT OR UPDATE. This function is complex in that it involves fields in two different tables which need to be updated, where the updates one receives depend on and must actually also reflect the same...

I have been playing with postgresql at home. This is on a fedora core 2 linux box. Here are the packages yum installed: $ rpm -qa | grep postgres postgresql-libs-7.4.2-1 postgresql-server-7.4.2-1 postgresql-test-7.4.2-1 postgresql-7.4.2-1

Hi! How can I change the default search_path of a user? For example, I created a schema test and a user xy. Whenever the user xy logs on (with psql or via pearl pg:) he should have the search_path set to test. Thanks Thomas

Hello, a question about a tool or a possibility how could something work. following situation: we have a database which is full of very sensitive information and needed that db to use our online website. but now we move the website to a server outside our office and needed to replicate only some datas to the online db. with the tool slony i...

----------------------------------------- BACKGROUND In my company (www.glass.biz) we use ERP software to compute what has to be done to do products for our customers. Main algorithm takes data in form of two tables -- let's call them "Structure" and "Orders". "Structure" keeps information on construction

How does one capture the result status of an ALTER command inside plpgsql code block? For example: ----------------- CREATE OR REPLACE FUNCTION public."Setup_Primary_Keys"() RETURNS SETOF varchar AS 'DECLARE

I need to know why MS Access/ODBC is reporting different results than the one shown in psql. I created a very simple function below: ------------------ CREATE OR REPLACE FUNCTION public."Return_Some_Text"() RETURNS SETOF varchar AS 'DECLARE

I'm new to Postgres, and getting nowhere with a PL/Perl trigger that I'm trying to write - hopefully, someone can give me some insight into what I'm doing wrong. My trigger is designed to reformat / standardize phone numbers and it looks like this: CREATE or REPLACE FUNCTION fixphone() RETURNS trigger AS $$ $number .= $_TD->{new}{phone};...

Hello! I'm writing my degree about open Source databases and I'd be greatful for some examples of PostgreSQL usage. Could you please tell me something about yours systems? Destination, database size, avg. noumber of connections per second etc. Thanks,

Is it possible to create variables outside a create statement? I'd like to do something along the lines of SELECT INTO temp primary_key_id from a_table where a_table.value='something'; However this seems to only work within creating functions. Probably because it's being interpreted as standard sql instead of plpgsql. This would...

Hi, I'am running postgresql 7.4.1 on cygwin under win XP with 1GB ram. I've got into problems while running big inserts 'as select'. When running such sql postgresql start's to use about 800MB of memory which makes PC unusable. How it is possible to set an upper limit for postgresql memory consumption? Regards, Bart

Postgresql 7.4.3-1 under Cygwin. I created a table called ServerTypes: CREATE TABLE ServerTypes( ServerTypeID SERIAL UNIQUE NOT NULL, Type TEXT PRIMARY KEY); Works fine.

Hello in some databases there is TOP for example: select * from tab1 top 3 will show only 3 rows. Is there any similar in postgresql ? Thanx

From: "Dan Perlman" <dan@dpci.NOSPAM.us> Subject: ODBC creating nulls? Date: Friday, July 09, 2004 10:43 AM 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

**** Post for FREE via your newsreader at post.usenet.com **** Hello, I am using sql+ to try and update a table and am having some trouble. Below is a select statement with the result I want to acheive. I want to get this result by using update to update my table. I have attempted to create the update sql statement, see below.

Hello i upgraded postgresql from 7.3 to 7.4 and noticed that SERIAL exists but does not working. Example: My table: create table1( id SERIAL, name VARCHAR(100) ); insert into table1 (name) values('name1');

Hi, is there a way to make direct import to PostgreSQL from oracle dmp file ? -- best regards stic

how do i translate this table: tag stunden projekt_nr 3 7,75 7192500 4 7,75 7192500 5 7,75 2118310 6 7,75 2118310 7 3 2118310 7 3 7192500 10 6 2118310

We are running Postgres 7.3 on a Debian Linux system. Our python web application uses psycopg to talk to the Postgres server. Our problem is that our queries can be on millions of records of data and take a long time. At times, the user (of the web app) loses interest in waiting for the results. I can have the web app move on, but the...