I suppose comparing postgres running on a single processor laptop to sql server
running
on a dual processor machine wouldn't help you determine what sql server does
better.
If it might let me know.
Aside from maybe having the planner reorder joins for you I would guess that it
is sql
servers s
Hi,
I had someone pull the plug on my database about a week ago. When it was
restarted
postgres would not start because of the postmaster.pid file existed already. I
deleted
the pid file and attempt to restart the postmaster but it again failed. The
error this
time was that Log could not ren
Hello,
Will there need to be a new version of DBD::Pg released for 8.1.4?
Mike
--
Open WebMail Project (http://openwebmail.org)
---(end of broadcast)---
TIP 6: explain analyze is your friend
CREATE TABLE aa
(
a_col1 text
);
CREATE TABLE bb
(
b_col1 text
);
This update works:
UPDATE bb
SET b_col1 = aa.a_col1
FROM aa
WHERE bb.b_col1 <> aa.a_col1;
This does not:
UPDATE bb
SET bb.b_col1 = aa.a_col1
FROM aa
WHERE bb.b_col1 <> aa.a_col1;
Error: column "bb" of relation "bb" does not exis
Hi,
I have the postgresql.conf escape_string_warning active on my Win32 machine. I
have a couple databases on it which are static. When pg_autovacuum checks
these static databases it is triggering the warning: "non standard use of \\ in
a string literal at character 128 or character 355" depe
If someone can make a ppm I would appreciate it. I have VS 2005 not 2003.
Mike
On Thu, Feb 23, 2006 at 02:11:55AM -, Greg Sabino Mullane wrote:
>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
>
> I am pleased to announce that version 1.44 of DBD::Pg has
> been released. You can find
Hi,
I was hoping to update the results of one table with data from another table.
I have done this many times before using UPDATE X SET Z FROM Y.
The catch this time is the tables involved both have the same column names,
same table names but reside in different schemas.
UPDATE schema1.A
SET
Is this on fedora or redhat linux? If so a separate rpm must be installed for
plpython to function.
If you built from source the config script must also include building python.
On Fri, Jan 21, 2005 at 10:34:51PM -0700, Michael Fuhr wrote:
> On Fri, Jan 21, 2005 at 09:16:27PM -0800, elein wr
Isn't the syntax CREATE OR REPLACE FUNCTION chargeratetest() RETURNS "trigger"
AS'
?
On Wed, Jan 19, 2005 at 03:45:53PM +1100, Jamie Deppeler wrote:
> Hi,
>
> Think im doing something wrong here, cant seem to resolve the problem i
> have a trigger which is calling a update function and when
In 8.0 how does one have a plperl function use strict?
If I add "use strict" within the function body I receive an error message:
"creation of Perl function failed: 'require' trapped by operation mask..."
If I do Create Function X AS Language 'plperl' strict volatile the
function will comp
On Fri, Jan 14, 2005 at 01:28:47PM +0100, Martijn van Oosterhout wrote:
> On Thu, Jan 13, 2005 at 04:35:04PM -0600, Mike G. wrote:
> > thank you.
> >
> > I use the cursor because I really do an update against a different
> > table based on a value from the select i
Maybe it is because 'name' is a sql 92/99 non-reserved / key word?
On Mon, Jan 17, 2005 at 05:46:20AM +0100, LENGYEL Zoltan wrote:
> Hi,
>
> I have a pgpsql function:
>
> create or replace function new_uri(varchar,varchar,varchar) returns
> integer as '
> declare
> src alias for $1;
> tit a
at 04:58:06PM -0500, Tom Lane wrote:
> "Mike G." <[EMAIL PROTECTED]> writes:
> > I have a function that reads through one table via a cursor to make updates
> > to a different table. There is a row in this table with a column that has
> > a null value. The f
Hi,
I don't think you can. I logged it as a bug a few days ago. You might be able to
create the tables and execute the copy command to fill them with pgadminIII.
Mike
On Thu, Aug 12, 2004 at 09:29:21AM -0500, Jason Tesser wrote:
> I just downloaded the new beta for windows. I usually only use
I would think that depends upon how the sql in the file is coded. You can use the
RAISE NOTICE / ERROR commands to abort a function's execution.
> Can psql be told to exit immediately after an error (especially when
> doing commands from a file, -f)? This is the default behaviour of the
> mysq
Sounds like the pg_hba.conf file does not have that other computer
listed in it.
On Fri, 2004-07-23 at 08:37, eClaire wrote:
> Hello,
>
> I'm new in this list. First, scuse me for my not very good english and
> please speak me in simple words ;)
>
> I had install postgresql on my debian, no
Hello,
Varchar by default will truncate extra space at the end. If the table
column is defined as char or you cast the varchar to a char data type it
will have a fixed size of 40 characters.
Mike
On Tue, 2004-07-13 at 06:29, Constantin Khatsckevich wrote:
> Hello!
>
> Can I get ordered length
Have you run the analyze function on the table or database?
We would need to see the sql for your tests to determine why it was or
was not used.
By the way the pgsql-performance list is probably a much better place to
discuss this.
Mike
On Sat, 2004-07-10 at 05:57, Vitaly Belman wrote:
> I re
I can't help you with that error. Have you searched the pgsql-hacker
mailing list? It is much more appropriate for this question.
On Tue, 2004-07-13 at 03:52, Charles Su wrote:
> Hi , Dear Postgresql Creator, I live in Taiwan and try to run
> postgres_win32_7.5_devel but when I do initdb -L "c
It seems that postgresql crashed recently, tried to restart
automatically, and has not succesfully restarted.
You will need to stop the postmaster daemon manually, probably delete
the postmaster.pid file, and restart the postmaster daemon.
Chances are that anyone trying to query the database is n
Well there is no native windows version yet.
You can use cygwin from www.cygwin.com to run postgres under a unix
emulator.
It has ssl compiled with it by default. I forget if openssl needs to be
present on the machine as well.
On Mon, 2004-07-12 at 16:08, Otto Blomqvist wrote:
> Hello !
>
Well there is no native windows version yet.
You can use cygwin from www.cygwin.com to run postgres under a unix
emulator.
On Sat, 2004-07-10 at 08:02, Praveen wrote:
> Hi All,
>
> Can anybody tell from where i can download the latest Postgress Windows version?
>
> Thanks,
> Praveen
>
> -
What do you want to change it to?
Another number? Use something like Update table set field = field + 1
I assume you are going to store the result in the same table column?
On Mon, 2004-07-12 at 13:07, [EMAIL PROTECTED] wrote:
> I have a int4 coloumn, and I want to change the last bit the the
That depends on the platform you are installing it. The tar file should
contain a file named INSTALL which lists the instructions on how to
install by platform.
Mike
On Sun, 2004-07-11 at 00:01, network lines wrote:
> OK, i went to their web site and downloaded some
> *.tar files...which one do
Hi,
I think you will need to be more specific to what scripting language you
are attempting to use, which blob data type is being used in the db(lo
or bytea), and possibly the database driver used (odbc / .net)
to get a response from the community.
Mike
On Fri, 2004-07-16 at 08:21, Dylan Milks wr
Seems your FC2 box did not have the python language support compiled
into the version of postgresql that was installed on that box or
possibly not installed in the template1 database so it would be
available to any other database created in your FC2.
I do believe python is included in the rpm ve
What language are you using for this plperl?
That command listed in the documentation certainly works in psql or
plpgsql but I don't know about plperl.
Are you assigning the result to a variable and then printing the result
of that variable before the function ends or printing based on what the
f
Can you use pg_dump to backup the database and possibly then upgrade the
db? 7.2 is rather old. I recall reading similar postings in the
mailing this that recommend you upgrade to 7.2.4 or .6(?) if you must
stay on 7.2.
On Mon, 2004-07-05 at 17:48, ruben wrote:
> Hi:
>
> I'm getting this error
Would this be installing from source code or using a cygwin package? I
use 7.4.3 under cygwin package on XP Pro 24x7.
On Wed, 2004-06-30 at 16:17, Chuck Bernardes wrote:
> Anyone successful in installing PostgreSQL 7.4.3 on a windows XP Pro
> environment? I've read various README's but seem daun
Sounds like a permissions problem with cron. Was the cron job created
under the non-root users account?
On Thu, 2004-06-24 at 15:47, Kristopher Spencer-Yates wrote:
> Hi
>
> I have a PHP script running as a non-root user. The non-root user will
> exec PHP script via cron once per day.
>
> War
Yes to the first two questions under number 1. Not sure what you are looking for on
the last one.
Yes to number 2 if you configure it correctly although I don't know if it can write to
a file and screen at the same time.
Open the postgresql.conf file.
This page in the docs might help.
http:/
I believe they are created when either a function / program creates a temporary table.
On Wed, May 19, 2004 at 08:32:06AM -0400, Jerry Sievers wrote:
> Hello.
>
> I'm running postgres 7.4.1 and notice an accumulation of temp schemas
> named pg_temp_1, pg_temp_2... etc.
>
> These schemas are empt
32 matches
Mail list logo
