[GENERAL] problems using COPY

2001-09-14 Thread roypgsqlgen
Hey guys, I'm trying to copy in data from a file generated by SQL Server's bcp and for most of my tables I'm not having any problems. But every once in a while, it doesn't like the datetime values from SQL Server, such as this: 2001-02-16 23:32:51.420 Is there anything wrong with this? Oh, d

Re: [GENERAL] maintaining sequences

2001-09-14 Thread roypgsqlgen
Oh, great! So I'm going to do this: select setval('sequencename', ( select max(someid) from sometable ) ); Thanx! Roy. > -Original Message- > From: Jeff Eckermann [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 13, 2001 5:45 PM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] >

[GENERAL] confused on maximum characters

2001-08-16 Thread roypgsqlgen
Hey guys, I'm a little confused by the documentation on varchar data type in postgresql. Looking at the docs Peter Eisentraut added this note at the bottom of the documentation for character data. --- The maximum value for "n" is 2147483648. The longest possible string is actually only about 1

RE: [GENERAL] why no stored procedures?

2001-08-15 Thread roypgsqlgen
> -Original Message- > From: Jan Wieck [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, August 14, 2001 10:51 PM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Re: [GENERAL] why no stored procedures? > > [EMAIL PROTECTED] wrote: > > Hey guys, > > > > Is there any reason why there a