PostgreSQL Database Forum

Hi there, I am totally new to database programming, and just have a question about starting psql. I've downloaded the latest version of postgresql in windows (xp), and now I need to start using it, except I have no idea where to begin. The documentation at http://www.faqs.org/docs/ppbook/c4890.htm under "starting psql" doesn't seem to be for...

Can anyone tell me about database backup and restore. There are lot many dumps available but i want to use tar/gzip backup. also provide me information about restoring it in case of db crash. Method i use should be easy and fast. From C# as front end in linux server I should be able to do this. I will be more happy if somebody helps me on...

Hi! New to postgres, im trying to import shapefiles into postgres 8.2 using shp2pgsql but so far have failed. I tryed using the -p option just to prepare / create the tables then insert the data, but no luck, please help me writing the correct syntax to acomplish for the following: Shapefile named "callesnac.shp" Database "postgres"...

In a function we r finding max value of a column which is hving an id value and then incrementing the column value by adding 1 to the value . now we have to check if max value is zero (ie that column has no value) then we have to write 1 in the column and start incrementing them. how to do this. plz reply as soon as possible.

hai, now we are using batch file for take backup at time of start services and stop services. we need option for take database backup at time 1. System Start 2. System Shutdown using the windows sechulder, we got the solution (System Start time backup. ...

Hi, I have installed postgres 8.1 server on UIBUNTU /etc/init.d/postgresql-8.1 start but when I tried to start it, it gives following error. Starting PostgreSQL 8.1 database server: main* Insecure directory in $ENV {PATH} while running with - T switch At /usr/bin/pg_ctlcluster line 52.

hi all, i have written one function, but it is showing some error, the code is as follows: CREATE OR REPLACE FUNCTION fn_name(int8, int8, int8, "varchar", date, date) RETURNS "varchar" AS ' declare dt numeric; a varchar(20);

Hi, I'm pretty new with Postgre. So far I've managed to create databases, functions, etc and access them from Windows applications written in C# via Odbc and Npgsql. I am requested to use OleDb, so I got hold of this provider. I registered the dll and can actually create the connection, but when I try to open it I get an exception saying 'invalid...

Can anyone please tell me the impact of uncommenting these two parameters of postgresql.config file. #commit_delay = 0 # range 0-100000, in microseconds #commit_siblings = 5 # range 1-1000 And is there any, auto commit setting can be done thru this?

does anyone know how I can retrieve the start of the year in postgres without hardcoding it, and so it will go back to 2008 in 2008 not 2007. select now()....... need to minus the amount of days from Jan.1 to get back to Jan.1 ?

please tell me how can i migrate the data of a csv or excell table into the corresponding postgresql table ? is there any migretion tool from excell to postgre ?.

How actually the query executes in PostgreSql database. Different phases of execution and where actually the Datafiles, LogFiles and Control Files reside while installing PostGresSql in Linux Machine. Is there any feature like Replication exists in PostgreSql. However, this is open source but material availability is very rare. One more thing,...

Hi everybody! How to write a trigger, to increment a field (numeric type) even if the user cannot modify anything in dbase?

Hi, I'm stuck here. I have a function that I would like to pass a text string and have the function perform ILIKE on that passed string. create or replace function foo( sLastName text ) AS

Hi team, I'm new in Postgres and I tried creating a stored procedure which performs numerous update procedure. As I compiled it, I was given the following error: psql:storedproc.sql:33: ERROR: language "plpgsql" does not exist HINT: You need to use "createlang" to load the language into the database. So I tried to execute this code but...

Can someone tell me what's wrong with this syntax? CREATE OR REPLACE FUNCTION Foo(bigint, out int, out boolean ) RETURNS record AS $BODY$ begin $2 := 0; $3 := false; end

We are running a PHP web-based frontend with a Postgres 7.2 backend on a Windows 2000 Server box with automated backups of the server being handled by Legato. We are experiencing several problems that point in the general direction of the backup process but we have nothing concrete. The Legato system runs incremental backups Monday through...

I want to store some pdf files in the database, What would be the datatype for the same. If anyone knows please give me the details. I am very new to the PostgreSql database.

Hi, everyone I want to compare Oracle and PostgreSQL. I need some information.... Do you know, how PostgreSQL searching Queries? You can give me some guide to do this comparison. I glad to heard something from you all. Thank you..

Indexes are good for "select statement", bad for "inserts, updates, deletes", how does a constraint differ? I've created a constraint on a table as "unique", and later went in a created 6 indexes (not primary or foreign). Would it be better to build these as constraints even though they will only be used in a "select" clause? thank you

Let's say I have a table, data_tbl, with the following columns: object_id of type integer mytimestamp of type timestamp with time zone data_1 of type integer data_2 of type integer And each object within this table gets a new record every second. So if there are 4 different object_ids, then 4 new records are inserted each second. Now,...

Ok, my syntax is off somewhere. Can someone set me straight on how to declare a local variable in a function? CREATE OR REPLACE FUNCTION BLAH( bigint ) declare int cnt RETURNS void as $$ cnt = select count(*) from "DCx" where "Index" = $1; if cnt > 0 then

Ok, I'm pretty good with MsftSQL, but there's enough differences with PostgreSQL to make things confusing. I'm having a problem declaring a function (I want a stored proc). Here's my schema CREATE TABLE author ( "authorName" character varying(100) NOT NULL, "authorID" integer NOT NULL DEFAULT...

Hi Friends, I would like to set the properties of a transaction like ON_ERROR_ROLLBACK . To set This parameter There is a psql command (meta command) \set. ex: \set ON_ERROR_ROLLBACK on from the psql terminal it was working fine. But my problem is I am working with the libpq 'C' library in VC++. by uing this libpq library I am connecting...

I'm searching for the informations of PostgreSQL's features and its data management strategies. I know nothing about PostgreSQL. Please give me some suggestions. Thanks so much.