;
I am trying to pass the following values to the function but I have been so
far unsuccessful.
SELECT sp_insert_manifest('me', [EMAIL PROTECTED]', '[EMAIL PROTECTED]',
'test.txt', NULL,
'2006/06/09')
Can anyone help me here?
Thanks,
Rommel the
Hi guys,
Thanks for the input so far. No it wasn't a direct paste, what I did in fact
type was SELECT sp_insert_manifest('me', '[EMAIL PROTECTED]', '[EMAIL
PROTECTED]',
'test.txt', NULL, '2006/06/09'). The error message said something like
function sp_insert_manifest(character varying, character
Hi List,
I've been trying the following query from VB.NET: select * from my_table
order by column1 limit 1. This query works flawlessly when I use the
pgAdminIII query tool, but when I run this query from VB.NET, I get the
following error: syntax error at or near "limit". Any ideas as to the caus
> Could VB be rewriting the query behind your back? Turn on log_statement
logging, and look in the postmaster log to see what's really being sent to
the > backend ...
Exactly!
This was an oversight on my part tho. I had used the following command:
MyDataReader = MyCommand.ExecuteReader(CommandB
Hi guys,
I use the following code to detect alphanumeric strings:
IF _my_variable SIMILAR TO '^[a-zA-Z0-9]+$' THEN
// do stuff here
END IF;
In pg8.4 this worked perfectly. I upgraded to pg9.0 and it no longer
works. From the release notes it appears that the behavior of SIMILAR
TO has ch
Thank you very much. I figured it was something simple but I am not
proficient at regular expressions. Thanks again.
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Saturday, October 16, 2010 10:30 AM
To: Rommel the iCeMAn
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL
Hi list,
I wrote a database creation script that begins with commands to drop the
existing database (if it exists) and create it from scratch. These commands
execute fine, the problem is that all subsequent commands are executed on
the default database 'postgres'. What command can I use to set th
Thanks for the swift responses,
I tried the \c command but I got the following error:
ERROR: syntax error at or near "\"
SQL state: 42601
Character: 520
Here's a code snippet ...
--
-- TOC entry 1685 (class 1262 OID 16453)
-- Name: test_db; Type: DATABASE; Schema: -; Owner: postgres
--
DROP D
I seem to be blundering a lot today! I thought I was replying to the entire
list, didn't realize I replied to one person :-)
Nothing was wrong with my script, I assumed that since it was generated by
pgAdmin that I could run it inside pgAdmin. It works perfectly when I run it
using psql. It is ver
B!!!, I was there late last November, it must be far worse now!
I'll be sticking close to the forums from now on :-)
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgres
Hi Steve,
Thanks for the alternative method, I will give that a try as well. It's nice
to know there is more than one road to reach a destination.
Thanks again,
Rommel Edwards
Software Developer,
Barbados, Caribbean.
---(end of broadcast)---
TIP 9
Hi guys,
I'm trying to call a function from my .NET project and I am getting this
error: "Input string was not in a correct format". I have checked to make
sure that I am not mismatching my parameters. Is there a way that I can see
the actual SQL query that is being sent to postgresql? Once I can
Ok guys,
Sorry for the false alarm. I solved the problem. When I define my parameters
in .NET in the order they are listed in pgAdmin, the function call works. If
I use the order that they are listed in Visual Studio's Server Explorer, the
function call fails. It appears Visual Studio's Server exp
Hi Michael & Tom,
First of all, thanks to Michael for your response. I did enable logging of
SQL queries but still I could find no SQL statements in the logs. This led
me to believe it was a client-side error. Then I saw the response from Tom
which confirmed what I was thinking, so my second set o
14 matches
Mail list logo
