PG_statement_type, const char *,...);
--
The changes to the ECPGdo prototype were made during 8.3 development
(REL8_2_STABLE) and were checked in 2007/08/14 (version 1.71 of ecpglib.h) by
user 'meskes'.
--
Any suggestions very much appreciated!
Peter Wilson
--
h
Michael Meskes wrote:
On Fri, Jan 11, 2008 at 11:51:08PM +, Peter Wilson wrote:
I've just tried compiling our project against the 8.3RC1 code. This is
the first time I've tried any release of 8.3.
...
crbembsql.pgC:254: error: invalid conversion from `int' to `ECPG
Michael Meskes wrote:
On Sun, Jan 13, 2008 at 03:01:04PM +, Peter Wilson wrote:
that fixes that problem. My build now gets further, but I get an error
and a seg-fault later in the build.
Whow, you're really stress testing it. Thanks a lot! This is what we
need.
I have to say I d
That it had been her opinion, till now, she was not guilty of
Adam's sin, nor any way concerned in it, because she was not active in
it; but that now she saw she was guilty of that sin, and all over
defiled by it; and the sin which she brought into the world with her,
was alone sufficient to condem
them. Every one can say this; every one can call
himself a prophet. But I see that Christian religion wherein prophecies are
fulfilled; and that is what every one cannot do.
694. And what crowns all this is prediction, so that it should not be said
that it is chance which has done it?
Whosoever,
th is propogating schema changes - because (I think) you can
attach triggers to schema changes.
Thanks.
Gordan
Pete
--
Peter Wilson : http://www.whitebeam.org
---(end of broadcast)---
TIP 6: explain analyze is your friend
-
TIP 6: explain analyze is your friend
--
--------
Peter Wilson
T: 01707 891840
M: 07796 656566
http://www.yellowhawk.co.uk The information in this email is
confidential and is intended for the addressee/s
Dave Page wrote:
On Jan 30, 2008 1:34 PM, Peter Wilson <[EMAIL PROTECTED]> wrote:
Dave Page wrote:
On Jan 30, 2008 12:45 PM, Peter Wilson <[EMAIL PROTECTED]> wrote:
Has anyone else generated a Windows Help version of the manual?
Is it only distributed with the Window
Michael Meskes wrote:
On Mon, Jan 14, 2008 at 10:57:45AM -0500, Tom Lane wrote:
I'm concerned about this too. We'll at least have to call this out as
an incompatibility in 8.3, and it seems like a rather unnecessary step
backwards.
Given that people seem to use this feature I'm more t
Dave Page wrote:
On Jan 30, 2008 12:45 PM, Peter Wilson <[EMAIL PROTECTED]> wrote:
Has anyone else generated a Windows Help version of the manual?
We distribute it with PostgreSQL - it's just not integrated with the
pgAdmin help any more. You can even tell pgAdmin to use
Swaminathan Saikumar wrote:
Hi all,
I'm new to PostGreSql.
http://searchyourwebhost.com/web-hosting/articles/insight-database-hosting-using-sql
What a wonderful article - it's almost worth keeping a copy. It's so bad
it's difficult to know where to start. I think my favourite has to be :
+ MSS
Koen Vermeer wrote:
Hi,
I would like to store binary data in a PostgreSQL database. The size of
the data is about 2 to 20 MB and is always stored or retrieved as a
block (i.e., I do not need to get only part of the data). As I
understand, I have two options for storing this data: As BYTEA or as
Koen Vermeer wrote:
On Wed, 2008-02-13 at 09:35 +, Peter Wilson wrote:
My preference : if I don't need the file-like interface to large objects
I'd use BYTEA every time.
Right, so that basically means that when 'large objects' are files,
which should be sav
Pavan Deolasee wrote:
[...]
I am not suggesting one read-write and many read-only architecture. I am
rather suggesting all read-only systems. I would be interested in this
setup if I run large read-only queries on historical data and need easy
scalability. With read-only setup, you can easily
paul rivers wrote:
Ivan Sergio Borgonovo wrote:
Yeah... but how can I effectively enforce the policy that ALL input
will be passed through prepared statements?
Code reviews are about the only way to enforce this.
That's not entirely true - if you have a policy that says thou-shalt-not-use
cation Perl
script seemed to be rather inefficient, using a lot of regular
expressions to decode field values etc. Perl isn't something I felt too
confident in - and I needed a solution quickly and hence the C++
implementation
Pete
--
Peter Wilson
YellowHawk : http://www.yellowhawk.co.uk
Whiteb
/replicate.rhtm
Pete
Peter Wilson wrote:
Not
sure whether this is any use to anyone, or whether this is the right
list to post to but...
I've just released a C++ implementation of the DBMirror.pl script as
part of Whitebeam (http://www.whitebeam.org). We had *real* performance
issues with the
Vlad wrote:
Hello,
in need to increase reliability of the service (and perhaps eventually
offload main DB server) we are looking to setup replication for the
database server. I found two solutions:
Slony ( http://gborg.postgresql.org/project/slony1/projdisplay.php )
PGCluster ( http://pgfoundry.org
Vlad wrote:
Hello,
in need to increase reliability of the service (and perhaps eventually
offload main DB server) we are looking to setup replication for the
database server. I found two solutions:
Slony ( http://gborg.postgresql.org/project/slony1/projdisplay.php )
PGCluster ( http://pgfo
Joshua D. Drake wrote:
Benjamin Smith wrote:
As a long-time user of Postgres, (First started using it at 7.0) I'm
reading recently that Firebird has been taking off as a database.
Perhaps this is not the best place to ask this, but is there any
compelling advantage to using Firebird over Postgres
Christopher Browne wrote:
Martha Stewart called it a Good Thing when Peter Wilson <[EMAIL PROTECTED]>
wrote:
I looked at Slony, which seems to be a current favourite -but I
couldn't get it working on my database (claimed my tables didn't have
relevant keys - which they do). Slony-
Vlads thread on Slony against PGcluster made me go back to take another
look at Slony. I'd tried to get it going back in February when I needed
to build some replicated databases. Slony was my first choice because it
seemed to be the current 'hot topic'.
I couldn't get it to work - and having t
Grant McLean wrote:
On Thu, 2005-05-05 at 14:16 -0400, Jeff - wrote:
One of the biggest things for Slony is that you can install slony,
set things up and it will bring the slave(s) "up to speed". You
don't need to do an initial data dump (I think you still need to load
the schema on the slav
Andrew Sullivan wrote:
On Thu, May 05, 2005 at 03:35:27PM +0100, Peter Wilson wrote:
Looking at Slony now, can someone tell me what the benefits of Slony are
over DBmirror? As far as I can see:
+ both are async Master->multiple slaves
+ both (I think) can do cascaded replication
This is
://www.whitebeam.org
--
Peter Wilson
T: 01707 891840
M: 07796 656566
http://www.yellowhawk.co.uk
<>
ining column's datatypes do not
match
The index is of no use when you specify no value for main. You want any
row that has any value for main, and a value of 'E' for type. Because
you haven't specified a value for 'main' the only solution i
ld take several minutes just to analyse a command,
not even starting the execution. That was on version 8.0. On version
7.4.x the query never returned at all.
Pete
--
Peter Wilson - YellowHawk Ltd : http://www.yellowhawk.co.uk
---(end of broadcast)-
I was a little busy with deadlines at the time but I saved the database
in it's slow configuration so I could investigate during a quieter period.
I'll do a restore now and see whether I can remember back to April when
I came across this issue.
Pete
Tom Lane wrote:
Peter Wils
Tom Lane wrote:
> Peter Wilson <[EMAIL PROTECTED]> writes:
>> I found a while ago that after inserting a lot of rows into a clean
>> Postgres table it would take several minutes just to analyse a command,
>> not even starting the execution.
>
> Oh? Could you pro
Tom Lane wrote:
Peter Wilson <[EMAIL PROTECTED]> writes:
I found a while ago that after inserting a lot of rows into a clean
Postgres table it would take several minutes just to analyse a command,
not even starting the execution.
Oh? Could you provide a test case for this? I can cer
Tom Lane wrote:
Peter Wilson <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
Oh? Could you provide a test case for this? I can certainly believe
that the planner might choose a bad plan if it has no statistics, but
it shouldn't take a long time to do it.
On investigation the prob
Howard Cole wrote:
Hi,
I am going to create binary objects in a database which are compressed
eml files (1K - 10 Mbytes in size). Am I better using the bytea or large
objects?
Is there still an issue with backup and restore of databases using large
objects with pg_dump/restore?
Thanks in
Joshua D. Drake wrote:
I've just re-written our Whitebeam code to drop large-objects in
favour of BYTEA fields.
All the old problems of large objects in backups exist, but the killer
for us was that none of the current replication systems, at least that
I could find, would replicate large o
Regards,
Dawid
---(end of
broadcast)---
TIP 5: don't forget to increase your free space map settings
--
Peter Wilson
T: 01414 160505
M: 07796 656566
http://www.yellowhawk.co.uk
The information in this email i
I'd start with something fairly straightforward. dbmirror
is very simple but does a lot. There are two parts:
A trigger function and set of database tables to collect
replication data. The trigger function is written is 'C' and
performance is good.
The second part is a Perl script that attaches t
fine.
>>
>> Konrad
>>
>> ---(end of broadcast)---
>> TIP 5: don't forget to increase your free space map settings
>>
>
>
> ---(end of broadcast)---
&
I've just got the following message while trying to restore a database :
pg_restore : [custom archiver] Dumping a specific TOC data block out of order is
not supported without ID on this input stream (fseek required).
The command was :
pg_restore -L /tmp/toc --dbname=whitebeam --disable-triggers
ur application it's worth thinking about what
happens as it starts to get busier. What's your route to scaling? Many web
applications are written to work on a single machine with no thought to what
happens when that reaches the limit, other than get a bigger server.
All the best
Peter Wilson
Jorge Godoy wrote:
> Listmail <[EMAIL PROTECTED]> writes:
>
Yeah yeah, but terminology aside, having 2 or three digits in each
attribute is just wrong!
>>> Terminology aside, why? The unit is "8.1" not "8" and "1". It makes no
>>> sense to say you're on version 8, in the given context, s
Dave Page wrote:
[EMAIL PROTECTED] wrote:
Can you confirm that you don't provide support for Windows Vista for any
release of Postgres. I'm dumbfounded an it appears that you don't
support Vista. If so, are you planning any releases. I have a major
project and was hoping to use Postgres.
Postg
Harald Armin Massa wrote:
I migrated one database from 8.0 to 8.1
That I used to do add "without oids" to all tables.
First step so:
pg_dump --schema-only -U user database
the file was edited, all tables to "withoud oids"; and reloaded in 8.1
After that I
pg_dump --data-only -U user databa
The Whitebeam implementation of DBMirror.pl :
http://www.whitebeam.org/library/guide/TechNotes/replicate.rhtm
is a complete re-write in 'C' which avoids a lot of the text processing, and what text processing is required is done using a state machine rather
than repeated regular expressio
Achilleus Mantzios wrote:
Peter,
It is much more convinient for you to make a test,
(just change the last function in DBmirror.pl), than for me
(grab whitebeam, compile for FreeBSD, etc...)
Of course you would need to use the original .conf format
than the one you are using now.
It would be int
Tony Caduto wrote:
Thank you, however I'm more concerned with:
"PGLA has many advanced features not found in pgAdmin III,".
Aside from it being slightly misleading (not only are there not many
'advanced' things PGLA can do that pgAdmin can't, there are a similar
number that pgAdmin can, that PG
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
Why not replace the whole of PHP/mySQL with Whitebeam(unashamed
plug)/PostgreSQL,
have a complete BSD licensed solution and avoid all this uncertainty :-) ?
--
Peter Wilson
http://ww
Randal L. Schwartz wrote:
Oracle purchases Sleepycat. From what I understand, BerkeleyDB was the
"other" way that MySQL could have transactions if Oracle decided to
restrict InnoDB tables (after purchasing Innobase last year).
Does this mean the other shoe has dropped for MySQL AB?
I think th
falcon wrote:
Hi,
Most of the web applications I work on are nothing more than front-ends
to postgresql. I have used Perl (CGI), Java, C# and am now looking at
Django. Each generation of frameworks lessens the pain of donig
web-apps, but it still seems redundant.
Does any one know of a framewo
[EMAIL PROTECTED] wrote:
Hi,
I'm trying to write a stored procedure that can capture all the changes
to a table and record the changes based on the table's primary key.
I can almost get there but the sticking point is being able to access
the primary key field of the NEW/OLD record in the trigg
Tim Allen wrote:
Kenneth Downs wrote:
GPL is to spread it as far and wide as possible as fast as possible.
LGPL?
My concern would be, I can't use this toolkit for a closed source
application if it is GPL.
That may be your intent (which I actually don't have a business
problem with), I was
louis gonzales wrote:
PHP is one alternative, another is PERL with CGI to write web based
programs that can GET/POST with input/output from the browser, and to
interface with *SQL - i.e. postgresql - you can use PERL's DBI interface
Leif B. Kristensen wrote:
On Tuesday 13. June 2006 15:39, j
Are you just asking random questions? What do you actually want to do? You've
asked how to access Postres from a shell - now you're using 'C'. Are you going
to work your way through Java, Perl and a host of others.
All of this information is *very* clearly available in the manual at:
http://www.
as to go over the internet and suffers not only the
processing time at the database but also the network latency.
But to answer your question - there is *not* coupling between JavaScript and
Postgres. The JavaScript runs on the client, Postgres on the server and PHP as
your intermediary.
Best rega
52 matches
Mail list logo
