[SQL] how to vacum
Tried to issue the command "vacum full" both from psql and the sql box in pgadmin without success. How do you use the command? select vacum full; also does not work Lost in the woods please help Richard
Re: [SQL] MINUS & ROWNUM in PostGres
> Anyway, you'll need to write your own replace() if you stick with that > release. > You can use this replace function, if you stick with that release. regards, bhuvaneswaran create or replace function replace (varchar, varchar, varchar) returns varchar as ' declare string alias for $1; findalias for $2; replacement alias for $3; match integer; end_before integer; start_after integer; string_replaced varchar; string_remainder varchar; begin string_remainder := string; string_replaced := ; match:= position(find in string_remainder); while (match > 0) loop end_before := match - 1; start_after := match + length(find); string_replaced := string_replaced || substr(string_remainder, 1, end_before) || replacement; string_remainder := substr(string_remainder, start_after); match := position(find in string_remainder); raise notice ''replaced %, remainder %'', string_replaced, string_remainder; end loop; string_replaced := string_replaced || string_remainder; return string_replaced; end; ' LANGUAGE 'plpgsql'; -- [EMAIL PROTECTED] ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [SQL] [JDBC] contrib/ltree
I would recommend using getString()/setString(). You will need to marshall the data into the correct format, but you will at least be able to get and set the values. --Barry [EMAIL PROTECTED] wrote: how do i get jdbc to recognize the ltree type that comes with the contrib/ltree extension? This: Object object = resultSet.getObject(columnNumber); generates the following exception: Exception caused by: No class found for ltree at org.postgresql.jdbc1.AbstractJdbc1Connection.getObject(AbstractJdbc1Connecti on.java:693) at org.postgresql.jdbc2.AbstractJdbc2Connection.getObject(AbstractJdbc2Connecti on.java:117) at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getObject(AbstractJdbc2ResultSet .java:147) ... Regards, Floyd Shackelford 4 Peaks Technology Group, Inc. VOICE: 334.735.9428 FAX: 702.995.6462 EMAIL: [EMAIL PROTECTED] ICQ #: 161371538 PGP Key ID: 0x2E84F2F2 PGP Fone available on request at private.fwshackelford.com Shackelford Motto: ACTA NON VERBA - Actions, not words Alabama State Motto: AUDEMUS JURA NOSTRA DEFENDERE - We Dare Defend Our Rights The Philosophy of Liberty: http://www.isil.org/resources/introduction.swf "We have allowed our constitutional republic to deteriorate into a virtually unchecked direct democracy. Today's political process is nothing more than a street fight between various groups seeking to vote themselves other people's money. Individual voters tend to support the candidate that promises them the most federal loot in whatever form, rather than the candidate who will uphold the rule of law." --Rep. Ron Paul ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [SQL] how to vacum
On Wed, Sep 10, 2003 at 20:43:25 +0800, Richard Sydney-Smith <[EMAIL PROTECTED]> wrote: > Tried to issue the command "vacum full" both from psql and the sql box in pgadmin > without success. > > How do you use the command? > > select vacum full; > > also does not work Try using: vacuum full (Note that vacuum has 2 u's.) ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [SQL] how to vacum
On Wed, 10 Sep 2003 20:43:25 +0800 "Richard Sydney-Smith" <[EMAIL PROTECTED]> wrote: > Tried to issue the command "vacum full" both from psql and the sql box in pgadmin > without success. seems like you also vacuumed the second 'U' out of the word :) vacuum full; does the trick. cya erik -- Erik Thiele ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [SQL] how to vacum
Richard Sydney-Smith writes: > Tried to issue the command "vacum full" both from psql and the sql box in pgadmin > without success. vacuum full; ^^ -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [SQL] how to vacum
El Mié 10 Sep 2003 10:07, Bruno Wolff III escribió: > On Wed, Sep 10, 2003 at 20:43:25 +0800, > > Richard Sydney-Smith <[EMAIL PROTECTED]> wrote: > > Tried to issue the command "vacum full" both from psql and the sql box in > > pgadmin without success. > > > > How do you use the command? > > > > select vacum full; > > > > also does not work > > Try using: > vacuum full > (Note that vacuum has 2 u's.) When entering "vacum" to Dict, it catches nothing, but one of it's suggestions is vacuum, which means "clean". -- 17:38:01 up 19 days, 9:28, 3 users, load average: 1.59, 1.39, 0.91 - Martín Marqués |[EMAIL PROTECTED] Programador, Administrador, DBA | Centro de Telematica Universidad Nacional del Litoral - ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
