On 17 Sep 2003 at 0:16, Tom Lane wrote:
> "scott.marlowe" <[EMAIL PROTECTED]> writes:
> > Not so sure on whether the foot gun is a good idea. We already have .22
> > calibre foot gun (fsync) that makes for pretty big improvements in load
> > speed, and we see people all the time on General and
Ish Ahluwalia <[EMAIL PROTECTED]> writes:
> Thanks for the resply. We're looking to use pgSql in a embedded systems
> environment especially for a telecom switch. Memory may not be that big
> of a issue as we plan to have a reasonable size flash and decent RAM too
> (64 to 128 Mb - which is a
Andrew Rawnsley <[EMAIL PROTECTED]> writes:
> On Tuesday, September 16, 2003, at 03:59 PM, Joshua D. Drake wrote:
>> If someone is willing to pony up 2000.00 per month for a period of at
>> least 6 months, I will dedicated one of my programmers to the task.
> Do the core folk (Tom/Bruce/Jan/etc)
Network Administrator <[EMAIL PROTECTED]> writes:
> PANIC: XLogWrite: write request 5/2D498000 is past end of log 5/2D498000
I'll bet you are running 7.3.3. You need to update to 7.3.4 to escape
this startup bug.
regards, tom lane
---(end of broa
Robert Creager wrote:
Once upon a time (Tue, 16 Sep 2003 12:59:37 -0700)
"Joshua D. Drake" <[EMAIL PROTECTED]> uttered something amazingly similar to:
If someone is willing to pony up 2000.00 per month for a period of at
least 6 months, I will dedicated one of my programmers to the task. So
i
"scott.marlowe" <[EMAIL PROTECTED]> writes:
> Not so sure on whether the foot gun is a good idea. We already have .22
> calibre foot gun (fsync) that makes for pretty big improvements in load
> speed, and we see people all the time on General and Performance running
> production servers with it
Once upon a time (Tue, 16 Sep 2003 12:59:37 -0700)
"Joshua D. Drake" <[EMAIL PROTECTED]> uttered something amazingly similar to:
> If someone is willing to pony up 2000.00 per month for a period of at
> least 6 months, I will dedicated one of my programmers to the task. So
> if you want it bad e
that works too ... basically, adding 'security' for a "load nly" mode
shouldn't be to difficult
On Tue, 16 Sep 2003, scott.marlowe wrote:
> On Tue, 16 Sep 2003, Marc G. Fournier wrote:
>
> >
> >
> > On Tue, 16 Sep 2003, scott.marlowe wrote:
> >
> > > Not so sure on whether the foot gun is a good
On Tue, 16 Sep 2003, Marc G. Fournier wrote:
>
>
> On Tue, 16 Sep 2003, scott.marlowe wrote:
>
> > Not so sure on whether the foot gun is a good idea. We already have .22
> > calibre foot gun (fsync) that makes for pretty big improvements in load
> > speed, and we see people all the time on Ge
On Mon, 2003-09-15 at 21:55, Christopher Browne wrote:
> A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Ron Johnson) wrote:
> > Pardon if this has already been suggested and shot down as impossible
> > or too difficult, etc.
>
> None of this is forcibly the problem.
>
> The _big_
ROTFLMAO!
That's just the trigger I needed for a belly laugh today. Thanks guys!
Marc G. Fournier wrote:
On Tue, 16 Sep 2003, scott.marlowe wrote:
Not so sure on whether the foot gun is a good idea. We already have .22
calibre foot gun (fsync) that makes for pretty big improvements in load
On Tue, 16 Sep 2003, scott.marlowe wrote:
> Not so sure on whether the foot gun is a good idea. We already have .22
> calibre foot gun (fsync) that makes for pretty big improvements in load
> speed, and we see people all the time on General and Performance running
> production servers with it t
Tying to my last post, concerning Joshua's offer to put up the labor
if we can put up the dough, given the
fact that Postgres is still in flux, do you think its even possible to
do some sort of in-place upgrade, not knowing
what may come up when you're writing 7.6?
In other words, if we pony up
Hello,
I would imagine that it would be maintainable but it would be
something that would have to be
constantly maintained from release to release. It would have to become
part of the actual project or
it would die.
The reason I chose six months is that I figure it will be 30 days of
full ti
On Tuesday, September 16, 2003, at 04:51 PM, Marc G. Fournier wrote:
Just curious here ... but, with all the time you've spent pushing for
an
"easy upgrade path", have you looked at the other RDBMSs and how they
deal
with upgrades? I think its going to be a sort of apples-to-oranges
thing,
sinc
As I understand it, changes that require the dump restore fall into two
categories, catalog changes, and on disk format changes. If that's the
case (I'm as likely wrong as right here, I know) then it could be that
most upgrades (say 7.4 to 7.5) could be accomplished more easier than the
occasi
It's be EXTREMELY cool if there was some relationship betweenn the code for;
PITR and
Inplace upgrades
Any possibility of overlaps?
Mike Mascari wrote:
Lamar Owen wrote:
And that has nothing to do with user need as a whole, since the care
level I mentioned is predicated by the develope
Lamar Owen wrote:
> And that has nothing to do with user need as a whole, since the care
> level I mentioned is predicated by the developer interest level. While
> I know, Marc, how the whole project got started (I have read the first
> posts), and I appreciate that you, Bruce, Thomas, and Vadim
> > And that has nothing to do with user need as a whole, since the care
> > level I mentioned is predicated by the developer interest level.
> > While I know, Marc, how the whole project got started (I have read the
> > first posts), and I appreciate that you, Bruce, Thomas, and Vadim
> > starte
Let me run some numbers. I'm interested in the idea, and I think I can
push one of my clients on it.
Do the core folk (Tom/Bruce/Jan/etc) think this is doable with that
sort of time commitment? Is it maintainable over time? Or are we
pissing in the wind?
On Tuesday, September 16, 2003, at 03:5
On Tue, 16 Sep 2003, Tom Lane wrote:
> Christopher Browne <[EMAIL PROTECTED]> writes:
> > Restoring a database involves, for each table:
> > 1. Reading table data from the source file;
> > 2. Writing data to the database file for the table;
> > 3. After that, reading the database file data, and
On Tue, 16 Sep 2003, Edwin Quijada wrote:
>
>
>
>
> Hoii!!
>
> I am creating my struct and I have the question :
> What I must use for character fields char or varchar?
> Which are the differences? and the better
Generally speaking, varchar or text() types are preferred. char() types
are p
Hmmm, ok, I can't retask any of my people or reallocation funds for this year
but I can personally do 5 to 10% of that monthly cost.
Some more people and project plan- then the ball could roll :)
Quoting "Joshua D. Drake" <[EMAIL PROTECTED]>:
>
> >
> > And that has nothing to do with user need
And that has nothing to do with user need as a whole, since the care
level I mentioned is predicated by the developer interest level.
While I know, Marc, how the whole project got started (I have read the
first posts), and I appreciate that you, Bruce, Thomas, and Vadim
started the original c
On Tue, 16 Sep 2003, [iso-8859-1] Benoît Costes wrote:
> Before beginning i want to explain you i'm French and i hope you will excuse my poor
> english
>
> I'm working in a small entreprise and we are looking for a data base for one of our
> products.
> This data base must allow multi sessi
On Tue, 16 Sep 2003, Edwin Quijada wrote:
You need for all non varchar items in select cast to varchar. Try
CAST(column AS VARCHAR) or column::VARCHAR;
regards
Pavel
> I have a trigger when I executed I get this error:
>
> WARNING: Error occurred while executing PL/pgSQL function
> actuali
Christopher Browne <[EMAIL PROTECTED]> writes:
> Restoring a database involves, for each table:
> 1. Reading table data from the source file;
> 2. Writing data to the database file for the table;
> 3. After that, reading the database file data, and
> 4. Writing the sorted bits to the index file
It is fully functional, but has few
packages. I think that docs interfaces and contrib are in separate
packages.
There are also pgsql modules for php that are not
listed under "database" packages but http server or something like
that.
Regards !
- Original Message -
From:
Hi,
I am faced to the following problem:
...
conn.setAutoCommit(false);
String[] val = new String[] {"one", "two", "two", "three" };
for (int i=0; i < nmax; i++) {
try {
PreparedStatement
pst = conn.prepareStatement("INSERT INTO ATEST VALUES (?)");
pst.setString(1, val[i]);
Complete, functional, full blown working
copy. You can even update it to the latest 7.3.4, which if you haven't
started using it yet, is a good idea.
ftp://ftp3.ca.postgresql.org/pub/binary/v7.3.4/RPMS/redhat-9/
Terry FielderManager Software Development and
DeploymentGreat Gulf Homes /
Before beginning i want to explain you i'm French
and i hope you will excuse my poor english
I'm working in a small entreprise and we are
looking for a data base for one of our products.
This data base must allow multi session and a very
important data quantity.
Someone has speak us abo
On 16 Sep 2003 at 14:36, Marek Lewczuk wrote:
> >
> > You want to use the || operator, e.g. 'hello' || ' ' || 'world'
>
> I know that, but in my application (which is working on MySQL now) I
> have many querys which use CONCAT function, so I need to implement this
> function is PG - there is no
>
> You want to use the || operator, e.g. 'hello' || ' ' || 'world'
I know that, but in my application (which is working on MySQL now) I
have many querys which use CONCAT function, so I need to implement this
function is PG - there is no possibility to replace (in short time) all
of my querys.
On Tuesday 16 September 2003 13:45, Marek Lewczuk wrote:
> Hello,
> As I'm in the middle of the migration process form mysql to pg I found
> that there is no CONCAT function which is available in mysql. Can
> anybody tell me how to implement this function using plPERL or plPGSQL
> language ?
You w
Thanks.
There is a connectivity tool, PostgreSQL for 4D, available from
Exenevex at:
http://www.exenevex.com/next/us/prod.php?id=9
Yes, I found that with google.
What exactly are you having trouble with in doing the migration? I ask
as the process is simple enough that a tool for doing the
On 09/16/2003 at 13:47 it was written:
>Someone asked me today if there are tools to migrate a 4D database to
>PostgreSQL. Any clue?
>
>Some googling turned up a tool to go the other way round and the
>archives got me an unanswered post about migrating from 4D to
>PostgreSQL, so I guess there's
Hi all,
Someone asked me today if there are tools to migrate a 4D database to
PostgreSQL. Any clue?
Some googling turned up a tool to go the other way round and the
archives got me an unanswered post about migrating from 4D to
PostgreSQL, so I guess there's not much chance...
Cheers.
---
Hello,
As I'm in the middle of the migration process form mysql to pg I found
that there is no CONCAT function which is available in mysql. Can
anybody tell me how to implement this function using plPERL or plPGSQL
language ?
Best wishes,
ML
---(end of broadcast)-
Hi,
I'm using PostgreSQL version 7.1.3.
I would like to change the data type of a column from VARCHAR to TEXT. Is this
possible? If
possible, how should I do it? Can anyone throw some light on this.
- Gnanam
Yahoo! Ind
hi,
using postgresql 7.3.1:
# select current_timestamp,date_part('timezone_hour',current_timestamp);
timestamptz | date_part
---+---
2003-09-16 10:51:58.228489+03 |-3
(1 row)
I would expect date_part('timezone_hour') to return 3.
40 matches
Mail list logo
