Re: [GENERAL] Performance implications of creating many, many sequences

2010-10-23 Thread Michael Gardner
On Oct 22, 2010, at 11:03 PM, Craig Ringer wrote: > Instead, maintain a counter, either in the main customer record or in an > associated (customer_id, counter) side table if you want to reduce potential > lock contention. Write a simple SQL function that uses an UPDATE ... > RETURNING statemen

Re: [GENERAL] rule which unpredictable modify a sequence number

2010-10-23 Thread Tom Lane
Armand Turpel writes: > I have a problem with a rule which unpredictable modify a sequence > number. When I add a new table entry, the new id_keyword hasnt the value > as expected. ex.: 1000, 1001, > 1002,.. If i remove the rule it works. Rules don't pla

[GENERAL] rule which unpredictable modify a sequence number

2010-10-23 Thread Armand Turpel
I have a problem with a rule which unpredictable modify a sequence number. When I add a new table entry, the new id_keyword hasnt the value as expected. ex.: 1000, 1001, 1002,.. If i remove the rule it works. Here the table, rule and sequence definitions

Re: [GENERAL] What is "return code" for WAL send command

2010-10-23 Thread Tom Lane
zhong ming wu writes: > I have a master PG 8.1.11 sending WAL files to a cold-standby using rsync > For some reason it failed recently with "return codes 32512" and I couldn't > find this num. as a valid rsync exit code > During the time that the error was going on I tried the rsync command > ma

Re: [GENERAL] Advice needed on application/database authentication/authorization/auditing model

2010-10-23 Thread Craig Ringer
On 10/23/2010 12:02 AM, Dmitriy Igrishin wrote: Please see http://www.postgresql.org/docs/9.0/static/functions-info.html#FUNCTIONS-INFO-ACCESS-TABLE Yep. As for not explicitly mentioning "lower" roles when granting a higher role (ie "admin" isn't also a "user") - role inheritance. http://ww

[GENERAL] rule which unpredictable modify a sequence number

2010-10-23 Thread Armand Turpel
I have a problem with a rule which unpredictable modify a sequence number. When I add a new table entry, the new id_keyword hasnt the value as expected. ex.: 1000, 1001, 1002,.. If i remove the rule it works. Here the table, rule and sequence definitions:

[GENERAL] What is "return code" for WAL send command

2010-10-23 Thread zhong ming wu
Hello I have a master PG 8.1.11 sending WAL files to a cold-standby using rsync For some reason it failed recently with "return codes 32512" and I couldn't find this num. as a valid rsync exit code During the time that the error was going on I tried the rsync command manually and didn't error C

Re: [GENERAL] Tools for form generation in PHP/HTML from database models/queries

2010-10-23 Thread Neil D'Souza
Hi Andre, Check out my project at: git://github.com/neilxdsouza/codehelper.git I'm using a modified create table syntax to generate forms - but my target language is C++/PostgreSQL using the Wt (witty) web toolkit. However, that does not mean you are restricted to C++ or Postgres or

Re: [GENERAL] server error

2010-10-23 Thread Craig Ringer
On 10/23/2010 03:19 PM, quickinfo quickinfo wrote: Dear Friends, I have recently installed PostgreSQL 8.3.11 on Windows 7 32 bit Try installing the current version, 9.0. operating System. when I start the server it is showing me following error. Please see the screen shot. Please let me know

Re: [GENERAL] full vacuum cancelation

2010-10-23 Thread Viktor Bojović
On Thu, Oct 21, 2010 at 5:00 PM, Tom Lane wrote: > =?UTF-8?Q?Viktor_Bojovi=C4=87?= writes: > > my full vacuuming of one table runs still after four days. Is it safe to > > cancel it by pressing Ctrl+c? > > I assume this is a pre-9.0 Postgres version? > > Depending on how far along the vacuum act

[GENERAL] server error

2010-10-23 Thread quickinfo quickinfo
Dear Friends, I have recently installed PostgreSQL 8.3.11 on Windows 7 32 bit operating System. when I start the server it is showing me following error. Please see the screen shot. Please let me know what is the problem and how should I proceed. [image: Postgres.jpg] Thanks in Advance, Eagerly