patrick wrote:
hi,
i have an issue with tseach2, i just installed postgresql 8.3.1 on
windows using UTF8 server encoding / client encoding and LOCALE Canada /
French.
UPDATE product SET search_vector = setweight(to_tsvector(name), 'A') ||
to_tsvector(description);
ERROR: invalid byte
Hello,
On 3/18/08, Erik Jones [EMAIL PROTECTED] wrote:
Observe:
CREATE SEQUENCE part_seq;
CREATE TABLE parent (
id integer PRIMARY KEY DEFAULT nextval('part_seq'),
foo text
);
CREATE TABLE child1 (
bar text,
CHECK(foo='some_type1'),
PRIMARY
Is anyone else having problems accessing the mailing lists through NNTP?
-arturo
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 3/19/08, Leon Mergen [EMAIL PROTECTED] wrote:
Excuse me for bumping this up again, but I still don't understand how
to use this approach to sequentially walk through all different child
tables in one select, without having to JOIN these tables all the time
Apparently a UNION all solved
Hi,
Is there any chance I can use the contrib/xml2 package with a 7.4
database, or does it need features only available with version 8 and
later? I'd prefer not upgrading the database for the moment, and would
like to use XSLT functions in Postgresql.
Thanks
Philippe
--
Sent via pgsql-general
On Mar 19, 2008, at 9:01 AM, Leon Mergen wrote:
On 3/19/08, Leon Mergen [EMAIL PROTECTED] wrote:
Excuse me for bumping this up again, but I still don't understand how
to use this approach to sequentially walk through all different child
tables in one select, without having to JOIN these
what kind of errors are you experiencing?
Saludos!
Martin-
- Original Message -
From: Arturo Pérez [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Sent: Wednesday, March 19, 2008 6:52 AM
Subject: [GENERAL] nntp not workiNG
Is anyone else having problems accessing the mailing lists
Can you identify which row(s) are causing this problem? If we have the
value that's causing this, someone can reproduce it.
i have only 1 row:
46; the product name; the description;
i don't see any specials chars or accents.
knowing that some of my clients are french, should i use LATIN9 as
On 3/19/08, Erik Jones [EMAIL PROTECTED] wrote:
Excuse me for bumping this up again, but I still don't understand how
to use this approach to sequentially walk through all different child
tables in one select, without having to JOIN these tables all the
time
Apparently a UNION
Hi!
Postgresql: version 8.1.11
Is there a way to concatenate two arrays without duplicity?
This select return duplicity:
SELECT array_cat(ARRAY[1,2], ARRAY[2,3]);
array_cat
---
{1,2,2,3}
I need to get result without duplicity!
{1,2,3}
Thx
Fafi
--
Sent via pgsql-general mailing list
On Wed, 19 Mar 2008, Ondřej Fafejta [EMAIL PROTECTED] writes:
SELECT array_cat(ARRAY[1,2], ARRAY[2,3]);
array_cat
---
{1,2,2,3}
I need to get result without duplicity!
{1,2,3}
I don't know any builtin way of achieving such a thing. But you may want
to use intarray contrib module or
Hi,
I have a table
CREATE TABLE MsgCommon
(
UTC timestamp without time zone NOT NULL,
UID bigint NOT NULL,
DataSourceID integer NOT NULL,
DataSourceType integer NOT NULL,
BSCArchive boolean NOT NULL,
Oddities integer NOT NULL,
Encapsulated boolean NOT NULL,
2008/3/19 Zubkovsky, Sergey [EMAIL PROTECTED]:
Simple calculations show that each row occupies 76 bytes approximately.
But anticipated row size would be 41 or near.
You haven't mentioned PG version. For 8.2 onwards, the tuple header is
23 bytes. Add another 4 bytes for one line pointer for
On Wed, Mar 19, 2008 at 03:05:06PM +0100, Ondřej Fafejta wrote:
Hi!
Postgresql: version 8.1.11
Is there a way to concatenate two arrays without duplicity?
This select return duplicity:
SELECT array_cat(ARRAY[1,2], ARRAY[2,3]);
array_cat
---
{1,2,2,3}
I need to get result
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello,
We are quickly approaching the start of the PostgreSQL Community
Conference, East at the University of Maryland. The conference runs on
March 29th and 30th of this year, with over 20 talks and tutorials from
long time contributors and new
Guys,
I've got SPI code that performs inserts into some tables. Code works
fine when destination columns are type text, but fails when there
is something different like inet or macaddr. For type inet, following
error message is produced : could not format inet value: Address family
not
I'm running into a problem with maintaining referential integrity with
inheritance-based partitioning. Imagine a situation where partitions
are based on time. Two tables A and B are partitioned, and B
references A. If records in B are added some time after records in A,
the insertion
patrick wrote:
SELECT 'abc'::text || 'def'::text;
it's working fine (no need to convert the query ASCII to UTF8 or such
OK, now try each of these in turn:
UPDATE product SET search_vector = to_tsvector(name);
UPDATE product SET search_vector = setweight(to_tsvector(name), 'A');
UPDATE
patrick wrote:
Can you identify which row(s) are causing this problem? If we have the
value that's causing this, someone can reproduce it.
i have only 1 row:
46; the product name; the description;
i don't see any specials chars or accents.
I think I've reproduced it here, and it's not your
That solved my problem. Thanks!
On Wed, 2008-03-19 at 21:13 +0200, Volkan YAZICI wrote:
On Wed, 19 Mar 2008, Alex Vinogradovs [EMAIL PROTECTED] writes:
params[0] = DirectFunctionCall1(textin,
CStringGetDatum(pstrdup(192.168.1.1)));
Should't you be using inet_in instead of textin?
On Wed, 19 Mar 2008, Alex Vinogradovs [EMAIL PROTECTED] writes:
params[0] = DirectFunctionCall1(textin,
CStringGetDatum(pstrdup(192.168.1.1)));
Should't you be using inet_in instead of textin?
Regards.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
Richard Huxton [EMAIL PROTECTED] writes:
The issue is what characters were in your script file.
I'm wondering about non-UTF8 characters in the dictionary file(s) used
by the text search configuration. Failure to load a configuration
file would explain why it only shows up in tsearch-related
On Mar 19, 2008, at 12:54 PM, dan chak wrote:
I'm running into a problem with maintaining referential integrity
with inheritance-based partitioning. Imagine a situation where
partitions are based on time. Two tables A and B are partitioned,
and B references A. If records in B are added
Leon Mergen wrote:
On 3/19/08, Erik Jones [EMAIL PROTECTED] wrote:
Excuse me for bumping this up again, but I still don't understand how
to use this approach to sequentially walk through all different child
tables in one select, without having to JOIN these tables all the
time
Missed the mailing list on the last reply
Richard Huxton wrote:
patrick wrote:
hi richard,
thanks for your help! i found something... but first let me answer
your question:
UPDATE product SET search_vector = to_tsvector(name);
UPDATE product SET search_vector =
Richard Huxton [EMAIL PROTECTED] writes:
Missed the mailing list on the last reply
patrick wrote:
thoses queries are not working, same message:
ERROR: invalid byte sequence for encoding UTF8: 0xc3
what i found is in postgresql.conf if i change:
default_text_search_config from
I cannot d/l news.us.postgresql.org from here
perhaps you can ping the admin for the server
?
M-
- Original Message -
Wrom: KEDOTWFAOBUZXUWLSZLKBRNVWWCUFPEGAUTF
To: Martin Gainty [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Sent: Wednesday, March 19, 2008 8:03 PM
Subject: Re:
Tom Lane wrote:
Tyler, Mark [EMAIL PROTECTED] writes:
What I want to do is to guarantee that the row is available for
selection prior to sending the message.
You cannot do that with an AFTER trigger, because whatever it does
necessarily happens before your transaction commits. I
Should I use JDBC version 8.1 Build 412 with this database or is it recommended
to use JDBC version 8.3 Build 603
or another version?
Regards,
BTJ
--
---
Bjørn T Johansen
[EMAIL PROTECTED]
Hi All,
Does anyone know where I can download rmpbuild for RHEL 3?
I tried to install postgresql-8.2.6-1PGDG.f8.src.rpm. I got error rpmbuild:
command not found.
rpmbuild --rebuild --define 'buildrhel3 1' postgresql-8.2.6-1PGDG.f8.src.rpm
-bash: rpmbuild: command not found
Thank
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 19 Mar 2008 14:22:53 -1000
Tri Quach [EMAIL PROTECTED] wrote:
Hi All,
Does anyone know where I can download rmpbuild for RHEL 3?
I tried to install postgresql-8.2.6-1PGDG.f8.src.rpm. I got error
rpmbuild: command not found.
SELECT 'abc'::text || 'def'::text;
it's working fine (no need to convert the query ASCII to UTF8 or such
i am using pgadmin (1.8.2) to pass the query:
show client_encoding = UNICODE.
in postgresql.conf i have:
client_encoding; Value = UTF8, Current value = UNICODE;
i tried to restart postgresql
Hi All,
I am not sure which RHEL is on my server.
[EMAIL PROTECTED] pq8.2.6]# uname -a
Linux lyris3.k12.hi.us 2.4.21-20.EL #1 SMP Wed Aug 18 20:34:58 EDT 2004
x86_64 x86_64 x86_64 GNU/Linux
Thank you for your help.
Tri.
--
Sent via pgsql-general mailing list
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 19 Mar 2008 16:40:30 -1000
Tri Quach [EMAIL PROTECTED] wrote:
Hi All,
I am not sure which RHEL is on my server.
[EMAIL PROTECTED] pq8.2.6]# uname -a
Linux lyris3.k12.hi.us 2.4.21-20.EL #1 SMP Wed Aug 18 20:34:58 EDT
2004 x86_64
Hi,
On Wed, 2008-03-19 at 16:40 -1000, Tri Quach wrote:
I am not sure which RHEL is on my server.
cat /etc/redhat-release
Regards,
--
Devrim GÜNDÜZ , RHCE
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP,
Tri Quach escribió:
Hi All,
I am not sure which RHEL is on my server.
[EMAIL PROTECTED] pq8.2.6]# uname -a
Linux lyris3.k12.hi.us 2.4.21-20.EL #1 SMP Wed Aug 18 20:34:58 EDT 2004
x86_64 x86_64 x86_64 GNU/Linux
Thank you for your help.
Tri.
cat /etc/redhat-release
smime.p7s
Hi,
On Wed, 2008-03-19 at 14:22 -1000, Tri Quach wrote:
Does anyone know where I can download rmpbuild for RHEL 3?
RHEL 3 - PostgreSQL 8.2.6 packages:
http://www.postgresql.org/ftp/binary/v8.2.6/linux/rpms/redhat/rhel3.0/
We don't have 8.2.7, yet.
Regards,
--
Devrim GÜNDÜZ , RHCE
Tri Quach wrote:
Hi All,
I am not sure which RHEL is on my server.
cat /etc/redhat-release
--
Postgresql php tutorials
http://www.designmagick.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Thanks all. I think it must be RHEL 3.
[EMAIL PROTECTED] pq8.2.6]# cat /etc/redhat-release
Red Hat Enterprise Linux AS release 3 (Taroon Update 3)
[EMAIL PROTECTED] pq8.2.6]#
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Devrim GÜNDÜZ
Sent: Wednesday,
Hi,
On Thu, Mar 20, 2008 at 9:22 AM, Tri Quach wrote:
[ ... ]
Does anyone know where I can download rmpbuild for RHEL 3?
I tried to install postgresql-8.2.6-1PGDG.f8.src.rpm. I got error rpmbuild:
command not found.
If you don't have your install CDs, try https://rhn.redhat.com/ .
Or, just
Hello,
I was wondering, I'm reading that there is no support for foreign keys
to inherited (child) tables -- are there any plans on supporting these
in the (near) future, and/or are there any practical workarounds for
this ?
Regards,
Leon Mergen
--
Sent via pgsql-general mailing list
Hi,
On Thu, Mar 20, 2008 at 6:17 AM, Bjørn T Johansen wrote:
Should I use JDBC version 8.1 Build 412 with this database or
is it recommended to use JDBC version 8.3 Build 603
or another version?
Why not just stick with the version compatible with your JDK/JVM
version? (Check
Leon Mergen wrote:
Hello,
I was wondering, I'm reading that there is no support for foreign keys
to inherited (child) tables -- are there any plans on supporting these
in the (near) future, and/or are there any practical workarounds for
this ?
This has worked well for me:
CREATE TABLE
Hi all,
I'm interested in finding what would be involved on enhancing Postgres to allow
queries run in one database in a cluster to access join with tables in other
databases in the cluster, ie: cross database join support.
This would be very useful, depending on cost, I may be able to
On Mar 19, 2008, at 10:42 PM, brian wrote:
Leon Mergen wrote:
Hello,
I was wondering, I'm reading that there is no support for foreign
keys
to inherited (child) tables -- are there any plans on supporting
these
in the (near) future, and/or are there any practical workarounds for
this ?
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thu, 20 Mar 2008 16:51:57 +1300
Brent Wood [EMAIL PROTECTED] wrote:
Hi all,
I'm interested in finding what would be involved on enhancing
Postgres to allow queries run in one database in a cluster to access
join with tables in other
Brent Wood wrote:
Hi all,
I'm interested in finding what would be involved on enhancing
Postgres to allow queries run in one database in a cluster to access
join with tables in other databases in the cluster, ie: cross
database join support.
This would be very useful, depending on cost, I
47 matches
Mail list logo