You can log to syslog, and use the syslog definitions file (syslog.conf) to
pipe the output to a program that can do whatever you want with it.
Susan
On Tue, May 13, 2014 at 2:29 PM, Alan Nilsson wrote:
> All
>
> Is there a hook that someone could direct me to that I can use to redirect
> logg
First, I would not restrict color to 30 colors, if anything like furniture
or clothing, etc. is involved. Colors are very important to consumers, and
exact colors are important. I would re-think my color selections.
Make sure you have indexes on all the appropriate columns, of course.
Susan
O
help.
Susan
On Thu, Apr 17, 2014 at 10:33 AM, Vincent Veyron <
vincent.vey...@libremen.org> wrote:
> On Thu, 17 Apr 2014 10:02:00 -0700
> Susan Cassidy wrote:
>
> > I moved the code in the function inline into the code, and I still cannot
> > find the newly inserted i
2014 at 8:13 AM, Scott Marlowe wrote:
> So any chance of a self-contained test case so we're not all chasing our
> tails?
>
> On Thu, Apr 17, 2014 at 9:06 AM, Susan Cassidy
> wrote:
> > Except for the fact that I get the new id returned from the first insert,
> >
Except for the fact that I get the new id returned from the first insert,
which means that the insert probably did happen.
Susan
On Wed, Apr 16, 2014 at 11:55 PM, Alban Hertroys wrote:
> On 17 Apr 2014, at 2:49, David G Johnston
> wrote:
>
> > Robert DiFalco wrote
> >> Two common cases I can
I suppose it's possible. I've never seen this behavior before, but I don't
think I've ever used this same scenario before. It is slightly unusual.
Susan
On Wed, Apr 16, 2014 at 11:55 PM, Alban Hertroys wrote:
> On 17 Apr 2014, at 2:49, David G Johnston
> wrote:
>
> > Robert DiFalco wrote
>
On Wed, Apr 16, 2014 at 7:32 PM, Adrian Klaver wrote:
> On 04/16/2014 05:24 PM, Susan Cassidy wrote:
>
>> I marked it volatile, and still the next time I call the function after
>> the first insert, using the previous new id as as input parameter, it
>> still can't &q
No. One gets done automatically when the transaction fails, however. I
can see it in the log.
Susan
On Wed, Apr 16, 2014 at 6:26 PM, Andy Colson wrote:
> On 04/16/2014 07:06 PM, Susan Cassidy wrote:
>
>> Yes, it is the same connection. It is all the same transaction.
No, I am doing:
begin transaction
Loop:
Do some selects, including id on second iteration of the inserted id
Do the insert (function call), which also does a select on an id.
Save the newly inserted id for select on the next iteration. This id will
be selected by the insert function on the next it
It is never committed, because the lookup for the insert fails.
Susan
On Wed, Apr 16, 2014 at 5:39 PM, David G Johnston <
david.g.johns...@gmail.com> wrote:
> Susan Cassidy-3 wrote
> > Nor can any regular SELECTs in the main program find it.
>
> Ever?
>
> If
it be because the insert is done inside a function?
>>
>> Not by itself; but that factor could be interacting with something else to
>> cause the observed behavior. As noted above functions are able to
>> maintain
>> their own "schema" environment so what is
r 16, 2014 at 5:18 PM, Susan Cassidy <
susan.cass...@decisionsciencescorp.com> wrote:
> It isn't marked as one of those as all, so whatever the default is.
>
> That could be it. I'll look up the default.
>
> Thanks,
> Susan
>
>
> On Wed, Apr 16, 20
It isn't marked as one of those as all, so whatever the default is.
That could be it. I'll look up the default.
Thanks,
Susan
On Wed, Apr 16, 2014 at 5:17 PM, Tom Lane wrote:
> Susan Cassidy writes:
> > It is a fairly large and complex Perl program, so no, not really.
It seems to be returning the right id. It should be next for the serial
datatype.
Susan
On Wed, Apr 16, 2014 at 5:13 PM, Bosco Rama wrote:
> On 04/16/14 17:08, Susan Cassidy wrote:
> > The function does a select to see if the id number exists, and it fails.
> > NOT FOUND
The function does a select to see if the id number exists, and it fails.
NOT FOUND causes a RAISE EXCEPTION.
Susan
On Wed, Apr 16, 2014 at 5:05 PM, Susan Cassidy <
susan.cass...@decisionsciencescorp.com> wrote:
> It is a fairly large and complex Perl program, so no, not really.
&g
teven Schlansker wrote:
>
>
> >> On Wed, Apr 16, 2014 at 4:31 PM, Tom Lane wrote:
> >> Susan Cassidy writes:
> >> > Is there any way to let a transaction "see" the inserts that were done
> >> > earlier in the transaction?
> >&g
Yes, it is the same connection. It is all the same transaction.
Susan
On Wed, Apr 16, 2014 at 5:00 PM, John R Pierce wrote:
> On 4/16/2014 4:53 PM, Susan Cassidy wrote:
>
>> Well, it isn't working for me right now. It can't "see" a row that was
>> inser
Well, it isn't working for me right now. It can't "see" a row that was
inserted earlier in the transaction. It is a new primary key, and when I
SELECT it, it isn't found.
Susan
On Wed, Apr 16, 2014 at 4:31 PM, Tom Lane wrote:
> Susan Cassidy writes:
&
Is there any way to let a transaction "see" the inserts that were done
earlier in the transaction? I want to insert a row, then later use it
within the same transaction.
If not, I will have to commit after each insert, and I don't want to do
that until add the rows are added, if I can possibly av
I have a query with several joins, where I am searching for specific data
in certain columns. If I do this:
SELECT distinct on (s.description, st1.description, s.scene_id)
s.description, s.scene_id, to_char(s.time_of_creation, 'MM/DD/YY
HH24:MI:SS'),
position_0_0_0_info, st.scene_thing_i
c/functions-info.html for more
> functions)
> Do the same from your "psql". Compare the output. Are you 110% sure that
> you are connecting to the same database, as the same user, and using the
> same schema?
>
>
>
>
> On Thu, Mar 13, 2014 at 3:44 PM, S
wrote:
> On 03/13/2014 03:23 PM, Susan Cassidy wrote:
>
>> The only one that comes out different is inet_server_addr, via the
>> program, it comes out:
>> ::1
>> whereas via psql it comes out empty.
>>
>> Yes, I am 100% sure I am using the same schema (which
14:25 0:00 ps auxww
103a105
> scassidy 25360 0.0 0.0 103256 856 pts/2S+ 14:25 0:00 grep p
Susan
On Thu, Mar 13, 2014 at 1:55 PM, Rob Sargent wrote:
> On 03/13/2014 02:44 PM, Susan Cassidy wrote:
>
> No, I don't have 2 instances running. I default the port
lez wrote:
> On Thu, 13 Mar 2014 13:28:38 -0700
> Susan Cassidy wrote:
>
> > No, it is connecting to localhost, which is the same system I am
> > running psql on.
> >
> > Susan
> >
> Well, if one query is logged and the other one is not it means that it
No, it is connecting to localhost, which is the same system I am running
psql on.
Susan
On Thu, Mar 13, 2014 at 1:26 PM, Rodrigo Gonzalez wrote:
> On Thu, 13 Mar 2014 13:20:53 -0700
> Susan Cassidy wrote:
>
> > Another odd thing is that it is apparently not logging statement
oddity. The identical test database is working fine. Only this
database is giving me trouble. Naturally the "live" database is causing
problems.
Susan
On Thu, Mar 13, 2014 at 12:25 PM, Tom Lane wrote:
> Susan Cassidy writes:
> > I have a weird issue that I can't figu
# special values:
Could it have something to do with permissions on /var/log/postgresql? It
is writeable by root only. The perl program runs under apache.
Susan
On Thu, Mar 13, 2014 at 12:46 PM, Steve Atkins wrote:
>
> On Mar 13, 2014, at 12:18 PM, Susan Cassidy &l
I have a weird issue that I can't figure out.
If I run the exact same query through psql as through perl DBI, I get
different results. I get far fewer results with DBI than through the psql
command line.
Any ideas why that would be?
The query is:
SELECT st.description, st.scene_thing_instan
3:18 PM, Rob Sargent wrote:
> On 03/07/2014 04:06 PM, Adrian Klaver wrote:
>
>> On 03/07/2014 02:48 PM, Susan Cassidy wrote:
>>
>>> I have another problem with a slightly different trigger. It's very
>>> weird, because it is exactly the same as the firs
I have another problem with a slightly different trigger. It's very weird,
because it is exactly the same as the first trigger, that now works, except
for the table name.
The error is:
ERROR: query string argument of EXECUTE is null
CONTEXT: PL/pgSQL function metric_int_insert_func() line 5 at
I'm having a problem with a trigger function. I've been googling for over
an hour, with no luck with my specific problem.
I get this error:
ERROR: missing FROM-clause entry for table "new"
LINE 1: insert into metric_double_values_201203 values (NEW.metricID...
The documentation says:
CASE search-expression
WHEN expression [, expression [ ... ]] THEN
statements
[ WHEN expression [, expression [ ... ]] THEN
statements
... ]
[ ELSE
statements ]
END CASE;
And it repeats the "END CASE" phrase in other examples.
However, that d
error in
the first place.
Someone said something about
"Yes, except those that are inside the aggregate."
but I don't have an aggregate specified.
Susan
On Fri, Feb 21, 2014 at 10:38 AM, Scott Marlowe wrote:
> On Fri, Feb 21, 2014 at 10:40 AM, Susan Cassidy
> wrote:
&g
I have a large query:
SELECT distinct on (srs.scan_run_id) srs.scan_run_id,
srs.run_request_number, srs.container_id, srs.manifest_id,
srs.scan_system_name_id,
srs.scan_site_name_id, srs.scan_site_nickname_id,
to_char(srs.start_time, 'MM/DD/YY HH24:MI:SS'),
to_char(srs.stop_time, '
Works great, thanks a bunch.
Susan
On Mon, Feb 3, 2014 at 12:39 PM, Rob Sargent wrote:
> On 02/03/2014 01:01 PM, Susan Cassidy wrote:
>
> description| description
> ---+-
> 18 cm long wrench | Scene 1
> absolute root |
> blue s
e 1
blue screwdriver | Scene 1
red toolbox | Scene 1
small wrench | Scene 1
tire | Scene 2
(9 rows)
On Mon, Feb 3, 2014 at 12:22 PM, Adrian Klaver wrote:
> On 02/03/2014 12:01 PM, Susan Cassidy wrote:
>
> CCing the list.
>
> This didn't sort the way I wa
| Scene 2
On Mon, Feb 3, 2014 at 11:14 AM, Adrian Klaver wrote:
> On 02/03/2014 10:53 AM, Susan Cassidy wrote:
>
>> I have a column that contains items like
>> 'absolute root'
>> 'root 3'
>> 'root 4'
>> 'root 5
I have a column that contains items like
'absolute root'
'root 3'
'root 4'
'root 5'
'scene 1'
'scene 2'
'scene 3'
and I would like them to sort in that order.
I tried:
select sti.description, sc.description from scene_thing_instances sti join
scenes sc on sti.scene_id = sc.scene_id
order by CAS
It turns out IT screwed something up when they installed 9.2. The actual
server/client running is still pointing to 8.4.
Thanks, guys.
Susan
On Mon, Jan 27, 2014 at 4:48 PM, Tom Lane wrote:
> Susan Cassidy writes:
> > This is 9.2
>
> I'd bet a very good dinner that it
This is 9.2
On Mon, Jan 27, 2014 at 4:16 PM, Tom Lane wrote:
> Adrian Klaver writes:
> > On 01/27/2014 01:45 PM, Susan Cassidy wrote:
> >> I tried:
> >> GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO testuser;
> >> and I get:
> >> ER
I tried:
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO testuser;
and I get:
ERROR: syntax error at or near "ALL"
LINE 1: GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO te...
also the same thing for tables, with the same results.
Am I misinterpreting the syntax for this?
I tried:
setsebool -P httpd_can_network_connect 1
But I get:
Cannot set persistent booleans without managed policy.
Could not change policy booleans
I don't know what that means.
Susan
On Fri, Jan 24, 2014 at 9:38 AM, Adrian Klaver wrote:
> On 01/24/2014 09:35 AM, Susan Cassi
rights to execute the perl code?
>
> Try disabling SELinux..
> You'll get it..
>
> On Fri, 2014-01-24 at 09:35 -0800, Susan Cassidy wrote:
> > I've already checked that. It is enabled. I am running Scientific
> > Linux.
> >
> >
> >
> &g
:28 AM, Tom Lane > <mailto:t...@sss.pgh.pa.us>> wrote:
>>
>> Susan Cassidy > <mailto:susan.cass...@decisionsciencescorp.com>> writes:
>> > $dbh =
>> DBI->connect("dbi:Pg:dbname=$dbname;host=${dbserver};port=$dbport;&q
I've already checked that. It is enabled. I am running Scientific Linux.
On Fri, Jan 24, 2014 at 8:28 AM, Tom Lane wrote:
> Susan Cassidy writes:
> > $dbh =
> DBI->connect("dbi:Pg:dbname=$dbname;host=${dbserver};port=$dbport;",
> > $dbuser, $dbpasswd) or
2014 at 3:08 PM, Adrian Klaver wrote:
> On 01/23/2014 02:55 PM, Susan Cassidy wrote:
>
>> I'm having a problem connecting to postgres via a CGI program. I can
>> connect just fine using the same connect string in a non-cgi perl
>> program as in the perl cgi program. The er
I'm having a problem connecting to postgres via a CGI program. I can
connect just fine using the same connect string in a non-cgi perl program
as in the perl cgi program. The error I get is this:
ERROR: Unable to connect to dbname testdb2, err: could not connect to
server: Permission denied
Is t
pgpool-II may do what you want. Lots of people use it.
On Wed, Jan 22, 2014 at 1:35 PM, Dmitry Koterov wrote:
> Hello.
>
> I googled 1 hour approximately, but have not found a ready solution for
> this. So maybe this feature is in PostgreSQL todo-list, or something
> similar exists somewhere...
Sorry, answered wrong posting.
On Thu, Jan 23, 2014 at 6:31 AM, Andreas Lubensky wrote:
> Hello,
> When implementing a database backend with libpq I realized that it seems
> to be impossible to declare a cursor on a prepared statement. Is this
> correct? What is the reason for this limitation?
>
pgpool-II may do what you want.
On Thu, Jan 23, 2014 at 6:31 AM, Andreas Lubensky wrote:
> Hello,
> When implementing a database backend with libpq I realized that it seems
> to be impossible to declare a cursor on a prepared statement. Is this
> correct? What is the reason for this limitation?
rrors
went away.
Susan
On Tue, Jan 21, 2014 at 3:05 PM, Adrian Klaver wrote:
> On 01/21/2014 02:51 PM, Susan Cassidy wrote:
>
>> When I tried to do CREATE EXTENSION IF NOT EXISTS
>> /usr/pgsql-9.2/share/extension/plpgsql.control with schema public;
>>
>> it ga
When I tried to do CREATE EXTENSION IF NOT EXISTS
/usr/pgsql-9.2/share/extension/plpgsql.control with schema public;
it gave me
ERROR: syntax error at or near "EXTENSION"
CREATE LANGUAGE worked just fine. I only tried CREATE EXTENSION because
the manual said that CREATE LANGUAGE was deprecated.
What are the "dot" lines for? They don't seem to work on my Linux
installation. I tried adding them to the initial line, and I see no .pdf
output. I just see:
Producing testdb.dia from /usr/share/postgresql_autodoc/dia.tmpl
Producing testdb.dot from /usr/share/postgresql_autodoc/dot.tmpl
Produ
It doesn't appear that DBVisualizer does an ER type diagram, which is what
I really need.
Thanks,
Susan
On Thu, Jan 16, 2014 at 1:09 PM, Bartosz Dmytrak wrote:
> Hi,
>
> try DBVisualizer
>
>
>
> --
>
> Regards,
>
> Bartek
>
Is there any free or cheap software that will read in DDL and output a
graphic display of it? Preferably showing links for foreign keys.
I know about Erwin, but it is too expensive.
Thanks,
Susan
The initdb command said I could use that command, but pg_ctl works fine
now. I should have tried that before. I have always used pg_ctl in the
past, don't know why I just went with the postgres command.
Thanks,
Susan
On Tue, Jan 7, 2014 at 11:50 AM, Shaun Thomas wrote:
> > When I start postgr
When I start postgres using postgres -D $PGDATA, it hangs, and I see that
postgres and all the other attendant processes are running, but I never get
my prompt back.
If I hit ctl/C, postgres ends running.
I can't seem to figure out why.
This is postgres 9.2.
What am I doing wrong?
Thanks,
Susa
I ran an initdb, but got a message that the Encoding I specified was
invalid, so I tried to run it again, and now I get:
initdb: directory "/var/lib/pgsql/data" exists but is not empty
If you want to create a new database system, either remove or empty
the directory "/var/lib/pgsql/data" or run in
I see you have the length included.
Perhaps, UTF8 characters in one and ascii in the other?
Susan
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Susan Cassidy
Sent: Wednesday, October 17, 2012 8:27 AM
To: John Beynon
Are you sure that one of those entries doesn't have a trailing space?
Susan
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of John Beynon
Sent: Wednesday, October 17, 2012 3:48 AM
To: pgsql-general@postgresql.org
Subject:
See my reply below:
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Ralph Dell
Sent: Monday, February 06, 2012 8:26 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] windows 2008 scheduled task problem
I am running postgresql 8.4.3/ postgis
You can do something like:
DECLARE
p ALIAS FOR $1;
in the function, if you want.
Susan
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Martín Marqués
Sent: Wednesday, September 21, 2011 6:09 AM
To: Thomas Kellerer
C
-Original Message-
> From: Tom Lane [mailto:t...@sss.pgh.pa.us]
> Sent: Tuesday, September 06, 2011 9:57 AM
> To: Susan Cassidy
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Backend process that won't die
> Susan Cassidy writes:
>> I have
I have a couple of backend processes that are "stuck", and do not respond to a
pg_cancel_backend. This is PostgreSQL 8.3.5. The pg_cancel_backend returns
true, but the process keeps running. I have also done a "kill 12345" from the
command-line, with no effect.
The processes are running a "s
Use the Encode module to test/convert back and forth between UTF8 characters
and bytes for the SQL ASCII database. Assuming the input is already UTF-8:
use Encode qw(:all);
# connect to db, prepare insert statement, etc.
my $bytes = encode('utf8', $utf8_text);
$sth->execute($bytes, $i) or er
There seems to be no reason it should be looking for an integer, if your table
definition as shown is correct. You don't have any integers listed.
Also, why does it think that the column id is 96799?
Stupid question, but are you logged into the right database? Maybe a different
db has a diffe
The default quote character is ", so I believe it is expecting quotes to be
around text fields. That is the norm for CSV files.
Susan
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Bryan Nelson
Sent: Friday, July 15,
>From: pgsql-general-ow...@postgresql.org
>[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Jonathan Brinkman
>Sent: Tuesday, July 05, 2011 7:48 AM
>To: pgsql-general@postgresql.org
>Cc: 'Brent Wood'
>Subject: Re: [GENERAL] Read MS-SQL data into Postgres via ODBC link?
>
>Thanks
>I'm impor
Wouldn't it be easy enough to write a little program to suck in the column
names from the information schema, and output the CREATE VIEW statement,
excluding all the columns you want to exclude?
Then, if the tables have changed, just run the program, let it fetch the
information from the inform
sequence nextval as default, unless the sequence has been told
what value to start with, it will start at 1.
Per the documentation:
SELECT setval('users_id_seq', 42); -- Next nextval (insert) will return 43
Susan Cassidy
--
Sent via pgsql-general mailing list (pgsql-general@po
Don't forget to use setval to set the current value of the sequence to the
highest number used in the data already, so that the next insertion uses a new,
unused value.
Susan Cassidy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscri
OK, I must be doing something wrong. I'm trying to create a user with only
limited access to certain tables. The db is large, complicated, and has tons
of users with some complex interactions of permission using groups, etc. I
don't dare revoke any exist permissions, for fear of messing up a
Personally, I vastly prefer written information to video. I can read far
faster than someone can read/explain something to me. Plus, it is easier to
refer back to.
Susan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.po
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Gauthier, Dave
> Sent: Friday, February 18, 2011 1:24 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] constraining chars for all cols of a table
> Hi:
> I have to constrain the chars
Per the error message, you need to enclose array values in braces. For
example, something like:
INSERT into "Bladetypes" ("ID", "type"), values ('1', '{"Knife"}');
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Bernha
>Ray,
>
>Thank you for responding. OK, that was my first trip into DSN setup
>and I got lost:
>The first step is to choose and existing MS driver for an Office app
>or 'Add' one from this 'User DSN' tab. The other tabs are:
>System dSN, File DSN, Drivers, Tracing, and Connection Pooling.
>I did n
Use a CASE statement?
something like:
select case WHEN os ~* E'^windows' then 'windows'
WHEN os ~* E'server' then 'server'
WHEN os ~* E'nix$' then '*nix'
else 'other' end
as osval, count(*) from os_tbl group by osval order by osval;
The hard part is making sure your regexes cover al
I have a number of Perl programs of similar form to this:
$dbh=DBI->connect("dbi:Pg:dbname=$dbname;host=${dbserver};", $dbuser, $dbpasswd,
{PrintError => 0, PrintWarn => 0, AutoCommit => $autocommit}) or
errexit( "Unable to connect to dbname $dbname, err: $DBI::errstr");
errexit("No d
Can't you check it using something like this:
IF OLD.modified = NEW.modified THEN
NEW.modified = NOW();
END IF;
RETURN NEW;
Susan
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Johan Andersson
Sent: Wednesday, July 0
I have a database I inherited with a number of triggers defined on various
tables.
One AFTER trigger, when executed, causes a database log entry with a "CONTEXT"
entry, but no ERROR. I normally only see the CONTEXT entries when an ERROR
occurs.
The trigger is on table rbs, and it returns NULL
Hi,
I was trying to update certain columns in a table, but the update never took
place, but did not throw an exception. I investigated the code in the 'before
update' trigger, and put in some RAISE NOTICE statements. I could then see
that another update of the same table was happening, too, b
81 matches
Mail list logo
