Hi everybody!
Recently, I've discovered an interesting feature (or a bug?) of PostgreSql
(checked 7.4.x and 8.0.x):
One may define such tables:
create table ref(
id serial primary key,
name text);
create table dat(
id serial,
ref_id int references ref(id),
comment text);
Let us fill the ref t
The following bug has been logged online:
Bug reference: 1682
Logged by: D.J. Kniep
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.3
Operating system: Linux
Description:subselect generates multiple rows
Details:
table1:
id content
1 John D
i am trying to find information on how to add users so they could login with
sshd, and also when adding the users it would be shown in /etc/passwd and i
will be able to do "passwd user", some told me to install postgres and i did
and i created db and everything but that didn't help, any place to re
--
$psql -V
psql (PostgreSQL) 7.4.7
contains support for command-line editing
--
I have table with two _id (document_id and document_store_id). And I
have a view:
SELECT document_items.document_store_id AS document_id,
document_items.vat_type_id, vat_type_value,
sum(d
The following bug has been logged online:
Bug reference: 1683
Logged by: Ilya Konyuhov
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.2
Operating system: Red Hat 7.0
Description:Error in PQresultErrorField function
Details:
I am use libpq client on Windows
evgeny gridasov <[EMAIL PROTECTED]> writes:
> ... and we recieve a deadlock!
> Easy to understand why: each insert statement generates query like:
> SELECT 1 FROM ONLY "public"."ref" x WHERE "id" = $1 FOR UPDATE OF x
> So, is this behaviour of postgresql is a bug or feature?
An extremely well-know
"D.J. Kniep" <[EMAIL PROTECTED]> writes:
> query:
> select * from table1 t1 where t1.id in (select t2.id from view2 t2 where
> extra1 = 'a1')
> produces:
> id content
> 1 John Doe
> 1 John Doe
> 2 Peter Gabriel
Not for me ---
regression=# create table table1(i
>
> I just installed 8.0.3 on Windows XP Pro and I got the
> following error everytime I boot:
>
> The ordinal 968 could not be located in the dynamic link
> library LIBEAY32.dll.
>
> What is going on? How do I fix this?
You need to upgrade to OpenSSL 0.9.7.
Is this an install from the offic
On Fri, May 27, 2005 at 08:55:50AM +0100, D.J. Kniep wrote:
>
> id content
> 1 John Doe
> 1 John Doe
> 2 Peter Gabriel
I couldn't reproduce these results with the test data and query you
provided, but my table and view definitions probably differed from
yours.
Tomasz Brzezina <[EMAIL PROTECTED]> writes:
> document_id vat_type_id vat_type_value document_netto_value
> 65615 1 0 0
> 65615 4 0.07-12.5327
> 65615 5 0.22-7.31148
> 65615
Tom, where are we on this patch? Seems we need to do something.
Here is the thread:
http://archives.postgresql.org/pgsql-bugs/2005-05/msg8.php
---
Tom Lane wrote:
> Boris van Schooten <[EMAIL PROTECTED]> write
[Please copy the mailing list on replies so others can participate
in and learn from the discussion.]
On Fri, May 27, 2005 at 10:08:20AM +0200, FREMAUX Benjamin SOFRECOM wrote:
>
> I have effectively an index (PK) on list.group_artifact_id. I solved the
> problem with an index rebuild.
A reinde
Tom Lane wrote:
> Bruce Momjian writes:
> > Tom, where are we on this patch? Seems we need to do something.
>
> It's in my to-do pile. I was debating whether it's OK to commit to
> 8.0 branch, or should I just put it in HEAD.
I am thinking just HEAD. If someone really needs it we can point th
Bruce Momjian writes:
> Tom, where are we on this patch? Seems we need to do something.
It's in my to-do pile. I was debating whether it's OK to commit to
8.0 branch, or should I just put it in HEAD.
regards, tom lane
---(end of broadcast)--
14 matches
Mail list logo
