Re: [GENERAL] pgsql cvs

2004-10-16 Thread snpe
On Saturday 16 October 2004 04:48 pm, Marc G. Fournier wrote: > On Sat, 16 Oct 2004, snpe wrote: > > > Devrim, > > I update cvs in last two years with > > cd /u1/pgsql > > cvs up -dPC > > > > I see this error today and I delete all and checkout again

Re: [GENERAL] pgsql cvs

2004-10-15 Thread snpe
Devrim, I update cvs in last two years with cd /u1/pgsql cvs up -dPC I see this error today and I delete all and checkout again It is fine now; pgsql guys destroy cvs often regards On Friday 15 October 2004 06:52 pm, Devrim GUNDUZ wrote: > > Hi, > > On Fri, 15 Oct 2004, snpe wro

Re: [GENERAL] pgsql cvs

2004-10-15 Thread snpe
/optimizer/path cvs update: cannot open directory /projects/cvsroot/pgsql-server/src/backend/optimizer/plan: No such file or directory On Friday 15 October 2004 06:13 pm, Devrim GUNDUZ wrote: > > Hi, > > On Fri, 15 Oct 2004, snpe wrote: > > > Is it do

[GENERAL] pgsql cvs

2004-10-15 Thread snpe
Is it down ? regards ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [GENERAL] 7.5 features

2003-12-15 Thread snpe
On Monday 15 December 2003 08:30 am, Tino Wildenhain wrote: > Hi Harsi, > > snpe schrieb: > > On Sunday 14 December 2003 03:51 pm, Tino Wildenhain wrote: > >>Hi snpwhatever, > >> > >>snpe wrote: > >>>Hello, > >>> Can PostgreSQL

[GENERAL] Oracle and regular expressions ???

2003-09-09 Thread snpe
New features in version 10g (commin soon) : SQL Regular Expressions ... regards ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [GENERAL] Performance tuning for linux, 1GB RAM, dual CPU?

2001-07-12 Thread snpe
> Another factor, not under our control, is that if the shared memory > region gets too large the kernel may decide to swap out portions of > it that haven't been touched lately. This of course is completely > counterproductive, especially if what gets swapped is a dirty buffer, > which'll event

Re: [GENERAL] Simple question for SQL Student

2001-05-23 Thread snpe
On Monday 21 May 2001 01:27, Johnny_ wrote: > I want to use an aggregate function in the WHERE clause and SQL Server 7 > won't let me? Specifically, I need to find a customer ID where the budget > is equal to MAX(budget). Is my logic wrong? How can I display the the > customer ID with the b

Re: [GENERAL] Performance aggregates

2001-05-16 Thread snpe
On Tuesday 15 May 2001 14:40, you wrote: > Hello, > > I have 2 tables : > > CREATE TABLE e_kalkn ( > idINT4 NOT NULL, > roba VARCHAR(6) NOT NULL, > dat DATENOT NU

Re: [GENERAL] Performance aggregates

2001-05-15 Thread snpe
On Tuesday 15 May 2001 17:28, Stephan Szabo wrote: > On Tue, 15 May 2001, snpe wrote: > > Table e_kalkn have 4668 rows and e_kalkns 101170 rows. > > > > Query : > > > > select roba,sum(izn) > > from e_kalkn k,e_kalkns ks > > where k.id=ks.id > &g

Re: [GENERAL] Performance aggregates

2001-05-15 Thread snpe
On Tuesday 15 May 2001 17:28, Stephan Szabo wrote: > On Tue, 15 May 2001, snpe wrote: > > Table e_kalkn have 4668 rows and e_kalkns 101170 rows. > > > > Query : > > > > select roba,sum(izn) > > from e_kalkn k,e_kalkns ks > > where k.id=ks.id > &g

[GENERAL] Contraints in postgresql ?

2001-05-14 Thread snpe
Hello, I want next : a) add constraint (primary and foreign) in existing table b) temporary disable constraint and enable later Is it possible in Postgresql ? Haris Peco [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: su

[GENERAL] Size of table in postgresql

2001-01-30 Thread snpe
Hello, Can I calculate size of table in postgresql and how ? Haris Peco [EMAIL PROTECTED]