pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: \i command
5+ messages / 3 participants
[nested] [flat]

* \i command
@ 2001-04-11 15:07 Najm Hashmi <najm@mondo-live.com>
  2001-04-10 18:37 ` Re: \i command Joel Burton <jburton@scw.org>
  0 siblings, 1 reply; 5+ messages in thread

From: Najm Hashmi @ 2001-04-11 15:07 UTC (permalink / raw)
  To: pgsql-sql

Hi All,
    From pgsql, I try to insert data in table using the \i command. Nothing
takes place and after this command pgsql is hung... i cant use it any more.
The same command works with all other tables but this is only one I am having
problem with.
I have attached my file with message. Could someone help me out here what is
the reason for this behaviour.
I am using  postgres7.03 on  RH 6.2.

Attachments:

  tracks.sql (text/plain, 76.7K) download

najm.vcf (text/x-vcard, 183B) download begin:vcard n:Hashmi;Najm x-mozilla-html:FALSE org:Mondo-Live.com;www.flipr.com adr:;;;;;; version:2.1 email;internet:najm@mondo-live.com x-mozilla-cpt:;6144 fn:Najm Hashmi end:vcard
^ permalink raw reply [nested|flat] 5+ messages in thread

* Re: \i command
  2001-04-11 15:07 \i command Najm Hashmi <najm@mondo-live.com>
@ 2001-04-10 18:37 ` Joel Burton <jburton@scw.org>
  2001-04-11 18:16   ` Re: Re: \i command Najm Hashmi <najm@mondo-live.com>
  0 siblings, 1 reply; 5+ messages in thread

From: Joel Burton @ 2001-04-10 18:37 UTC (permalink / raw)
  To: Najm Hashmi <najm@mondo-live.com>; +Cc: pgsql-sql

On Wed, 11 Apr 2001, Najm Hashmi wrote:

> Hi All,
>     From pgsql, I try to insert data in table using the \i command. Nothing
> takes place and after this command pgsql is hung... i cant use it any more.
> The same command works with all other tables but this is only one I am having
> problem with.
> I have attached my file with message. Could someone help me out here what is
> the reason for this behaviour.

Works just fine for me (Pg7.1 RC3, Linux).

Can you do manual inserts into the table?
Can you insert just a few records using \i?
Can you vacuum the table?


-- 
Joel Burton   <jburton@scw.org>
Director of Information Systems, Support Center of Washington




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Re: \i command
  2001-04-11 15:07 \i command Najm Hashmi <najm@mondo-live.com>
  2001-04-10 18:37 ` Re: \i command Joel Burton <jburton@scw.org>
@ 2001-04-11 18:16   ` Najm Hashmi <najm@mondo-live.com>
  2001-04-10 19:14     ` Re: Re: \i command Joel Burton <jburton@scw.org>
  2001-04-11 13:05     ` Re: Re: \i command cbell <cbell@lighthouseasp.com>
  0 siblings, 2 replies; 5+ messages in thread

From: Najm Hashmi @ 2001-04-11 18:16 UTC (permalink / raw)
  To: Joel Burton <jburton@scw.org>; +Cc: pgsql-sql

Joel Burton wrote:

> On Wed, 11 Apr 2001, Najm Hashmi wrote:
>
> > Hi All,
> >     From pgsql, I try to insert data in table using the \i command. Nothing
> > takes place and after this command pgsql is hung... i cant use it any more.
> > The same command works with all other tables but this is only one I am having
> > problem with.
> > I have attached my file with message. Could someone help me out here what is
> > the reason for this behaviour.
>
> Works just fine for me (Pg7.1 RC3, Linux).
>
> Can you do manual inserts into the table?
> Can you insert just a few records using \i?
> Can you vacuum the table?
>
> --
> Joel Burton   <jburton@scw.org>
> Director of Information Systems, Support Center of Washington
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Hi, No I can't even do manaul insert on that particular table. This is really
weird. Could this table's internals be corrupted?
 One  more thing, if I run the same file on another db it works just fine. I am
just wondering what is wrong with the structure.
Thank you for replying..... Anyone else has an idea about it????
Regards.

Attachments:

najm.vcf (text/x-vcard, 183B) download begin:vcard n:Hashmi;Najm x-mozilla-html:FALSE org:Mondo-Live.com;www.flipr.com adr:;;;;;; version:2.1 email;internet:najm@mondo-live.com x-mozilla-cpt:;6144 fn:Najm Hashmi end:vcard
^ permalink raw reply [nested|flat] 5+ messages in thread

* Re: Re: \i command
  2001-04-11 15:07 \i command Najm Hashmi <najm@mondo-live.com>
  2001-04-10 18:37 ` Re: \i command Joel Burton <jburton@scw.org>
  2001-04-11 18:16   ` Re: Re: \i command Najm Hashmi <najm@mondo-live.com>
@ 2001-04-10 19:14     ` Joel Burton <jburton@scw.org>
  1 sibling, 0 replies; 5+ messages in thread

From: Joel Burton @ 2001-04-10 19:14 UTC (permalink / raw)
  To: Najm Hashmi <najm@mondo-live.com>; +Cc: pgsql-sql

On Wed, 11 Apr 2001, Najm Hashmi wrote:

> Joel Burton wrote:
> 
> > On Wed, 11 Apr 2001, Najm Hashmi wrote:
> >
> > >     From pgsql, I try to insert data in table using the \i command. Nothing
> > > takes place and after this command pgsql is hung... i cant use it any more.
> > > The same command works with all other tables but this is only one I am having
> > > problem with.
> > > I have attached my file with message. Could someone help me out here what is
> > > the reason for this behaviour.
> >
> > Can you do manual inserts into the table?
> > Can you insert just a few records using \i?
> > Can you vacuum the table?
> 
> Hi, No I can't even do manaul insert on that particular table. This is really
> weird. Could this table's internals be corrupted?
>  One  more thing, if I run the same file on another db it works just fine. I am
> just wondering what is wrong with the structure.
> Thank you for replying..... Anyone else has an idea about it????
> Regards.

The problem is almost certainly not w/your structure at all. Your tables
has probably just become corrupted. Can you vacuum it? Can you dump it
and recreate it?

(You may also want to try running postmaster at a higher level of debug
and checking the logs.) 

Good luck,

-- 
Joel Burton   <jburton@scw.org>
Director of Information Systems, Support Center of Washington




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Re: \i command
  2001-04-11 15:07 \i command Najm Hashmi <najm@mondo-live.com>
  2001-04-10 18:37 ` Re: \i command Joel Burton <jburton@scw.org>
  2001-04-11 18:16   ` Re: Re: \i command Najm Hashmi <najm@mondo-live.com>
@ 2001-04-11 13:05     ` cbell <cbell@lighthouseasp.com>
  1 sibling, 0 replies; 5+ messages in thread

From: cbell @ 2001-04-11 13:05 UTC (permalink / raw)
  To: Najm Hashmi <najm@mondo-live.com>; +Cc: pgsql-sql

I don't know if you've resolved your problem, but if not, you could try deleting and
recreating the indexes on the table...

Najm Hashmi wrote:

> Joel Burton wrote:
>
> > On Wed, 11 Apr 2001, Najm Hashmi wrote:
> >
> > > Hi All,
> > >     From pgsql, I try to insert data in table using the \i command. Nothing
> > > takes place and after this command pgsql is hung... i cant use it any more.
> > > The same command works with all other tables but this is only one I am having
> > > problem with.
> > > I have attached my file with message. Could someone help me out here what is
> > > the reason for this behaviour.
> >
> > Works just fine for me (Pg7.1 RC3, Linux).
> >
> > Can you do manual inserts into the table?
> > Can you insert just a few records using \i?
> > Can you vacuum the table?
> >
> > --
> > Joel Burton   <jburton@scw.org>
> > Director of Information Systems, Support Center of Washington
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
> Hi, No I can't even do manaul insert on that particular table. This is really
> weird. Could this table's internals be corrupted?
>  One  more thing, if I run the same file on another db it works just fine. I am
> just wondering what is wrong with the structure.
> Thank you for replying..... Anyone else has an idea about it????
> Regards.
>
>   ------------------------------------------------------------------------
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl




^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2001-04-11 18:16 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-04-11 15:07 \i command Najm Hashmi <najm@mondo-live.com>
2001-04-10 18:37 ` Joel Burton <jburton@scw.org>
2001-04-11 18:16   ` Najm Hashmi <najm@mondo-live.com>
2001-04-10 19:14     ` Joel Burton <jburton@scw.org>
2001-04-11 13:05     ` cbell <cbell@lighthouseasp.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox