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...
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: pgsql-sql@postgresql.org
Sent: Sunday, December 3, 2006 5:33:41 AM
Subject: [SQL] hi any o
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
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");
$s
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*
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 var
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 co
