This is what I'm trying to:
char lmt_str[100];
sprintf(lmt_str,"%s",PQgetvalue(res, 0, nFields-1));
//the last field is of type timestamp
This is giving segmentation fault.
I'm confused
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscripti
On Wed, 2008-03-12 at 21:40 -0700, Scott Marlowe wrote:
> On Wed, Mar 12, 2008 at 8:45 PM, Ow Mun Heng <[EMAIL PROTECTED]> wrote:
> > On Wed, 2008-03-12 at 21:33 -0500, Adam Rich wrote:
> > > select c.relname, a.attname, attstattarget
> > > from pg_catalog.pg_attribute a, pg_catalog.pg_class c,
"Blair Bethwaite" <[EMAIL PROTECTED]> writes:
> Why would we be getting a duplicate key violation on the primary key
> of this table when we aren't doing anything in the UPDATE (that I can
> tell) to change it?
Corrupted index, perhaps? Can you REINDEX that table?
There are at least two known bu
Hi all,
I have recently turned up the postgresql logging facilities on a
rather database intensive application in the hope of finding bugs and
tuning queries. We're using 8.0.8, though thinking of moving to 8.3 as
the new HOT functionality looks like it would be useful for us given
the high UPDATE
On Wed, 12 Mar 2008 21:30:57 -0700
"Scott Marlowe" <[EMAIL PROTECTED]> wrote:
> You might want to keep this one on the list. I'm out of my league
> with this one I think
Can you pg_dump the database? What about vacuum? What does:
SELECT * FROM pg_database; Return?
J
>
> On Wed, Mar 12, 2008
On Wed, Mar 12, 2008 at 8:45 PM, Ow Mun Heng <[EMAIL PROTECTED]> wrote:
> On Wed, 2008-03-12 at 21:33 -0500, Adam Rich wrote:
> > select c.relname, a.attname, attstattarget
> > from pg_catalog.pg_attribute a, pg_catalog.pg_class c,
> > pg_catalog.pg_namespace n
> > where a.attrelid = c.oid and
On Wed, Mar 12, 2008 at 4:48 AM, Ivan Sergio Borgonovo
<[EMAIL PROTECTED]> wrote:
> one of the inner join doesn't have an on relationship.
>
> As you could see in the other (longer) query I'm just trying to put in
> the same row what would be
Could you get what you want by cross joining the fi
You might want to keep this one on the list. I'm out of my league
with this one I think
On Wed, Mar 12, 2008 at 11:24 AM, Gauthier, Dave
<[EMAIL PROTECTED]> wrote:
> stdb2=# select '|'||datname||'|' from pg_database ;
> ?column?
>
> |postgres|
> |template1|
> |templat
Scott Marlowe wrote:
On Wed, Mar 12, 2008 at 1:02 PM, paul rivers <[EMAIL PROTECTED]> wrote:
- Auto_increment columns as pkeys in InnoDB tables are practically
required, yet severely limited scalability due to how a transaction
would lock the structure to get the next auto-increment (sign
On Wed, 2008-03-12 at 21:33 -0500, Adam Rich wrote:
> select c.relname, a.attname, attstattarget
> from pg_catalog.pg_attribute a, pg_catalog.pg_class c,
> pg_catalog.pg_namespace n
> where a.attrelid = c.oid and c.relnamespace=n.oid
> and n.nspname = 'public' and a.attnum > 0
Funny, that does not
On Wed, Mar 12, 2008 at 1:02 PM, paul rivers <[EMAIL PROTECTED]> wrote:
> - Auto_increment columns as pkeys in InnoDB tables are practically
> required, yet severely limited scalability due to how a transaction
> would lock the structure to get the next auto-increment (significantly
> improved
> Is there a query to pg_catalog tables to find out which table/column
> has
> the stat level not at default in 1 sweep?
Try this:
select c.relname, a.attname, attstattarget
from pg_catalog.pg_attribute a, pg_catalog.pg_class c,
pg_catalog.pg_namespace n
where a.attrelid = c.oid and c.relnamespac
josep porres wrote:
but the most important is how can I reference the fields inside de loop
By "the fields" I assume you mean the fields with names that end in a
number from 1 to 5, and you want to access those fields in a loop as if
you were indexing an array?
I think you might want to ex
Hi,
I finally figure out how come (i think) my analyszing of some specific
tables is taking so freaking long. 12million rows, ~11GB table.
I had some of the columns with the stat level set up to 1000. (this was
previously because I was trying to optimise somethings to make things
faster. ) When t
Alban Hertroys wrote:
On Mar 11, 2008, at 10:28 PM, Tom Lane wrote:
An ON CONNECT trigger enforced by the database seems a bit scary to me.
If it's broken, how you gonna get into the DB to fix it?
regards, tom lane
If creating the trigger wouldn't be possible from within the data
On Mar 11, 2008, at 10:28 PM, Tom Lane wrote:
An ON CONNECT trigger enforced by the database seems a bit scary to
me.
If it's broken, how you gonna get into the DB to fix it?
regards, tom lane
If creating the trigger wouldn't be possible from within the database
th
Hi Devrim,
When I tried to install, I got this error.
[EMAIL PROTECTED] pq8.2.6]# rpmbuild --rebuild --define 'buildrhel3 1'
postgresql-8.2.6-1PGDG.f8.src.rpm
-bash: rpmbuild: command not found
Do you know where can I download rpmbuild for RHEL 3?
Thank you for your help,
Tri
-Original Me
Well, if you have a crappy system that cannot sustain concurrent load or
even be backed up concurrently with regular operation, one solution is
to write a kick-ass replication system.
Still, it would be nice to have a kick-ass replication system for PG,
too. We've been toying with WAL archi
Hi everyone,
I'm trying to port some vb6 code to pgplsql (PostgreSQL 8.3 winxp)
that code is
Const f2_MAX_TRAMS = 5
Dim f2_rTarifaA as new ADODB.Recordset
Dim Mpa(f2_MAX_TRAMS) As Double ' preu aigua
Dim Ma(f2_MAX_TRAMS) As Long' m3 aigua tarifa
Dim i As Integer, j As
Hi Everyone,
I am wanting to ask some opinions on implementing PL/R into V8.3 on
Win32. I have a need to be able to perform some relatively demanding
statistical functions as the basis of producing data for reports.
In short R appears to have more than enough capability to do the job
(from a stat
In my snowball_create.sql I find:
-- No language-specific snowball dictionaries, for lack of shared
library support
This build comes from postgresqlformac.com the "Unified Installer -
8.3.0 (PostgreSQLforMac)"
Now I am considering that it might have been better to compile my own,
but be
There is other things in that directory including dict_snowball.so
ascii_and_mic.so latin2_and_win1250.so utf8_and_big5.so
utf8_and_gbk.so
cyrillic_and_mic.so latin_and_mic.so utf8_and_cyrillic.so
utf8_and_iso8859.so
dict_snowball.sopgxs
There is a file here with the same name:
/Library/PostgreSQL8/lib/postgresql/plpgsql.so
So I could try and run that snowball_create.sql script from src (which
I have downloaded) and try and get the required functionality? That
would be the easiest for now.
On the production system I will
Hi everyone,
I'm trying to port some vb6 code to pgplsql (PostgreSQL 8.3 winxp)
that code is
Const f2_MAX_TRAMS = 5
Dim f2_rTarifaA as new ADODB.Recordset
Dim Mpa(f2_MAX_TRAMS) As Double ' preu aigua
Dim Ma(f2_MAX_TRAMS) As Long' m3 aigua tarifa
Dim i As Integer, j As
On Mar 12, 8:11 am, [EMAIL PROTECTED] (Alvaro Herrera) wrote:
> Please always ensure that the list is copied on replies (use "Reply to
> all") so that other people can help you.
>
> sam escribió:
>
> > On Mar 11, 5:39 pm, [EMAIL PROTECTED] (Alvaro Herrera) wrote:
> > > sam escribió:
>
> > > > Iam n
Is it possible to change the Service Account password for Service
Account name postgres
and if so how?
Windows XP Home SP2
PostgreSQL v8.3.0
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-gener
Consider the following case which is almost exact snapshot of part of our
scheme:
Table "cities"
Column| Type | Modifiers | Description
--++---+-
ficity_id| integer| not nu
Alex Vinogradovs <[EMAIL PROTECTED]> writes:
> I've created 2 sample tables with 1 column each - type
> char(1) and type integer. After inserting equal number
> of rows (4M or more) tablesizes are exactly the same, while
> I would expect table with char(1) to be slighly smaller...
> What's causing
On Wed, 2008-03-12 at 14:22 -0400, Lee Hachadoorian wrote:
> It was far stupider than that. I had been playing around with a
> couple of different data clusters before doing a complete reinstall of
> PostgreSQL. I just realized I was trying to start a cluster that I
> was no longer using and the
On Wed, Mar 12, 2008 at 11:46:12AM -0400, James B. Byrne wrote:
> CREATE UNIQUE INDEX idxUF_table_column ON table
> (lower(trim(both ' ' from(regexp_replace(, /( ){2,}/g," " )
> What I intend this to do is to squeeze out excess whitespace, strip off
> leading and trailing blanks, and then for
Add psql TODO:
o Include the symbolic SQLSTATE name in verbose error reports
http://archives.postgresql.org/pgsql-general/2007-09/msg00438.php
---
Alvaro Herrera wrote:
> Tom Lane wrote:
> > Benjamin Ara
Guys,
I've created 2 sample tables with 1 column each - type
char(1) and type integer. After inserting equal number
of rows (4M or more) tablesizes are exactly the same, while
I would expect table with char(1) to be slighly smaller...
What's causing it ? Thanks!
Server version is 8.3.
Best rega
On Mar 12, 2008, at 3:19 PM, Tom Lane wrote:
- restore dump, ignoring "object already exists" errors
Couldn't one use the dump listing feature of pg_restore and comment
out the extensions when restoring? Not likely to be a big improvement
over "ignore" errors :-)
--
Sent via pgsql-gen
Alvaro Herrera wrote:
Ivan Sergio Borgonovo wrote:
On Wed, 12 Mar 2008 09:13:14 -0700
paul rivers <[EMAIL PROTECTED]> wrote:
For a database of InnoDB tables, people tend to replicate the
database, and then backup the slave (unless the db is trivially
That recalled me the *unsup
Hello
I am translating tips from czech language, that I would copy to wiki.
Please, I invite any help with language fix - my translation is really
basic.
current work is on: http://www.pgsql.cz/index.php/PostgreSQL_SQL_Tricks
Thank you
Pavel Stehule
On 12/03/2008, Dave Page <[EMAIL PROTECTED]>
On Wed, Mar 12, 2008 at 07:34:03PM -, Greg Sabino Mullane wrote:
> > - dump version N database
> > - create empty version N+1 database
> > - install N+1's version of each needed contrib module into new database
> > - restore dump, ignoring "object already exists" errors
> >
> > There is a TODO
Greg Sabino Mullane wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
- dump version N database
- create empty version N+1 database
- install N+1's version of each needed contrib module into new database
- restore dump, ignoring "object already exists" errors
There is a TODO to fig
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> - dump version N database
> - create empty version N+1 database
> - install N+1's version of each needed contrib module into new database
> - restore dump, ignoring "object already exists" errors
>
> There is a TODO to figure out some cleaner
"Angus B. Atkins-Trimnell" <[EMAIL PROTECTED]> writes:
> I am having trouble with a function designed to return all column
> constraints on a table.
I think the problem is that you're declaring the contype return column
as char (ie, character(1)) when pg_constraint.contype is actually "char"
(a h
Glyn Astill <[EMAIL PROTECTED]> writes:
> --- Bruce Momjian <[EMAIL PROTECTED]> wrote:
>> MySQL has incentives to _not_ make their community release
>> production-quality.
> I mean features being pulled into the enterprise release that haven't
> had much time to be tested even in the community rel
On Tue, Mar 11, 2008 at 4:51 PM, Andrej Ricnik-Bay <[EMAIL PROTECTED]>
wrote:
> On 12/03/2008, Kynn Jones <[EMAIL PROTECTED]> wrote:
> Of course I may not have quite
> understood how that "this procedure adds useful definitions,
> mostly subs, to Perl's main package. This needs to be done
> for
paul rivers <[EMAIL PROTECTED]> writes:
> Is this something that wouldn't be fixed by:
> - dump 8.2 database
> - load dump into 8.3 database
> - for each extension, run the 8.2 drop extension script in 8.2's contrib
> - for each extension, run the 8.3 install extension script in 8.3's contrib
The
At 09:47 PM 3/11/2008, rrahul wrote:
Hi,
I am a database professional but have never used Postgre. My client was
exploring the posiblity of using Postgre instead of Mysql and wnated to know
the comments from the community.
I waned you people you post your views on the following comparision poin
--- Bruce Momjian <[EMAIL PROTECTED]> wrote:
> Glyn Astill wrote:
> >
> > --- Greg Smith <[EMAIL PROTECTED]> wrote:
> >
> > > If you look at the link I passed along before, you'll see the
> > > difference
> > > with MySQL is that they've been abusing their customers with
> minor
> > > point
>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 12 Mar 2008 14:35:19 -0400 (EDT)
Bruce Momjian <[EMAIL PROTECTED]> wrote:
> > This is something I noticed too when looking at MySQL and postgres.
> > The frequency of bug fixes and features, some coming over pretty
> > quickly from the commun
Tim Child <[EMAIL PROTECTED]> writes:
> There is other things in that directory including dict_snowball.so
Well, that's even stranger. It's real hard to see how the
src/backend/snowball Makefile would have built dict_snowball.so
and not built the correct version of snowball_create.sql.
Anyway,
Glyn Astill wrote:
>
> --- Greg Smith <[EMAIL PROTECTED]> wrote:
>
> > If you look at the link I passed along before, you'll see the
> > difference
> > with MySQL is that they've been abusing their customers with minor
> > point
> > releases that try to add new features. Instead some of these
On Wed, Mar 12, 2008 at 11:53 AM, Dave Page <[EMAIL PROTECTED]> wrote:
> I'm pleased to announce that wiki.postgresql.org is now open for business!
Awesome!
--
Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324
EnterpriseDB Corporation | fax: 732.331.1301
499 Thornall Street, 2nd Floo
Added to Win32 TODO:
o Diagnose problem where shared memory can sometimes not be
attached by postmaster children
http://archives.postgresql.org/pgsql-general/2007-08/msg01377.php
---
Magnus Ha
Added to TODO:
* Remove use of MAKE_PTR and MAKE_OFFSET macros
http://archives.postgresql.org/pgsql-general/2007-08/msg01510.php
---
Tom Lane wrote:
> Gregory Stark <[EMAIL PROTECTED]> writes:
> > "Trevor Talbot" <[EMAI
--- Greg Smith <[EMAIL PROTECTED]> wrote:
> If you look at the link I passed along before, you'll see the
> difference
> with MySQL is that they've been abusing their customers with minor
> point
> releases that try to add new features. Instead some of these
> introduce
> functional regressio
It was far stupider than that. I had been playing around with a
couple of different data clusters before doing a complete reinstall of
PostgreSQL. I just realized I was trying to start a cluster that I
was no longer using and the postgres account didn't have appropriate
permissions for. It's one
I am considering the utility value of creating a functional index on a name
field. To minimize the number of invalid searches caused by spacing errors
and mis-matched lettercase I am contemplating doing something like this:
CREATE UNIQUE INDEX idxUF_table_column ON table
(lower(trim(both ' ' fr
On Wed, Mar 12, 2008 at 10:49 AM, Lee Hachadoorian
<[EMAIL PROTECTED]> wrote:
> Last week I set up Postgres 8.3 on a WindowsXP machine. Had it up and
> running and imported data. Now when I try to start the server (after
> a machine restart) I get the message:
>
>
> **
On Wed, Mar 12, 2008 at 10:49 AM, Lee Hachadoorian
<[EMAIL PROTECTED]> wrote:
> Last week I set up Postgres 8.3 on a WindowsXP machine. Had it up and
> running and imported data. Now when I try to start the server (after
> a machine restart) I get the message:
>
>
> **
On Wed, 12 Mar 2008 10:26:21 -0700
"Scott Marlowe" <[EMAIL PROTECTED]> wrote:
> On Wed, Mar 12, 2008 at 10:15 AM, Alvaro Herrera
> <[EMAIL PROTECTED]> wrote:
> > Ivan Sergio Borgonovo wrote:
> > > On Wed, 12 Mar 2008 09:13:14 -0700
> > > paul rivers <[EMAIL PROTECTED]> wrote:
> > >
> > > > For
Hello,
I am having trouble with a function designed to return all column
constraints on a table. The problem is not in the SQL, which works fine
on its own. The problem comes when the function is invoked using SELECT
* FROM function_name(arg_name) AS temp_table(.). When the function
do
Last week I set up Postgres 8.3 on a WindowsXP machine. Had it up and
running and imported data. Now when I try to start the server (after
a machine restart) I get the message:
pg_ctl: another server mig
On Wed, 12 Mar 2008 17:47:35 +0100
"jose javier parra sanchez" <[EMAIL PROTECTED]> wrote:
> Take a look at pgpool . http://pgpool.projects.postgresql.org/
I knew about it.
Giving a look at
http://pgpool.projects.postgresql.org/#restriction
it doesn't seem something that can be completely hidden
On Wed, Mar 12, 2008 at 10:15 AM, Alvaro Herrera
<[EMAIL PROTECTED]> wrote:
> Ivan Sergio Borgonovo wrote:
> > On Wed, 12 Mar 2008 09:13:14 -0700
> > paul rivers <[EMAIL PROTECTED]> wrote:
> >
> > > For a database of InnoDB tables, people tend to replicate the
> > > database, and then backup t
On Wed, Mar 12, 2008 at 10:03 AM, Gauthier, Dave
<[EMAIL PROTECTED]> wrote:
>
>
> V8.2.0 on Linux
Look into updating, there were some serious bugs fixed between 8.2.0
and 8.2.6 It's a pretty simple thing, since you don't need to dump /
reload for it.
>
> Can't rename a db, complains that it does
Ivan Sergio Borgonovo wrote:
> On Wed, 12 Mar 2008 09:13:14 -0700
> paul rivers <[EMAIL PROTECTED]> wrote:
>
> > For a database of InnoDB tables, people tend to replicate the
> > database, and then backup the slave (unless the db is trivially
>
> That recalled me the *unsupported* feeling I have
Tim Child <[EMAIL PROTECTED]> writes:
> There is a file here with the same name:
> /Library/PostgreSQL8/lib/postgresql/plpgsql.so
What else is in that directory? If you don't have dict_snowball.so
it's not gonna work.
> So I could try and run that snowball_create.sql script from src (which
> I
V8.2.0 on Linux
Can't rename a db, complains that it doesn't exist. Yet psql -l shows
that it does and I can connect to it ???
mmdcc228_SETUP(120)% psql stdb2 -c "alter database stdb rename to
stdb_tmp"
ERROR: database "stdb" does not exist
mmdcc228_SETUP(121)% psql -l
List of
Take a look at pgpool . http://pgpool.projects.postgresql.org/
2008/3/12, Ivan Sergio Borgonovo <[EMAIL PROTECTED]>:
> On Wed, 12 Mar 2008 09:13:14 -0700
> paul rivers <[EMAIL PROTECTED]> wrote:
>
> > For a database of InnoDB tables, people tend to replicate the
> > database, and then backup the
I noticed this immediately when using the PostgreSQL tool for examples of
dumps for creating export of database/table structure/data for the
MyJSQLView
application. I considered implementing a similar copy dump, but seems it
would
not be handled properly with SQL statements.
danap.
This is n
David Potts wrote:
This is not a flame about current or previous release of Postgres.
I have just gone through the awful experience of upgrading from Postgres
8.2 to 8.3 with a database that had one of the many Postgres extensions
included. The problem comes down to the way that Postgres extensi
On Wed, 12 Mar 2008 09:13:14 -0700
paul rivers <[EMAIL PROTECTED]> wrote:
> For a database of InnoDB tables, people tend to replicate the
> database, and then backup the slave (unless the db is trivially
That recalled me the *unsupported* feeling I have that it is easier
to setup a HA replication
Reece Hart wrote:
On Tue, 2008-03-11 at 06:47 -0700, rrahul wrote:
Any major clients of the two.
You can add you own points too.
Perhaps someone can comment on current MySQL backups procedures. I
believe that MySQL used to (still does?) require shutdown to be backed
up. I don't know whether
Tim Child <[EMAIL PROTECTED]> writes:
> In my snowball_create.sql I find:
> -- No language-specific snowball dictionaries, for lack of shared
> library support
Really!?
> This build comes from postgresqlformac.com the "Unified Installer -
> 8.3.0 (PostgreSQLforMac)"
Hm, do they have plpgsql
You can make a backup in MySQL in several ways:
1) Using mysqldump;
2) Lock tables and copy their files one-by-one (MyISAM-only);
3) Shutdown server and copy all files (can be a slave in a replicated
setup);
4) Using InnoDB hot backup (commercial tool);
On 3/12/08, Reece Hart <[EMAIL PROTECTED]>
I'm pleased to announce that wiki.postgresql.org is now open for business!
The PostgreSQL Wiki replaces the technical documentation area
("techdocs") on the PostgreSQL website and provides an easy-to-use
area for PostgreSQL users and developers to read and document
experiences with any area of Pos
On Tue, 2008-03-11 at 06:47 -0700, rrahul wrote:
> Any major clients of the two.
> You can add you own points too.
Perhaps someone can comment on current MySQL backups procedures. I
believe that MySQL used to (still does?) require shutdown to be backed
up. I don't know whether this was true for
Tim Child <[EMAIL PROTECTED]> writes:
> If I do \dF:
> Schema | Name | Description
> ++--
> pg_catalog | simple | simple configuration
> (1 row)
Huh. Seems like initdb forgot to install all the Snowball stemmers.
What do you find in $SHAREDIR/
This is not a flame about current or previous release of Postgres.
I have just gone through the awful experience of upgrading from Postgres
8.2 to 8.3 with a database that had one of the many Postgres extensions
included. The problem comes down to the way that Postgres extensions are
packaged up,
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> Hi! I want to set up a trigger (somehow) that, whenever someone connects
> database my_db, will fire and thereby run a stored PLPERL procedure
> perl_setup() in the new connection's environment. (BTW, this procedure adds
> useful definitions
On Wed, Mar 12, 2008 at 07:52:29AM -0400, Kynn Jones wrote:
> > An ON CONNECT trigger enforced by the database seems a bit scary to me.
> > If it's broken, how you gonna get into the DB to fix it?
A "psql --skip-on-connect-trigger", only available to, say,
superusers ? Or a database flag (like th
Kynn Jones wrote:
On Tue, Mar 11, 2008 at 5:28 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
"Kynn Jones" <[EMAIL PROTECTED]> writes:
If one can set up this insert operation so that it happens automatically
whenever a new connection is made, I'd like to learn how it's done.
For manual psql sessions
Hi,
Does somebody knows how to compile oralink in postgresql 8.2? The boss
wants it because it saw it working in a postgresql 8.1. I hate oralink
because it looks like a dummy's job (the makefile is a mess and
there's no documentation, not even a README file).
Any information is welcome.
Thanks
Please always ensure that the list is copied on replies (use "Reply to
all") so that other people can help you.
sam escribió:
> On Mar 11, 5:39 pm, [EMAIL PROTECTED] (Alvaro Herrera) wrote:
> > sam escribió:
> >
> > > Iam not able to understand if this is a version problem or the way iam
> > > usi
On Tue, Mar 11, 2008 at 5:28 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Kynn Jones" <[EMAIL PROTECTED]> writes:
> > If one can set up this insert operation so that it happens automatically
> > whenever a new connection is made, I'd like to learn how it's done.
>
> For manual psql sessions, you can
On Wed, 12 Mar 2008 11:48:24 +0100
Martijn van Oosterhout <[EMAIL PROTECTED]> wrote:
> On Wed, Mar 12, 2008 at 11:40:18AM +0100, Ivan Sergio Borgonovo
> wrote:
> > I'd like to make this query work
> >
> > select 1,
> > st.Name, sm.Name, sm.MethodID, sm.Description,
> > pt.Name, pm.Name, p
Hi everyone,
I'm trying to port some vb6 code to pgplsql (PostgreSQL 8.3 winxp)
that code is
Const f2_MAX_TRAMS = 5
Dim f2_rTarifaA as new ADODB.Recordset
Dim Mpa(f2_MAX_TRAMS) As Double ' preu aigua
Dim Ma(f2_MAX_TRAMS) As Long' m3 aigua tarifa
Dim i As Integer, j As
If I do \dF:
Schema | Name | Description
++--
pg_catalog | simple | simple configuration
(1 row)
\dFd:
Schema | Name |Description
+
+-
On Wed, Mar 12, 2008 at 11:40:18AM +0100, Ivan Sergio Borgonovo wrote:
> I'd like to make this query work
>
> select 1,
> st.Name, sm.Name, sm.MethodID, sm.Description,
> pt.Name, pm.Name, pm.MethodID, pm.Description
> from
> shop_commerce_paymethods pm,
> shop_commer
I'd like to make this query work
select 1,
st.Name, sm.Name, sm.MethodID, sm.Description,
pt.Name, pm.Name, pm.MethodID, pm.Description
from
shop_commerce_paymethods pm,
shop_commerce_shipmethods sm
inner join shop_commerce_shiptypes st on s
sathiya psql wrote:
Is there any article describing the migration database from postgresql 7.4to
8.1
The basic tips are:
1. Use pg_dump from 8.1 to dump your 7.4 database
2. Read the release notes for the intervening versions to see what might
affect your applications.
In particular, the UTF
On Wed, 12 Mar 2008, Russell Smith wrote:
Scott Marlowe wrote:
I too wait a day or two to test it on a staging server, but
I've never had a pgsql update blow back in my face, and I've done an
awful lot of them.
So you missed 8.1.7 then or weren't using those features at the very
least? You a
On Wed, Mar 12, 2008 at 12:02 AM, Russell Smith <[EMAIL PROTECTED]> wrote:
>
> Scott Marlowe wrote:
> > On Tue, Mar 11, 2008 at 7:33 PM, Justin <[EMAIL PROTECTED]> wrote:
> >
> >> I view updates/patches of any kind like this, if ain't broke don't fix
> it.
> >> I normally only update compute
Scott Marlowe wrote:
On Tue, Mar 11, 2008 at 7:33 PM, Justin <[EMAIL PROTECTED]> wrote:
I view updates/patches of any kind like this, if ain't broke don't fix it.
I normally only update computers with security patches only after i prove it
don't destroy installs.
But that's juast it.
90 matches
Mail list logo
