My script does essentially the same thing, unfortunately, its hard to
merge since we use different ways to "parse" the SQL. The script in
contrib is good enough and not much different from what I have, so just
keep it ;)
-alex
On Fri, 19 Jan 2001, Bruce Momjian wrote:
>
> We have added contrib
I just checked out the latest/head/tip revision of pgsql from CVS and
built it for NT. Now all regression tests pass.
It seems that the failing tests that I reported in a previous note
were caused by 1) some date/time bugs that have since been fixed, and
2) some problem in my cygwin configuratio
Sorry for switching gear on you without notice. The logic is something like
this:
When remote node attaches to DB for synchronization then update a
common-to-all-tables version sequence. (ONLY in this case do we increment
the version sequence) This is currently handled by an external perl scri
> Umm, sorry.
Sorry again, bad day mixed with feeling rubbed the wrong way.
> and (as pointed out on this thread) it's not even valid
> for the whole of the US.
That's new on me... I have a list of U.S. Postal Codes that all consist of
two letters. This includes all the U.S. states, territories
"rob" <[EMAIL PROTECTED]> writes:
> Is there a correct way to "initialize" currval without incrementing the
> sequence?
No, but for the purpose that was being discussed here, I don't see why
you'd need to. Maybe you should explain the application logic that
seems to require such a thing.
I use for sequences for row versioning not just numbering. I'm glad you
pointed this out. I'll need to revisit that code.
Is there a correct way to "initialize" currval without incrementing the
sequence?
--rob
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "rob" <[EMAI
"Brett W. McCoy" <[EMAIL PROTECTED]> writes:
>> last_value will return whatever value was last assigned
>> by any backend, therefore you might not get the value that was inserted
>> into your tuple, but someone else's.
> In that case you would call next_val *before* you insert and use that
> valu
On Sat, 20 Jan 2001, Tom Lane wrote:
> > currval returns error unless nextval has been called at least once in the
> > session.
>
> > I use .last_value
>
> > Perhaps I'm fooling myself
>
> Yes, you are, unless you never have more than one client attached to
> your database. last_value will retur
"Joseph" <[EMAIL PROTECTED]> writes:
> In file included from mail.c:29:
> /usr/include/pgsql/utils/elog.h:37: parse error before `CritSectionCount'
> /usr/include/pgsql/utils/elog.h:37: warning: data definition has no type or
> storage class
At a guess, this code is neglecting to include postgres
"rob" <[EMAIL PROTECTED]> writes:
> currval returns error unless nextval has been called at least once in the
> session.
> I use .last_value
> Perhaps I'm fooling myself
Yes, you are, unless you never have more than one client attached to
your database. last_value will return whatever value wa
Martijn van Oosterhout wrote:
>
> I must have come over somewhat stronger than I intended.
> It was supposed to be just a passing comment. The reason
> I picked up on it is because it's the first thing people
> think of when looking for a reason for fixed length fields
> and (as pointed out on th
> currval returns error unless nextval has been called at least once in the
> session.
But in my example, which is
> > > create table t1 (recordid SERIAL PRIMARY KEY, val INT4, name TEXT);
> > > ... much later ...
> > > insert into t1 (val, name) values (3465, 'blah');
> > > -- now we want the r
Never mind this one, I guess you MUST also set the buffer value up if you
want to increase the connections setting. Seems like it did not used to be
that way.
I turned on logging and was able to see the problem.
- Original Message -
From: "Joseph" <[EMAIL PROTECTED]>
To: <>
Cc: "Lama
If I set MAX_CONNECTIONS over 32 on 7.1beta3-2 the postmaster refuses to
start?
Joseph
Gregory Wood wrote:
>
> > Does anyone else get annoyed when going on to an american site to
> > register or buy something and find that the state field is only
> > 2 characters long?
>
> Sorry, I didn't realize that many other countries had states... the only
> other frame of reference that I ha
At 07:38 PM 1/19/01 -0700, Ron Chmara wrote:
>Taking a page from M$, they don't exactly sit on the sidelines
>and avoid bashing Linux, Solaris, etc politeness is great
>for getting along and sharing space. If you want to take over
>marketshare, though, it doesn't quite work.
Why "take over ma
I am trying to compile the pg_sendmail function from
ftp://ftp.trurl.anything3d.com/pub/Linux/our/pgsendmail-1.0.tar.gz and I get
the following error message.
I am using 7.1beta3-2 from rpm install.
Here is the error...
# make
/bin/sh ./libtool --mode=compile
gcc -DHAVE_CONFIG_H -I. -I. -I.
"Anthony E . Greene" wrote:
> On Fri, 19 Jan 2001 17:02:43 Gregory Wood wrote:
> >> Does anyone else get annoyed when going on to an american site to
> >> register or buy something and find that the state field is only
> >> 2 characters long?
> [snip]
> >Does anyone else get annoyed when people ju
currval returns error unless nextval has been called at least once in the
session.
I use .last_value
Perhaps I'm fooling myself that the latter is doing what I think, but it
seems to work fine and doesn't require an initial call to nextval.
I too thought that OID was always unique. That is not
Search this (and the novice) list for importing from Excel. I recently
posted some tips there on using tab delimited text files and the copy
command. DBD has a file size limit.
--rob
- Original Message -
From: "Keith G. Murphy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday,
20 matches
Mail list logo
