[GENERAL] Urgent job opening for PostgreSQL DBA.

2007-04-01 Thread Poornima
Hi, We have excellent and urgent job opening for PostgreSQL DBA with one of our esteemed client in Pune/ Bangalore. Skillset : PostgreSQL DBA Experience : 5 - 7 yrs Location : Pune/ Bangalore. If interested, please send me your updated resume in MS word format along with the CTC de

[GENERAL] Urgent job opening for PostgreSQL DBA.

2007-04-01 Thread Poornima
Hi, We have excellent and urgent job opening for PostgreSQL DBA with one of our esteemed client in Pune/ Bangalore. Skillset : PostgreSQL DBA Experience : 5 - 7 yrs Location : Pune/ Bangalore. If interested, please send me your updated resume in MS word format along with the CTC de

Re: [GENERAL] Problem restoring from backup file

2007-04-01 Thread Chris
Rohit Prakash Khare wrote: I am using PGSQL 8.2.3. I took a backup of my database selecting "Plain" option from pgAdmin 1.6. When I am trying to restore it to a new machine having PGSQL 8.2.3 installed, using pgAdmin, the OK button of the "Restore Backup Window" remains disabled. Why? The pg-

Re: [GENERAL] Connecting a sequence with table column

2007-04-01 Thread Chris
RPK wrote: I am using PGSQL 8.2.3 on Windows XP and pgAdmin 1.6.3. While adding columns to a table from pgAdmin front-end, an option appears "sequence" with a drop-down box on the column creation window, but it remains disabled. I have already created a sequence but want to connect that sequence

Re: [GENERAL] Tsearch2 crashes my backend, ouch !

2007-04-01 Thread Listmail
Anyway, just to signal that tsearch2 crashes if SELECT is not granted to pg_ts_dict (other tables give a proper error message when not GRANTed).On I don't understand this. Are sure on this ? From prompt in your select examples I see you have superuser's rights and you have successfully

Re: [GENERAL] postgresl for mysql?

2007-04-01 Thread Listmail
>What will they think of next! >http://krow.livejournal.com/502908.html >I suppose it makes as much sense as the others, except why would you >want to use mysql if the storage is in postgres? If you've inherited data in a postgresql database this will allow you to migrate it to the industry sta

Re: [GENERAL] postgresl for mysql?

2007-04-01 Thread felix
On Sun, Apr 01, 2007 at 10:53:06AM -0700, Steve Atkins wrote: > > On Apr 1, 2007, at 10:33 AM, Anton Melser wrote: > > >What will they think of next! > >http://krow.livejournal.com/502908.html > >I suppose it makes as much sense as the others, except why would you > >want to use mysql if the stor

Re: [GENERAL] postgresl for mysql?

2007-04-01 Thread Anton Melser
OK, it got me for more than half a second... :-) And as you mention - not entirely ridiculous! Cheers Anton On 01/04/07, Tom Lane <[EMAIL PROTECTED]> wrote: Leonel <[EMAIL PROTECTED]> writes: > On 4/1/07, Anton Melser <[EMAIL PROTECTED]> wrote: >> What will they think of next! >> http://krow.liv

Re: [GENERAL] postgresl for mysql?

2007-04-01 Thread Tom Lane
Leonel <[EMAIL PROTECTED]> writes: > On 4/1/07, Anton Melser <[EMAIL PROTECTED]> wrote: >> What will they think of next! >> http://krow.livejournal.com/502908.html > Is today Aprils Fool's ? Yup. But he got me for about half a second, because this was proposed entirely seriously by the MySQL A

Re: [GENERAL] Tsearch2 crashes my backend, ouch !

2007-04-01 Thread Oleg Bartunov
On Fri, 30 Mar 2007, Listmail wrote: OK, I've solved my problem... thanks for the hint ! Anyway, just to signal that tsearch2 crashes if SELECT is not granted to pg_ts_dict (other tables give a proper error message when not GRANTed).On I don't understand this. Are sure on this ? F

[GENERAL] Problem restoring from backup file

2007-04-01 Thread Rohit Prakash Khare
I am using PGSQL 8.2.3. I took a backup of my database selecting "Plain" option from pgAdmin 1.6. When I am trying to restore it to a new machine having PGSQL 8.2.3 installed, using pgAdmin, the OK button of the "Restore Backup Window" remains disabled. Why? Have you checked out the new-look w

[GENERAL] Connecting a sequence with table column

2007-04-01 Thread RPK
I am using PGSQL 8.2.3 on Windows XP and pgAdmin 1.6.3. While adding columns to a table from pgAdmin front-end, an option appears "sequence" with a drop-down box on the column creation window, but it remains disabled. I have already created a sequence but want to connect that sequence with this co

Re: [GENERAL] postgresl for mysql?

2007-04-01 Thread Leonel
On 4/1/07, Anton Melser <[EMAIL PROTECTED]> wrote: What will they think of next! http://krow.livejournal.com/502908.html I suppose it makes as much sense as the others, except why would you want to use mysql if the storage is in postgres? Cheers Anton ---(end of broadcast

Re: [GENERAL] postgresl for mysql?

2007-04-01 Thread Steve Atkins
On Apr 1, 2007, at 10:33 AM, Anton Melser wrote: What will they think of next! http://krow.livejournal.com/502908.html I suppose it makes as much sense as the others, except why would you want to use mysql if the storage is in postgres? If you've inherited data in a postgresql database this w

[GENERAL] postgresl for mysql?

2007-04-01 Thread Anton Melser
What will they think of next! http://krow.livejournal.com/502908.html I suppose it makes as much sense as the others, except why would you want to use mysql if the storage is in postgres? Cheers Anton ---(end of broadcast)--- TIP 3: Have you checked

Re: [GENERAL] Arrays instead of join tables

2007-04-01 Thread Ron Mayer
William Garrison wrote: > I've never worked with a database with arrays, so I'm curious... > > + Efficiency: To return the set_ids for an Item, I could return an array > back to my C# code instead of a bunch of rows with integers. That's > probably faster, right? You should look in to the contri