Re: [GENERAL] [JDBC] SQLData user-defined-types and getObject()

On Sat, 7 Jan 2006, Assad Jarrahian wrote: I am quite confused (PLEASE PLEASE Help), I cannot find anything on the web). I read that you can declare a class that implements SQLData (in this case I set up a class called Complex from the /src/tutorial datatype that mimics the user-defined datat

Re: [GENERAL] Arrays and Performance

Sorry for the duplicate post! My first post was stalled and my mail server down for a day or so. I will reply to your original posts. Regards, Marc Philipp ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriat

Re: [GENERAL] Arrays and Performance

No, we don't get deadlock errors, but when running a vacuum and another process writing into the database there progress will stop at some point and nothing happens until one process is being killed. I think we used to vacuum every two nights and did a full vacuum once a week. Regards, Marc Phili

Re: [GENERAL] PostgreSQL Arrays and Performance

> How large are the arrays? PG is definitely not designed to do well > with > very large arrays (say more than a couple hundred elements). You > should > reconsider your data design if you find yourself trying to do that At the moment, the arrays are not larger than 200 entries. But there is not

Re: [GENERAL] PostgreSQL Arrays and Performance

> This sounds like it has more to do with inadequate freespace map > settings than use of arrays. Every update creates a dead tuple, and > if > it is large (because the array is large) and leaked (because you have > no > room in your freespace map), that would explain a rapidly increasing > dat

Re: [GENERAL] Installing Postgres 8.1 on Windows Server 2003 R2

> Has anyone tried to install Postgres on Windows Sever 2003 > version R2? R2 is actually shipping as a 'new' Microsoft > product- it's basically an interim update to Windows Server ( > http://www.microsoft.com/windowsserver2003/r2/whatsnewinr2.msp > x

Re: [GENERAL] COPY to

Angshu Kar schrieb: > Thanks Andreas. But how can I run this from the pgAdmin III Query tool > in a WinXP m/c? You dont. There is the function for saving query data to file already built in. Just press the button (documentation or tooltips tell you) and select the format of your csv in the request

[GENERAL] autocommit to off

Help me please! I need change autocommit to off in fedora core 3 in postgresql.conf i don´t know. How can i do? Thanks a lot Marcelo Lima. -- ___ Surf the Web in a faster, safer and easier way: Download Opera 8 at http://www.opera.com Powered by Ou

[GENERAL] PGError: server closed the connection unexpectedly

Hello list, I've been working a bit today to resolve the error I'm seeing mentioned in the title, and I was hoping you might have some insight. I've managed to semi-reliably reproduce this based on two different tasks: - a pg_dumpall from my backup server will throw this, but not always on

Re: [GENERAL] Suse Linux 10.0

On Thursday 05 January 2006 10:57, Peter Eisentraut wrote: > Am Donnerstag, 5. Januar 2006 21:15 schrieb Joseph M. Day: > > Has anyone been able to get the latest version of Postgres working on > > Suse 10.0 ? I just switched form Fedora and realized that this version > > is not specifically suppor

Re: [GENERAL] How to search?

Thanks, Mike ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] (Select *) vs. (Select id) from table.

Mike wrote: > Hi, > > I am trying to make a website where scalability matters. In my quest to > make my website more scalable I broke down the following SQL statement: > > select * from customers limit 100 > > to: > > select id, updated_date from customers limit 100 > > Then my application wou

Re: [GENERAL] Suse Linux 10.0

if i were you i'd try to compile, it's better way 2006/6/2, Jerome Lyles <[EMAIL PROTECTED]>: > On Thursday 05 January 2006 10:57, Peter Eisentraut wrote: > > Am Donnerstag, 5. Januar 2006 21:15 schrieb Joseph M. Day: > > > Has anyone been able to get the latest version of Postgres working on > >

Re: [GENERAL] COPY to

Got it. Thanks a ton Tino... On 1/8/06, Tino Wildenhain <[EMAIL PROTECTED]> wrote: Angshu Kar schrieb:> Thanks Andreas. But how can I run this from the pgAdmin III Query tool> in a WinXP m/c? You dont. There is the function for saving query data to filealready built in. Just press the button (docum

Re: [GENERAL] Suse Linux 10.0

Jerome Lyles wrote: On Thursday 05 January 2006 10:57, Peter Eisentraut wrote: Am Donnerstag, 5. Januar 2006 21:15 schrieb Joseph M. Day: Has anyone been able to get the latest version of Postgres working on Suse 10.0 ? I just switched form Fedora and realized that this version is not s

Re: [GENERAL] (Select *) vs. (Select id) from table.

Michael Trausch <[EMAIL PROTECTED]> writes: > Well, first, it's never really a good idea to use "SELECT * FROM" in a > production application, against a table. Tables can (and do) change > from one release to another, and if the layout of the table changes, you > could be looking at having to re

Re: [GENERAL] (Select *) vs. (Select id) from table.

On Saturday 07 January 2006 13:50, Michael Trausch wrote: > Mike wrote: > > Hi, > > > > I am trying to make a website where scalability matters. In my quest to > > make my website more scalable I broke down the following SQL statement: > > > > select * from customers limit 100 > > > > to: > > > > s

Re: [GENERAL] Suse Linux 10.0

On Thu, 2006-06-01 at 23:10 -1000, Jerome Lyles wrote: > On Thursday 05 January 2006 10:57, Peter Eisentraut wrote: > > Am Donnerstag, 5. Januar 2006 21:15 schrieb Joseph M. Day: > > > Has anyone been able to get the latest version of Postgres working on > > > Suse 10.0 ? I just switched form Fed

Re: [GENERAL] (Select *) vs. (Select id) from table.

> The time the DB needs to find the record > should be the same since the record has to be found before the resultset is > assembled. What if the query can be satisfied from an index? I don't know if PostgreSQL has this kind of optimization or not. But in the original example: select id, updated_

Re: [GENERAL] (Select *) vs. (Select id) from table.

Scott Ribe <[EMAIL PROTECTED]> writes: >> The time the DB needs to find the record >> should be the same since the record has to be found before the resultset is >> assembled. > > What if the query can be satisfied from an index? I don't know if PostgreSQL > has this kind of optimization or not.

Re: [GENERAL] Installing Postgres 8.1 on Windows Server 2003 R2

That's what I was afraid of... it's a new install of Win Server 2003 R2, so I can rule out any third party firewall. Windows Firewall is NOT installed.  And I've installed Postgres on a Windows XP box behind the same router, so it's not a router-firewall issue.   It's probably a new R2 feature, I

[GENERAL] Functions as a Security Layer

Functions, with some databases, are used as security layers so that a user that wouldn't otherwise have read/write privileges on a table can perform some sort of controlled update. I've written a function to serve as a type of counter to update a table called "users". This function takes one (rele

Re: [GENERAL] Functions as a Security Layer

Benjamin Stookey <[EMAIL PROTECTED]> writes: > My question is, can I somehow give permissions to the > function, but not to the user to protect the counter > table from being modified in any ways I don't want? Label the function SECURITY DEFINER. regards, tom lane ---

Re: [GENERAL] Oracle DB Worm Code Published

On 1/7/06, Magnus Hagander <[EMAIL PROTECTED]> wrote: > > A recent article about an Oracle worm: > > http://www.eweek.com/article2/0,1895,1880648,00.asp > > got me wondering. > > Could a worm like this infect a PostgreSQL installation? > > It seems to depend on default usernames and passwords - and

Re: [GENERAL] Functions as a Security Layer

--- Benjamin Stookey <[EMAIL PROTECTED]> wrote: > Functions, with some databases, are used as security > layers so that a user that wouldn't otherwise have > read/write privileges on a table can perform some sort > of controlled update. > > I've written a function to serve as a type of counter

Re: [GENERAL] Functions as a Security Layer

Thanks so much. That did the trick! --- Tom Lane <[EMAIL PROTECTED]> wrote: > Benjamin Stookey <[EMAIL PROTECTED]> writes: > > My question is, can I somehow give permissions to > the > > function, but not to the user to protect the > counter > > table from being modified in any ways I don't > wan

[GENERAL] userdefined types

Hello, So I have been reading over the web and it seems that one must define two methods before declaring a type. But I seem to have done it (CREATE TYPE) without creating any functions and it did not give me an error. I tried to use INSERT TABLENAME SET user-defined-column = ROW('val1' ,'va2'

[GENERAL] CRITICAL RELEASE: Minor Releases to Fix DoS Vulnerability

PostgreSQL patch versions 8.1.2, 8.0.6, 7.4.11 and 7.3.13 are available today. The fixes in the 8.1 and 8.0 branches are critical, especially for Windows users, and users of these branches are urged to update at their earliest opportunity. One critical fix repairs a denial-of-service vulner

Re: [GENERAL] userdefined types

Assad Jarrahian <[EMAIL PROTECTED]> writes: > it does not like the commas one after the other (empty value) how > do I solve that or does this have something to do with those two > methods (in and out) that I overlooked. > any insight would be much appreciated. You have not given us nea

[GENERAL] Fedora + Yum + 8.1

I am running Fedora core 4 with nightly "yum" update. Presently it is not picking up version 8.1 as an upgrade. 1) If I wait will 8.1 get added to the "yummy" list or 2) If I add 8.1 via the RPMs will future releases be maintained by "yum" or do future upgrades have to continue to be done man

Re: [GENERAL] userdefined types

C code (I am confused, are you talking about c-functions and types, cause I don't have any!) all I have is listed below (with the last query not working) So getting back to user-defined types, is it REALLY necessary to have the in-out functions (just to note, I am using jdbc with the db) Thanks!