On Thu, Nov 18, 2010 at 08:49:12AM +0100, Alban Hertroys wrote:
From the discussion so far it appears to me that
unlogged should probably be split into various gradations
of unlogged. There appear to be a number of popular
use-cases for such tables, with different requirements,
That's
On Thu, Nov 18, 2010 at 10:30:46AM +0100, Karsten Hilbert wrote:
That is why I argued for options:
- alter database dump_unlogged_tables to on/off
default on: better safe than sorry, point the gun but don't pull the
trigger
(I agree, however, that the database metadata isn't
Hello,
PostgreSQL 9.1 is likely to have, as a feature, the ability to create
tables which are unlogged, meaning that they are not added to the
transaction log, and will be truncated (emptied) on database restart.
Such tables are intended for highly volatile, but not very valuable,
data,
DiffKit 0.8.2 introduces support for PostgreSQL
DiffKit is Free and Open Source Software (FOSS).
http://www.diffkit.org
DiffKit is an application, and a framework, for comparing two tables
of data, field-by-field. The tables can come from any of a number of
sources, such as an RDBMS or CSV
Hello,
In an exception block, we can check the error code.
Is there a way to get the message and possibly the detail too ?
ereport(ERROR, \
(errcode(ERRCODE_SQLCLIENT_UNABLE_TO_ESTABLISH_SQLCONNECTION), \
= errmsg(could not establish connection), \
= errdetail(%s, msg)));
Hello
2010/11/18 Marc Mamin m.ma...@intershop.de:
Hello,
In an exception block, we can check the error code.
Is there a way to get the message and possibly the detail too ?
yes, but you need a 8.4 as minimum
http://www.postgresql.org/docs/8.4/interactive/plpgsql-errors-and-messages.html
I have a backup from an 8.2 UTF8 database and I am trying to restore it
into another 8.2 UTF8 database.
I have tried restoring it on the same machine and a different machine. I
don't know how the character got in, but t looks like it has been there
for about a year.
The backup is taken by
On Thursday 18 November 2010 05:37:51 Allan Kamau wrote:
Hi,
I am experiencing the row is too big error (with postgreSQL-9.0.1)
when populating a table having a tsquery and tsvector fields.
Are fields of tsquery and tsvector datatypes affected by this row size
restriction?
Looks like you
Hi all,
I'm having a lot of trouble developing with PostgreSQL on OS X and
I've tracked it down to the way that various client libraries are
compiled and installed. I'll use the ecpg library as an example. With
PostgreSQL 8.4.5 on OS X we have the library libecpg.6.1.dylib and
two symbol
Hi,
I have a table column name is called begin, tried to move it to
postgresql9 from postgresql8.4. the function failed to call
New.begin.
here is a quick test.
CREATE TABLE test(id serial primary key not null, begin timestamp
without time zone not null);
CREATE TABLE test2(id bigint not null,
On 11/18/2010 3:46 AM, Jayadevan M wrote:
Hello,
PostgreSQL 9.1 is likely to have, as a feature, the ability to create
tables which are unlogged, meaning that they are not added to the
transaction log, and will be truncated (emptied) on database restart.
Such tables are intended for highly
Installing from enterprisedb site from msi packages in Windows 2000:
Installing 9.0 latest returns error about missing entry point.
Intalling 8.3 latest does not create db cluster. Running createdb shows
error message that postgres is not running.
How to install postgresql ( 8.1 or above) in
On 2010-11-18 03.57, Ray wrote:
On Nov 17, 8:42 pm, Rayrui.va...@gmail.com wrote:
-- snip ---
figured out. the begin is keyword and need to double quoted.
This is one strong reason why you should avoid using keywords as object
names. Better to fix that early in the design since names
On Wed, Nov 17, 2010 at 2:55 PM, t...@fuzzy.cz wrote:
What's wrong with these docs?
http://www.postgresql.org/docs/9/static/catalogs.html
It's about different tables and or views
(Tom Lane):
Or, more to the point, these docs:
Lloyd Parkes ll...@must-have-coffee.gen.nz writes:
I'm having a lot of trouble developing with PostgreSQL on OS X and
I've tracked it down to the way that various client libraries are
compiled and installed. I'll use the ecpg library as an example. With
PostgreSQL 8.4.5 on OS X we have
Allan Kamau kamaual...@gmail.com writes:
CREATE TABLE farm.produce
(id INTEGER NOT NULL DEFAULT NEXTVAL('farm.produce_seq')
,process___id TEXT NOT NULL
,item_names tsvector NULL
,product__ids__tsquery tsquery NULL
,product__ids__tsvector tsvector NULL
,population_time TIMESTAMP NOT NULL
On Nov 18, 2010, at 8:22 AM, Tom Lane wrote:
AFAICT, the way this works on OS X is that
(1) At the time of shared library build, you specify its eventual
install location with -install_name /full/path/and/filename.
(2) When an executable is linked against such a library, the
install_name
On 2010-11-17 15.09, Tony Caduto wrote:
On 11/15/2010 5:53 PM, Lee Hachadoorian wrote:
If anyone's interested, I've started accessing the postgres list through
gmane.org (along with several other mailing lists I subscribe to). It's
gives you the choice of reading the list as a threaded
On 17 November 2010 14:09, Tony Caduto tony_cad...@amsoftwaredesign.com wrote:
On 11/15/2010 5:53 PM, Lee Hachadoorian wrote:
If anyone's interested, I've started accessing the postgres list through
gmane.org (along with several other mailing lists I subscribe to). It's
gives you the choice
On 11/17/10 6:09 AM, Tony Caduto wrote:
The mailing lists etc are fine, but they are kind of old school,
people coming from other databases
expect a web based forum plain and simple. To attract more users the
forums are a GREAT idea.
gee, we should have a Facebook wall and a Twitter feed
Does that sum it up adequately?
One more thing: that you might not get all of these options in 9.1.
Currently the discussion is talking about *maybe* offering checkpointing
of unlogged tables, which would allow such tables to survive a normal
restart, and including unlogged tables in
On Thu, Nov 18, 2010 at 6:28 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Allan Kamau kamaual...@gmail.com writes:
CREATE TABLE farm.produce
(id INTEGER NOT NULL DEFAULT NEXTVAL('farm.produce_seq')
,process___id TEXT NOT NULL
,item_names tsvector NULL
,product__ids__tsquery tsquery NULL
John R Pierce wrote:
gee, we should have a Facebook wall
As if there wasn't one already :)
http://www.facebook.com/#!/group.php?gid=2324323985v=wall
and a Twitter feed too
http://twitter.com/postgresql
Best regards,
--
Daniel
PostgreSQL-powered mail user agent and storage:
hi all,
I've just read that pgadmin team was hired by some company and the
project will be closed... It was a post from 2009.
I'm just curious what's the story behind that. Did anyone leave?
thanks.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
On Thu, 2010-11-18 at 16:18 -0500, andrew wrote:
hi all,
I've just read that pgadmin team was hired by some company and the
project will be closed... It was a post from 2009.
I'm just curious what's the story behind that. Did anyone leave?
thanks.
What are you talking about? Source
On Thu, 2010-11-18 at 16:18 -0500, andrew wrote:
I've just read that pgadmin team was hired by some company and the
project will be closed... It was a post from 2009.
...and that post was published at Apr 1, 2009 ;)
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified
On Nov 18, 2010, at 1:31 PM, Joshua D. Drake j...@commandprompt.com wrote:
On Thu, 2010-11-18 at 16:18 -0500, andrew wrote:
hi all,
I've just read that pgadmin team was hired by some company and the
project will be closed... It was a post from 2009.
I'm just curious what's the story behind
andrew and...@mytrashmail.com writes:
hi all,
I've just read that pgadmin team was hired by some company and the
project will be closed... It was a post from 2009.
I'm just curious what's the story behind that. Did anyone leave?
thanks.
Are you thinking about this announcement?
Chris Browne wrote:
andrew and...@mytrashmail.com writes:
hi all,
I've just read that pgadmin team was hired by some company and the
project will be closed... It was a post from 2009.
I'm just curious what's the story behind that. Did anyone leave?
thanks.
Are you thinking about this
Hi,
I have designed a handful databases but is absolutely no SQL-expert. Nor
have I had any formal database training and have never worked with
someone who had. What I know about SQL I have read in the documentation,
found with google, and learned from my numerous mistakes.
This question I
On 11/18/10 2:56 PM, Fredric Fredricson wrote:
What puzzle me though is that this use is never mentioned in the
discussions, at least as far as I can see. Am I doing something
strange? Is this something you should not have to do if you have
proper database design?
in certain other
Hello,
(I googled and read docs before sending this e-mail).
Is it necessary to use order by twice (inside and outside) to get the
proper order if I have an ordered subqery in a join?
select * from (select distinct on (b_id) * from a order by b_id, id) sub
left join b on b.id =
On 19 November 2010 01:36, Mage m...@mage.hu wrote:
Hello,
(I googled and read docs before sending this e-mail).
Is it necessary to use order by twice (inside and outside) to get the proper
order if I have an ordered subqery in a join?
select * from (select distinct on (b_id) *
Hi,
One doubt - if the tables are 'unlogged' , will the DMLs against these
still be replicated to a slave?
Yes, because the system tables, which store the layout of all tables, is
written to WAL.
Thank you for the reply. But my doubt was not about layout, rather the
DMLs. If I do an
Hello everyone,
we're collecting snapshots of the statistics (pg_stat, pg_statio etc.)
regularly so that we can analyze the performance, detect trends etc.
We need to identify whether the stats were reset between the snapshots,
because then the collected data are useless (and the scripts that do
Installing any of 9.0 or 8.3 what exact error you get? Can you attach the
installation log file (%TEMP%\install-postgresql.log)?
On Nov 18, 2010, at 8:19 PM, Andrus wrote:
Installing from enterprisedb site from msi packages in Windows 2000:
Installing 9.0 latest returns error about missing
Tomas Vondra t...@fuzzy.cz writes:
We need to identify whether the stats were reset between the snapshots,
because then the collected data are useless (and the scripts that do the
analysis are quite confused).
The stats are never reset automatically. If you have a DBA who randomly
resets
On 19 Nov 2010, at 4:23, Jayadevan M wrote:
Hi,
One doubt - if the tables are 'unlogged' , will the DMLs against these
still be replicated to a slave?
Yes, because the system tables, which store the layout of all tables, is
written to WAL.
Thank you for the reply. But my doubt was
What are the use-cases for replicating unlogged tables?
Hello,
I guess they could be useful in cloud infrastructures.
(see http://archives.postgresql.org/pgsql-general/2010-11/msg00865.php)
regards,
Marc Mamin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
39 matches
Mail list logo