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
[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
(
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
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
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'.
Can a
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
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
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,
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 specific
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
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
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
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
13 matches
Mail list logo