Re: [ADMIN] Share Data between PostgreSQL and Oracle

Hai friend Perl DBI and DBD cab be user for accessing oracle or postgress. I think, you are looking for this kind of solution Regards raja --- David Wagoner <[EMAIL PROTECTED]> wrote: > Anyone have experience doing this? I would like to > hear your tips and > experiences. > > Here's our situati

[ADMIN] give me suggestion pl.

Hai all, I have created two tables as follows CREATE TABLE AAA( ORG CHAR(4), TERM CHAR(4), ID CHAR(4), NAME VARCHAR(15) NOT NULL, DTTIME TIMESTAMP DEFAULT NOW(), ... . . . 44 fields CONSTRAINT AAA PRIMARY KEY (ORG,TERM,ID), CONSTRAINT AAA_NAME_UNIQ UN

[ADMIN] Help in storing passwords

Hai Friends, I want to store passwords in a table. How can I do it ? How can I convert the ordinary table into Special type ? Thanks raja __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://ph

[ADMIN] how do i get setof items from a plpgsql funtion?

Friends, I wanted to select setof items from a plpgsql funtion. I know that plpgsql funtion can return a setof items. But i don't know how to write that kind of funtion. Please help me in this reg. advance thanks rajaDo You Yahoo!? Get email alerts & NEW webcam video instant messaging with Yahoo! M

Re: [ADMIN] database cluster

 you can rename that dir. i.e mv abcd abcdold   Jodi Kanter <[EMAIL PROTECTED]> wrote: Let's try this again. Please respond to this message as it has mycorrect email addressI mistakenly created a second database cluster. Can someone tell me howto remove this?Also, I need to reinitializ

Re: [ADMIN] Vaccum

No problem, we are doing vaccume different tables at different times. Because if you do vaccume it will decrease the performace of data base you can write scripts like this. -cleanTable.sh #!/sbin/shecho "## START:## Clean Table  $1 ##"/usr/local/pgsql/bin/psql

[ADMIN] Any body know --- 'sql query where condition execution plan'

 Hai every body, I want to know how the--where condition--is executed in a sql query. e.g., select aa,bb,cc from ttt where aa=100 and bb = 200 and cc =300. my doubt is , will psql leave the record as on when it fails to satisfy a record having aa !=100  or will it chect for bb = 200 and cc = 300 a

[ADMIN] how to alter sequence.

Hai friends, I have a sequence called raj_seq with max value 3000. I have a table, with one field haveing nextvalu('raj_seq') as default value.; now i wanted to increase the max value of the raj_seq to 999. How to do this change? If i drop and recreate the raj_seq, then i have to recreate the t

Re: [ADMIN] how to alter sequence.

Hai friend, Thanks. But I wanted to change the maximum value but not current value. How to change the maximum value of a sequence raja --- Dan Langille <[EMAIL PROTECTED]> wrote: > On 4 Dec 2002 at 4:29, raja kumar thatte wrote: > > > Hai friends, > > I have a sequence

Re: [ADMIN] how to alter sequence.

Thsnkd --- Egon Reetz <[EMAIL PROTECTED]> wrote: > I meant start value (inst. min.). > > Egon Reetz wrote: > > > Drop the sequence and recreate with a min. value > greater your last value and > > the new max. value. > > > > Egon > > > >

Re: [ADMIN] how to alter sequence.

Thanks --- Egon Reetz <[EMAIL PROTECTED]> wrote: > I meant start value (inst. min.). > > Egon Reetz wrote: > > > Drop the sequence and recreate with a min. value > greater your last value and > > the new max. value. > > > > Egon > > > >

Re: [ADMIN] how to alter sequence.

Thanks everybody. --- Bruce Momjian <[EMAIL PROTECTED]> wrote: > Oliver Elphick wrote: > > On Wed, 2002-12-04 at 12:29, raja kumar thatte > wrote: > > > Hai friends, > > > I have a sequence called raj_seq with max value > 3000. > > ... > &

Re: [HACKERS] [ADMIN] how to alter sequence.

equence > suit the bill ? > > > > > > whats' the major advantage to implement em as a > command? > > > > > > At least one thing from which all of us can > benifit in PgSQL > > > is replication. I just hope 7.4 give us some > sort of mast

[ADMIN] vaccumdb is giving "ERROR: out of free buffers: time to abort !"

xyzdb After 7 to 8 hours I am getting ERROR: out of free buffers: time to abort ! vacuumdb: vacuum xyzdb failed What to do? Thanks in advance. c u raja = Raja Kumar Thatte, Research Engineer,TMN-Group,C-DOT, 71/1, Sneha Complex, Miller Road, Bangalore-560052. Phone:080-2389351/354

Re: [ADMIN] vaccumdb is giving "ERROR: out of free buffers: time to abort !"

Hai Tom Lane Thanks a lot. I think I have to increase shared_buffers. I will try. I think this will solve my problem c u raja --- Tom Lane <[EMAIL PROTECTED]> wrote: > Raja Kumar Thatte <[EMAIL PROTECTED]> writes: > > After 7 to 8 hours I am getting > > ERROR: o