Re: [SQL] syncing - between databases

True, But it has its own stable version capable to handle this functionality On Mon, May 14, 2012 at 5:23 PM, Devrim GÜNDÜZ wrote: > On Mon, 2012-05-14 at 17:22 +0530, Trinath Somanchi wrote: > > You can use PgCluster with Slony-II for this type of requirements. > > PGCluster is

Re: [SQL] syncing - between databases

t; > worry >> > > about a locked record. But what happens if a user is updating at the >> > > same moment as a different user in a different database is updating >> the >> > > same customer. Can a race condition occur? >> > > >> > > I was thinking I could create a master database. And have all the >> other >> > > databases use dblink to excute the master trigger. >> > > >> > > >> > > Any advise would be helpful, >> > > >> > > Johnf >> > > >> > > -- >> > > Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) >> > > To make changes to your subscription: >> > > http://www.postgresql.org/mailpref/pgsql-sql >> > > -- Regards, -- Trinath Somanchi, +91 9866 235 130

Re: [SQL] How to group by similarity?

appropriate solution can be suggested. -- Trinath Somanchi. On Wed, Apr 25, 2012 at 12:09 AM, Andreas wrote: > Hi, > > I'm trying to get an idea about pg_trgrm. > I created a GIST index on a text column in a table. > Now I can filter the table with similarity(). > > How

Re: [SQL] converting type and function in postgresql ?

n := instr( l_string, ',' ); > > l_data.extend; > > l_data(l_data.count) := ltrim( rtrim( substr( l_string, 1, n-1 ) > ) ); > > l_string := substr( l_string, n+1 ); > > end loop; > > > > return l_data; > > end; > > > > how this function can be rewritten in postgresql ? > > > > your help will help me a lot. > > > > Thanks > Amar > -- Regards, -- Trinath Somanchi,

Re: [SQL] linux. ossp-uuid

w I can fix it? > > > -- > С уважением, Николай Ижиков > nizhi...@gmail.com > -- Regards, -- Trinath Somanchi,

Re: [SQL] Using count on a join, group by required?

ing list archive at Nabble.com. > > -- > Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql > -- Regards, -- Trinath Somanchi,

Re: [SQL] insert from a select

tly. > > >> > > >> Like I said the table "tempclass" (a temporary) is a dup of table > > >> "esclass" so > > >> none of it makes sense. Of course I did say I'm missing something. > > >> > > >> So why isn't the select statement working with the insert? > > >> > > >> Johnf > > Thanks to all - after reading everyone responses I slept on it. Today I > realized that the order of the fields mattered as you all suggested. > > Thanks to all, > Johnf > > -- > Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql > -- Regards, -- Trinath Somanchi,

[SQL] UUID for Postgresql 8.4

Hi All, I have a column in my Postgresql database tables which need UUID. Is there any function in Pgsql for UUID generation. Please help me in this regard. -- Regards, -- Trinath Somanchi,

Re: [SQL]

; the nasty god damned CSTRING off the input/output operations. > > > -- > Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql > -- Regards, -- Trinath Somanchi,

[SQL] How to store Byte strings into a table.

. Please help me in this regard. -- Regards, -- Trinath Somanchi,

Re: [SQL] Postgresql database

yes... But attribute of this table asl has an instance .. that two year of releases are possible also... I'm speaking of a very trivial case. On Fri, May 14, 2010 at 2:44 PM, silly sad wrote: > On 05/14/10 12:42, Trinath Somanchi wrote: > >> Hi All, >> >> I hav

[SQL] Postgresql database

s. I'm in my way to design this DB for use in PgSQL. But for a vast data, data retrieval is a very costly task (Joining all tables). Can any one guide me of this design, on how the structure looks like. Hard about Inheritance feature of pgSQL. But not aware of how implementation goes. Thanks in advance. -- Regards, -- Trinath Somanchi,