[GENERAL] Resource temporarily unavailable

cpu time (seconds, -t) unlimited max user processes(-u) 256 virtual memory(kbytes, -v) unlimited im totaly bogus, any ideas ? Thanks -- Canaan Surfing Ltd. Internet Service Providers Ben-Nes Michael - Manager Tel: 972-4-6991122 Fax: 972-4

Re: [GENERAL] Is this a Stupid Question ?

cheers -- Canaan Surfing Ltd. Internet Service Providers Ben-Nes Michael - Manager Tel: 972-4-6991122 Fax: 972-4-6990098 http://www.canaan.net.il -- - Original Message - From: Adam Smith [EMAIL PROTECTED] To: [EMAIL PROTECTED]@postgresql.org Sent

Re: [GENERAL] Database Size Limiting

Title: Database Size Limiting I wonder if this will work: each DB should assigned a diffrent user with set of premissions ( including insert ). a script that can revoke the inseret privilage will emarge from time to time to check the DB size. --Canaan Surfing

[GENERAL] defferable update unique

Hi All Does 7.4 support defferable updates on unique column ? example unique INT colum named u_test has the following values: 1, 2, 3, 4, 5 can i do update table set u_test = u_test + 1; cheers -- Canaan Surfing Ltd. Internet Service Providers Ben-Nes Michael - Manager

Re: [GENERAL] Recomended FS

- Original Message - From: Shridhar Daithankar [EMAIL PROTECTED] To: Ben-Nes Michael [EMAIL PROTECTED] Cc: Nick Burrett [EMAIL PROTECTED]; postgresql [EMAIL PROTECTED] Sent: Monday, October 20, 2003 3:06 PM Subject: Re: [GENERAL] Recomended FS Ben-Nes Michael wrote: I'm saying: don't

Re: [GENERAL] Recomended FS

what about mirroring only ? raid 1 ? I always thought that raid 1 is the fastest, am I true ? I don't really need more then 3GB data and I have two 36GB HD. so I don't need lvl 0 nor lvl 5 unless raid 1 is slower. -- Canaan Surfing Ltd. Internet Service Providers Ben-Nes

Re: [GENERAL] Disable Transaction - plans ?

of tables into Postgres that will enable the most simplest fastest query. If the developers think that the speed increase is irrelevant then lets drop the issue :) -- Canaan Surfing Ltd. Internet Service Providers Ben-Nes Michael - Manager Tel: 972-4-6991122 http

[GENERAL] install only pg_dump

Hi All I need to do dumps for backups from a redhat6.2 mechine. I dont want to install the whole server for just one utility nor could I find a proper rpm. Any sugestions ? the server 7.1.3 is on redhat 7.1 -- Canaan Surfing Ltd. Internet Service Providers Ben-Nes

[GENERAL] sub select

Can I: select *, sum_rows as ( select count(*) from table2; ) from table1; -- Canaan Surfing Ltd. Internet Service Providers Ben-Nes Michael - Manager Tel: 972-4-6991122 http://sites.canaan.co.il -- ---(end of broadcast

Re: [GENERAL] store in bytea

It sure is :) On the theoretical issue, can I use TEXT field to store binary ? If so, what will be the case with addslashes ? will it work ? - Original Message - From: Joe Conway [EMAIL PROTECTED] To: Ben-Nes Michael [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, August 23, 2001

Re: [GENERAL] store in bytea

select for output. Does any one here save his website images on DB and retrive them out on his web page ? Ben-Nes Michael [EMAIL PROTECTED] writes: On the theoretical issue, can I use TEXT field to store binary ? TEXT will not handle null (zero) bytes. If you are using a multibyte

Re: [GENERAL] Roll Back dont roll back counters

that... -- Canaan Surfing Ltd. Internet Service Providers Ben-Nes Michael - Manager Tel: 972-4-6991122 http://sites.canaan.co.il -- ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http

Re: [GENERAL] VACUUM ANALYZE - with debug

- From: Stephan Szabo [EMAIL PROTECTED] To: Ben-Nes Michael [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, July 20, 2001 6:59 PM Subject: Re: [GENERAL] VACUUM ANALYZE Hmm, unfortunate (was hoping that only the bottom of the trace was only addresses). Can you turn on --enable-debug (from

[GENERAL] readline and rh7.1

? -- Canaan Surfing Ltd. Internet Service Providers Ben-Nes Michael - Manager Tel: 972-4-6991122 http://sites.canaan.co.il -- ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http

Re: [GENERAL] readline and rh7.1

Yes I did with locale + debug - Original Message - From: Trond Eivind Glomsrød [EMAIL PROTECTED] To: Ben-Nes Michael [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, July 29, 2001 6:36 PM Subject: Re: [GENERAL] readline and rh7.1 Ben-Nes Michael [EMAIL PROTECTED] writes

Re: [GENERAL] readline and rh7.1

The RPM support locale ? If not I cant use them :( - Original Message - From: Trond Eivind Glomsrød [EMAIL PROTECTED] To: Ben-Nes Michael [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, July 30, 2001 7:12 AM Subject: Re: [GENERAL] readline and rh7.1 Ben-Nes Michael [EMAIL

Re: [GENERAL] VACUUM ANALYZE

fault. #0 0x4014d8e0 in ?? () - Original Message - From: Stephan Szabo [EMAIL PROTECTED] To: Ben-Nes Michael [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, July 18, 2001 9:17 PM Subject: Re: [GENERAL] VACUUM ANALYZE It looks like the backend (I'd assume this one) crashed

[GENERAL] two constrains for one column

Hi All im trying to do the next thing, is it possible ? CREATE TABLE language ( language serial PRIMARY KEY, shortcut char(2) NOT NULL, unique, -- like il,en,fr,sp ); ---(end of broadcast)--- TIP 2: you can get off all lists at once with the

[GENERAL] locale per db / table / column

? -- Canaan Surfing Ltd. Internet Service Providers Ben-Nes Michael - Manager Tel: 972-4-6991122 http://sites.canaan.co.il -- ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate

Re: [GENERAL] autoincrement???

Use the Serial type for address_id. And you should read the Manuals ! :) - Original Message - From: Markus Jais [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 13, 2001 12:20 AM Subject: [GENERAL] autoincrement??? hi I have the following problem: I create the following

[GENERAL] hebrew charset

Hi All Any one know if Postgres have a support for the Hebrew charset. like when sorting with 'order by' -- -- Canaan Surfing Ltd. Internet Service Providers Ben-Nes Michael - Manager Tel: 972-6-6925757 Fax: 972-6-6925858 http://www.canaan.co.il --