Re: [GENERAL] Arduino SQL Connector

2014-04-28 Thread vincent elschot
On 18-04-14 06:21, John R Pierce wrote: On 4/17/2014 9:09 PM, Steve Spence wrote: You know what? Fine, it doesn't matter that much to me. I'm happy to continue using MySQL. It works with the Arduino quite nicely. Postgres doesn't work. That's Postgres loss not mine. I really thought the postgre

[GENERAL] Select max(id) causes AccessExclusiveLock?

2014-04-28 Thread Edson Richter
On table create table MyTableName ( id integer not null primary key, seqYear char(4), seqCount integer, ...) Where id is primary key and (seqYear, seqCount) is a unique index. Table facts: about 40 fields, 1 million records. When I issue a select max(id) from MyTableName Postgres 9.2

Re: [GENERAL] Select max(id) causes AccessExclusiveLock?

2014-04-28 Thread Tom Lane
Edson Richter writes: > When I issue a > select max(id) from MyTableName > Postgres 9.2.7 is scaling a AccessExclusiveLock and causing large delays. Really? regression=# create table MyTableName ( regression(#id integer not null primary key, regression(#seqYear char(4), regression(#s

Re: [GENERAL] Select max(id) causes AccessExclusiveLock?

2014-04-28 Thread Edson Richter
Em 28/04/2014 12:01, Tom Lane escreveu: Edson Richter writes: When I issue a select max(id) from MyTableName Postgres 9.2.7 is scaling a AccessExclusiveLock and causing large delays. Really? regression=# create table MyTableName ( regression(#id integer not null primary key, regression(#

Re: [GENERAL] Select max(id) causes AccessExclusiveLock?

2014-04-28 Thread Stephen Frost
Edson, * Edson Richter (edsonrich...@hotmail.com) wrote: > The programmer added a > > LOCK TABLE MyTableName > > just before issuing the select max(id) from MyTableName. > > I do suspect this is the case, right? Yup, that'll do it. http://www.postgresql.org/docs/9.3/static/sql-lock.html

[GENERAL] xml question

2014-04-28 Thread David Ekren
I am new to this forum. I need to return the value 1 between the orientationId tags in this xml string within the function below. I still get errors. I'm sure I am doing something wrong. Any help would be appreciated. CREATE FUNCTION Davidxml9(v_clipId integer, v_orientationId varchar(1024), OU

[GENERAL] problems with permissions

2014-04-28 Thread Eric Smith
All, Having a problem dumping a database using pg_dump. This is Mac OS 10.9.2 and postgres 8.3. I'm using md5 for authentication, and have the appropriate .pgpass file with u=rw permissions in the user's home directory. I can access my database, called radiovision, using psql -U radiovision.

Re: [GENERAL] problems with permissions

2014-04-28 Thread John R Pierce
On 4/25/2014 7:11 PM, Eric Smith wrote: Having a problem dumping a database using pg_dump. This is Mac OS 10.9.2 and postgres 8.3. I'm using md5 for authentication, and have the appropriate .pgpass file with u=rw permissions in the user's home directory. I can access my database, called radi

Re: [GENERAL] problems with permissions

2014-04-28 Thread Adrian Klaver
On 04/25/2014 07:11 PM, Eric Smith wrote: All, Having a problem dumping a database using pg_dump. This is Mac OS 10.9.2 and postgres 8.3. I'm using md5 for authentication, and have the appropriate .pgpass file with u=rw permissions in the user's home directory. I can access my database, cal

Re: [GENERAL] xml question

2014-04-28 Thread David G Johnston
David Ekren wrote > I am new to this forum. I need to return the value 1 between the > orientationId tags in this xml string within the function below. I still > get errors. I'm sure I am doing something wrong. Any help would be > appreciated. > > > CREATE FUNCTION Davidxml9(v_clipId integer, v_o