Quoting Bruce Momjian <[EMAIL PROTECTED]>:
> Thomas Hallgren wrote:
> > Marc,
> > > Since I (and I don't believe anyone else on core) uses Java ...
> > > shouldn't it be up to the developer of the PL/J* modules to do this? We
>
> > > can't weigh which one is better then the other, as we don't u
On Tue, 24 Aug 2004 01:34:46 +0200
(BIan Barwick <[EMAIL PROTECTED]> wrote
(B
(B> ...
(B> wild speculation in need of a Korean speaker, but:
(B>
(B> [EMAIL PROTECTED]:~/tmp> cat j.txt
(B> $Bec,e$;ec(B
(B> $ByyPl%$%9wd!"(B
(B> $Bx"(l%$(Bl$B%i(B
(B> $Bw{%1v.%/wd(B
(B>
On Aug 23, 2004, at 6:49 PM, Tim Allen wrote:
One possible clue: your original post in this thread was using
encoding euc-kr, not unicode (utf-8). If your mailer was set to use
that encoding, perhaps your other client software is/was also?
Bah! Stupid Mail.app was trying to be too smart!
Thanks,
Tom Lane wrote:
David Wheeler <[EMAIL PROTECTED]> writes:
bric=3D# reindex index udx_keyword__name;
REINDEX
bric=3D# select * from keyword where name =3D'=BA=CF=C7=D1=C0=C7';
id | name | screen_name | sort_name | active
--++-+---+
1218 | =B1=B9=B9=E6=BA
On Aug 23, 2004, at 5:22 PM, Tatsuo Ishii wrote:
Locales for multibyte encodings are often broken on many platforms. I
see identical things with Japanese on Red Hat. This is one of the
reason why I tell Japanese PostgreSQL users not to enable locale while
initdb...
Yep, and exporting my data, delet
On Mon, 23 Aug 2004, Joshua D. Drake wrote:
1. Core -- Main database backend -- central approval/rejection
a. plCore -- controls the release/distribution/testing etc.. of the pl
languages
b. contribCore -- products that make it into contrib
ya, its called moving those things not required in co
> >
> > Ð ÐÐÐ, 23.08.2004, Ð 23:04, David Wheeler ÐÐÑÐÑ:
> > > On Aug 23, 2004, at 1:58 PM, Ian Barwick wrote:
> > >
> > > > er, the characters in "name" don't seem to match the characters in the
> > > > query - 'êëë' vs. 'ëíì' - does that have any bearing?
> > >
> > > Yes, it means that = is doin
On Aug 23, 2004, at 5:07 PM, Ian Barwick wrote:
Does this go away if you change your locale to C?
Yes.
Hallelujah! I'm running initdb again now.
Cheers,
David
smime.p7s
Description: S/MIME cryptographic signature
I am using PG version 7.4.3.2.
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "borajetta" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, August 21, 2004 8:55 AM
Subject: Re: [GENERAL] ERROR: duplicate key violates unique constraint
"pg_class_oid_index"
> "
On Mon, 23 Aug 2004 16:50:04 -0700, David Wheeler <[EMAIL PROTECTED]> wrote:
> On Aug 23, 2004, at 4:34 PM, Ian Barwick wrote:
>
> > wild speculation in need of a Korean speaker, but:
> >
> > [EMAIL PROTECTED]:~/tmp> cat j.txt
> > ããã
> > íêì
> > ìêì
> > ìëì
> > êëë
> > ëíì
> > ããã
> > [EMAIL PROT
On Aug 23, 2004, at 4:49 PM, David Wheeler wrote:
Hmm. I tried putting your string into a UNICODE database and I got
ERROR: invalid byte sequence for encoding "UNICODE": 0xc7
Really? Curious.
Oh, are you sure that you got my UTF-8 data? Because it came back in
your reply all mangled.
Cheers,
Da
On Aug 23, 2004, at 4:34 PM, Ian Barwick wrote:
wild speculation in need of a Korean speaker, but:
[EMAIL PROTECTED]:~/tmp> cat j.txt
テスト
환경설
전검색
웹문서
국방비
북한의
てすと
[EMAIL PROTECTED]:~/tmp> uniq j.txt
テスト
환경설
てすと
All but the first and last lines are random Korean (Hangul)
characters. Evidently our re
On Aug 23, 2004, at 4:35 PM, Tom Lane wrote:
Hmm. I tried putting your string into a UNICODE database and I got
ERROR: invalid byte sequence for encoding "UNICODE": 0xc7
Really? Curious.
So there's something funny happening here. What is your
client_encoding
setting?
It's not set. I've had it c
David Wheeler <[EMAIL PROTECTED]> writes:
>> Is the problem query using an index? If so, does REINDEX help?
> Doesn't look like it:
> bric=3D# reindex index udx_keyword__name;
> REINDEX
> bric=3D# select * from keyword where name =3D'=BA=CF=C7=D1=C0=C7';
>id | name | screen_name | sort_na
On Tue, 24 Aug 2004 00:46:50 +0200, Markus Bertheau
<[EMAIL PROTECTED]> wrote:
>
>
> Ð ÐÐÐ, 23.08.2004, Ð 23:04, David Wheeler ÐÐÑÐÑ:
> > On Aug 23, 2004, at 1:58 PM, Ian Barwick wrote:
> >
> > > er, the characters in "name" don't seem to match the characters in the
> > > query - 'êëë' vs. 'ëíì'
El 23/08/2004 5:13 PM, Josué Maldonado en su mensaje escribio:
> it did not ask for the password neither, however this works but no
data is restored just the schema
wrong paste trimmed here, this is the correct, sorry
C:\pgsql\bin>psql -d farmacia2 -U postgres -f xfar.sql
Password:
SET
SET
COMMEN
On Aug 23, 2004, at 4:08 PM, Tom Lane wrote:
[ looks back at discussion... ] Actually I misremembered --- the
discussion was about how we would *reject* legal UTF-8 codes that are
more than 2 bytes long. So the code is broken, but not in the
direction
that would cause your problem. Time for ano
Hello List,
I'm having this issue with beta 8.0
C:\pgsql\bin>pg_dump -U postgres farmacia > xfar.sql
Password:
C:\pgsql\bin>psql -U postgres farmacia2 < xfar.sql
Password:
psql: FATAL: Password authentication failed for user "postgres"
C:\pgsql\bin>psql -U postgres -W farmacia2 < xfar.sql
Password
Peter Eisentraut wrote:
Tim Penhey wrote:
Are there any python drivers that work with the version 8 beta?
The version seven ones didn't.
Why?
Changed from using pyPgSQL to psycopg and things are working again...
Tim
---(end of broadcast)---
David Wheeler <[EMAIL PROTECTED]> writes:
> Is the encoding check fixed in 8.0beta1?
[ looks back at discussion... ] Actually I misremembered --- the
discussion was about how we would *reject* legal UTF-8 codes that are
more than 2 bytes long. So the code is broken, but not in the direction
that
On Aug 23, 2004, at 3:59 PM, Tom Lane wrote:
But is it possible to store non-UTF-8 data in a UNICODE database?
In theory not ... but I think there was a discussion earlier that
concluded that our check for encoding validity is not airtight ...
Well, it it was mostly right, I wouldn't expect it to b
David Wheeler <[EMAIL PROTECTED]> writes:
> But is it possible to store non-UTF-8 data in a UNICODE database?
In theory not ... but I think there was a discussion earlier that
concluded that our check for encoding validity is not airtight ...
regards, tom lane
---
On Aug 23, 2004, at 3:46 PM, Markus Bertheau wrote:
The collation rules of your (and my) locale say that these strings are
the same:
[EMAIL PROTECTED] markus]$ cat > t
국방비
북한의
[EMAIL PROTECTED] markus]$ uniq t
국방비
[EMAIL PROTECTED] markus]$
Interesting.
Make sure that you have initdb'd the database
Hi,
For various reasons (parallel structure with existing code, commonality of concepts,
etc), we have C language functions implemented that use libpq to make a new connection
to the same Postgres server. Yes, I realize libpq is meant for clients and SPI for
backends. The question is, are the
As Tom (I believe) has stated, and both Bruce/I have said over and over
again ... this is nothing stop'ng a group of ppl starting up a "bundled
postgresql" project, and dedicating their time and effort into building
something up ...
As Peter has stated, he had thought of this in the past, and f
Bruce Momjian wrote:
Csaba Nagy wrote:
Hi all,
Bruce, if postgres is not a company and so on, why don't you open up the
core development team to include some of the contributors who would like
to include their product in the main distribution, and have a bundled
product ? Cause a good data base is
> > works =# select 1 = ANY ('{1,2,3}'::int[]);
> > doesn't work =# select 1 = ANY (select '{1,2,3}'::int[]);
> > works =# select 1 = ANY ((select '{1,2,3}'::int[])::int[]);
I may be misinterpreting your reply but.
My real-world application has a set-returning PL/pgSQL function for which I
c
On Mon, 23 Aug 2004, Frank van Vugt wrote:
> The following works :
>
> db=# select 1 = ANY ('{1,2,3}'::int[]);
> ?column?
> --
> t
> (1 row)
>
>
> This doesn't :
>
> db=# select 1 = ANY (select '{1,2,3}'::int[]);
> ERROR: operator does not exist: integer = integer[]
> HINT: No operato
Csaba Nagy wrote:
> Hi all,
>
> Bruce, if postgres is not a company and so on, why don't you open up the
> core development team to include some of the contributors who would like
> to include their product in the main distribution, and have a bundled
> product ? Cause a good data base is definite
Hi all,
Bruce, if postgres is not a company and so on, why don't you open up the
core development team to include some of the contributors who would like
to include their product in the main distribution, and have a bundled
product ? Cause a good data base is definitely not made up just by the
cor
On Mon, 23 Aug 2004, Thomas Hallgren wrote:
Again, I'm not trying to offload work from the contributors onto the members
of core. This is about how things are perceived by the PostgreSQL customers.
Of course the contributors must continue to support their products. If they
don't, I'd expect the
Ulrich Wisser wrote:
Hi,
I would like to stop the postmaster every night and run
vacuum
pg_dump
reindex
in the stand alone backend.
Vacuum and reindex seem to be quite easy, as I can setup a small script
with both commands. But what about pg_dump. That seems "somewhat" more
complex.
Explain what
Secrétariat wrote:
Hello !
I've installed the Beta 1 on Win XP Pro, it seem working correctly.
I load a database from Linux 7.4.3 with pgdumpall, it works too.
But I can't connect from other PC over the LAN (I modified pg_hba.conf
for the hosts).
If I write in postgresql.conf :
tcpip_socket = tr
Thomas Hallgren wrote:
> Marc,
> > Since I (and I don't believe anyone else on core) uses Java ...
> > shouldn't it be up to the developer of the PL/J* modules to do this? We
> > can't weigh which one is better then the other, as we don't use it ...
> >
> Of course the contributors should suppl
On 8/21/2004 10:34 PM, Jim Worke wrote:
Another thing that bothers us is that we can't find any multi-master
clustering solution in PostgreSQL. We're actually evaluating MySQL's own
clustering solution, but it's production quality release is still slated for
MySQL 5.0.
And with all the differen
Marc,
Since I (and I don't believe anyone else on core) uses Java ...
shouldn't it be up to the developer of the PL/J* modules to do this? We
can't weigh which one is better then the other, as we don't use it ...
Of course the contributors should supply as much of this material as
possible. Th
Hi,
The following works :
db=# select 1 = ANY ('{1,2,3}'::int[]);
?column?
--
t
(1 row)
This doesn't :
db=# select 1 = ANY (select '{1,2,3}'::int[]);
ERROR: operator does not exist: integer = integer[]
HINT: No operator matches the given name and argument type(s). You may need
to
After a long battle with technology, Matthias Blohm <[EMAIL PROTECTED]>, an earthling,
wrote:
> Hello,
> a question about a tool or a possibility how could something work.
>
> following situation:
> we have a database which is full of very sensitive information and needed that db to
> use our onl
On Mon, Aug 23, 2004 at 09:53:43AM +0100, Graeme Hinchliffe wrote:
> Hiya
> I am writing a daemon in C which monitors a table stored in postgres.
> I would ideally like the daemon to be able to withstand things such as
> the db connection going away or the db being shutdown, and simply keep
On Sun, Aug 22, 2004 at 12:35:20PM -0500, Mike Nolan wrote:
> > > As far as I can tell, Postgres has no equivalent to greatest and least
> > > functions in Oracle.
> > Doesn't max/min() do that ? Note that I know nothing about
> > greatest/least in Oracle.
>
> No, max/min are aggregate functions.
Hello !
I've installed the Beta 1 on Win XP Pro, it seem
working correctly.
I load a database from Linux 7.4.3 with pgdumpall,
it works too.
But I can't connect from other PC over the LAN (I
modified pg_hba.conf for the hosts).
If I write in postgresql.conf :
tcpip_socket =
true
port = 54
Raju,
The file with the source code is:
/pgsql_sources_directory(replace_this)/src/backend/utils/adt/ri_triggers.c
But you can trust that those triggers are not doing anything else then
checking/enforcing the foreign keys you have defined on that
table/referencing that table.
So you might want in
hi,
how can i show all the columns and its data types?
i create the following sql-statement but it only gets me a reference of
the data types, how can i replace the reference?
SELECT
pg_class.relname, pg_attribute.attname, pg_attribute.atttypid
FROM
pg_catalog.pg_attribute, pg_catalog.
Csaba,
Thank you for your reply. How do I check the sources. Can you please tell me
in detail.
regds
-raju
-Original Message-
From: Csaba Nagy [mailto:[EMAIL PROTECTED]
Sent: Monday, August 23, 2004 4:11 PM
To: SVGK, Raju (Raju)
Cc: '[EMAIL PROTECTED]'
Subject: Re: [GENERAL] view triggers
Daniel Martini wrote:
Hi,
Citing Ulrich Wisser <[EMAIL PROTECTED]>:
I would like to stop the postmaster every night and run
vacuum
pg_dump
reindex
in the stand alone backend.
Vacuum and reindex seem to be quite easy, as I can setup a small script
with both commands. But what about pg_dump. That se
Raju,
these triggers are the PG implementation of foreign key constraints
checking.
They are written in C, so if you're curios how they work you will have
to check the postgres sources ;-)
HTH,
Csaba.
On Mon, 2004-08-23 at 12:06, SVGK, Raju (Raju) wrote:
> Hi,
>
> I have a table where in lot
Hi,
I have a table where in lot of triggers were included in that as shown
below. How to view/access triggers and procedures from postgresql.
I am using postgresql 7.4.1 on solaris.
regds
-raju
Process=# \d reviews
Table "public.reviews"
Column
Hi,
Citing Ulrich Wisser <[EMAIL PROTECTED]>:
> I would like to stop the postmaster every night and run
>
> vacuum
> pg_dump
> reindex
>
> in the stand alone backend.
>
> Vacuum and reindex seem to be quite easy, as I can setup a small script
> with both commands. But what about pg_dump. That
Hiya
I am writing a daemon in C which monitors a table stored in postgres.
I would ideally like the daemon to be able to withstand things such as
the db connection going away or the db being shutdown, and simply keep
trying to connect rather than just fall on it's face.
Is there a
> Hello all,
>
> I am testing PostgreSQL 8.0 beta on a windows xp
> professional. In the time when I did the install I have been
> working with pgadmin and so on...
>
> But after a few days, when I tried to continue with my tests.
> I cannot start the postgresql service. I always get this
Hello all,
I am testing PostgreSQL 8.0 beta on a windows xp professional. In the
time when I did the install I have been working with pgadmin and so
on...
But after a few days, when I tried to continue with my tests. I
cannot start the postgresql service. I always get this message
windown when
Hi,
I would like to stop the postmaster every night and run
vacuum
pg_dump
reindex
in the stand alone backend.
Vacuum and reindex seem to be quite easy, as I can setup a small script
with both commands. But what about pg_dump. That seems "somewhat" more
complex.
TIA
Ulrich
--
52 matches
Mail list logo
