I use ODBC instead of Npgsql because the ODBC can use with MS Access,
MS SQL and PostgreSQL database.
Here is the code.
System.DateTime dateTimeNow = System.DateTime.Now;
int i=0;
dataView1.RowFilter = "Posted = true";
dataView1.Sort = "GLTran, ID"; //GLTran Table
int n = this.BindingContext[data
Hi Jonel
Thank you for your response. I use ODBC instead of Npgsql because the
program can use with MS Access, MS SQL and PostgreSQL.
Here is the code.
int n = this.BindingContext[dataView1].Count - 1;
string _Journal;
DataRowView DataRowView1;
this.cmdInsert.Transaction = _Transaction;
this.cm
Assad Jarrahian <[EMAIL PROTECTED]> writes:
> UPDATE userprofiles SET address = ROW(
> ,'','','',,'',,'','','','','','','','','','') where
> username='mooreg3';
> ERROR: syntax error at or near "," at character 41
That first comma is wrong, or else you forgot to put in a value
before it ...
Thank you for your response. I use ODBC instead of Npgsql because I can
use ODBC with other database such as MS Access, and MS SQL.
Here is the code.
System.DateTime dateTimeNow = System.DateTime.Now;
int i=0;
dataView1.RowFilter = "Posted = true";
dataView1.Sort = "GLTran, ID"; //GLTran Table
in
Richard Sydney-Smith <[EMAIL PROTECTED]> writes:
> I am running Fedora core 4 with nightly "yum" update. Presently it is
> not picking up version 8.1 as an upgrade.
> 1) If I wait will 8.1 get added to the "yummy" list
Nope. FC4 is locked to the PG 8.0.x release series. This goes along
with Re
When I try to unregister the windows service I get an error like:
C:\Program Files\PostgreSQL\8.1\bin>pg_ctl.exe unregister -N "pgsql-8.1"
pg_ctl: could not open service manager
This is on Windows XP and the logged user is postgres
---(end of broadcast)---
> When I try to unregister the windows service I get an error like:
>
> C:\Program Files\PostgreSQL\8.1\bin>pg_ctl.exe unregister -N
> "pgsql-8.1"
> pg_ctl: could not open service manager
>
> This is on Windows XP and the logged user is postgres
You need administrative privileges to unregister
> You need administrative privileges to unregister a service. Can't run it
> as user postgres.
I did the same under "Administrator" but then I get an access violation
error like:
Unhandled exception at 0x77c478c0 in pg_ctl.exe: 0xC005: Access
violation reading location 0x.
What am I
Thanks Tom. 8.1 has some very tempting features running it on the
windows box ... ayah but I like the lazy days approach of having yum do
the updates so guess the FC4 box will have to await the release of FC5.
r
Tom Lane wrote:
Richard Sydney-Smith <[EMAIL PROTECTED]> writes:
Angshu Kar wrote:
Hi Pgsql,
Could anyone please advise whether the following program can be implemented
using pgsql cursors/anythign else (or do we need some external scripts)?If
yes, could you give please some function names etc?
[snip series of queries]
Any procedural language will be able t
В Пнд, 09/01/2006 в 02:33 -0400, Marc G. Fournier пишет:
> -- Character string locale comparison bug. This may require a REINDEX
> on text column indexes in some locales, such as Hungarian.
Can we be more specific here? How is an administrator supposed to know,
whether he needs to reindex his
Does the system running pgpool have to be permanently running or can it be
rebooted without deranging open but quiescent ODBC connections?
If it /can/ be rebooted can it also be transferred from one machine to another,
e.g. by changing the location of the IP alias?
If it /can't/ be rebooted witho
Hi,
On Mon, 9 Jan 2006, Richard Sydney-Smith wrote:
Thanks Tom. 8.1 has some very tempting features running it on the windows
box ... ayah but I like the lazy days
approach of having yum do the updates so guess the FC4 box will have to await
the release of FC5.
Instead, you can downloa
Hi,
I've got Postgres
8.1.1 running on a Win32 platform. I would like to authenticate users through an
LDAP server and I saw that is possble to do this under a Unix platform with the
pam_ldap package.
Does anybody know if
something similar is at the moment available (or will be available
> Hi,
>
> I've got Postgres 8.1.1 running on a Win32 platform. I would
> like to authenticate users through an LDAP server and I saw
> that is possble to do this under a Unix platform with the
> pam_ldap package.
>
> Does anybody know if something similar is at the moment
> available (or wi
On 1/9/06, Markus Bertheau <[EMAIL PROTECTED]> wrote:
> В Пнд, 09/01/2006 в 02:33 -0400, Marc G. Fournier пишет:
>
> > -- Character string locale comparison bug. This may require a REINDEX
> > on text column indexes in some locales, such as Hungarian.
>
> Can we be more specific here? How is an
On 1/8/06, Guy Rouillier <[EMAIL PROTECTED]> wrote:
> Carlos Moreno wrote:
>
> > Any comments? If it is the first option above, then it feels like
> > by definition there is absolutely nothing that can be done, now or
> > ever :-(
>
> I got an IMAP account with BurntMail.com. I belong to a doze
On 1/6/06, Pete Deffendol <[EMAIL PROTECTED]> wrote:
> Correct me if I'm wrong, but it seems that PostgreSQL 7.4 does not remove a
> user's privileges on tables when that user is dropped. The privileges are
> still showing up if I do a \z in psql, but with the SYSID instead of the
> username (obvi
Why is the first commaa wrong?
I guess thats my question
how do I set a value of a type to null?
I mean if type is made up of type a,b,c
how do I set them all at once, but having b to be null?
I thought using the ,, with nothing in between would do that I guess I
was wrong.
Any help would be much
Assad Jarrahian schrieb:
> Why is the first commaa wrong?
> I guess thats my question
>
> how do I set a value of a type to null?
> I mean if type is made up of type a,b,c
> how do I set them all at once, but having b to be null?
>
> I thought using the ,, with nothing in between would do that I
Hi,
I have to archieve functions like this:
When users define a new index, I will do something (for instance,
increase an counter in my table or do some other statistics). However,
I defined rule for insert on pg_class and when the entry is actually an
index, I do my thing. Obviously my rule
Hello,
I'm new to postgresql and during testing for a script I've found some
curious things.
If I do the following things a bad dump will be created that can't be
restored (using pgadmin3, pg_dump and pg_restore or psql).
There's also a issue that pgadmin crash.
In pgadmin3 do
1) Create a new d
Hi,
I have a question regarding function overloading:
assume that you have a function that takes several numeric arguments -
lets for example say 4 arguments: f(a,b,c,d)
Now further assume that internally in the function the first thing you
do is to convert the arguments to double precision, do
Greetings,
I'd like to vacuum all tables under a specific schema. Instead of
specifying tables one by one under the schema (not one Database), is
there a simple way to do it?
Thanks and have a nice weekend,
Emi
---(end of broadcast)---
TIP 5: d
Dear friends,
read txt and insert table (pgsql).
can i do help anyone ?.
att,
Marcelo Lima.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
> Does this mean that I can't create rules for system tables?
that's right... you cannot create rules for system tables...
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner w
[EMAIL PROTECTED] writes:
> Does this mean that I can't create rules for system tables?
Not ones that will be invoked by system operations, anyway.
regards, tom lane
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postma
Robert Greimel <[EMAIL PROTECTED]> writes:
> I have a question regarding function overloading:
> assume that you have a function that takes several numeric arguments -
> lets for example say 4 arguments: f(a,b,c,d)
> Now further assume that internally in the function the first thing you
> do is t
snip WHERE my_tbl_id = $1AND CASE WHEN $2 IS NULL THEN TRUE ELSE $2 = username ENDor WHERE my_tbl_id = $1 AND COALESCE($2 = username, TRUE)or WHERE my_tbl_id = $1 AND COALESCE($2, username) = usernameWith predicates such as these you wouldn't need to use EXECUTE andyou could write the query
"Daniel Whitter" <[EMAIL PROTECTED]> writes:
> If I do the following things a bad dump will be created that can't be
> restored (using pgadmin3, pg_dump and pg_restore or psql).
> There's also a issue that pgadmin crash.
You should report the pgadmin crash to the pgadmin people (who may or
may not
is using IN to query a list of values in an function supported? or is there a work around for this type of query?e.g. ... SELECT * FROM tbl WHERE u_id IN (0$1) $$ LANGUAGE SQL;
Yahoo! Photos
Got holiday prints? See all the ways to get quality prints in your hands ASAP.
On 1/9/06, Matthew Peter <[EMAIL PROTECTED]> wrote:
> is using IN to query a list of values in an function supported? or is there
> a work around for this type of query?
>
> e.g.
> ...
> SELECT * FROM tbl WHERE u_id IN (0$1)
>
> $$ LANGUAGE SQL;
>
if you mean
SELECT * FROM tbl WHERE u_id IN (0, 1)
How come when I pass in a list in it doesn't use it as a list of integers? Do I need to somehow make $1 be interpreted as a list of ints? Rather than just passing a text value that contains the list?CREATE TABLE my_tbl (u_id int);INSERT INTO my_tbl (u_id) values (1);INSERT INTO my_tb
Marcelo Lima wrote:
> Help me please!
>
> I need change autocommit to off in fedora core 3 in postgresql.conf i don?t
> know.
>
> How can i do?
No, only in psql using AUTOCOMMIT.
--
Bruce Momjian| http://candle.pha.pa.us
pgman@candle.pha.pa.us | (61
On Fri, Jan 06, 2006 at 10:31:49AM -0700, Trent Shipley wrote:
> Actually, lack of DEFINE is a major gap in SQL itself. Most modern
> programming languages make a distinction between *defining* a
> ???multi-variable
> precursor??? (sort of a light weight type) and *instantiating* a variable.
Jaime Casanova wrote:
> On 1/9/06, Markus Bertheau <[EMAIL PROTECTED]> wrote:
> > ? ???, 09/01/2006 ? 02:33 -0400, Marc G. Fournier ?:
> >
> > > -- Character string locale comparison bug. This may require a REINDEX
> > > on text column indexes in some locales, such as Hungarian.
> >
> > Can
I have a pg_psql stored procedure
getlms(_int4)
from psql
SELECT * fROM get_lms(ARRAY[12,23,34]);
that does not work. How do I pass an array to a function in psql?
Please help. Thanks.
-assad
---(end of broadcast)---
TIP 1: if posting/reading thr
On Mon, Jan 09, 2006 at 05:33:53PM -0700, Assad Jarrahian wrote:
> I have a pg_psql stored procedure
>
> getlms(_int4)
>
> from psql
>
> SELECT * fROM get_lms(ARRAY[12,23,34]);
>
> that does not work. How do I pass an array to a function in psql?
Could you explain what "does not work" means?
On Mon, Jan 09, 2006 at 01:01:33PM -0800, Matthew Peter wrote:
> One other quick question, (figure it still applies to the subject
> line :) when returning a row from a function I'm trying to include an
> aggregate, but it's not showing up in the query result and I think
> it's because it's not
CREATE OR REPLACE FUNCTION getlms(_int4)
RETURNS SETOF tp_locationmessage_object AS
$BODY$
DECLARE
...
SELECT * FROM getLMs();
... so lets say I want to send an array contain 1,23,34 ...
how do I do that .. whats the syntax?
On 1/9/06, Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Mon,
[Please don't use a blank subject. I've added a subject to this
message.]
On Mon, Jan 09, 2006 at 03:26:45PM -0800, Matthew Peter wrote:
> How come when I pass in a list in it doesn't use it as a list of
> integers? Do I need to somehow make $1 be interpreted as a list of
> ints? Rather than ju
On Mon, Jan 09, 2006 at 08:17:17PM -0700, Assad Jarrahian wrote:
> CREATE OR REPLACE FUNCTION getlms(_int4)
> RETURNS SETOF tp_locationmessage_object AS
> $BODY$
> DECLARE
> ...
>
>
> SELECT * FROM getLMs();
>
> ... so lets say I want to send an array contain 1,23,34 ...
>
> how do I do
Terminology point: you used the word "aggregate" but the function below doesn't have an aggregate. Aggregates are functions thatoperate on multiple rows, like count() and sum(); substr() doesn'tdo that so it's not an aggregate. ya. my mistake.[snip] 1. Create a composite type with the
You could write the function to take an array of integers instead of a text string:CREATE OR REPLACE FUNCTION getlist(integer[]) RETURNS SETOF my_tbl as $$SELECT * FROM my_tblWHERE u_id = 0 OR u_id = ANY($1)$$ LANGUAGE SQL STABLE STRICT;SELECT * FROM getlist('{1,2,3}');Another way would be to bu
On Mon, Jan 09, 2006 at 11:39:09AM -0500, Emi Lu wrote:
> I'd like to vacuum all tables under a specific schema. Instead of
> specifying tables one by one under the schema (not one Database), is
> there a simple way to do it?
VACUUM works either on a specific table or on an entire database;
it d
MARCELO_LIMA/[EMAIL PROTECTED] wrote:
> Dear friends,
>
> read txt and insert table (pgsql).
> can i do help anyone ?.
>
You've provided way too little information for anyone to respond
helpfully. What do you mean by your first statement?
(1) Read comma-separated data from a CSV file and load
Hi, I was wondering what is the best database connectivity and programming language to get the best performance with PostgreSQL. I'm currently working with Delphi, but I don't know if that is the best way to go ? Many thanks in advance, Best regards, Nico Callewaert
Yahoo! Photos
R
47 matches
Mail list logo
