[ADMIN]
http://arkofnoah.net/modules/mod_wdbanners/xmas.php?people128.gif";>http://arkofnoah.net/modules/mod_wdbanners/xmas.php?people128.gif
[ADMIN]
http://tikiboma.tripod.com/ _ Hotmail is redefining busy with tools for the New Busy. Get more from your inbox. http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_2
[ADMIN]
http://pabivano.t35.com/ _ Hotmail is redefining busy with tools for the New Busy. Get more from your inbox. http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_2
[ADMIN] unsubscribe
unsubscribe Get a FREE online computer virus scan from McAfee when you click here.
[ADMIN] unsubscribe
unsubscribe Say good-bye to spam, viruses and pop-ups with MSN Premium -- free trial offer!
[ADMIN] !!!!!UrgentERROR: cannot read block 95 of t : Input/output error
Help needed please-- ERROR: cannot read block 2 of pg_toast_17939_idx: Input/output error" what does this mean?. After some investigation found out that this happened after a vacuum of a table vacuum t;ERROR: cannot read block 95 of t: Input/output error Somebody please help to fix this problem Thanks, Pnair Check your PC for viruses with the FREE McAfee online computer scan.
[ADMIN] Help needed Please !!!!!incremental backups possible in 7.3 or 7.4?
Hi all, Is Incremental backups possible in Postgres 7.3 or 7.4 Thanks, PN Worried about inbox overload? Get MSN Extra Storage now!
[ADMIN] incremental backup possible in 7.3 or 7.4?
Hi all, Is incremental backup possible in postgres 7.3 or 7.4? Thanks, Pn Check your PC for viruses with the FREE McAfee online computer scan.
[ADMIN] encrypt function
Is there any encrypt function in postgres? like encrypt('string')... Thanks, pn See when your friends are online with MSN Messenger 6.0. Download it now FREE!
Re: [ADMIN] sql scripts
Use pg_dump -c this will drop the db objects before creating them Priya >From: Sam Carleton <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: [ADMIN] sql scripts >Date: Sat, 18 Oct 2003 22:37:00 -0400 > >I am new to postgres and your mailing lists, please let me know if I >am posting in the wrong list. > >I am working on creating my first database in Postgres. In the >script that will create all the tables for the firs time, I would >like to have a conditional statement to delete a table, if it >already exists. I know the other databases create such a condtional >statement for you when you export the schema. What would such a >conditional statement look like in Postgres's sql? > >sam > >---(end of broadcast)--- >TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly Fretting that your Hotmail account may expire because you forgot to sign in enough? Get Hotmail Extra Storage today!
[ADMIN] t help PostgreSQL server: FATAL 1: S
I saw this error PostgreSQL server: FATAL 1: Sorry, too many clients already in /usr/share/php/phplib/db_pgsql.inc on line 49. It seems like I have to increase the maximum connections in the postgresql.conf .Is that the right step to fix the problem..Also I am seeing lot of idle processess Help protect your PC. Get a FREE computer virus scan online from McAfee.
[ADMIN]
Is there a script that gives a list of sequences and the tables associated with it and the columns associated with it Thanks in advance SG Instant message in style with MSN Messenger 6.0. Download it now FREE!
[ADMIN] sequence table
Hi all, Is there a script where u can get list of sequences ,the tables associated with it and the column for which these sequences are created. Thanks in advance SG Instant message during games with MSN Messenger 6.0. Download it now FREE!
[ADMIN] seqeunces and related tables
is there a script where u can find all the sequences and the tables connected to these sequences and also the columns for which the sequences are described Thanks sree _ Instant message during games with MSN Messenger 6.0. Download it now FREE! http://msnmessenger-download.com ---(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: [ADMIN] help needed!!!
Since I am a novice can you explain more about this version mismatch? From: Bruce Momjian <[EMAIL PROTECTED]> To: Priya G <[EMAIL PROTECTED]> CC: [EMAIL PROTECTED] Subject: Re: [ADMIN] help needed!!! Date: Mon, 22 Sep 2003 14:46:27 -0400 (EDT) Priya G wrote: [ text/html is unsupported, treating like TEXT/PLAIN ] > > Hi all, > > The following message was found in the postgres logpostgres[20563]: [73256] FATAL 1: invalid length of startup packet > what does this mean? > > Thanks http://g.msn.com/8HMBENUS/2746??PS=";>Add MSN 8 Internet Software to your existing Internet access and enjoy patented spam protection and more. Sign up now! Odds are you have a mismatch between the client version and the server version. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 _ Instant message with integrated webcam using MSN Messenger 6.0. Try it now FREE! http://msnmessenger-download.com ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[ADMIN] help needed!!!
Hi all, The following message was found in the postgres logpostgres[20563]: [73256] FATAL 1: invalid length of startup packet what does this mean? Thanks Add MSN 8 Internet Software to your existing Internet access and enjoy patented spam protection and more. Sign up now!
[ADMIN] postgres[20563]: [73256] FATAL 1: invalid length of startup packet
Hi all, The following message was found in the postgres logpostgres[20563]: [73256] FATAL 1: invalid length of startup packet what does this mean? Thanks Get 10MB of e-mail storage! Sign up for Hotmail Extra Storage.
[ADMIN] postgres[20563]: [73256] FATAL 1: invalid length of startup packet
Hi all, This message was found in the postgres log .Can anybody explain to me what this means? Thanks Fast, faster, fastest: Upgrade to Cable or DSL today!
[ADMIN] pg_recvbuf : unexpected EOF on client
what does the error in postgres.log pg_recvbuf : unexpected EOF on client mean? thanks in advance Sree Get MSN 8 and help protect your children with advanced parental controls.
Re: [ADMIN] How to read a sequence without incrementing it?
select last_value from 'seq'; >From: Pierre Couderc <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: [ADMIN] How to read a sequence without incrementing it? >Date: Fri, 29 Aug 2003 18:27:09 +0200 > >I would like to read the current value of a sequence, or a value not >too far of the current value (for example, the value it was a few >seconds or minutes ago). Is it possible (without any nexrval that >should increment it)? > >Thank you all > >Pierre Couderc > > >---(end of >broadcast)--- >TIP 4: Don't 'kill -9' the postmaster Get MSN 8 and enjoy automatic e-mail virus protection.
Re: [ADMIN] This table won't use INDEX until I DUMP/RESTORE it ?
try to analyze the table. That may help to use the index >From: Chris Miles <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >CC: Chris Miles <[EMAIL PROTECTED]> >Subject: [ADMIN] This table won't use INDEX until I DUMP/RESTORE it ? >Date: Tue, 19 Aug 2003 17:46:16 +0100 > >I have a DB that appears to perform badly. A test of one table >with one of the typical queries gives me a query plan indicating >a Seq Scan; > >DB=# EXPLAIN select pcref,pcseqnbr from catrecrel where >pcbsref='something' and (pccaref is null or pccaref='') and pcpar >is null order by pcseqnbr ; >NOTICE: QUERY PLAN: > >Sort (cost=38266.65..38266.65 rows=4 width=58) > -> Seq Scan on catrecrel (cost=0.00..38266.61 rows=4 width=58) > >Ok, that's no good, but it _should_ be using an index instead, and >if I dump this table, restore it onto a different (non-live) DB, and >try again, I see that it does indeed plan to use the index: > >DB=# EXPLAIN select pcref,pcseqnbr from catrecrel where >pcbsref='something' and (pccaref is null or pccaref='') and pcpar >is null order by pcseqnbr ; >NOTICE: QUERY PLAN: > >Sort (cost=469.92..469.92 rows=1 width=58) > -> Index Scan using ind_pcbsref on catrecrel (cost=0.00..469.91 >rows=1 width=58) > >Now, why is this? The first (live) DB is VACUUM ANALYSEd nightly, >and >was done so again just before this test. Data, schema and indexes >should >be the same in both (well it was dumped/restored directly from one >to the >other). > >The only fix I can think of is to dump and restore the whole DB, >based on >the fact that a newly restored DB appears to work much better, but >surely >I shouldn't have to do this? What else can i do to fix it? > >Cheers, >CM > >-- >Chris Miles >http://chrismiles.info/ > > >---(end of >broadcast)--- >TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html MSN 8: Get 6 months for $9.95/month.
[ADMIN] forcce a table in memory
Is there any way in postgres that you can force a table to be in memory.Tired of spam? Get advanced junk mail protection with MSN 8.