Re: [GENERAL] pgbench

2006-03-04 Thread Tatsuo Ishii
pgbench comes with PostgreSQL source code distribution and must be compiled under PostgreSQL source tree. I'm not familiar with MacOS but I guess there may be pre-compiled package. Anyone can help him? -- Tatsuo Ishii SRA OSS, Inc. Japan I have just received my new MacBook (1.83Gz. Duo) and

Re: [GENERAL] problem with windows xp sp2 and postgres-8.1.3

2006-03-04 Thread Magnus Hagander
the lsp-fix did the trick. As you supposed it was a personal firewall (however a great product, called armor2net personal), which unfortunately was broken with the winsock lib. Obviously not a gread product, I'd say, if it breaks the winsock stack. Which the hole purpose of a firewall is to

Re: [GENERAL] problem with windows xp sp2 and postgres-8.1.3

2006-03-04 Thread Dave Page
-Original Message- From: [EMAIL PROTECTED] on behalf of Magnus Hagander Sent: Sat 3/4/2006 9:46 AM To: [EMAIL PROTECTED]; pgsql-general@postgresql.org Subject: Re: [GENERAL] problem with windows xp sp2 and postgres-8.1.3 But it specifically surprises me that it was necessary for psql

Re: [GENERAL] record OID to table

2006-03-04 Thread Karsten Hilbert
On Fri, Mar 03, 2006 at 09:01:53PM -0700, Michael Fuhr wrote: Could you explain what you're trying to do without reference to how you're trying to do it? It sounds like the goal is to take an arbitrary string and find out what rows in what tables contain that string. Is that right? If so

Re: [GENERAL] Quick psqlODBC driver setting

2006-03-04 Thread Rolf �stvik
Bart Golda [EMAIL PROTECTED] wrote in news:[EMAIL PROTECTED]: I would like to have an installation program, which creates psqlODBC connection, so there will be no need of typing and clicking on two hundred workstations... There is the driver's msi file which can be installed very nicely, but

Re: [GENERAL] How do I prevent binding to TCP/IP port outside of localhost?

2006-03-04 Thread hubert depesz lubaczewski
On 2/23/06, Karl Wright [EMAIL PROTECTED] wrote: I have a situation where I need postgres to LISTEN and allow BINDs to its TCP/IP port (5432) only to connections that originate from localhost. I need it to not accept *socket* connections if requests with new postgresql's (i dont know which

[GENERAL] Using same database from XP and Linux in notebook

2006-03-04 Thread Andrus Moor
I have notebook which can be booted into Windows XP/NTFS and into Linux. Notebook is not connected to any network. There are separate IDE partitions for both OS. I want same Postgres 8.1 database to be available in both modes. I think I must put Postgres database cluster into a NTFS partition

Re: [GENERAL] Using same database from XP and Linux in notebook

2006-03-04 Thread William Penberthy
Here is an example I always used as a start point in this type of project. http://campbellcentral.org/rick/code/setup.html Generally, I would store the datafiles on an NTFS partition - it seems easier to reach NTFS from Linux then vice-versa. I have seen this done successfully with virtually

[GENERAL] xml and utf-8

2006-03-04 Thread Perez
Any pointers/tricks/gotchas on storing XML into postgresql? Is it any more complicated than storing the XML into a bytea field? Do I have to worry about character encoding? All my XML is in utf-8. tia, arturo ---(end of broadcast)--- TIP 9: In

Re: [GENERAL] Default Access Exclusive Lock on Update?

2006-03-04 Thread seth . m . green
For anyone that is interested, my problem was solved on another list. Turns out the TRUNCATE command that I run at the beginning of the SP creates and holds an access exclusive lock on the table for the entire duration of the SP. I changed it to DELETE FROM and my problem was fixed. Full

[GENERAL] Quick psqlODBC driver setting

2006-03-04 Thread Bart Golda
I would like to have an installation program, which creates psqlODBC connection, so there will be no need of typing and clicking on two hundred workstations... There is the driver's msi file which can be installed very nicely, but what is the best way of creating the connection itself without much

Re: [GENERAL] ERROR: column datpath does not exist

2006-03-04 Thread [webattach] IT-Dienstleistungen
Thanks Scott, now I got it! ;) I found older copies of pg_dump in /usr/bin while the newer were in /usr/local/pgsql/bin/. Beginner's mistake... 8-) Sascha ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire

[GENERAL] PgsqlODBC connection parameters in the registry

2006-03-04 Thread Bart Golda
Is there any way to crypt ODBC settings (user, password)? It seems to be stored in HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI in plain text. I can use bogus data there and cover it with proper login and password on application side, but... er... MSSQL does not store password in this way... It is

[GENERAL] tsearch2 match substrings in words

2006-03-04 Thread Muller Zsolt
Hi, Is it possible using tsearch2 to match a substring of an element of a ts_vec column? For example: I have a table with a ts_vec, and I have a field with text, and if there is a value in the field I would like to match the beginning of the words - and the ts_vec has 'like':3 'match':5

Re: [GENERAL] problem with windows xp sp2 and postgres-8.1.3

2006-03-04 Thread Istvan Nagy
Hi, the lsp-fix did the trick. As you supposed it was a personal firewall (however a great product, called armor2net personal), which unfortunately was broken with the winsock lib. Strange problem with it however, that it hasn't got any problems with the earlier version of Postgres (last i had

[GENERAL] Questions about privileges

2006-03-04 Thread sylsau14
Hello, For an exercise at university, I have several SQL queries to find to manage privileges on a database. I didn't found all the queries. So, this is my problem : I have got one table named books with several columns. * The first question is : - All users can find titles, codes and prices

[GENERAL] What query on system tables retrieves table or queries definitoin

2006-03-04 Thread lists
What is the query for retrieving a tables and a views definition from the system tables (in 7.4). I am trying to find my way in the system tables and I am finding very confusing, especially way in the way the tables are linked. ---(end of

[GENERAL] A pg_hba.conf problem - again...

2006-03-04 Thread Bart Golda
So there is Fedora Core 3 with PostgreSQL 8.1.3 installed from rpms. The server listens on all interfaces. For testing, I used this pg_hba.conf (default with added line) and it worked: local all all trust host all all 127.0.0.1/32 trust host all all ::1/128 trust host all all 10.144.3.0/24 trust

[GENERAL]

2006-03-04 Thread Javier Velez Perez
Hola , soy estudiante universitario y estoy interesado en trabajar con PostgresSQL y me gustaría que me ayudaran mandándome información sobre él

Re: [GENERAL] What query on system tables retrieves table or queries definitoin

2006-03-04 Thread Martijn van Oosterhout
On Sat, Mar 04, 2006 at 03:13:18AM +, [EMAIL PROTECTED] wrote: What is the query for retrieving a tables and a views definition from the system tables (in 7.4). I am trying to find my way in the system tables and I am finding very confusing, especially way in the way the tables

Re: [GENERAL] Questions about privileges

2006-03-04 Thread Martijn van Oosterhout
On Sat, Mar 04, 2006 at 05:08:27AM -0800, [EMAIL PROTECTED] wrote: I have got one table named books with several columns. * The first question is : - All users can find titles, codes and prices of books (which are columns of the table books) So, I would like if a solution existed for that

Re: [GENERAL] Insert fails when it shouldn't

2006-03-04 Thread Jim Nasby
Adding -general back to the distribution list. Please do a reply-all. Even if you tell psql what encoding to use, if the database is created with the wrong encoding it might not be able to differentiate between the two strings. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

[GENERAL] PostgreSQL on Intel Core Duo Macs?

2006-03-04 Thread Andrew L. Gould
I know PostgreSQL works on the PPC chip Macs; but has anyone successfully installed PostgreSQL on one of the new Intel Core Duo Macs? Thanks, Andrew Gould ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire

Re: [GENERAL] PostgreSQL on Intel Core Duo Macs?

2006-03-04 Thread Steve Atkins
On Mar 4, 2006, at 6:24 PM, Andrew L. Gould wrote: I know PostgreSQL works on the PPC chip Macs; but has anyone successfully installed PostgreSQL on one of the new Intel Core Duo Macs? It's run fine on the intel developer macs for quite a while. I've not actually built it on the shiny

Re: [GENERAL] PostgreSQL on Intel Core Duo Macs?

2006-03-04 Thread Andrew L. Gould
On Sat, 4 Mar 2006 19:34:49 -0800 Steve Atkins [EMAIL PROTECTED] wrote: On Mar 4, 2006, at 6:24 PM, Andrew L. Gould wrote: I know PostgreSQL works on the PPC chip Macs; but has anyone successfully installed PostgreSQL on one of the new Intel Core Duo Macs? It's run fine on the

Re: [GENERAL] xml and utf-8

2006-03-04 Thread Gavin M. Roy
If your DB encoding is UTF-8, I don't see why you can't use a TEXT data type. Regards, Gavin On Mar 2, 2006, at 7:07 PM, Perez wrote: Any pointers/tricks/gotchas on storing XML into postgresql? Is it any more complicated than storing the XML into a bytea field? Do I have to worry

Re: [GENERAL] User tables

2006-03-04 Thread chris smith
Suppose there 3 users red, green, blue. How can the user green know what tables he has created?! From psql command line \dt lists every table in the DB!!! Thanks in advance. Hrishi If you mean that the owner of the table(s) is the user green, then try select * from pg_tables where

Re: [GENERAL] PostgreSQL on Intel Core Duo Macs?

2006-03-04 Thread Brendan Duddridge
Hi, We're running PostgreSQL 8.1.3 on an Intel iMac at work and I also have it running just fine on my new MacBook Pro. No problems. Compiled as is out of the box using the instructions at http:// keyvaluecoding.com Thanks,