On 02 Feb 2005 00:58:17 -0500, Greg Stark <[EMAIL PROTECTED]> wrote:
>I don't recall what the original motivation to rewrite the analyze sampling
>was, did having lots of dead tuples cause bad estimates in 7.4?
The original intention was to make analysing huge tables faster. But
the patch turned
Dorian Büttner wrote:
I appreciate nearly any hint to look after.
ok seems the problem affects system users that auth against ldap, so
this is off-topic here. Sorry.
Thanks,
Dorian
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands g
One advantage of a cursor over a for loop is that it makes your code more
portable.
It also allows you to bring existing code over without having to majorly
rewrite.
""Van Ingen, Lane"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> After reading the manual (8.0). I am not certain w
I own a server that was recently cracked by, I presume, an incompetent
script kiddie. Minutes after he bravely tagged the web site, the
server went down hard and would not boot. I've built a new system.
I need to recover a postgresql 7.2 database from the old hard drive,
which is still readable.
Hi,
I've successfully added tsearch2 to an existing database and the speedup
of searches is brilliant. I'm now trying to extend this to other parts
of our system.
One of the tables holds reasonable amounts of text, some fields hold up
to 2Mb. When I try and run
UPDATE table SET idxfti=to_tsvec
Por favor gostaria de saber como utilizo store
procedure no postgre ...
não quero retornar valor , apenas que o banco de
dados me execute uma instrução ...
Exemplo : insert into cliente (cnp,nom) values (
'21231231','CLIENTE TESTE')
sem mais,
Adelson
Bruce,
here is a example:
(there is a simple error in the function that does not get caught when running
the query in 8.0)
CREATE or REPLACE FUNCTION annual.get_ratio( float8, float8)
RETURNS pg_catalog.float8 AS
$BODY$
DECLARE
execptioncount_in alias for $1;
questioncount_in alias for $2;
ratio_
Bruce,
This function which has even more errors also raises no errors when run in the
query editor:
CREATE or replace function annual.get_ratio72( float8, float8)
RETURNS pg_catalog.float8 AS
$BODY$
DECLARE
execptioncount_in alias for $1;
questioncount_in alias for $2;
IF (execptioncount_in >
hi
i need to select rows from a table and to store them into an array.
and next, i would like to sort my array depending on some criteria.
so, my questions are :
how to store rows into a array ?
and how reverse some lines ?
(example : row[i]=row[i+1])
thanks in advance
Will
Hi all,
when I invoke psql-client from my normal user account, the prompt does
not accept the [']-key (quote). In a regular shell, I can type as many
's as I want to. If I start psql as root, everything works all right.
In both cases, \encoding shouts LATIN1.
OS is FreeBSD5.3, psql is 7.4.7
I app
Dear postgresql community,
I have a quite complex statement. When I execute it directly via
psql, the execution time is approx. 2000 ms.
When I execute it via JDBC (Apache Cocoon), the execution time
is either 600..1000 ms or approx. 10.000 ms, based on a certain
value in a table.
An interesting po
[EMAIL PROTECTED] (Russell Smith) writes:
> On Mon, 21 Feb 2005 08:05 pm, Surabhi Ahuja wrote:
> > do you still experience problems when you run
> > LDLIBRARY=/usr/local/pgsql/lib ./sample
>
> Note there is no SPACE in the example I have given.
> LDLIBRARY=/usr/local...
>
> NOT
>
> LDLIBRARY =
Hi!
I’m considering the possibility of using postgres in embededded
environment with VxWorks (RTOS) & Hitachi SH4 processor.
Can
anyone tell me if porting postgres to such a platform is possible? If yes,
which version of postgres supports this?
You may
provide me some referenc
Hi Phil,
Have you tried copying the insert statement straight into postgres?
print it out (or log it or whatever) and try that first.. that'll narrow
things down a little.
phil campaigne wrote:
Hi All,
In my java application I need to subtract two java.sql.timestamps. and I
want to store the re
Hi All,
In my java application I need to subtract two java.sql.timestamps. and I
want to store the result as sql type "interval".
But my insert statement is failing.
Does anyone know what java type I need to use in the insert statement?
(it must accept null values)
thanks in advance,
Phil
> Phil Endecott <[EMAIL PROTECTED]> writes:
>> I would understand this if I were doing an "ALTER TABLE", for example.
>> But does adding or removing a trigger really count as "schema-altering"?
>
> [ shrug... ] Hard to say. Probably depends a lot on what the trigger
> does. I suppose we could
Does any one know if this can be applied to windows server as through
the beta this only worked on linux based machines.
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [
Scott Marlowe wrote:
Why not change the keys that currently connect them to something
different (i.e. random noise) and make a NEW table that could join them
with those random keys that is restriced access wise to only the chosen
few.
This might work rather nicely. It would enable us to restrict d
On Tuesday 22 February 2005 12:30 pm, Heather Johnson wrote:
> One of the tables contains personally identifiable information
> (PII) (e.g., email, first and last name, etc.). The other contains
> "click stream" data (information about where on our website users
> have gone). In order to be sensiti
On Tue, 2005-02-22 at 14:30, Heather Johnson wrote:
> One of the tables contains personally identifiable information (PII)
> (e.g., email, first and last name, etc.). The other contains "click
> stream" data (information about where on our website users have gone).
> In order to be sensitive to
One of the tables contains personally identifiable information (PII)
(e.g., email, first and last name, etc.). The other contains "click
stream" data (information about where on our website users have gone).
In order to be sensitive to users privacy, we don't want to ever (even
accidentally) ru
On Tue, Feb 22, 2005 at 02:51:09PM -0500, Heather Johnson wrote:
> Is there a way to revoke permission to join two or more tables, even for
> users who have all other permissions (e.g., select, insert, update,
> delete) on those tables?
For what purpose? If this were possible, then users could
Heather Johnson wrote:
Is there a way to revoke permission to join two or more tables, even for
users who have all other permissions (e.g., select, insert, update,
delete) on those tables?
I don't think you can, and I'm not sure it makes sense to. If I can
select from tables ta,tb then I can mat
Is there a way to revoke permission to join two or more tables, even for
users who have all other permissions (e.g., select, insert, update,
delete) on those tables?
Heather Johnson
Senior Database Programmer
New York Post
---(end of broadcast)---
I want to create a view or a sp which returns NULL
if nothing is found and a recordset if the user is found
I wrote something like:
CREATE sp_getuser(name, pass) RETURNS record
AS
$body$
DECLARE
retval RECORD;
BEGIN
SELECT INTO retval * FROM Users
WHERE userid=name AND passwd=pass
Craig Bryden wrote:
Hi Shachar
I have confirmed that I am running the latest version.
The error that I get (in ADO .Net) is :
**
An unhandled exception of type 'System.ArgumentOutOfRangeException'
occurred in system.data
Joe Maldonado <[EMAIL PROTECTED]> writes:
> iostat shows that without vacuum (on SCSI Raid1), our application
> is not using much I/O on an avg (although there is bursty I/O)
> Device:rrqm/s wrqm/s r/s w/s rsec/s wsec/srkB/swkB/s
> avgrq-sz avgqu-sz
> /dev/sda 0.00 1.60 0.
[EMAIL PROTECTED] wrote:
Thank you very, very much. It works.
Do you know if exista another similar possibility do resolve this problem
without need to know the columns types?
Well, you could cast all the output columns to type text, then you'd
only need to know how many columns there were. Othe
Tom Lane wrote:
Joe Maldonado <[EMAIL PROTECTED]> writes:
Can concurrent updates/deletes slow down vacuum when it is progressing ? I
mean to ask if vacuum would have to redo or stall its work because of the
updates/deletes. Is it even possible that it goes into a long loop while
such updates occ
Phil Endecott <[EMAIL PROTECTED]> writes:
> I would understand this if I were doing an "ALTER TABLE", for example.
> But does adding or removing a trigger really count as "schema-altering"?
[ shrug... ] Hard to say. Probably depends a lot on what the trigger
does. I suppose we could at least
Hi Shachar
I have confirmed that I am running the latest
version.
The error that I get (in ADO .Net) is
:
**
An unhandled exception of type
'System.ArgumentOutOfRangeException' occurred in system.data.dll
Addition
Tom Lane wrote:
Phil Endecott <[EMAIL PROTECTED]> writes:
It seems less scary when you think of metadata as just being the content
of more tables, rather than something special.
PG does just fine with handling metadata changes transactionally.
However, most operations that affect a table's schema
I'm desparately seeking for a simple way to send messages to the client
during the execution of large stored procedures.
RAISE INFO 'Now Processing %', thisCustomer;
Doesn't do it, because the client console is cluttered with verbose context
information (e.g. backtrace). It's impossible to foll
Phil Endecott <[EMAIL PROTECTED]> writes:
> It seems less scary when you think of metadata as just being the content
> of more tables, rather than something special.
PG does just fine with handling metadata changes transactionally.
However, most operations that affect a table's schema at all will
Title: RE: [GENERAL] rows and array
i don't want to do the re-ordering on the client side.
i want a stored procedure which extract some rows from a database into an array.
next i have a function for re-ordering the array depending on specific needs
and finally generate a XML file on the server
Greg asked:
> > is "DROP TRIGGER" transaction safe?... I mean, could I do:
> >
> > BEGIN
> > DROP TRIGGER category_mv_ut;
> > ... insert rows
> > ... update materialized view table
> > CREATE TRIGGER category_mv_ut AFTER UPDATE ON items
> > FOR EACH ROW EXECUTE PROCEDURE update_ut();
> > COMMIT;
Title: RE: FW: [GENERAL] execute dynamic strings. need help.
Thank you very, very much. It works.
Do you know if exista another similar possibility do resolve this problem
without need to know the columns types?
In JDBC, when calling this function, you have to know these column types?
Thank
Joe Maldonado <[EMAIL PROTECTED]> writes:
> Can concurrent updates/deletes slow down vacuum when it is progressing ? I
> mean to ask if vacuum would have to redo or stall its work because of the
> updates/deletes. Is it even possible that it goes into a long loop while
> such updates occur ?
vacuu
[EMAIL PROTECTED] wrote:
I have a function with 3 parameters (select clause, where clause and order
by clause (last two are optionally clauses). This clauses apply to a given
table. For example, the table table1
and the function table1_rwc (read by where clause).
Given, let's say, the followings v
Can concurrent updates/deletes slow down vacuum when it is progressing ? I
mean to ask if vacuum would have to redo or stall its work because of the
updates/deletes. Is it even possible that it goes into a long loop while
such updates occur ?
The reason for my question is that I'm seeing vacuuming
Richard Huxton writes:
> FERREIRA William (COFRAMI) wrote:
>> i can store rows and re-order them like this :
>> children(i-j) := children(i-j-1);
> Well, I'd look at one of three solutions:
> 1. Functional index to order by
> 2. Temporary table (read up on EXECUTE and OID caching)
> 3. pl/p
"Boris Makovecki" <[EMAIL PROTECTED]> writes:
> I'm having trouble migrating DB from postgreSQL 7.4 to 7.4.7:
> During restore I'm geting all kind of errors like :
>
> ERROR: column "txt_name" has a type conflict
> DETAIL: chara
Title: execute dynamic strings
I have a function with 3 parameters (select clause, where
clause and order by clause (last two are optionally clauses). This clauses apply
to a given table. For example, the table table1
and the function table1_rwc (read by where clause).
Given, let's say, the f
On Tue, Feb 22, 2005 at 15:23:23 +0100,
Brar Piening <[EMAIL PROTECTED]> wrote:
> Hi there,
> if I use the datatype serial in a table it implicitly creates a sequence.
> If I grant INSERT to a user on this table he still can't insert data as
> he doesn't have the right privileges on the implicit
Hi,
I have a "simple" request without a limit giving me this :
# select a.id_my from sites_articles a, site_my s where s.id_site = a.id_site
and s.language = 'aa' and s.id_category = 11 order by my_date desc ;
id_my
(0 rows)
Time: 3.537 ms
If I put a LIMIT (because it'll be an automa
On Tue, Feb 22, 2005 at 08:22:31 -0300,
Renato Cramer <[EMAIL PROTECTED]> wrote:
> Hello All,
>
> I'm terminating a database postgraduate and need prepare my monograph.
>
> Anybody will can suggest a subject for it?
>
> I'm want use PostgreSQL.
Have you looked at the TODO list?
-
FERREIRA William (COFRAMI) wrote:
i want do to it in a stored procedure using the pl/pgSQL language.
i can't use "ORDER by" because the traitment is very specific.
for example, in oracle syntaxe i can create my own type :
type recordChild is TABLE OF XDB_CHILD%ROWTYPE
and next when i declar
Hi there,
if I use the datatype serial in a table it implicitly creates a sequence.
If I grant INSERT to a user on this table he still can't insert data as
he doesn't have the right privileges on the implicitly created sequence.
Is this a bug or a feature?
Is there a way to implicitly grant the ri
I'm having trouble migrating DB from postgreSQL 7.4 to 7.4.7:
During restore I'm geting all kind of errors like :
ERROR: column "txt_name" has a type conflictDETAIL:
character varying versus pg_catalog.varchar
*
Title: RE: [GENERAL] rows and array
i want do to it in a stored procedure using the pl/pgSQL language.
i can't use "ORDER by" because the traitment is very specific.
for example, in oracle syntaxe i can create my own type :
type recordChild is TABLE OF XDB_CHILD%ROWTYPE
and next when
On Tue, 2005-02-22 at 14:08 +0200, Sharon Abu wrote:
> insert into COL_LED_TBL
> (LED_STATE_COLOR,NEID,LED_STATE_MODE,PHY_INDEX,PORT_INDEX,MODE_DFGH)
> values (1,1234,3,0,104,'test led numbetr 1');
>
> the name of the table & its columns are correct (I've checked it)
>
> The execution fails
Title: RE: [GENERAL] Problem with inserting data into a table.
maybe you can try to add the name of the schema like this :
insert into my_schema.COL_LED_TBL
(LED_STATE_COLOR,NEID,LED_STATE_MODE,PHY_INDEX,PORT_INDEX,MODE_DFGH)
values (1,1234,3,0,104,'test led numbetr 1');
-Message
>
> Try pltcl or plperl (or python I'd have thought) - they're much more
> suited to this sort of thing.
>
> PS - IMHO, formatting data into XML is a client-side task, middle-ware
> probably.
> --
Its not true. There is SQL/XML, but PostgreSQL don't support this. Where
you can use it: fast ge
Sharon Abu wrote:
Hi All,
new to postgreSQL.
I'm running postgreSQL 8.0.1 on win 2k and and i have created a database
(for testing) using pgAdmin-III application
i'v'e also managed to create table with just few simple columns... so far so
good.
the name of the table & its columns are co
Hello,
use other languege. You need hash table, and hash are not implemented in
PL/pgSQL. Some examples
http://www.root.cz/clanky/plperl-postgresql-aplikacni-server/
but in czech language.
Pavel
On Tue, 22 Feb 2005, Jan Poslusny wrote:
> Hi,
> I have a problem of plpgsql usage. When I iter
Hi All,
new to postgreSQL.
I'm running postgreSQL 8.0.1 on win 2k and and i have created a database
(for testing) using pgAdmin-III application
i'v'e also managed to create table with just few simple columns... so far so
good.
The problem arises when i'm trying to insert some data int
Renato Cramer wrote:
Hello All,
I'm terminating a database postgraduate and need prepare my monograph.
Anybody will can suggest a subject for it?
I'm want use PostgreSQL.
Well, the TODO list is here:
http://developer.postgresql.org/todo.php
There's been a lot of discussion on the hacker's list re
Jan Poslusny wrote:
Hi,
I have a problem of plpgsql usage. When I iterate through dynamic query,
like this:
FOR my_/record/ IN EXECUTE /text_expression/ LOOP/statements/
END LOOP;
I am not able to construct expression, which can get value for each
'item' of my_record, something like my_recor
Hello All,
I'm terminating a database postgraduate and need prepare my monograph.
Anybody will can suggest a subject for it?
I'm want use PostgreSQL.
Thanks in advance.
Renato Cramer.
---(end of broadcast)---
TIP 3: if posting/reading through Us
Hi,
I have a problem of plpgsql usage. When I iterate through dynamic query, like
this:
FOR my_/record/ IN EXECUTE /text_expression/ LOOP
/statements/
END LOOP;
I am not able to construct expression, which can get value for each 'item' of
my_record, something like my_record[3] or get_item(my
FERREIRA William (COFRAMI) wrote:
hi
does postgresql allows to store rows into array ?
i select rows in a table and i would like to sort them depending on my
criteria.
Is this different from
SELECT a,b,c FROM t ORDER BY a ASC, b DESC;
If so, could you specify more details - what language you are
Title: rows and array
hi
does postgresql allows to store rows into array ?
i select rows in a table and i would like to sort them depending on my criteria.
thanks
Will
You should try directing this request to the postgres jdbc list.
Have you looked at
http://jdbc.postgresql.org/documentation/80/datasource.html?
John Sidney-Woollett
Sharon Abu wrote:
Dear Postgresql experts,
First i want to mention that i'm new to postgreSQL DB.
I have a J2EE application wh
Dear Postgresql experts,
First i want to mention that i'm new to postgreSQL DB.
I have a J2EE application which is deployed on Oracle OC4J application
server and Oracle 9i DB i'm trying to migrate to PostgreSQL DB (cost
reduction issues)
so I have installed PostgreSQL 8.0.1 on win 2K pla
Nageshwar Rao wrote:
Hi,
Can you please let me know what parameters need to be adjusted in order to
complete this operation? It is still running and checked the table, still
there are no records in that. This table does not have any constraints
That is odd then. The only thing that should slow you
Hi,
Can you please let me know what parameters need to be adjusted in order to
complete this operation? It is still running and checked the table, still
there are no records in that. This table does not have any constraints
.Checked the same operation with 4 records it is fine.Only problem is when
Nageshwar Rao wrote:
I am trying to load some 5000 records now. It is still running for past 15
minutes, but when I check the table still I do not see records .And there is
no status as how many records are inserted. Just left it like that.
Without knowing more about the table, your configuration s
67 matches
Mail list logo
