Hi,
Could anyone let me know how to unsubscribe?
Thanks,Angshu
On 10/24/05, William Yu <[EMAIL PROTECTED]> wrote:
[EMAIL PROTECTED] wrote:> VFP will run in WINE up to VFP version 8. But the people I talk to that
> are doing this are using VFP's native tables. Does anyone know if it's> possible
Hi,
I've the following scenario:
1. I've my web server on a windows xp machine - IIS
2. I've my database server on a linux machine - postgresql
3. I'm using php on the windows machine to connect to my db
I'm failing to connect to my db. What is the solution?
Are there any DSO kind of stuff to
Hi Pgsql,I've a table schema in pg say as:(A B C D E) where none of these fields allow null.Now, I've a flat file that has got tab-delimited data for B,C and E fields.And A,B come from sequences.
Could anyone please let me know how I can upload the complete dataset into the table?Thanks,AK-- Ignore
COPY?Thanks,AngshuOn 1/5/06,
Jim C. Nasby <[EMAIL PROTECTED]> wrote:
On Thu, Jan 05, 2006 at 10:51:55PM -0600, Angshu Kar wrote:> Hi Pgsql,>> I've a table schema in pg say as:>> (A B C D E)>> where none of these fields allow null.>
> Now, I've a flat file
Could you please tell me what's the syntax with INSERT for this?On 1/5/06, Bruno Wolff III <[EMAIL PROTECTED]> wrote:
On Thu, Jan 05, 2006 at 22:51:55 -0600, Angshu Kar <
[EMAIL PROTECTED]> wrote:> Hi Pgsql,>> I've a table schema in pg say as:>> (A B C D E)>
without any avail!Also do I need to change the permission to akar directory? How(I'm a linux freshie)?Thanks,Angshu
On 1/5/06, Michael Fuhr <[EMAIL PROTECTED]> wrote:
On Thu, Jan 05, 2006 at 11:04:16PM -0600, Angshu Kar wrote:> Thanks Jim. the statement is running without any error but noth
I've solved the permission issue but now the error is:ERROR: missing data for column "subject_entry_id"
CONTEXT: COPY distance, line 1: "107128"I feel the ^M is creating the problem! Any means to remove that? I mean using the delimiters option?
On 1/6/06, Angshu Kar
and to succeed you need to execute this command as rootor the owner of the directoryOn 1/6/06, Angshu Kar <[EMAIL PROTECTED]
> wrote:> Thanks Michael.>> I'm using PgAdmin III 1.4.0 from my WinXP m/c to access the DB in my linux> m/c! The file has about 2GB data.It returns back
ith field E too!
AKOn 1/6/06, Angshu Kar <[EMAIL PROTECTED]> wrote:
Thanks for the chmod command Pandu but the cat command is not doing anything!And as Michael suggested that file has indeed carriage returns embedded in fields. I opened it in my windows m/c using textpad and got:
B1 C1 E
RESTRICT "distance_subject_id_fkey" FOREIGN KEY (subject_id) REFERENCES entry(entry_id) ON UPDATE RESTRICT ON DELETE RESTRICT
On 1/6/06, Pandurangan R S <[EMAIL PROTECTED]> wrote:
Please show the output of describe command of the tableOn 1/6/06, Angshu Kar <[EMAIL PROTECTED]&
EFAULT nextval('')Btw, what version of postgres are you using?
On 1/6/06, Angshu Kar <[EMAIL PROTECTED]> wrote:> here it is:>>>Table "public.distance"> Column| Type | Modifiers
> --+-
No need for that. Everything works fine. I'm grateful pgsql. And thanks a ton Pandu:)On 1/6/06, Angshu Kar <
[EMAIL PROTECTED]> wrote:Thanks a lot Pandu.Everything works ok. Now one last thing : I want to insert a fixed value to the D field in all rows. Any statement for that
Hi Pgsql,I want to copy the output of a SELECT query onto a text file. I'm trying to use the COPY command for that as :COPY (SELECT ) to 'outfile'But its throwing some error. Is it possible? Else, are there any means to do it?
Thanks,AK-- Ignore the impossible but honor it ...The only enviable
Thanks Andreas. But how can I run this from the pgAdmin III Query tool in a WinXP m/c?On 1/7/06, A. Kretschmer <
[EMAIL PROTECTED]> wrote:am 07.01.2006, um 14:13:28 -0600 mailte Angshu Kar folgendes:
> Hi Pgsql,>> I want to copy the output of a SELECT query onto a text file. I&#
Hi Pgsql,Could anyone please advise whether the following program can be implemented using pgsql cursors/anythign else (or do we need some external scripts)?If yes, could you give please some function names etc?
select A from Bcluster where pvalue = 0.3--say we get A=8
select B, A_child from CClust
Ok thanks AndreasOn 1/7/06, Andreas Kretschmer <[EMAIL PROTECTED]> wrote:
Angshu Kar <[EMAIL PROTECTED]> schrieb:> Thanks Andreas. But how can I run this from the pgAdmin III Query tool in a> WinXP m/c?Sorry, i don't using pgAdmin nor windows...
I mean, use the CLI-Interfa
Got it. Thanks a ton Tino...
On 1/8/06, Tino Wildenhain <[EMAIL PROTECTED]> wrote:
Angshu Kar schrieb:> Thanks Andreas. But how can I run this from the pgAdmin III Query tool> in a WinXP m/c?
You dont. There is the function for saving query data to filealready built in. Just pres
Hi,Can I use Select max(a field returned from another query)?say, another query returns say 10,1,2,3,6,7
Thanks,AK-- Ignore the impossible but honor it ...The only enviable second position is success, since failure always comes first...
AIL PROTECTED]> wrote:
On Thu, 2006-01-12 at 12:58, Angshu Kar wrote:> Hi,>> Can I use Select max(a field returned from another query)?> say, another query returns say 10,1,2,3,6,7Does this form help you:
select max(a) from (select 1 as a union select 2 union select 3) as b;-- Ignore
Thanks Scott. I've used another way of getting the max - I've used order by desc in my inner query and selected top 1 to get the max value ...On 1/12/06,
Scott Marlowe <[EMAIL PROTECTED]> wrote:
On Thu, 2006-01-12 at 13:14, Angshu Kar wrote:> What are 1 ,2 and 3 in your query?
Hi,Could anyone please let me know how can I view the pgsql log?A week back everything was ok but today I open my db and see many data deleted.Can I view when this happened?Thanks,AK
Thanks Chris. I;ll try that tomorrow
On 7/5/06, Chris <[EMAIL PROTECTED]> wrote:
Angshu Kar wrote:> Hi,>> Could anyone please let me know how can I view the pgsql log?
> A week back everything was ok but today I open my db and see many data> deleted.> Can I view when thi
22 matches
Mail list logo
