Hi Tom,
I have now completed the move to PG8.0.3, and feel that I have confirmed
that this problem is related to the problem I'm having:
Formulated like this, it is not performing:
SELECT station_id, timeobs,temp_grass, temp_dry_at_2m
FROM temp_dry_at_2m a
FULL OUTER JOIN temp_gra
Hello!
I have implemented solution for enabling regular
user (from group "ADMINS") to create new users in predefined groups, by your
modified function:
CREATE OR REPLACE FUNCTION "public"."alter_group"
(name, boolean, name, varchar, timestamp) RETURNS boolean
AS$body$DECLARE l_group ALI
Hi,
Why
not :
SELECT
INTO l_validity "VALIDITY"."VALIDITY" FROM ( SELECT
min("VALIDITY"."RV_ID") AS "RV_ID", "VALIDITY"."VALIDITY" FROM "VALIDITY" GROUP
BY "VALIDITY"."RV_ID", "VALIDITY"."VALIDITY") sve;
Regards,
Patrick
On 22 Jun 2005 at 8:59, [EMAIL PROTECTED] wrote:
> I have seen a bunch of different documentation on how to set up to
> allow ODBC, but I am a little confused about how much/what has to be
> set up to allow an ODBC connection from Windows (mostly 2003, some XP)
> to an existing PostgreSQL (7.4.6)
Not quite correct. TCP needs to be turned on AND an according entry in
pg_hba.conf needs to be set up - otherwise the server will just decline to
talk to the client.
Also - if you're on XP you might want to check the "firewall" settings - which
if configured wrong could potentially block connec
Great! It works.
Thanks.
- Original Message -
From:
[EMAIL PROTECTED]
To: [EMAIL PROTECTED] ; [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Sent: Thursday, June 23, 2005 10:18
AM
Subject: Re: [GENERAL] help about the
function
Hi,
Why
not :
I am trying to change the password for the postgres user but it doesn't work...
I
have tried changing it from pgAdmin, EMS PostgreSQL Manager, etc but whatever
password I set, I still can log in without using password (And it seems
that no
sql code is run on the server)
What am i missing?
Bjørn T Johansen wrote:
I am trying to change the password for the postgres user but it doesn't work...
I
have tried changing it from pgAdmin, EMS PostgreSQL Manager, etc but whatever
password I set, I still can log in without using password (And it seems
that no
sql code is run on the ser
Bjørn T Johansen <[EMAIL PROTECTED]> writes:
> I am trying to change the password for the postgres user but it
> doesn't work... I have tried changing it from pgAdmin, EMS
> PostgreSQL Manager, etc but whatever password I set, I still can log
> in without using password (And it seems that no s
On Wed, 2005-06-22 at 20:28, Tom Lane wrote:
> Scott Marlowe <[EMAIL PROTECTED]> writes:
> > Well, what really gets me is that basically, the syntax diagram in
> > the psql environment has a syntax diagram that makes sense to me.
>
> > So I guess if there was a "patch" it would basically referenc
hi, if the client machine is another linux , what is the correct way to configure ODBC
thanks
Hugo
Hi,All you need is the Windows ODBC driver, which you install on the
client machine, and then configure it to talk to the Linux server onport 5432 (set by default).--Ray.>> Most of the documenta
Hello
Does psql maintain some sort of global performance
counters?
We are interested mainly in following counters
(cumulative, by all psql processes):
- cpu time by all backends
- sql queries count
- fsync count
- disk reads / disk bytes read- disk
writes / disk bytes written
- transacti
Aaahh, of course I forgot about the trust settings I have there...
BTJ
Gavin Love wrote:
>
> Bjørn T Johansen wrote:
>
>> I am trying to change the password for the postgres user but it
>> doesn't work... I
>> have tried changing it from pgAdmin, EMS PostgreSQL Manager, etc but
>> whatever
Cestmir Hybl wrote:
Hello
Does psql maintain some sort of global performance counters?
Chapter 23. Monitoring Database Activity
You will want to combine the built-in stats with ps/logfile reading to
get all the figures you want.
--
Richard Huxton
Archonet Ltd
--
Scott Marlowe <[EMAIL PROTECTED]> writes:
> Now I'm thinking I should make a patch for a demonstration of making a
> rule with >1 action though...
You're right, there are no such examples. It would be interesting to
make a full-fledged demonstration of maintaining a join view (where
delete from t
Kim Bisgaard <[EMAIL PROTECTED]> writes:
> The reason the first query is not performing is because the query
> optimizer does not push the conditions down into the sub-queries - right??
Well, it's not the same condition: the WHERE clause is constraining
the output variable of the FULL JOIN, which
The problem:
I've two tables, both called "test" on two different schemas, let's say
schema1 and schema2.
I need to write a function like (just a simple example)
CREATE OR REPLACE FUNCTION foo()
RETURNS int4 AS
$BODY$
declare
num int4;
begin
select into num count(*) from test;
return
Hi..
I am running postgres 8.0.3 on red hat 9 and i have installed pgadmin
III 1.2 on win 2000 professional client. i want to establish a
connection between win client and postgres server..
please help me with the steps
kapil
---(end of broadcast)
Hi everyone,
I am looking for the best way to compare the schemas of two databases with the
very similar structure.
One (certainly not the best options) is to do something like this:
pg_dump ... DB1 > PG_SCHEMA1
pg_dump ... DB2 > PG_SCHEMA2
diff PG_SCHEMA1 PG_SCHEMA2 > differences.txt
kwri
Akash Garg <[EMAIL PROTECTED]> writes:
> During a vacuum, I ran into this error:
> vacuumdb: vacuuming of database "friend" failed: ERROR: invalid page
> header in block 41661 of relation "friend_pkey"
> I've read the posts on this newsgroup and it's clear that I have to
> REINDEX to fix this. T
Hello!
I'd like to know how can i get list of fields and corresponding foreign
keys (referenced table and field).
Thanks!
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
On Thu, Jun 23, 2005 at 01:34:28AM -0700, mrix wrote:
>
> I'd like to know how can i get list of fields and corresponding foreign
> keys (referenced table and field).
For individual tables, client interfaces usually have a way to show
the table definition. In psql, for example, you can use "\d t
On Wed, Jun 22, 2005 at 06:50:40PM +0200, Roberto Pellagatti wrote:
>
> The problem is that i get always the number of rows from the table in
> the schema that was current when I created the function.
PL/pgSQL caches its query plans, so subsequent calls to the function
use the plan created on th
On 6/20/2005 1:23 PM, Lee Harr wrote:
Some of the data required by the check function
is being restored after the data being checked
by the function and so it all fails the constraint.
Are you saying that the check function perform queries against other
data? That might not be a good idea --
Hi,
We've got a product which supposedly supports the major RDBMSs including
PostgreSQL. We tested it so far only with PostgreSQL 7.2 and found no
problem. Now, it turned out that it does not work with more recent
versions (certainly not with 8.0). The problem is with the kind of code
where w
Kapil Malhotra wrote:
Hi..
I am running postgres 8.0.3 on red hat 9 and i have installed pgadmin
III 1.2 on win 2000 professional client. i want to establish a
connection between win client and postgres server..
Make sure your server is actually listening for internet connections.
http://www.p
On Thu, Jun 23, 2005 at 11:47:37AM -0400, Jan Wieck wrote:
> On 6/20/2005 1:23 PM, Lee Harr wrote:
> >
> >You ask some great questions. Thanks.
>
> But not the really important one :-)
Maybe that's because it didn't need asking :-)
> The question I have is how exactly you manage to get the trigg
Hi,
- Original Message -
From: "Milorad Poluga" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, June 22, 2005 1:36 PM
Subject: [GENERAL] How to compare the schemas ?
>Hi everyone,
>
>I am looking for the best way to compare the schemas of two databases with
the very similar structure.
>One (c
Added pgsql-hackers
Added Bruce Momjian
On 6/23/2005 12:19 PM, Michael Fuhr wrote:
The question I have is how exactly you manage to get the trigger fired
when restoring the dump. By default, the dump created by pg_dump will
create the table, fill in the data and create the trigger(s) only afte
See also the recent thread 'Version Control?' for some tools and a
discussion of some of the difficulties in doing this robustly.
Milorad Poluga wrote:
> Hi everyone,
>
> I am looking for the best way to compare the schemas of two databases with
> the very similar structure.
> One (certainly not
=?ISO-8859-1?Q?Kov=E1cs_P=E9ter?= <[EMAIL PROTECTED]> writes:
> The problem is with the kind of code
> where we test the existence of a table in a transaction with:
> select count(*) from doesitexist where 1 = 2;
AFAIK the behavior of that has not changed since forever: if doesitexist
doesn't ex
On Wed, Jun 22, 2005 at 04:39:15PM -0400, Tom Lane wrote:
> "Magnus Hagander" <[EMAIL PROTECTED]> writes:
> > Yeah. But it has been declared dead by the Kerberos folks
> > (http://www.faqs.org/faqs/kerberos-faq/general/section-7.html. And this
> > document is from 2000, an dit was declared already
Jan Wieck <[EMAIL PROTECTED]> writes:
> I think pg_dump should add the check constraints in the same manner as
> it does triggers.
> Bruce, do we have a TODO item for this?
No, because that idea has been proposed and rejected before --- it adds
overhead (extra table scans) and reduces readability
> Has Kerb4 been marked as depricated in the docs at all? If
> not it might be best to just do that and then yank it later.
Yes, since 7.4.
http://www.postgresql.org/docs/8.0/static/auth-methods.html#KERBEROS-AUT
H
http://www.postgresql.org/docs/7.4/static/auth-methods.html#KERBEROS-AUT
H
"Ker
On Thu, 2005-06-23 at 12:12, Tom Lane wrote:
> =?ISO-8859-1?Q?Kov=E1cs_P=E9ter?= <[EMAIL PROTECTED]> writes:
> > The problem is with the kind of code
> > where we test the existence of a table in a transaction with:
>
> > select count(*) from doesitexist where 1 = 2;
>
> AFAIK the behavior of th
Scott Marlowe <[EMAIL PROTECTED]> writes:
> What versions of postgresql supported the abortive non-autocommit mode
> that caused so many problems, could it be that 7.2 did, and it was on
> for this fellow?
If memory serves, that mistake was only in 7.3. In any case, it would
not have had the effe
I'm migrating from mysql to
postgresql.
I've several (mysql)tables with multi-language
columns:
descript, descript_gb, descript_b5,
descript_sp
they store the record's description in
English, SimplifiedChinese, TraditionalChinese
and Spanish respectively.
I don't know if this will wo
Akash Garg <[EMAIL PROTECTED]> writes:
> I'll try running the od command -- I'm just a little confused on where
> I run it. I tried running od -x 41661 but that doesn't yield any
> results. I'm assuming I have to run this command on the actual index
> file itself -- how do I do this?
See contrib
Tom,
I'll try running the od command -- I'm just a little confused on where
I run it. I tried running od -x 41661 but that doesn't yield any
results. I'm assuming I have to run this command on the actual index
file itself -- how do I do this?
Thanks,
Akash
On 6/23/05, Tom Lane <[EMAIL PROTECTED
I used oid2name to find the index files:
168807081
168807081.1
168807081.2
168807081.3
168807081.4
Now how do I run the od command to find the block in question?
Thanks,
Akash
On 6/23/05, Tom Lane <[EMAIL PROTECTED]> wrote:
> Akash Garg <[EMAIL PROTECTED]> writes:
> > I'll try running th
Just a friendly warning that FC4's targeted SELinux policy breaks
PostgreSQL IDENT authentication across the loopback interface. Details
at:
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=161383
--
Ian Pilcher
I paid $69 and purchased the EMS PostgreSQL DB Comparer tool.
Works great for me..
They have a trial version you can play with...
They even have a command line version..
http://www.sqlmanager.net/en/products/postgresql/dbcomparer
Peter Fein wrote:
See also the recent thread 'Version Co
Akash Garg <[EMAIL PROTECTED]> writes:
> I used oid2name to find the index files:
> 168807081
> 168807081.1
> 168807081.2
> 168807081.3
> 168807081.4
> Now how do I run the od command to find the block in question?
Rather than doing the math by hand, let dd do it:
dd bs=8k skip=41661 cou
"YL" <[EMAIL PROTECTED]> writes:
> I'm migrating from mysql to postgresql.
> I've several (mysql)tables with multi-language columns:
>
> descript, descript_gb, descript_b5, descript_sp
>
> they store the record's description in
> English, SimplifiedChinese, TraditionalChinese and Spanish respe
On Thu, Jun 23, 2005 at 09:33:27AM -0600, Michael Fuhr wrote:
>
> http://www.postgresql.org/docs/8.0/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN
>
> Note what the documentation says about not being able to get the
> result of an EXECUTE query directly. A couple of workarounds
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Version 1.43 of DBD::Pg, the Perl DBI interface to PostgreSQL,
has just been released. This version mostly fixes some bugs
that appeared in 1.41 and 1.42, as well as introducing a new
file, README.dev, to help developers of this module.
The module c
On 06/23/2005 10:28:49 AM, Richard Huxton wrote:
Kapil Malhotra wrote:
Hi..
I am running postgres 8.0.3 on red hat 9 and i have installed pgadmin
III 1.2 on win 2000 professional client. i want to establish a
connection between win client and postgres server..
Make sure your server is actual
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> I just installed a new machine with Fedora Core 4 with PostgreSQL 8.0.3. I
> also installed DBI::Pg 1.41. When I try to use a query with a placeholder
> in it I get the error: "DBD::Pg::st execute failed: ERROR: syntax error at
> or near "$1" at
Akash Garg <[EMAIL PROTECTED]> writes:
> Ok, I ran that command on the index files -- they are attached.
I'm a bit confused --- you mean you extracted block 41661 from each of
the index's segments? If so, only the first one is actually relevant
here.
> I notice that in file2, file2 and file3, I
Thanks to William and everyone else who answered this. It works like a
charm!! PostgreSQL rules!
Susan
William Yu
On Thu, 2005-06-23 at 03:39 +, Karl O. Pinc wrote:
> On 06/22/2005 08:23:43 AM, Sven Willenberger wrote:
> > On Wed, 2005-06-22 at 01:30 +0200, Roman Neuhauser wrote:
> > > # [EMAIL PROTECTED] / 2005-06-21 15:00:12 -0400:
> > > > We have a system set up whereby postfix and maildrop gather user
Greg,
Switching to 1.42 didn't help, but 1.43 did the trick. I didn't realize
that there were newer versions of DBD::Pg. The CPAN install tool kept
telling me that DBD::Pg was up to date.
Thanks for the help!
Peter Darley
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAI
Hi,
We're running a Postgres 8.0.1 database and have a maintenance process
that runs vacuum on selected tables every 10 minutes. Each table takes
around 2-3 seconds to vacuum. Since we've started this process we've
seen a lot of postmaster crashes (it says it received signal 9). It
appears th
I know poker is just ludicrously popular these days. So surely somebody has
thought of storing hands in a relational database already? Has anyone here
done so in Postgres?
--
greg
---(end of broadcast)---
TIP 8: explain analyze is your friend
David Mitchell <[EMAIL PROTECTED]> writes:
> Hi,
>
> We're running a Postgres 8.0.1 database and have a maintenance process
> that runs vacuum on selected tables every 10 minutes. Each table takes
> around 2-3 seconds to vacuum. Since we've started this process we've
> seen a lot of postmaster cra
Joe Maldonado and I have a vexing problem with PostgreSQL 7.4.5 (we are
using the PGDG RPMs on a RedHat 9 system). He posted about this briefly
with the subject "info on strange error messages on postgresql" on this
list, but I'll start from the beginning. About once per week the
database ent
Jeff Gold <[EMAIL PROTECTED]> writes:
> About once per week the
> database enters some pathological state where the parent postmaster --
> NOT one of the child connections -- appears to run out of memory.
I can absolutely, positively say that that dump is not from the parent
postmaster. It's a
If you're running Linux, it's possible that your system is
overcommitted and low on memory and the kernel is picking random
processes to kill. There should be entries in the syslogs related to
this, if that's what's happening. There are ways to tell (some
versions of) Linux not to overcommit mem
David Mitchell <[EMAIL PROTECTED]> writes:
>> If you're running Linux, it's possible that your system is
>> overcommitted and low on memory and the kernel is picking random
>> processes to kill. There should be entries in the syslogs related to
>> this, if that's what's happening. There are ways
I had a couple of questions about Postgres 8.0 on Windows platforms:
1. Has Postgres 8.0 seen many field deployments yet? What have been the results?
2. When running a test against Postgress, I noticed in the Windows task manager that several postgres.exe processes we're created. What contro
I see there's a pgsql-cygwin list and a pgsql-hackers-win32 list, but no
pgsql-win32 list. I browsed through the pgsql-novice and pgsql-general archives
and only saw a few Windows-related posts. Which of those two lists is most
appropriate for asking newbie-type questions about the Windows por
61 matches
Mail list logo
