Re: [GENERAL] Product Roadmap question and request for recommendation

2009-02-23 Thread Dot Yet
don't fix if it ain't broken ;) no really, if the system is capable of working nearly flawlessly till 8.4 is baked, then it is sound to wait till then, especially when upgrading to a newer version is a *painful* as in time consuming task. i am assuming downgrading (just incase things don't workout

Re: [GENERAL] Unique constaint violated without being violated

2008-12-07 Thread Dot Yet
funny!! :) too bad, i also noticed it only after reading Merlin's response :) On Sat, Dec 6, 2008 at 11:12 AM, Sebastian Tennant <[EMAIL PROTECTED]>wrote: > Quoth "Merlin Moncure" <[EMAIL PROTECTED]>: > > It looks to me like you are setting the whole table to the same > > address in the update st

[GENERAL] PostgreSQL 8.3.4 Solaris x86 compilation issues

2008-10-24 Thread Dot Yet
Hi everyone, i am facing some problem while compiling postgresql 8.3.4 on Solaris 10 x86 10u5. the compiler is SunStudio 12. The compilation happens without errors, but make check fails: OpenSSL 0.9.8i compiled as: ./Configure --prefix=/opt/usr/local -m64 -xmodel=medium PostgreSQL 8.3.4 compiled

Re: [GENERAL] Alias name from subquery

2008-09-30 Thread Dot Yet
>From what i know, Aliases are literals, they are not variables, hence they cannot be derived from something. you can derive them outside the scope of normal SQL by using functions or shell scripts, but probably not inside an SQL context. rgds, dotyet On Tue, Sep 30, 2008 at 12:10 PM, Scott Marlo

[GENERAL] Horology test failure while compiling PostgreSQL 8.3.3 on Solaris 10 x64

2008-08-15 Thread Dot Yet
Hi Eveyone, I am trying to compile PostgreSQL 8.3.3 on Solaris 10 x64. The tools involved were: OpenSSL 0.9.8h 28 May 2008 PostgreSQL 8.3.3 CC: Sun C++ 5.8 2005/10/13 Configure command: ./configure --prefix=/opt/usr/local/amd64 --with-openssl --with-libraries=/opt/usr/local/amd64/lib --with-incl

Re: [GENERAL] pg_version is missing

2008-04-29 Thread Dot Yet
was there an explicit definition of $PGDATA variable pointing to the data_old location? rgds, dotyet On Fri, Apr 25, 2008 at 8:47 AM, Roberts, Jon <[EMAIL PROTECTED]> wrote: > I had a problem with a database yesterday on a Windows server. The > service was described as executing "C:\Program > F

Re: [GENERAL] Unique indicies

2008-02-22 Thread Dot Yet
oops yeah... must have read it clearly rgds, dotyet On 2/22/08, Erik Jones <[EMAIL PROTECTED]> wrote: > > > On Feb 22, 2008, at 8:38 AM, Dot Yet wrote: > > > that would mean > > > > Every row in foo for column f1 has to be unique > > and > >

Re: [GENERAL] Unique indicies

2008-02-22 Thread Dot Yet
that would mean Every row in foo for column f1 has to be unique and Every row in foo for column f2 has to be unique Say for example: create table test1 ( a int, b int ) ; create unique index idx_t1_a on test1(a) ; create unique index idx_t1_b on test1(b) ; insert into test1 values (1,1) ; -- O

Re: [GENERAL] SSL Connectivity on Solaris 10 x86

2007-10-30 Thread Dot Yet
I am using md5. OK. thanks for the clue... Now, for the root certificate anyone? :) regards, dotyet On 10/30/07, Tom Lane <[EMAIL PROTECTED]> wrote: > > "Dot Yet" <[EMAIL PROTECTED]> writes: > > I am seeing this "Connection reset by peer" me

[GENERAL] SSL Connectivity on Solaris 10 x86

2007-10-29 Thread Dot Yet
Hello Everyone, I have configured SSL for my postgreSQL setup. The environment is PostgreSQL 8.2.5 (64-bit) built using Sun tools with ssl flag OpenSSL 0.9.8d 28 Sep 2006 OpenSolaris 5.11 snv_73 I have configured the server key and certificate file using openssl. The connection between a remote

Re: [GENERAL] Postgres 8.2.5 compilation problem on OpenSolaris/Solaris

2007-10-11 Thread Dot Yet
/07, Erik Jones <[EMAIL PROTECTED]> wrote: > > On Oct 11, 2007, at 2:30 PM, Dot Yet wrote: > > > Hi everyone, > > > > I am trying to get the postgresql 8.2.5 version working on my > > opensolaris nv 73 server. > > > > The configuration information

[GENERAL] Postgres 8.2.5 compilation problem on OpenSolaris/Solaris

2007-10-11 Thread Dot Yet
Hi everyone, I am trying to get the postgresql 8.2.5 version working on my opensolaris nv 73 server. The configuration information is as follows: SunOS db03nge0 5.11 snv_73 i86pc i386 i86pc $ isainfo -v 64-bit amd64 applications ahf sse3 sse2 sse fxsr amd_3dnowx amd_3dnow amd_mmx mmx cmo