No, when you catch an insert exception , you can save the information you
needed to array or something likes that, and continue to do the next insert.
In your application, you can write codes as follows.
begin transaction
loop
try
do insert
catch exception
save error info
Hi Danish, yes thats the one I was looking for. Thanks a lot!!!
On Tue, Jul 28, 2015 at 1:32 AM, dinesh kumar
wrote:
>
>
> On Mon, Jul 27, 2015 at 12:57 PM, dinesh kumar
> wrote:
>
>> On Mon, Jul 27, 2015 at 12:53 PM, Alex Magnum
>> wrote:
>>
>>> Hello,
>>>
>>> I have a csv string in a text f
Thanks you very much Adrian for clearing my confusion.
On Mon, Jul 27, 2015 at 7:24 PM, Adrian Klaver
wrote:
> On 07/27/2015 12:48 AM, Amit Bondwal wrote:
>
>> Hi Everyone.
>>
>> I am able to setup postgresql with TLS v1.2 with client certificate. I
>> used below link to setup this and it work
Thank you Kevin! I missed the start of string and end of string matching.
On Tue, Jul 28, 2015 at 1:06 AM, Kevin Grittner wrote:
> Sanjaya Vithanagama wrote:
>
> > I can match the numeric value and the rest of the string after
> > the numeric value using the following:
> >
> > select regexp_mat
On 07/23/2015 02:36 PM, Heikki Linnakangas wrote:
On 07/23/2015 11:31 AM, Spiros Ioannou wrote:
Well, so far with commit_delay=0 no problems. I will report back of couse
if something happens, but I believe that the problem may indeed be
solved/masked with that setting.
Rough description of our
On Mon, Jul 27, 2015 at 12:57 PM, dinesh kumar
wrote:
> On Mon, Jul 27, 2015 at 12:53 PM, Alex Magnum
> wrote:
>
>> Hello,
>>
>> I have a csv string in a text field that is unsorted and contains
>> duplicates.
>> Is there a simple way to remove these and sort the string.
>>
>> E.g
>> 2,18,20,23,
> Hello,
>
> I have a csv string in a text field that is unsorted and contains
> duplicates.
> Is there a simple way to remove these and sort the string.
>
> E.g
> 2,18,20,23,1,27,1,2,8,16,17,18,20,22,23,27
>
> i tried string to array and unique but that did not work...
> Any suggestions on ho
>
> I have a csv string in a text field that is unsorted and contains duplicates.
> Is there a simple way to remove these and sort the string.
>
> E.g
> 2,18,20,23,1,27,1,2,8,16,17,18,20,22,23,27
>
Do you need to eventually load the data in Postgres?
I'd personally use python to deal with th
On Mon, Jul 27, 2015 at 12:53 PM, Alex Magnum wrote:
> Hello,
>
> I have a csv string in a text field that is unsorted and contains
> duplicates.
> Is there a simple way to remove these and sort the string.
>
> E.g
> 2,18,20,23,1,27,1,2,8,16,17,18,20,22,23,27
>
> i tried string to array and uniqu
Hello,
I have a csv string in a text field that is unsorted and contains
duplicates.
Is there a simple way to remove these and sort the string.
E.g
2,18,20,23,1,27,1,2,8,16,17,18,20,22,23,27
i tried string to array and unique but that did not work...
Any suggestions on how to do this without wri
On 07/27/2015 12:36 PM, JotaComm wrote:
Hello,
I have the following inconsistency in my environment:
postgres@postgres =# SELECT current_timestamp;
now
---
*2015-07-27 16:26:40.001694-03*
(1 row)
postgres@postgres =# SHOW timezone;
TimeZone
-
Hello,
I have the following inconsistency in my environment:
postgres@postgres =# SELECT current_timestamp;
now
---
*2015-07-27 16:26:40.001694-03*
(1 row)
postgres@postgres =# SHOW timezone;
TimeZone
-
Brazil/East
(1 row)
postgres@post
On 07/27/2015 10:58 AM, AI Rumman wrote:
I am not using any comma here. With the same command I am able to take
dump on other disks.
I beg to differ, From your original post:
-f dbname_tablename,sqlc
^^^
>
But with ISOLON CIFS, I am getting the error.
Thanks.
On Mon
I am not using any comma here. With the same command I am able to take dump
on other disks.
But with ISOLON CIFS, I am getting the error.
Thanks.
On Mon, Jul 27, 2015 at 10:56 AM, Adrian Klaver
wrote:
> On 07/27/2015 10:55 AM, AI Rumman wrote:
>
>> No it is "-s" for schema only backup.
>>
>
> M
On 07/27/2015 10:55 AM, AI Rumman wrote:
No it is "-s" for schema only backup.
My ^ got misplaced in sending. I was talking about the ',' in the file
name at the end of the command.
Thanks.
On Mon, Jul 27, 2015 at 10:53 AM, Adrian Klaver
mailto:adrian.kla...@aklaver.com>> wrote:
On 0
No it is "-s" for schema only backup.
Thanks.
On Mon, Jul 27, 2015 at 10:53 AM, Adrian Klaver
wrote:
> On 07/27/2015 10:48 AM, AI Rumman wrote:
>
>> Hi,
>>
>> I am getting the following error during pg_dump:
>>
>> pg_dump dbname -v -t tablename -s -Fc -f dbname_tablename,sqlc
>>
>
On 07/27/2015 10:48 AM, AI Rumman wrote:
Hi,
I am getting the following error during pg_dump:
pg_dump dbname -v -t tablename -s -Fc -f dbname_tablename,sqlc
^
Is that really a ','(comma)?
pg_dump: [custom archiver] WARNING: ftell mi
Hi,
I am getting the following error during pg_dump:
pg_dump dbname -v -t tablename -s -Fc -f dbname_tablename,sqlc
pg_dump: [custom archiver] WARNING: ftell mismatch with expected position
-- ftell used
I am using Postgresql 9.1 and I have enough disk space on it. The backup
drive is on ISOLON
* Michael Paquier (michael.paqu...@gmail.com) wrote:
> On Tue, Jul 21, 2015 at 4:47 PM, Andrew Beverley wrote:
> > Dear all,
> >
> > I'm setting up hot backups on my database server. As such, I'd like to set
> > up a
> > Postgres user that has access to only pg_start_backup and pg_stop_backup.
>
A little late to the party, but i'll share how I do my data imports /
validation for anyone interested.
I have a bunch of data that comes in from various sources, and it isn't
always guaranteed to be in the correct format, have the right foreign keys,
or even the right data types.
I have a stagin
On 07/27/2015 08:42 AM, Herouth Maoz wrote:
On 27 ביולי 2015, at 18:01, Adrian Klaver wrote:
Not sure what yo have set up for logging, but you might to crank it up. 13 days
between entries for a system that is in use all the time seems sort of light to
me.
Most of the log settings are just
On Mon, Jul 27, 2015 at 3:19 AM, Chris Withers
wrote:
> On 24/07/2015 22:51, Jeff Janes wrote:
>
> starting vacuum...end.
>
>> transaction type: TPC-B (sort of)
>> scaling factor: 1
>>
>
> This is your problem. There is only one row in the pgbench_branch
> table, and every transaction has to
> On 27 ביולי 2015, at 18:01, Adrian Klaver wrote:
> Not sure what yo have set up for logging, but you might to crank it up. 13
> days between entries for a system that is in use all the time seems sort of
> light to me.
Most of the log settings are just the Debian default (except the log pref
On 07/27/2015 08:07 AM, Herouth Maoz wrote:
On 27 ביולי 2015, at 16:55, Melvin Davidson wrote:
If you are running Linux (please ALWAYS give the O/S ), then this could have
been caused by the sys admin doing a system shutdown.
Yes, sorry about that, as I previously answered Adrian Klaver, t
For crying out loud GET OVER IT! You've been given a very reasonable and
quick solution to your problem.
You can either
1. Keep crying and moaning until someone changes the rules.
2. Give up and port to another database.
3. Write the triggers and solve your problem!
On Fri, Jul 24, 2015 at 5:27 AM
Herouth Maoz writes:
> So Iâm left with the question of what caused the shutdown on July 21st.
Well, you had
2015-07-21 15:37:59 IDT LOG: received fast shutdown request
There is exactly one place in the Postgres code that prints that message,
and it is the postmaster's SIGINT handler.
2015-
2015-07-24 14:25:52 UTC [4736-17] LOG: starting background worker process
"bdr (6174890623557546797,1,20737,)->bdr (6174890623557546797,1,"
Anyone know how can I solve this error? I'm using BDR replication with
Debian wheezy packages.
Thanks!
2015-07-24 14:25:52 UTC [4805-1] ERROR: tuple natts
Zdeněk Bělehrádek wrote
> What about creating a SAVEPOINT before each INSERT, and if the INSERT
> returns
> an error, then ROLLBACK TO SAVEPOINT? This way you will have all the
> insertable data in your table, and you can still ROLLBACK the whole
> transaction, or COMMIT it if there were no erro
>
> Just in case it has not been made obvious yet, rules are silently
> deprecated. They still exist because views depend on them, but it is
> generally considered best practices to not use them outside that realm.
Well, the manual doesn't seem to reflect that fact.
If that's how the developers
On 23 July 2015 at 19:25, Scott Marlowe wrote:
> stick to triggers, they're faster
Erm, not according to your beloved manual !!!
38.7. Rules Versus Triggers
" a rule issuing one extra command is likely to be faster than a trigger"
"The summary is, rules will only be significantly slower than t
林士博 wrote
> If I am following correctly, you can do it in your application as follows.
> 1.begin transaction
> 2.insert each data. Catch db exception,
> and save exception message and other information you need to array.
> 3.in the end ,you can get all the information about the wrong data in
> arra
> On 27 ביולי 2015, at 16:55, Melvin Davidson wrote:
>
> If you are running Linux (please ALWAYS give the O/S ), then this could have
> been caused by the sys admin doing a system shutdown.
Yes, sorry about that, as I previously answered Adrian Klaver, the OS is Debian
Gnu/Linux 7.
But I did
Sanjaya Vithanagama wrote:
> I can match the numeric value and the rest of the string after
> the numeric value using the following:
>
> select regexp_matches('hello+123123.453the-123re',
>
> '([\+|-]?(?:\d*(?:(?:\.)?\d+)))(.*)')
> outputs array {+12312
On 07/27/2015 07:45 AM, Herouth Maoz wrote:
On 27 ביולי 2015, at 16:39, Adrian Klaver wrote:
* Given that I did not terminate any backend connection interactively,
why did I get a "terminating connection due to administrator
command” message? Is there any situation where this mess
> On 27 ביולי 2015, at 16:39, Adrian Klaver wrote:
>>
>> * Given that I did not terminate any backend connection interactively,
>>why did I get a "terminating connection due to administrator
>>command” message? Is there any situation where this message is
>>issued without the admin
On 27/07/2015 14:54, p...@arbolone.ca wrote:
> It worked!
> Thanks kids, that was awesome!
Glad it worked. It's a while since I've been called a kid! :-)
> One last question, is there a tutorial about accessing the back end
> using c++
I've done it using Qt, and there are tons of documentation a
On 07/27/2015 06:48 AM, Furlong, Shane wrote:
I am trying to upgrade from PostgreSQL 9.0.22 to 9.4.4.
When I attempt to execute pg_upgrade, I get the following error:
*Performing Consistency Checks*
*-*
*Checking cluster versions*
*This utility can only upgrade to
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Shane Furlong asks:
> When I attempt to execute pg_upgrade, I get the following error:
...
> This utility can only upgrade to PostgreSQL version 9.4.
...
> /app/PostgreSQL/9.4/bin/pg_upgrade -b /app/PostgreSQL/9.0/bin -B
> /app/PostgreSQL/9.4/b
It worked!
Thanks kids, that was awesome!
One last question, is there a tutorial about accessing the back end using
c++
Again, thanks s much!
-Original Message-
From: Raymond O'Donnell
Sent: Monday, July 27, 2015 9:28 AM
To: p...@arbolone.ca ; Adrian Klaver ; PostGreSQL MailingLi
If you are running Linux (please ALWAYS give the O/S ), then this could
have been caused by the sys admin doing a system shutdown.
Otherwise, anyone that can sudo to postgres could also have potentially
issued a
pg_ctl stop.
I strongly suggest you review the _system_ logs for a possible hint as t
On 07/27/2015 12:48 AM, Amit Bondwal wrote:
Hi Everyone.
I am able to setup postgresql with TLS v1.2 with client certificate. I
used below link to setup this and it works nicely.
https://www.howtoforge.com/postgresql-ssl-certificates
How can I connect to remote database with encrypted connectio
I am trying to upgrade from PostgreSQL 9.0.22 to 9.4.4.
When I attempt to execute pg_upgrade, I get the following error:
Performing Consistency Checks
-
Checking cluster versions
This utility can only upgrade to PostgreSQL version 9.4.
The command I am executing is:
On 07/27/2015 02:16 AM, Herouth Maoz wrote:
Hello everybody.
In the past week, it has happened to us twice already that we got an
exception from our Java application, due to PostgreSQL "terminating
connection due to administrator command”.
The problem is that I’m the administrator, and I issued
On 07/27/2015 06:22 AM, p...@arbolone.ca wrote:
After removing PostgreSQL and manually deleting all the other files
installed by it I reinstalled PostgreSQL, I started the cmd.exe and
typed psql, asked me for the password, entered it, but to no avail.
I took notes of all the information I entered
On 27/07/2015 04:15, p...@arbolone.ca wrote:
> OK, I think I should tell you folks that I am a newbie. I am using
> postgresql to learn the SQL for the purpose of learning storing the data
> in my c++ application. I have near zero knowledge of SQL or PostgreSQL
> for that matter.
> When I type C:\p
After removing PostgreSQL and manually deleting all the other files
installed by it I reinstalled PostgreSQL, I started the cmd.exe and typed
psql, asked me for the password, entered it, but to no avail.
I took notes of all the information I entered during the installation, so
this time I'd be s
On 24/07/2015 22:51, Jeff Janes wrote:
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 1
This is your problem. There is only one row in the pgbench_branch
table, and every transaction has to update that one row. This is
inherently a seriaized event.
Indeed
Hello everybody.
In the past week, it has happened to us twice already that we got an exception
from our Java application, due to PostgreSQL "terminating connection due to
administrator command”.
The problem is that I’m the administrator, and I issued no such command.
On the first opportunity
Hi Everyone.
I am able to setup postgresql with TLS v1.2 with client certificate. I used
below link to setup this and it works nicely.
https://www.howtoforge.com/postgresql-ssl-certificates
How can I connect to remote database with encrypted connection on tls
without setting client certificates o
49 matches
Mail list logo