Hi,
On Mar 09 02:00, Yury Don wrote:
> Looks like string comparison operators ignore spaces isnside of string.
> Because of this sorting on text fields is wrong.
>
> mdb=# select 'a z'::text>'ad'::text;
> ?column?
> --
> t
PostgreSQL relies on your locale for collation. Therefore, firs
"Chris Hodgson" <[EMAIL PROTECTED]> writes:
> If you cycle through enough id's in your toast tables, the chunk_id goes
> past 2^32 and wraps around, leaving you in an intermittent error state.
> Inserting further toasted chunks will fail depending on whether that
> particular next id from the sequ
Excuse me if I was no very clear and I don't put you in right direction,But yes the problem is not with FROM but with ORDER BY or GROUP BY.As you can see in my query I need to GROUP BY modelloid ad aggregateon npezzi. To solve the problem I rewrite the query in the second for and
encapsulated the
The following bug has been logged online:
Bug reference: 2311
Logged by: Chris Hodgson
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4.7
Operating system: Linux Fedora Core 3
Description:Toast table chunk_id overflow
Details:
If you cycle through enough id'
I wrote:
> The relevant owner field for a composite type is pg_type.typowner.
> We don't bother to maintain pg_class.relowner for the subsidiary
> pg_class entry.
Actually, now that I look at it, there is a non-cosmetic issue here:
we seem to be creating a dependency link for the pg_class owner fi
"eKo1" <[EMAIL PROTECTED]> writes:
> I have the following function that displays the relation-like objects owned
> by a user in a given schema:
The relevant owner field for a composite type is pg_type.typowner.
We don't bother to maintain pg_class.relowner for the subsidiary
pg_class entry.
"Yury Don" <[EMAIL PROTECTED]> writes:
> Looks like string comparison operators ignore spaces isnside of string.
It's not wrong, it's just following the rules of the locale. You should
initdb the database with LANG=C if you want plain ASCII sorting.
regards, tom lane
---
Hallo,
wi egeht dat;) Habe Postgres installiert udn habe mit dem user ppstgres
eine db "ubu" und einen user "ubu" angelegt. Jetzt will ich mit psql -h
localhost ubu ubu einloggen aber er will jetzt ein passwort. habe ich
aber nicht :( Was kann man machen?
Wenn Sie Ihr Abonnement fuer diese
postgreSQL管理各位
lo_openについて、以下の現象が発生してしまいます。
お調べくださいますようお願い申し上げます。
Ｃ言語でラージオブジェクトを書き込み、取り出すプログラムを作成
しているのですが、Ｃでコンパイル後に実行する場合は正常に動作する
のですが、作成したＣの関数をＳＰ化した場合にlo_openで 下記のメッセージが
出力され エラーになってしまいます。
ERROR: invalid flags: 0
lo_openでは openmodeのチェックは実
It's a problem because after restore, server is looking for sequence in
schema "public" but sequence was created in schema "schema".
When I'm inserting new row to the table I have an error because server
can't find the sequence.
I know I can set proper searchpath, but now I can't because I have
Upon issuing the insert statement I receive the following error message:
"could not send data to server: No buffer space available
(0x2747/10055)"
I suspect that this happens because we are inserting a lot of data: the
first BYTEA column is about 1.8MB, while the second is about 0.5MB.
Howeve
Hello,
I've been trying to install postgres 8.1.3 from de sources in 2 Suse x86
machines, one with the 8.2 SUSE s.o. and the other whith the 9.0 one.
Neither of the tryings where succesfull because the configure script
did
not work in any case.
¿Is there package or rpm for SUSE in dev
The following bug has been logged online:
Bug reference: 2310
Logged by: eKo1
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.3
Operating system: Linux Fedora Core 3
Description:"ALTER TYPE name OWNER TO new_owner" not working
Details:
I have the following
The following bug has been logged online:
Bug reference: 2309
Logged by: Yury Don
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.3
Operating system: Linux (Debian)
Description:Wrong string comparison
Details:
Looks like string comparison operators ignore s
Kamil Giza <[EMAIL PROTECTED]> writes:
> It's a problem because after restore, server is looking for sequence in
> schema "public" but sequence was created in schema "schema".
No, it doesn't. regclass constants don't work that way; the sequence is
identified by OID, and isn't subject to search p
15 matches
Mail list logo
