i deleted DB and created new DB when i execute my queries i got the
following error.please help me
could not load library "C:/Program Files/PostgreSQL/8.4/lib/pldbgapi.dll":
The specified module could not be found
In one command, why can we update the same tuple for twice?
And the result is not predicated!!
Welcome to psql 8.3.3, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate wit
On mån, 2010-03-15 at 14:13 -0700, Josh Berkus wrote:
> 1. Create a function.
> 2. In one session, start an explicit transaction.
> 3. Do a CREATE OR REPLACE on the same function, but do not commit.
> 4. Open a 2nd session, and an explicit transaction in that session.
> 5. Do a CREATE OR REPLACE on
"terry" <94487...@qq.com> wrote:
> In one command, why can we update the same tuple for twice?
> TEST=# update t1 set a = t2.d from t2 where a=t2.c;
> UPDATE 1
It says it updated it once. Why do you think otherwise?
> And the result is not predicated!!
When you select multiple rows witho
Hi,
I have a problem with pg_dump.
This command is working when I run in command prompt.
pg_dump -i -h 127.0.0.1 -p 5433 -U postgres -F c -b -v -t log_term -t
log_admin_m -t log_admin_s -f C:\Backup_TFGRSLog_2010-03-13131631.dat
infoinfo
After release my asp.net application pg_dump is not able to
"Kevin Grittner" writes:
> "terry" <94487...@qq.com> wrote:
>> In one command, why can we update the same tuple for twice?
>> TEST=# update t1 set a = t2.d from t2 where a=t2.c;
>> UPDATE 1
> It says it updated it once. Why do you think otherwise?
I think maybe the OP meant to type "why *can
On Mon, Mar 15, 2010 at 3:04 PM, Gregg Lind wrote:
> As per http://osdir.com/ml/pgsql-hackers/2010-03/msg00331.html, I would
> certainly find it helpful is count(distinct(myfield)) wasn't a full index
> scan.
We should maybe add this to our Todo file, if it's not there already
(I don't see it on
Robert Haas writes:
> On Mon, Mar 15, 2010 at 3:04 PM, Gregg Lind wrote:
>> As per http://osdir.com/ml/pgsql-hackers/2010-03/msg00331.html, I would
>> certainly find it helpful is count(distinct(myfield)) wasn't a full index
>> scan.
> We should maybe add this to our Todo file, if it's not there
On Tue, Mar 16, 2010 at 10:16:36AM +0530, venu gopal wrote:
>Hi,
>I have a problem with pg_dump.
>This command is working when I run in command prompt.
>pg_dump -i -h 127.0.0.1 -p 5433 -U postgres -F c -b -v -t log_term -t
>log_admin_m -t log_admin_s -f C:\Backup_TFGRSLog_2010-
Howdy folks, I've been testing the reconnoiter code against 9.0:
CREATE OR REPLACE FUNCTION stratcon.choose_window(IN in_start_time timestamp
with time zone, IN in_end_time timestamp with time zone, IN
in_hopeful_nperiods integer, OUT tablename text, OUT period interval, OUT
nperiods integer)
On Mar 16, 2010, at 9:20 PM, Robert Treat wrote:
> The problem is with the variable name window; once I changed it things worked
> fine. Now, Window is supposed to be a reserved word, so I am not necessarily
> expecting it to work any more, but this code works fine in 8.4., so I figured
> I
>
11 matches
Mail list logo