I'm a newbie, and couldn't find this in the archives... although I see that
disabling SSL is new to 7.4.
I'm using psql to attach to 7.4.2 across a DSL connection. This always
results in a long delay (just over 60 seconds) either when connecting
(nossl) or disconnecting (ssl).
If my pg_hba.con
> ALL rules get executed. Conditions get combined (actually, parse trees
> get merged).
>
> === BEGIN rule_test.sql ===
> CREATE TABLE foo (a int4 PRIMARY KEY, b text);
>
> COPY foo FROM stdin;
> 1 aaa
> 2 bbb
> 3 ccc
> 4 aaa
> 5 bbb
> 6 ccc
> \.
>
> CREATE VIEW foo_v AS SELECT * FROM foo WHERE b=
On Wednesday September 29 2004 5:17, Tom Lane wrote:
> >
> > 2004-09-29 18:14:53.621 [520]ERROR: Memory exhausted in
> > AllocSetAlloc(1189)
> >
> > Analyze: 132263832 total in 27 blocks; 2984 free (35 chunks); 132260848
> > used
>
> Either increase your per-process memory limit, or reduce the
Hi All,
Please let me know How do I unsbscribe from this news group?
Thanks,
Murali
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ed L.
Sent: Wednesday, September 29, 2004 9:23 PM
To: Tom Lane
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] 7.3.4 vacuum/an
Hi All,
Please let me know how do I unsbscribe to this newsgroup?
Thanks,
Murali
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ed L.
Sent: Wednesday, September 29, 2004 9:21 PM
To: Tom Lane
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] 7.3.4 vacuum/anal
"Ed L." <[EMAIL PROTECTED]> writes:
> On Wednesday September 29 2004 10:18, Tom Lane wrote:
> $ psql -c "show default_statistics_target;"
> default_statistics_target
> ---
> 1000
> (1 row)
> Does that look like its been changed?
Uh ... the default is 10.
Tom Lane wrote:
Jeffrey Melloy <[EMAIL PROTECTED]> writes:
I have a couple users trying to install Postgres on OS X. To the best
of my knowledge, both of them are using 7.4.5/10.3.5, and got identical
errors while trying to init the database:
They need to increase the system's shmmax lim
On Wednesday September 29 2004 10:18, Tom Lane wrote:
> > Honestly, I don't even know how. How can I check its value to see if
> > someone else has?
>
> show default_statistics_target;
Let me add this: I'm seeing this error show up across multiple clusters,
maybe 5 or 6, all with similar schema
On Wednesday September 29 2004 10:18, Tom Lane wrote:
> > Honestly, I don't even know how. How can I check its value to see if
> > someone else has?
$ psql -c "show default_statistics_target;"
default_statistics_target
---
1000
(1 row)
Does that look like i
> Honestly, I don't even know how. How can I check its value to see if
> someone else has?
show default_statistics_target;
regards, tom lane
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Jeffrey Melloy <[EMAIL PROTECTED]> writes:
> I have a couple users trying to install Postgres on OS X. To the best
> of my knowledge, both of them are using 7.4.5/10.3.5, and got identical
> errors while trying to init the database:
They need to increase the system's shmmax limit (sysctl kern.s
On Wednesday September 29 2004 9:54, Tom Lane wrote:
> You sure you haven't changed default_statistics_target?
Honestly, I don't even know how. How can I check its value to see if
someone else has? What I *do* do is to enable the stats_* stuff in
postgresql.conf, but that's it.
> I'd think
On Thu, 2004-09-30 at 13:49, Jeffrey Melloy wrote:
> I have a couple users trying to install Postgres on OS X. To the best
> of my knowledge, both of them are using 7.4.5/10.3.5, and got identical
> errors while trying to init the database:
Have you tried the suggestions in the documentation?
"Ed L." <[EMAIL PROTECTED]> writes:
> The table has 3 columns, one of which contains huge text values. Yes, barf.
That shouldn't matter --- ANALYZE actually deliberately ignores
very-wide values so as not to run out of memory.
You sure you haven't changed default_statistics_target?
I'd think yo
I have a couple users trying to install Postgres on OS X. To the best
of my knowledge, both of them are using 7.4.5/10.3.5, and got identical
errors while trying to init the database:
Reducing the shared buffers didn't help.
Any thoughts would be appreciated.
Jeffrey Melloy
[EMAIL PROTECTED]
Wi
Hi
all,
I want to get what
roles/groups that the current user is member of.
I tried to use the
following commands but they both returned no rows.
SELECT * FROM
information_schema.enabled_roles
SELECT * FROM
information_schema.applicable_roles
Anybody know how to
solve this ? or anyb
On Wednesday September 29 2004 8:59, Tom Lane wrote:
> "Ed L." <[EMAIL PROTECTED]> writes:
> >> Either increase your per-process memory limit, or reduce the
> >> statistics targets for this table ...
> >
> > What am I missing?
> >
> > $ ulimit -a
> > time(seconds)unlimited
> > file(blocks)
"Ed L." <[EMAIL PROTECTED]> writes:
>> Either increase your per-process memory limit, or reduce the statistics
>> targets for this table ...
> What am I missing?
> $ ulimit -a
> time(seconds)unlimited
> file(blocks) unlimited
> data(kbytes) 131072
^^^
On Wednesday September 29 2004 8:33, Ed L. wrote:
> On Wednesday September 29 2004 5:17, Tom Lane wrote:
> > "Ed L." <[EMAIL PROTECTED]> writes:
> > > I'm getting a slew of these repeatable errors when running ANALYZE
> > > and/or VACUUM ANALYZE (from an autovacuum process) against a
> > > 7.3.4 cl
On Wednesday September 29 2004 5:17, Tom Lane wrote:
> "Ed L." <[EMAIL PROTECTED]> writes:
> > I'm getting a slew of these repeatable errors when running ANALYZE
> > and/or VACUUM ANALYZE (from an autovacuum process) against a
> > 7.3.4 cluster on HP-UX B.11.00:
> >
> > 2004-09-29 18:14:53.621 [520
Yeah, I suppose this would be faster than the EXTRACT technique, too,
eh? Because it requires only a single index and is not an index on an
expression, which are generally more expensive?
-tfo
On Sep 29, 2004, at 6:59 PM, Tom Lane wrote:
"Thomas F.O'Connell" <[EMAIL PROTECTED]> writes:
Here's wh
"Ed L." <[EMAIL PROTECTED]> writes:
> I'm getting a slew of these repeatable errors when running ANALYZE
> and/or VACUUM ANALYZE (from an autovacuum process) against a
> 7.3.4 cluster on HP-UX B.11.00:
> 2004-09-29 18:14:53.621 [520]ERROR: Memory exhausted in AllocSetAlloc(1189)
> Analyze:
"Thomas F.O'Connell" <[EMAIL PROTECTED]> writes:
> I'm interested to know a little bit more about the postgres
> implementation of indexes. I'm specifically wondering what it means in
> the output of EXPLAIN when a filter is applied.
The index itself is using the condition(s) indicated as "Ind
I'm getting a slew of these repeatable errors when running ANALYZE
and/or VACUUM ANALYZE (from an autovacuum process) against a
7.3.4 cluster on HP-UX B.11.00:
2004-09-29 18:14:53.621 [520]ERROR: Memory exhausted in AllocSetAlloc(1189)
This error is in the FAQ, but that answer does not ap
Vivek Khera <[EMAIL PROTECTED]> writes:
> On Sep 29, 2004, at 4:55 PM, Richard Huxton wrote:
>> Am I missing something Vivek, or should the gross hack be "creating a
>> user with id=102" ?
> And how exactly does one accomplish this?
CREATE USER.
regards, tom lane
--
I'm interested to know a little bit more about the postgres
implementation of indexes. I'm specifically wondering what it means in
the output of EXPLAIN when a filter is applied.
I'm trying to decide whether it makes sense to use indexes on
expressions rather than relying on a left-anchored
On Wed, Sep 29, 2004 at 05:07:38PM -0400, Vivek Khera wrote:
>
> On Sep 29, 2004, at 4:55 PM, Richard Huxton wrote:
>
> >Vivek Khera wrote:
> >>there is no user with ID 102 in the pg_user view. pg_restore
> >>complains about the missing user "102". And no, the user was not
> >>"102" it was th
On Sep 29, 2004, at 4:55 PM, Richard Huxton wrote:
Vivek Khera wrote:
there is no user with ID 102 in the pg_user view. pg_restore
complains about the missing user "102". And no, the user was not
"102" it was the name of a (former) employee.
The gross hack is to pg_restore to an ascii file and
Vivek Khera wrote:
there is no user with ID 102 in the pg_user view. pg_restore complains
about the missing user "102". And no, the user was not "102" it was the
name of a (former) employee.
The gross hack is to pg_restore to an ascii file and delete those GRANT
lines, but the compressed dump
I have a database which started on Pg 7.1, moved to 7.2 via
pg_dump/restore, and ultimately to Pg 7.4 likewise.
While it was in 7.2, I added one user and granted access to various
tables. After the 7.4 migration, that user was no longer needed, so
was removed via "dropuser" command line tool.
You have to use psql's \copy.
---
Josh Close wrote:
> Is there a way to do COPY FROM STDIN from sql? So, remotely I could
> run the copy command and somehow push the info over instead of having
> it on the server.
>
> -Josh
Hello,
On Tue, 2004-09-28 at 13:57, Tim Penhey wrote:
> Matthew Metnetsky wrote:
>
> >So, does anyone know of (or have) good examples of queries within
> >functions (and returning sets of data)?
> >
> >Thanks in advance,
> >
> >~ Matthew
> >
> >
> Hi Matthew,
>
> I wrote up an example which ca
Is there a way to do COPY FROM STDIN from sql? So, remotely I could
run the copy command and somehow push the info over instead of having
it on the server.
-Josh
---(end of broadcast)---
TIP 6: Have you searched our list archives?
ht
Well, considering that the EXPLAIN tables are different from
tablea/tableb, I can only assume that your jobdata tables follow the
same pattern.
Are you familiar with the ONLY syntax for SELECT when using
inheritance? It looks like you might need to SELECT ONLY ... FROM
tableb.
-tfo
On Sep 29,
Marco Colombo <[EMAIL PROTECTED]> writes:
> I'm not against abusing of the db, nor playing dirty tricks, if that fits
> your needs. You're free to design your db the way you like and face
> the cost of a careful design or of later SQL gymnastics. I'm fine,
> as long as you don't ask for syntactic
Doh ! Thanks for the insight.
Greg
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Wed 9/29/2004 8:40 AM
To: Gregory S. Williamson
Cc: [EMAIL PROTECTED]
Subject:Re: [GENERAL] Setting search paths inside a function (plpgsql)
"Gregory S. Williamson" <[
Title: Message
after
an improper shutdown (power failure) the postgres service cannot be
restarted.
simply
restoring the postmaster.pid does not allow the postgres service to
start.
also,
is there somekind of data integrity check built in with postgresql that can
notify me of any data co
--- "Geisler, Jim" <[EMAIL PROTECTED]> wrote:
> I am trying to create an installer that will run
> PostgreSQL as a service
> onto a Windows machine( 2000 or Server 2003).
>
> Are there any suggestions for solving this problem?
> Any response is much
> appreciated.
>
You might want to look at
On Wed, 29 Sep 2004, Graeme Hinchliffe wrote:
> The RADIUS server is reporting problems when trying to write START of
> accounting entries, and the error given is:
>
> ERROR: cannot EXECUTE a null querystring CONTEXT: PL/pgSQL function
> "radacct_trig" line 43 at open
>
> The lines its re
<[EMAIL PROTECTED]> writes:
> My question is - HOW do I construct the argument to
> my_function(my_type) so that the function recognises that I am passing
> into it composite data?
Sorry, don't think you're going to have much joy on that in 7.3.
In 8.0 you could do it with a ROW() constructor, bu
Hello,
I hate to re-ask this again (sorry to be repetitive!)... I really could
use some help with this, if anyone is familiar with table inheritance as
it applies to my questions
Thanks!
- Greg
>Hello,
>
>I am playing with the "INHERITS" functionality of create table to
>determine its suita
"Gregory S. Williamson" <[EMAIL PROTECTED]> writes:
> RAISE NOTICE ''doing name search for fips %'',p_fips;
> env_str := ''SET search_path TO f'' || p_fips || '',public'';
> EXECUTE env_str;
> RAISE NOTICE ''did exec of <%>'',env_str;
> FOR retrec IN
>
Quick question, hopefully...
How do you store a date in Postgresql using Java date format, i.e.
2004-00-01 where that would be January 1, 2004 (looking for the 00 as
Jan.)
I've googled but only found someone else with the same problem.
---(end of broadcast)--
On Wed, 29 Sep 2004, Gregory S. Williamson wrote:
> I've got a problem which seemed to be neatly solved by the use of
> schemas, and in fact it mostly works, but I have tried to go one step
> too far, perhaps.
>
> Rather than have the application do
>
> SET search_path TO f12057;
> SELECT * FROM
Hiya
I have written a PL/PGSQL function which tots up users accounting
information from their RADACCT data on the fly. So each insert or
update modifies their totals.
This has worked without error when I have tested it by hand with hand
crafted inserts and updates, however when I
On Wed, 29 Sep 2004, Devrim GUNDUZ wrote:
> We were performing some tests on PostgreSQL and found that it fails on the
> following query:
>
> SELECT 512*18014398509481984 AS result;
>
> and the result is:
>
> result
> - --
> -9223372036854775808
This query should e
Najib Abi Fadel wrote:
AS YOU CAN SEE TWO ROWS WHERE UPDATED INSTEAD OF ONE !!
THE COMMON THINGS BETWEEN THE TWO ROWS IS THAT THE FIELDS: cod_etu,
cursus_id,vers_id,code_type_academic are the same
Because that's what you asked upd1/2 to do for you. To see what is
happening, try selecting row id=5
> > Because that's what you asked upd1/2 to do for you. To see what is
> > happening, try selecting row id=53597 then manually running each rule
> > yourself, substituting in the OLD.foo from your selected row. You should
> > find that there are two rows that match 53597 on (cursus_id, vers_id,
> >
On Wed, Sep 29, 2004 at 04:51:30PM +0530, Shridhar Daithankar wrote:
> Probably because the normal integer is 4 bytes long and bigint is 8 bytes
> long. The value above is exactly 2^63 at which a 8 bytes long signed bigint
> should flip sign/overflow. I am still puzzled with correct value and neg
> This means upd1 is redundant since any rows affected by upd1 *must* be
> affected by upd2.
OK
> > CREATE RULE transactions_sco_up8 AS ON
> > UPDATE TO transactions_sco_v DO INSTEAD UPDATE transactions_sco SET
traiter
> > = new.traiter WHERE
> > (transactions_sco.id = old.id);
>
> OK, this on
On Wednesday 29 Sep 2004 2:25 pm, Devrim GUNDUZ wrote:
> > template1=# SELECT 512*18014398509481984::numeric(20) AS result;
> > result
> > -
> > 9223372036854775808
> > (1 row)
>
> Ok, I got the same result in 7.4.5... But... Why do we have to cast it
> into numeric? The r
On Tue, 28 Sep 2004, Greg Stark wrote:
Marco Colombo <[EMAIL PROTECTED]> writes:
(a = b or (a is null and b is null))
that raises a flag for me. It seems that NULL is used as a special value,
which is not.
Well, as I said, it raised a flag for me too. However, it's not good to be too
dogmatic about
Najib Abi Fadel wrote:
Details:
I have a table "transactions_sco" and a view "transactions_sco_v" defined as
:
create view transactions_sco_v as select * from transactions_sco;
I have the following Rules:
CREATE RULE transactions_sco_up1 AS ON
UPDATE TO transactions_sco_v DO INSTEAD UPDATE transac
Details:
I have a table "transactions_sco" and a view "transactions_sco_v" defined as
:
create view transactions_sco_v as select * from transactions_sco;
I have the following Rules:
CREATE RULE transactions_sco_up1 AS ON
UPDATE TO transactions_sco_v DO INSTEAD UPDATE transactions_sco SET trait
Dear peoples,
I've got a problem which seemed to be neatly solved by the use of schemas, and in fact
it mostly works, but I have tried to go one step too far, perhaps.
Rather than have the application do
SET search_path TO f12057;
SELECT * FROM parcel-owners WHERE ... ;
SET search_path TO publi
Najib Abi Fadel wrote:
WHY IS THAT HAPPENNING ??
I can provide more details if anyone is ready to help ...
You will need to provide if anyone is to help.
One thing you need to consider is that rules are basically like macros,
with all the issues that can have.
--
Richard Huxton
Archonet Ltd
-
Sim Zacks wrote:
Do I need to use a specific language in a function to do this or does
it work as native SQL, as it would in T-SQL?
You need to use a specific language.
What I would like to do is something like -
(pseudo code)
declare cursor for select relname from pg_statio_user_sequences
open cur
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Wed, 29 Sep 2004, Shridhar Daithankar wrote:
SELECT 512*18014398509481984 AS result;
and the result is:
result
--
-9223372036854775808
It should be 9223372036854775808... This is PostgreSQL 7.4.5 on Fedora
Core 2.
Cheers for that! We did catch it eventually. My colleague was using
pgAdminIII and was apparently typing:
v_ref := ''/'';
and pgAdminIII "appears" to have been "helping out" by escaping the
single quotes.
On Tue, 28 Sep 2004 22:46:31 +0300, Andre Maasikas
<[EMAIL PROTECTED]> wrote:
> [EMAIL PRO
Hi all i am running PostgreSQL 7.3.2,
i have a VIEW for which i implemented
multiple RULES on UPDATE.
The weird think is that the Update Query
corresponding to one of the rules is updating MULTIPLE ROWS even though it
should only update one ROW !!
THE WEIRDEST is that when i remove 2
create type my_type (my_test text, my_int integer);
create function my_function(my_type)
returns timestamp as
'begin
return (current_timestamp);
end;
'
language 'plpgsql';
In 7.3.5, we are trying to get around the 32 argument limit of the
functions WITHOUT re-compiling with a greater func_max_ar
I am in the process of testing PostGreSQL for our sales and product
database and I am a little confused about SQL scripting and various
available languages. (My background is mostly MSSQL Server).
I am using the PGAdmin tool and I would like to write a script to
update all sequences to the current
On Wednesday 29 Sep 2004 1:11 pm, Devrim GUNDUZ wrote:
> Hi,
>
> We were performing some tests on PostgreSQL and found that it fails on the
> following query:
>
> SELECT 512*18014398509481984 AS result;
>
> and the result is:
>
> result
> --
> -9223372036854775808
>
>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
We were performing some tests on PostgreSQL and found that it fails on the
following query:
SELECT 512*18014398509481984 AS result;
and the result is:
result
- --
-9223372036854775808
It should be 9223372036854775808..
good day everyone!
i am using postgresql-8.0beta2-dev3 windows port, with postgis-0.9
add-on. anyway, while trying to insert a table using shp2pgsql, i get
this error:
psql:temp.sql:38: ERROR: Unicode characters greater than or equal to
0x1 are not supported
this is line 38 of temp.sql:
I
65 matches
Mail list logo
