 |
COMPGROUPS.NET |
 Search |
 Post Question |
 Groups |
 Stream |
 About |
 Register
|
Stats Updating... 5/25/2013 11:59:27 PM Top Users in comp.databases.postgresql  gavcomedy (1610) 558 Articles, 1052 Replies, 1610 Points
 kwutzke (87) 66 Articles, 21 Replies, 87 Points
 sfeher (10) 10 Articles, 0 Replies, 10 Points
 gjdwebshop (5) 4 Articles, 1 Replies, 5 Points
 ivan_521521 (9) 7 Articles, 2 Replies, 9 Points
 jaroslav.zaruba (1) 1 Articles, 0 Replies, 1 Points
 v.campanella (1) 1 Articles, 0 Replies, 1 Points
 marcu.nicolae (2) 2 Articles, 0 Replies, 2 Points
 abc28 (1) 1 Articles, 0 Replies, 1 Points
 petshmidt (50) 13 Articles, 37 Replies, 50 Points
Top Articles in comp.databases.postgresql  to_char issue  6
 382 (2/3/2010 4:25:19 PM) Hi, is this a bug or am I misunderstanding something? db_atm=# select length(to_char(552020, '000000000')); length -------- 10 (1 row) in my opinion it should give 9... I am getting ugly error...   Anselmo Permission, select currval(seq) 6
636 (1/1/2010 12:19:42 AM) After an insert statement, I need a the members of a user group to get the recently inserted statement's primary key that was created from a sequence, with the currval() function. For example: select cu... ivan_521521 (9) default postgres user password on CentOS? 1
3253 (11/6/2009 5:37:48 PM) Hello, I'm new to postgresql and have installed it on CentOS 5.3 via yum. I am attempting to install an application that uses postgresql as its database, and am running application-supplied scripts to create ... Greg Listing multiple joins on one row 8
454 (12/22/2009 6:55:31 PM) This is not a Postgres specific question. Given two simple tables tracking the marriages between people: >> create table person ( >> person_id serial not null, primary key (person_id), >... ivan_521521 (9) How to disable trigger within itself? (to prevent recursion/loop) 2
427 (11/11/2009 9:39:56 AM) Hello I have this trigger which ON INSERT inserts more rows into the very same table it "sits" on. To avoid an INSERT-recursion I would like to disable all triggers on that table from within my trigger-fun... ISO PostGreSql to Oracle 8
597 (10/16/2009 2:17:48 PM) I am an Oracle and MS SQL DBA and application developer so I'm very familiar with those two RDBMSs. But recently I've been tasked to look at coming up with a means of moving data from a PostGreSQL database to... Saaran disable trigger temporary 3
577 (11/15/2009 10:44:27 PM) Hello, i had written a stored procedure that works as trigger for upate and delete statements. The trigger raises an error if there is a not allowd change on the row, that's the normal way. But now I h... Philipp Blob with OIDs and trigger 10
385 (11/18/2009 2:01:37 PM) Hi, I have create a table with this structur CREATE TABLE import ( id1 integer NOT NULL, id2 integer NOT NULL, dataset oid NOT NULL, CONSTRAINT import_pk PRIMARY KEY (id1, id2), CONSTRAINT... Philipp Lucene & Postgres? 9
567 (2/10/2010 10:51:12 PM) Does anybody here has any experience with that? Any remarks, praises or words of caution? Postgres search engine seems to be unable to cope with phrases and since that is an absolute must, I must look elsew... Mladen Direct I/O 29
184 (1/26/2010 9:55:54 PM) Can I somehow force PogSQL to do direct I/O on Ext3 file system? All those FS buffers are messing up free memory and swap partitions. -- http://mgogala.byethost5.com ... MladenStatistics Last Updated: 5/4/2013 12:00:00 AM |
0 followers. 