[ADMIN] Who can resolve this BUG ?

2001-05-18 Thread Alexander Dederer
INM1=# explain select ref_num from grls where ag_id in (24); Index Scan using grls_ag_id on grls (cost=0.00..597.87 rows=849 width=12) IMN1=# explain select ref_num from grls where ag_id in (select 24); Seq Scan on grls (cost=0.00..992.44 rows=30195 width=12) SubPlan -> Materialize (cos

[GENERAL] Parallel Serever use PostgreSQL

2001-05-18 Thread Alexander Dederer
Help me, please. Can I create a 2 Parallel Server with clustrering DB PostgreSQL? ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[ADMIN] Re: Question / Joel /BE

2001-05-18 Thread Alexander Dederer
Jo?l Francken wrote: > I'd like to know if it is possible to select data from a db on a server > and then to insert it on an other server ? > Is there somth like > > SELECT * INTO backup FROM server.database.table; > > Is there an alternate solution ? As I know it's in 7.1.1 not working. Try Per

[ADMIN] Re: Need Help in creating script

2001-05-18 Thread Alexander Dederer
Prashant Sinha wrote: > This is a multi-part message in MIME format. > > --=_NextPart_000_0021_01C0DE12.BB861C80 > Content-Type: text/plain; charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > Hi, > I am a new postgre user. I had used sql commands to create database and >