PostgreSQL Database Forum

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?

i have database test, how import 'test' in another database?only schema?

any body of u know how to start stop postgres through build.xml.

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...

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

For example: main String==> "FirstSecondThird" from the above string I need "Third" only. Can any help Pls.........

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...

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...

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???

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...

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?

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-----'

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...

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...

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

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..

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...

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,

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 ( ...

How do i cleanly remove replication between primary and standby database in a hotstandby setup for psql 9.2? Please advice.

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...

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?

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:...

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

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 ...