On 9/04/2010 11:35 AM, chaoyong wang wrote:
> It reports an ERROR:
> could not load library "C:\Program
> Files\PostgreSQL\8.3\lib/xml_index.dll": The specified module could not
> be found.
>
> I checked the directory C:\Program Files\PostgreSQL\8.3\lib,
> xml_index.dll exists.
> I tried to cha
Hi peng
> According to 8.4 document 44.1(Most system catalogs are
> copied from the template database during database creation and are
thereafter database
> -specific.),we know that each created database has their own pg_...
tables
I believe it is right.
> and thus if a superuser admini
Hi,I'm using VC2005 to create PG C-language Fun in my contrib xml_index,
which import other library, and I have add the include and lib directory by
changing Mkvcbuild.pm and config.pl.
But after I executed the following commands:build DEBUGperl
install.pl "C:\Program F
On 8/04/2010 2:01 PM, Jeffrey Ottery wrote:
Running Windows XP Pro. Have been successfully using and deploying
postgres for 2 years.
When I try to Uninstall PostgreSQL 8.3 using Windows Add/Remove
Programs I get this message:
Service "PostgreSQL Database Server 8.3' (pgsql-8.3) failed to start.
hi,Kenichiro,
Thanks for your answer!
Then another question comes: According to 8.4 document 44.1(Most system
catalogs are copied from the template database during database creation and
are thereafter database-specific.),we know that each created database has
their own pg_... tables and thus i
Hello sunpeng
First,I answer this question.
>another question:how postgresql internal knows which
>relations belongs to which database?
When we use "psql" command ,it means "psql -d postgres".
#you can change default parameter to set PGDATABASE (OS parameter)
"-d" indicate your connecting datab
On Thu, Apr 8, 2010 at 6:34 PM, sunpeng wrote:
> once i have created mydb and several relations in it,are there any sql
> commands used to list all the tables in this mydb?
> i noticed there are no database( pg_database.oid) field in pg_class table,so
> i can not use
> select relname from pg_class
On Thu, 2010-04-08 at 11:02 -0700, Jeff Davis wrote:
> The current implementation does not enforce the declared number of
> dimensions either. Arrays of a particular element type are all
> considered to be of the same type, regardless of size or number of
> dimensions. So, declaring the array size
once i have created mydb and several relations in it,are there any sql
commands used to list all the tables in this mydb?
i noticed there are no database( pg_database.oid) field in pg_class table,so
i can not use
select relname from pg_class,pg_database where pg_database.datname like
'mydb' and pg_
how to debug the codes in the PostgresMain() from the begining of this
function to the "for (;;)" loop that handles the connection?
if i use eclipse cdt to attach the postgres process forked by postmaster,
this part of codes from the begining of this PostgresMain() to the "for
(;;)" loop could not
On 08.04.2010 21:27, Oleg Bartunov wrote:
it means, that (from
http://www.postgresql.org/docs/current/static/textsearch-dictionaries.html#TEXTSEARCH-ISPELL-DICTIONARY)
12.6.5. Ispell Dictionary
The Ispell dictionary template supports morphological dictionaries,
which can normalize many diff
Steven Harms escribió:
> I don't have stats on how big they were getting, but they are running
> this every night, which I suspect causes issues (and I suspect the
> reason their logs were getting big is because they programmed a bunch
> of locked transactions):
>
> find /pgsql/data/pg_xlog -type
I don't have stats on how big they were getting, but they are running
this every night, which I suspect causes issues (and I suspect the
reason their logs were getting big is because they programmed a bunch
of locked transactions):
find /pgsql/data/pg_xlog -type f -mtime +1 | xargs rm -f
find /pgs
Steven Harms escribió:
> I ran into a script today that was removing files under
> /var/lib/pgsql/data/pg_clog today because they were too large
> (Postgresql 7.4). My initial thought was this could cause data loss
> or corruption, can someone provide insight as to if that is correct?
Yeah. How
I ran into a script today that was removing files under
/var/lib/pgsql/data/pg_clog today because they were too large
(Postgresql 7.4). My initial thought was this could cause data loss
or corruption, can someone provide insight as to if that is correct?
Thanks,
Steve
--
GPG Key ID: C92EF367 /
On Thu, 8 Apr 2010, Corin wrote:
On 08.04.2010 20:15, Oleg Bartunov wrote:
On Thu, 8 Apr 2010, Corin wrote:
english_ispell dictionary is a morphology kind of dictionary ! Read docs.
Also, simple dictionary will never invoked, since english_stem dictionary
recognizes everything !
I'm not sure w
On 08.04.2010 20:15, Oleg Bartunov wrote:
On Thu, 8 Apr 2010, Corin wrote:
english_ispell dictionary is a morphology kind of dictionary ! Read docs.
Also, simple dictionary will never invoked, since english_stem dictionary
recognizes everything !
I'm not sure what you mean with 'morphology'. I s
On Thu, 8 Apr 2010, Corin wrote:
Hi!
I'm using postgres 8.4.3 and try to get stemming/ wrong word correction
working.
I already installed the myspell dictionaries using apt-get and created
postgres dictionaries like this:
Fulltext search configuration ?public.english_ispell?
Parser: ?pg_c
On Thu, 2010-04-08 at 13:30 -0400, Joseph S wrote:
> What's up with Postgres and array dimensions? The table definition
> doesn't even store how many dimensions the array should be.
>
That's a little strange, but it is documented behavior:
>From http://www.postgresql.org/docs/8.4/static/arrays
What's up with Postgres and array dimensions? The table definition
doesn't even store how many dimensions the array should be.
[local]:playpen=> create table arrtest(
playpen(>id SERIAL PRIMARY KEY,
playpen(> arrone int[],
playpen(> arrtwo int[][]
playpen(> );
NOTICE: CREATE TABLE will
On Thu, Apr 8, 2010 at 6:18 PM, Merlin Moncure wrote:
> On Thu, Apr 8, 2010 at 11:40 AM, Jorge Arevalo
> wrote:
>> Is this a good way of doing it? Is it possible? And another small
>> question: if the memory for my array of structs is allocated inside
>> the function that provides me the array, s
On Thu, Apr 8, 2010 at 7:12 AM, Utsav Turray wrote:
> Even if If i try to pad the file 25205.3 using DD command I am not able to
> calculate the bytes to be padded as the total count of the blocks is comming
> out to be 521228 and the error is coming cannot read the 348938 block.
Assuming 25205
On Thu, Apr 8, 2010 at 11:40 AM, Jorge Arevalo
wrote:
> Is this a good way of doing it? Is it possible? And another small
> question: if the memory for my array of structs is allocated inside
> the function that provides me the array, should I deallocate it in the
> SRF? Using pfree? It wasn't all
Hello,
I need to code a set-returning function, but it's my first time, and
I'm not sure if my point is the right one. I'd like to know your
opinion:
My function will return an array of structs. Then, In the first call
(SRF_IS_FIRSTCALL() is true), I get the array from another function.
For the n
Hi!
I'm using postgres 8.4.3 and try to get stemming/ wrong word correction
working.
I already installed the myspell dictionaries using apt-get and created
postgres dictionaries like this:
Fulltext search configuration »public.english_ispell«
Parser: »pg_catalog.default«
Token |
On Apr 7, 2010, at 11:12 PM, Utsav Turray wrote:
> Dear All ,
>
> I am using postgres 7.3. on RHEL 4.0
I don't know the answer to your problem, but I do know that you have many, many
years worth of bug fixes, improvements, and optimizations you are missing due
to running on such old software
On 4/8/2010 9:30 AM, Bill Moran wrote:
> In response to Ognjen Blagojevic:
>
>>
>> Is this:
>> a. Lookup table
>> b. Classifier
>> c. Cypher(er)?
>>
>> I'm looking for the appropriate term in English.
>>
> I try to make it an ENUM when it's very unlikely to change, i.e. day of
> the week
Dear All ,
I am using postgres 7.3. on RHEL 4.0
If I do any operation(select , delete , count , update , vacuum,reindex) on a
table ; the error comes "Cannot read block 348938 of pdbsynchtable"
Given below is the o/p of the files corresponding to the table
-rw--- 1 postgres postgres 107
Running Windows XP Pro. Have been successfully using and deploying
postgres for 2 years.
When I try to Uninstall PostgreSQL 8.3 using Windows Add/Remove
Programs I get this message:
Service "PostgreSQL Database Server 8.3' (pgsql-8.3) failed to start.
Verify that you have sufficient privileges to
In response to Ognjen Blagojevic :
> Hi,
>
> How do you name a table which sole purpose is to store a list of values?
> E.g.
>
> Table: sex
> id name
> ---
> 1 male
> 2 female
>
> Table: day
> id name
> ---
> 1 Sunday
> 2 Monday
> 3 Tuesday
> 4 Wednesday
> 5 Thursday
> 6 Friday
> 7 Sat
On Thu, Apr 08, 2010 at 10:16:57PM +0900, Ian Barwick wrote:
> > How do you name a table which sole purpose is to store a list of values?
> (...)
> > Is this:
> > a. Lookup table
> > b. Classifier
> > c. Cypher(er)?
lookup (*_lu, lu_*) or enum or just what it is (gender,
document_type, ...)
Kars
Ognjen Blagojevic wrote:
Hi,
How do you name a table which sole purpose is to store a list of
values? E.g.
Is this:
a. Lookup table
b. Classifier
c. Cypher(er)?
d. valueset?
regards,
Yeb Havinga
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
Hi all
Is it possible to modify a type cast which is a standard cast in
Postgres? I need to modify the ::TSQuery type cast, so it points to my
own function. I would preffer not to create additional custom user
cast.
Manual only mentions about creating and dropping custom user casts via
SQL comman
2010/4/8 Ognjen Blagojevic :
> Hi,
>
> How do you name a table which sole purpose is to store a list of values?
(...)
> Is this:
> a. Lookup table
> b. Classifier
> c. Cypher(er)?
>
> I'm looking for the appropriate term in English.
I'd call it a lookup-table.
Ian Barwick
--
Sent via pgsql-gen
Hi,
How do you name a table which sole purpose is to store a list of values?
E.g.
Table: sex
id name
---
1 male
2 female
Table: day
id name
---
1 Sunday
2 Monday
3 Tuesday
4 Wednesday
5 Thursday
6 Friday
7 Saturday
Is this:
a. Lookup table
b. Classifier
c. Cypher(er)?
I'm looking fo
donia zheni wrote:
> And if it's defined with "typedef", must all operations be defined also
> in C or can some functions be defined with plpgsql?
If you want a new data type that's only accessible using functions and
operators defined to operate on it, you must write it in C.
If you wanted to u
On Thu, Apr 8, 2010 at 1:52 PM, dipti shah wrote:
> techdb=> select * from techtable;
> ERROR: permission denied for relation techtable
> techdb=>
>
> ...and it gives permission denied..!
This should work:
SELECT description from techtable;
UPDATE techtable SET description = 'xyz'
This should n
Ohh...sorry. It works but I am wondering why pg_namespace doesn't display
any information.
techdb=> select description from techtable;
description
-
(0 rows)
techdb=> select number from techtable;
ERROR: permission denied for relation techtable
Thanks a ton.
On Thu, Apr 8, 2010 at
I also tried below:
techdb=# revoke all ON techtable from public;
REVOKE
techdb=# select pc.relname, pc.relacl from pg_class pc, pg_namespace pn
where pc.relnamespace=pn.oid and pn.nspname='techdb' and
pc.relname='techtable';
relname | relacl
---+-
On Thu, Apr 8, 2010 at 1:41 PM, dipti shah wrote:
> Okay. I think I got it but it is not working the way it should. I have given
> select permission on one column but still it is displaying both the columns.
> Could you please tell me what is wrong.
>
>
> techdb=# GRANT SELECT (description), UPDAT
Okay. I think I got it but it is not working the way it should. I have given
select permission on one column but still it is displaying both the columns.
Could you please tell me what is wrong.
techdb=# GRANT SELECT (description), UPDATE (description) ON techtable TO
user1;
GRANT
sysdb=> select *
Yup. I read it and tired couple of ways but couldn't figured out how to
specify column names. It gives me below error message and hence, I asked for
the example.
GRANT { { SELECT | INSERT | UPDATE | REFERENCES } ( *column* [, ...] )
[,...] | ALL [ PRIVILEGES ] ( *column* [, ...] ) }
ON [ T
On Apr 8, 2010, at 4:22 , dipti shah wrote:
> Hi, from postgesql features list mentioned at
> http://www.postgresql.org/about/press/features84.html, I came to know that
> it is possible to grant column level permissions.
> Could anyone please give me the example of how to grant column level
>
Dear all,
I have a question concerning "an extension of Postresql/PostGIS with a
spatio-temporal Abstract data type".
PostgreSQL have many types
categories : base types, composite types, domains, etc...
I would like to extend PostGIS type system with a new abstract
data type.
This means th
In response to Me Self :
> Hello Im just getting started using postgres and Ive run run into a
> problem with count(*):
>
> When I do "select count(*) from mytable" or "select count(*) from
> mytable where mycolumn=x" then I get wrong number. The number of rows
> returned is lower than the actual
Hello Im just getting started using postgres and Ive run run into a
problem with count(*):
When I do "select count(*) from mytable" or "select count(*) from
mytable where mycolumn=x" then I get wrong number. The number of rows
returned is lower than the actual number. How can that happen? The
tabl
Gordan Bobic wrote:
John R Pierce wrote:
all the enterprise SAN guys I've talked with say the Intel x25 drives
are consumer junk, about the only thing they will use is STEC Zeus,
and even then they mirror them.
A couple of points there.
1) Mirroring flash drives is a bit ill advised since f
Hi, from postgesql features list mentioned at
http://www.postgresql.org/about/press/features84.html, I came to know that
it is possible to grant column level permissions.
PostgreSQL is "the most secure by default" and part of that is making
security tools easy to use. 8.4 makes our existing connec
Hello,
SET default_tablespace is not really usefull for cases where data and
indexes should be splitted on different tablespaces.
Having an additional default_index_tablespace parameter would hence be
nice.
best regards,
Marc Mamin
49 matches
Mail list logo
