PostgreSQL

• PostgreSQL Questions

• • Windows Local Security Policy Rights?

    What are the exact specific Windows Local Security Policy RightsREAUIRED for the user created to run...

    By leonard_arah

  • "on insert" rules happen before the insert...

    The PostgreSQL documentation claims that "on insert" rules are executedafter the insert. This is not...

    By thomasreat

  • ERROR: cache lookup failed for type 0

    Tzahi Fadida <tzahi_ml@myrealbox.com> writes:> It still doesn't work. btw, I am using ...

    By tomlane

  • distance calculation usng lat and long in miles

    > I am calculating the distance as below> select distance(geom1, geom2)* 69.055>> It see...

    By brew_themode_com

  • Announcing postgresql-sdbc-0.7.2 driver for OpenOf...

    Hi,I'd like to announce the availability of the version 0.7.2 of the nativepostgresql driver fo...

    By joerg_budischewski

• • Detaching database

    Hi.Is any way how to detach complete database, and attach it into other Postgreserver (like MSSQL, I...

    By petr, 7 Comments

  • DNN Postgres Data Provider

    Our company is moving toward developing web applications in the DNN 3 (DotNet Nuke) framework. We cu...

    By randyhow, 1 Comments

  • xml output

    Hello Guys,I am trying to export the data out of the database directly to an xmlfile. Is there a way...

    By muralik_maddali, 2 Comments

  • Windows Version of PostgreSQL

    hi,Is there binary version of PostgreSQL available for Windows?Thanks,Mike__________________________...

    By mikehao, 2 Comments

  • Writing oracle/postgress generic SQL

    Anyone know of any guidelines for writing SQL which works under Oraclewitch will also work under pos...

    By benedwards, 9 Comments

• PostgreSQL: is the Category's subject.It's has 27,508 questions,this is No.1,376 pages.
• Wird behavour of foreign keys
• Hi listAs I'm new to this list please kick me in the right direction if this questionis better asked somewhere else.I'm seing some wird behavoure regarding foreign keys.My situation is this:I have 3 tables:pagesPK: page_idpage_grouppk: page_group_idfk: pages(page_id) ON DELETE CASCADE,...
• lundeman_tbkol_dk, Fri, 19 Mar 2010 00:31:00 GMT, 1,871 bytes, 1 Answer
• Year Only Date Column
• On Tue, 23 Nov 2004 22:28:08 +0900, "Michael Glaesemann"<grzm@myrealbox.com> said:> On Nov 23, 2004, at 10:16 PM, Jeff Flowers wrote:> > You could do that, or create a domain that would restrict the date to> only be, say, CCYY-01-01, which would represent the year.Since I will...
• jeffflowers, Thurs, 18 Mar 2010 22:14:00 GMT, 743 bytes
• Postgresql and Oracle data Type
• I would like to know, if it's correct?else, could you correct it?ANSI Data type |ORACLE |Postgresql====================================integer |NUMBER(10,0) |integerchar(n) |CHAR(n) |character(n)varchar(n) |VARCHAR2(n)...
• laurent_marquez, Thurs, 18 Mar 2010 21:32:00 GMT, 539 bytes, 1 Answer
• (NONE)
• Hello,I have a table with and id field (primary key) which default value is the result of a sequence (increment explicitly set to 1).To my surprise, the real increment on insert is the total number of rows of the table. For instance, with 41 rows and a sequence last_value of 1141, the next inser...
• jean_christophe_roux, Thurs, 18 Mar 2010 21:21:00 GMT, 645 bytes
• infinite recursion detected in rules for relation "..."
• examnotes <sebastianboeck@freenet.de> writes:> i have a problem migrating my application from version> 7.4 to 8.0. Everything is fine in 7.4 but with 8.0 i get> the following error:> infinite recursion detected in rules for relation "..."> I don't know wether its a bug...
• tomlane, Thurs, 18 Mar 2010 19:07:00 GMT, 538 bytes
• ERROR: missing cache data for cache id 27
• Tom Lane <tgl@sss.pgh.pa.us> writes:> Jorge Godoy <jgodoy@gmail.com> writes: > This was fixed in 8.1.5 ... or at least the only known cause was fixed.Thanks! I'll bug OpenSuSE guys to release an 8.1.5 package ;-)Jorge Godoy <jgodoy@gmail.com>--(end of broadcast)--TIP...
• jorgegodoy, Thurs, 18 Mar 2010 17:07:00 GMT, 411 bytes
• Win installed pgsql 8.0 beta2 dev3
• Not sure if this is a win installer issue or Microsoft MDAC issue...I've installed the win32 pg8.0 beta2 dev3 along with the accompanying ODBCthat is packaged with the installer. Works great, love it, and all therest. My application uses ADO 2.7 to interface with the ODBC driver.My applicat...
• a_mous, Thurs, 18 Mar 2010 13:50:00 GMT, 1,244 bytes, 1 Answer
• Cache loolup failed problems with tsearch following
• Mike,I think the problem is that tsearch2 is referenced by your SP (stored procedure)and your SP should be recreated *after* tsearch2 installed because functionsare referenced by OID and your SP try to lookup tsearch2 functionsusing old OID.OlegOn Tue, 23 Mar 2004, Mike Bell wrote:> Hi,> I...
• oleg_bartunov, Thurs, 18 Mar 2010 13:45:00 GMT, 3,740 bytes, 1 Answer
• do I need replication or something else?
• We have a billing system and we want the ability to send users out intothe field with an unconnected (no WAN, VPN etc) laptop containing our pgdb and software. Upon their return we need to synchronize changes to themain db. We would like the ability to be able to have this accomplishedat the db...
• caleb_simonyi_gindele, Thurs, 18 Mar 2010 13:23:00 GMT, 419 bytes, 9 Answer
• XML & Postgres Functions
• Hi all-I'm migrating to postgres from the MS SQL Server land, as I can seea great potential with postgres, I was wondering if anyone hasexperimented or started a project with XML inside user definedfunctions?I've seen the contrib/xml shipped with the distro, as I see it'susefulnes...
• zerobearing2, Thurs, 18 Mar 2010 10:44:00 GMT, 3,252 bytes, 1 Answer
• Query performance question on a large table
• Hi All,how can I improve the query performance in the following situation:I have a big (4.5+ million rows) table. One query takes approx. 9 sec tofinish resulting ~10000 rows. But if I run simultaneously 4 similar queriesit takes nearly 5 minutes instead of 4 times 9 seconds or something near of...
• egydcsaba, Thurs, 18 Mar 2010 06:19:00 GMT, 1,173 bytes, 8 Answer
• Writing DDLs in Functions
• Hii AllI need to write DDL statements in function, as we used to do in Oracle with EXECUTE IMMEDIATE command. Is there any way we can do this.RegardsSarabjeet...
• sarabjeethanspal, Thurs, 18 Mar 2010 06:19:00 GMT, 174 bytes, 1 Answer
• How to retrieve the comment for a constraint?
• Hallo all,using at least PostgreSQL 7.4.2, one can use the commandCOMMENT ON CONSTRAINT <constraint_name> ON <table_name>;to document a constraint defined viaCONSTRAINT <constraint_name> ...in the context of a table.Now, imagine you know the name of a constraint or all of them...
• wolfgang_drotschmann, Thurs, 18 Mar 2010 06:09:00 GMT, 1,434 bytes, 1 Answer
• About Tools at the DB design phase.
• Greetings,I am at the design phase of the DB design. That is, I'd like to designtables and relationships between them, but not the real implement oftables. Could somebody suggest some good and free tools to help/easedesign the structures please?Thanks a lot!Emi--(end of broadcast)--TIP 4: H...
• yinglu, Thurs, 18 Mar 2010 06:08:00 GMT, 488 bytes, 4 Answer
• windows ODBC driver issues
• Hi list;We've installed the windows version of the postgres odbc driver. However when we attempt to create a link table in sql server via this driver it cannot connect.Any thoughts on how to debug or resolve this?Thanks--(end of broadcast)--TIP 3: Have you checked our extensive FAQ?http://w...
• mr_dba, Thurs, 18 Mar 2010 06:08:00 GMT, 452 bytes, 1 Answer
• "oracle to postgresql" conversion
• I'm a newbie in Oracle and postgreSQL,i'm need to translate the following script (in Oracle) to PostgreSQL :rem Autorisation des lignes vides :set sqlbl onrem Initialisation du timer :set timing onrem Creation de la table :CREATE TABLE "LEPAPE"."EXPERIENCE"("EXP_ID" VARCHAR2(16) NOT NU...
• altudela_gmail_com, Thurs, 18 Mar 2010 06:07:00 GMT, 775 bytes, 8 Answer
• Does a 'stable' deferred trigger execution order exist? Is housekeeping for deferred t
• Hi,If during a transaction a number of deferred triggers are fired, what will betheir execution order upon the commit?Will they be executed in order of firing or alfabetically or somethingentirely different? The docs only mention regular triggers being executedalfabetically.And equally important...
• frankvan_vugt, Wed, 17 Mar 2010 19:32:00 GMT, 860 bytes
• "select ..... for update of ..." doesn't support full qualified table name?
• CREATE SCHEMA one;CREATE TABLE one.aa ( a INT );CREATE SCHEMA two;CREATE TABLE two.bb ( b INT );SELECT * FROM one.aa, two.bb WHERE one.aa.a = two.bb.b FOR UPDATE OF one.aa;ERROR: syntax error at or near "." at character 73 (points to thelast instance of "one.aa" in SQL query)p.s. in our applicat...
• vlad, Wed, 17 Mar 2010 19:26:00 GMT, 851 bytes, 4 Answer
• Draw a rectanlge around a text
• I need to print a Order in which I have to draw a rectangle around theCustomer address.how can I acheive this.I already try with the following codes but it works in screen bufferbut in the printed report I cannt able to put the rectangle..DEFINE RECTANGLE RECT-2EDGE-PIXELS 1 GRAPHIC-EDGE NO-FILL...
• shiva, Wed, 17 Mar 2010 17:42:00 GMT, 392 bytes
• "libpq.lib"
• Good day!I have found library "libpq.lib" for visual c++ (package PostgreSQL8), but for borland builder give me error for using this library.Where I can find "libpq.lib" for borland builder (win2000)?thanks.--(end of broadcast)--TIP 3: Have you checked our extensive FAQ?http://www.postgresql.org...
• vlad, Wed, 17 Mar 2010 17:37:00 GMT, 431 bytes, 1 Answer
• «««13661367136813691370137113721373137413751376