[ADMIN] data corruption

Hi, I have a query that runs fine for one set of data and not for another. In the following query, all the columns used in a where clause are indexed. If i use this for the origindbs('02','05','06','07') except '04', it works fine. when i look for the data from origindb "04" it just run for 2 hou

[ADMIN] connect to postgres from shell scripts

Hi, I would like to know how to connect to postgres from shell scripts using a password protected user. Is there a way to embed the password in psql login. It keeps prompting for the passwords. Any hint is appreciated. Thanks Priya

Re: [ADMIN] Help converting constraint triggers

pgAdmin III v1.2.0.. --- Chris Hoover <[EMAIL PROTECTED]> wrote: > What version of pgadmin are you using? I looked in > pgadmin3 and it > does not show the constraint triggers. > > On 8/3/05, Hemapriya <[EMAIL PROTECTED]> wrote: > > > > pgadmin will l

[ADMIN] Grant ALL on schema

Hi, Can anybody know how the following statement work. Grant ALL on SCHEMA test to user 'user1'; will the user be able to have all the privileges on all the objects/tables on schema test? Or he can only create new objects in that schema. Thanks Priya

[ADMIN] pg_shadow passwd decrypt

Hi, Does postgres support any system functions that decode/decrypt the user passwords stored in pg_shadow system catalog. Is there a way to retrieve the passwords, if forgotten. Thanks in Advance. Priya __ Celebrate Yahoo!'s 10th

[ADMIN] vacuum analyze takes long time

Hi, I have updated 10M rows in a table. i ran the vacuum analyze. it has been running more than a day. I'm not sure whether it would take so long? total volume in the table - 16M rows Can anyone please confirm... thanks Priya __ Do you

[ADMIN] View Different Schemas

Hi, Can anyone tell me how to view the different schemas in a database. I have created a schema and some tables in it. Also I have altered the search_path to add the new schema.. but still /dt doesn't give me the new schema and its tables. Any help? Thanks Priya _

[ADMIN] Connect to postgres from a script using password

Hi, Can anyone tell me how to connect to postgres from a shell script using password. If i use psql -UUser db -W option it prompts for password everytime.. Is there anyway we can have the password included in psql login command.? Thanks Priya __

[ADMIN] Database, Table Names are resulting in lowercase

Hi All, We have postgresql running in mac. I found whatever db objects i create from the sql prompt results in lowercase. Can anyone tell me why it is happening.? does postgres stores the db objects in lowercase internally.. If i create something from the shell prompt it remains in the same case

[ADMIN] Querying Across Databases..

Hi, Does anyone know how to write queries to tables in other database intances in postgres? For examlpe if I have two DB instances set up, called "test1" and "test2" I may want to run an SQL in "test1" that selects data from a table in "test2". It is unclear whether it is supported or not. Thank

[ADMIN] Set Timestamp

Hi, Does anyone know how to set timestamp values in postgres. Thanks in Advance. - Priya __ Do you Yahoo!? SBC Yahoo! - Internet access at a great low price. http://promo.yahoo.com/sbc/ ---(end of broadcast)

[ADMIN] Query with Max, Order by is very slow.......

Hi, we have table having 23 million rows. This is the table structure. Table Request: Column |Type | Modifiers ---+-+--- origindb | character(1)| not null uid | integer | not null

[ADMIN] Best Platform for postgres.

Hi, Does anyone know postgres performance in Linux vs Mac Os.. Pls suggest the best platform to go for.. Thanks in Advance. Priya __ Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway http://promotions.yahoo.com/design_giveaway/ --

[ADMIN] postgres copy command very slow.

Hi, We have postgresql 7.4.1 running on Mac OS.we are doing a conversion from mysql to postgres. I'm importing the table dumps using copy command in postgres. Copy takes 2 min to import 427938 rows in one table and at the same time it takes more than 2 hrs for 2415768 rows.. no of columns are simi

[ADMIN] Torn pages Detection in SQL SERVER

Hi, Any one know how to detect torn pages/ torn bits from memory dump of DBCC PAGE command in SQL Server?? Any help or hint is highly appreciated. Thanks priya __ Do you Yahoo!? Yahoo! Finance Tax Center - File online. File on time. http://taxes.yahoo.com/filing.

[ADMIN] process list

How can i view the list of processes running in postgresql.. is there any command for that?? Any help is appreciated. Thanks Priya __ Do you Yahoo!? Yahoo! Finance Tax Center - File online. File on time. http://taxes.yahoo.com/filing.html