[GENERAL] the impact of encoding on performance.

Hi All Snip The drawback of using locales other than C or POSIX in PostgreSQL is its performance impact. It slows character handling and prevents ordinary indexes from being used by LIKE. For this reason use locales only if you actually need them. snip; What is the impact of the locale on

Re: [GENERAL] pl sql to check if table of table_name exists

Title: RE: [GENERAL] pl sql to check if table of table_name exists Hi Hate to ask, but it isnt obvious to me from the documentation. How do I perform a query in pgplsql, to check it a table exists of a particular name. Thanks in advance Kind Regards, Shaun Clements

Re: [GENERAL] pl sql to check if table of table_name exists

Title: RE: [GENERAL] pl sql to check if table of table_name exists Much appreciated. Thanks Kind Regards, Shaun Clements -Original Message- From: Adam Tomjack [mailto:[EMAIL PROTECTED]] Sent: 10 March 2005 11:04 AM To: Shaun Clements Cc: postgresql Subject: Re: [GENERAL] pl sql to

Re: [GENERAL] partitionning

Greg Stark wrote: Actually I have a strong feeling what really _ought_ to happen here is that the inherited tables support in postgres, which never really worked anyways, should be deprecated and eventually removed. All that infrastructure should be repurposed into partitioned tables. That seems

[GENERAL] Problem with inherited table, can you help?...

I have the following three tables and my inserts are blocking each other in a way I just can't understand Can someone point me in the direction as to what is causing this? jobs= \d master.locations Table master.locations Column|

Re: [GENERAL] pl sql to check if table of table_name exists

Shaun Clements wrote: Hi Hate to ask, but it isnt obvious to me from the documentation. How do I perform a query in pgplsql, to check it a table exists of a particular name. Check the manual. There are two ways to d othis. You could query the data catalogs directly (something like count(*)

Re: [GENERAL] Disabling triggers in a transaction

I just got this rather wild idea, don't really have the opportunity to think it through thoroughly right now... Say, you create a table with a set of triggers that have some method of checking whether triggers should be enabled in this session, and containing some stubs where actual trigger

[GENERAL] postgres 8 settings

Hi, I have a 64 bit Opteron m/c with 32GB RAM and ~500GB HardDrive. The database size is ~45GB. I am using the following values in postgresql.conf: shared_buffers = 10 work_mem = 128000 maintenance_work_mem = 10 max_fsm_pages = 20 bgwriter_percent = 0 bgwriter_maxpages = 0 fsync =

[GENERAL] Locale problem

Hi ! Im running PG 7.23 now with text fields in CP866. I tried to restore dump from 7.23 into PG 8.01 with following settings : - initdb --locale ru_RU - createdb -E ALT. all works great , but sort order in text fields is wrong People, help pls to megrate to PG 8.01 properly Thanks,

Re: [GENERAL] PostgreSQL still for Linux only?

Joshua D. Drake wrote: Nobody should ever put a server regardless of OS on a public IP. It should always be firewalled/Nat/Port Forwarding. Except for the firewall/Nat server, of course :D -- Alban Hertroys ---(end of broadcast)--- TIP 3: if

Re: [GENERAL] pl sql to check if table of table_name exists

Title: RE: [GENERAL] pl sql to check if table of table_name exists selectyour_tablename from pg_class where relkind='r' "Shaun Clements" [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... Hi Hate to ask, but it isnt obvious to me from the documentation. How do I perform

Re: [GENERAL] pl sql to check if table of table_name exists

Title: RE: [GENERAL] pl sql to check if table of table_name exists i mean select* from pg_class where relkind='r' and relname=your_tablename "Sim Zacks" [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... selectyour_tablename from pg_class where relkind='r' "Shaun

Re: [GENERAL] pl sql to check if table of table_name exists

Title: RE: [GENERAL] pl sql to check if table of table_name exists Hi Sim Thanks for your response. I had it working from a previous post by Adam Tomjack. snip -- A list of tables: SELECT schemaname, tablename FROM pg_tables; -- Returns true if a table exists: SELECT count(*)0 FROM

[GENERAL] normal user dump gives error because of plpgsql

Hi, i have a normal user with rights to create a db. template1 contains language plpgsql. the user wants to - dump his db - drop his db - create it again - and use the dump file to fill it. it gives errors because of CREATE LANGUAGE statements inside the dump. How can i prevent that the dump

Re: [GENERAL] Locale problem

go wrote: Hi ! Im running PG 7.23 now with text fields in CP866. I tried to restore dump from 7.23 into PG 8.01 with following settings : - initdb --locale ru_RU - createdb -E ALT. all works great , but sort order in text fields is wrong Both on Linux and Windows you should use for your

Re: [GENERAL] normal user dump gives error because of plpgsql

On Thu, Mar 10, 2005 at 01:31:26PM +0100, Janning Vygen wrote: Hi, i have a normal user with rights to create a db. template1 contains language plpgsql. the user wants to - dump his db - drop his db - create it again - and use the dump file to fill it. it gives errors because of CREATE

Re: [GENERAL] pl sql to check if table of table_name exists

Title: RE: [GENERAL] pl sql to check if table of table_name exists I'm gladto hear yougot itworking. In explanation to my response: the pg_class internal table lists all the relationships in the database. relkind='r' means that the relation you are looking for is a table (relation), I

Re: [GENERAL] pl sql to check if table of table_name exists

Title: RE: [GENERAL] pl sql to check if table of table_name exists Hi Sim Thanks for your input. Kind Regards,Shaun Clements -Original Message-From: Sim Zacks [mailto:[EMAIL PROTECTED]Sent: 10 March 2005 02:47 PMTo: pgsql-general@postgresql.orgSubject: Re: [GENERAL] pl sql to

Re: [GENERAL] postgres 8 settings

On Thu, 10 Mar 2005 09:58:02 +, vinita bansal [EMAIL PROTECTED] wrote: Hi, I have a 64 bit Opteron m/c with 32GB RAM and ~500GB HardDrive. The database size is ~45GB. I've got a similar box, but with only 16G RAM. What is the storage subsystem, fibre channel or SCSI? Also, what OS?

[GENERAL] postgres db failure

hi folks the postgres fail with follow mwssage pg_dump: dumpClasses(): SQL command failed pg_dump: Error message from server: ERROR: xlog flush request 190/3F08779C is not satisfied --- flushed only to 190/3FD0 CONTEXT: writing block 268606 of relation 17142/17501 any clue? best

Re: [GENERAL] PostgreSQL still for Linux only?

While we run PostgreSQL on Free-BSD for our production systems, we have 'demo' laptop windows XP systems that contain the entire server architecture (application server, database, win32 client, etc). Sure is handy to be able to run PostgreSQL on windows and not have to change anything..

Re: [GENERAL] postgres db failure

marcelo Cortez wrote: hi folks the postgres fail with follow mwssage pg_dump: dumpClasses(): SQL command failed pg_dump: Error message from server: ERROR: xlog flush request 190/3F08779C is not satisfied --- flushed only to 190/3FD0 CONTEXT: writing block 268606 of relation 17142/17501

Re: [GENERAL] partitionning

On Wed, 2005-03-09 at 17:29, Greg Stark wrote: Scott Marlowe [EMAIL PROTECTED] writes: But what I'm really saying is that between good home grown partitioning and fast hardware, the need for the pg devel team to implement partitioning is pretty low. Ah. I thought you were saying that

[GENERAL] Loading of native libraries in PLJAVA

Title: Loading of native libraries in PLJAVA We are facing 2 problems in loading files from Pljava. 1. Loading Native C library from Pljava trigger. From Pljava trigger, we were trying to load native library, Using System.loadLibrary(library_name), which is specified in the

Re: [GENERAL] postgres 8 settings

vinita bansal [EMAIL PROTECTED] writes: Do these settings seem fine or I am making some mistake. These settings when used with Postgres 7.4 gave me good results but they don't seem to work with Postgres 8.0. Am I missing out on something?? Define don't seem to work, please. Offhand the only

Re: [GENERAL] PostgreSQL still for Linux only?

Hi all, In my country Nigeria (and even African continent), we do not eat what the western world eat. We wear different styles of cloths. In the same vein, our computerisation culture is different. I must submit that computers became popular in Nigeria by Windows desktop system. While the

Re: [GENERAL] Loading of native libraries in PLJAVA

Nageshwar, This is not the right forum for PL/Java issues. You should use mailing list at [EMAIL PROTECTED] We are facing 2 problems in loading files from Pljava. 1. Loading Native C library from Pljava trigger. From Pljava trigger, we were

Re: [GENERAL] Problem with inherited table, can you help?...

On Thu, Mar 10, 2005 at 01:31:21AM -0800, Net Virtual Mailing Lists wrote: 1. set search_path=jl_site2,public; 2. BEGIN; 3. INSERT INTO locations (user_id, city, state_id, zip, country_id, loc_type, deleted, entered_dt) VALUES (37613, 'Glendale', 3, '85301', 1, 'secondary', 'f', now());

Re: [GENERAL] normal user dump gives error because of plpgsql

I'm pretty sure I had the same problem when using pg_restore. If pl/pgsql is installed in template1, then the restore fails. And I couldn't find any solution to this on the list either. I definitely want pl/pgsql in template1 so that any databases I create have access to pl/pgsql without having

Re: [GENERAL] normal user dump gives error because of plpgsql

John Sidney-Woollett [EMAIL PROTECTED] writes: I'm pretty sure I had the same problem when using pg_restore. If pl/pgsql is installed in template1, then the restore fails. And I couldn't find any solution to this on the list either. You're supposed to restore into a database cloned from

Re: [GENERAL] PostgreSQL still for Linux only?

On Thu, 2005-03-10 at 10:19, Tope Akinniyi wrote: Hi all, Howdy. Glad to have you on the lists. 1. If I can manage it, can I continue to use PostgreSQL on Windows and watch as it evolves? I recognise the points certain respondents made on earlier; which was PostgreSQL on Windows is still a

Re: [GENERAL] normal user dump gives error because of plpgsql

Tom Lane wrote: John Sidney-Woollett [EMAIL PROTECTED] writes: I'm pretty sure I had the same problem when using pg_restore. If pl/pgsql is installed in template1, then the restore fails. And I couldn't find any solution to this on the list either. You're supposed to restore into a database

[GENERAL] postgres 7.4 build for win

Hi, I am trying to build postgres 7.4.5 on windows (200) on mingw/msys env. I have installed win32-pthreads to enable-thread safet feature. Couple of issues that I wanted to check:. i) The configure was --enablethread-safety flag for the platform (it was complaining CANNOT enable threads on

Re: [GENERAL] postgres 7.4 build for win

Hi Amin, maybe I'm little off but why don't you try the 8.0.1 version which should run on Windows platform? Miroslav ulc Amin Abdulghani wrote: Hi, I am trying to build postgres 7.4.5 on windows (200) on mingw/msys env. I have installed win32-pthreads to enable-thread safet feature. Couple of

[GENERAL] Process list in PostgreSQL 8.0

Hi All, We upgraded to Postgres 8.0 on a Linux (RHEL) machine yesterday and notice a slightly different list when looking at the processes (ps). 11679 ? S 0:00 postgres: iacm didit 216.187.113.78(56640) idle 11680 ? S 0:07 postgres: iacm didit 216.187.113.78(56641) idle 11863 ? S 0:00 postgres:

Re: [GENERAL] postgres 7.4 build for win

Hi, I am trying to build postgres 7.4.5 on windows (200) on mingw/msys env. I have installed win32-pthreads to enable-thread safet feature. Couple of issues that I wanted to check:. 7.4 is not supported natively on win32. If you need it on windows, you need to use cygwin. If you can, go to

Re: [GENERAL] Process list in PostgreSQL 8.0

Ericson Smith [EMAIL PROTECTED] writes: 11679 ? S 0:00 postgres: iacm didit 216.187.113.78(56640) idle 11680 ? S 0:07 postgres: iacm didit 216.187.113.78(56641) idle 11863 ? S 0:00 postgres: iacm didit 216.187.113.89(41860) idle 11864 ? R 0:09 postgres: iacm didit 216.187.113.89(41861) INSERT

Re: [GENERAL] postgres 7.4 build for win

I went for 8.0.1. Now compiling that (I need to compile it with enable-thread-safety) it throws THREAD-SAFETY requires POSIX signals. Has this issue been looked upon earlier .. I am not totally sure if we need the thread-safey flag on windows or not, but it would be nice to know if someone

Re: [GENERAL] PostgreSQL still for Linux only?

Tope, As someone who's been on these lists for several years now, I can honestly say they're among the friendliest and most helpful I've found. i can certainly echo that sentiment. from what i can tell, Tom in particular (since he's been 'called out' here) has (most of the time ...) the patience

Re: [GENERAL] error codes in log file?

On Thu, Mar 10, 2005 at 01:58:52PM -0500, David Parker wrote: Is there a postgresql.conf directive (7.4.5) which will result in error codes being emitted in the log file? I am thinking of the error codes in: http://www.postgresql.org/docs/7.4/interactive/errcodes-appendix.html. You could set

Re: [GENERAL] PostgreSQL still for Linux only?

...it will be the first time they have seen your name... ...with your first email have criticised the project... Check the archives. This poster has been active on the list for awhile. Cheers, Rick

Re: [GENERAL] New user: Windows, Postgresql, Python

Paul Moore [EMAIL PROTECTED] writes: I suppose my first (lazy) question is, is there a Python 2.4 compatible plpython.dll available anywhere? Alternatively, is there a way I can build one for myself? I'm happy enough doing my own build (I have mingw and msys available), but I'd rather not

Re: [GENERAL] PostgreSQL still for Linux only?

On Wed, Mar 09, 2005 at 11:39:53AM -0600, Doug Hall wrote: On Wed, 9 Mar 2005 11:02:10 -0600, Jim C. Nasby [EMAIL PROTECTED] wrote: ... but the fact is there's still a LOT of places that are windows shops and a LOT of people who use windows more heavily than *nix. More important, the egotism

[GENERAL] keeping track of when a row was last modified

Does postgres automatically keep track of when a row was last modified? Thanks ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] PostgreSQL still for Linux only?

On Wed, Mar 09, 2005 at 09:47:17AM -0800, Ben wrote: Ho ho, flame on! :) My completely annecodal experience with devs which prefer windows over posix is that the former prods things until they seem to work and accepts unexplained behavior far more readily than the latter. Do I *really* want

Re: [GENERAL] keeping track of when a row was last modified

On Thu, Mar 10, 2005 at 09:15:28PM +, Sally Sally wrote: Does postgres automatically keep track of when a row was last modified? No, but you can set up a trigger to do it. The Trigger Procedures section of the PL/pgSQL chapter in the documentation has an example:

Re: [GENERAL] keeping track of when a row was last modified

Nope, although there are plenty of trigger-based examples of doing so in the archives. -tfo -- Thomas F. O'Connell Co-Founder, Information Architect Sitening, LLC http://www.sitening.com/ 110 30th Avenue North, Suite 6 Nashville, TN 37203-6320 615-260-0005 On Mar 10, 2005, at 3:15 PM, Sally

Re: [GENERAL] keeping track of when a row was last modified

On Mar 10, 2005, at 4:15 PM, Sally Sally wrote: Does postgres automatically keep track of when a row was last modified? Thanks No. If you look on the SQL list in the past ten-20 minutes, there has been a discussion about this issue. Generally, you can use a trigger to update a timestamp when a

Re: [GENERAL] PostgreSQL still for Linux only?

On Wed, Mar 09, 2005 at 05:51:43PM -0800, Chris Travers wrote: Jim C. Nasby wrote: Ok--- I will admit to a anti-Windows bias. But at least my bias is informed. In addition to my former employment at Microsoft, I have studies both types of OS's in detail. Here are some specific comments

[GENERAL] Fwd: IO Timeout

I have a question about IO timeouts: We are using the 3ware escalade 9500S series of cards, and we had a drive failure this morning. Apparnetly the card waits 30 seconds for the drive to respond, and if it doesn't, it put's the drive in a fail state. Postgres it seems didn't wait 30 seconds

Re: [GENERAL] PostgreSQL still for Linux only?

On Thu, Mar 10, 2005 at 11:22:59AM -0600, Scott Marlowe wrote: 2. This response is alarming: Tom Lane wrote in digest V1.5092: We are supporting Windows as a Postgres platform for the benefit of developers who want to do testing on their laptops (and for reasons best known to themselves

Re: [GENERAL] PostgreSQL still for Linux only?

On Thu, 2005-03-10 at 16:19 +, Tope Akinniyi wrote: Hi all, --- cut --- I sought Windows replication tool for and could not get. I checked PgFoundry and the one there put a banner and said NOT FOR WINDOWS. Then I said is this PostgreSQL for Windows a joke? That prompted my post -

Re: [GENERAL] PostgreSQL still for Linux only?

On Thu, 2005-03-10 at 15:45, Jim C. Nasby wrote: On Thu, Mar 10, 2005 at 11:22:59AM -0600, Scott Marlowe wrote: 2. This response is alarming: Tom Lane wrote in digest V1.5092: We are supporting Windows as a Postgres platform for the benefit of developers who want to do testing on

Re: [GENERAL] PostgreSQL still for Linux only?

From: Tope Akinniyi snip experiences. As an IT organisation that wants to stay in business you need to give to people what they wants. I think that is the basis of service. I have some deployments of PostgreSQL on Windows servers. I must admit that we have not had any problems so far. /snip

Re: [GENERAL] the impact of encoding on performance.

Michael Ben-Nes [EMAIL PROTECTED] writes: The drawback of using locales other than C or POSIX in PostgreSQL is its performance impact. It slows character handling and prevents ordinary indexes from being used by LIKE. For this reason use locales only if you actually need them. What is

Re: [GENERAL] PostgreSQL still for Linux only?

Jim C. Nasby wrote: On Thu, Mar 10, 2005 at 11:22:59AM -0600, Scott Marlowe wrote: This is the second problem. Windows simply has problems that cause data relibility problems that may or may not be surmountable in the future. Do you have any references to these problems? I've seen several

Re: [GENERAL] SRF, JDBC and result info

On Tue, 8 Mar 2005 [EMAIL PROTECTED] wrote: Hi everybody! I have an SRF which is called from a JAVA app with JDBC. Everything works fine and I want now to be able to pass some result-related info to my app. It is not about the format of the results (ResultSetMetaData) or something like

Re: [GENERAL] Problem with inherited table, can you help?...

On Fri, 11 Mar 2005 03:39 am, Michael Fuhr wrote: On Thu, Mar 10, 2005 at 01:31:21AM -0800, Net Virtual Mailing Lists wrote: [snip] Some have suggested that PostgreSQL should use a weaker lock on the referenced key, but that hasn't been implemented yet. Are there actually any problems

Re: [GENERAL] SRF, JDBC and result info

Thank you very much for your reply. The thing is that my SRF is written in C, not plpgsql, but I'll look into RAISE NOTICE anyway.(I think there is something equevalent in libpq) Thanks again, Ntinos Katsaros Kris Jurka writes: On Tue, 8 Mar 2005 [EMAIL PROTECTED] wrote: Hi everybody!