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.
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
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 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.
---
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
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 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
>
> 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 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
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 /
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]);
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:
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
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
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
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
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
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
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
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
> > 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
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
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
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
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
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
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
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
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
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 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_
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
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
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
"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
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
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
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)
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
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
40 matches
Mail list logo