Hi
On our production database, we had a small hiccup when playing a SQL
migration.
We write them to be as smooth as possible, trying not to interfere with
running services, but this time, we got a batch of failures.
I diagnosed the situation, and found out that we were hit by a known "feature"
On 05/11/2017 07:10 PM, John R Pierce wrote:
On 5/11/2017 9:53 AM, Pierre Couderc wrote:
I have broken my postgres database by typing :
psql How can I safely repair, knowing that I have the pg_dumpall of last
night, but many dbs have changed today... ?
Thanks in advance
was there
On 05/11/2017 07:07 PM, Hunley, Douglas wrote:
On Thu, May 11, 2017 at 11:53 AM, Pierre Couderc <mailto:pie...@couderc.eu>> wrote:
How can I safely repair, knowing that I have the pg_dumpall of
last night, but many dbs have changed today... ?
If pg_dumpall is your on
I have broken my postgres database by typing :
psql How can I safely repair, knowing that I have the pg_dumpall of last
night, but many dbs have changed today... ?
Thanks in advance
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On Friday, January 6, 2017 9:00:06 AM CET Merlin Moncure wrote:
> On Fri, Jan 6, 2017 at 4:09 AM, Pierre Ducroquet
>
> wrote:
> > Hi
> >
> > Running PostgreSQL 9.4, I am running in the following issue.
> > On a huge table, I have to remove the content (set to &
PostgreSQL would use the free
space to put the new data, so my update loop would give me a clean, «packed»
table.
What behaviour did I miss here ? How can I get PostgreSQL to use that free
space without falling back to a vacuum full ? (And without using tools like
pg_repack if possible, because this seems like not needed in that situation)
Thanks
Pierre
signature.asc
Description: This is a digitally signed message part.
On Wednesday, November 9, 2016 10:40:10 AM CET Francisco Olarte wrote:
> Pierre:
>
> On Wed, Nov 9, 2016 at 10:22 AM, Pierre Ducroquet
>
> wrote:
> > The query does a few joins «after» running a FTS query on a main table.
> > The FTS query returns a few thousand ro
On Wednesday, November 9, 2016 10:51:11 AM CET Pavel Stehule wrote:
> 2016-11-09 10:40 GMT+01:00 Francisco Olarte :
> > Pierre:
> >
> > On Wed, Nov 9, 2016 at 10:22 AM, Pierre Ducroquet
> >
> > wrote:
> > > The query does a few joins «after» running
On Wednesday, November 9, 2016 1:01:29 PM CET you wrote:
> Hello,
>
> On 09.11.2016 12:22, Pierre Ducroquet wrote:
> > Hello
> >
> > I recently stumbled on a slow query in my database that showed an odd
> > behaviour related to the statistics of FTS queries.
>
Hello
I recently stumbled on a slow query in my database that showed an odd
behaviour related to the statistics of FTS queries.
The query does a few joins «after» running a FTS query on a main table.
The FTS query returns a few thousand rows, but the estimations are wrong,
leading the optimizer
that, neither a "SQL-only"
fellow, nor a "C-what-else" guy.
It also reminds me of a paper I read once, where it was carefully
explained why scientists hated databases. But that's another subject.
Le 04/05/2016 21:22, Will McCormick a écrit :
Yeah but your alread
.
À+
Pierre
--
Pierre Chevalier
PChGEI: Pierre Chevalier Géologue Et Informaticien
Partenaire DALIBO
Mesté Duran
32100 Condom
Tél+fax :09 75 27 45 62
06 37 80 33 64
Émail
Interesting point of view. Time to make a bug report, isn't it? ;-)
À+
Pierre
Le 18/05/2016 17:44, Adam Brusselback a écrit :
On Tue, May 17, 2016 at 1:54 PM, Raymond O'Donnellmailto:r...@iol.ie>> wrote:
Having said all that, I've rarely had any trouble with pgAdmin
uot;application development". The latter would be made by using clipper,
most often.
À+
Pierre
--
____________
Pierre Chevalier
PChGEI: Pierre Chevalier Géologue Et Informaticien
Partenaire DALIBO
Mesté Duran
32100 Condom
Hi,
Le 17/05/2016 10:44, John R Pierce a écrit :
On 5/17/2016 1:34 AM, Pierre Chevalier Géologue wrote:
On this matter, I hear *very* often from such guys that the only
reproach they have to PostgreSQL is that it does not come with a slick
GUI like Access.
Access is a lot more than a slick
ould more suitable into
"advocacy" than here in "general", though.
À+
Pierre
--
________
Pierre Chevalier
PChGEI: Pierre Chevalier Géologue Et Informaticien
Partenaire DALIBO
Mesté Duran
32100 Condom
where you had something like 1 - 1 = 2... Maybe your boss was actually
very wise (and paranoid)?...
À+
Pierre
--
____
Pierre Chevalier
PChGEI: Pierre Chevalier Géologue Et Informaticien
Partenaire DALIBO
Mesté Duran
Hello,
I think that you can safely add the PostgreSQL repository to your system, so
that you can get the latest packages for your Debian.
See there how to do it:
https://wiki.postgresql.org/wiki/Apt
Regards,
Pierre
Le 13 mai 2016 09:14:28 GMT+02:00, JingYuan Chen a écrit :
>I use Deb
the 1990's, I met many-many deeply sick
persons. I had been infected for a while, I must confess.
À+
Pierre
--
________
Pierre Chevalier
PChGEI: Pierre Chevalier Géologue Et Informaticien
Partenaire DALIBO
ode on the server.
All right, I understand better now. I think I also totally missed your
point, sorry...
I'll give a look at andl.
À+
Pierre
--
____
Pierre Chevalier
PChGEI: Pierre Chevalier Géologue Et Informaticien
Pa
, and I tend to stuff more and more
logic inside the database. Which is often merely converting SQL queries
into views...
But it comes with a counterpart: the more you put logic inside your
DBMS, the more dependent you become. As far as I'm concerned, I recently
decided to just stick to Po
alize there is pg_restore -l and pg_restore -L :
http://www.postgresql.org/docs/9.5/interactive/app-pgrestore.html
Yes, thanks for the advice. Now I remember that I had used it also: I
just found these notes in my numeric attic:
# pierre@autan: ~< 2013_08_17__17_00_23 >
pg
the idea should be a bit more matured first, maybe?
À+
Pierre
--
____
Pierre Chevalier
PChGEI: Pierre Chevalier Géologue Et Informaticien
Partenaire DALIBO
Mesté Duran
32100 Condom
Tél+fax : 09 75 27 45 62
pg_dump' didn't help. And as I can read this discussion (I
haven't finished yet, obviously), this is not the case.
À+
Pierre
--
____________
Pierre Chevalier
PChGEI: Pierre Chevalier Géologue Et Informaticien
Partenaire
Hello,
Searching BDR led me to a few surprising results... (trigrams definitely have
numerous funny meanings ;o))
This URL will probably help:
http://bdr-project.org/docs/stable/index.html
Regards,
Pierre
Andreas Kretschmer a écrit :
>Sachin Srivastava wrote:
>
>>
maybe other "details". Since
postgresql data files are *very* close to what happens in the server's
RAM, a $PGDATA contents will not be readable on a different architecture.
Which OS was your old dusty server running on?
Regards (
Hello,
Are u sur that it's not a network issue ?
Maybe just try to telnet or check your ec2 security group.
Pierre
*Pierre HILBERT*
*Database Responsible | Decatec*
*Phone : +33 6 67 63 54 87*
On Sun, Feb 7, 2016 at 10:35 PM, Augori wrote:
> Thanks for the reply. Yes, it seems tha
matically to the list, I can see my own replies, displayed
within the appropriate conversation thread.
Or did I miss a point?
À+
Pierre
--
____________
Pierre Chevalier
PChGEI: Pierre Chevalier Géologue Et Informaticien
M
Le 10/02/2016 18:08, John R Pierce a écrit :
On 2/10/2016 8:51 AM, Pierre Chevalier Géologue wrote:
PPS: how should I behave on this list: should I systematically "reply
to all", or just "reply" to the list? I'm used to a number of mailing
lists where a simple "r
ide of what I would call a
horrible abuse; but despite these conditions, PostgreSQL did very well,
there has never been any data loss, it was used daily for
mission-critical operations.
So there are my $0.02
And these were my small 0.02€ ;)
À+
Pierre
PS: sorry Chris, I didn't pay
Hi
This table just has a column which type is integer. There are one million
data in this table. I wanna calculate standard deviation on each 50 data by
order. It means SD1 is from data 1 to data 50, SD2 is from data 51 to
100 Is there anyone who can give me some suggestions? Thanks
Pierre
Hi,
Is there anyone who can help me to create a specific table as following?
Thanks
Pierre
rule:
1. just one column which type is integer in table
2. this columns only has 1 and 2 for 50 times as following
1
2
1
2
1
2
1
2
.
rice and the implied price from linear regression by each
250 historical data(moving window)
Hopefully, it's clear for you to understand this calculation. Thanks
[image: Inline image 1]
On Thu, Jan 22, 2015 at 2:15 AM, Paul Jungwirth wrote:
> Hi Pierre,
>
> It looks like you'
Hi Raymond,
Thanks for your reply. Please see detail as following. Thanks again.
Pierre
[image: Inline image 1]
On Thu, Jan 22, 2015 at 1:48 AM, Raymond O'Donnell wrote:
> On 21/01/2015 17:32, Pierre Hsieh wrote:
> > Hi guys,
> >
> > Thanks for your replies.
> &
moving window
function but also few logical rules. Please see details as following or
attachment. I put some colors in rules. Hopefully, it's easier for you guys
to read them. Thanks
I really need the helps from your guys. Please give me some suggestions.
Thanks.
Pierre
[image: Inline image 1
Hi,
Would you please tell me whether PostgreSQL can execute the following
tasks? If not, please also tell me which one can help me for that. Thanks
--
*謝宗翰* *|* *台北富邦銀行* *風險管理部* *| 10686**台北市大安區仁愛路四段**169**號**12**樓**| (02)
27716699 **分機* *62853*
*Pierre
but I'll test
9.3 and 9.4 soon.
Thanks
Pierre
pg_audit_users-0.1.tar.bz2
Description: application/bzip-compressed-tar
signature.asc
Description: This is a digitally signed message part.
On Saturday, December 20, 2014 06:57:54 AM Adrian Klaver wrote:
> On 12/20/2014 06:40 AM, Pierre Ducroquet wrote:
> > Hi
> >
> > I'm working on a web credit card payment solution, so in a PCI-DSS
> > environment, and the auditors gave me trouble with one
L 9.2 only, but I'll test
9.3 and 9.4 soon.
Thanks
Pierre
pg_audit_users-0.1.tar.bz2
Description: application/bzip-compressed-tar
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hello
I just "released" (aka made known to more people than me and my
desk-neighboors)
a tiny tool that may come handy to some people.
It's a MySQL "plugin" (their definition of plugin is flabbergasting) that
provides a postgres storage engine in a MySQL instance.
It's usable both for select/up
Is EXECUTE slower than a direct assignment call?
>-Original Message-
>From: Vibhor Kumar [mailto:vibhor.ku...@enterprisedb.com]
>Sent: 1 mars 2011 18:24
>To: Pierre Racine
>Cc: pgsql-general@postgresql.org
>Subject: Re: [GENERAL] Dynamic binding in plpgsql function
>
-This is what I need
RETURN x;
END;
$$ LANGUAGE 'plpgsql';
I don't want to do an EXECUTE statement since I have no table to put after the
FROM clause. I want to assign the resulting value directly to a variable like
in my example.
Can I/How can I achieve this?
Thanks,
2010/7/28 Craig Ringer
> On 29/07/10 07:06, Pierre Thibault wrote:
> I doubt anyone can make any useful recommendations without a more
> complete explanation of what you're trying to achieve and why you want
> to do what you have described.
>
Thank you Craig,
Yes, I was
mapping correctly the files with the file system? Is
Posgresql able to handle this kind of charge?
--
A+
-
Pierre
Hum right... Better follow Paul instructions. We are in geographic coordinates
here... Sorry. This would work in a limited projected space.
>-Original Message-
>From: pgsql-general-ow...@postgresql.org
>[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of
>Pierre Raci
, orig.latitude),
ST_MakePoint(dest.longitude, dest.latitude), 2) AND orig.id = 378 AND
dest.id <> 378
Pierre
>-Original Message-
>From: pgsql-general-ow...@postgresql.org
>[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Joe
>Conway
>Sent: 21 juillet 2010 11
t[7] in join or string at
./crosstab_perl.pl line 24.
...
But the .csv file is there, after a redirection, and it seems fine! I'm
just worried about the messages: anything serious, or can I just ignore
them?
I'll do a diff with the csv I generated before (with psql, \a, and so
ually, I would have liked to have something that I can reuse within
postgresql, just like a view. Sorry, I'm an idealist...
based on any resultset (any number of columns). I'd be happy to post a
little get you started code if you wanted.
Sure, why not? Thanks!
--
Pierre Chevalie
t could be for any
FLOSS database, I guess) could be developed: again, does someone know if
such a project exists?
--
Pierre Chevalier Mesté Duran 32100 Condom
Tél : 09 75 27 45 62 - 06 37 80 33 64
http://pierremariechevalier.free.fr/
Logiciels Libres dans le Gers: http://gnusquetair
r_to_dataset() should be written, in C if
I understand well.
I have to dig out my old C book, and browse through postgresql APIs,
code examples,etc. I guess...
A+
Pierre
--
____
Pierre Chevalier
Mesté Duran
3
ppily to their
m$-access, therefore ignoring the pure wealth of postgreSQL: sad, isn't
it?...
A+
Pierre
--
________
Pierre Chevalier
Mesté Duran
32100 Condom
Tél+fax :09 75 27 45 62
05 62 28 06 83
bash: ERREUR: : commande introuvable
bash: » : commande introuvable
pie...@duran:~$ LIGNE 4 : 'value_num');
bash: Erreur de syntaxe près du symbole inattendu « ) »
pie...@duran:~$ ^
bash: ^ : commande introuvable
(sorry about the French!)
I could not do t
, that would be
just super!
A+
Pierre
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi,
Is there a way to tell PostgreSQL to keep only one instance of
postgres.exe running?
Thanks,
Pierre
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Thanks for the suggestion. Unfortunately I get an INVALID COLUMN
REFERENCE (SQL state: 42P10)
to the effect that the subselect in the FROM clause cannot reference
other tables at the same request level.
2008/9/20 Marcus Engene <[EMAIL PROTECTED]>:
>>
>> SELECT
>>persons.*,
>>(
>>
I have a PERSONS table.
I also have a PROGENY table, which is a many-to-many association table
with two foreign keys to the PERSONS table to itself.
(In this day and age, not only can an individual have any number of
children, but also a person can have any number of parents! At least,
let's assum
2008/6/30 Oleg Bartunov <[EMAIL PROTECTED]>:
> you, probably, can use custom configuration, which uses pg_3chars
> dictionary.
Thanks Oleg. That sounds like a cleverer (and more natural) idea than mine.
I am intrigued: is "pg_3chars" something that's part of the current
distribution of postgres
2008/6/30 Oleg Bartunov <[EMAIL PROTECTED]>:
> tsearch will have prefix search support in 8.4.
Thanks Oleg! That's fantastic news!
In the meantime, carrying on with my earlier idea, here's the little
function I came up with for extracting the 3-char-lexeme tsvector, in
case anyone's interested:
I am trying to implement an incremental search engine. The service
should start searching when the user has typed at least 3 characters.
I am thinking of using the following strategy:
a) Create a function string_to_three_char_tsvector(str text) that
would generate the tsvector composed of the thr
ID AS '$libdir/ascii_and_mic', 'ascii_to_mic' LANGUAGE C STRICT;
child process exited with exit code 1
The file ascii_and_mic.dll does exist in C:/Program Files
(x86)/PostgreSQL/8.3/lib
Thanks,
Jean-Pierre Pelletier
e-djuster
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Fri, May 23, 2008 at 7:10 AM, Sushant Sinha <[EMAIL PROTECTED]> wrote:
> Teodor did not want a separate function. He wanted it as an extension to
> ts_headline. One way to do this will be to invoke it only when options
> like MaxCoverSize is used. It will be slightly ugly though.
What I underst
or pg.
Pierre-yves.
diff -Nrub postgresql-8.3.1-orig/contrib/tsearch2/tsearch2.c postgresql-8.3.1/contrib/tsearch2/tsearch2.c
--- postgresql-8.3.1-orig/contrib/tsearch2/tsearch2.c 2008-01-01 20:45:45.0 +0100
+++ postgresql-8.3.1/contrib/tsearch2/tsearch2.c 2008-05-22 11:35:07.0 +0200
@@
Thanks Adam. No, It doesn't.
But I have found a solution which works :
select name from (select distinct name from t) as name order by replace(name,
'.', 'a');
name
--
co.aaa
co.abb
co.cab
co.ment
com
com.enta
(6 lines)
Thanks to all of you.
Adam Rich wrote :
>> By the way,
;
> select name from t order by replace(name, '.', '');
>
>
> Jon
>
>> -Original Message-
>> From: [EMAIL PROTECTED] [mailto:pgsql-general-
>> [EMAIL PROTECTED] On Behalf Of Pierre LEBRECH
>> Sent: Tuesday, March 25, 2008 9:56 AM
>> To
to t values ('co.cab');
> insert into t values ('com');
> insert into t values ('co.ment');
> insert into t values ('com.enta');
>
> select name from t order by replace(name, '.', '');
>
>
> Jon
>
>> ---
Hello,
I want to sort strings containing a dot but by taking care of this dot
like any other character.
example :
Currently, I get this after the sort :
co.aaa
co.abb
co.cab
com
co.ment
com.enta
But I would like to get this :
co.aaa
co.abb
co.cab
co.ment
com
com.enta
How I can do this?
Thank
> > My database uses tsearch2. I was about to follow the conversions
> > instructions found at Appendix F31 (on the new tsearch module).
> > http://www.postgresql.org/docs/8.3/static/tsearch2.html
> The docs will need to be updated because tsearch2 is now in the core and
> should already be availa
I just downloaded the 8.3 Windows installation (binary with installer).
My database uses tsearch2. I was about to follow the conversions
instructions found at Appendix F31 (on the new tsearch module).
http://www.postgresql.org/docs/8.3/static/tsearch2.html
However, I hit a problem when I get to
Olexandr Melnyk wrote:
Joe Celko's "SQL Programming Style" is a good not vendor-specific book.
As for PostgreSQL-specific books, I can only speak for one I read
before: Bruce Momjian's "PostgreSQL: Introduction and Concepts". It is
a good introductionary book, although
it isn't based on Postgr
Unfortunately there isn't a current version of Joshua Drake's book out
there (which I do own along with PostgreSQL Essential Reference by
Stinson), so alternatively, can anyone recommend a good DBA book
outlining best practices, physical design, etc? I would like something
that is relevant to P
Thomas Hart wrote:
Andrew Sullivan wrote:
I don't think top posting is always the crime it's made to be (and I
get a
little tired of lectures to others about it on these lists).
A
I agree. Obviously there is convention, and I will post in the style
generally accepted in the list, but to
A. Kretschmer wrote:
am Tue, dem 04.12.2007, um 20:19:29 -0800 mailte pc folgendes:
Hi,
How to redirect the output of an sql command to a file?
Thanks in advance
within psql you can use \o , from the shell you can use this:
[EMAIL PROTECTED]:~$ echo "select now()" | psql test > now.
Craig White wrote:
I wrote a little script to individually back up table schemas, table
data and then vacuum the table and it works nicely but I wanted a way to
query a database and get a text file with just the table names and
cannot figure out a way to do that.
my script looks like this...
(al
carter ck wrote:
> Hi all,
>
> I was trying to create function in postgres, but it returns error mentioning
> the language is NOT defined.
>
> The function is as following:
>
> CREATE OR REPLACE FUNCTION test_word_count(TEXT, TEXT) RETURNS INTEGER AS $$
> DECLARE
> d_word ALIAS FOR $1;
> d_phras
There's likely someone here that can help you, if you can give us some
more info. To start with, did the uninstall even work?
Ron
Tom Allison wrote:
Ran into a problem.
I hosed up postgresql by deleting the data directory.
So I thought I would just uninstall and reinstall postgres using
De
Harpreet Dhaliwal wrote:
Hi,
I keep getting this duplicate unique key constraint error for my
primary key even
though I'm not inserting anything duplicate. It even inserts the
records properly
but my console throws this error that I'm sure of what it is all about.
Corruption of my Primary Ke
Having read
http://www.postgresql.org/docs/8.2/interactive/datatype-character.html
I am puzzling over this issue:
1) Is there ever ANY reason to prefer "varchar(n)" to "text" as a column type?
2) For instance, if I know that a character-type column will never
contain more than 300 characters, w
Andrew Sullivan wrote:
On Fri, Jun 01, 2007 at 01:27:14PM -0700, Ron St-Pierre wrote:
imp=# select age(datfrozenxid) from pg_database where datname = 'imp';
age
1571381411
(1 row)
Time to start VACUUM FULL ANALYZE over the weekend.
I guess this come
Alvaro Herrera wrote:
FYI, in 8.2 and up the Xid wraparound problem is considered on a table
by table basis, which means that only the tables that have not been
vacuumed recently need to be vacuumed. The need for database wide
vacuuming is gone.
That's good.
Time to start VACUUM FULL ANAL
I stopped using autovacuum months ago because of similar problems
(version 8.1.4). Because we do some major inserts and updates about four
times a day, there were a few tables that I didn't want autovacuumed.
Even after I turned autovacuum off for these tables it still tried to
vacuum them whil
'A' and test <'Am';
"A"
"Ab"
"Ac"
select * from test where test >= 'Am' and test <'Bc';
"Amz"
"Az"
The end will be tricky because "" is not < "zz" so you will need
the la
Thanks Richard and Joshua, I had no idea that BETWEEN worked for text.
SELECT *
FROM Your_table AS YT
WHERE YT.text_field BETWEEN 'Aa' AND 'An';
postgres=# select * from test where test between 'A' and 'An';
test
--
A
Ab
Ac
(3 rows)
Ron
Ron St
I'm sure that others have solved this but I can't find anything with my
(google and archive) searches. I need to retrieve data where the text
field is within a certain range e.g.
A-An
Am-Bc
Bc-Eg
Yi-Zz
Does anyone know of a good approach to achieve this? Should I be looking
into regular e
Brilliant! Thank you!
> In tsearch2, I would like to use the "simple" dictionary along with my
> own list of stopwords.
> [...]
sure, just specify dict_initoption. For example,
test=# update pg_ts_dict set dict_initoption='contrib/english.stop' where
dict_name='simple';
UPDATE 1
test=# selec
In tsearch2, I would like to use the "simple" dictionary along with my
own list of stopwords.
In other words, once the text is parsed into tokens, no stemming
whatsoever, but stopwords are removed.
Is there an easy way to produce that result, using the standard
"simple" dictionary?
rks with UTF8, via the ODBC driver. Say
again that I output the data with another software that expects UTF8,
via the JDBC driver. Why does it matter that my system should be
localized in another encoding?
2007/1/29, Tom Lane <[EMAIL PROTECTED]>:
"Pierre Thibaudeau" <[EMAIL
Is this a documented phenomenon with the "convert" function? The first
result is what's expected:
SELECT convert('Gregoire' USING utf8_to_iso_8859_15);
"Gregoire"
But I don't understand the next result, when I put an acute accent over the
first "e":
SELECT convert('Grégoire' USING utf8_to_iso_
ges (see quoted post below), I don't know on
what factor to base my choice of initdb locale.
Suggestions?
On Jan 28, 3:28 am, [EMAIL PROTECTED] ("Pierre Thibaudeau") wrote:
[...] I cannot figure out what the latest status is concerning the
"default locale" on a Windows UTF-8
Over the past few days, I have been reading everything I could about
tsearch2, but I cannot figure out what the latest status is concerning the
"default locale" on a Windows UTF-8 database under PostgreSQL 8.2.
More specifically, I have a UTF-8 database containing information in five
different Eu
Greg Sabino Mullane wrote:
The database contains several schemas and excluding "comment_archive" by
moving it to different schema doesn't sound very convenient. pg_dump
doesn't have an option to dump multiple schemas at once.
Are there any working "-X" patches for pg_dump or does anyone have oth
Michael Fuhr wrote:
On Wed, Aug 09, 2006 at 10:33:02AM -0700, Ron St-Pierre wrote:
ERROR: duplicate key violates unique constraint "systemcounts_pkey"
CONTEXT: SQL statement "INSERT INTO dm.systemCounts (updateDate) VALUES (
$1 ::date)"
PL/pgSQL function "upda
Hi, I'm having a problem with one of my functions, where I delete all
rows containing a particular date and then re-insert a row with that
same date. When I try this I get a constraint error. This just started
recently, after upgrading our database from 7.4 to 8.1.4 (now on RH EL).
here's the
Hi, I've been trying to see whether or not autovacuum is vacuuming all
of my tables, and how often (for my peace of mind). I can see that it is
running, but I don't know what it's doing. There are a handful of key
tables in our database which suffer quite a bit if their not vacuumed
regularly (
Douglas McNaught wrote:
rstp <[EMAIL PROTECTED]> writes:
pg_config is telling us that we are running version 7.3.6-RH, but when
we start psql it shows that we are running 8.1.4 (which is the correct
version).
[EMAIL PROTECTED] bin]$ pg_config --version
PostgreSQL 7.3.6-RH
[EMAIL PROTEC
> - Original Message -
> From: "Michael Fuhr" <[EMAIL PROTECTED]>
> To: "Ron St-Pierre" <[EMAIL PROTECTED]>
> Subject: Re: [GENERAL] Schema is Missing
> Date: Fri, 10 Mar 2006 11:27:54 -0700
>
>
> On Fri, Mar 10, 2006 at 12
We received the following error on our development server this morning
(postgresql 7.4.1, debian woody):
org.postgresql.util.PSQLException: ERROR: schema "customer" does not exist
When I login to postgres it looks as if the other schemas are okay, but the
customer schema is gone. I have a back
scope of the list, I
wasn't sure whether or not there were postgres modules to deal with this.
Thanks for pointing me to possible solutions.
Ron
> - Original Message -
> From: "George Pavlov" <[EMAIL PROTECTED]>
> To: "Ron St-Pierre" <[EMAIL PRO
I'm sure that this has been asked before but I can't find any reference to it
in google, and the search facility on postgresql.org is currently down.
I have a large number of entries (possibly 10,000+) in an XML file that I need
to import into the database (7.4 on Debian) on a daily basis. Does
threw away by
mistake...
Pierre
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
The link is not there, but the doc sure is :
http://www.postgresql.org/docs/8.0/static/
Is it the right version ?
I know they can be accessed at developer.postgresql.org, but I didn't
see a link to the docs for postgresql 8 on the new website, did I miss
it somewhere?
Chris
1 - 100 of 210 matches
Mail list logo
