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
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
11 matches
Mail list logo
