[GENERAL] problem with check constraints

Hi, When I create a check constraint in PgAdmin3 1.8.4 on a Postgresql 8.3.3: ((A and B) or (C and D)) I get with create script: (A and B or C and D) which is wrong. Please help. Cheers, Anton -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subs

[GENERAL] very slow updates in 8.3?

Hi, I have noticed that the first time you execute an: update table1 set params_count=0; it takes too long to complete: 11000 rows - 100 s. Postgresql 8.3 configuration on Turion 64 with 1.4 Gb RAM, Windows XP Which compiler is used to build Postgresql on Windows? Is it 9? Any comment? Che

Re: [GENERAL] How to "use" database?

create a new database you can not access it by name cause you receive an error "cross database referencing is not allowed". Cheers, Anton Shane Ambler wrote: Anton Andreev wrote: Hi, How to use a database I have just created in a script that I am executing in Pgadmin3 on Windows

[GENERAL] How to "use" database?

Hi, How to use a database I have just created in a script that I am executing in Pgadmin3 on Windows? I can not use "USE Northwind;" or "\connect Northwind;"? Cheers, Anton -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www

[GENERAL] Question about the cluster command

a specific company ordered by date as fast as possible (to generate charts). Does autovacuum include reclustering? Cheers, Anton Andreev -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] returning a resultset from a function

Hi, How do I return a result set? Is there a better way in 'plpgsql' than the one described below? I do not want to make a select from a function(which pretty useful in many cases): SELECT * FROM getfoo(); , but I want to just call the function with SELECT getfoo(); --DROP FUNCTION getfoo();

[GENERAL] safely increase a single column integer value

Hi, What is the best way from concurrency point of view to increase a integer value from a table? Suppose you count every postback from all the users that are currently browsing your web-site. Cheers, Anton ---(end of broadcast)--- TIP 9: In

[GENERAL] day of week

Hi, I have records with date column. Is there a way I can get which day of week this date is? Cheers, Anton ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining

[GENERAL] Sql problem

Hi, Can you tell me more about Postgresql string functions? I want to replace a column text "1/2/3/8/" to the corresponding values to these values like "A, B, C, D". Cheers, Anton Andreev ---(end of broadcast)--- TIP 4: H

Re: [GENERAL] Please change default characterset for database cluster

Hi, Get a VPS - Virtual Private Server. Mine is 29$ and it is fine for 480MB RAM and enough disk space. I am a full admin on my server, so I install and configure Postgresql without problem. YES! I agree that the default encoding must be UTF-8. I started using Postgresql, cause I had problems w

[GENERAL] OK, when 8.3 is coming?

Hi, Has someone stated when is Postgresql 8.3 coming? Anton ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] [pgadmin-support] questions about cursors

- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anton Andreev Sent: dinsdag 24 april 2007 13:45 To: [EMAIL PROTECTED] Subject: [pgadmin-support] questions about cursors Hi, I am trying to use cursors and I am really frustrated already. Do I need to install an extension? 1

[GENERAL] pgsql-general@postgresql.org

Hi, I am trying to use cursors and I am really frustrated already. Do I need to install an extension? 1. Problem number one is that what ever I use in front of the fetch command it is not being accepted, it gives a syntax error. If I use a number ,"all" or "forward" it gives an error again?

[GENERAL] table as hashtable

Hi, Can I use a Postgre table as hashtable\\? when I do select where column='test', I want this to be done by hashtable, not linear, not by b-tree. I do not need to sort, sum or else I just want to get the value as fast as possible. 10x to anyone answering me Cheers, Anton ---

[GENERAL] posting request

I want to post some questions. ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match