Any functional use? (other than a tough
learning experience?)
--
Until later, Geoffrey
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
I tried to subscribe to a few more lists (docs, patches, and committers) and
got this for them all:
subscribe
Illegal command!
No valid commands processed.
Geoff
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
ht
hat I need
to be able to do (and I would gladly help with the coding if I knew where to
start).
Geoff
-Original Message-
From: mlw [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 24, 2001 9:25 PM
To: Gowey, Geoffrey
Cc: 'Alex Pilosov'; [EMAIL PROTECTED]
Subject: Re: Changing
Two problems (I've been holding back reporting until I ran into this
second):
Background: I'm trying to migrate an existing db from MS Sql 2K to pgsql by
creating a DTS job.
DB system info: NT 4 sp6a, MS SQL2K Regular, Pgsql ODBC driver 7.01.00.06.
First problem: The ODBC driver reports a colum
Also, rename the column to something else so a new one can be created in
it's place with the same name. Do columns have their own oid's? If so this
plus some random chars could be the new name.
Geoff
-Original Message-
From: Gowey, Geoffrey
Sent: Monday, September 24, 2001
. Fournier [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 24, 2001 1:28 PM
To: Gowey, Geoffrey
Cc: 'Hiroshi Inoue'; Stephan Szabo; [EMAIL PROTECTED]
Subject: RE: [HACKERS] an already existing alter table drop column
?!?!?!
On Mon, 24 Sep 2001, Gowey, Geoffrey wrote:
> damn. Is t
damn. Is there a usable version being worked around? If so, how long before
it is available?
Geoff
-Original Message-
From: Marc G. Fournier [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 24, 2001 1:14 PM
To: Gowey, Geoffrey
Cc: 'Hiroshi Inoue'; Stephan Szabo; [EMAIL
Does this mean that the code is or isn't usable?
Geoff
-Original Message-
From: Hiroshi Inoue [mailto:[EMAIL PROTECTED]]
Sent: Sunday, September 23, 2001 11:02 PM
To: Stephan Szabo
Cc: Gowey, Geoffrey; [EMAIL PROTECTED]
Subject: Re: [HACKERS] an already existing alter table drop c
x27;t we aiming to go head to head with
commercial rdbms'?
>>On Mon, 24 Sep 2001, Gowey, Geoffrey wrote:
>> I posted this in my last message, but have not heard anything yet so I'm
>> wondering if it was overlooked. I need to know how to change a column
from
>> being
saying
"no, you can't".
Geoff
-Original Message-
From: Gowey, Geoffrey
Sent: Monday, September 24, 2001 10:53 AM
To: 'Alex Pilosov'; Gowey, Geoffrey
Cc: [EMAIL PROTECTED]
Subject: RE: [HACKERS] Changing data types
>This is not for -hackers.
How so?
>A
I posted this in my last message, but have not heard anything yet so I'm
wondering if it was overlooked. I need to know how to change a column from
being say a varchar(9) to an integer. Does anyone know how to change the
data type?
Geoff
---(end of broadcast)---
While looking through the code I found an already existing alter table drop
column in src/backend/parser/gram.y. However, when I try to run it in psql
it comes back with a not implemented. Was the left hand not talking to the
right hand when this was coded or is there more to this?
Geoff
-
Not sure how to do this, but it shouldn't be too ugly. I want to drop
columns from a table as well as be able to change the data type of a column.
Where should I be looking in the source for altering tables? For removing I
don't imagine it could be too ugly as all it should be is a reverse add.
: Gowey, Geoffrey
Cc: 'Joe Conway'; [EMAIL PROTECTED]
Subject: Re: [HACKERS] version 1 C-Language Functions documentation and
ex ample
"Gowey, Geoffrey" <[EMAIL PROTECTED]> writes:
> ... I have also tried the contrib
> tree, but all the programs in there use vers
ay, August 25, 2001 10:56 PM
To: Gowey, Geoffrey; [EMAIL PROTECTED]
Subject: Re: [HACKERS] version 1 C-Language Functions documentation and
example
> Anyone know of a good reference or set of examples clearly showing the
usage
> of V1? I have a problem that I've posted on pgsql-ge
Anyone know of a good reference or set of examples clearly showing the usage
of V1? I have a problem that I've posted on pgsql-general, but this list
might be more appropriate for.
Geoff
---(end of broadcast)---
TIP 2: you can get off all lists at
16 matches
Mail list logo
