Whenever I try to install version 8.3 on w2k, using an existing windows account
, the installer returns the error "Invalid username specified: A required
privilege is not held by the client".
I have since installed version 8.2 successfully, using the same account that
failed with the 8.3 inst
FOLLOW UP FOR THE ARCHIVES:
Thanks to some assistance from another forum, I was finally able to install
version 8.2, using the filemon.exe utitlity to track down file permission
problems. Here are the changes I made. Disclaimer, I tried a lot of different
things, so it may not be everything.
FOLLOW UP FOR THE ARCHIVES:
Thanks to some assistance from another forum, I was finally able to install
version 8.2, using the filemon.exe utitlity to track down file permission
problems. Version 8.3 never did install. Here are the changes I made.
Disclaimer, I tried a lot of different things,
FOLLOW UP FOR THE ARCHIVES:
Thanks to some assistance from another forum, I was finally able to install
version 8.2, using the filemon.exe utitlity to track down file permission
problems. Version 8.3 never did install. Here are the changes I made.
Disclaimer, I tried a lot of different things,
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 m
-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 othe
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 ?
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 arra
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 child_
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 http://jdbc.po
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 (pgsql-g
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, ju
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,
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:
http://www.postgresql.org/mailpr
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
PostgreSQ
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
Desc
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, O
-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
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 (pgsql-general@postgresql.org)
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
-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
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 you
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]
---
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 s
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:
Sent: Wednesday, March 19, 2008 8:03 PM
Subject: Re: [GENERAL] nntp not workiNG
>
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_confi
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 = setweight(to_tsvector(name),
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
>> ti
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
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 q
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 change
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 texti
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 yo
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 product
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 tim
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 supported
-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 comer
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 ge
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 pointe
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 N
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 m
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 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
> >
> > Appa
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 a
what kind of errors are you experiencing?
Saludos!
Martin-
- Original Message -
From: "Arturo Pérez" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, March 19, 2008 6:52 AM
Subject: [GENERAL] nntp not workiNG
> Is anyone else having problems accessing the mailing lists through NNTP?
>
> -arturo
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 tabl
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 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 solve
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
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'),
>
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 sequ
51 matches
Mail list logo
