--- On Thu, 7/7/11, Craig Ringer cr...@postnewspapers.com.au wrote:
From: Craig Ringer cr...@postnewspapers.com.au
Subject: Re: [GENERAL] Oracle to Postgres migration open source tool
To: akp geek akpg...@gmail.com
Cc: pgsql-general pgsql-general@postgresql.org
Date: Thursday, July 7, 2011, 2:02
--- On Wed, 10/27/10, Vick Khera vi...@khera.org wrote:
From: Vick Khera vi...@khera.org
Subject: Re: [GENERAL] How to merge data from two separate databases into one
(maybe using xlogs)?
To: pgsql-general pgsql-general@postgresql.org
Date: Wednesday, October 27, 2010, 8:26 PM
On Wed, Oct 27,
--- On Thu, 10/21/10, Reid Thompson reid.thomp...@ateb.com wrote:
From: Reid Thompson reid.thomp...@ateb.com
Subject: Re: [GENERAL] Cannot Start Postgres After System Boot
To: Rich Shepard rshep...@appl-ecosys.com
Cc: pgsql-general@postgresql.org
Date: Thursday, October 21, 2010, 4:28 AM
On
--- On Thu, 9/30/10, Vincenzo Romano vincenzo.rom...@notorand.it wrote:
From: Vincenzo Romano vincenzo.rom...@notorand.it
Subject: [GENERAL] [9.0] On temporary tables
To: PostgreSQL General pgsql-general@postgresql.org
Date: Thursday, September 30, 2010, 11:09 AM
Hi all.
This is my case:
--
- On Wed, 9/2/09, August Lilleaas augustlille...@gmail.com wrote:
From: August Lilleaas augustlille...@gmail.com
Subject: [GENERAL] Ungooglable error message when running initdb: Symbol not
found: _check_encoding_conversion_args
To: pgsql-general@postgresql.org
Date: Wednesday, September 2,
/pgsql-general
IMHO you have to use pgpool to handle many connections
Lennin Caro Pérez
Usuario:GNU/LINUX
PHP Developer
PostgreSQL DBA
Oracle DBA
Linux counter id 474393
--- On Thu, 7/2/09, Brandon Metcalf bran...@geronimoalloys.com wrote:
From: Brandon Metcalf bran...@geronimoalloys.com
Subject: [GENERAL] simulate multiple primary keys
To: pgsql-general@postgresql.org
Date: Thursday, July 2, 2009, 5:27 PM
I have the following table:
gms= \d jobclock
--- On Mon, 6/29/09, Tguru g...@talend.com wrote:
From: Tguru g...@talend.com
Subject: Re: [GENERAL] Switching from MySQL: ON DUPLICATE KEY UPDATE, plpgsql
function
To: pgsql-general@postgresql.org
Date: Monday, June 29, 2009, 1:33 PM
To migrate the site, you can use an open source
--- On Thu, 6/18/09, David Shen davidshe...@googlemail.com wrote:
From: David Shen davidshe...@googlemail.com
Subject: [GENERAL] connecting to a remote pq always require a password
To: pgsql-general@postgresql.org
Date: Thursday, June 18, 2009, 12:11 PM
Hi,
I am trying to use the libpq
--- On Wed, 2/25/09, Bill Herbert wgh8...@earthlink.net wrote:
From: Bill Herbert wgh8...@earthlink.net
Subject: [GENERAL] Problem setting up PostgreSQL
To: pgsql-general@postgresql.org pgsql-general@postgresql.org
Date: Wednesday, February 25, 2009, 4:30 AM
Hello,
I am attempting to
This is my first attempt at using libpq, and I'm running
across a strange
problem. Here is my bare-bones program:
#include stdio.h
#include libpq-fe.h
int main(int argc, char **argv) {
PGconn *conn;
fprintf(stderr, connecting\n);
conn = PQconnectdb(dbname=postgres);
I have simple question
I tried following code
select right(column, number_of_character) from table
but it didn't work, saying that pg doesn't have the
function
is there any way to achieve such output?
honestly I have no idea that such simple feature
doesn't exist in postgresql
or
--- On Sat, 2/14/09, Bob Pawley rjpaw...@shaw.ca wrote:
From: Bob Pawley rjpaw...@shaw.ca
Subject: Re: [GENERAL] pg_hba reload
To: John R Pierce pie...@hogranch.com, PostgreSQL
pgsql-general@postgresql.org
Date: Saturday, February 14, 2009, 11:31 PM
I'm running 8.3 on Windows XP.
I
--- On Wed, 1/14/09, Louis-David Mitterrand
vindex+lists-pgsql-gene...@apartia.org wrote:
From: Louis-David Mitterrand vindex+lists-pgsql-gene...@apartia.org
Subject: Re: [GENERAL] inconsistency in aliasing
To: pgsql-general@postgresql.org
Date: Wednesday, January 14, 2009, 11:27 AM
On Wed,
I have two cuestion:
1- postgresql have the method to allocate a table in memory
2- In postgresql can have multiple port to listen
thank...
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
From: Gustavo Rosso [EMAIL PROTECTED]
Subject: [GENERAL] ERROR
To: pgsql-general@postgresql.org
Date: Monday, November 17, 2008, 3:08 PM
I create a db wiht user postgres, but other users can't
no create tables, and I give all privileges.
(banco is my db)
grant all on database banco to
Hi all,
I'm re-writing some functions and migrating bussines
logic from a
client application to PostgreSQL.
I expected something like this to work, but it doesn't:
-- simple table
CREATE TABLE sometable (
id SERIAL PRIMARY KEY,
text1 text,
text2 text
);
CREATE OR
--- On Mon, 10/20/08, pere roca [EMAIL PROTECTED] wrote:
From: pere roca [EMAIL PROTECTED]
Subject: re[GENERAL] moving a portion of text
To: pgsql-general@postgresql.org
Date: Monday, October 20, 2008, 11:21 AM
hi,
I have a column with full of data like ATB-OO NCK-TT
how can I
--- On Tue, 9/30/08, r_musta [EMAIL PROTECTED] wrote:
From: r_musta [EMAIL PROTECTED]
Subject: Re: [GENERAL] Counting unique rows as an aggregate.
To: pgsql-general@postgresql.org
Date: Tuesday, September 30, 2008, 6:55 AM
On Sep 30, 2:36 am, [EMAIL PROTECTED] (Tom Lane) wrote:
SELECT
--- On Tue, 9/23/08, William Garrison [EMAIL PROTECTED] wrote:
From: William Garrison [EMAIL PROTECTED]
Subject: [GENERAL] Error in ALTER DATABASE command
To: Postgres General List pgsql-general@postgresql.org
Date: Tuesday, September 23, 2008, 3:49 PM
In Postgresql 8.2.9 on Windows, you
--- On Fri, 9/19/08, Yi Zhao [EMAIL PROTECTED] wrote:
From: Yi Zhao [EMAIL PROTECTED]
Subject: [GENERAL] how to return the first record from the sorted records
which may have duplicated value.
To: pgsql-general pgsql-general@postgresql.org
Date: Friday, September 19, 2008, 8:51 AM
hi
--- On Tue, 9/9/08, Markova, Nina [EMAIL PROTECTED] wrote:
From: Markova, Nina [EMAIL PROTECTED]
Subject: [GENERAL] 3 postgres processes
To: pgsql-general@postgresql.org
Date: Tuesday, September 9, 2008, 2:50 PM
Hi,
After issuning initdb and starting the postgres server, I
checked for
--- On Wed, 9/3/08, Akhtar Yasmin-B05532 [EMAIL PROTECTED] wrote:
From: Akhtar Yasmin-B05532 [EMAIL PROTECTED]
Subject: Re: [GENERAL] Postgres does not start, gives no error
To: Tom Lane [EMAIL PROTECTED]
Cc: Joshua Drake [EMAIL PROTECTED], pgsql-general@postgresql.org
Date: Wednesday,
--- On Wed, 9/3/08, Akhtar Yasmin-B05532 [EMAIL PROTECTED] wrote:
From: Akhtar Yasmin-B05532 [EMAIL PROTECTED]
Subject: [GENERAL] Postgres does not start, gives no error
To: pgsql-general@postgresql.org
Date: Wednesday, September 3, 2008, 7:11 PM
HI,
I am facing this peciliar
--- On Thu, 8/28/08, Masis, Alexander (US SSA) [EMAIL PROTECTED] wrote:
From: Masis, Alexander (US SSA) [EMAIL PROTECTED]
Subject: [GENERAL] MySQL LAST_INSERT_ID() to Postgres
To: pgsql-general@postgresql.org
Date: Thursday, August 28, 2008, 4:14 PM
I was mapping C++ application code that
--- On Tue, 8/26/08, Richard Broersma [EMAIL PROTECTED] wrote:
From: Richard Broersma [EMAIL PROTECTED]
Subject: [GENERAL] PITR - base backup question
To: pgsql-general@postgresql.org pgsql-general@postgresql.org, [EMAIL
PROTECTED]
Date: Tuesday, August 26, 2008, 10:53 PM
From the
--- On Tue, 8/19/08, Masis, Alexander (US SSA) [EMAIL PROTECTED] wrote:
From: Masis, Alexander (US SSA) [EMAIL PROTECTED]
Subject: [GENERAL] schema name in SQL statement.
To: pgsql-general@postgresql.org
Date: Tuesday, August 19, 2008, 10:52 PM
I have to explicitly specify the schema name
you can use a cron job
--- On Tue, 8/12/08, Joao Ferreira gmail [EMAIL PROTECTED] wrote:
From: Joao Ferreira gmail [EMAIL PROTECTED]
Subject: [GENERAL] automatic REINDEX-ing
To: pgsql-general pgsql-general@postgresql.org
Date: Tuesday, August 12, 2008, 3:13 PM
Hello all
[[[ while
use the double quotes ()
ALTER USER foo-bar WITH ENCRYPTED PASSWORD 'foo-bar'
--- On Fri, 8/8/08, Tom Copeland [EMAIL PROTECTED] wrote:
From: Tom Copeland [EMAIL PROTECTED]
Subject: [GENERAL] ALTER ROLE role-name-with-hyphen
To: pgsql-general@postgresql.org
Date: Friday, August 8, 2008,
try whit this
http://www.postgresql.org/docs/8.3/interactive/ecpg-dynamic.html
--- On Thu, 8/7/08, Anderson dos Santos Donda [EMAIL PROTECTED] wrote:
From: Anderson dos Santos Donda [EMAIL PROTECTED]
Subject: [GENERAL] Create Table Dinamic
To: pgsql-general@postgresql.org
Date: Thursday,
what error show the log file?
--- On Mon, 8/4/08, Greg Smith [EMAIL PROTECTED] wrote:
From: Greg Smith [EMAIL PROTECTED]
Subject: Re: [GENERAL] recovery via base + WAL replay failure
To: Rob Adams [EMAIL PROTECTED]
Cc: postgres general pgsql-general@postgresql.org
Date: Monday, August 4,
] eliminating records not in (select id ... so SLOW?
To:
Cc: PostgreSQL pgsql-general@postgresql.org
Date: Thursday, July 31, 2008, 11:01 PM
On Thu, 31 Jul 2008 14:59:29 -0700 (PDT)
Lennin Caro [EMAIL PROTECTED] wrote:
The box is a 2x dual core Xeon (below 2GHz) with
4Gb ram.
Default
--- On Thu, 7/31/08, Warren Bell [EMAIL PROTECTED] wrote:
From: Warren Bell [EMAIL PROTECTED]
Subject: [GENERAL] CAST(integer_field AS character) truncates trailing zeros
To: pgsql-general@postgresql.org
Date: Thursday, July 31, 2008, 8:03 PM
I am trying to cast an int to a character. The
--- On Thu, 7/31/08, Ivan Sergio Borgonovo [EMAIL PROTECTED] wrote:
From: Ivan Sergio Borgonovo [EMAIL PROTECTED]
Subject: [GENERAL] eliminating records not in (select id ... so SLOW?
To: PostgreSQL pgsql-general@postgresql.org
Date: Thursday, July 31, 2008, 9:45 PM
I'm doing something
you can use slony-i
http://slony.info/
--- On Mon, 7/28/08, Garg, Manjit [EMAIL PROTECTED] wrote:
From: Garg, Manjit [EMAIL PROTECTED]
Subject: [GENERAL] Clone a database to other machine
To: pgsql-general@postgresql.org
Date: Monday, July 28, 2008, 4:44 PM
Hi All,
I'm stuck to an
--- On Fri, 7/18/08, Glyn Astill [EMAIL PROTECTED] wrote:
From: Glyn Astill [EMAIL PROTECTED]
Subject: [GENERAL] Initdb problem on debian mips cobalt: Bus error
To: pgsql-general@postgresql.org
Date: Friday, July 18, 2008, 10:26 AM
Hi Chaps,
I'm attempting to run 8.3.3 on an old cobalt
in this link have information about database size
http://www.postgresql.org/docs/8.1/static/functions-admin.html#FUNCTIONS-ADMIN-DBSIZE
--- On Thu, 7/10/08, aravind chandu [EMAIL PROTECTED] wrote:
From: aravind chandu [EMAIL PROTECTED]
Subject: [GENERAL] SPACE FOR POSTGRESQL DATABASE
To:
sound like you have a postmaster.pid in your PGDATA directory. Rename file
postmaster.pid and launch the postgresql again
--- On Sat, 7/5/08, Scott Frankel [EMAIL PROTECTED] wrote:
From: Scott Frankel [EMAIL PROTECTED]
Subject: [GENERAL] roll back to 8.1 for PyQt driver work-around
To:
for hot_backup and restore check this
http://www.postgresql.org/docs/8.3/static/continuous-archiving.html
for logic backup (dump) use this
http://www.postgresql.org/docs/8.3/static/app-pgdump.html
--- On Mon, 7/7/08, aravind chandu [EMAIL PROTECTED] wrote:
From: aravind chandu [EMAIL
--- On Wed, 7/2/08, Gwyneth Morrison [EMAIL PROTECTED] wrote:
From: Gwyneth Morrison [EMAIL PROTECTED]
Subject: Re: [GENERAL] Delete from Join
To: pgsql-general@postgresql.org
Date: Wednesday, July 2, 2008, 7:12 PM
--- On Wed, 7/2/08, Gwyneth Morrison
[EMAIL PROTECTED] wrote:
use...
ps auxw | grep postgres
--- On Wed, 7/2/08, Fernando Dominguez [EMAIL PROTECTED] wrote:
From: Fernando Dominguez [EMAIL PROTECTED]
Subject: [GENERAL] pg_ctl start check sum failed
To: pgsql-general@postgresql.org
Date: Wednesday, July 2, 2008, 11:30 PM
Hello,
I try to use an
--- On Wed, 7/2/08, Gwyneth Morrison [EMAIL PROTECTED] wrote:
From: Gwyneth Morrison [EMAIL PROTECTED]
Subject: [GENERAL] Delete from Join
To: pgsql-general@postgresql.org
Date: Wednesday, July 2, 2008, 3:15 PM
Hello,
Is it possible to use a join keyword in a delete?
For example:
see trigger and estatus
select tgname,tgenabled from pg_catalog.pg_trigger
--- On Mon, 6/30/08, kartik [EMAIL PROTECTED] wrote:
From: kartik [EMAIL PROTECTED]
Subject: [GENERAL] Query
To: pgsql-general@postgresql.org
Date: Monday, June 30, 2008, 9:55 AM
Hello ,
I am a beginner
use REINDEX
http://www.postgresql.org/docs/8.3/static/sql-reindex.html
tell us the result
thank
--- On Fri, 6/27/08, Ganbold [EMAIL PROTECTED] wrote:
From: Ganbold [EMAIL PROTECTED]
Subject: [GENERAL] ERROR: concurrent insert in progress
To: pgsql-general@postgresql.org
Date: Friday, June
use REINDEX
REINDEX ip_dst_idx
OR
REINDEX table_name
http://www.postgresql.org/docs/8.3/static/sql-reindex.html
tell us the result
thank
--- On Fri, 6/27/08, Ganbold [EMAIL PROTECTED] wrote:
From: Ganbold [EMAIL PROTECTED]
Subject: [GENERAL] ERROR: concurrent insert in progress
To:
use a dynamic select in the web page
$1 = 10
$2 = 5
select * from mytable limit $1 OFFSET $2
--- On Fri, 6/27/08, Bill Thoen [EMAIL PROTECTED] wrote:
From: Bill Thoen [EMAIL PROTECTED]
Subject: [GENERAL] Advice Wanted on Selecting Multi-row Data Requests in 10-Row
Blocks
To:
use this
explain analyze select * from result where active = 't';
--- On Thu, 6/26/08, Phillip Mills [EMAIL PROTECTED] wrote:
From: Phillip Mills [EMAIL PROTECTED]
Subject: [GENERAL] Partial Index Too Literal?
To: pgsql-general@postgresql.org
Date: Thursday, June 26, 2008, 7:24 PM
Under
the table o tables have triggers?
try to use COMMIT
--- On Thu, 6/26/08, Robert James [EMAIL PROTECTED] wrote:
From: Robert James [EMAIL PROTECTED]
Subject: [GENERAL] Undocumented Postgres error: failed to fetch old tuple for
AFTER trigger
To: Postgres General pgsql-general@postgresql.org
Date:
48 matches
Mail list logo