| |
thread by: jilstjoseph |
last post Aug 21 '14 by: jilstjoseph
I am trying to start Postgresql 8.2.13 in Windows Server 2008 machine but is not starting..Service is getting timed out..
No specific error in the Aplication log in event viwer..
It was previusly running .. But after a server restart this was happening..
Is there any way I can recover the data?
The pg_log says
2014-08-21 17:13:30...
|
thread by: aritchie |
last post Sep 3 '14 by: aritchie
I am running a SQL Script called from a batch file to build a temp database from a flat file.
It works when the flat is on the C: drive but not on a net work drive
I get this error:
ERROR: could not open file "\\ESSOMAFPS5\Pollbook\Data\STREET_DATA.txt" for reading: Invalid argument
Here is the copy statement... I am using the \\ UNC...
|
thread by: ce2100 |
last post Sep 24 '14 by: Rabbit
I have a table with 12 million records. There are indexes on columns col_1 and col_2. I use postgresql 9.3.
I need two types of queries on it. First, some queries with just one condition in where clause, such as:
select count(*)
from table_1
where
col_1 >= 123456;
**explain analyze:**
|
thread by: beckjoh |
last post Sep 26 '14 by: Rabbit
I have a Postgresql table with the following structure:
id | value
----+--------
1 | 1
2 | 2
3 | 3
4 | 4
5 | 1
6 | 2
|
thread by: beckjoh |
last post Sep 27 '14 by: Rabbit
I have a simple table with a primary id column called id.
I have a need to ALTER the table and delete the primary id column. When I do the first 6 rows are reordered to the bottom of the table. I do not want them to be reordered. Any thoughts? Thanks in advance.
|
thread by: Helveticus |
last post Oct 18 '14 by: Helveticus
Hi
I'm using postgreSQL 9.3 and I have the following two types of stored procedures (only the statements given):
INSERT INTO table1 (col1, col2, col3, col4, col5)
SELECT $1, $2, $3, $4, $5
WHERE EXISTS (SELECT id FROM table2 q WHERE q.id = $1) RETURNING table1.id;
DELETE FROM table1 m WHERE m.id = (
SELECT m.id FROM table1 m
|
thread by: Fragus |
last post Oct 26 '14 by: Fragus
Trying to import postgresql file around 8GB using pg_restore but it's outputting an error message:
pg_restore -d testdb -U postgres -C helium-20141009.sql
pg_restore: input file does not appear to be a valid archive
|
| |
thread by: sdlan |
last post Nov 3 '14 by: sdlan
Hi Guys,
I am new to Database and Postgresql.
I created an ERD diagram to store information on students, parents, teachers and schools, part of my design instead of having address for each entity I create a new entity called address and contains a composite primary key from (studentID, partentID, techerID, schoolID), streetName, suburb,...
|
thread by: gcoder |
last post Nov 18 '14 by: gcoder
i have followed this link
http://www.postgresonline.com/journal/index.php?url=archives/165-Encrypting-data-with-pgcrypto.html&serendipity=moderate#feedback
to perform two way encryption, but i am getting the following error while inserting :
ERROR : Corrupt ascii-armor
please help me to solve this error.
|
thread by: hamidsultan |
last post Dec 23 '14 by: hamidsultan
Hi,
Following is my code that does some initial accounts creation in bulk for some purpose.
After creating about 52 accounts it gives the following error:
org.postgresql.util.PSQLException: FATAL: sorry, too many clients already
Unless I am overlooking something , I open only one database connections, making 3 SQL Statatements, 3...
|
thread by: roghellman |
last post Jan 31 '15 by: roghellman
Simply put, I have been storing json data in bytea's with the data encrypted.
Now, I would like to take advantage of 9.3's ability to have json indexes, but presume that encryption / indexes simply won't work. If anyone knows how to do this, or can confirm that it can't be done, then please advise.
|
thread by: mlike |
last post Feb 11 '15 by: mlike
Hello,
I have installed postgresql on Linux on a virtual box on my wintel machine.
I am unable to get a connection from pgadmin to the DB.
I have modified these two files to allow remote connections to DB, then restarted the postgresql service:
postgresql.conf
added line:
listen_addresses = '*'
|
thread by: oweniit |
last post Feb 17 '15 by: oweniit
HI Guys
I need a big help from you guys. I need to install postgresql cluster on Suse Linux 11 SP1. I have found links about cluster installing on CentOS but not in Suse Linux. Can you please let me know a way or a link about installing Postgresql on Suse Linux.
|
thread by: mahesh89 |
last post Feb 28 '15 by: Luuk
I just want to ask if you can upload binary files (ex. jpg, doc files) to the postgreSQL server through PHP? If so, how must this be done? Just a link on any tutorial will do. Thanks!
|
thread by: scubak1w1 |
last post May 6 '15 by: CallMeSpike
Hello,
Did a search here, manuals and Googled, etc generally, so apologies if I did not find the answer to my issue - that is, I try and 'self help' as mush as I can...
I adjusted my postgresql.conf file to set as on 'explain_pretty_print'
Now in pgAdmin (1.10.0) when I right-click a database in the 'usual' way, Maintenance, any of the...
|
| |
thread by: Rajuganesh |
last post May 22 '15 by: Rajuganesh
1) i'm new to postgresql. i have one package in oracle, now i need to create that package in postgresql.please give me the alternative for the packages in postgresql.
2) how to execute the procedures automatically in postgresql. like we have a package in oracle dbms_job.submit.
please help me..
thanks in advance
|
thread by: Muskie77 |
last post Jun 15 '15 by: Muskie77
I am struggling to write a pl/sql function that encompasses the two below queries. Right now, the function executes, but when called it isn't returning anything....
It looks like I *might* be running into some trouble with passing $1 in a set returning function (i.e ST_Dump or generate_series...). It fails like this on a Multipolygon feature:
...
|
thread by: Ashraf Ali |
last post Jul 2 '15 by: Rabbit
How to find duplicate points(poi) in an area by creating a radius for each points and compared with another points which resides in the radius, for every points it has to be follow the same method?
|
thread by: johnigneel |
last post Jul 16 '15 by: johnigneel
I have been researching for days about the diff. between pltcl and plpgsql language in postgresql to solve my problem.
I have created a trigger function in 'pltcl' language but now I am trying to convert this in 'plpgsql' language. Any idea on how to convert this piece of trigger function code to plpgsql function? Thanks
CREATE OR REPLACE...
|
thread by: vervia |
last post Jul 29 '15 by: vervia
HI,
I am developing a program for windows ce device using c#.
The existing database is Postgresql. Is it possible to connect Postgresql to my windows ce program? If yes, how?
Looking forward for your immediate response.
Thank you.
|
thread by: huumzz |
last post Aug 12 '15 by: Rabbit
CREATE OR REPLACE VIEW vwstmACC AS
SELECT DISTINCT ON (stmnt.chargeservicelineid) stmnt.created, stmnt.createdby, stmnt.lastupdated, stmnt.updatedby, stmnt.accountid, stmnt.practiceid, stmnt.chargegroupid, stmnt.chargeservicelineid, stmnt.patientid, stmnt.paymentpostingid, stmnt.chargeadjustmentid, stmnt.locationid, stmnt.specialityid,...
|
thread by: chrchcol |
last post Aug 17 '15 by: chrchcol
I keep getting this error within my application
duplicate key value violates unique constraint "product_supplierinfo_pkey" DETAIL: Key (id)=(409) already exists.
The actual next sequence number the key constraint needs to be is 5461 not 409.
It is a postgreSQL table called product_supplierinfo and it has a constraint called...
|
thread by: krithikas |
last post Aug 22 '15 by: anvesh
Hello,
We have two postgres databases running in the same server. Now we have to write a trigger in one database to access a table in another database for live data updation in both databases. How can we perform that?
Can we use contrib/dblink? If we yes how to do that? Our postgres version is 7.4.7. And the function dblink does not...
|
| |
thread by: sbgraman |
last post Sep 5 '15 by: Luuk
We need to fetch multiple records from a table using select POSTGRESQL SQL query and need to highlight the record(row) with red or green color based on a condition. Is the above requirement is feasible. Please help us to achieve this task.
|
thread by: ganesank31 |
last post Sep 10 '15 by: ganesank31
I have Oracle query which needs to be converted into postgresql .
In oracle query i have NLS_DATE_LANGUAGE='Italy' parameter set.
What is the equivalent code to read the italy date values in postgresql.
|