Vivek Khera <[EMAIL PROTECTED]> writes:
> 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.
Not a bad guess --- but I know that 8.0.* builds in Red Hat dev
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
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 packag
> 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 work
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
s
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:
http://messenger.latam.msn.co
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 a
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 g
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:
Sent: Wednesday, April 13, 2005 5:49 PM
Subject: [GENERAL] About ERROR: could not convert UTF-8 characte
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 ne
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
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 broadcast)--
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?
http://www.postgresql.org/docs/
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 SITE,
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.
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 th
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
---
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 wi
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 sh
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 t
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,
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 server
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
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 do
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
>
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 insta
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
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
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 betwee
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 im
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.* /var/log/pg
31 matches
Mail list logo