According to [the docs][1] it looks like `bigint` is your friend, with a range of -9223372036854775808 to 9223372036854775807.


  [1]: http://www.postgresql.org/docs/7.4/interactive/datatype.html#DATATYPE-INT

Should be a bigint


bigint	8 bytes	large-range integer	-9223372036854775808 to 9223372036854775807

From here: http://www.postgresql.org/docs/current/interactive/datatype-numeric.html


I have an array that I want to iterate over and delete some of the elements. This doesn&#39;t work:

    a = [1, 2, 3, 4, 5]
    a.each do |x|
      next if x &lt; 3
      a.delete x
      # do something with x
    end
    a #=&gt; [1, 2, 4]

I want `a` to be `[1, 2]`. How can I get around this?

How can I use Array#delete while iterating over the array?

when i give 
ls -l /etc/fonts/conf.d/70-yes-bitmaps.conf 

    lrwxrwxrwx &lt;snip&gt; /etc/fonts/conf.d/70-yes-bitmaps.conf -&gt; ../conf.avail/70-yes-bitmaps.conf

so for a symbolic link or soft link, how to find the target file&#39;s full(absolute path) in python,

If i use 

`os.readlink(&#39;/etc/fonts/conf.d/70-yes-bitmaps.conf&#39;)`

it outputs 

`../conf.avail/70-yes-bitmaps.conf`

but i need the absolute path not the relative path, so my desired output must be,

`/etc/fonts/conf.avail/70-yes-bitmaps.conf`

how to replace the `..` with the actual full path of the parent directory of the symbolic link or soft link file.


how to find the target file&#39;s full(absolute path) of the symbolic link or soft link in python

I want to know what&#39;s the equivalent of `Long` data type in PostgreSQL?

What is equivalent of Long data type in PostgreSQL?

<p>I want to know what's the equivalent of <code>Long</code> data type in PostgreSQL?</p>


Just come across with this problem:

    List&lt;DataNode&gt; a1 = new ArrayList&lt;DataNode&gt;();
    List&lt;Tree&gt; b1 = a1;  // compile error: incompatible type

Where the type DataNode is a subtype of Tree.

    public class DataNode implements Tree

To my surprise, this works for array:

    DataNode[] a2 = new DataNode[0];
    Tree[] b2 = a2;   // this is okay

This likes a bit strange. Can anyone give an explanation on this? 



Java Generics: Cannot cast List&lt;SubClass&gt; to List&lt;SuperClass&gt;?

I want to check that Java String or character array is not just made up of whitespaces, using Java?

This is a very similar question except it&#39;s Javascript: &lt;br&gt;
&lt;a href=&quot;https://stackoverflow.com/questions/2031085/check-if-string-contains-characters-whitespaces-not-only-whitespaces&quot;&gt;https://stackoverflow.com/questions/2031085/check-if-string-contains-characters-whitespaces-not-only-whitespaces&lt;/a&gt;

***EDIT***: I removed the bit about alphanumeric characters, so it makes more sense.

How do I check that a Java String is not all whitespaces?

In WebDriver, if I use sendKeys it will append my string to the value that already exists in the field.  I can&#39;t clear it by using clear() method because the second I do that, the webpage will throw an error saying that it has to be between 10 and 100.  So I can&#39;t clear it or an error will be thrown before I can put in the new value using sendKeys, and if I sendKeys it just appends it to the value already there.

Is there anything in WebDriver that lets you overwrite the value in the field?

Selenium WebDriver: I want to overwrite value in field instead of appending to it with sendKeys using Java

In a JSF backing bean (Managed Bean, Weld Bean, doesn&#39;t matter), I can get the context path the client is on by calling 

    FacesContext ctx = FacesContext.getCurrentInstance();
    String path = ctx.getExternalContext().getRequestContextPath();

This gives me the path the client currently accesses, like `/myapplication`.
Is it also possible to get the current *page*, like `/home.faces`, and how?

Get current page programmatically

I would like to create a junit test suite using JUnit 4 where the names of the test classes to be included are not known until the test suite is run.

In JUnit 3 I could do this:

    public final class MasterTester extends TestCase
    {
      /**
       * Used by junit to specify what TestCases to run.
       * 
       * @return a suite containing what TestCases to run
       */
      public static TestSuite suite() {
        TestSuite suite = new TestSuite();
        
        for(Class&lt;?&gt; klass : gatherTestClasses()) {
          suite.addTestSuite(klass);
        }
                           
        return suite;
      }
    }

and let the `gatherTestClasses()` method deal with figuring out what test classes to run.

In JUnit 4, the [documentation][1] says to use an annotation: `@SuiteClasses({TestClass1.class, TestClass2.class...})` to build up my test suite.  There are [numerous SO answers][2] showing how to do this.  Unfortunately the examples I see do not seem to allow for passing a dynamically generated list of TestClasses.

This [SO answer][3] suggested I would have to subclass `BlockJUnit4ClassRunner` which I do not want to do.

Dynamically specified test suites seem like something that must be in JUnit 4 somewhere.  Does anyone know where?


  [1]: http://kentbeck.github.com/junit/javadoc/latest/
  [2]: https://stackoverflow.com/questions/190224/junit-and-junit-framework-testsuite-no-runnable-methods/190347#190347
  [3]: https://stackoverflow.com/questions/1645154/how-do-i-define-a-testsuite-without-using-suiteclasses-in-junit-4-5

How do I Dynamically create a Test Suite in JUnit 4?

I&#39;ve got a PostgreSQL data base that I&#39;d like to configure to accept all incoming connections regardless of the source IP address. How can this be configured in the pg_hba.conf file? I&#39;m using postgreSQL version 8.4.

How to configure PostgreSQL to accept all incoming connections

Is there a tool or method to analyze Postgres, and determine what missing indexes should be created, and which unused indexes should be removed? I have a little experience doing this with the &quot;profiler&quot; tool for SQLServer, but I&#39;m not aware of a similar tool included with Postgres.

PostgreSQL Index Usage Analysis

How can I drop all tables in PostgreSQL, working from the command line?

I **don&#39;t** want to drop the database itself, just all tables and all the data in them.

How can I drop all the tables in a PostgreSQL database?

I am trying a simple `UPDATE table SET column1 = 0` on a table with about 3 million rows on Postegres 8.4 but it is taking forever to finish. It has been running for more than 10 min.

Before, I tried to run a VACUUM and ANALYZE commands on that table and I also tried to create some indexes (although I doubt this will make any difference in this case) but none seems to help.

Any other ideas?

**Update:**

This is the table structure:

    CREATE TABLE myTable
    (
      id bigserial NOT NULL,
      title text,
      description text,
      link text,
      &quot;type&quot; character varying(255),
      generalFreq real,
      generalWeight real,
      author_id bigint,
      status_id bigint,
      CONSTRAINT resources_pkey PRIMARY KEY (id),
      CONSTRAINT author_pkey FOREIGN KEY (author_id)
          REFERENCES users (id) MATCH SIMPLE
          ON UPDATE NO ACTION ON DELETE NO ACTION,
      CONSTRAINT c_unique_status_id UNIQUE (status_id)
    );

I am trying to run `UPDATE myTable SET generalFreq = 0;`

Slow simple update query on PostgreSQL database with 3 million rows

I have a table with two fields:

1. id(UUID) that is primary Key and
2. description (`var255`)

I want to insert random data with SQL sentence.
I would like that description would be something random.

PS: I am using PostgreSQL.

Content Type	Original Author	Original Content on Stackoverflow
Question	Mahmoud Saleh	View Question on Stackoverflow
Solution 1 - Java	Jon Skeet	View Answer on Stackoverflow
Solution 2 - Java	SQLMenace	View Answer on Stackoverflow

What is equivalent of Long data type in PostgreSQL?

Java Problem Overview

Java Solutions

Solution 1 - Java

Solution 2 - Java

how to find the target file's full(absolute path) of the symbolic link or soft link in python

How can I use Array#delete while iterating over the array?

Attributions