Bristol and Bath Linux: Februari 2014

Jumat, 28 Februari 2014

Bristol Digest, Vol 539, Issue 11

Send Bristol mailing list submissions to
bristol@mailman.lug.org.uk

To subscribe or unsubscribe via the World Wide Web, visit
https://mailman.lug.org.uk/mailman/listinfo/bristol
or, via email, send a message with subject or body 'help' to
bristol-request@mailman.lug.org.uk

You can reach the person managing the list at
bristol-owner@mailman.lug.org.uk

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Bristol digest..."

Today's Topics:

1. Backup drive (david)
2. Re: Backup drive (Alex Butcher)
3. Re: Backup drive (david)
4. Re: Backup drive (Adrian Portway)
5. Introducing myself (Adrian Portway)
6. Re: Introducing myself (David Fear)
7. Re: Introducing myself (Nigel Sollars)

----------------------------------------------------------------------

Message: 1
Date: Fri, 28 Feb 2014 16:53:25 +0000
From: david <david@avoncliff.com>
To: Bristol and Bath Linux User Group <bristol@mailman.lug.org.uk>
Subject: [bristol] Backup drive
Message-ID: <5310BF05.9000003@avoncliff.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

All
I have decided I really ought to do something about backups, the old
system of copying everything to a CD every so often that has worked for
years is showing its age.
So I bought a 1T drive, and formatted it ext4, it shows up as 1000gig free.
So I copied /home off an old machine on to it, this lists as 159,323
items totalling 28.4GB, and now the drive is showing 899GB free.
Does everyone just ignore this, and buy bigger drives?
If I partition it up how many partitions do I need to make it worth the
effort.

And as the idea is to copy several machines and some old drives on to
one drive (all eggs in one basket ) has anyone used any deduping
software for home use.

David

------------------------------

Message: 2
Date: Fri, 28 Feb 2014 17:02:45 +0000 (GMT)
From: Alex Butcher <lug@assursys.co.uk>
To: Bristol and Bath Linux User Group <bristol@mailman.lug.org.uk>
Subject: Re: [bristol] Backup drive
Message-ID: <alpine.LFD.2.03.1402281655470.8365@nffheflf.pb.hx>
Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed

On Fri, 28 Feb 2014, david wrote:

> I have decided I really ought to do something about backups, the old system
> of copying everything to a CD every so often that has worked for years is
> showing its age.
> So I bought a 1T drive, and formatted it ext4, it shows up as 1000gig free.
> So I copied /home off an old machine on to it, this lists as 159,323 items
> totalling 28.4GB, and now the drive is showing 899GB free.
> Does everyone just ignore this, and buy bigger drives?
> If I partition it up how many partitions do I need to make it worth the
> effort.

Using smaller partition sizes to get smaller cluster sizes is a
Microsoft-ism.

Linux extX filesystems reserve some blocks (default 5%) for root. If you
didn't override this, that probably explains the discrepancy. To check, run
as root:

# tune2fs -l /dev/sdX | grep Reserved

Finally, there's also the difference in definitions between binary and
decimal multiples; OSs usually use the former, storage vendors the latter
(<http://en.wikipedia.org/wiki/IEEE_1541>).

HTH,
Alex

------------------------------

Message: 3
Date: Fri, 28 Feb 2014 17:40:32 +0000
From: david <david@avoncliff.com>
To: Bristol and Bath Linux User Group <bristol@mailman.lug.org.uk>
Subject: Re: [bristol] Backup drive
Message-ID: <5310CA10.8040009@avoncliff.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

On 28/02/14 17:02, Alex Butcher wrote:
> On Fri, 28 Feb 2014, david wrote:
>
>> I have decided I really ought to do something about backups, the old
>> system of copying everything to a CD every so often that has worked
>> for years is showing its age.
>> So I bought a 1T drive, and formatted it ext4, it shows up as 1000gig
>> free.
>> So I copied /home off an old machine on to it, this lists as 159,323
>> items totalling 28.4GB, and now the drive is showing 899GB free.
>> Does everyone just ignore this, and buy bigger drives?
>> If I partition it up how many partitions do I need to make it worth
>> the effort.
>
> Using smaller partition sizes to get smaller cluster sizes is a
> Microsoft-ism.
>
> Linux extX filesystems reserve some blocks (default 5%) for root. If you
> didn't override this, that probably explains the discrepancy. To check, run
> as root:
>
> # tune2fs -l /dev/sdX | grep Reserved
>
> Finally, there's also the difference in definitions between binary and
> decimal multiples; OSs usually use the former, storage vendors the latter
> (<http://en.wikipedia.org/wiki/IEEE_1541>).
>
Even more confused, if it is reserved by the format, why did it show up
as free before the copy. Ubuntu has joined the binary is too difficult
for users brigade, it listed it as 1T free = 1000.4GB.
Reserved block count: 12209500
Block size: 4096
So 28GB + 48GB + 899 = 25missing. I guess I stop worrying there. And
only ask for the reserved back if I get too full.
Thanks

------------------------------

Message: 4
Date: Fri, 28 Feb 2014 18:55:47 +0000
From: Adrian Portway <adrian.portway@gmail.com>
To: Bristol and Bath Linux User Group <bristol@mailman.lug.org.uk>
Subject: Re: [bristol] Backup drive
Message-ID:
<CAAUR1PvjBZyUyQeoW5TOscPQqV4uEsU5FYNSR8YkHifjZ35Wyg@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

Hi David,

As regards deduping software I've found dupeguru pretty good and the
developer has recently opened up the source. You can find it here :
http://www.hardcoded.net/dupeguru/

Cheers,

Adrian
On 28 Feb 2014 16:54, "david" <david@avoncliff.com> wrote:

> All
> I have decided I really ought to do something about backups, the old
> system of copying everything to a CD every so often that has worked for
> years is showing its age.
> So I bought a 1T drive, and formatted it ext4, it shows up as 1000gig free.
> So I copied /home off an old machine on to it, this lists as 159,323 items
> totalling 28.4GB, and now the drive is showing 899GB free.
> Does everyone just ignore this, and buy bigger drives?
> If I partition it up how many partitions do I need to make it worth the
> effort.
>
> And as the idea is to copy several machines and some old drives on to one
> drive (all eggs in one basket ) has anyone used any deduping software for
> home use.
>
> David
>
> _______________________________________________
> Bristol mailing list
> Bristol@mailman.lug.org.uk
> https://mailman.lug.org.uk/mailman/listinfo/bristol
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.lug.org.uk/mailman/private/bristol/attachments/20140228/e631fa62/attachment-0001.html>

------------------------------

Message: 5
Date: Fri, 28 Feb 2014 20:29:25 +0000
From: Adrian Portway <adrian.portway@gmail.com>
To: Bristol@mailman.lug.org.uk
Subject: [bristol] Introducing myself
Message-ID:
<CAAUR1Pvb9+Hi-BhQ89xh2GoQLPsT7X=mrQwHjhwWZ0AJ3mw-KA@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

Hi everyone, just joined the mailing list and thought I'd introduce myself.

My name is Adrian Portway, I'm based in Chard. Been using Linux for about
10 years or so starting with Mandrake 9 on an old Dell Inspiron laptop.

I work as IT Manager at a firm in Devon looking after the desktops ( mostly
Windows ) and servers ( all Linux ).

Hopefully I'll be able to get up to Bristol to meet a few of you some time.

Cheers,

Adrian
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.lug.org.uk/mailman/private/bristol/attachments/20140228/9a9c501e/attachment-0001.html>

------------------------------

Message: 6
Date: Fri, 28 Feb 2014 21:12:38 +0000
From: David Fear <david@dfear.co.uk>
To: Bristol and Bath Linux User Group <bristol@mailman.lug.org.uk>
Subject: Re: [bristol] Introducing myself
Message-ID: <5310FBC6.5000404@dfear.co.uk>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

On 28/02/14 20:29, Adrian Portway wrote:
> Hi everyone, just joined the mailing list and thought I'd introduce myself.
>
> My name is Adrian Portway, I'm based in Chard. Been using Linux for
> about 10 years or so starting with Mandrake 9 on an old Dell Inspiron
> laptop.
>
> I work as IT Manager at a firm in Devon looking after the desktops (
> mostly Windows ) and servers ( all Linux ).
>
> Hopefully I'll be able to get up to Bristol to meet a few of you some time.
>
> Cheers,
>
> Adrian
>
>
>
> _______________________________________________
> Bristol mailing list
> Bristol@mailman.lug.org.uk
> https://mailman.lug.org.uk/mailman/listinfo/bristol
>
Hi

Welcome to the group. Hope to see you at one of the monthly meetups.
Meetings every 4th Saturday of each month at the Knights Templar pub at
Temple Quays Bristol starting from 1-30PM. For details:
http://www.bristol.lug.org.uk/.

Also you might be interested in coming to the event we are holding on
Saturday 15th March at Pervasive Media Studio (Watershed) in Bristol.
It's called "LinuxLive 2014" and it's being held to showcase how great
linux is and as alternative to Windows XP. If you would like more info
go to: www.linuxlive.co.uk.

--
Regards

-----------------------------------
Dave Fear :: david@dfear.co.uk

Order your free giffgaff SIM card through my page and get 5 pounds free
credit http://t.co/z1KJF5y

------------------------------

Message: 7
Date: Fri, 28 Feb 2014 16:43:40 -0500
From: Nigel Sollars <nsollars@gmail.com>
To: Bristol and Bath Linux User Group <bristol@mailman.lug.org.uk>
Subject: Re: [bristol] Introducing myself
Message-ID:
<CAG6aBkXhCg3wMXBv=KH5MZJpG0AcT3zLf0=CeNAu-iW7JpYr3A@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

Hi,

Welcome aboard,

As an off topic, I will be back in Bristol in June ( 24th ) until July
14th, I was hoping to meet up with everyone. Can someone point out if
there is a meeting within that scope?.

Living in Florida leaves me with a rather hefty mileage deficit.

Regards
Nige

On Fri, Feb 28, 2014 at 4:12 PM, David Fear <david@dfear.co.uk> wrote:

> On 28/02/14 20:29, Adrian Portway wrote:
>
>> Hi everyone, just joined the mailing list and thought I'd introduce
>> myself.
>>
>> My name is Adrian Portway, I'm based in Chard. Been using Linux for
>> about 10 years or so starting with Mandrake 9 on an old Dell Inspiron
>> laptop.
>>
>> I work as IT Manager at a firm in Devon looking after the desktops (
>> mostly Windows ) and servers ( all Linux ).
>>
>> Hopefully I'll be able to get up to Bristol to meet a few of you some
>> time.
>>
>> Cheers,
>>
>> Adrian
>>
>>
>>
>> _______________________________________________
>> Bristol mailing list
>> Bristol@mailman.lug.org.uk
>> https://mailman.lug.org.uk/mailman/listinfo/bristol
>>
>> Hi
>
> Welcome to the group. Hope to see you at one of the monthly meetups.
> Meetings every 4th Saturday of each month at the Knights Templar pub at
> Temple Quays Bristol starting from 1-30PM. For details:
> http://www.bristol.lug.org.uk/.
>
> Also you might be interested in coming to the event we are holding on
> Saturday 15th March at Pervasive Media Studio (Watershed) in Bristol. It's
> called "LinuxLive 2014" and it's being held to showcase how great linux is
> and as alternative to Windows XP. If you would like more info go to:
> www.linuxlive.co.uk.
>
>
> --
> Regards
>
> -----------------------------------
> Dave Fear :: david@dfear.co.uk
>
> Order your free giffgaff SIM card through my page and get 5 pounds free
> credit http://t.co/z1KJF5y
>
> _______________________________________________
> Bristol mailing list
> Bristol@mailman.lug.org.uk
> https://mailman.lug.org.uk/mailman/listinfo/bristol
>

--
"Science is a differential equation. Religion is a boundary condition."

Alan Turing
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.lug.org.uk/mailman/private/bristol/attachments/20140228/afb8e585/attachment.html>

------------------------------

_______________________________________________
Bristol mailing list
Bristol@mailman.lug.org.uk
https://mailman.lug.org.uk/mailman/listinfo/bristol

End of Bristol Digest, Vol 539, Issue 11
****************************************

Kamis, 27 Februari 2014

Bristol Digest, Vol 539, Issue 10

Rabu, 26 Februari 2014

Bristol Digest, Vol 539, Issue 9

Selasa, 25 Februari 2014

Bristol Digest, Vol 539, Issue 8

Send Bristol mailing list submissions to
bristol@mailman.lug.org.uk

To subscribe or unsubscribe via the World Wide Web, visit
https://mailman.lug.org.uk/mailman/listinfo/bristol
or, via email, send a message with subject or body 'help' to
bristol-request@mailman.lug.org.uk

You can reach the person managing the list at
bristol-owner@mailman.lug.org.uk

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Bristol digest..."

Today's Topics:

1. Re: Opamp - somewhat off topic (Allen Coates)
2. Re: Slony probs (Martin Moore)
3. Re: Slony probs (Colin M. Strickland)
4. Re: Slony probs (Martin Moore)
5. Re: Slony probs (Martin Moore)
6. Re: Opamp - somewhat off topic (david)

----------------------------------------------------------------------

Message: 1
Date: Tue, 25 Feb 2014 12:04:02 +0000
From: Allen Coates <linux@cidercounty.org.uk>
To: Bristol and Bath Linux User Group <bristol@mailman.lug.org.uk>
Subject: Re: [bristol] Opamp - somewhat off topic
Message-ID: <530C86B2.3060006@cidercounty.org.uk>
Content-Type: text/plain; charset=ISO-8859-1

Dave SMITH wrote:
> On 25/02/2014 01:35, Allen Coates wrote:
>> The open-loop gain of an opamp is (theoretically) infinite - in practice
>> tens of thousands. You set the stage gain using feedback resistors.
>>
>> If you amplify an analogue signal 400 times, I have a feeling you would
>> encounter problems with input noise.
>>
>> It may be better to use the opamp as a comparator, where the output is
>> logic zero if the input is below an (adjustable) threshold level, and
>> logic one if it is above. Two such comparators would give you a clear
>> Low/Acceptable/High indication.
>
> Good point, and you could then feed the result into a digital IO rather
> than needing an analogue input.
>
> I'm not sure I'd do a comparator at such low voltages, though - after
> all, the obvious way to generate the threshold voltage would be through
> a resistive voltage divider, but even if you use resistors with 1%
> tolerance (about the limit of what is widely available), you're still
> going to end up with a threshold that could vary by as much as 1000%.

I haven't played with load cells, but with strain gauges you would use a
pair of them - or a "rosette" - in a bridge type circuit. It was even
possible to stress one gauge in compression, and its partner in tension
to double the output from the bridge...

> To do the design "right", I think I'd have a first OpAmp stage with a
> gain of somewhere around 20 (giving you a voltage swing of about 100
> mV), and then feed that into a comparator.

I thought of that - just after I had pressed the <SEND> key...

> To make things even better, you could even use a voltage reference IC as
> the input to the voltage divider, so that you get a nice stable supply
> that's not wandering around as the Pi power consumption changes.
> Reference ICs generating a 1.2 V output are cheap (about 30p from RS)
> and readily available, and you'd only need one across all your channels.

Bridges tend to be insensitive to supply voltage fluctuations - but
you're right. Every little helps. I must admit, though, I like "tuning
for zero" on a ten turn pot.

------------------------------

Message: 2
Date: Tue, 25 Feb 2014 14:27:02 -0000
From: "Martin Moore" <martinm@it-helps.co.uk>
To: "'Bristol and Bath Linux User Group'" <bristol@mailman.lug.org.uk>
Subject: Re: [bristol] Slony probs
Message-ID:
<!&!AAAAAAAAAAAYAAAAAAAAAFLxZtQqo65Oo+1jhlUB9DvCgAAAEAAAAH8v8vI3hs5Mv+9gUvbSR5gBAAAAAA==@it-helps.co.uk>

Content-Type: text/plain; charset="us-ascii"

Almost got londiste running - but guess what :

londiste jess2sb3.ini provider install
2014-02-25 14:08:14,472 16014 INFO plpgsql is installed
2014-02-25 14:08:14,474 16014 INFO txid_current_snapshot is installed
2014-02-25 14:08:14,474 16014 INFO pgq is installed
2014-02-25 14:08:14,475 16014 INFO Installing londiste
2014-02-25 14:08:14,475 16014 INFO Reading from
/usr/share/skytools/londiste.sql
Traceback (most recent call last):
File "/usr/bin/londiste", line 134, in <module>
script.start()
File "/usr/bin/londiste", line 97, in start
self.script.start()
File "/usr/lib/python2.7/dist-packages/skytools/scripting.py", line 369,
in start
run_single_process(self, self.go_daemon, self.pidfile)
File "/usr/lib/python2.7/dist-packages/skytools/scripting.py", line 98, in
run_single_process
runnable.run()
File "/usr/lib/python2.7/dist-packages/londiste/setup.py", line 73, in run
self.admin()
File "/usr/lib/python2.7/dist-packages/londiste/setup.py", line 176, in
admin
self.provider_install()
File "/usr/lib/python2.7/dist-packages/londiste/setup.py", line 227, in
provider_install
self.exec_provider(q, [self.pgq_queue_name])
File "/usr/lib/python2.7/dist-packages/londiste/setup.py", line 359, in
exec_provider
src_curs.execute(sql, args)
File "/usr/lib/python2.7/dist-packages/psycopg2/extras.py", line 123, in
execute
return _cursor.execute(self, query, vars)
psycopg2.ProgrammingError: operator is not unique: unknown || integer
LINE 1: SELECT 'pgq.event_' || id
^
HINT: Could not choose a best candidate operator. You might need to add
explicit type casts.
QUERY: SELECT 'pgq.event_' || id
CONTEXT: PL/pgSQL function pgq.create_queue(text) line 34 at assignment

So, I hacked 2 of the pqc functions to cast 'id' to int and all is ok. But
only needed to do this on the provider, not the subscriber. I think there's
something odd with the setup on the provider which was the cause of the
slony problems.

I'll try and find out what's going wrong.

-----Original Message-----
From: bristol-bounces@mailman.lug.org.uk
[mailto:bristol-bounces@mailman.lug.org.uk] On Behalf Of Colin M. Strickland
Sent: 24 February 2014 22:26
To: Martin Moore; Bristol and Bath Linux User Group
Subject: Re: [bristol] Slony probs

On 24 Feb 2014, at 22:06, Martin Moore wrote:

> I'll check out skytools londiste - I only want some tables replicated,
> so can't use the built-in stuff.

Londiste is ideal for this use, (as is slony of course). It's more
lightweight, and I found it more easy to troubleshoot. I replaced the slave
db servers at last.fm replicating a couple of 100GB of catalogue metadata
via slony-1 on pg 8.3 with londiste and pg 9.1 a year or so ago, and found
the migration process fairly painless.

The most significant difference was that the londiste slaves don't enforce
any kind of read-only state on the replica tables, so I had to manage that
with user access control (I used pgbouncer to map any incoming tcp/ip
database connection down to a user with no write access)

Rather than loading scripts into the slightly cranky slonik command parser,
you just interact with the replication agent using command line tools from
the shell - "londiste subscriber add tablename" etc.

--
Regards,
Colin M. Strickland, cms, 'that guy'.

_______________________________________________
Bristol mailing list
Bristol@mailman.lug.org.uk
https://mailman.lug.org.uk/mailman/listinfo/bristol
-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2014.0.4335 / Virus Database: 3705/7092 - Release Date: 02/14/14
Internal Virus Database is out of date.

------------------------------

Message: 3
Date: Tue, 25 Feb 2014 14:44:00 +0000
From: "Colin M. Strickland" <cms@beatworm.co.uk>
To: "Martin Moore" <martinm@it-helps.co.uk>, "Bristol and Bath Linux
User Group" <bristol@mailman.lug.org.uk>
Subject: Re: [bristol] Slony probs
Message-ID: <BCB5DB59-5D67-4D01-97AB-9E30EAE12D9B@beatworm.co.uk>
Content-Type: text/plain; format=flowed

On 25 Feb 2014, at 14:27, Martin Moore wrote:

> psycopg2.ProgrammingError: operator is not unique: unknown || integer
> LINE 1: SELECT 'pgq.event_' || id
> ^
> HINT: Could not choose a best candidate operator. You might need to
> add
> explicit type casts.
> QUERY: SELECT 'pgq.event_' || id
> CONTEXT: PL/pgSQL function pgq.create_queue(text) line 34 at
> assignment

This is the same category of error as before. I would expect the
database to just know how to cast integers to strings. Do you get an
exception thrown if you run something like this on the provider ?

postgres=# select 123 || ' a string ' as demonstration ;
demonstration
---------------
123 a string
(1 row)

Your database seems a bit confused about basic types and operators in a
way I find surprising.

--
Regards,
Colin M. Strickland, cms, 'that guy'.

------------------------------

Message: 4
Date: Tue, 25 Feb 2014 14:55:51 -0000
From: "Martin Moore" <martinm@it-helps.co.uk>
To: "'Bristol and Bath Linux User Group'" <bristol@mailman.lug.org.uk>
Subject: Re: [bristol] Slony probs
Message-ID:
<!&!AAAAAAAAAAAYAAAAAAAAAFLxZtQqo65Oo+1jhlUB9DvCgAAAEAAAAFlbBE6YKl5Ls4Q2aOxyibwBAAAAAA==@it-helps.co.uk>

Content-Type: text/plain; charset="us-ascii"

select 123 || ' a string ' as demonstration ;

does indeed fail. So, I removed the cast/function I added to get 8.4 working
and it bursts into life. Obviously some work has been done on autocasting
between 8.4 and 9.3!!

I'll try slony again as we have no experience of londiste, although it does
look god.

-----Original Message-----
From: bristol-bounces@mailman.lug.org.uk
[mailto:bristol-bounces@mailman.lug.org.uk] On Behalf Of Colin M. Strickland
Sent: 25 February 2014 14:44
To: Martin Moore; Bristol and Bath Linux User Group
Subject: Re: [bristol] Slony probs

On 25 Feb 2014, at 14:27, Martin Moore wrote:

> psycopg2.ProgrammingError: operator is not unique: unknown || integer
> LINE 1: SELECT 'pgq.event_' || id
> ^
> HINT: Could not choose a best candidate operator. You might need to
> add explicit type casts.
> QUERY: SELECT 'pgq.event_' || id
> CONTEXT: PL/pgSQL function pgq.create_queue(text) line 34 at
> assignment

This is the same category of error as before. I would expect the database to
just know how to cast integers to strings. Do you get an exception thrown if
you run something like this on the provider ?

postgres=# select 123 || ' a string ' as demonstration ;
demonstration
---------------
123 a string
(1 row)

Your database seems a bit confused about basic types and operators in a way
I find surprising.

--
Regards,
Colin M. Strickland, cms, 'that guy'.

_______________________________________________
Bristol mailing list
Bristol@mailman.lug.org.uk
https://mailman.lug.org.uk/mailman/listinfo/bristol
-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2014.0.4335 / Virus Database: 3705/7092 - Release Date: 02/14/14
Internal Virus Database is out of date.

------------------------------

Message: 5
Date: Tue, 25 Feb 2014 15:09:11 -0000
From: "Martin Moore" <martinm@it-helps.co.uk>
To: "'Bristol and Bath Linux User Group'" <bristol@mailman.lug.org.uk>
Subject: Re: [bristol] Slony probs
Message-ID:
<!&!AAAAAAAAAAAYAAAAAAAAAFLxZtQqo65Oo+1jhlUB9DvCgAAAEAAAAM3MIlbldE1LkZaHY9uVa9kBAAAAAA==@it-helps.co.uk>

Content-Type: text/plain; charset="us-ascii"

Slony has now installed OK. (at least without errors!).

Thanks for your help - that must be the hardest way to find out why slony
wasn't installing....

Martin.

-----Original Message-----
From: bristol-bounces@mailman.lug.org.uk
[mailto:bristol-bounces@mailman.lug.org.uk] On Behalf Of Colin M. Strickland
Sent: 25 February 2014 14:44
To: Martin Moore; Bristol and Bath Linux User Group
Subject: Re: [bristol] Slony probs

On 25 Feb 2014, at 14:27, Martin Moore wrote:

> psycopg2.ProgrammingError: operator is not unique: unknown || integer
> LINE 1: SELECT 'pgq.event_' || id
> ^
> HINT: Could not choose a best candidate operator. You might need to
> add explicit type casts.
> QUERY: SELECT 'pgq.event_' || id
> CONTEXT: PL/pgSQL function pgq.create_queue(text) line 34 at
> assignment

This is the same category of error as before. I would expect the database to
just know how to cast integers to strings. Do you get an exception thrown if
you run something like this on the provider ?

postgres=# select 123 || ' a string ' as demonstration ;
demonstration
---------------
123 a string
(1 row)

Your database seems a bit confused about basic types and operators in a way
I find surprising.

--
Regards,
Colin M. Strickland, cms, 'that guy'.

_______________________________________________
Bristol mailing list
Bristol@mailman.lug.org.uk
https://mailman.lug.org.uk/mailman/listinfo/bristol
-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2014.0.4335 / Virus Database: 3705/7092 - Release Date: 02/14/14
Internal Virus Database is out of date.

------------------------------

Message: 6
Date: Tue, 25 Feb 2014 19:04:46 +0000
From: david <david@avoncliff.com>
To: bristol@mailman.lug.org.uk
Subject: Re: [bristol] Opamp - somewhat off topic
Message-ID: <530CE94E.3050807@avoncliff.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

On 24/02/14 12:44, Andrew wrote:

> We are using a load cell to measure the amount of ink. It gives an
> output of about 5 mV. As stated by a helper "The input range on the
> Custard Pi 3 is from 0 to 2.5V. So to get the best accuracy from this
> load cell, we need an amplification of around 400 using an opamp."

I am coming a bit late to this conversation, but the Raspberry does not
have an analogue to digital input. I am not sure what they are referring
to on the Custard, but I guess that is the range of volts the digital
ports can cope with.

I would recommend using an external A->D chip, and selecting one that
has the accuracy you need at low voltage. Maybe still with low gain
amplifier, say 10x. Try search "precision fixed gain op amp"

Search "Raspberry Analogue Input" gives plenty of hits.

( I am sure I have got some 40 year old 741's around here somewhere )

David

------------------------------

_______________________________________________
Bristol mailing list
Bristol@mailman.lug.org.uk
https://mailman.lug.org.uk/mailman/listinfo/bristol

End of Bristol Digest, Vol 539, Issue 8
***************************************

Bristol Digest, Vol 539, Issue 7

Send Bristol mailing list submissions to
bristol@mailman.lug.org.uk

To subscribe or unsubscribe via the World Wide Web, visit
https://mailman.lug.org.uk/mailman/listinfo/bristol
or, via email, send a message with subject or body 'help' to
bristol-request@mailman.lug.org.uk

You can reach the person managing the list at
bristol-owner@mailman.lug.org.uk

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Bristol digest..."

Today's Topics:

1. Re: Opamp - somewhat off topic (david.smith@ds-electronics.co.uk)
2. Re: Slony probs (Martin Moore)
3. Re: Slony probs (Colin M. Strickland)
4. Re: Opamp - somewhat off topic (Allen Coates)
5. Re: Opamp - somewhat off topic (Dave SMITH)

----------------------------------------------------------------------

Message: 1
Date: Mon, 24 Feb 2014 21:35:08 +0000
From: david.smith@ds-electronics.co.uk
To: bristol@mailman.lug.org.uk
Subject: Re: [bristol] Opamp - somewhat off topic
Message-ID:
<686d1d7979c391b80da700cf6105bb259390a523@webmail.eclipse.net.uk>
Content-Type: text/plain; charset="utf-8"

?

----- Original Message -----
From: "Andrew"
Thanks for that.

Is there such a thing as 4 or 5 of these on a board, or even 10? We
are thinking of setting it up to do several in parallel.

Well, if you'd told me that.... :)

In that case, I'd look at something like the MCP6004-I/P - four on a
chip.? Whether you use single, dual or quad-device ICs, you won't
get them "on a board" - you'll need to build your own board, but if
you don't want to go to the lengths of doing a PCB design, you can
just use Veroboard (or similar) for something this simple, or maybe
your Pi extension board has a little prototyping area?

You can get 8 devices on a single chip, but then you're starting to
get into packages that don't play well with Veroboard/breadboard so
you would have to design a "proper" PCB or do a really nasty hack.

Also, look at buying them from RS rather than eBay - eBay price is
?2.66 each, RS price is 31p+VAT with an order multiple of 10 - so,
for ?3.72 you'll get 10 quad-device chips, which is cheaper than two
from eBay.? I guess it depends on how easy it is for you to get to
their trade counter in St Philips.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.lug.org.uk/mailman/private/bristol/attachments/20140224/a651067a/attachment-0001.html>

------------------------------

Message: 2
Date: Mon, 24 Feb 2014 22:06:28 -0000
From: "Martin Moore" <martinm@it-helps.co.uk>
To: "'Bristol and Bath Linux User Group'" <bristol@mailman.lug.org.uk>
Subject: Re: [bristol] Slony probs
Message-ID:
<!&!AAAAAAAAAAAYAAAAAAAAAFLxZtQqo65Oo+1jhlUB9DvCgAAAEAAAAI/62qywx4dHuYnJUqWliWYBAAAAAA==@it-helps.co.uk>

Content-Type: text/plain; charset="us-ascii"

Thanks Colin - Slony was removed from the dump (I think!) so should be OK
there, and the server is a clean install. I did look at the slony functions
but still can't see what the problem is - and I don't want to start playing
around in that area !!

I'll check out skytools londiste - I only want some tables replicated, so
can't use the built-in stuff.

Martin

-----Original Message-----
From: bristol-bounces@mailman.lug.org.uk
[mailto:bristol-bounces@mailman.lug.org.uk] On Behalf Of Colin M. Strickland
Sent: 24 February 2014 21:33
To: Martin Moore; Bristol and Bath Linux User Group
Subject: Re: [bristol] Slony probs

On 24 Feb 2014, at 15:17, Martin Moore wrote:

> I've restored a postgres 8.4 database onto a 9.3 installation (on
> Debian Jessie).
>
> Running a script (as used in 8.4 so may need to be changed, but can't
> find
> anything) which contains the following
>
>

Hmm, slony can be brittle. All of your errors seem to be thrown from inside
the slony stored procedures where attempts to cast ints to text.
I'm afraid I haven't worked with it for a couple of years now, and my memory
is rusty :-/

A couple of thoughts. There was a change in implicit casting behaviour
between 8.2 and 8.3 after which all sorts of implied casts to text types
stopped working without explicit type casting. Is it possible you've got
some pre 8.3 stored procedure code installed into the 9.3 database somehow?

How did the slony code get installed ? I'm not sure you can reliably deploy
the slony server components into a database via a pg_dump, might that have
happened. I think you might need to install slony separately from your
database restore, load your dataset and then rebuild the slony replication
sets and resync your slaves from scratch.

If you don't absolutely have to go with slony for userspace replication, I'd
suggest looking into skytools londiste as a fairly drop-in replacement. It's
a little bit more robust than slony, works on basically the same principles,
and the python user tools are nice and simple to use IMO. (You might also be
able to use 9.3 streaming replication instead of trigger-based replication,
if your replication requirement is to slave your entire dataset)

Sorry if I'm failing to address your actual question usefully, I don't have
a slony installation to hand to inspect. If I did, I'd be tempted to examine
the source of those sprocs and hand-reproduce the error by calling them
directly with similar arguments.

Regards,
Colin M. Strickland, cms, 'that guy'.

_______________________________________________
Bristol mailing list
Bristol@mailman.lug.org.uk
https://mailman.lug.org.uk/mailman/listinfo/bristol
-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2014.0.4335 / Virus Database: 3705/7092 - Release Date: 02/14/14
Internal Virus Database is out of date.

------------------------------

Message: 3
Date: Mon, 24 Feb 2014 22:25:55 +0000
From: "Colin M. Strickland" <cms@beatworm.co.uk>
To: "Martin Moore" <martinm@it-helps.co.uk>, "Bristol and Bath Linux
User Group" <bristol@mailman.lug.org.uk>
Subject: Re: [bristol] Slony probs
Message-ID: <42CDB4DB-43D4-42FA-AF92-4A4C3607588C@beatworm.co.uk>
Content-Type: text/plain; format=flowed

On 24 Feb 2014, at 22:06, Martin Moore wrote:

> I'll check out skytools londiste - I only want some tables replicated,
> so
> can't use the built-in stuff.

Londiste is ideal for this use, (as is slony of course). It's more
lightweight, and I found it more easy to troubleshoot. I replaced the
slave db servers at last.fm replicating a couple of 100GB of catalogue
metadata via slony-1 on pg 8.3 with londiste and pg 9.1 a year or so
ago, and found the migration process fairly painless.

The most significant difference was that the londiste slaves don't
enforce any kind of read-only state on the replica tables, so I had to
manage that with user access control (I used pgbouncer to map any
incoming tcp/ip database connection down to a user with no write access)

Rather than loading scripts into the slightly cranky slonik command
parser, you just interact with the replication agent using command line
tools from the shell - "londiste subscriber add tablename" etc.

--
Regards,
Colin M. Strickland, cms, 'that guy'.

------------------------------

Message: 4
Date: Tue, 25 Feb 2014 00:35:10 +0000
From: Allen Coates <linux@cidercounty.org.uk>
To: andrew@1dtv.com, Bristol and Bath Linux User Group
<bristol@mailman.lug.org.uk>
Subject: Re: [bristol] Opamp - somewhat off topic
Message-ID: <530BE53E.70404@cidercounty.org.uk>
Content-Type: text/plain; charset=ISO-8859-1

The open-loop gain of an opamp is (theoretically) infinite - in practice
tens of thousands. You set the stage gain using feedback resistors.

If you amplify an analogue signal 400 times, I have a feeling you would
encounter problems with input noise.

It may be better to use the opamp as a comparator, where the output is
logic zero if the input is below an (adjustable) threshold level, and
logic one if it is above. Two such comparators would give you a clear
Low/Acceptable/High indication.

Hope this helps

Allen C

Andrew wrote:
> Greetings luggers
>
> Still progressing slowly on the project to get a raspberry pi working to
> fill ink cartridges.
>
> We are using a load cell to measure the amount of ink. It gives an
> output of about 5 mV. As stated by a helper "The input range on the
> Custard Pi 3 is from 0 to 2.5V. So to get the best accuracy from this
> load cell, we need an amplification of around 400 using an opamp."
>
> Does anyone know if I can get this opamp off the shelf, or whether it
> would have to be custom made.
>
> Thanks
>
> Andrew
>
>
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Bristol mailing list
> Bristol@mailman.lug.org.uk
> https://mailman.lug.org.uk/mailman/listinfo/bristol

------------------------------

Message: 5
Date: Tue, 25 Feb 2014 11:35:41 +0100
From: Dave SMITH <Dave.Smith@st.com>
To: <bristol@mailman.lug.org.uk>
Subject: Re: [bristol] Opamp - somewhat off topic
Message-ID: <530C71FD.2090303@st.com>
Content-Type: text/plain; charset="ISO-8859-1"

On 25/02/2014 01:35, Allen Coates wrote:
> The open-loop gain of an opamp is (theoretically) infinite - in practice
> tens of thousands. You set the stage gain using feedback resistors.
>
> If you amplify an analogue signal 400 times, I have a feeling you would
> encounter problems with input noise.
>
> It may be better to use the opamp as a comparator, where the output is
> logic zero if the input is below an (adjustable) threshold level, and
> logic one if it is above. Two such comparators would give you a clear
> Low/Acceptable/High indication.

Good point, and you could then feed the result into a digital IO rather
than needing an analogue input.

I'm not sure I'd do a comparator at such low voltages, though - after
all, the obvious way to generate the threshold voltage would be through
a resistive voltage divider, but even if you use resistors with 1%
tolerance (about the limit of what is widely available), you're still
going to end up with a threshold that could vary by as much as 1000%.

To do the design "right", I think I'd have a first OpAmp stage with a
gain of somewhere around 20 (giving you a voltage swing of about 100
mV), and then feed that into a comparator.

To make things even better, you could even use a voltage reference IC as
the input to the voltage divider, so that you get a nice stable supply
that's not wandering around as the Pi power consumption changes.
Reference ICs generating a 1.2 V output are cheap (about 30p from RS)
and readily available, and you'd only need one across all your channels.

------------------------------

_______________________________________________
Bristol mailing list
Bristol@mailman.lug.org.uk
https://mailman.lug.org.uk/mailman/listinfo/bristol

End of Bristol Digest, Vol 539, Issue 7
***************************************

Senin, 24 Februari 2014

Bristol Digest, Vol 539, Issue 6

Bristol Digest, Vol 539, Issue 5

Bristol Digest, Vol 539, Issue 4

Send Bristol mailing list submissions to
bristol@mailman.lug.org.uk

To subscribe or unsubscribe via the World Wide Web, visit
https://mailman.lug.org.uk/mailman/listinfo/bristol
or, via email, send a message with subject or body 'help' to
bristol-request@mailman.lug.org.uk

You can reach the person managing the list at
bristol-owner@mailman.lug.org.uk

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Bristol digest..."

Today's Topics:

1. Re: Opamp - somewhat off topic (Matt Dainty)
2. Re: Thoughts on WhatsApp? (Tim Wintle)
3. Re: Opamp - somewhat off topic (Andrew)
4. Re: Opamp - somewhat off topic (Peter Hemmings)
5. quad core blimey (Andrew)
6. Slony probs (Martin Moore)

----------------------------------------------------------------------

Message: 1
Date: Mon, 24 Feb 2014 09:02:12 -0500
From: Matt Dainty <matt@bodgit-n-scarper.com>
To: Bristol and Bath Linux User Group <bristol@mailman.lug.org.uk>
Subject: Re: [bristol] Opamp - somewhat off topic
Message-ID: <20140224140212.GR2245@simulant.bodgit-n-scarper.com>
Content-Type: text/plain; charset="us-ascii"

* Dave SMITH <Dave.Smith@st.com> [2014-02-24 08:50:44]:
> On 24/02/2014 14:25, Andrew wrote:
> > How do I define what I am looking for as the opamp itself, on ebay or
> > elsewhere. This is the bit I was getting really frustrated with - it
> > seems like a whole language defining these kinds of things.
>
> You just want a general-purpose OpAmp. I don't have any datasheets to
> hand so I'm not sure what to recommend I'm afraid. Many years ago, the
> standard would've been the 741, but that's been well and truly
> superceeded nowadays. When I've got a bit of time (I'm currently at
> work in a meeting), I'll do a bit more digging around to give you some
> suggestions.
>
> In reality, however, virtually any OpAmp you can buy will probably do
> what you want, as your requirements are not particularly taxing.

I was looking at a circuit for use with a Pi that featured an OpAmp and
that used a CA3140 part. I note in the features it's a replacement for
the 741 that Dave suggested.

HTH

Matt
--
"Phased plasma rifle in a forty-watt range?"
"Hey, just what you see, pal."
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <https://mailman.lug.org.uk/mailman/private/bristol/attachments/20140224/8c2c3fb1/attachment-0001.pgp>

------------------------------

Message: 2
Date: Mon, 24 Feb 2014 14:08:11 +0000
From: Tim Wintle <timwintle@gmail.com>
To: Bristol and Bath Linux User Group <bristol@mailman.lug.org.uk>
Subject: Re: [bristol] Thoughts on WhatsApp?
Message-ID: <1393250891.15643.8.camel@tim-desktop>
Content-Type: text/plain; charset="UTF-8"

On Sun, 2014-02-23 at 20:09 +0000, Mike Yates wrote:
> For those who haven't noticed, the price paid by Facebook for WhatsApp
> is the result of the latter's abuse of Android (and IOS)
> "Permissions".

I'm going to dispute that statement ..

All the big names aren't necessarily trying to grab cash out of mobiles
at the moment: They just want to be in a market-leading position to make
money out of stuff once that happens.

The money-centre of mobile hasn't been defined yet: it could be payments
(i.e. mobile payments with NFC are trying to take over from credit card
companies), it could be media rentals (e.g. Google Play), or it could be
something completely different.

i.e. Facebook were willing to pay that (frankly rediculous) price for
Whatsapp because they don't want another competitor in the field. Google
apparently bid the price up that far: presumably because they want
hangouts to be *the* way that people communicate in a post-sms and
standard phone call world.

Twitter is still afloat for the same reason: having the eyeballs *might*
lead to some way to make money in the future, even though there's no
prospect right at the moment.

I.e. the value is about owning the user's experience: not about the
contacts. I honestly think the fact your phonebook gets uploaded to
whatsapp is due to no more than dumb systems design.

Tim

------------------------------

Message: 3
Date: Mon, 24 Feb 2014 14:12:19 +0000
From: Andrew <andrewsoltau@gmail.com>
To: Bristol and Bath Linux User Group <bristol@mailman.lug.org.uk>
Subject: Re: [bristol] Opamp - somewhat off topic
Message-ID: <530B5343.9080000@1dtv.com>
Content-Type: text/plain; charset="iso-8859-1"; Format="flowed"

On 24/02/14 14:02, Matt Dainty wrote:
> * Dave SMITH <Dave.Smith@st.com> [2014-02-24 08:50:44]:
>> On 24/02/2014 14:25, Andrew wrote:
>>> How do I define what I am looking for as the opamp itself, on ebay or
>>> elsewhere. This is the bit I was getting really frustrated with - it
>>> seems like a whole language defining these kinds of things.
>> You just want a general-purpose OpAmp. I don't have any datasheets to
>> hand so I'm not sure what to recommend I'm afraid. Many years ago, the
>> standard would've been the 741, but that's been well and truly
>> superceeded nowadays. When I've got a bit of time (I'm currently at
>> work in a meeting), I'll do a bit more digging around to give you some
>> suggestions.
>>
>> In reality, however, virtually any OpAmp you can buy will probably do
>> what you want, as your requirements are not particularly taxing.
> I was looking at a circuit for use with a Pi that featured an OpAmp and
> that used a CA3140 part. I note in the features it's a replacement for
> the 741 that Dave suggested.
>
> HTH
>
> Matt
Thank you Matt, a help indeed. And they are cheap and plentiful on Ebay.
Seems like the problem is solved.

Andrew
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.lug.org.uk/mailman/private/bristol/attachments/20140224/95b86651/attachment-0001.html>

------------------------------

Message: 4
Date: Mon, 24 Feb 2014 14:16:20 +0000
From: Peter Hemmings <peter@hemmings.eclipse.co.uk>
To: andrew@1dtv.com, Bristol and Bath Linux User Group
<bristol@mailman.lug.org.uk>
Subject: Re: [bristol] Opamp - somewhat off topic
Message-ID: <530B5434.3090409@hemmings.eclipse.co.uk>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

On 24/02/14 13:25, Andrew wrote:
> On 24/02/14 13:13, Dave SMITH wrote:
>> On 24/02/2014 13:46, Andrew wrote:
>>> ps I forgot to mention that I have done a load of googling but I am not
>>> coming up with anything I understand.
>> Have a look at the "closed loop, non-inverting" section of the OpAmp
>> page on Wikipedia. There's a circuit diagram showing how you connect up
>> an OpAmp with two resistors to define the gain you want.
>>
> Thanks Dave. That looks really simple.
>
> How do I define what I am looking for as the opamp itself, on ebay or
> elsewhere. This is the bit I was getting really frustrated with - it
> seems like a whole language defining these kinds of things.

Sorry for butting in Dave,

"Core blimey" (London Accent) I never thought these still existed! I
remember them from many years ago (more the 40!).

Generally if you are designating a circuit you should have an idea of
what you want regards supply voltage and type of encapsulation etc. If
you are makin a high gain amp you may have to remove any offset voltage
or buy an amp that can compensate for it. Bandwidth also varies with
feedback (as I recall) but should not be a problem with your use.

When these came out, they revolutionized the electronics industry as
they could be used in so many different ways and were so cheap (ah those
were the days).

PS just saw other posts, there are a lot more on this list with newer
knowledge on OpAmps than me, good luck.

(goes back to armchair to relax in the knowledge that some thing learnt
many years ago are still extant!)

> Andrew
>
>
>
> _______________________________________________
> Bristol mailing list
> Bristol@mailman.lug.org.uk
> https://mailman.lug.org.uk/mailman/listinfo/bristol
>

--
Peter H

------------------------------

Message: 5
Date: Mon, 24 Feb 2014 14:43:53 +0000
From: Andrew <andrewsoltau@gmail.com>
To: Bristol and Bath Linux User Group <bristol@mailman.lug.org.uk>
Subject: [bristol] quad core blimey
Message-ID: <530B5AA9.3020009@1dtv.com>
Content-Type: text/plain; charset="iso-8859-1"; Format="flowed"

On 24/02/14 14:16, Peter Hemmings wrote:
> "Core blimey" (London Accent) I never thought these still existed! I
> remember them from many years ago (more the 40!).
Things certainly change. It used to be Cor blimey. I presume you are on
the new quad core blimey!

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.lug.org.uk/mailman/private/bristol/attachments/20140224/12e39538/attachment-0001.html>

------------------------------

Message: 6
Date: Mon, 24 Feb 2014 15:17:36 -0000
From: "Martin Moore" <martinm@it-helps.co.uk>
To: "'Bristol and Bath Linux User Group'" <bristol@mailman.lug.org.uk>
Subject: [bristol] Slony probs
Message-ID:
<!&!AAAAAAAAAAAYAAAAAAAAAFLxZtQqo65Oo+1jhlUB9DvCgAAAEAAAALlZF0q9paZLhHF4LtCdbT0BAAAAAA==@it-helps.co.uk>

Content-Type: text/plain; charset="us-ascii"

I've restored a postgres 8.4 database onto a 9.3 installation (on Debian
Jessie).

Running a script (as used in 8.4 so may need to be changed, but can't find
anything) which contains the following

define CLUSTER T1;
define PRIMARY 1;
define SLAVE 10;
cluster name = @CLUSTER;
define origin1 origin = @PRIMARY;
define origin2 origin = @SLAVE;
define primary id = @PRIMARY;
define slave id = @SLAVE;
define set_user_admin id = 10001;

node @PRIMARY admin conninfo = 'dbname=myname host=localhost user=slony';

node @SLAVE admin conninfo = 'dbname=myname host=slave.host.com user=slony';
create set (id = 10001, @origin1, comment = 'user_admin');
set add table (set @set_user_admin, @origin1, id = 10002, full qualified
name = 'public.users', comment = 'Table public.users');

fails as below.

./addsst.slonik:3: WARNING: Auto-casting int to text: 10001
CONTEXT: PL/pgSQL function "_T1".storeset(integer,text) line 11 at RETURN
./addsst.slonik:3: WARNING: Auto-casting int to text: 1
CONTEXT: PL/pgSQL function "_T1".storeset(integer,text) line 11 at RETURN
./addsst.slonik:4: WARNING: Auto-casting int to text: 10002
CONTEXT: PL/pgSQL function "_T1".altertableaddtriggers(integer) line 53 at
EXECUTE statement
SQL statement "SELECT "_T1".alterTableAddTriggers(p_tab_id)"
PL/pgSQL function "_T1".setaddtable_int(integer,integer,text,name,text) line
99 at PERFORM
SQL statement "SELECT "_T1".setAddTable_int(p_set_id, p_tab_id, p_fqname,
p_tab_idxname, p_tab_comment)"
PL/pgSQL function "_T1".setaddtable(integer,integer,text,name,text) line 28
at PERFORM
./addsst.slonik:4: PGRES_FATAL_ERROR lock table "_T1".sl_config_lock;select
"_T1".setAddTable(10001, 10002, 'public.users', 'users_pkey', 'Table
public.users'); - ERROR: operator is not unique: text || integer
LINE 3: '"_T1".log_truncate(' || i_tabid || ');'
^
HINT: Could not choose a best candidate operator. You might need to add
explicit type casts.
QUERY: SELECT 'create trigger "_T1_truncatetrigger" ' ||
' before truncate on ' || i_fqtable || ' for
each statement execute procedure ' ||
'"_T1".log_truncate(' || i_tabid || ');'
CONTEXT: PL/pgSQL function "_T1".altertableaddtruncatetrigger(text,integer)
line 3 at EXECUTE statement
SQL statement "SELECT "_T1".alterTableAddTruncateTrigger(v_tab_fqname,
p_tab_id)"
PL/pgSQL function "_T1".altertableaddtriggers(integer) line 65 at PERFORM
SQL statement "SELECT "_T1".alterTableAddTriggers(p_tab_id)"
PL/pgSQL function "_T1".setaddtable_int(integer,integer,text,name,text) line
99 at PERFORM
SQL statement "SELECT "_T1".setAddTable_int(p_set_id, p_tab_id, p_fqname,
p_tab_idxname, p_tab_comment)"
PL/pgSQL function "_T1".setaddtable(integer,integer,text,name,text) line 28
at PERFORM

Any ideas? Or even a slony/postgres forum that is lively!

Martin

------------------------------

_______________________________________________
Bristol mailing list
Bristol@mailman.lug.org.uk
https://mailman.lug.org.uk/mailman/listinfo/bristol

End of Bristol Digest, Vol 539, Issue 4
***************************************