Scott Marlowe, 04.12.2008 16:34:
Like an Oracle DBA who told me
pgsql was broken because the output of group by wasn't properly
ordered like it was on Oracle 9.
Then he did not know Oracle very well :)
Even Oracle 9 does not guarantee that the output of an GROUP BY is actually sorted,
On Fri, Dec 5, 2008 at 8:24 AM, Thomas Kellerer [EMAIL PROTECTED] wrote:
Scott Marlowe, 04.12.2008 16:34:
Like an Oracle DBA who told me
pgsql was broken because the output of group by wasn't properly
ordered like it was on Oracle 9.
Then he did not know Oracle very well :)
Even Oracle 9
Hi,
I have problems with inserting rows into an updatable view through it's
insert rule.
Running this:
insert into view_products_1
(id,firmid,name_en,name_hu,artnum1,artnum2,description_hu,description_en,pkgunitid,minpkg,customstariff,vat)
values
maybe that constraint ?? CONSTRAINT fk_products_qtyunitid FOREIGN KEY
(qtyunitid) REFERENCES whm.qtyunits (id) MATCH FULL ON UPDATE
CASCADE ON DELETE CASCADE,
Also, that table seem to be far away from perfect, too many fields,
you should chop it into few smaller tables.
2008/12/5 Csaba Együd
Csaba Együd wrote:
Hi,
I have problems with inserting rows into an updatable view through it's
insert rule.
[snip]
But in the table definition I defined DEFULT=(-1) for this field. What's
going wrong? Shouldn't it inherit these settings from the table?
Maybe, but it doesn't (and I think I've
Thanks for all of you help. It's working now :-)
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
2008/12/4, Rob Richardson [EMAIL PROTECTED]:
...
The problem, of course, is that the inventory table has a unique key
constraint that gets violated. So, to do this, I'm going to have to
write an insert query that lists every field in this table (all 62 of
them), except for the primary key,
Hi all
Could anyone tell me what's the best thing to with idle transactions
that are holding locks?
I just killed the process as I wanted to get on with some work. I'm
just not sure this is a good idea when we go into production.
Cheers
Will T
--
Sent via pgsql-general mailing list
Richard Huxton [EMAIL PROTECTED] a következőket írta üzenetében
news:[EMAIL PROTECTED]
Csaba Együd wrote:
Hi,
I have problems with inserting rows into an updatable view through it's
insert rule.
[snip]
But in the table definition I defined DEFULT=(-1) for this field. What's
going wrong?
Grzegorz Jaśkiewicz [EMAIL PROTECTED] a következőket írta üzenetében
news:[EMAIL PROTECTED]
maybe that constraint ?? CONSTRAINT fk_products_qtyunitid FOREIGN KEY
(qtyunitid) REFERENCES whm.qtyunits (id) MATCH FULL ON UPDATE
CASCADE ON DELETE CASCADE,
Also, that table seem to be far away from
Hi people,
Does anyone know how I can change what I'm doing to get pgsql to pick a better
plan?
I'll explain what I've done below but please forgive me if I interpret the
plans wrong as I try to describe, I've split it into 4 points to try and ease
the mess of pasting in the plans..
1) I've
select pg_cancel_backend(pid);
--- On Fri, 5/12/08, William Temperley [EMAIL PROTECTED] wrote:
From: William Temperley [EMAIL PROTECTED]
Subject: [GENERAL] IDLE in transaction - safest way to kill
To: pgsql-general@postgresql.org
Date: Friday, 5 December, 2008, 2:08 PM
Hi all
Could
Csaba Együd wrote:
Thx for your reply. Is there any possible way to generate an sql to
copy these defaults to the view.
Nothing pre-packaged that I know of. You could probably do something
copying values about in pg_attribute and pg_constraint, but that'd be an
at your own risk sort of activity
2008/12/5 Csaba Együd [EMAIL PROTECTED]:
Hi, thx for your reply too. Not that I guess because there is a default row
in qtyunits with id=-1.
Too many fields: How would you chop this table?
I would generally try to normalize it. Queries are going to be bit
more complicated than, but it
Richard Huxton [EMAIL PROTECTED] a következőket írta üzenetében
news:[EMAIL PROTECTED]
Csaba Együd wrote:
Thx for your reply. Is there any possible way to generate an sql to
copy these defaults to the view.
Nothing pre-packaged that I know of. You could probably do something
copying values
2008/12/5 Richard Huxton [EMAIL PROTECTED]:
I can't recall if you do ALTER VIEW view_products_1 or ALTER
TABLE view_products_1, but it's one of them.
It seems odd, but adding defaults to a VIEW is done with ALTER TABLE.
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL
Hi,
I have a question concerning psql. I found that psql has a defined
command '-t' and that it turns off printing of column names and result
row count footers, etc.
what I look for, is a command, which would turn off result row count
footer, but would print column names.
is there an easy
Could anyone tell me what's the best thing to with idle
transactions
that are holding locks?
On Fri, Dec 5, 2008 at 2:25 PM, Glyn Astill [EMAIL PROTECTED] wrote:
select pg_cancel_backend(pid);
Thanks. Sorry for the basic question.
Will
--
Sent via pgsql-general mailing list
Hello all,
I know that I am WAY behind the times here, but I am just now getting to
upgrade to 8.3. As I was reading through all of the installations I
realized that in order to install postgis now, you have to use the
Application Stack Builder and that this application has to access the
On Fri, Dec 5, 2008 at 3:42 PM, Lee Keel [EMAIL PROTECTED] wrote:
So, how do I load postgis into Postgres without using Application
Stack Builder; or how do I load it without internet connection? This is a
huge issue for me and I would appreciate any help that anyone can provide.
You can grab
-Original Message-
You can grab the installer manually from
http://pgfoundry.org/frs/?group_id=1000256release_id=1266 and copy
that around in whatever way you need.
Thanks Dave! I will do that. I just wasn't sure if installing outside
of Application Stack Builder was going to cause
On Fri, Dec 5, 2008 at 3:56 PM, Lee Keel [EMAIL PROTECTED] wrote:
-Original Message-
You can grab the installer manually from
http://pgfoundry.org/frs/?group_id=1000256release_id=1266 and copy
that around in whatever way you need.
Thanks Dave! I will do that. I just wasn't sure if
Hi,
I had created some tables in the schema Foo and given
GRANT ALL ON SCHEMA FOO TO SCOT;
But when Scot tries to alter a table he gets the error
MUST BE OWNER OF THE TABLE
How can I give the ALTER permission or is there any other way to let other
users modify or add tables in this schema?
On Thu, 2008-12-04 at 10:47 -0500, Robert Treat wrote:
http://archives.postgresql.org/pgsql-hackers/2006-04/msg00288.php
I remember after reading this post wondering whether Tom uses
caffeinated soap
My RHCE course book is still at WC -- I read it on some days ;)
--
Devrim GÜNDÜZ, RHCE
On Fri, Dec 5, 2008 at 11:25 PM, Glyn Astill [EMAIL PROTECTED] wrote:
select pg_cancel_backend(pid);
No, pg_cancel_backend() cancels only *query*, and doesn't kill idle
in transaction. I think that killing the backend (idle in transaction) with
SIGTERM is better way.
Regards,
--
Fujii Masao
Dear all,
I create a stored function to select some row and return it as cursor.
the function receive some parameter that later I put it in where clause
But I found that select statement runs Case Sensitive
so if I have a record, for example
- id -nama_pelanggan
- 1 - Wira
I wil get the
On Fri, Dec 5, 2008 at 9:11 PM, hendra kusuma [EMAIL PROTECTED] wrote:
Dear all,
I create a stored function to select some row and return it as cursor.
the function receive some parameter that later I put it in where clause
But I found that select statement runs Case Sensitive
so if I have a
Sorry, forgot to add subject
On 12/5/08, hendra kusuma [EMAIL PROTECTED] wrote:
Dear all,
I create a stored function to select some row and return it as cursor.
the function receive some parameter that later I put it in where clause
But I found that select statement runs Case Sensitive
so
I have just installed postgresql 8.3 on my debian sid, and have set
the password of both system user postgres and database user to the
same password, but when i connect to it using pgadmin3(from the local
machine), i got the error:
--
An error has occurred:
Error connecting to the
29 matches
Mail list logo
