> I think the "VACUUM ANALYZE" solution should be given great prominence in
> the FAQ.
>
> Possibly add to:
> 4.9) My queries are slow or don't make use of the indexes. Why?
> http://www.postgresql.org/docs/faq-english.html#4.9
>
> New first lines:
> Make sure relevant indexes exist (see 4.8) t
Hi,
I'm trying to write a simple C function:
char *pg_crypt (char *pass) {
char *salt="xyz";
char *res;
res = (char *) palloc(14);
res=crypt(pass,salt);
return res;
}
CREATE FUNCTION pg_crypt(text) RETURNS text as
'/
Hi,
Prior to 6.5, when I ran
$ jar tvf jdbc6.5-1.2.jar
I got
..
5309 Wed Sep 15 21:45:44 CST 1999 postgresql/Driver.class
..
Now in 7.0, when I ran
$ jar tvf jdbc7.0-1.2.jar
I got
..
5341 Mon May 15 16:07:48 CST 2000 org/postgresql/Driver.class
..
Is there any particul
Hi,
After installing postgresql-7.0-1, I got the following message
whenever I login/connect to postmaster via JDBC,
Message from syslogd@mylinux at Fri May 19 20:48:11 2000 ...
mylinux
Message from syslogd@mylinux at Fri May 19 20:59:11 2000 ...
mylinux
I have never seen this kind
I've worked with various versions of Oracle for several years and can share
some of my experiences with their "system catalog" implementation.
They use a fairly simple design in which a database instance consists of 1
.. n tablespaces (that can contain any type of database object) which in
turn c
Thomas Lockhart writes:
> So pg_location would hold the full path (absolute or logical) to every
> file resource in every database? Or would it hold only a list of
> allowed paths? Or only a list of resources for each database (~1 row
> per database) and then table-specific info would be store
Bruce Momjian wrote:
>
> I have completed the first draft of my book through chapter 10.
>
> New chapters include:
>
> Chapter 7, Numbering rows: OID's, sequences
>
> Chapter 8, Combining Selects: UNION, subqueries
>
> Chapter 9, Data Types: types, functions, operat
Hi, I just start using pgsql and I am new to SQL also. I have read lots
of
documents on this and I cant seem to find the answer, perhaps you can
help me.
Say I have a table:
pgsql=> \d test_table
test_table
--
f1| CHAR (40)
f2| CHAR (40)
Somewhere down the line I n
Is there a way to automatically uppercase a column upon insert or
update?
I don't think rules can do that because of the problem of recursion.
The only way I think it can be done is using triggers. Is that correct?
--
Bruce Momjian| http://www.op.net/~candle
[EMAI
On Fri, May 19, 2000 at 05:54:55PM +0200, [EMAIL PROTECTED] wrote:
> Hi,
> I'm trying to write a simple C function:
>
> char *pg_crypt (char *pass) {
> char *salt="xyz";
> char *res;
> res = (char *) palloc(14);
> res=crypt(pass,sa
Richard,
For constraints see:
http://www.postgresql.org/doxlist.html
then select Documentation
then select Integrated Document
then select Alter Table
For Column definitions:
I believe some other implementations of SQL allow you to alter
columns as long as you are keeping the same basic datatype
> Having the
> ability to organize tables, indices, etc into tablespaces, and then
> distributing the datafiles in some quasi intelligent fashion is truly pretty
> powerful.
Great feedback! Everyone will agree that there is no problem with the
overall goal. We're just working out the details, and
Tom Lane wrote:
> It's kinda fuzzy, but in practice I'd say the readers of pgsql-hackers
> and maybe pgsql-general.
One more time for the mailing list...
Hands up if you have objections to the patch I recently submitted for
postgresql. It fixes the long standing bit-rot / bug that DELETE and
Does anyone happen to have a copy of the zips.zip file from the census
bureau? Their FTP server is uncooperative.
Dustin Sallings wrote:
>
> On Thu, 18 May 2000, Jeff Hoffmann wrote:
>
> I tried to get a few permutations of that to work, but with no
> luck. The following will give a l
I have been looking for information on the meaning of each column in
pg_shadow, but have been unable to find any thus far. It would be good if
someone could enlighten me, or point me to existing documentation. The
columns I am unsure of are listed below:
usecreatedb:
Ability to create new d
Bruce Momjian wrote:
> Is there a way to automatically uppercase a column upon insert or
> update?
>
> I don't think rules can do that because of the problem of recursion.
> The only way I think it can be done is using triggers. Is that correct?
>
Since triggers are available in postgreSQL, tha
"Michael A. Mayo" <[EMAIL PROTECTED]> writes:
> I have been looking for information on the meaning of each column in
> pg_shadow, but have been unable to find any thus far. It would be good if
> someone could enlighten me, or point me to existing documentation. The
> columns I am unsure of are l
Hi,
how should I write this:
todolist=# select name from tasks_t where id = 5 and NOT done;
ERROR: argument to NOT is type 'numeric', not 'bool'
bis später...
Sascha
18 matches
Mail list logo
