Hi,
If I have a series of Insert statements within a loop in a function on the
same table.
Would an Insert be able to see the values of previous insert in that table ?
I just wanted to know, when would the records be committed, as in, is it
after the whole function is done for with its execution
On 07/08/07 22:07, lai yoke hman wrote:
Hello,
Is there any direct I/O instead of buffered I/O for postgresql?
Thank you.
Why do you want raw IO? Performance would tank.
--
Ron Johnson, Jr.
Jefferson LA USA
Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for
Hello,
Is there any direct I/O instead of buffered I/O for postgresql?
Thank you.
_
Windows Live Spaces is here! It’s easy to create your own personal Web site.
http://spaces.live.com/?mkt=en-my
---(end of br
On Sun, 8 Jul 2007 19:12:46 -0400 Alvaro Herrera wrote:
> Oops :-( We should certainly make an effort to check the validity of
> the values in pg_autovacuum, but 0 is a perfectly valid value, so the
> check would not help you any in this case :-(
Apparently not, taken into account, that the 'ena
Josh Tolley wrote:
On 7/8/07, Crystal <[EMAIL PROTECTED]> wrote:
Hi All,
Our company need to save contact details into the PostgreSQL database. I
just begin to learn it, so I got many questions. I am not sure which
data type I should choose for website address, varchar or char. The
website add
Crystal <[EMAIL PROTECTED]> writes:
> Our company need to save contact details into the PostgreSQL database. I
> just begin to learn it, so I got many questions. I am not sure which
> data type I should choose for website address, varchar or char.
Use varchar. Or text, if you don't have a speci
On 7/8/07, Crystal <[EMAIL PROTECTED]> wrote:
Hi All,
Our company need to save contact details into the PostgreSQL database. I
just begin to learn it, so I got many questions. I am not sure which
data type I should choose for website address, varchar or char. The
website address may be very long
Since VARCHAR length is run length encoded
and CHAR is fixed length
If your string will always be about the same size set as CHAR(MaximumLength)
otherwise use VARCHAR
M
This email message and any files transmitted with it contain confidential
information intended only for the person(s) to whom th
Hi All,
Our company need to save contact details into the PostgreSQL database. I
just begin to learn it, so I got many questions. I am not sure which
data type I should choose for website address, varchar or char. The
website address may be very long, and we also don't want to lose the
speed.
Andreas 'ads' Scherbaum wrote:
> On Sat, 7 Jul 2007 00:12:32 +0200 Andreas 'ads' Scherbaum wrote:
>
> > On Fri, 6 Jul 2007 12:06:41 -0400 Alvaro Herrera wrote:
> >
> > > Andreas 'ads' Scherbaum wrote:
> > > > The value is '0' for all columns in all entries, except 'vacrelid' and
> > > > 'enabled
On Jul 8, 2007, at 14:09 , Pat Maddox wrote:
Can I just convert it, or do I need to dump
it, drop it, recreate with UTF-8, and then load the data?
It depends on what is currently in your (SQL_ASCII) database. If it's
only ASCII data or all non-ASCII data is UTF-8, you should be okay
just
My databases all have the default SQL_ASCII encoding. I read the docs
and it says that you shouldn't use it if you're going to have any
non-ASCII data. I need to start supporting UTF-8, so it seems I need
to convert my database. Can I just convert it, or do I need to dump
it, drop it, recreate
[Please start a new message rather than replying to an old one to
start a new topic.]
On Jul 8, 2007, at 10:16 , Mike Gould wrote:
I would like to see a CREATE Variable dataname datatype added. The
scope of these variables would be global.
CREATE TABLE global_int_variables
(
global
I would like to see a CREATE Variable dataname datatype added. The scope of
these variables would be global. Along this same line I would like to see a
way to have a trigger or rule fired upon connection initialization. This would
allow for these type of variables to be SET along with other de
14 matches
Mail list logo
