| |
thread by: Eriks0381 |
last post Jun 20 '12 by: Rabbit
I have a database that is around 12 million rows. I need to choose 1 million of them randomly and change the value of one of the fields. There is no oids on the table and no serial. Is there any way I can accomplish this without the lengthy 'random()' function?
|
thread by: DASY |
last post Jun 30 '12 by: rski
i have database test,
how import 'test' in another database?only schema?
|
thread by: mohanpriya |
last post Jul 6 '12 by: mohanpriya
any body of u know how to start stop postgres through build.xml.
|
thread by: dhbele |
last post Jul 11 '12 by: dhbele
I have an application which uses Postgres.
The application periodically drop tables and the recreates
them. I have to manage the users privileges
on these tables. I can NOT change anything in the application code. When the application drops and recreates
tables all GRANTS are dropped and I have to recreate
GRANTS from the scratch. Any...
|
thread by: Ayush |
last post Jul 16 '12 by: Rabbit
i wanted to know about the working of an auto complete in text box so that when i enter some value in a text box the related values are choosen from the database and then displayed as suggestion for the user
|
thread by: sivaroyal |
last post Jul 19 '12 by: Rabbit
For example: main String==> "FirstSecondThird"
from the above string I need "Third" only.
Can any help Pls.........
|
thread by: Lubna89 |
last post Aug 5 '12 by: Lubna89
i have installed a software on ubuntu 10.10 that contains postgres inside it, and postgres was automatically installed with software .run file.
now the database directory is inside the /opt directory and every time i try to access it i have the error message:
couldn't change directory to root
psql: couldn't connect to server: no such file...
|
| |
thread by: mangal |
last post Aug 22 '12 by: Leanne84
Hello,
I am creating a web application in which registrations are open as usual. My doubt is, if some one try to create an account by an email-id like 'foo@gmail.com', at same time other user also try to create account by same emailid 'foo@gmail.com', what will happen in this case? I have added a validation to check the duplicate email-id in...
|
thread by: seema17 |
last post Aug 22 '12 by: seema17
i have installed postgre9.1. i have turned on autovacumm but in the logs instead of getting the detail of autovacuum process, i m getting
2012-08-22 18:32:14 ISTDEBUG: autovacuum: processing database "mydb"
2012-08-22 18:32:14 ISTDEBUG: server process (PID 9759) exited with exit code 0
I m not getting what does it mean. can anyone help???
|
thread by: venkatesh2j |
last post Sep 23 '12 by: NeoPa
Hi Guys,
I just made a ODBC connection from MS Access (2007) to PostGre server, however i came across some strange error "Operation must be updateable Query" for an simple Update statement. I have table called Geo it has a column Zone having values North,South,West & East.
Table: Geo
Zone
North
East
West
South
i want to update these...
|
thread by: periwalridhi |
last post Oct 11 '12 by: periwalridhi
How to write query in PostgreSQL to connect to Commnad Prompt?
I want to generate keys in GNUpg in PostgreSQL query itself by calling command prompt.
Are there any predefined functions or procedures for it or do we need to write functions in plpgsql?
|
thread by: periwalridhi |
last post Oct 11 '12 by: periwalridhi
I am using GnuPG software for assymetric encryption in PostgreSQL.
I have done encryption using
->INSERT INTO "test1"("test")
-> VALUES (pgp_pub_encrypt('testing', dearmor('------>BEGIN PGP PUBLIC KEY BLOCK-----
->Version: GnuPG v2.0.17 (MingW32)
->..............
->-----END PGP PUBLIC KEY BLOCK-----'
|
thread by: mangal |
last post Oct 14 '12 by: Rabbit
Hi all .... Im working on search function for an app and have built a pretty decent thing go except one thing.
Im using the ~* to match the incoming keywords against several fields, 4 varchar and one text ...... its working BUT Im getting partial words which isnt exactly what I wanted (neat but not right) lets me explain more.
If im...
|
thread by: arjun417 |
last post Oct 31 '12 by: arjun417
warning: pg_query(): Query failed: ERROR: cannot update a view HINT: You need an unconditional ON UPDATE DO INSTEAD rule. in /home/websites/public_html/uac-dev.itechne.com/public/includes/database.pgsql.inc on line 138.
user warning: query: UPDATE uac_institution_view SET status = '2' WHERE nid = '9950' in...
|
thread by: americanmc |
last post Nov 30 '12 by: americanmc
Hi,
I have a need to create a syntax , so that basing on the current_date, the sql generated will always give me the Last day of the Last Quarter.
I am new to SQL, so need help
thanks.
Ed
|
| |
thread by: smileyammu1 |
last post Dec 4 '12 by: smileyammu1
Dear All,
I have a holiday table and i need to insert all sundays and second saturdays into the table using a stored procedure.There are 4 columns in the table such as holiday_id,holiday_date,updated_on and updated_by.Please guide me.I am a fresher in this field..
|
thread by: prashant2308 |
last post Dec 13 '12 by: prashant2308
Actually I am using WAL files for designing a replication tool and I need to know if there is any method by which we can obtain sql statements executed in particular transaction id (xid)
Here is a block of information which I have from the processing of WAL file in pg_xlog directory
INSERT INTO "16425" ( insert: s/d/r:1663/16384/16425...
|
thread by: lshapsa |
last post Dec 18 '12 by: Rabbit
Hi,
I would like to ask what is the best approach to split and migrate a big table to X smaller tables using PL/pgsql.
Running the following "select * from tab1 where col1=Z into tab2" X times, seems not be efficient. I would like to reduce table scans.
Thanks,
|
thread by: pintul83 |
last post Dec 24 '12 by: pintul83
Hi,
I am facing the below issue on pg_bulkloader.
for better understanding...
I created the below table with index and then loaded data, as the log file shows everything is success but i don't find that amount of record on the loaded table.
see the below exact commands...
CREATE TABLE quovaadm.SATYA_GEOIP
(
...
|
thread by: newpostdba |
last post Jan 9 '13 by: newpostdba
How do i cleanly remove replication between primary and standby database in a hotstandby setup for psql 9.2? Please advice.
|
thread by: jitendrapatil |
last post Jan 31 '13 by: jitendrapatil
I have an application currently running on sql server i want to move it on postgressql server can any one please suggest me any tool support following type of scenario,
i have one master and one slave database if the any way master is crashed then application automatically connect to slave for further operations and after some period of time...
|
thread by: grandsuri |
last post Feb 11 '13 by: grandsuri
Hi,
I found the command "SELECT CONNECTION_ID()" in mysql which returns the connection ID with the server. Is there any equivalent command in PostgreSQL? What is the primary use of it other than server ID?
|
thread by: pathmakumara |
last post Mar 4 '13 by: skosanabv
I added the reference to Npgsql.dll and run the application. it gives this run time error
Could not load file or assembly 'Mono.Security, Version=2.0.0.0, Culture=neutral, PublicKeyToken=0738eb9f132ed756' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT:...
|
| |
thread by: pracheebapate |
last post Mar 18 '13 by: Rabbit
hi everyone,
i am trying to write postgresql query for below scenario:
inputs :
1. alphanumeric string e.g. abcd1234efgh
2. pattern e.g.
3. delimiter e.g - (hyphen)
output : a-bc-d12-34-e-fgh
|
thread by: surk16 |
last post Apr 8 '13 by: surk16
i want to connect a local remote database
select dblink('host=192.168.1.2 dbname=postgres user=postgres password=webgis',' select * from test');
however i am getting a below error message,
ERROR: could not establish connection
DETAIL: FATAL: no pg_hba.conf entry for host "192.168.1.10", user "postgres", database "postgres", SSL off
...
|