Re: [GENERAL] Log File Maintainance

2005-04-13 Thread Richard Huxton
Neil Dugan wrote: On Tue, 2005-04-12 at 08:51 +0100, Richard Huxton wrote: Inpreet Singh wrote: syslog = 2 # range 0-2 syslog_facility = 'LOCAL0' syslog_ident = 'postgres' You also need to update your syslog.conf and restart syslogd Add a line like: local0.*

Re: [GENERAL] psql vs perl prepared inserts

2005-04-13 Thread Dawid Kuroczko
On 4/12/05, Matt Van Mater [EMAIL PROTECTED] wrote: I've been experimenting with loading a large amount of data into a fairly simple database using both psql and perl prepared statements. Unfortunately I'm seeing no appreciable differences between the two methods, where I was under the

Re: [GENERAL] psql vs perl prepared inserts

2005-04-13 Thread Sean Davis
On Apr 13, 2005, at 4:12 AM, Dawid Kuroczko wrote: On 4/12/05, Matt Van Mater [EMAIL PROTECTED] wrote: I've been experimenting with loading a large amount of data into a fairly simple database using both psql and perl prepared statements. Unfortunately I'm seeing no appreciable differences between

Re: [GENERAL] What are the consequences of a bad database design (never seen that before !)

2005-04-13 Thread Robert Treat
On Wednesday 13 April 2005 01:21, Jinane Haddad wrote: Thanx guys for the advices. i think i will have to find some POLITICAL approach in order to restructure the existing database, which i am not so good at but worse trying. Note that even the code is Bad (they are using PHP for a big

Re: [GENERAL] psql vs perl prepared inserts

2005-04-13 Thread Neil Conway
Dawid Kuroczko wrote: For a test you might want to try also this approach (both from perl and from psql): $dbh-do('PREPARE sth_tim (int,inet,boolean,timestamptz) AS INSERT INTO timestamps VALUES ($1,$2,$3,$4)'); $sth_tim = $dbh-prepare(EXECUTE sth_tim(?,?,?,?)); ...and later execute it. (and

Re: [GENERAL] psql vs perl prepared inserts

2005-04-13 Thread Matt Van Mater
Thanks to all who replied. Thanks for the tip on that last thread Tom, I don't know how I missed it. I have a hunch that it's not applicable to me at this time because I'm running a year and a half old software (included in OpenBSD 3.4), but I will have to check which version of DBD::Pg was

Re: [GENERAL] psql vs perl prepared inserts

2005-04-13 Thread Bruno Wolff III
On Wed, Apr 13, 2005 at 09:57:09 -0400, Matt Van Mater [EMAIL PROTECTED] wrote: Also, I forgot to mention earlier that I tried using transactions to speed things up, but since I expect to see certain inserts fail I would need to rework my code so the whole transaction doesn't fail if one

Re: [GENERAL] Composite type versus Domain constraints.

2005-04-13 Thread James Robinson
On Apr 12, 2005, at 4:48 PM, Tom Lane wrote: James Robinson [EMAIL PROTECTED] writes: insert into simple_table values (null, '(43)'); -- GRR works!!! It'll let any smallint in. What happened to the constraint? The composite-type input routine doesn't check any constraints ... and that includes

Re: [GENERAL] psql vs perl prepared inserts

2005-04-13 Thread Daniel Verite
Neil Conway wrote: For an INSERT query without any sub-selects that is not rewritten by any rules, the cost to parse, rewrite and plan the statement is trivial. So I wouldn't expect prepared statements to be a big win -- you would gain a lot more from batching multiple inserts

[GENERAL] Foreign Keys Question

2005-04-13 Thread Matthias Loitsch
First of all, hi. I'm new to this mailing list. I searched this on the net, but I didn't get any usable answers... So here's my problem: I have 2 schemas. One is called SITE, one SITE_forum. What I wanted, is to separate the forum from the whole Site db, so I can put them on different

Re: [GENERAL] psql vs perl prepared inserts

2005-04-13 Thread Tom Lane
Neil Conway [EMAIL PROTECTED] writes: The intent of prepared statements is to reduce the overhead of running the parser, rewriter and planner multiple times for a statement that is executed multiple times. For an INSERT query without any sub-selects that is not rewritten by any rules, the

Re: [GENERAL] Foreign Keys Question

2005-04-13 Thread Bruno Wolff III
On Wed, Apr 13, 2005 at 13:54:05 +0200, Matthias Loitsch [EMAIL PROTECTED] wrote: So I thought I could make a foreign key on a different Schema (db), and use the same table And well, thats where I started to search if this is possible ... and, in fact my main question is: Is this a

Re: [GENERAL] PostGreSQL (7.3?) recovery, Mac OS X (10.3.8)

2005-04-13 Thread Eric D. Nielsen
Thank you. I'm used to installing from source or Debian packages. I haven't poked around too much at the console level of the Mac. I would assume I install from source and just point the install to the old data directory? Any gotchas to watch for that aren't in the manual? I would assume I

Re: [GENERAL] psql vs perl prepared inserts

2005-04-13 Thread Sean Davis
On Apr 13, 2005, at 9:57 AM, Matt Van Mater wrote: Thanks to all who replied. Thanks for the tip on that last thread Tom, I don't know how I missed it. I have a hunch that it's not applicable to me at this time because I'm running a year and a half old software (included in OpenBSD 3.4), but I

[GENERAL] About ERROR: could not convert UTF-8 character 0x00e9 to ISO8859-1

2005-04-13 Thread Ying Lu
Greetings, PostgreSQL 8.0.1 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.2. When I run select * from table1; I got an error: = ERROR: could not convert UTF-8 character 0x00e9 to ISO8859-1 I tried to google but cannot find much info about it. Can somebody help? Thanks, Emi

Re: [GENERAL] Composite type versus Domain constraints.

2005-04-13 Thread Tom Lane
James Robinson [EMAIL PROTECTED] writes: Thank you for the great info. If I may, here's another question. I am in the need of new scalar types, essentially domain'd smallints, hence why my composite type had but one composite member. Domain'd smallints would be great, but it seems when they

Re: [GENERAL] psql vs perl prepared inserts

2005-04-13 Thread Alvaro Herrera
On Wed, Apr 13, 2005 at 09:57:09AM -0400, Matt Van Mater wrote: Also, I forgot to mention earlier that I tried using transactions to speed things up, but since I expect to see certain inserts fail I would need to rework my code so the whole transaction doesn't fail if one insert goes bad.

Re: [GENERAL] Foreign Keys Question

2005-04-13 Thread Oleg Bartunov
Will inherits helps you ? create table SITE_forum.t1 () inherits (SITE.t); Oleg On Wed, 13 Apr 2005, Matthias Loitsch wrote: First of all, hi. I'm new to this mailing list. I searched this on the net, but I didn't get any usable answers... So here's my problem: I have 2 schemas. One is called

[GENERAL] Postgresql 8.0.2 and Tiger?

2005-04-13 Thread Jerry LeVan
Mac OSX 10.4 aka Tiger is going to be released in a couple of weeks, does anyone know if Tiger will still be Postgresql friendly? Jerry ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ?

Re: [GENERAL] Postgresql 8.0.2 and Tiger?

2005-04-13 Thread Joshua D. Drake
Jerry LeVan wrote: Mac OSX 10.4 aka Tiger is going to be released in a couple of weeks, does anyone know if Tiger will still be Postgresql friendly? There is no reason to think that it wouldn't be. Sincerely, Joshua D. Drake Jerry ---(end of

Re: [GENERAL] Postgresql 8.0.2 and Tiger?

2005-04-13 Thread Steve Atkins
On Wed, Apr 13, 2005 at 01:21:41PM -0400, Jerry LeVan wrote: Mac OSX 10.4 aka Tiger is going to be released in a couple of weeks, does anyone know if Tiger will still be Postgresql friendly? 8.0.2 doesn't build out of the box on build 8A351B. I've not had a chance to see what's going on yet,

Re: [GENERAL] Postgresql 8.0.2 and Tiger?

2005-04-13 Thread Vivek Khera
On Apr 13, 2005, at 1:52 PM, Steve Atkins wrote: 8.0.2 doesn't build out of the box on build 8A351B. I've not had a chance to see what's going on yet, but it doesn't look like anything too hard to fix. My guess would be any issues on building would be related to gcc4 in tiger, and any changes

Re: [GENERAL] About ERROR: could not convert UTF-8 character 0x00e9 to ISO8859-1

2005-04-13 Thread Secrtariat
Specify your codepage : SET CLIENT_ENCODING TO 'LATIN1' ; SELECT * FROM table1 ; Your database woul be coded as LATIN1. Luc - Original Message - From: Ying Lu [EMAIL PROTECTED] To: pgsql-general@postgresql.org Sent: Wednesday, April 13, 2005 5:49 PM Subject: [GENERAL] About ERROR: could

Re: [GENERAL] Composite type versus Domain constraints.

2005-04-13 Thread James Robinson
On Apr 13, 2005, at 11:50 AM, Tom Lane wrote: Thank you for the great info. If I may, here's another question. I am in the need of new scalar types, essentially domain'd smallints, hence why my composite type had but one composite member. Domain'd smallints would be great, but it seems when they

Re: [GENERAL] About ERROR: could not convert UTF-8 character 0x00e9

2005-04-13 Thread Ying Lu
Hello, Actually, both the server and client sides have been setup encoding latin1. I am trying to read data from one DB and save to another DB. When I tried to read data from one DB (using postgresql-8.0-310.jdbc3.jar), it seems that I lost all my French characters (they become ?). Also, I am

[GENERAL] [PHP] unsubscribe

2005-04-13 Thread Libia Andrea Ramos Snchez
unsubscribe LIBIA ANDREA RAMOS SÁNCHEZ INGENIERO DE SISTEMAS ESCUELA COLOMBIANA DE INGENIERIA CEL. 3103271242 OFC. 5452799 - 2550469 CMN-Consulting _ Charla con tus amigos en línea mediante MSN Messenger:

Re: [GENERAL] About ERROR: could not convert UTF-8 character 0x00e9

2005-04-13 Thread Ying Lu
Luc, You are right. I am afraid that I checked different mahine's client_encoding, which have been setup the correct encodings. While for my working environment, I have CLIENT_ENCODING = SQL_ASCII ; SERVER_ENCODING = SQL_ASCII; After we setup the correct encoding for client and server side, we

Re: [GENERAL] Postgresql 8.0.2 and Tiger?

2005-04-13 Thread Scott Ribe
Mac OSX 10.4 aka Tiger is going to be released in a couple of weeks, does anyone know if Tiger will still be Postgresql friendly? Well, considering that PostgreSQL is now used by Apple Remote Desktop, for storing client-management kinds of info, I expect there will be some way to get it

Re: [GENERAL] Postgresql 8.0.2 and Tiger?

2005-04-13 Thread Benjamin Reed
On 4/13/05, Vivek Khera [EMAIL PROTECTED] wrote: My guess would be any issues on building would be related to gcc4 in tiger, and any changes needed for that will be applicable to gcc4 on any other platform too. But that's just a SWAG. I confirmed that my postgresql 8.0.2 and 7.4.7 packages

Re: [GENERAL] grant all privileges to all tables in a database

2005-04-13 Thread Florin Andrei
On Mon, 2005-04-11 at 03:28 +0200, Daniel Verite wrote: Florin Andrei wrote: On MySQL, it's enough to do this: GRANT ALL PRIVILEGES ON dbname.* TO username [IDENTIFIED BY 'password']; On PostgreSQL, you have to give it privileges not only to the database, but to all