Re: [GENERAL] PostgreSQL Installation

Thanks. I think I mistook postgres for postgres-plus. Quoting Ashesh Vashi : You can always download PostgreSQL installer for any supported platform without any registration from http://www.enterprisedb.com/products/pgdownload.do. On Thu, Feb 11, 2010 at 4:30 PM, wrote: Hi, Please why is

[GENERAL] PostgreSQL Installation

Hi, Please why is it that we must register at EnterpriseDB and register each Windows installation of postgreSQL these days? At times, I need to install on a server that is not on the internet and have had to bear the pain of configuring a server for internet before I can install postgreSQ

[GENERAL] Loop

Hi, I have a loop of the form: FOR rec IN SELECT code FROM staff WHERE shiftgroup = NEW.groupe ORDER BY code LOOP WHILE sdate <= NEW.todate LOOP SELECT INTO starty,endy,nday resumetime,closetime,nextday FROM shifts WHERE shift = NEW.shift; restim

[GENERAL] Documentation - PgAdmin

Hi, Congratulations on the release of version 8.4. I am surprised that pgAdmin's help link is now directed to the documentation website of postgresql. The embedded help CHM was not packaged with it. This implies that anytime one needs help on a simple syntax, one must connect to the inte

[GENERAL] Serial Jumping

Hi, I have a table with BIG SERIAL field as Primary KEY. During high load, entries in the BIG SERIAL field are jumped. One could see a row with 1367 and expecting the next INSERT to be 1368, one would end up getting 1369. Please is this normal? Regards, Chris -- Sent via pgsql-general mailing

[GENERAL] [ANN] PostgreSqlClient 2.0 Beta 1 released.

PostgreSqlClient ( old PgSqlClient ) 2.0 Beta 1 is available for download. It's the first version for ADO.NET 2.0 and Microsoft .NET 2.0, be aware that right now it doesn't provide integration with Visual Studio 2005. Download information can be found: http://sourceforge.net/project/showfiles

Re: [GENERAL] Create User

? On 1/20/06, DB Subscriptions <[EMAIL PROTECTED]> wrote: Hi, I have this table: CREATE TABLE users ( userid varchar(100) NOT NULL, nama varchar(50) NOT NULL, pword varchar(255) NOT NULL, groupe varchar(7) NOT NULL, rolle int2 NOT NULL DEFAULT 2, statux varchar(9) NOT NULL DEFAULT &

[GENERAL] Create User

Hi, I have this table: CREATE TABLE users ( userid varchar(100) NOT NULL, nama varchar(50) NOT NULL, pword varchar(255) NOT NULL, groupe varchar(7) NOT NULL, rolle int2 NOT NULL DEFAULT 2, statux varchar(9) NOT NULL DEFAULT 'Active'::character varying, CONSTRAINT users_pkey PRIMARY KEY (u

[GENERAL] Validating User

Hi, Please as a superuser how would I obtain an equivalent of this query: SELECT * FROM pg_shadow WHERE usename='userid' AND md5(passwd)='passwd' I browse the content of the pg_shadow and the passwd field shows something like md5... All I am after is to validate a user against pg_shadow table i

[GENERAL] Replicator

Hi, Does anyone know of any open source PostgreSQL replicator that can replicate data from Fedora Core4 to Windows Server? Can Slony do that? Thanks for your advice. Best regards. Chris. ---(end of broadcast)--- TIP 1: if posting/reading through

[GENERAL] Query Cost

Hi, I have a table with this schema: CREATE TABLE billing.bill ( sno serial NOT NULL, billno int4, det date NOT NULL, . . . CONSTRAINT bill_pkey PRIMARY KEY (sno) ) I want to execute a query that will not return any record. Which of these queries is cheaper please? 1. Select * from