sec.
VACUUM
=> reindex index tracks_pkey;
ERROR: could not create unique index "tracks_pkey"
DETAIL: Key (id)=(793935) is duplicated.
2014-08-12 20:21 GMT+02:00 John R Pierce :
> On 8/12/2014 12:32 AM, Alexis Bernard wrote:
>
>> The vacuum full tracks just finished an
The vacuum full tracks just finished and I still have the duplicated IDs.
2014-08-12 9:17 GMT+02:00 Alexis Bernard :
> Hi,
>
> Thanks for your help Alban !
>
> Alexis.
>
>
> 2014-08-09 18:46 GMT+02:00 Alban Hertroys :
>
> On 09 Aug 2014, at 13:24, Alexis Berna
Hi,
Thanks for your help Alban !
Alexis.
2014-08-09 18:46 GMT+02:00 Alban Hertroys :
> On 09 Aug 2014, at 13:24, Alexis Bernard wrote:
>
> > Primary key definition: "tracks_pkey" PRIMARY KEY, btree (id)
> > select version(): PostgreSQL 9.3.4 on x86_64-unknown-
35 GMT+02:00 Alban Hertroys :
> On 09 Aug 2014, at 11:38, Alexis Bernard wrote:
>
> > Hi,
> >
> > I am having regurlarly duplicated rows with the same primary key.
> >
> > => select id, created_at, updated_at from tracks where created_at =
> &#
Hi,
I am having regurlarly duplicated rows with the same primary key.
=> select id, created_at, updated_at from tracks where created_at =
'2014-07-03 15:09:16.336488';
id | created_at | updated_at
++
331
hours.
Regards,
Bernard
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
,
Bernard
-Message d'origine-
De : Tom Lane [mailto:t...@sss.pgh.pa.us]
Envoyé : lundi 2 novembre 2009 4:40
À : Bernard Grosperrin
Cc : pgsql-general@postgresql.org
Objet : Re: [GENERAL] Error on compile for Windows
"Bernard Grosperrin" writes:
> I have setup a bu
inter, I really want to be able to see through that
project, as quite a few things are depending on it.
Bernard.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
subscribe
end
Today I tried every permutation of the DateStyle parameter I could find, and
still cannot get PostgreSQL 8.3 to accept dates in the format mmdd. I tried
setting this in the postgresql.conf file, and also in psql using "set datestyle
to
I'm currently porting an Informix based application to PostgreSQL 8.3.
All of the dates processed by the application are in the mmdd
format. According to the date input table at the link below, the
mmdd format is not listed. The mmdd format is supported, but
I'd have to modify a LOT
bgrosper...@laposte.net
Bernard Grosperrin
BGSoftFactory
Bureau/Domicile 09 53 41 58 18
Mobile 06 75 13 97 17
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
, should I write a function that I would call
instead?
Thanks,
Bernard
---(end of broadcast)---
TIP 6: explain analyze is your friend
Hi Tom,
It now works!
I hate SELinux, it always cause me problems.
Any suggestion on how to make SELinux happy without having to turn it off.
Thanks,
Bernard
Tom Lane wrote:
Bernard Miville <[EMAIL PROTECTED]> writes:
I am just trying to connect to a Postgresql DB using a Pe
say, I searched the web and a lot of forums the past 2 days and found a lot of solutions that do not work for my case or
are for Postgresql 7.4 (e.g. tcpip_socket = true does not exist in 8.1, need to use listen_addresses instead).
Any help would be really appreciated.
Thank you,
Bernard
--
y braindead list server I have
seen so far.
On Tue, 30 Aug 2005 11:24:45 +0300, marko wrote:
>[This guy has prove-you-arent-bot filtering]
>
>On Tue, Aug 30, 2005 at 07:04:52PM +1200, Bernard wrote:
>> I would appreciate your help very much.
>
>Unless you turn off your brain
pg_hba.conf is in its
original state.
I would appreciate your help very much.
Thanks.
Bernard
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
ible explanation (ambiguity) but I can't see
how this explanation would apply to the case under discussion.
Any help would be highly appreciated.
Regards
Bernard
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
from that data.
Unfortunately the user is not in the position to convert the output to
another format or change the software output in any non-standard way.
Any help would be highly appreciated.
Regards
Bernard
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Sean,
Very diplomatic way to get the message across without offending anyone
except the bastards.
Capatalism is good for development. But it has to be kept in check as
to not destroy the basis on which it once grew and provided fair
chances for anyone to participate. Who is keeping it in check to
decision which
database to use is theirs.
Regards
Bernard
On Fri, 19 Aug 2005 01:10:46 -0700, you wrote:
>Yeah, I'm -vvv tonight.
>
>psql provides \COPY table from file
>
>how about
>String cmd = "psql -c '\COPY table from file' -U user -d database"
&
remote data transfers.
Regards
Bernard
On 19 Aug 2005 02:03:54 -0400, you wrote:
>
>Oliver Jowett <[EMAIL PROTECTED]> writes:
>
>> Bernard was also objecting to the overhead of pushing the data down a
>> TCP pipe when it's already available locally, I think.. I di
t in which ident auth is
>at all trustable, it would in theory be possible to implement COPY to a
>file descriptor opened by the client and passed through the socket. I
>personally think it is unlikely that this would be worth the (not
>inconsiderable) amount of work needed to implement i
setup for such "bulk" loading is a mess.
Regards,
Bernard
On Fri, 19 Aug 2005 12:27:01 +1200, you wrote:
>Bernard wrote:
>
>> The majority of JDBC users trying to bulk load tables would not want
>> to send the data through their connection. This connection is designed
a file.
The need is only created by the limitations of the Postgres COPY
command.
I can't see why a workaround should be developed instead of or before
fixing the COPY command.
It works in other DB engines.
Regards
Bernard
On Fri, 19 Aug 2005 11:10:42 +1200, you wrote:
>Berna
String in memory.
Thanks
Bernard
On Wed, 17 Aug 2005 06:51:12 -0500, you wrote:
>On Wed, Aug 17, 2005 at 09:22:16 +0100,
> Bernard <[EMAIL PROTECTED]> wrote:
>>
>> The following bug has been logged online:
>
>This isn't a bug and you really should have aske
postgres.
Once that is done, the "su postgres" will work without any password since
you are running it from root.
Regards,
Bernard
On Saturday 09 October 2004 10:29, wayne schlemitz wrote:
> I am using SuSE 8.0 Professional Linux and installing
> postresql 7.4 by placin
Hello Jonathan,
Take look at URL: http://techer.pascal.free.fr/postgis/psqlwin/
That French guy has a binary version of PG for Windows.
The zip is at URL: http://techer.pascal.free.fr/postgis/psqlwin.zip
Note that I did not tried it!
Good luck!
Bernard
On Tuesday 22 June 2004 15:13
Done too :)
Hum! IMHO not so many people because when I click PG went from 16% to 17%
immediately.
Bernard
On Wednesday 31 March 2004 14:09, Marc G. Fournier wrote:
> Done :)
>
> Guys ... poll now shows 53% for MaxDB (ie. MySQL) and 15% for PostgreSQL
> ... think we can imp
e and
this paragraph and the following two paragraphs appear in all copies.
HOWEVER, I AM NOT A LAWER, THEREFORE I COULD BE WRONG.
Regards,
Bernard
On Thursday 25 March 2004 01:19, Eric Yum wrote:
> Dear Sir
>
> I am a developer of one commercial organization. We are going to
correctly...you might have to play with it (or wait for somebody with more
experience than me).
Bernard
On Wednesday 10 March 2004 16:23, Randall Skelton wrote:
> >> I to return a sequential row number beginning at 1?
> >>
> >> i.e.
>
31 matches
Mail list logo
