On Apr 24, 4:13 pm, t...@sss.pgh.pa.us (Tom Lane) wrote:
> Sam writes:
> > A particular web application I am working has a staging version
> > running one a vps, and a production version running on another vps.
> > They both get about the same usage, but the production version keeps
> > crashing a
On Apr 24, 3:53 pm, thombr...@gmail.com (Thom Brown) wrote:
> On 24 April 2010 18:48, Sam wrote:
>
>
>
>
>
> > Hi,
>
> > I am a web developer, I've been using postgesql for a few years but
> > administratively I am a novice.
>
> > A particular web application I am working has a staging version
> >
On Apr 24, 3:53 pm, thombr...@gmail.com (Thom Brown) wrote:
> On 24 April 2010 18:48, Sam wrote:
>
>
>
>
>
> > Hi,
>
> > I am a web developer, I've been using postgesql for a few years but
> > administratively I am a novice.
>
> > A particular web application I am working has a staging version
> >
Howdy,
I spent a majority of today playing around with pg_partman (awesome tool
btw!). I am mainly using the time-static method with an interval of one
month.
I wanted to see what performance improvements I could get with some
common queries that are used by our analytics team. A lot of these
On 03/04/2015 12:11 AM, David G Johnston wrote:
In short - since the planner determines exclusion constraints and the
executor, which strictly follows the planner in the query execution process,
would be the one to determine what the value of your date is - there is no
way for a single query to
On 03/18/2015 09:20 AM, adityagis wrote:
Dear Users,
I have lots of data in my DB. I need to do archeiving and purging of my
data.
Can anyone please help me with step by step riles?
Thanks in Advance.
Aditya Kumar
--
View this message in context:
http://postgresql.nabble.com/Archeiving-an
On 05/16/2015 10:44 PM, Maks Materkov wrote:
I have a database, table "users", with column "profile_id", and the
following query:
EXPLAIN ANALYZE SELECT * FROM users_user WHERE profile_id IN (...50 ids...);
Result:
Index Scan using users_user_83a0eb3f on users_user (cost=0.50..292.22
rows=
ow what commands are available since
there is no common prefix (e.g. pg_) for these commands.
Thanks
Samuel
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
we update the Arch Linux documentation to prefer these
commands? What is the recommendation here?
On 29 October 2016 at 12:39, John R Pierce wrote:
> On 10/28/2016 4:31 PM, Samuel Williams wrote:
>>
>> Just wondering as the naming of these commands seems overly generic
>> and for a
rience a lot better. Given how awesome
postgres is in other areas, it's disappointing that the command line
tools don't reflect the same level of engineering and thoughtfulness.
On 29 October 2016 at 16:36, Samuel Williams
wrote:
> I think there is an opportunity here to make the exp
l of engineering and thoughtfulness.
On 29 October 2016 at 13:46, John R Pierce wrote:
> On 10/28/2016 4:55 PM, Samuel Williams wrote:
>>
>> Even if maintaining the old commands, they could print
>> out to stderr "This command is deprecated and now wraps `pg_ctl init`
FYI, https://wiki.archlinux.org/index.php/PostgreSQL mentions initdb,
createuser, createdb and several others. I think my suggestion is
still relevant and something that would improve the system for new
users :)
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make change
ly just my 2c, I'd be happy to submit a PR but can you
confirm intention to work on it to acceptance? Otherwise I'm just
wasting everyone's time including my own :)
On 30 October 2016 at 13:31, Gavin Flower wrote:
> On 30/10/16 11:25, John R Pierce wrote:
>>
>> On 1
John - that's an interesting example. If it's that easy, why isn't
that the approach given in tutorials and other documentation? What was
the motivation for the createuser command?
On 30 October 2016 at 20:20, John R Pierce wrote:
> On 10/30/2016 12:15 AM, Samuel Williams w
x27;d feel more confident
to invest the time and effort required to improve things.
But so far, I'm getting the opposite.
Kind regards,
Samuel
On 31 October 2016 at 04:30, Adrian Klaver wrote:
> On 10/30/2016 12:15 AM, Samuel Williams wrote:
>>
>> Adrian, I like the idea
#x27;s
worthy of some attention.
On 31 October 2016 at 12:51, Mike Sofen wrote:
> From: Samuel Williams Sent: Sunday, October 30, 2016 3:42 PM
> As a community I'd think that having feedback from a new user would be
> valuable since as you say, sometimes when you get ingrained i
Sorry, just to clarify, b "worst" I don't mean functionality, I mean
the way the commands are named and organised.
On 31 October 2016 at 13:07, Samuel Williams
wrote:
> Mike, I agree with "the postgres way of doing things". I'm suggesting that
>
>> th
On 1 November 2016 at 06:50, Daniel Verite wrote:
> Samuel Williams wrote:
>
>> John - that's an interesting example. If it's that easy, why isn't
>> that the approach given in tutorials and other documentation? What was
>> the motivation for the c
> Really? So naming them pg_initdb and pg_createdb would help to clarify their
> use?
Yes.
> Perhaps you missed: https://www.postgresql.org/docs/9.6/static/app-pg-ctl.html
I meant a man page that details the ENTIRE Postgres command line tools.
> Command line aliases and other stuff
I've been
I'd like to understand a bit more about indexes in PG.
When I have a row in a table, and an index, say, for a single column,
does that duplicate the entire row on disk? Or is there some kind of
id lookup involved?
Thanks.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
Is there any reason why for the same data set, and same indexes, that
the data in postgres would be significantly larger than
innodb/mariadb?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-gener
could be ignored from the index.
Thanks,
Samuel
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
So, uh, my main question was, does MySQL add null values to an index, and
is this different from Postgres. The schema is irrelevant, except that the
column allows null values. I noticed when you create an index you can add a
where clause. Could it be I should add WHERE the fields are not null?
Her
Melvin, of course there are differences. However, I suspect there are at
least SOME tangible differences which can be identified.
On 4 December 2016 at 15:53, Melvin Davidson wrote:
>
>
> On Sat, Dec 3, 2016 at 9:32 PM, Steve Atkins wrote:
>
>>
>> > On Dec 3, 2016,
Melvin, uh... I'm a software engineer... since when was it a problem to
want to know how things work and why they are different? If you have
nothing to contribute of a relevant technical nature, please don't reply,
I'm really not interested.
Thanks Kevin, that makes sense. Yeah, I understand the architectural
difference a bit more now. I also read that when you change a column
which is not index, all the indexes for that row need to be updated
anyway. Is that correct?
On 7 December 2016 at 05:27, wrote:
> Samuel Williams wr
ored with all the possible precision of a REAL or are they
stored as displayed?
-- Is it because of the behaviour of the COPY statement?
Thank you for your help!
Samuel
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Howdy,
I am looking for advice on migrating to postgres from another database
system.
Without going into too much detail, my company offers a software
solution which we self host ourselves in our data center. We have gotten
a green light from management to start using postgres as a free and
On 02/21/2015 05:25 PM, David Steele wrote:
On 2/21/15 6:08 PM, Adrian Klaver wrote:
Currently the built in replication solutions work at the cluster level,
not at the database level. There are third party tools, Slony and
Bucardo come to mind, that can work at a more focused level.
Again, it
On 02/22/2015 01:53 PM, Scott Marlowe wrote:>
> I'd run a debian based distro (Ubuntu or Debian work well) and use the
> pg_* commands to create the clusters the same way. Gives you the
> maximum separation for clients.
>
> pg_createcluster
>
> Usage: /usr/bin/pg_createcluster [options]
> [-- ]
ache, all user_ids seen on
a given day. If we change our index to be more discrete, e.g.
created_at::date, would this help? The set union of user_ids for 365
days should be pretty fast?
I'm open to any ideas or suggestions, ideally we can keep
optimisations within the database, rather than ad
Oh, I've also tried earth distance and ll_to_earth in a GIST index...
it was slower that the BTREE index on a small subset of data in my
tests.
On 19 April 2017 at 16:01, Samuel Williams
wrote:
> Hi.
>
> We have 400,000,000 records in a table (soon to be 800,000,000), here
>
16:42, John R Pierce wrote:
> On 4/18/2017 9:01 PM, Samuel Williams wrote:
>>
>> We want the following kinds of query to be fast:
>>
>> SELECT ... AND (latitude > -37.03079375089291 AND latitude <
>> -36.67086424910709 AND longitude > 174.6307139779924 AND lon
> Did that 50% performance gain come from just the datatype, or that fact that
> the index became smaller?
How would one measure this?
On 19 April 2017 at 19:48, John R Pierce wrote:
> On 4/19/2017 12:31 AM, vinny wrote:
>>
>> Given the number of records, my first thought was either partitionin
ing the different indexes
explicitly?
The correlation between user_id and location... well, it's somewhat
temporally related.
On 19 April 2017 at 22:50, Alban Hertroys wrote:
>
>> On 19 Apr 2017, at 6:01, Samuel Williams
>> wrote:
>>
>> Hi.
>>
>> We hav
Martijn that is a good question. It's because we are only concerned
with a subset of events for this index and this particular query. The
query planner can recognise this and use the index correctly. By doing
this, we reduce the size of the index significantly. In the best case,
where we only wante
;m using the default 9.6 config, I thought that auto-vacuum was on by default?
On 20 April 2017 at 00:48, Stephen Frost wrote:
> Greetings,
>
> * Samuel Williams (space.ship.travel...@gmail.com) wrote:
>> We want the following kinds of query to be fast:
>
> "kinds of q
Ah right, yeah, it's insert only. So, it's never been vacuumed.
On 20 April 2017 at 01:25, Stephen Frost wrote:
> Greetings,
>
> * Samuel Williams (space.ship.travel...@gmail.com) wrote:
>> Thanks for all the suggestions Stephen.
>>
>> > That explain a
Okay, so after changing longitude/latitude to float4, and
re-organizing the table a bit, I got the query down from about 8
minutes to 40 seconds.
The details are in the gist comments:
https://gist.github.com/ioquatix/bddda36d9e4ffaceb7a62d7b62259121
Now, just need to get performance another 2 ord
I see this, but no follow up:
https://www.postgresql.org/message-id/CAEepm%3D2LUCLZ2J4cwPv5DisHqD9BE_AXnqHGqf0Tj-cvtiqVcQ%40mail.gmail.com
So, is it possible or not?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresq
Andrew, how would timescaledb compare to citus - and is timescaledb an
extension to postgres or is it an entirely separate system?
On 21 April 2017 at 02:44, Andrew Staller wrote:
> Awesome thread.
>
> Samuel,
>
> Just wanted you to be aware of the work we're doing at
Scott, Vick, the vast majority of the data is generic. But there are
some specific events we need to look up quickly which are probably
less than a few 100,000 records. We did evaluate partial indexes vs
full indexes. The partial index speeds up our specific queries
significantly while only taking
Citus is also now just an extension.
Sounds pretty awesome, I'll certainly consider your system if/when we
decide to make changes.
On 22 April 2017 at 08:41, Andrew Staller wrote:
> Samuel,
>
> Short answer to your questions: (1) TimescaleDB and CitusDB are focusing on
>
every child. To my great surprise, the
insert below failed with a message saying that NULLs are not allowed in the
modificationdate column.
INSERT INTO observation
(dataset, station, method, startdate, duration, value)
VALUES (9, 2, 128, '2014-01-01 00:00:00', '24 hours', 42)
On 2014-02-18 14:25:59 Adrian Klaver wrote:
> On 02/18/2014 02:10 PM, Samuel Gilbert wrote:
> > I have data warehousing DB 2 fairly big tables : one contains about 200
> > million rows and the other one contains about 4 billion rows. Some
> > queries
> > are now takin
h of my post as short as
possible.
As Tom Lane pointed out, it's hard to get help without a complete self-
contained example. I will work on writing that up tomorrow.
Cheers!
On 2014-02-18 15:02:41 Adrian Klaver wrote:
> On 02/18/2014 02:42 PM, Samuel Gilbert wrote:
> > On 2014-02-18 14
On 2014-02-18 17:59:35 Tom Lane wrote:
> Samuel Gilbert writes:
> > All of this was done on PostgreSQL 9.2.0 64-bit compiled from the official
>
> > source. Significant changes in postgresql.conf :
> Why in the world are you using 9.2.0? You're missing a year and a
INTO child_split1 (split, happiness) VALUES (1, 42);
-- NOTICE: NEW row is now : (1, 42, 2014-02-19 16:37:27.134194)
-- INSERT 0 1
So, we clearly see that trigger_insert_00 is called in both cases. I don't
understand why the query fails on the parent, but works when the INSERT
targets the chil
On Fri, May 27, 2011 at 9:15 AM, Emi Lu wrote:
>
> Solution:
>
> (1) Save pdfs to file system, only point file name in psql8.3
>
> (2) Save oids of pdfs into table
>
> (3) Save pdf files as bytea column in psql8.3
>
>
> Pros and cons for (1), (2), (3), which is the most
Hi,
I see the following error as found in pg.log:
UTC4115FATAL: the database system is in recovery mode
Actually that message was logged repeatedly for about 4 hours according to the
logs (I don't have access to the system itself, just the logs).
Leading up to that error were the following in
Craig Ringer writes:
> On 05/30/2011 10:29 PM, Mathew Samuel wrote:
>
>> 2011-03-28 10:44:28 UTC3609HINT: Consider increasing the configuration
>> parameter "checkpoint_segments".
>> 2011-03-28 10:44:38 UTC3609LOG: checkpoints are occurring too
>> freque
Thanks. But I am not looking for how to avoid the problem at this
moment,
I am more interested in why PostgreSQL is designed to work this way.
To make the problem more obvious,
drop table if exists t1;
create table t1 (f1 int);
create unique index uix_t1 on t1(f1) ;
insert into t1(f1) values (1),
Thanks for the reply.
You are right, the result is all or nothing, so it's still atomic. I
found my mistake and posted a clarification for my question.
I know in PostgreSQL 9.0 unique constraint can be set to deferrable.
However still no luck for unique indexes.
The real question is that why Pos
I ran the same tests in SQL Server 2008R2, Oracle10 and PostgreSQL
9.0.4 and found something interesting...
set up
=
drop table t1
create table t1 (f1 varchar(100))
insert into t1 (f1) values ('AbC')
insert into t1 (f1) values ('CdE')
insert into t1 (f1) values ('abc')
insert into t1 (f1) valu
On Wed, Sep 26, 2012 at 1:21 PM, hubert depesz lubaczewski <
dep...@depesz.com> wrote:
> On Wed, Sep 26, 2012 at 02:38:09PM -0400, Robert Sosinski wrote:
> > The first query shows a cost of 190,169.55 and runs in 199,806.951 ms.
> > When I disable nested loop, I get a cost of 2,535,992.34 which ru
-+--
00042 | 10 | " 00042"
Is there a reason why to_char adds a leading space? Is this a bug? I can
easily fix this with trim(leading ' ' from to_char(num, '0')), but,
being of a curious nature, I'd like ton know why
Thank you, it works. The documentation gave me the impression that the FM
modifier only applied to date/time since it was under "Usage notes for
date/time formatting:"
Samuel
On Friday, October 26, 2012 16:01:08 Moshe Jacobson wrote:
> You want to use a format of 'FM000
vere issue for me since, I don't want users that need to
input data to also have the right to modify references tables. This is,
also, not how I would have expected the permissions to behave.
Any help to resolve this issue will be greatly appreciated!
Best Regards,
Samuel
--
Sent via p
er role.
In the end, I got mixed up and sent the wrong version of the test script to
the list. However, even if it is not the right user, the problem remains.
Samuel
On Saturday, July 24, 2010 06:08:23 Alban Hertroys wrote:
> On 23 Jul 2010, at 20:39, Samuel Gilbert wrote:
> > Hel
tre tables où
il y a un champ qui fait référence à la table sur laquelle il y a le
trigger.
Exemple d'application:
INSERT INTO table1 (champ2, champ3) VALUES ('salut', 'samuel');
(la table1 as un champ1 (alias id) qui est un serial en clef primaire)
-> La fonction pgp
Le mardi 26 août 2008 à 11:01 +0200, Guillaume Lelarge a écrit :
> Samuel ROZE a écrit :
> > [...]
> > J'ai un trigger (AFTER FOR EACH ROW) sur une table qui à chaque fois
> > qu'il y a un enregistrement sur cette même table, exécute une fonction
> > pgplsql
10-18 10:34:08 MDT [17633]: [1-1] FATAL: the database system is
starting up
2011-10-18 10:34:09 MDT [17669]: [1-1] FATAL: the database system is
starting up
Samuel
I have been trying to use views to restrict access to a subset of data
as stated :
Using Andrus's example for user B with document in public schema :
REVOKE ALL FROM public.document;
CREATE SCHEMA b AUTHORIZATION b;
CREATE VIEW b.document AS SELECT * FROM public.document WHERE
DocumentType
Tom Lane a écrit :
Samuel Thoraval <[EMAIL PROTECTED]> writes:
I have been trying this example not executing the GRANT UPDATE statement
at first to check that user b doesn't have the right to update. The
problem is that even though B was not granted the update pr
the information I
need reading through the pg documentation. For instance I currently need
to get the OID for a given namespace in order to query the pg_type
table, and I don't know where to find that information...
Regards,
--
Samuel Thoraval
---(end of broa
Reading through "Chapter 41. System Catalogs" down to sub chapter
"pg_type" I could actually easily get the namespace's OID from table
pg_namespce: pg_namespace.oid.
So sorry, may be reading through the documentation is good enough
and not so difficult :-[ ...
hen user nsp2 loggs in, the VIEW vtest would be using
VIEW nsp2.test, when user nsp3 loggs in it would use VIEW nsp3.test, for
user nsp1 TABLE nsp1.test ...
Cheers,
--
Samuel Thoraval
LIBROPHYT, Bioinformatique
Centre de Cadarache
---(end of broadcast)
IBPhoenix or manually, by issuing the command but not locking the
table. Hopefully it goes into the TO DO list.
Thank's
Andy
- Original Message -
From: "Thalis A. Kalfigopoulos" <[EMAIL PROTECTED]>
To: "Andy Samuel" <[EMAIL PROTECTED]>
Cc: <[EM
estion?
>
> Stephen
>
> ---(end of broadcast)---
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to [EMAIL PROTECTED] so that your
> message can ge
On Fri, Jul 28, 2000 at 06:53:41PM -0400, Tom Lane wrote:
> George Robinson II <[EMAIL PROTECTED]> writes:
> > What approach would be the most efficient way to accomplish this goal?
> > With what language or tools would you recommend? If I were to leave the
> > time as a int4, epoch time, wh
Is it possible to unlink large objects using SQL? I see import and export and
I can unlink from a program, but is it possible to use a query to unlink them?
Hi All,
I want to migration an existing database from a 32bit server to a 64bit
server. I will use exactly the same postgresql version (8.2.6).
Did I need to dump the data to do this or a single copy of /data will
work ?
Is any interger lenght impact on /data ?
Thanks,
--
Paul Tomblin a écrit :
>
> Quoting Alex Pilosov ([EMAIL PROTECTED]):
> > While I think its a great idea for quality of DBD::Pg (Edmund, with all
> > due respect, does not scale :), it needs to be agreed with Edmund
> > first, and CPAN releases of DBD::Pg should continue, based on snapshots
> > fr
So if I've got text of more
than 4096 bytes size, for example article - do I really have to put it in
the LOB field and use these terrific lo-functions to access it ?? Please, if
anyone can help me - write to [EMAIL PROTECTED] .
Thx in advance,
Michael 'Samuel' Modestowicz
Are there any tools for generating reports for Postgres? I searched
RedHat, Enterprise Linux, the HOWTO, and haven't found anything.
Sam
--
_
/ Samuel A. Mullen \
| Programmer Analyst |___
| Opportunities Unl. | O
far as that little MS Access comment goes. It took me a long time to
find a job where I just use Linux, I don't want to regress to Windows.
:)
Sam
"Brett W. McCoy" wrote:
>
> On Tue, 9 May 2000, Samuel A. Mullen wrote:
>
> > Are there any tools for generating rep
rs.
Any help would be greatly appreciated.
Sam
--
_____
/ Samuel A. Mullen \
| Programmer Analyst |___
| Opportunities Unl. | Which by his strength setteth fast the\
\_/| mountains; [being] gi
Replying to myself in the event that anyone was curious. Ended up
closing down StarOffice and starting it back up. Everything works fine
now. Go figure.
Can't really do/see relationships in Star Office, although that may be
more a StarOffice thing than ODBC driver.
Sam
"Samuel
Does anyone have a startup script for Postgres 7.0 that I can throw into my
/etc/rc.d/init.d directory? (RedHat 6.1)
Thanks,
Sam
--
_
/ Samuel A. Mullen \
| Programmer Analyst |___
| Opportunities Unl. | More to be
Using PostgreSQL 9.1.8 on x86_64-unknown-linux-gnu, compiled by gcc
(Ubuntu/Linaro 4.6.3-1ubuntu5) 4.6.3, 64-bit
POSTGIS="2.0.1 r9979" GEOS="3.3.3-CAPI-1.7.4" PROJ="Rel. 4.8.0, 6 March 2012"
GDAL="GDAL 1.9.2, released 2012/10/08" LIBXML="2.8.0" LIBJSON="UNKNOWN"
TOPOLOGY RASTER
Postgis seems t
I have a table (pubacc_lo) from the US government with 500,00+ rows. It has
latitude and longitude in three columns each for degrees, minutes and seconds.
I need a Point geometry column. So I wrote this query:
with mydata AS (SELECT (pubacc_lo.lat_degrees + pubacc_lo.lat_minutes/60 +
pubacc_lo.
Thank you! That worked fine.
From: bricklen [mailto:brick...@gmail.com]
Sent: Friday, August 23, 2013 10:08 AM
To: Hall, Samuel L (Sam)
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Update quey
On Fri, Aug 23, 2013 at 8:04 AM, Hall, Samuel L (Sam)
mailto:sam.h...@alcatel-lucent.com
I have a Postgressql-9.2 database with postgis-2.0 in production service. Due,
I think, to a bad postgis upgrade, there are both old and new functions
present. I am planning to install Postgresql-9.3 and Postgis-2.01 and then copy
the data over with pg_upgrade. My question is: Will this also cop
When I try to run SQL from PgAdmin : CREATE TABLE tse_history_old LIKE
tse_history INCLUDING ALL WITH OIDS
I get this error
ERROR: syntax error at or near "LIKE"
LINE 2: CREATE TABLE tse_history_old LIKE tse_history INCLUDING ALL ...
testing, I find that using the word "LIKE" always causes erro
t: Re: [GENERAL] PgAdmin errors
On 3/26/2014 12:32 PM, Hall, Samuel L (Sam) wrote:
When I try to run SQL from PgAdmin : CREATE TABLE tse_history_old LIKE
tse_history INCLUDING ALL WITH OIDS
I get this error
ERROR: syntax error at or near "LIKE"
LINE 2: CREATE TABLE tse_history_old LIKE tse_hi
ierce
Sent: Wednesday, March 26, 2014 3:02 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] PgAdmin errors
On 3/26/2014 12:58 PM, Hall, Samuel L (Sam) wrote:
That doesn't help. Even this CREATE TABLE tse_history_old (LIKE tse_history)
gives an error
the exact same error ?
--
Yes
"PostgreSQL 9.3.0 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu/Linaro
4.6.3-1ubuntu5) 4.6.3, 64-bit"
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Wednesday, March 26, 2014 4:03 PM
To: Hall, Samuel L (Sam)
Cc: John R Pierce; pgsql-general@post
I have an application that writes an Excel Spreadsheet to postgres. For the
values that go in number fields, I check the Excel values for dbnull and set
the parameters to 0, like this: cmd.Parameters(9).Value = 0. Npgsql throws an
error "format specifier was invalid" If I do this: cmd.Parameter
g i can do to try access my data, im restoring my
last backup, but i want try everything to get the most recent before
give up.
Thanks in advance.
PS: Please, cc me a reply cos im not in the pgsql list.
Samuel Abreu de Paula
sam...@debian-ce.org
Mike Ditka - "If God had wanted man to
89 matches
Mail list logo
