PostgreSQL Database Forum

hi all, i have created a function. i got the problem. it doesn't show the out put if i put between condition. but it works perfectly when used only ">" condition only in the date ie create or repl... ... .. to_char('||quote_ident(date_type)||',''yyyy-mm-dd'') > '||from_date ; ....

We set up a new system with the OS and database below. Now some pages are not loading in browser. the error is: but the same code is no problem with old server.. i can also insert the data into database with some pages.

i have instaled postgesql 7.1.11 on red hat el 5.3 after installtion its worked. when i change the line in /etc/rc.d/init.d postgresql as export PGDATA=/var/lib/pgsql/nampetdb (export PGDATA=/var/lib/pgsql/data) after that i could not restart the postgresql the contents of postgresql log id The files belonging to this database system...

hello all... I am using postgres as my backend server and i need to insert some characters into tables... the server side encoding is UTF-8 and i am using the psqlODbc to connec to the database.. now for example if i try to insert some russian characters it inserts some '???????' if i use the command set client encoding to UTF8, this sets...

I have installed postgresql 8.3.1,import data from a dB to another one.I work in pgadmin 3 . When I choose a table ,select the characteristic?it shows the problem below? Error:relation "pg_autovacuum" does not exit? Line1?select* from pg_autovacuum where vacrelid=26769::oid what is the problem? How to solve it?

Hi, How to get the C# data type like SQLDataReder or SQLDataAdapter from Nhibernate query?? By default session.CreateQuery(strQuery) returns IQuery object, but I want to get C# data type like SQLDataReader, SQLDataAdapter for the NHibernate query can anyone help???? Regards Dheeraj Joshi

I am a very, very, very beginner and want to learn Postgresql and would like to know if there is a P.I. manual or book that starts with the most elementary basics? Something like the Dick and Jane children's books? Thanks.

I created a table of five columns as follows crop_id, crop_type, crop_name, cultivation_yrs, local_name. I want to make the crop_id to be the primary key, and also to be autoincremental as well as serve as a reference to a foreign key in the main database table which is a different table altogerther. I am able to create the...

I want to see the type created for running a function. please tell me the query for this. i tried for : select * from pg_type where typname=' '; is it right or wrong. if wrong please send me the appropriate query.

I need to compile PostgreSQL 8.3.5 on CentOS 4.2. The CentOS already has PostgreSQL 7 installed as part of its default installation. For some reason, I cannot touch the existing PostgreSQL (upgrading, etc) --I really need to use my own compilation of PostgreSQL. Is it possible to have multiple installations of PostgreSQL (and different version...

Hello, What is a good approach to PostgreSQL backups? (yep, a newbie) (The server crashed and IT was not able to bring it back from the Acronis images - so rebuilding from scratch - ugh! - want to have a secondary system, that lesson is learnt!) Ideally, having the compressed backup that pgAdmin is able to do run on some sort of Task...

PG Admin Version 1.6.0 (Nov 15 2006, rev 5641) Running on Windows 2000 PostgreSQL 8.2.6, running remotely on Linux pg_hba.conf contains the record ... host all all 12.345.678.90 255.255.255.255 trust where 12.345.678.90 is the IP address that I am trying to connect from Database started with ...

Hi all, I have a question... our company has a centralised oracle database and few postgress clinets .. we want to replicate or copy a perticular table and column from oracle to pg.. is there any way we can do it with out using any tools in postgress.... oracle should not push the change but postgress should pull the information from...

Hi, I have to feed database A from database B which are in different machines but in the same network when a insert/update occurs on database B. I decided to use trigger for this and was trying to write a trigger but failed so far.... (I have written triggers in mysql but using pgsql is a bit difficult to me...) It will be so helpful to me...

plpgsql (postgresql 8.3 but I can upgrade) I can open a cursor with a dynamic query (table / column variable) : -open cursor for execute '...' ; But if I want do updates... - execute 'update ...' where current of cursor ?? Mmm I don't find the way. Another approach :

I have a PostgreSQL database encode in UTF-8. I try to do a mail merge from OOwriter. This seems to work except for non western characters. E.g. when I access the database from pgAdmin, a GUI client I can see all UTF-8 encoded characters. When I cut a text from the GUI and paste this text in OOwriter everything works well. The same text through a...

Hi, I have created table using following sql statement through psql tool in test database using create table t1(f1 int); table is created. Now I am using an odbc script to insert 5 records. But it inserts 6 records NULL value being the first one inserted. the code snippet is as below. ... ...

hi all. wanted to know if its possible to use a full dump + WAL logs as a gud backup plan ?? thanks.

sudo gvim /home/user/.psql_history and press enter enterpaswwoed for user then the file will be opened then u can delete the commands are delete only required commands and save the file

I am doing a php webshop. I have 4 tables: product for product info, product_catalog for multi-level catalogs, product_product_catalog for binding product and product_catalog together -- it shows which product is in what catalog I want to select from product: name, price, created(date), updated(date) and first_name, last_name from employee...

Hello, I have a DOMAIN LastUpdateUser and I want to use it in all the tables of the database. I want also to create a trigger which will fulfill this domain with the user name. Is it possible to do it on Domain instead of the table? Thanks

Hi, I used ./configure --with-odbc --enable-pthreads and try to configure psqlodbc in solaris x86. But it exits with an error, .. .. .. checking whether time.h and sys/time.h may both be included... yes checking for long... yes

I have a tablespace that is not being used and I want to drop it. When I try to drop the tablespace either via pgAdmin III or an sql command I get the following error: cannot read directory "pg_tblspc/20612": No such file or directory I have tired to manually create those directories in the location listed as the target folder for the...

Hello, I try to use the srf API and I have a link error. When I did : FuncCallContext *funcctx; ... if (SRF_IS_FIRSTCALL()){ funcctx = SRF_FIRSTCALL_INIT(); // If I remove this line, no link error ... }

Hi The Scripts Team, Is there any scripts or commands for installing a postgres db on a windows machine. For anyone who knows, thanks as always.