[SQL] hi any one can help me
Hi ... I installed postgresql 8.1 .. then I uninstalled postgresql.. Now again I am re installing the same postgresql 8.1 .. but its not installing .its giving error like already user exists its showing... I removed those files from registry also.. but I am getting same error... Any one can help to reinstall my postgresql in my machine... Thanks & Regards Penchal reddy | Software Engineer Infinite Computer Solutions | Exciting Times...Infinite Possibilities... SEI-CMMI level 5 | ISO 9001:2000 IT SERVICES | BPO Telecom | Finance | Healthcare | Manufacturing | Energy & Utilities | Retail & Distribution | Government Tel +91-80-5193-(Ext:503)| Fax +91-80-51930009 | Cell No +91-9980012376|www.infics.com Information transmitted by this e-mail is proprietary to Infinite Computer Solutions and/ or its Customers and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please notify us immediately at [EMAIL PROTECTED] and delete this mail from your records. Information transmitted by this e-mail is proprietary to Infinite Computer Solutions and / or its Customers and is intended for use only by the individual or the entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please notify us immediately at [EMAIL PROTECTED] and delete this email from your records.
Re: [SQL] hi any one can help me
You will need to manually remove the postgresql folder under Program files because uninstalling does not remove that folder for you. - Original Message From: Penchalaiah P. <[EMAIL PROTECTED]> To: [email protected] Sent: Sunday, December 3, 2006 5:33:41 AM Subject: [SQL] hi any one can help me Hi … I installed postgresql 8.1 .. then I uninstalled postgresql.. Now again I am re installing the same postgresql 8.1 .. but its not installing .its giving error like already user exists its showing… I removed those files from registry also.. but I am getting same error… Any one can help to reinstall my postgresql in my machine… Thanks & Regards Penchal reddy | Software Engineer Infinite Computer Solutions | Exciting Times…Infinite Possibilities... SEI-CMMI level 5 | ISO 9001:2000 IT SERVICES | BPO Telecom | Finance | Healthcare | Manufacturing | Energy & Utilities | Retail & Distribution | Government Tel +91-80-5193-(Ext:503)| Fax +91-80-51930009 | Cell No +91-9980012376|www.infics.com Information transmitted by this e-mail is proprietary to Infinite Computer Solutions and/ or its Customers and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please notify us immediately at [EMAIL PROTECTED] and delete this mail from your records. Information transmitted by this e-mail is proprietary to Infinite Computer Solutions and / or its Customers and is intended for use only by the individual or the entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please notify us immediately at [EMAIL PROTECTED] and delete this email from your records. Cheap talk? Check out Yahoo! Messenger's low PC-to-Phone call rates. http://voice.yahoo.com
Re: [SQL] hi any one can help me
On 12/3/06, Penchalaiah P. <[EMAIL PROTECTED]> wrote: Hi … I installed postgresql 8.1 .. then I uninstalled postgresql.. Now again I am re installing the same postgresql 8.1 .. but its not installing .its giving error like *already user exists* its showing… I removed those files *from registry* also.. but I am getting same error… *Any one can help to reinstall my postgresql in my machine…* Have you tried deleting the postgres user on your system? See if this helps. -- == Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com http://codeelixir.com ==
Re: [HACKERS] [SQL] Case Preservation disregarding case
Martijn van Oosterhout wrote:
I think you're missing the point that clients will be using languages
that are case sensetive. Consider the following Perl code:
$dbh->do("CREATE TEMP TABLE foo (Bar int4)");
$dbh->do("INSERT INTO foo VALUES (1)");
my $sth = $dbh->prepare("SELECT Bar FROM foo");
$sth->execute();
my $row = $sth->fetchrow_hashref();
print $row->{"bar"}; # prints 1
This code will works on any version of postgresql ever released, yet
your change will break it. By setting some options you can work around
it, but it's still a gratuitous change.
Have a nice day,
I agree, that code would break -- if the option were enabled globally --
because the named-column retrieval internals of that and many existing
modules don't do case-insens lookups. They would have to be retrofitted
to support it.
So that is the reason there was an idea proposed per database or per
connection SQL conformance controls (like what Mysql has). They'd allow
other apps to elect "less standard" modes (not just this one), for the
sake of compatibility (beit old PG modules or and other DB). You code
sample would continue to work.
Ken
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Re: [HACKERS] [SQL] Case Preservation disregarding case
Tom Lane wrote: > Ken Johanson <[EMAIL PROTECTED]> writes: > > Martijn van Oosterhout wrote: > >> I think it's unlikely to happen anytime soon. The primary reason being > >> that then you can no longer use indexes to search the catalog. Which > > > I take a different opinion on this: > > > -*If* the option to turn on case-insenetive behavior were selectable at > > the DB or session level, the existing apps could continue to use the > > case sensitve mode and be completely unaffected. > > Ken, you clearly fail to understand the point being made above. This is > not something that is "selectable at the session level". It won't work > from either a functional or performance perspective. > > The real bottom line, though, is that this community has little respect > for proposals that involve moving away from the SQL spec rather than > closer to it; and that's what you're asking us to do. The spec is not > at all vague about the case-sensitivity of identifiers. Now certainly > we are not doing exactly what the spec says, but what you ask is even > less like the spec's requirements. I think there are two major issues here: o if you quote identifiers that have any upper-case characters, do it both at table creation and use o display of non-quoted identifiers is lower-case I think we are OK making people either always quote, or always not quote. What we don't currently have a good answer for is people wanting the identifiers displayed using the original case. You can use quotes all the time of you want such display, but it is a pain. I think this is the crux of the complaints. Saving the case of the original creation and displaying that does work, but then it isn't clear if the identifier needs quotes (is the upper-case real or just for display). This gets us into even more confusion. Can someone can think of an answer to all this? -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDBhttp://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---(end of broadcast)--- TIP 6: explain analyze is your friend
[SQL] Query for block updates
Hi, If this question doesn't belong to this mailing list, please pardon. I have a table with a few hundred million rows, and I need to write a query that does something like follows -- Change all the values of a column to null where the value cannot be casted to numeric(20,4) I have it as varchar, and I need to convert it to numeric(20,4). I am using this query - alter table optiondata ALTER volume TYPE numeric(20,4) using cast(volume as numeric(20,4)); then wait for DB to complain, and then update that value to null, and just keep doing this till all garbadge is removed :-( Thanks, Amit ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [SQL] Query for block updates
Amit Shah <[EMAIL PROTECTED]> writes: > I am using this query - alter table optiondata ALTER volume TYPE > numeric(20,4) > using cast(volume as numeric(20,4)); then wait for DB to complain, and then > update that value to null, and just keep doing this till all garbadge is > removed :-( You could automate it in plpgsql ... something like for r in select id, val from table loop begin perform cast(r.val as numeric(20,4)); exception when ... then update table set val = null where id = r.id; end; end loop; and then do the ALTER TYPE after you've cleaned the data. regards, tom lane ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
