PostgreSQL Database Forum

hi, This is the error that we are getting on postgresql. The error is as follows: current transaction is aborted. queries ignored until end of the transaction block. What might be the real cause of the problem and how do we rectify it? Any suggestions will be appreciable.

hello, when i took the dump and tried to restore the dump in postgresql 7.3.4, the functions are not restored, so can anyone suggest me the solution of the above specified problem. The oids are restored but the functions are not restored? Please help me. Ntech

Hi, I'd like to return the output, or output as a variable, from a pgSQL query that I'm executing through batch file back to the batch file so that it executes a line in particular of the batch file (through a 'goto' command I think). I manage to execute the query and see the result (in cmd) but am not sure how I can grab that result and...

Hello, I'm brand new to postgreSQL (I'm running v 7.4) and am working on porting a simple mySQL db to postgres, but I'm a unique (uniquely obnoxious) situation: I'm not the one who installed postgresSQL on the server I'm working on, but the only way its been used in the past is via some GUI tool that does the heavy lifting for specific GIS...

hi, i have postgresql 8.1 and it was running very well but to store another database i copied the data folder of another database to C:\Program Files\PostgreSQL\8.1\ on my system then started service but as soon as i type the password to connect to the postgre,its showes a window named Server not listing, in which following messages is...

Hi all, for troubleshooting purpose, I would like to add to all my tables (and for all records) the creation and modification timestamp fields. Do you know if this is a common practice ? Do you know if those dates are usually handled by triggers ? Any concern about database size ? Cheers, ste

if not exists(select * from table ) begin insert into table(tabname,colname,chnname) select ''','' end

Hi Friends, when I have convert the float4 data type to float8 data type it was lossing the value. The following are the commands i Have used. Plaese go through it. (1) TE TABLE tab1(id int PRIMARY KEY,val float4); (2) INSERT INTO tab1 VALUES(1,1.1); INSERT INTO tab1 VALUES(2,1.2); INSERT INTO tab1 VALUES(3,1.3);

Can anybody help me with such problem: I need to get all columns names which have foreign key constraint. For example: I have table my_table with column my_column, and this column have foreign key constraint. What sql code will return me the name of this column if I know the name of it's foreign key constraint. In constraint_column_usage table...

hai expert iam woking in birlasoft (chennai),i want to know that whether there is any good training center in chennai please tell me

Hello – I’m trying to findout a better solution to this approach. Currently if I have to return columns from multiple tables, I have to define my own TYPE and then return SETOF that type in the function. I’ve provided an example below. Now, if I have to add a column to the select query, I have drop the existing TYPE definition,...

I am having some problems understanding how the temp tables work in PG. I have a relatively lengthy function I am creating that makes frequent use of temporary tables. I am dropping and recreating the temp tables on each run. If I run the procedure the first time via psql it seems to run fine. If I try to immediately run it again I get the...

Can you use a stored procedure in a subquery in postgres?

The installation of PostgreSQL 8.2 ends with a fatal error, as in the following log file Tha envoronment is: WXP SP2, Apache 2.2, Tomcat 6, PHP 5 Windows domain server As username I choose my login & pwd in the domain. I had tried a previous instalation, and it worked (until I had to reinstall it for other reason). ... Action 14.09.15:...

hello experts, i created a database through linux. the database created is with "Encoding = UTF8". i can't access it through my application. i am using VB 6 and it is connected with odbc. if i created with windows i can change the encoding. can i change the encoding ="UTF8" to enconding = "SQL_ASCII" plz,any help is appreciated

hello, i got a problem while restarting postgresql, i removed postmaste.pid and even the temporary sock file and while restarting postgres, i got the following error: LOG: could not bind IPv6 socket: Address already in use HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry. LOG: could not bind...

Hello, i am facing a problem. I am using postgresql database in Linux. After taking the dump of any postgresql database, when i restore the dump file into a new database, i dont get any oids. so can anyone help me in this issue? Does it happen due to version mismatch? how do i take the dump so that when i restore it, the oids are also available?...

I have to convert this script, but i didn't. This is stored procedure of sql. I need to convert to postgresql... if it is possible please help me! Thanks Fatma CREATE PROCEDURE usp_generatetable(@prm_tableID int, @prm_langID int) as

Hi, I have a function(stored procedure) in the database. I need to pass the table name which is a variable. How do i do that? Example : I have 1st table : table name - cities location | city (text) | (text) --------------------- 1 bangalore 2 mangalore

How to Declare a Column which needs to be incremented by 1 in postgreSQL in DB2 we use COL1 INTEGER AS IDENTITY,

I am not able to create a tablespace in PostgreSQL. what should i mention for Location field. What ever i mention, it gives me error saying Table Space location must be an absolute path. Thanks in Anticipation

Good Day to ALL, Does anyone here know how to convert BYTEA type into TEXT type? Hope to have some help from someone. Thank you in advance.

Hi all, I am having a table and there is a column named id. I have to choose the id and in case if id is null i have set id to '1' otherwise the same id should be displayed. For this i tried the following query but the result is not the proper one which i expect pls help me in this regard select substring(number,2), case when...

I've got a postgres db running on a windows mc. I've set it up to accept remote connections. Can I use psql from another machine (*nix) to connect to it? I've tried this: psql MYDB -U postgres -h 192.168.1.20 but I get the error missing or erroneous pg_hba.conf file which I don't understand. The pg_hba.conf file is a configuration file...

how do i round a value to the nearest integer? im doin that inside a function