Re: [GENERAL] serial

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, with

Re: [GENERAL] serial

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 :) > Ev

[GENERAL] Updatable Views - DEFAULT doesn't inherit from table???

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 ('23','1','','','dd

Re: [GENERAL] Updatable Views - DEFAULT doesn't inherit from table???

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 <

Re: [GENERAL] Updatable Views - DEFAULT doesn't inherit from table???

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

Re: [GENERAL] Executing a user created function twice give an error

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

Resp.: [GENERAL] Automatic insert statement generator?

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

[GENERAL] in transaction - safest way to kill

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 (pgsql-gen

Re: [GENERAL] Updatable Views - DEFAULT doesn't inherit from table???

"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? Sh

Re: [GENERAL] Updatable Views - DEFAULT doesn't inherit from table???

""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

[GENERAL] Planner picking topsey turvey plan?

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

Re: [GENERAL] in transaction - safest way to kill

select pg_cancel_backend(); --- On Fri, 5/12/08, William Temperley <[EMAIL PROTECTED]> wrote: > From: William Temperley <[EMAIL PROTECTED]> > Subject: [GENERAL] in transaction - safest way to kill > To: pgsql-general@postgresql.org > Date: Friday, 5 December, 2008, 2:08 PM > Hi all > > Could

Re: [GENERAL] Updatable Views - DEFAULT doesn't inherit from table???

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 act

Re: [GENERAL] Updatable Views - DEFAULT doesn't inherit from table???

>> 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

Re: [GENERAL] Updatable Views - DEFAULT doesn't inherit from table???

"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 valu

Re: [GENERAL] Updatable Views - DEFAULT doesn't inherit from table???

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 U

[GENERAL] tuples

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 way

Re: [GENERAL] in transaction - safest way to kill

>> >> 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(); > Thanks. Sorry for the basic question. Will -- Sent via pgsql-general mailing list (p

[GENERAL] Application Stack Builder - proxy error

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 inter

Re: [GENERAL] Application Stack Builder - proxy error

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

Re: [GENERAL] Application Stack Builder - proxy error

-Original Message- >> You can grab the installer manually from >> http://pgfoundry.org/frs/?group_id=1000256&release_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

Re: [GENERAL] Application Stack Builder - proxy error

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=1000256&release_id=1266 and copy >>> that around in whatever way you need. > > > Thanks Dave! I will do that. I just

[GENERAL] ALTER TABLE .....Error: Must be owner of the table

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? Thank

Re: [GENERAL] Favorite Tom Lane quotes

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 dev

Re: [GENERAL] in transaction - safest way to kill

On Fri, Dec 5, 2008 at 11:25 PM, Glyn Astill <[EMAIL PROTECTED]> wrote: > > select pg_cancel_backend(); 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

[GENERAL]

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 r

Re: [GENERAL]

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

Re: [GENERAL] select return case sensitive record

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

[GENERAL] is there any error for my postgresql installation?

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 serve