Re: [GENERAL] Postgres 8.2 binary for ubuntu 6.10?

2007-07-10 Thread Jan Muszynski
On 10 Jul 2007 at 9:13, Hannes Dorbath wrote: On 10.07.2007 03:09, novnov wrote: > I have postgres 8.1 installed on ubuntu 6.10 via synapic package manager. I > would like to install 8.2, but it's not offered in the list. I think 8.2 is > offered on 7.x ubuntu, and I wonder if 8.2 will be offered

[GENERAL] Multiple column index usage question

2007-01-19 Thread Jan Muszynski
Rather simple question, of which I'm not sure of the answer. If I have a multiple column index, say: Index index1 on tableA (foo,bar) and I then: Select * from "tableA" where foo = Will index1 be used, or am I looking at a seqscan in all circumstances? TIA -jan m -

[GENERAL] Multiple column index question.

2007-01-19 Thread Jan Muszynski
If I have an index that's composed of 2 columns: Index index1 on tableA (foo,bar) and I then: Select cola, colb from tableA where foo= Will index1 still be used, or am I looking at a seqscan under all circumstances in this case? TIA -jan m ---(end of broadcast)-

Re: [GENERAL] Migrate 8.0 dump to 7.4

2007-01-22 Thread Jan Muszynski
On 21 Jan 2007 at 15:11, Jim C. Nasby wrote: > On Sun, Jan 21, 2007 at 12:27:41PM -0500, Jaime Casanova wrote: > > On 1/21/07, mbneto <[EMAIL PROTECTED]> wrote: > > >Hi, > > > > > >I have a dumpall file generated from a 8.0 version that I need to import > > >back to a 7.4 server. > > > > > >Is the

Re: [GENERAL] security question

2007-01-22 Thread Jan Muszynski
On 22 Jan 2007 at 16:10, Sim Zacks wrote: > How good is postgresql security? > For example, If I have data that I do not anyone to see, including the > programmer/dba, is it enough > to change the password to the only user? > If they have access to the raw files is there a way for them to someho

Re: [GENERAL] security question

2007-01-22 Thread Jan Muszynski
On 22 Jan 2007 at 10:15, Ron Johnson wrote: > On 01/22/07 09:55, Jan Muszynski wrote: > > On 22 Jan 2007 at 16:10, Sim Zacks wrote: > > > >> How good is postgresql security? For example, If I have data > >> that I do not anyone to see, including the programmer

[GENERAL] ftell mismatch with expected position

2007-03-01 Thread Jan Muszynski
I found this thread (I'm posting here because I'm not subscribed to Hackers) http://www.mail-archive.com/pgsql-hackers@postgresql.org/msg85241.html which seems to be talking about this issue. I'm just wondering what the current status on this is. Someone I know is getting this error -(I'm not 1

Re: [GENERAL] I'd love to know what the rest of this error message is.

2007-03-02 Thread Jan Muszynski
On 2 Mar 2007 at 16:33, [EMAIL PROTECTED] wrote: > Quoting Bill Moran <[EMAIL PROTECTED]>: > > > In response to [EMAIL PROTECTED]: > >> "Your local 'Administrators' group contains 'Authenticated Users'. > >> This is a common configuration error that causes security issues. For this > >> reason,