On 28 Jun 2012, at 5:11, Tim Uckun wrote:
I am sure this is intended behavior but it seems odd (and inconvenient) to me.
create database tim_test_copy template tim_test
ERROR: source database tim_test is being accessed by other users
DETAIL: There are 1 other session(s) using the
I am building a new server with a separate partition for data and
xlogs. What is the correct way to do this?
Can I create a symlink from /var/lib/pgsql/9.1/data - /pg_data (and
then a symlink in /pgdata for xlogs- /pg_xlog)
Or do I have to modify $PGDATA in the init script?
This is all after
Paul McGarry wrote:
I have a situation where I'd like to lower the
log_min_duration_statement for a particular connection
.
The DB is used for several reporting type queries which may reasonably
take several seconds so the log_min_duration_statement in the DB is
set accordingly.
However
On Thu, Jun 28, 2012 at 1:20 PM, Ben Carbery ben.carb...@gmail.com wrote:
I am building a new server with a separate partition for data and
xlogs. What is the correct way to do this?
Can I create a symlink from /var/lib/pgsql/9.1/data - /pg_data (and
then a symlink in /pgdata for xlogs-
Hello,
Is it possible to find out the (list of) function oids from a function
call?
e.g. select MYFUNC('foo', 1234)
= someting like
select * from get_function_oids($$MYFUNC('foo', 1234)$$)
best regards,
Marc Mamin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
Hi,
I have to create a script which imports csv data into postgresql ...and have a
few questions about the best way to do it.
The csv data is automatically created from an external database so I have no
influence over which columns etc are downloaded.
The csv comes without an fid field and
On 28/06/2012 12:53, Robert Buckley wrote:
Hi,
I have to create a script which imports csv data into postgresql ...and
have a few questions about the best way to do it.
The csv data is automatically created from an external database so I
have no influence over which columns etc are
From: pgsql-general-ow...@postgresql.org On Behalf Of Robert Buckley
Sent: Donnerstag, 28. Juni 2012 13:53
To: pgsql-general@postgresql.org
Subject: [GENERAL] create a script which imports csv data
Hi,
I have to create a script which imports csv data into postgresql
...and have a
Robert Buckley wrote:
I have to create a script which imports csv data into postgresql
The csv data is automatically created from an external database
so I have no influence over which columns etc are downloaded.
How can I best create a table for the import?
This is what I do:
1) I have a
Hello
I am using PostgreSQL 9.0.6 64 bit on Windows 2003 64bit.
When i view Postgresql status, there are some autovaccum alway run.
Ex VACUUM ANALYZE pg_catalog.pg_attribute.
Is it problem of PostgreSQL? Please help me.
Tuan Hoang Anh.
-Original Message-
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
It'd be really interesting to relax that limitation to ... other
non-read-only transaction ... and have a database that's being cloned
block or reject
DML, UPDATE, etc. There are some issues with that
I've read that postgres uses MVCC for transactions, and that it creates
snapshots of the database for each transaction. Couldn't the create
database command just use that snapshot?
Database creation cannot be done inside a transaction (one of the few
DDL statements that can't), so no.
--
If
On Thu, Jun 28, 2012 at 2:12 PM, Berend Tober bto...@broadstripe.net wrote:
Robert Buckley wrote:
I have to create a script which imports csv data into postgresql
The csv data is automatically created from an external database
so I have no influence over which columns etc are downloaded.
Thanks too... :)
--Raghav
On Thu, Jun 28, 2012 at 4:52 PM, Ben Carbery ben.carb...@gmail.com wrote:
Too easy, thanks.
On 28 June 2012 18:38, Raghavendra raghavendra@enterprisedb.com
wrote:
On Thu, Jun 28, 2012 at 1:20 PM, Ben Carbery ben.carb...@gmail.com
wrote:
I am building a
Alban Hertroys haram...@gmail.com writes:
I've read that postgres uses MVCC for transactions, and that it creates
snapshots of the database for each transaction. Couldn't the create
database command just use that snapshot?
Database creation cannot be done inside a transaction (one of the few
Hi,
When I was restoring a dump on 9.1.4 (created on 9.0.7) I got this error:
ERROR: function
imported_credentials_generalized_external_id(imported_email3) does not
exist
LINE 1: ...ed_external_i_idx ON imported_email3 USING btree (imported_c...
Sergey Konoplev sergey.konop...@postgresql-consulting.com writes:
When I was restoring a dump on 9.1.4 (created on 9.0.7) I got this error:
ERROR: function
imported_credentials_generalized_external_id(imported_email3) does not exist
Yeah. Here's a more complete example on HEAD:
On Thu, Jun 28, 2012 at 8:59 PM, Tom Lane t...@sss.pgh.pa.us wrote:
A potential workaround is illustrated by:
regression=# create index foobari on foobar (foosum(row(foobar.*)::foo));
CREATE INDEX
regression=# \d foobari
Index public.foobari
Column | Type | Definition
On Thu, 2012-06-28 at 21:41 +0700, tuanhoanganh wrote:
Hello
I am using PostgreSQL 9.0.6 64 bit on Windows 2003 64bit.
When i view Postgresql status, there are some autovaccum alway run.
Ex VACUUM ANALYZE pg_catalog.pg_attribute.
Is it problem of PostgreSQL? Please help me.
Do you have
On 06/28/2012 07:53 PM, Robert Buckley wrote:
Hi,
I have to create a script which imports csv data into postgresql
...and have a few questions about the best way to do it.
The advice already given is pretty good. Remember you can always create
a clean new table then INSERT INTO ... SELECT
20 matches
Mail list logo