Sponsored Links

comp.databases.postgresql comp.databases.postgresql

Page 2 of 12

Last »

Threads in Forum : comp.databases.postgresql

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
Newbie Security Questions As a refugee from the big bad O, I am looking at Postgres. Four security questions (sorry if they have been asked and answered before): Can I remove... HoneyMonster	02-04-2011 11:34 AM Mladen Gogala	5	6
"Unattended" server Hi, I'm curious as to how much (and what type) "bit rot" is likely to creep into an "unattended" (un-managed?) server over the long run. And,... D Yuniskis	02-03-2011 04:54 AM D Yuniskis	2	3
Any experience using "shake" defragmenter? Did anyone try using "shake" while the cluster is active? Any problems with corruption or data loss? I ran the thing on my home directory and nothing... Mladen Gogala	01-30-2011 11:59 PM Mladen Gogala	0	1
"Table" type Hi, I need to include a column in a table that references another table. I.e., the type of the column would be "name of table". Furthermore, I... D Yuniskis	01-30-2011 04:04 AM D Yuniskis	4	5
Introducing Yellowfin Connect The phenomenal interest in social networking and Web 2.0 technologies at the enterprise level is both unprecedented and growing rapidly. But why? ... JTP PR	01-27-2011 05:59 AM JTP PR	0	1
Read problem from Bytea column Hello, I have postgresql 8.3.9 database. Now I am working on reading file from bytea data and save to filesystem. I am using Npgsql.dll on... orgilhp	01-23-2011 06:31 AM Jasen Betts	1	2
Is this safe? Hello, we are using postgres for a web application program. My colleague wrote some code that I suppose is not safe: basically we have a counter,... jmb@nospam.com	01-06-2011 10:19 AM Robert Klemme	3	4
pgstatindex and leaf fragmentation. There is a Postgres extension in the contrib directory, named pgstattuple, which collects valuable statistics for tables and indexes. One of the... Mladen Gogala	12-17-2010 12:29 PM Mladen Gogala	1	2
Permissions on trigger function Hello, I have postgres 8.3 server. Trying to deny a user ability to execute postgres function. Everything works fine with a regular function.... Boris	12-17-2010 08:01 AM Boris	2	3
Automizing crosstab queries Dear PostgreSQL experts, Is it possible to automize crosstab queries on a normalized database in PostgreSQL? A minimal example is a table with the... Julia Jacobson	12-17-2010 06:36 AM Thomas Kellerer	1	2
What does this mean? ( 1 2 3 ) I know PostgreSQL is installed and running as part of a TimeTrex install but when I try to access it: $ sudo psql psql: could not connect to server:... Mick	12-10-2010 07:57 AM HoneyMonster	21	22
blocking altertable Hello, My server is working in JDBC with read_commited connection. I launch PGAdminIII (or another client). When I want to do an "alter table add... Pif 34	12-10-2010 03:05 AM Pif 34	0	1
Help for grouping query Hello, I have a table with columns id and start_time: id \| start_time -----+--------------------- 96 \| 2010-11-24 09:30:00 97 \| 2010-11-24... jmb@nospam.com	11-29-2010 05:29 PM jmb@nospam.com	9	10
Full Text Search Signed/unsigned int and Delimiters Hi: I am setting up a full text search in postgresql and I expect some data to look like 8746-4756 or like 876.3456. This is what the ts vectors... Willy	11-20-2010 01:33 AM Willy	1	2
PgFouine It seems that neither PgFouine not pgsi are capable of analyzing log files produced by PostgreSQL 9.0. Did anyone have problems like that? Is there... Mladen Gogala	11-08-2010 04:51 PM Mladen Gogala	0	1
Yet another uniqueness problem Cheers, I'm setting up a db of tournament results. I don't want matches against self which I managed to solve, but I also don't want the same... Dorky Dork	11-08-2010 01:54 AM Marky Mark	8	9
Which is more performance-friendly: JOIN ON or JOIN USING? Friends at the PostgreSQL group: After a long search* I could not find an answer for the following question yet: Which is more... Pedro	11-06-2010 11:35 PM Jasen Betts	9	10
Bufer cache replacement LRU algorithm? Where can I find it documented? -- http://mgogala.byethost5.com Mladen Gogala	11-03-2010 11:34 AM Mladen Gogala	0	1
Array interface I wrote a little Perl script, intended to test the difference that array insert makes with PostgreSQL. Imagine my surprise when a single ... Mladen Gogala	11-03-2010 09:54 AM Mladen Gogala	0	1
interger column not empty Hi, suppose I have a table Match play score xx John 10 yy Smith zz Paul 5 The "score" column is a Integer... fireman	11-03-2010 08:09 AM Mladen Gogala	2	3
help me with a query Hi, Suppose I have a table like this: person, test_score, test_name "John", 100, "Math" "John", 50, ... fireman	10-24-2010 12:21 PM Mladen Gogala	4	5
debug psql procedure ? how debug procedure sql in postresql? Grzegorz	10-22-2010 03:48 AM Thomas Kellerer	1	2
Understanding injection attacks ( 1 2 ) I know that, from Java, the best method of protecting against SQL injection attacks is to use prepared statements. I'm looking at a situation in... Simon Brooke	10-14-2010 05:17 AM Mladen Gogala	16	17
Asynchronous I/O in Postgres Postgres 8.4 and 9.0 have the parameter named "effective_io_concurrency". The manual page is very short, it says the following: Sets the number of... Mladen Gogala	10-08-2010 01:38 PM Mladen Gogala	3	4
character(n) size Hi, In the postgres documentation we can read that space used by short string (<126 bytes) = 1 byte + size of the string. And longer string = 4 byte... bcar	10-02-2010 05:08 AM Jasen Betts	1	2
Some postgres statistics We're thinking about pg_stat_database which has two end columns blks_read , blks_hit which according to the docs below tell you which blocks have... Paul Branon	10-02-2010 04:42 AM Robert Klemme	4	5
PgAdmin3 1.10 doesn't work with PgSQL 9.0 The error message is here: ERROR column "datconfig" does not exist at character 76 The utility doesn't open any databases. Fortunately, 1.12 works... Mladen Gogala	10-01-2010 04:29 PM Mladen Gogala	0	1
Not quite yet.... Mladen Gogala wrote: With any common Linux distribution and derivatives like centos, you almost always want to use a prepared package for the... Mladen Gogala	09-28-2010 06:54 AM Mladen Gogala	4	5
Statistics with temporary tables, optimizer question I have a table with 45 million rows, partitioned on a date field. Each of the partitions has a primary key. There are 3 partitions so far, 15 million... Mladen Gogala	09-23-2010 09:29 AM Mladen Gogala	0	1
Migrate blob field from Postgres to Oracle Hello, I need to migrate a database from postgres to Oracle My Postgres box has this software version: - PostgreSQL 7.4.2 - O/S: Conectiva Linux... Big George	09-14-2010 12:12 AM Mladen Gogala	1	2
Transactional issue that begs for explanation I am having problems explaining the following course of events: I created table test_keys(key int,val varchar(10)); No PK, no indexes. I populated... Mladen Gogala	09-10-2010 04:58 AM Mladen Gogala	0	1
Write binary data from database to file using libpq Dear PostgreSQL users, I wrote a C++ program which should write binary data from a column of type 'BYTEA' to a file. It looks like this: #include... Julia Jacobson	09-04-2010 03:19 AM Julia Jacobson	0	1
Postgres for Android? Is there PostgreSQL version for Android based phones or for iPhone? That would be a really cool thing for doing presentations. Is it planned? Anybody... Mladen Gogala	09-03-2010 01:14 PM Mladen Gogala	3	4
Partitions and the optimizer ( 1 2 ) Il 02/09/2010 17.33, Mladen Gogala ha scritto: I agree with your point. My feeling in this case is that the way partitioning is implemented in PG... Mladen Gogala	09-02-2010 12:00 PM Anselmo Canfora	10	11
like, ilike, and indexes Hi there, is there a way to use indexes with (i)like clauses? Should I use the full text indexing... Anselmo Canfora	09-01-2010 05:18 AM Anselmo Canfora	2	3
Create view with substitution for values in one column ( 1 2 ) Dear PostgreSQL users, Presume you had a table of employees and the incentive payments they received additionally to their salaries. Now you would... Julia Jacobson	08-29-2010 12:51 PM Mladen Gogala	13	14
modify template1 (or maybe 0) help Hello, I have by error, modify database template (create tables when connect on the template database)), now when i create a database this... Didier	08-29-2010 07:13 AM Jasen Betts	2	3
Order by and indexes It looks like the Postgres optimizer cannot use indexes for "order by" conditions. The query that made me conclude this, looks like this: explain... Mladen Gogala	08-28-2010 03:56 AM Thomas Kellerer	1	2
Array interface Is there anything in Postgres that would allow me to insert a whole bunch of rows at once, with a single insert or do a prefetch? Here is... Mladen Gogala	08-26-2010 03:42 PM Mladen Gogala	2	3
Wildcard for date in SELECT from type TIMESTAMP Dear PostgreSQL users, How can I select all entries having a time of earlier than for example 11:00:00 from a column with data type TIMESTAMP, no... Julia Jacobson	08-23-2010 02:02 AM Andreas Kretschmer	3	4
PQcmdTuples and partitioned tables When using the partitioning scheme using triggers as suggested in the postgresql 8.4 documentation section 5.9.2, after inserting a record into the... Graham Murray	08-20-2010 09:24 PM Mladen Gogala	4	5
why so difficult to install postrgesql on debian ??? Hello, I try since fews day to install postresql for debian, but with apt-get (where to get ?) wath is the command for install posgresql + lib perl... Didier	08-19-2010 08:29 AM Jasen Betts	3	4
help initdb and user hello, With the account "mylogin" I do : initdb -D /home/mylogin/basedir all is ok :) but when i do : psql template1 , respond that user mylogin... Didier	08-16-2010 05:14 AM Didier	7	8
Difference with and without bind variables I was confused by the role of the bind variables for Postgres applications so I created 2 scripts, doing the same thing, with or without bind... Mladen Gogala	08-12-2010 11:38 AM Mladen Gogala	6	7
schemas How can I see all the schemas in a Postgres database? There is, of course, "select distinct schema from pg_tables" but what if the schema contains no... Mladen Gogala	08-06-2010 04:36 AM Anselmo Canfora	3	4
XML Functions Hi, I'm in the process of converting a LAMP AJAX website from MySQL to PostgreSQL. I'm having trouble finding resources regarding XML manipulation... Soral42	08-05-2010 12:32 AM Soral42	0	1
scheme and postgresql anyone using scheme and postgresql? nice combo? is memcached needed? quiet_lad	08-03-2010 07:32 AM Simon Brooke	2	164
postgres not runing Hi, Comming back from holidays, my local postgres server seems not running (ubuntu 10.4 postgress 8.4) Trying to get help on the web, i see... Vincent Pottier	07-31-2010 06:17 PM Mladen Gogala	3	4
Time travel I was playing with the generate_series function which, as everybody knows, can use dates, as of the version 8.4. What I didn't realize is that it can... Mladen Gogala	07-26-2010 02:31 PM Mladen Gogala	0	1
ORDER BY with UNION Having trouble with the following union query... SELECT table_catalog AS "databaseName", table_schema AS "schemaName", table_name AS "tableName", ''... gargoyle60	07-23-2010 04:23 AM gargoyle60	4	5

Page 2 of 12

Last »

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off