On 2/11/2013 6:47 AM, Tom Lane wrote:
Roger Niederland writes:
I am getting the following error when trying to execute a plpgsql funtion:
PSTERROR: could not load library "/usr/pgsql-9.2/lib/plpgsql.so":
/usr/pgsql-9.2/lib/plpgsql.so: undefined symbol: SPI_plan_get_cached_plan
Th
I am getting the following error when trying to execute a plpgsql funtion:
PSTERROR: could not load library "/usr/pgsql-9.2/lib/plpgsql.so":
/usr/pgsql-9.2/lib/plpgsql.so: undefined symbol: SPI_plan_get_cached_plan
This is on a SL6.3 system running postgres 9.2.2
We set this server up about
Hello,
I stripped down the original query to what is below. I am not saying
that the query below
is useful except to show an error I am getting in Postgresql 9.1.1 on
both SL6.1 (64 bit) and
Windows 2008 server 9.1.1 (32-bit and 64-bit). The error I am getting is:
ERROR: variable not found
On 11/1/2011 8:30 PM, Tom Lane wrote:
Roger Niederland writes:
I extracted the tables from the database which generates the error above
I eliminated most of the columns such that this query still exhibits
this behavior to reduce
the file size. I have a zipped file from windows postgresql
On 11/1/2011 3:54 PM, Roger Niederland wrote:
Hello,
I stripped down the original query to what is below. I am not saying
that the query below
is useful except to show an error I am getting in Postgresql 9.1.1 on
both SL6.1 (64 bit) and
Windows 2008 server 9.1.1 (32-bit and 64-bit). The
Hello,
I stripped down the original query to what is below. I am not saying
that the query below
is useful except to show an error I am getting in Postgresql 9.1.1 on
both SL6.1 (64 bit) and
Windows 2008 server 9.1.1 (32-bit and 64-bit). The error I am getting is:
ERROR: variable not found
On my windows install of postgres 9.1.0.
I have a search_path set in the config file. This search path has
several schemas defined.
Some of the databases within postgres, do not have the schema specified
on the search path defined within the database.
Trying to add pgcryto via:
CREATE EXTENS
On 9/23/2011 5:18 PM, Adrian Klaver wrote:
On Friday, September 23, 2011 7:26:19 am Roger Niederland wrote:
On 9/23/2011 6:46 AM, hubert depesz lubaczewski wrote:
On Thu, Sep 22, 2011 at 11:00:10PM -0700, Roger Niederland wrote:
Using pg_dump from the command line with the exe included in
On 9/23/2011 6:46 AM, hubert depesz lubaczewski wrote:
On Thu, Sep 22, 2011 at 11:00:10PM -0700, Roger Niederland wrote:
Using pg_dump from the command line with the exe included in windows
32 bit install in postgresql 9.1.
pg_dump -U username -f somefile.sql.gz -Z 9 -i dbname
please note
Using pg_dump from the command line with the exe included in windows 32
bit install in postgresql 9.1.
pg_dump -U username -f somefile.sql.gz -Z 9 -i dbname
outputs a file that is in plain text. In previous versions of
postgresql, this output a gzipped file.
Also tried: pg_dump -U username
On Jul 9, 2:18 pm, t...@sss.pgh.pa.us (Tom Lane) wrote:
> Niederland writes:
> > SQL 2: select ('A' || '\r\n' || 'B') as tt from customer limit 1
> > Functions without escaping literal
>
> Really? I get
>
> regression=# select (&#x
with Postgres 8.4:
SQL 1: update customer set note = ('A' || '\r\n' || 'B') where 1=0;
generates:
WARNING: nonstandard use of escape in a string literal
LINE 1: update customer set note = ('A' || '\r\n' || 'B') where 1=0;
^
HINT: Use the escape string
Today I postgres on one of our servers shutdown with exit code 128.
Postgresql 8.3.7 on Windows 2003 server.
It started up normally but this is the second occurance this week.
Below is a section of the log. A restart of the service returned
postgres to normal. Suggestions?
Thanks,
Roger
2009-0
I have found in most instances if you leave the services window open
the installer will fail to install (or upgrade) the postgres service.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Yes I checked the file permissions... In fact I logged in as the user
specified in the service and started postgres via the command line
with
postgres -D ../data
and the postgres.conf parameters were loaded as confirmed with a "show
all" in psql
And still running postgresql from the service does n
Here's more information: It appears that the postgresql.conf file is
not being used...
executing a show all; from psql
I see that the parameters are using the default values and not paying
attention to the settings in the postgresql.conf file.
The config_file has a value of c:/program files/Post
On my laptop which I use for development (Windows VISTA), I tried
Postgresql 8.3 RC1. I ran into one problem... It seems that either
the service is not finding the postgresql.conf file or not paying
attention to the search_path within it. This worked in all the
previous 8.2.x, 8.1.x I've used.
I
This seems to be an installer bug for VISTA
If I run postgres via the command prompt with:
postgres -D ../data
then the postgres.conf file is loaded as confirmed with a show all in
psql
If I start postgres via the service which is installed with installer
the postgres.conf file values are not loa
I did an analyize and tried to delete 50 rows from the 1.5M table and
it took over 120 seconds.
Deleting 100 rows took nearly twice as long.
An explain of the delete query showed that indexes were being used.
I found that changing the variable enable_seqscan = off and restarting
the database, del
On Apr 23, 4:25 am, Iain Adams <[EMAIL PROTECTED]> wrote:
> Hi,
>
> This is probably a really easy question but I have been toiling with
> this SQL for ages.
> Okay I have a table with geom_id and id in, this table is called temp.
> I also have another table called junctions with a column, old_id.
Using Postgresql 8.2.3
The following query functions correctly:
select lastname as name from person where lastname ='Smith'
union
select firstname as name from person where firstname = 'John'
order by name;
---
The followi
This is a windows installation postgresql 8.5.1
trying to start postgresql provides the following:
2006-12-03 08:58:11 LOG: database system was shut down at 2006-12-02
11:01:55 Mountain Standard Time
2006-12-03 08:58:11 LOG: checkpoint record is at 13/173572B0
2006-12-03 08:58:11 LOG: redo rec
Sorry working to late at night Query works just a typo
the following works.
WHERE
Lead.CreationDate = (SELECT MIN(LL.CreationDate) FROM Lead AS LL
WHERE LL.ProspectID = Lead.ProspectID)
sorry for the previous post,
Roger
Niederland wrote:
> Before postgresql 8.1.5, I could do
Before postgresql 8.1.5, I could do the following to find the first
lead that created a prospect in my application.
SELECT
Lead.LeadID,
Prospect.ProspectID
FROM
Prospect INNER JOIN Lead USING (ProspectID)
WHERE
Lead.CreationDate = (SELECT MIN(Lead.CreationDate) FROM Lead AS LL
WHERE LL.Pro
I am using postgresql 8.1.4.
Is there anyway to create an index equivalent to:
CREATE INDEX i1 ON t1 USING btree (ts::Date);
So that indexes are used for queries when the field is cast to a date.
---(end of broadcast)---
TIP 4: Have you searched
I am using postgres 8.1.2 on a windows computer.
My postgres.config has:
add_missing_from = off
In the following example, the first update sets value for v1 in table
t1 to 4 for all rows.
Just for my sanity, I checked the null condition in the second update,
and this
does not update any of the row
Yes I removed the comment...
Tail end of postgresql.conf..
#---
# VERSION/PLATFORM COMPATIBILITY
#---
# - Previous Postgres Versions -
# do not all
postgres does not seem to pick up
the following parameter in the postgresql.conf
add_missing_from = false
Setting the parameter via psql, functions properly
SET add_missing_from TO FALSE
Using: winxp, Postges 8.0
(note: I did restart the service after updating the parameters in
postgresql.conf)
That worked thanks. Just can not use the "> DBFile" on windows.
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
I am having the same problem:
System: the released Postgres 8.0, winXP
Install performed an initDB. Tryed all types of backup/restore
combinations, see below:
Using:
pg_dump --format=t --blobs myDB > DBFile
pg_restore --create -dbname=crm DBFile
Resulted in:
pg_restore: [archiver] unsupported ve
More Info:
If I perform a backup of my database with PGAdmin3. I can restore
the database via the command line pg_restore. It seems as if the
backup created with pg_restore when issued from a winXP command prompt
does not create a file that the pg_restore can read... At least for the
file types C
Hello,
I am having problems adding a simple expression to a table level
constraint.
Here is an example of one which postgresql 7.4.3 does not accept.
create table test (a int, b int, c int,
constraint aname check (((a=0) and (b is not null)) or ((a=1) and (c
is not null)));
Should this work? I
32 matches
Mail list logo
