User Profile

Collapse

Profile Sidebar

Collapse
ahammond
ahammond
Last Activity: Jan 29 '07, 11:44 PM
Joined: Jan 29 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • ahammond
    replied to postgresql function
    in PostgreSQL
    Your question is incoherent. If you actually want to solve your problem, you might try posting the code, along with a description of what it's supposed to do, and what it's doing that's wrong....
    See more | Go to post

      Leave a comment:

    • ahammond
      replied to how can I fetch data from the database and display it in form of a editable html form
      in PostgreSQL
      What a vague question. You might want to look at Ruby on Rails to build a web front-end for your table. I hear it's quite easy to develop with....
      See more | Go to post

        Leave a comment:

      • ahammond
        replied to limit database size
        in PostgreSQL
        I can think of a number of ways to do this. The easiest is to us the tablespaces feature and stick each DB in it's own tablespace on a 10MB partition....
        See more | Go to post

          Leave a comment:

        • ahammond
          replied to Linking Tables from 2 databases
          in PostgreSQL
          This implements statement based replication, which is fraught with problems. What you're asking for is synchronous, multi-master replication. The brief answer is Oracle RAC. It'll cost you in the millions. The other brief answer is that you probably don't need it.

          If you describe the problem you're trying to solve, instead of the solution you think you've come up with, you're more likely to get a better answer....
          See more | Go to post

            Leave a comment:

          • ahammond
            replied to which is the best interface for postgresql
            in PostgreSQL
            If it's you personally that wants to interface with the database then I'd suggest either the command line interface that comes with postgres called psql. If you want something GUI than check out pgadmin3.

            As an aside, if you want to be taken seriously, you might want to take the time to write like you have an education that extends beyond the kindergarten of IRC...
            See more | Go to post

              Leave a comment:

            • ahammond
              replied to To insert 60million rows to database
              in PostgreSQL
              This assumes that you don't have concurrent queries trying to read from those tables. If you do, and they depend on the index you won't like the effect.



              This is incorrect. PostgreSQL does not dynamically maintain clustering. AFAIK there are no plans to support dynamically maintained clustering at any time in the near future.



              Nobody seems to have mentioned using prepared transactions yet....
              See more | Go to post

                Leave a comment:

              • ahammond
                replied to Postgresql Compression Across Network
                in PostgreSQL
                You can use an ssh tunnel to do this or some other VPN solution. I think it's also possible to do compression at the SSL layer, but you probably don't want the annoyance of using SSL....
                See more | Go to post

                  Leave a comment:

                No activity results to display
                Show More
                Working...